新增文章

文章标题分类内容

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

if exists ( select * from sys.views where object_id = OBJECT_ID(N'dbo.a_ICTransactionType') )
               drop     view                                         dbo.a_ICTransactionType
   go

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--【视图】a_ICTransactionType 金蝶老单 单据类型

create view dbo.a_ICTransactionType
   as 
   select  
   
       FTemplateID
      ,FName
      ,FID
      ,FChatTypeID
      ,FSchemeTypeID
      ,FFormWidth,FFormHeight
      ,FHeadTable,FEntryTable
      
      ,'' A1
      
      ,FType
      ,FVchTemplateID
       
      ,FROB
      ,FObjectType,FObjectID
      ,FBillPOSHeadTable,FBillPOSEntryTable
      ,FCheckPRO,FFixCols
      ,FAllowDefined,FBillFlow
      ,FName_CHT,FName_EN
      ,FBrNo

from ICTransactionType

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

select * from a_ICTransactionType  where FName LIKE '%销售%'  order BY FTemplateID    -- 金蝶老单 单据类型
   
   select * from  ICTransactionType
   
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
*/
go