新增文章

文章标题分类内容

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

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

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--【视图】 a_ICListTemplate  金蝶老单 序时簿类型

create view dbo.a_ICListTemplate
   as 
   select
   
       FName
      ,FBillTemplateID
      ,FTemplateID
      ,FID
      ,FFilter
      
      ,'' A1
      
      ,FMenuID
      ,FBillCls
      ,FGroupID
      ,FSubSysID
      ,FMasterTable
      ,FSourceType,FSourceSql
      ,FHeadHeight,FBottomHeight
      
      ,FNeedCount
      ,FFontID,FLogicStr,FToolBarVis,FHeadVis,FBottomVis
      ,FType,FGetDataType
      ,FRptTemplateID
      ,FNeedStatistic,FName_CHT,FName_EN
      ,FLinkPrimary
      
   from ICListTemplate     
   
/*
------------------------------------------------------------------------------------------------------------------------------------------------------------------------

select * from a_ICListTemplate     where FName LIKE '%销售%'  order BY FTemplateID,FBillTemplateID,FID   -- 金蝶老单 序时簿类型
   
   select * from   ICListTemplate
   
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
*/
go