金蝶全系列SQL數(shù)據(jù)字典

1、返回總覽采購管理(工業(yè))系統(tǒng)數(shù)據(jù)表序序號號表表名名表表描描述述1 ICPurchase購貨發(fā)票表2 ICPurchaseEntry購貨發(fā)票分錄表3 POInStock收料通知表4 POInStockEntry收料通知單分錄表5 POOrder采購訂單表6 POOrderEntry采購訂單分錄表7 PORequest采購申請表8 PORequestEntry采購申請單分錄表9 t_Supply供應(yīng)商供貨表10 t_SupplyEntry供應(yīng)商供貨明細表11 ICBatchNoRule物料批號管理12 ICItemMapping物料對應(yīng)表13 vwICBill_25采購申請單（視圖）14 vwIC

2、Bill_26采購訂單（視圖）15 vwICBill_27收料通知單（視圖）16 vwICBill_28退料通知單（視圖）17 vwICBill_42購貨發(fā)票（視圖）18 vwICBill_21費用發(fā)票（視圖）19 ICExpensesEntry費用發(fā)票分錄表20 ICExpenses費用發(fā)票表21 vwICBill_81檢驗單(視圖)22 vwICBill_702采購檢驗申請單(視圖)23 vwICBill_80質(zhì)檢方案(視圖)返回采購管理(工業(yè))系統(tǒng)目錄表結(jié)構(gòu)字字段段名名類類型型描描述述FAcctIDINTEGER貸方科目FArApStatusINTEGER狀態(tài)FCompactIDINTE

3、GER合同內(nèi)碼FCurCheckLevelINTEGERFMultiCheckLevel1INTEGER一審FMultiCheckLevel3INTEGER三審FMultiCheckLevel4INTEGER四審FBillerNameSTRING開票人FCheckerIDINTEGER審核人FOrderIDINTEGER訂單IDFOrgBillInterIDINTEGER源單內(nèi)碼FMultiCheckLevel6INTEGER六審FOrderInterIDINTEGER定單內(nèi)碼FPeriodINTEGER日期FPosterIDINTEGER記賬人FNoteSTRING備注FCompactNoS

4、TRING合同號FCurrencyIDINTEGER幣別FDateDATETIME單據(jù)日期FResourceIDINTEGER資源內(nèi)部IDFROBINTEGER紅藍字FRSCBillInterIDINTEGER原單內(nèi)碼FDeptIDINTEGER部門FHookInterIDINTEGER鉤稽單據(jù)內(nèi)碼FRelationBillNoSTRING關(guān)聯(lián)單據(jù)號碼FBrNoSTRING公司機構(gòu)內(nèi)碼FRelationTranTypeINTEGER關(guān)聯(lián)單據(jù)類型FContractIDINTEGER合同內(nèi)碼FRSCBillNoSTRINGFSupplyIDINTEGER供應(yīng)商內(nèi)碼FManagerIDINTEGER

5、FTranTypeINTEGER單據(jù)類型FVchInterIDINTEGER憑證內(nèi)碼FMultiCheckDate1DATETIME一級審核日期FMultiCheckDate2DATETIME二級審核日期FYearINTEGER年份FMultiCheckDate3DATETIME三級審核日期FMultiCheckDate4DATETIME四級審核日期FMultiCheckDate5DATETIME五級審核日期FMultiCheckDate6DATETIME六級審核日期FMultiCheckLevel2INTEGER二審FMultiCheckLevel5INTEGER五審FBillerIDINT

6、EGER制單人FPOStyleINTEGER采購方式FVoucherIDINTEGER憑證內(nèi)碼FYtdIntRateFLOAT年利率(%)FYearPeriodSTRING鉤稽期間FBillNoSTRING購貨發(fā)票號FCancellationINTEGER作廢FStatusINTEGER狀態(tài)FEmpIDINTEGER業(yè)務(wù)員FExchangeRateFLOAT匯率FInterIDINTEGER購貨發(fā)票內(nèi)碼FTotalCostFLOAT總成本額（本位幣）FTotalCostForFLOAT總成本額原幣FSubSystemIDINTEGER子系統(tǒng)內(nèi)碼FHookerIDINTEGER鉤稽人FInvSt

7、yleINTEGER業(yè)務(wù)類型FOffsetTaxForFLOAT抵扣費用(原幣)FPostedINTEGER是否過賬FClosedINTEGER是否關(guān)閉FFincDateDATETIME財務(wù)日期FFreeItem1STRING應(yīng)收應(yīng)付發(fā)票自由項FFreeItem2STRING應(yīng)收應(yīng)付發(fā)票自由項FInStockInterIDINTEGER收料通知單FTaskIDINTEGER任務(wù)IDFBudgetAmountForFLOAT預(yù)算金額FClassTypeIDINTEGER新單據(jù)類型IDFCOMINVIDINTEGER商業(yè)發(fā)票內(nèi)碼FRelationInterIDINTEGER關(guān)聯(lián)單據(jù)內(nèi)碼FTotal

