新增文章

文章标题分类内容

------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--【视图】 删除

if exists ( select * from sys.views where object_id = OBJECT_ID(N'dbo.a_ICTemplateEntry') )
               drop     view                                         dbo.a_ICTemplateEntry
    go
   
   
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--【视图】a_ICTemplateEntry  金蝶老单 表体字段

create view dbo.a_ICTemplateEntry
   as 
   select 
       a1.FID
      ,a2.FName  FBillName
      ,a1.FFieldName
      ,a1.FHeadCaption
      
      ,REPLACE(REPLACE(a1.FHeadCaption,' ',''),':','')  FCaption2
      
      ,a1.FOptionExt
      ,a1.FCtlIndex,a1.FCtlOrder
      
      ,'【'+ a1.FID +',u1.'+ a1.FFieldName +' '+ a1.FHeadCaption +'】' FFullName
      
      ,a1.FRelationID,a1.FAction,a1.FFilter
      ,a1.FWidth,a1.FVisForBillType,a1.FIsVisibleForList
      ,a1.FEnable,a1.FMustInput,a1.FSysMustInputItem,a1.FNeedSave,a1.FNeedCount
      ,a1.FAllowCopy,a1.IsSupportImport,a1.FPrint,a1.FPrintStatus
      
      ,a1.FCtlType,a1.FLookUpType,a1.FLookUpCls
      ,a1.FValueType,a1.FSaveValue,a1.FMaxValue,a1.FMinValue,a1.FDefaultValue,a1.FFormat,a1.FSaveRule
      ,a1.FRelateOutTbl,a1.FCanEditedAllTime
      ,a1.FStatCount
      ,a1.FHeadCaption_CHT,a1.FHeadCaption_EN
      ,a1.FDescription,a1.FDescription_CHT,a1.FDescription_EN
      ,a1.FDefaultCtl
      ,a1.FItemClassID,a1.FUserDefineClassID
      
      ,a2.FEntryTable  FTableName
      ,  'u1'          FTableAlias
      ,  '分录'        FPage
      ,   2            FSort
      
   from      ICTemplateEntry    a1
   left join ICTransactionType  a2 on a1.FID = a2.FTemplateID and a2.FAllowDefined = 1 
   
/*
------------------------------------------------------------------------------------------------------------------------------------------------------------------------

select * from a_ICTemplateEntry  where FID = 'B01'  -- 金蝶老单 表体字段

------------------------------------------------------------------------------------------------------------------------------------------------------------------------

select * from  ICTemplateEntry

------------------------------------------------------------------------------------------------------------------------------------------------------------------------
*/
go