/* 单据类型 */
SELECT * FROM ICBillNo
/* 界面描述-工业单据 */
SELECT * FROM ICTransactionType WHERE FID = 713
SELECT * FROM ICTemplate WHERE FID = 'B01' ORDER BY FCtlIndex
SELECT * FROM ICTemplateEntry WHERE FID = 'B01' ORDER BY FCtlOrder
/* 界面描述-BOS单据 */
SELECT * FROM ICClassType WHERE FID = 1000000
SELECT * FROM ICClassTypeEntry WHERE FParentID = 1000000
SELECT * FROM ICClassTableInfo WHERE FClassTypeID = 1000000 ORDER BY FTableName,FTabIndex
/* 表结构描述 */
SELECT * FROM t_TableDescription WHERE FTableName = 'ICStockBill'
SELECT * FROM t_FieldDescription WHERE FTableID = 210008
/* 下推关联信息 */
SELECT * FROM ICClassLink WHERE FDestTranTypeID = 2 AND FSourTranTypeID = 713
SELECT * FROM ICListTemplate WHERE FID = 713
SELECT DISTINCT FTableName,FTableAlias FROM ICChatBillTitle WHERE FTypeID = 713 --AND FTableName IN ('ICQCBill','ICQCBillEntry')
/* 基础资料 */
SELECT * FROM t_ItemClass
SELECT * FROM t_Item
SELECT * FROM t_ItemPropDesc
v_ICBillFlow 老单据过滤方案表
select FRemark from v_ICBillFlow where fname='销售订单' and FDestTranTypeID=2(销售定的过滤方案)
select b.FName,a.*
from icstockbill a join ictranst