8、ExpenseFLOAT采購費用FOffsetTaxFLOAT抵扣費用FTotalExpenseForFLOAT采購費用(原幣)fitemclassidINTEGER核算項目內(nèi)碼FWWInStockInterIDINTEGER委外加工入庫單內(nèi)碼FOrderAmountForFLOAT訂單金額FOuterIDINTEGER外部單據(jù)內(nèi)碼鍵表鍵鍵名名類類型型PK_ICPurchase主鍵索引表索索引引名名字字段段PK_ICPurchaseFBrNoIX_ICPurchase_FBillNoFInterIDIX_ICPurchase_FDateFBillNoIX_ICPurchase_FHookInt

9、erIDFTranTypeIX_ICPurchase_FInterIDFDateIX_ICPurchase_FVchInterIDFVoucherID觸發(fā)器表觸觸發(fā)發(fā)器器名名描描述述返回采購管理(工業(yè))系統(tǒng)目錄表結(jié)構(gòu)字字段段名名類類型型描描述述FAddCostFLOAT附加費本幣FAddCostForFLOAT附加費原幣fauxqty_baseFLOAT輔助基本數(shù)量FBatchNoSTRING批次FDetailIDINTEGERFDiscountRateFLOAT折扣率FFreeItem1STRING應(yīng)收應(yīng)付發(fā)票自由項FFreeItem2STRING應(yīng)收應(yīng)付發(fā)票自由項FNoteSTRING備注

10、FStdAmountFLOAT金額（本位幣）FStdTaxAmountFLOAT稅額（本位幣）FUnitIDINTEGER單位內(nèi)碼FAuxPriceFLOAT輔助單價FAuxQtyFLOAT輔助數(shù)量FPriceFLOAT單價FAmountFLOAT金額FAmountExFLOATFAmountincludetaxFLOAT金額FAmountMustFLOAT應(yīng)計費用FAuxCommitQtyFLOAT輔助提交數(shù)量FAuxOrderPriceFLOAT輔助訂單單價FAuxTaxPriceFLOAT含稅價二FBrNoSTRING公司內(nèi)碼FClassID_SRCINTEGER關(guān)聯(lián)源單類型FCOMIN

11、VIDINTEGER商業(yè)發(fā)票內(nèi)碼FCommitQtyFLOAT提交數(shù)量FDeductTaxFLOAT運費稅金FEntryIDINTEGER分錄號FEntryID_SRCINTEGER關(guān)聯(lián)源單分錄IDFInterIDINTEGER購貨發(fā)票內(nèi)碼FItemIDINTEGER物料內(nèi)碼FMapNameSTRING對應(yīng)名稱FMapNumberSTRING對應(yīng)代碼FOrderPriceFLOAT訂單單價FOrgBillEntryIDINTEGERFQtyFLOAT數(shù)量FSourceEntryIDINTEGER原分錄號FStdAmountincludetaxFLOAT金額（本位幣）FTaxFLOATFTaxA

12、mountFLOAT稅額FTaxPriceFLOAT含稅價FTaxRateFLOAT稅率鍵表鍵鍵名名類類型型PK_ICPurchaseEntry主鍵索引表索索引引名名字字段段PK_ICPurchaseEntryFBrNoIX_ICPurchaseEntry_FDetailIDFInterIDIX_ICPurchaseEntry_FInterIDFEntryIDIX_ICPurchaseEntry_FItemIDFDetailID觸發(fā)器表觸觸發(fā)發(fā)器器名名描描述述返回采購管理(工業(yè))系統(tǒng)目錄表結(jié)構(gòu)字字段段名名類類型型描描述述FCnnInterIDINTEGER關(guān)聯(lián)單據(jù)內(nèi)碼FCurrencyIDIN

13、TEGER幣別FDateDATETIME 單據(jù)日期FDeptIDINTEGER部門FBClosedINTEGERFBillerIDINTEGER制單人FTranTypeINTEGER單據(jù)類型FUpStockWhenSaveINTEGER更新庫存FBillNoSTRING通知單號FBrNoSTRING公司機構(gòu)內(nèi)碼FCancellationINTEGER作廢FCheckDateDATETIMEFCheckerIDINTEGER審核人FClosedINTEGERFCnnBillNoSTRINGFSManagerIDINTEGER主管人FCreateDateDATETIMEFCurCheckLevel

14、INTEGERFStatusINTEGER狀態(tài)FStockIDINTEGER收料庫房FSupplyIDINTEGER供應(yīng)商內(nèi)碼FEmpIDINTEGER業(yè)務(wù)員FExchangeRateFLOAT匯率FFManagerIDINTEGER主管FInterIDINTEGER通知單內(nèi)碼FInvoiceClosedINTEGERFMultiCheckDate1DATETIME 一級審核日期FMultiCheckDate2DATETIME 二級審核日期FMultiCheckDate3DATETIME 三級審核日期FMultiCheckDate4DATETIME 四級審核日期FMultiCheckDate5

