常用金蝶表单查询

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	ICStockBill
25	采购申请	70	80	SELECT * FROM vwPOReqBills	PORequest
26	采购订单	71	81	SELECT * FROM vwPOOrderBills	POOrder
27	采购收货	72	82	SELECT * FROM vwPOINStockBills	POInStock
28	采购退货	73	83	SELECT * FROM vwPOOutStockBills	POInStock
29	购货发票(专用)	75	84	SELECT * FROM vwPOInvoiceBills WHERE FTranType=75	ICPurchase
30	购货发票(普通)	76	84	SELECT * FROM vwPOInvoiceBills WHERE FTranType=76	ICPurchase
31	销售发票(专用)	80	62	SELECT * FROM vwSaleInvoiceBills WHERE FTranType=80	ICSale
32	销售订单	81	61	SELECT * FROM vwSaleOrderBills	SEOrder
33	销售退货	82	63	SELECT * FROM vwSaleInStockBills	SEOutStock
34	销售发货	83	64	SELECT * FROM vwSaleOutStockBills	SEOutStock
35	销售报价单	84	60	SELECT * FROM vwSaleQtPriceBills	PORFQ
36	生产订单	85	90	SELECT * FROM vwICMOBills	ICMO
37	销售发票(普通)	86	62	SELECT * FROM vwSaleInvoiceBills WHERE FTranType=86	ICSale
38	凭证	90	42	SELECT * FROM vwVoucherBills	t_Voucher
39	入库业务	101	70	SELECT * FROM vwStockBills WHERE FTranType<20	ICStockBill
40	出库业务	102	71	SELECT * FROM vwStockBills WHERE FTranType>=20 AND FTranType<40	ICStockBill
41	仓库业务	108	70	SELECT * FROM vwStockBills	ICStockBill
42	购货发票	110	84	SELECT * FROM vwPOInvoiceBills	ICPurchase
43	销售发票	118	62	SELECT * FROM vwSaleInvoiceBills	ICSale
45	物料成本计算单	120	40	SELECT * FROM vwPurchaseCostBills	ICStockBill
46	暂估入库	122	41	SELECT * FROM vwStockZGBills	ICStockBill
47	外购退/入库单	128	70	SELECT * FROM vwHookStockPOBills	ICStockBill
48	销售出/入库单	129	71	SELECT * FROM vwHookStockSEBills	ICStockBill
50	原库存业务单	136	70	SELECT * FROM vwStockBills WHERE (FTranType<>41 AND FTranType<>50)	ICStockBill
52	主生产计划预测输入	903	903
53	主生产计划维护	904	904
54	采购计划查询	905	905
55	生产计划查询	906	906
56	主生产计划详细查询	907	907
57	主生产计划查询	908	908
58	可签约量查询	909	909
59	物料需求计划查询	910	910
60	购货发票	188	88	SELECT * FROM vwPOInvoiceBills	ICPurchase
61	合并需求分析	911	911
62	需求来源明细查询	912	912	SELECT * FROM vwPlansDmdSrc
63	供应来源明细查询	913	913	SELECT * FROM vwPlansForeInvSrc;SELECT * FROM vwPlansCommitBillSrc
64	委外加工入库(核算)	264	264	SELECT * FROM vwStockHS1Bills WHERE FSRCTranType=5	ICStockBill
66	其他入库(核算)	266	264	SELECT * FROM vwStockHS1Bills WHERE FSRCTranType=10	ICStockBill
68	出库业务	800	800	SS
69	盘盈入库	40	703	SELECT * FROM vwStockBills WHERE FTranType=40	ICStockBill
70	盘亏毁损	43	704	SELECT * FROM vwStockBills WHERE FTranType=43	ICStockBill
71	产品入库	2	701	SELECT * FROM vwStockBills WHERE FTranType=2	ICStockBill
75	委外加工入库	5	701	SELECT * FROM vwStockBills WHERE FTranType=5	ICStockBill
78	其他入库	10	701	SELECT * FROM vwStockBills WHERE FTranType=10	ICStockBill
80	外购入库	1	701	SELECT * FROM vwStockBills WHERE FTranType=1	ICStockBill
81	委外加工发出	28	702	SELECT * FROM vwStockBills WHERE FTranType=28	ICStockBill
82	销售出库	21	702	SELECT * FROM vwStockBills WHERE FTranType=21	ICStockBill
85	生产领料	24	702	SELECT * FROM vwStockBills WHERE FTranType=24	ICStockBill
87	其他出库	29	702	SELECT * FROM vwStockBills WHERE FTranType=29	ICStockBill
94	计划价调价	65	74	SELECT * FROM vwAdjPlanBills	ICStockBill
95	购货发票	110	88	SELECT * FROM vwPOInvoiceBills	ICPurchase
96	销售发票	118	62	SELECT * FROM vwSaleInvoiceBills	ICSale
97	不能确定单价单据	999	999	SELECT * FROM vwErrStockBills	ICStockBill