常用金蝶表单查询

BillType IDFNameFTypeIDFTemplateIDFDataSqlFTableName1外购入库158SELECT * FROM vwStockBills WHERE FTranType=1ICStockBill2产品入库255SELECT * FROM vwStockBills WHERE FTranType=2ICStockBill5委外加工入库556SELECT * FROM vwStockBills WHERE FTranType=5ICStockBill7其他入库1057SELECT * FROM vwStockBills WHERE FTranType=10ICStockBill8销售出库2176SELECT * FROM vwStockBills WHERE FTranType=21ICStockBill11生产领料2477SELECT * FROM vwStockBills WHERE FTranType=24ICStockBill15委外加工发出2869SELECT * FROM vwStockBills WHERE FTranType=28ICStockBill16其他出库2968SELECT * FROM vwStockBills WHERE FTranType=29ICStockBill17盘盈入库4050SELECT * FROM vwStockBills WHERE FTranType=40ICStockBill18仓库调拨4175SELECT * FROM vwStockBills WHERE FTranType=41ICStockBill19盘亏毁损4351SELECT * FROM vwStockBills WHERE FTranType=43ICStockBill24计划价调价6574SELECT * FROM vwAdjPlanBillsICStockBill25采购申请7080SELECT * FROM vwPOReqBillsPORequest26采购订单7181SELECT * FROM vwPOOrderBillsPOOrder27采购收货7282SELECT * FROM vwPOINStockBillsPOInStock28采购退货7383SELECT * FROM vwPOOutStockBillsPOInStock29购货发票(专用)7584SELECT * FROM vwPOInvoiceBills WHERE FTranType=75ICPurchase30购货发票(普通)7684SELECT * FROM vwPOInvoiceBills WHERE FTranType=76ICPurchase31销售发票(专用)8062SELECT * FROM vwSaleInvoiceBills WHERE FTranType=80ICSale32销售订单8161SELECT * FROM vwSaleOrderBillsSEOrder33销售退货8263SELECT * FROM vwSaleInStockBillsSEOutStock34销售发货8364SELECT * FROM vwSaleOutStockBillsSEOutStock35销售报价单8460SELECT * FROM vwSaleQtPriceBillsPORFQ36生产订单8590SELECT * FROM vwICMOBillsICMO37销售发票(普通)8662SELECT * FROM vwSaleInvoiceBills WHERE FTranType=86ICSale38凭证9042SELECT * FROM vwVoucherBillst_Voucher39入库业务10170SELECT * FROM vwStockBills WHERE FTranType<20ICStockBill40出库业务10271SELECT * FROM vwStockBills WHERE FTranType>=20 AND FTranType<40ICStockBill41仓库业务10870SELECT * FROM vwStockBillsICStockBill42购货发票11084SELECT * FROM vwPOInvoiceBillsICPurchase43销售发票11862SELECT * FROM vwSaleInvoiceBillsICSale45物料成本计算单12040SELECT * FROM vwPurchaseCostBillsICStockBill46暂估入库12241SELECT * FROM vwStockZGBillsICStockBill47外购退/入库单12870SELECT * FROM vwHookStockPOBillsICStockBill48销售出/入库单12971SELECT * FROM vwHookStockSEBillsICStockBill50原库存业务单13670SELECT * FROM vwStockBills WHERE (FTranType<>41 AND FTranType<>50)ICStockBill52主生产计划预测输入903903

53主生产计划维护904904

54采购计划查询905905

55生产计划查询906906

56主生产计划详细查询907907

57主生产计划查询908908

58可签约量查询909909

59物料需求计划查询910910

60购货发票18888SELECT * FROM vwPOInvoiceBillsICPurchase61合并需求分析911911

62需求来源明细查询912912SELECT * FROM vwPlansDmdSrc
63供应来源明细查询913913SELECT * FROM vwPlansForeInvSrc;SELECT * FROM vwPlansCommitBillSrc
64委外加工入库(核算)264264SELECT * FROM vwStockHS1Bills WHERE FSRCTranType=5ICStockBill66其他入库(核算)266264SELECT * FROM vwStockHS1Bills WHERE FSRCTranType=10ICStockBill68出库业务800800SS
69盘盈入库40703SELECT * FROM vwStockBills WHERE FTranType=40ICStockBill70盘亏毁损43704SELECT * FROM vwStockBills WHERE FTranType=43ICStockBill71产品入库2701SELECT * FROM vwStockBills WHERE FTranType=2ICStockBill75委外加工入库5701SELECT * FROM vwStockBills WHERE FTranType=5ICStockBill78其他入库10701SELECT * FROM vwStockBills WHERE FTranType=10ICStockBill80外购入库1701SELECT * FROM vwStockBills WHERE FTranType=1ICStockBill81委外加工发出28702SELECT * FROM vwStockBills WHERE FTranType=28ICStockBill82销售出库21702SELECT * FROM vwStockBills WHERE FTranType=21ICStockBill85生产领料24702SELECT * FROM vwStockBills WHERE FTranType=24ICStockBill87其他出库29702SELECT * FROM vwStockBills WHERE FTranType=29ICStockBill94计划价调价6574SELECT * FROM vwAdjPlanBillsICStockBill95购货发票11088SELECT * FROM vwPOInvoiceBillsICPurchase96销售发票11862SELECT * FROM vwSaleInvoiceBillsICSale97不能确定单价单据999999SELECT * FROM vwErrStockBillsICStockBill