15、DATETIME 五級審核日期FMultiCheckDate6DATETIME 六級審核日期FMultiCheckLevel1INTEGER一審FMultiCheckLevel2INTEGER二審FMultiCheckLevel3INTEGER三審FMultiCheckLevel4INTEGER四審FMultiCheckLevel5INTEGER五審FMultiCheckLevel6INTEGER六審FNoteSTRING備注FPosterIDINTEGER記賬人FPOStyleINTEGER采購方式FPurchaseInterIDINTEGER采購訂單內(nèi)碼FQCRBillInterIDINT

16、EGER采購檢驗申請單內(nèi)碼FRelateBrIDINTEGER供貨機構(gòu)FRelationBillNoSTRING關(guān)聯(lián)單據(jù)號FRelationInterIDINTEGER關(guān)聯(lián)單據(jù)內(nèi)碼FRelationTranTypeINTEGER關(guān)聯(lián)單據(jù)類型鍵表鍵鍵名名類類型型PK_POInStock_1_10主鍵索引表索索引引名名字字段段PK_POInStock_1_10FBrNoIX_POInStock_FInterIDFInterID觸發(fā)器表觸觸發(fā)發(fā)器器名名描描述述返回采購管理(工業(yè))系統(tǒng)目錄表結(jié)構(gòu)字字段段名名類類型型描描述述FAmountFLOAT金額FAuxBCommitQtyFLOAT輔助實退數(shù)量F

17、AuxCommitQtyFLOAT輔助實收數(shù)量FAuxPriceFLOAT輔助單價FBrNoSTRING公司機構(gòu)類碼FMapNameSTRING對應(yīng)名稱FEntryIDINTEGER分錄號FQtyFLOAT通知數(shù)量FSourceEntryIDINTEGER原分錄號FUnitIDINTEGER單位內(nèi)碼FAuxQCheckQtyFLOAT檢驗合格數(shù)量（常用）FBatchNoSTRING批次FDCSPIDINTEGER收料倉位FKFDateDATETIME 生產(chǎn)/采購日期FKFPeriodINTEGER保質(zhì)期FAuxQtyFLOAT輔助通知數(shù)量FBCommitQtyFLOAT實退數(shù)量FCommitQ

18、tyFLOAT實收數(shù)量FAuxInvoiceQtyFLOAT輔助發(fā)票數(shù)量FAuxQtyPassFLOAT輔助合格數(shù)量FInterIDINTEGER通知單內(nèi)碼FInvoiceQtyFLOAT發(fā)票數(shù)量FItemIDINTEGER物料內(nèi)碼FMapNumberSTRING對應(yīng)代碼FNoteSTRING備注FPriceFLOAT單價FQCheckQtyFLOAT檢驗合格數(shù)量FQtyPassFLOAT合格數(shù)量鍵表鍵鍵名名類類型型索引表索索引引名名字字段段IX_POInStockEntry_FInterIDFBrNo觸發(fā)器表觸觸發(fā)發(fā)器器名名描描述述返回采購管理(工業(yè))系統(tǒng)目錄表結(jié)構(gòu)字字段段名名類類型型描描述

19、述FBillerIDINTEGER制單人FMangerIDINTEGER主管FBillNoSTRING采購訂單號FCurrencyIDINTEGER幣別FDeptIDINTEGER部門FInterIDINTEGER采購訂單內(nèi)碼FStatusINTEGER狀態(tài)FBrNoSTRING公司機構(gòu)內(nèi)碼FCancellationINTEGER作廢FCheckerIDINTEGER審核人FClosedINTEGERFCompactNoSTRING合同號FContractIDINTEGER合同內(nèi)碼FCurCheckLevelINTEGERFDateDATETIME單據(jù)日期FEmpIDINTEGER業(yè)務(wù)員FEx

20、changeRateFLOAT匯率FMrpClosedINTEGER業(yè)務(wù)關(guān)閉狀態(tài)FMultiCheckDate1DATETIME一級審核日期FMultiCheckDate2DATETIME二級審核日期FMultiCheckDate3DATETIME三級審核日期FMultiCheckDate4DATETIME四級審核日期FMultiCheckDate5DATETIME五級審核日期FMultiCheckDate6DATETIME六級審核日期FMultiCheckLevel1INTEGER一審FMultiCheckLevel2INTEGER二審FMultiCheckLevel3INTEGER三審FM

21、ultiCheckLevel4INTEGER四審FMultiCheckLevel5INTEGER五審FMultiCheckLevel6INTEGER六審FOrderAffirmINTEGERFPOStyleINTEGER采購方式FRelateBrIDINTEGER供貨機構(gòu)FRelationBillNoSTRING關(guān)聯(lián)單據(jù)號碼FRelationInterIDINTEGER關(guān)聯(lián)單據(jù)內(nèi)碼FRelationTranTypeINTEGER關(guān)聯(lián)單據(jù)類型FRequestInterIDINTEGER申請單內(nèi)碼FSupplyIDINTEGER供應(yīng)商內(nèi)碼FTranStatusINTEGER傳輸狀態(tài)FTranTyp

