新增文章

文章标题分类内容

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

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

create view dbo.a_ICTemplate
   as
   select  
       a1.FROB
      ,a1.FID
      ,a2.FName  FBillName
      
      ,a1.FFieldName
      ,a1.FCaption
      
      ,REPLACE(REPLACE(a1.FCaption,' ',''),':','')  FCaption2
      
      ,a1.FOptionExt
      ,a1.FCtlIndex,a1.FTabIndex
      
      ,'【'+ a1.FID +',v1.'+ a1.FFieldName +' '+ a1.FCaption +'】' FFullName
      
      ,a1.FRelationID,a1.FAction,a1.FFilter
      ,a1.FLeft,a1.FTop,a1.FWidth,a1.FHeight
       
      ,a1.FVisForBillType,a1.FIsVisibleForList,a1.FEnable,a1.FMustInput,a1.FSysMustInputItem,a1.FNeedSave,0 FNeedCount
      ,a1.FAllowCopy,a1.IsSupportImport
      ,a1.FPrint,a1.FInEntryForSPrint
      
      ,a1.FCtlType,a1.FLookUpType,a1.FLookUpCls
      ,a1.FValueType,a1.FSaveValue,a1.FMaxValue,a1.FMinValue,a1.FDefaultValue,a1.FFormat
      
      
      ,a1.FFontName,a1.FFontSize,a1.FSelBill,a1.FLockA,a1.FVBACtlType,a1.FRelateOutTbl
      ,a1.FRMustInput,a1.FCanEditedAllTime
      ,a1.FCaption_CHT,a1.FCaption_EN
      ,a1.FDescription,a1.FDescription_CHT,a1.FDescription_EN
      ,a1.FDefaultCtl
      ,a1.FItemClassID,a1.FUserDefineClassID
      
      ,a2.FHeadTable  FTableName
      ,  'v1'         FTableAlias
      ,  '单据'       FPage
      ,   1           FSort
      
   from      ICTemplate         a1
   left join ICTransactionType  a2 on a1.FID = a2.FTemplateID and a2.FAllowDefined = 1

/*
------------------------------------------------------------------------------------------------------------------------------------------------------------------------

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

select * from  ICTemplate         where FID = 'A01'
   select * from  ICTransactionType  ORDER BY FTemplateID 
   
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
*/
go