select FTemplateID,* from ICTransactionType 
select FCtlIndex,* from ICTemplate where FID = 'Y02' and FFieldName like '%FHeadSelf%'   --20
SELECT FCtlOrder,* from ICTemplateEntry where FID = 'Y02' and FFieldName like '%FEntrySelf%'   --8


select FCtlIndex,* from AIS20211115095921..ICTemplate where FID = 'Y02' and FFieldName like '%FHeadSelf%'   --20
SELECT FCtlOrder,* from AIS20211115095921..ICTemplateEntry where FID = 'Y02' and FFieldName like '%FEntrySelf%'   --8




select 111,* from ICTemplate where FID = 'Y02' 
UNION 
select 222,* from AIS20211115095921..ICTemplate where FID = 'Y02'
ORDER BY FFieldName,1


select 111,* from ICTemplateEntry where FID = 'Y02' 
UNION 
select 222,* from AIS20211115095921..ICTemplateEntry where FID = 'Y02'
ORDER BY FFieldName,1




select 111,* from ICListTemplate where FID = 'Y02' 
select FID,FTemplateID,* from ICListTemplate where fname like '%投料%' 
select FID,FTemplateID,* from AIS20211115095921..ICListTemplate where fname like '%投料%' 


SELECT * FROM dbo.ICSubContract WHERE FBillNo = 'PWW21110059'

 
 SELECT * FROM ICChatBillTitle WHERE FTypeID =  2842
 SELECT * FROM ICChatBillTitle WHERE FTypeID =  -2842
  SELECT T1.* FROM ICChatBillTitle T1 INNER JOIN ICListTemplate T2 ON  T1.FTypeID = T2.FTemplateID WHERE  T1.FIsPrimary >= 1 AND T1.FIsPrimary <= 3  AND T2.FBillTemplateID = 88
 SELECT FTemplateID FROM ICTransactionType WHERE FID = 88
 
 SELECT * FROM AIS20211115095921..ICChatBillTitle WHERE FTypeID =  2842
 SELECT * FROM ICChatBillTitle  a WHERE FTypeID =  2842 AND NOT EXISTS( SELECT 1 FROM AIS20211115095921..ICChatBillTitle  b WHERE a.FColname = b.FColname )
 2296	2842	单位成本$		FEntrySelfY0284	PPBOMEntry	2	1000	1	-1	1	0	0	84	FEntrySelfY0284	u1
 
 SELECT * INTO ICChatBillTitle_bak20211115 FROM ICChatBillTitle  a WHERE FTypeID =  2842 AND a.FColName = 'FEntrySelfY0284'
 DELETE ICChatBillTitle  WHERE FTypeID =  2842 AND FColName = 'FEntrySelfY0284'
 
 SELECT * FROM AIS20211115095921..ICChatBillTitle  a WHERE FTypeID =  2842 AND NOT EXISTS( SELECT 1 FROM ICChatBillTitle  b WHERE a.FColname = b.FColname )



 SELECT * FROM ICChatBillTitle  WHERE FTypeID=2842 --ICChatBillTitle 界面字段列表 ftypeid=2842(委外模块)
 --原因：BOS中增加了投料单表身自定义栏位FEntrySelfY0284，然后又删除，数据残留在ICChatBillTitle了。
 --故障账套：AIS20200424101***
 --正常的备份账套：AIS20211115095921