22、eINTEGER單據(jù)類型鍵表鍵鍵名名類類型型PK_POOrder主鍵索引表索索引引名名字字段段PK_POOrderFBrNoIX_POOrder_FInterIDFTranType觸發(fā)器表觸觸發(fā)發(fā)器器名名描描述述返回采購管理(工業(yè))系統(tǒng)目錄表結(jié)構(gòu)字字段段名名類類型型描描述述FBrNoSTRING公司機構(gòu)類碼FCessFLOAT稅率FMapNameSTRING對應(yīng)名稱FMapNumberSTRING對應(yīng)代碼FAmountFLOAT金額FAuxCommitQtyFLOAT輔助到貨數(shù)量FAuxQtyFLOAT輔助訂貨數(shù)量FAuxPriceFLOAT輔助單價FAuxStockQtyFLOAT輔助入庫數(shù)

23、量FCommitQtyFLOAT到貨數(shù)量FDateDATETIME 交貨日期FEntryIDINTEGER分錄號FInterIDINTEGER采購訂單內(nèi)碼FItemIDINTEGER物料內(nèi)碼FNoteSTRING備注FPriceFLOAT單價FQtyFLOAT訂貨數(shù)量FSourceEntryIDINTEGER原分錄號FStockQtyFLOAT入庫數(shù)量FTaxAmountFLOAT稅額FTaxRateFLOAT稅率FUnitIDINTEGER單位內(nèi)碼鍵表鍵鍵名名類類型型PK_POOrderEntry_1_18主鍵索引表索索引引名名字字段段PK_POOrderEntry_1_18FBrNoIX_

24、POOrderEntry_FInterIDFInterID觸發(fā)器表觸觸發(fā)發(fā)器器名名描描述述返回采購管理(工業(yè))系統(tǒng)目錄表結(jié)構(gòu)字字段段名名類類型型描描述述FBillerIDINTEGER制單人FCheckerIDINTEGER審核人FCheckTimeDATETIME 審批日期FClosedINTEGER是否關(guān)閉FDeptIDINTEGER使用部門FSCBillInterIDINTEGER原單分錄號FMultiCheckDate1DATETIMEFBillNoSTRING申請單號FBrNoSTRING公司機構(gòu)內(nèi)碼FCancellationINTEGER作廢FCurCheckLevelINTEGE

25、RFDateDATETIME 單據(jù)日期FInterIDINTEGER申請單內(nèi)碼FMRPINTEGERMRP類型FMrpClosedINTEGER業(yè)務(wù)關(guān)閉狀態(tài)FMultiCheckDate2DATETIMEFMultiCheckDate3DATETIMEFMultiCheckDate4DATETIMEFMultiCheckDate5DATETIMEFMultiCheckDate6DATETIMEFMultiCheckLevel1INTEGER一審FMultiCheckLevel2INTEGER二審FMultiCheckLevel3INTEGER三審FMultiCheckLevel4INTEGER

26、四審FMultiCheckLevel5INTEGER五審FMultiCheckLevel6INTEGER六審FNoteSTRING備注FOrderInterIDINTEGER訂單內(nèi)碼FPlanOrderInterIDINTEGER計劃訂單號FRequesterIDINTEGER申請人FStatusINTEGER狀態(tài)FTranTypeINTEGER單據(jù)類型鍵表鍵鍵名名類類型型PK_POre主鍵索引表索索引引名名字字段段PK_POreFBrNoIX_PORequest_FInterIDFInterID觸發(fā)器表觸觸發(fā)發(fā)器器名名描描述述返回采購管理(工業(yè))系統(tǒng)目錄表結(jié)構(gòu)字字段段名名類類型型描描述述FA

27、PurchTimeDATETIME 建議采購日期FBrNoSTRING公司機構(gòu)類碼FEntryIDINTEGER分錄號FInterIDINTEGER申請單內(nèi)碼FAuxCommitQtyFLOAT輔助審批數(shù)量FAuxPriceFLOAT輔助單價FAuxQtyFLOAT輔助申請數(shù)量FCommitQtyFLOAT審批數(shù)量FFetchTimeDATETIME 到貨日期FItemIDINTEGER物料內(nèi)碼FPlanOrderInterIDINTEGER計劃訂單號FPriceFLOAT單價FQtyFLOAT申請數(shù)量FSourceEntryIDINTEGER原分錄號FSupplyIDINTEGER供應(yīng)商內(nèi)碼

