常用金蝶表单查询

BillType

ID	FName	FTypeID	FTemplateID	FDataSql	FTableName
1	外购入库	1	58	SELECT * FROM vwStockBills WHERE FTranType=1	ICStockBill
2	产品入库	2	55	SELECT * FROM vwStockBills WHERE FTranType=2	ICStockBill
5	委外加工入库	5	56	SELECT * FROM vwStockBills WHERE FTranType=5	ICStockBill
7	其他入库	10	57	SELECT * FROM vwStockBills WHERE FTranType=10	ICStockBill
8	销售出库	21	76	SELECT * FROM vwStockBills WHERE FTranType=21	ICStockBill
11	生产领料	24	77	SELECT * FROM vwStockBills WHERE FTranType=24	ICStockBill
15	委外加工发出	28	69	SELECT * FROM vwStockBills WHERE FTranType=28	ICStockBill
16	其他出库	29	68	SELECT * FROM vwStockBills WHERE FTranType=29	ICStockBill
17	盘盈入库	40	50	SELECT * FROM vwStockBills WHERE FTranType=40	ICStockBill
18	仓库调拨	41	75	SELECT * FROM vwStockBills WHERE FTranType=41	ICStockBill
19	盘亏毁损	43	51	SELECT * FROM vwStockBills WHERE FTranType=43	ICStockBill
24	计划价调价	65	74	SELECT * FROM vwAdjPlanBills