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 |