28、FUnitIDINTEGER單位內(nèi)碼FUseSTRING用途鍵表鍵鍵名名類類型型PK_PORequest主鍵索引表索索引引名名字字段段PK_PORequestFBrNoIX_PORequestEntry_FInterIDFInterID觸發(fā)器表觸觸發(fā)發(fā)器器名名描描述述返回采購管理(工業(yè))系統(tǒng)目錄表結(jié)構(gòu)字字段段名名類類型型描描述述FBrNoSTRING公司機構(gòu)內(nèi)碼FCurrencyIDINTEGER 幣別FItemIDINTEGER 物料內(nèi)碼FPOHighPriceFLOAT采購最高限價FSupIDINTEGER 供應(yīng)商內(nèi)碼FPTypeINTEGER 單價類型鍵表鍵鍵名名類類型型PK_t_Sup

29、ply主鍵索引表索索引引名名字字段段PK_t_SupplyFBrNo觸發(fā)器表觸觸發(fā)發(fā)器器名名描描述述返回采購管理(工業(yè))系統(tǒng)目錄表結(jié)構(gòu)字字段段名名類類型型描描述述FDisableDateDATETIME 失效日期FDiscountFLOAT折扣率FItemIDINTEGER物料內(nèi)碼FQuoteTimeDATETIME 生效日期FUsedINTEGERFBrNoSTRING公司機構(gòu)類碼FCyIDINTEGER幣別FEndQtyFLOAT訂貨終止數(shù)量FEntryIDINTEGER分錄號FLeadTimeINTEGER訂貨提前期FPriceFLOAT單價FPTypeINTEGER單價類型FRemar

30、kSTRING備注FStartQtyFLOAT訂貨起始數(shù)量FSupIDINTEGER供應(yīng)商內(nèi)碼FUnitIDINTEGER單位內(nèi)碼鍵表鍵鍵名名類類型型PK_t_SupplyEntry主鍵索引表索索引引名名字字段段PK_t_SupplyEntryFBrNo觸發(fā)器表觸觸發(fā)發(fā)器器名名描描述述返回采購管理(工業(yè))系統(tǒng)目錄表結(jié)構(gòu)字字段段名名類類型型描描述述FUseShortNumberINTEGER 是否使用短代碼FCharacterSTRING補位符FDetailINTEGER 是否明細物料FFormatDateSTRING格式FPropertyIDINTEGER 批號屬性值FSelDefineSTR

31、ING自定義批號FSubCharacterSTRING替換符FIDINTEGER 級次FItemIDINTEGER 物料內(nèi)碼FWidthINTEGER 寬度鍵表鍵鍵名名類類型型PK_ICBatchNoRule主鍵索引表索索引引名名字字段段PK_ICBatchNoRuleFID觸發(fā)器表觸觸發(fā)發(fā)器器名名描描述述返回采購管理(工業(yè))系統(tǒng)目錄表結(jié)構(gòu)字字段段名名類類型型描描述述FCompanyIDINTEGER 往來單位內(nèi)碼FIDINTEGER 基礎(chǔ)資料類別FMapNumberSTRING基礎(chǔ)資料映射代碼FItemIDINTEGER 基礎(chǔ)資料內(nèi)碼FMapNameSTRING基礎(chǔ)資料映射名稱FProper

32、tyIDINTEGER 往來單位類別鍵表鍵鍵名名類類型型PK_ICItemMapping主鍵索引表索索引引名名字字段段PK_ICItemMappingFID觸發(fā)器表觸觸發(fā)發(fā)器器名名描描述述返回采購管理(工業(yè))系統(tǒng)目錄表結(jié)構(gòu)字字段段名名類類型型描描述述FAPurchTimeDATETIME 建議采購日期FBillNoSTRING編號FCheckerIDSTRING審核人FCheckFlagSTRING審核標志FCheckTimeDATETIME 審批日期FCUUnitIDSTRING常用單位FdateDATETIME 日期FauxqtyFLOAT數(shù)量FBillerIDSTRING制單FCance

33、llationSTRING作廢標志FClosedSTRING關(guān)閉標志FcuQtyFLOAT常用單位應(yīng)收數(shù)量FDeptIDSTRING使用部門FEntryIDINTEGER單據(jù)分錄號FFetchTimeDATETIME 到貨日期FInterIDINTEGER單據(jù)內(nèi)碼FItemIDSTRING物料名稱FLeadTimeFLOAT提前期FmodelSTRING規(guī)格型號FMRPSTRING單據(jù)來源FMRPClosedSTRINGMRP關(guān)閉標志FNoteSTRING備注FNumberSTRING物料長代碼FOrderInterIDSTRING銷售訂單號FPlanOrderNoSTRING計劃訂單號FPP

34、OrderInterIDSTRING生產(chǎn)預(yù)測單號FQtyFLOAT基本單位數(shù)量FRelationSTRING關(guān)聯(lián)標志FRequesterIDSTRING申請人FShortNumberSTRING物料代碼FSupplyIDSTRING供應(yīng)商名稱FUnitGroupIDSTRING基本單位FUnitIDSTRING單位FUseSTRING用途鍵表鍵鍵名名類類型型索引表索索引引名名字字段段觸發(fā)器表觸觸發(fā)發(fā)器器名名描描述述返回采購管理(工業(yè))系統(tǒng)目錄表結(jié)構(gòu)字字段段名名類類型型描描述述FBillNoSTRING編號FcuQtyFLOAT常用單位數(shù)量FInterIDINTEGER單據(jù)內(nèi)碼FMRPClose

35、dSTRINGMRP關(guān)閉標志FNoteSTRING備注FAmountFLOAT金額FAuxQtyFLOAT數(shù)量FBillerIDSTRING制單FCheckerIDSTRING審核人FCommitdateDATETIME 交貨日期FMangerIDSTRING主管FUnitIDSTRING單位FCurrencyIDSTRING幣別FCUUnitIDSTRING常用單位FDeptIDSTRING部門FauxpriceFLOAT單價FCancellationSTRING作廢標志FEmpIDSTRING業(yè)務(wù)員FEntryIDINTEGER單據(jù)分錄號FMapNumberSTRING對應(yīng)代碼FPOSty

36、leSTRING采購方式FRequestInterIDSTRING采購申請單號FTaxRateFLOAT折扣率FCessFLOAT稅率(%)FItemIDSTRING物料名稱FMapNameSTRING對應(yīng)名稱FNumberSTRING物料長代碼FRelateBrIDSTRING供貨機構(gòu)FShortNumberSTRING物料代碼FAuxCommitQtyFLOAT關(guān)聯(lián)數(shù)量FCompactNoSTRING合同號FmodelSTRING規(guī)格型號FRelationSTRING關(guān)聯(lián)標志FStatus=3STRING關(guān)閉標志FSupplyIDSTRING供應(yīng)商FAuxStockQtyFLOAT入庫數(shù)量

37、FUnitGroupIDSTRING基本單位FCheckFlagSTRING審核標志FCommitQtyFLOAT基本單位關(guān)聯(lián)數(shù)量FdateDATETIME 日期FExchangeRateFLOAT匯率FQtyFLOAT基本單位數(shù)量FStockQtyFLOAT基本單位入庫數(shù)量鍵表鍵鍵名名類類型型索引表索索引引名名字字段段觸發(fā)器表觸觸發(fā)發(fā)器器名名描描述述返回采購管理(工業(yè))系統(tǒng)目錄表結(jié)構(gòu)字字段段名名類類型型描描述述FCurrencyIDSTRING幣別FDeptIDSTRING部門FKFPeriodINTEGER保質(zhì)期（天）FNoteSTRING備注FamountFLOAT金額FAuxQtyPa

38、ssFLOAT合格數(shù)量FExchangeRateFLOAT匯率FQtyFLOAT基本單位數(shù)量FQtyPassFLOAT基本單位合格數(shù)量FUnitGroupIDSTRING基本單位FauxpriceFLOAT單價FCnnInterIDSTRING采購訂單號FCUQtyPassFLOAT常用單位數(shù)量FCUUnitIDSTRING常用單位FDCSPIDSTRING倉位FPOStyleSTRING采購方式FBillNoSTRING單據(jù)編號FUnitIDSTRING單位FClosedSTRING關(guān)閉標志FEntryIDINTEGER單據(jù)分錄號FInterIDINTEGER單據(jù)內(nèi)碼FMapNameSTRI

39、NG對應(yīng)名稱FauxqtyFLOAT數(shù)量FCheckerIDSTRING審核人FCheckFlagSTRING審核標志FBillerIDSTRING制單FdateDATETIME 日期FEmpIDSTRING業(yè)務(wù)員FFManagerIDSTRING主管FItemIDSTRING物料名稱FKFDateDATETIME 生產(chǎn)/采購日期FMapNumberSTRING對應(yīng)代碼FmodelSTRING規(guī)格型號FNumberSTRING物料長代碼FPurchaseInterIDSTRING購貨發(fā)票號FRelateBrIDSTRING供貨機構(gòu)FRelationSTRING關(guān)聯(lián)標志FShortNumberS

40、TRING物料代碼FStockIDSTRING收料倉庫FSupplyIDSTRING供應(yīng)商FCancellationSTRING作廢標志FCUQtyFLOAT常用單位數(shù)量鍵表鍵鍵名名類類型型索引表索索引引名名字字段段觸發(fā)器表觸觸發(fā)發(fā)器器名名描描述述返回采購管理(工業(yè))系統(tǒng)目錄表結(jié)構(gòu)字字段段名名類類型型描描述述FBillNoSTRING編號FCurrencyIDSTRING幣別FKFPeriodINTEGER保質(zhì)期（天）FRemarkSTRING備注FamountFLOAT金額FauxpriceFLOAT單價FauxqtyFLOAT數(shù)量FBillerIDSTRING制單FCancellation

41、STRING作廢標志FCheckerIDSTRING審核人FCheckFlagSTRING審核標志FClosedSTRING關(guān)閉標志FCnnInterIDSTRING原收料通知單號FcuQtyFLOAT常用單位數(shù)量FCUUnitIDSTRING常用單位FdateDATETIME 日期FDCSPIDSTRING倉位FDeptIDSTRING部門FEmpIDSTRING業(yè)務(wù)員FEntryIDINTEGER單據(jù)分錄號FExchangeRateFLOAT匯率FFManagerIDSTRING主管FInterIDINTEGER單據(jù)內(nèi)碼FItemIDSTRING物料名稱FKFDateDATETIME 生產(chǎn)

42、/采購日期FMapNameSTRING對應(yīng)名稱FMapNumberSTRING對應(yīng)代碼FmodelSTRING規(guī)格型號FnoteSTRING退料原因FNumberSTRING物料長代碼FPOStyleSTRING采購方式FQCRBillInterIDSTRING質(zhì)檢單單號FQtyFLOAT基本單位數(shù)量FRelateBrIDSTRING供貨機構(gòu)FRelationSTRING關(guān)聯(lián)標志FShortNumberSTRING物料代碼FStockIDSTRING退料倉庫FSupplyIDSTRING供貨單位FUnitGroupIDSTRING基本單位FUnitIDSTRING單位鍵表鍵鍵名名類類型型索引表

43、索索引引名名字字段段觸發(fā)器表觸觸發(fā)發(fā)器器名名描描述述返回采購管理(工業(yè))系統(tǒng)目錄表結(jié)構(gòu)字字段段名名類類型型描描述述FaddressSTRING地址電話FAuxOrderPriceFLOAT訂單單價FBillerIDSTRING制單人FCancellationSTRING作廢標志FcuQtyFLOAT常用單位數(shù)量FShortNumberSTRING物料代碼FamountFLOAT金額FTax_AmountFLOAT運費金額(本位幣)FTaxAmountFLOAT稅額FTaxNumSTRING納稅登記號FTaxRateFLOAT稅率FUnitIDSTRING單位FVchInterIDSTRING憑

44、證字號FWWInStockInterIDSTRING委外加工入庫單號FYearPeriodSTRING鉤稽期間FYtdIntRateFLOAT年利率(%)FAmountMustFLOAT應(yīng)記費用（本位幣）FStdamountFLOAT金額（本位幣）FauxpriceFLOAT單價FauxqtyFLOAT數(shù)量FBankSTRING開戶銀行及賬號FStdTaxAmountFLOAT稅額（本位幣）FBillerNameSTRING開票人FBillNoSTRING發(fā)票號碼FSupplyIDSTRING供貨單位FCheckerIDSTRING審核人FCheckFlagSTRING審核標志FCompact

45、NoSTRING合同號FSupplyIDtSTRING基本單位FCurrencyIDSTRING幣別FCUUnitIDSTRING常用單位FdateDATETIME 日期FDeductTaxFLOAT運費稅金（本位幣）FDeptIDSTRING部門FEmpIDSTRING業(yè)務(wù)員FEntryIDINTEGER單據(jù)分錄號FExchangeRateFLOAT匯率FFullNameSTRING貸方科目FHookerIDSTRING鉤稽人FHookFlagSTRING鉤稽標志FInStockInterIDSTRING采購入庫單號FInterIDINTEGER單據(jù)內(nèi)碼FInvStyleSTRING業(yè)務(wù)類型

46、FItemIDSTRING物料名稱FMapNameSTRING對應(yīng)名稱FMapNumberSTRING對應(yīng)代碼FmodelSTRING規(guī)格型號FNoteSTRING備注FNumberSTRING物料長代碼FOrderInterIDSTRING采購訂單號FOrgBillInterIDSTRING拆單標志FPOStyleSTRING采購方式FQtyFLOAT基本單位數(shù)量FRelationSTRING關(guān)聯(lián)標志FRSCBillInterIDSTRING原發(fā)票號鍵表鍵鍵名名類類型型索引表索索引引名名字字段段觸發(fā)器表觸觸發(fā)發(fā)器器名名描描述述返回采購管理(工業(yè))系統(tǒng)目錄表結(jié)構(gòu)字字段段名名類類型型描描述述FA

47、ddressSTRING地址FBillNoSTRING發(fā)票號碼FCurrencyIDSTRING幣別FDeptIDSTRING部門FBankSTRING開戶銀行FBillerIDSTRING制單人FCancellationSTRING作廢標志FEmpIDSTRING業(yè)務(wù)員FEntryIDINTEGER單據(jù)分錄號FExchangeRateFLOAT匯率FInStockInterIDSTRING委外加工入庫單號FInterIDINTEGER單據(jù)內(nèi)碼FNumberSTRING費用長代碼FShortNumberSTRING費用代碼FStdTaxAmount)FLOAT不含稅金額（本位幣）FTaxAmo

48、unt)FLOAT不含稅金額FVchInterIDSTRING憑證字號FYearPeriodSTRING鉤稽期間FAmountFLOAT金額FAuxPriceFLOAT單價FAuxQtyFLOAT數(shù)量FCheckerIDSTRING審核人FCheckFlagSTRING審核標志FDateDATETIME 日期FFeeTypeSTRING費用類型FHookerIDSTRING鉤稽人FHookFlagSTRING鉤稽標志FInvoiceInterIDSTRING采購發(fā)票號FItemIDSTRING費用名稱FNoteSTRING備注FPosterIDSTRING記賬人FPOStyleSTRING采購

49、方式FRelationSTRING關(guān)聯(lián)標志FRSCBillInterIDSTRING原費用發(fā)票號FStdamountFLOAT金額（本位幣）FStdTaxAmountFLOAT可抵扣稅額(本位幣)FSupplyIDSTRING供貨單位FTaxAmountFLOAT可抵扣稅額FTaxNumSTRING納稅登記號FTaxRateFLOAT稅率(%)FUnitIDSTRING計量單位FVoucherStatusSTRING記賬標志鍵表鍵鍵名名類類型型索引表索索引引名名字字段段觸發(fā)器表觸觸發(fā)發(fā)器器名名描描述述返回采購管理(工業(yè))系統(tǒng)目錄表結(jié)構(gòu)字字段段名名類類型型描描述述FAuxPriceFLOAT單價

50、FAuxQtyFLOAT數(shù)量FNoteSTRING備注FTaxAmountFLOAT可抵扣稅額FAmountFLOAT金額FAmountExFLOAT不含稅金額FBrNoSTRINGFEntryIDINTEGER 分錄號FInterIDINTEGER 單據(jù)內(nèi)碼FItemIDINTEGER 費用內(nèi)碼FSourceEntryIDINTEGER 源單分錄號FStdAmountFLOAT金額（本位幣）FStdTaxAmountFLOAT稅額（本位幣）FTaxRateFLOAT稅率FUnitIDSTRING計量單位鍵表鍵鍵名名類類型型PK_ICExpensesEntry主鍵索引表索索引引名名字字段段PK

51、_ICExpensesEntryFBrNo觸發(fā)器表觸觸發(fā)發(fā)器器名名描描述述返回采購管理(工業(yè))系統(tǒng)目錄表結(jié)構(gòu)字字段段名名類類型型描描述述FAcctIDINTEGER會計科目FCustIDINTEGER購貨單位FHookerIDINTEGER鉤稽人FSaleStyleINTEGER銷售方式FInvTypeINTEGER銷售費用發(fā)票類型FPOStyleINTEGER采購方式FRelationInterIDINTEGER關(guān)聯(lián)單據(jù)內(nèi)碼FRelationTranTypeINTEGER關(guān)聯(lián)單據(jù)類型FCancellationINTEGER作廢標志FCheckDateDATETIME 審核日期FMultiCh

52、eckDate3DATETIME 三級審核日期FMultiCheckDate6DATETIME 六級審核日期FRecBillInterIDINTEGER其他應(yīng)收單據(jù)號FRelationBillNoSTRING關(guān)聯(lián)單據(jù)編號FDateDATETIME 日期FExchangeRateFLOAT匯率FMultiCheckDate1DATETIME 一級審核日期FMultiCheckDate2DATETIME 二級審核日期FMultiCheckDate4DATETIME 四級審核日期FMultiCheckDate5DATETIME 五級審核日期FRSCBillInterIDINTEGER原費用發(fā)票號FS

53、upplyIDINTEGER供貨單位FHookInterIDINTEGER鉤稽單據(jù)內(nèi)碼FInStockInterIDINTEGER委外加工入庫單號FInterIDINTEGERFBillNoSTRING單據(jù)號FBrNoSTRINGFClosedINTEGER關(guān)閉標志FCurCheckLevelINTEGER當(dāng)前審核級次FCurrencyIDINTEGER幣別FStatusINTEGER單據(jù)狀態(tài)FInvoiceInterIDINTEGER采購發(fā)票號FBillerIDINTEGER制單人FCheckerIDINTEGER審核人FDeptIDINTEGER部門FEmpIDINTEGER業(yè)務(wù)員FTra

54、nTypeINTEGER單據(jù)類型FMultiCheckLevel1INTEGER一審FMultiCheckLevel2INTEGER二審FMultiCheckLevel3INTEGER三審FMultiCheckLevel4INTEGER四審FMultiCheckLevel5INTEGER五審FMultiCheckLevel6INTEGER六審FPayBillInterIDINTEGER其他應(yīng)付單號FPosterIDINTEGER記賬FVchInterIDINTEGER憑證內(nèi)碼FYearPeriodSTRING鉤稽期間FROBINTEGER紅藍標志鍵表鍵鍵名名類類型型PK_ICExpenses主鍵索引表索索引引名名字字段段PK_ICExpensesFBrNo觸發(fā)器表觸觸發(fā)發(fā)器器名名描描述述返回采購管理(工業(yè))系統(tǒng)目錄表結(jié)構(gòu)字字段段名名類類型型描描述述FBillNoSTRING編號FSerialINTEG