金蝶全系列SQL数据字典

1、返回总览采购管理(工业)系统数据表序序号号表表名名表表描描述述1 ICPurchase购货发票表2 ICPurchaseEntry购货发票分录表3 POInStock收料通知表4 POInStockEntry收料通知单分录表5 POOrder采购订单表6 POOrderEntry采购订单分录表7 PORequest采购申请表8 PORequestEntry采购申请单分录表9 t_Supply供应商供货表10 t_SupplyEntry供应商供货明细表11 ICBatchNoRule物料批号管理12 ICItemMapping物料对应表13 vwICBill_25采购申请单（视图）14 vwIC

2、Bill_26采购订单（视图）15 vwICBill_27收料通知单（视图）16 vwICBill_28退料通知单（视图）17 vwICBill_42购货发票（视图）18 vwICBill_21费用发票（视图）19 ICExpensesEntry费用发票分录表20 ICExpenses费用发票表21 vwICBill_81检验单(视图)22 vwICBill_702采购检验申请单(视图)23 vwICBill_80质检方案(视图)返回采购管理(工业)系统目录表结构字字段段名名类类型型描描述述FAcctIDINTEGER贷方科目FArApStatusINTEGER状态FCompactIDINTE

3、GER合同内码FCurCheckLevelINTEGERFMultiCheckLevel1INTEGER一审FMultiCheckLevel3INTEGER三审FMultiCheckLevel4INTEGER四审FBillerNameSTRING开票人FCheckerIDINTEGER审核人FOrderIDINTEGER订单IDFOrgBillInterIDINTEGER源单内码FMultiCheckLevel6INTEGER六审FOrderInterIDINTEGER定单内码FPeriodINTEGER日期FPosterIDINTEGER记账人FNoteSTRING备注FCompactNoS

4、TRING合同号FCurrencyIDINTEGER币别FDateDATETIME单据日期FResourceIDINTEGER资源内部IDFROBINTEGER红蓝字FRSCBillInterIDINTEGER原单内码FDeptIDINTEGER部门FHookInterIDINTEGER钩稽单据内码FRelationBillNoSTRING关联单据号码FBrNoSTRING公司机构内码FRelationTranTypeINTEGER关联单据类型FContractIDINTEGER合同内码FRSCBillNoSTRINGFSupplyIDINTEGER供应商内码FManagerIDINTEGER

5、FTranTypeINTEGER单据类型FVchInterIDINTEGER凭证内码FMultiCheckDate1DATETIME一级审核日期FMultiCheckDate2DATETIME二级审核日期FYearINTEGER年份FMultiCheckDate3DATETIME三级审核日期FMultiCheckDate4DATETIME四级审核日期FMultiCheckDate5DATETIME五级审核日期FMultiCheckDate6DATETIME六级审核日期FMultiCheckLevel2INTEGER二审FMultiCheckLevel5INTEGER五审FBillerIDINT

6、EGER制单人FPOStyleINTEGER采购方式FVoucherIDINTEGER凭证内码FYtdIntRateFLOAT年利率(%)FYearPeriodSTRING钩稽期间FBillNoSTRING购货发票号FCancellationINTEGER作废FStatusINTEGER状态FEmpIDINTEGER业务员FExchangeRateFLOAT汇率FInterIDINTEGER购货发票内码FTotalCostFLOAT总成本额（本位币）FTotalCostForFLOAT总成本额原币FSubSystemIDINTEGER子系统内码FHookerIDINTEGER钩稽人FInvSt

7、yleINTEGER业务类型FOffsetTaxForFLOAT抵扣费用(原币)FPostedINTEGER是否过账FClosedINTEGER是否关闭FFincDateDATETIME财务日期FFreeItem1STRING应收应付发票自由项FFreeItem2STRING应收应付发票自由项FInStockInterIDINTEGER收料通知单FTaskIDINTEGER任务IDFBudgetAmountForFLOAT预算金额FClassTypeIDINTEGER新单据类型IDFCOMINVIDINTEGER商业发票内码FRelationInterIDINTEGER关联单据内码FTotal

8、ExpenseFLOAT采购费用FOffsetTaxFLOAT抵扣费用FTotalExpenseForFLOAT采购费用(原币)fitemclassidINTEGER核算项目内码FWWInStockInterIDINTEGER委外加工入库单内码FOrderAmountForFLOAT订单金额FOuterIDINTEGER外部单据内码键表键键名名类类型型PK_ICPurchase主键索引表索索引引名名字字段段PK_ICPurchaseFBrNoIX_ICPurchase_FBillNoFInterIDIX_ICPurchase_FDateFBillNoIX_ICPurchase_FHookInt

9、erIDFTranTypeIX_ICPurchase_FInterIDFDateIX_ICPurchase_FVchInterIDFVoucherID触发器表触触发发器器名名描描述述返回采购管理(工业)系统目录表结构字字段段名名类类型型描描述述FAddCostFLOAT附加费本币FAddCostForFLOAT附加费原币fauxqty_baseFLOAT辅助基本数量FBatchNoSTRING批次FDetailIDINTEGERFDiscountRateFLOAT折扣率FFreeItem1STRING应收应付发票自由项FFreeItem2STRING应收应付发票自由项FNoteSTRING备注

10、FStdAmountFLOAT金额（本位币）FStdTaxAmountFLOAT税额（本位币）FUnitIDINTEGER单位内码FAuxPriceFLOAT辅助单价FAuxQtyFLOAT辅助数量FPriceFLOAT单价FAmountFLOAT金额FAmountExFLOATFAmountincludetaxFLOAT金额FAmountMustFLOAT应计费用FAuxCommitQtyFLOAT辅助提交数量FAuxOrderPriceFLOAT辅助订单单价FAuxTaxPriceFLOAT含税价二FBrNoSTRING公司内码FClassID_SRCINTEGER关联源单类型FCOMIN

11、VIDINTEGER商业发票内码FCommitQtyFLOAT提交数量FDeductTaxFLOAT运费税金FEntryIDINTEGER分录号FEntryID_SRCINTEGER关联源单分录IDFInterIDINTEGER购货发票内码FItemIDINTEGER物料内码FMapNameSTRING对应名称FMapNumberSTRING对应代码FOrderPriceFLOAT订单单价FOrgBillEntryIDINTEGERFQtyFLOAT数量FSourceEntryIDINTEGER原分录号FStdAmountincludetaxFLOAT金额（本位币）FTaxFLOATFTaxA

12、mountFLOAT税额FTaxPriceFLOAT含税价FTaxRateFLOAT税率键表键键名名类类型型PK_ICPurchaseEntry主键索引表索索引引名名字字段段PK_ICPurchaseEntryFBrNoIX_ICPurchaseEntry_FDetailIDFInterIDIX_ICPurchaseEntry_FInterIDFEntryIDIX_ICPurchaseEntry_FItemIDFDetailID触发器表触触发发器器名名描描述述返回采购管理(工业)系统目录表结构字字段段名名类类型型描描述述FCnnInterIDINTEGER关联单据内码FCurrencyIDIN

13、TEGER币别FDateDATETIME 单据日期FDeptIDINTEGER部门FBClosedINTEGERFBillerIDINTEGER制单人FTranTypeINTEGER单据类型FUpStockWhenSaveINTEGER更新库存FBillNoSTRING通知单号FBrNoSTRING公司机构内码FCancellationINTEGER作废FCheckDateDATETIMEFCheckerIDINTEGER审核人FClosedINTEGERFCnnBillNoSTRINGFSManagerIDINTEGER主管人FCreateDateDATETIMEFCurCheckLevel

14、INTEGERFStatusINTEGER状态FStockIDINTEGER收料库房FSupplyIDINTEGER供应商内码FEmpIDINTEGER业务员FExchangeRateFLOAT汇率FFManagerIDINTEGER主管FInterIDINTEGER通知单内码FInvoiceClosedINTEGERFMultiCheckDate1DATETIME 一级审核日期FMultiCheckDate2DATETIME 二级审核日期FMultiCheckDate3DATETIME 三级审核日期FMultiCheckDate4DATETIME 四级审核日期FMultiCheckDate5

15、DATETIME 五级审核日期FMultiCheckDate6DATETIME 六级审核日期FMultiCheckLevel1INTEGER一审FMultiCheckLevel2INTEGER二审FMultiCheckLevel3INTEGER三审FMultiCheckLevel4INTEGER四审FMultiCheckLevel5INTEGER五审FMultiCheckLevel6INTEGER六审FNoteSTRING备注FPosterIDINTEGER记账人FPOStyleINTEGER采购方式FPurchaseInterIDINTEGER采购订单内码FQCRBillInterIDINT

16、EGER采购检验申请单内码FRelateBrIDINTEGER供货机构FRelationBillNoSTRING关联单据号FRelationInterIDINTEGER关联单据内码FRelationTranTypeINTEGER关联单据类型键表键键名名类类型型PK_POInStock_1_10主键索引表索索引引名名字字段段PK_POInStock_1_10FBrNoIX_POInStock_FInterIDFInterID触发器表触触发发器器名名描描述述返回采购管理(工业)系统目录表结构字字段段名名类类型型描描述述FAmountFLOAT金额FAuxBCommitQtyFLOAT辅助实退数量F

17、AuxCommitQtyFLOAT辅助实收数量FAuxPriceFLOAT辅助单价FBrNoSTRING公司机构类码FMapNameSTRING对应名称FEntryIDINTEGER分录号FQtyFLOAT通知数量FSourceEntryIDINTEGER原分录号FUnitIDINTEGER单位内码FAuxQCheckQtyFLOAT检验合格数量（常用）FBatchNoSTRING批次FDCSPIDINTEGER收料仓位FKFDateDATETIME 生产/采购日期FKFPeriodINTEGER保质期FAuxQtyFLOAT辅助通知数量FBCommitQtyFLOAT实退数量FCommitQ

18、tyFLOAT实收数量FAuxInvoiceQtyFLOAT辅助发票数量FAuxQtyPassFLOAT辅助合格数量FInterIDINTEGER通知单内码FInvoiceQtyFLOAT发票数量FItemIDINTEGER物料内码FMapNumberSTRING对应代码FNoteSTRING备注FPriceFLOAT单价FQCheckQtyFLOAT检验合格数量FQtyPassFLOAT合格数量键表键键名名类类型型索引表索索引引名名字字段段IX_POInStockEntry_FInterIDFBrNo触发器表触触发发器器名名描描述述返回采购管理(工业)系统目录表结构字字段段名名类类型型描描述

19、述FBillerIDINTEGER制单人FMangerIDINTEGER主管FBillNoSTRING采购订单号FCurrencyIDINTEGER币别FDeptIDINTEGER部门FInterIDINTEGER采购订单内码FStatusINTEGER状态FBrNoSTRING公司机构内码FCancellationINTEGER作废FCheckerIDINTEGER审核人FClosedINTEGERFCompactNoSTRING合同号FContractIDINTEGER合同内码FCurCheckLevelINTEGERFDateDATETIME单据日期FEmpIDINTEGER业务员FEx

20、changeRateFLOAT汇率FMrpClosedINTEGER业务关闭状态FMultiCheckDate1DATETIME一级审核日期FMultiCheckDate2DATETIME二级审核日期FMultiCheckDate3DATETIME三级审核日期FMultiCheckDate4DATETIME四级审核日期FMultiCheckDate5DATETIME五级审核日期FMultiCheckDate6DATETIME六级审核日期FMultiCheckLevel1INTEGER一审FMultiCheckLevel2INTEGER二审FMultiCheckLevel3INTEGER三审FM

21、ultiCheckLevel4INTEGER四审FMultiCheckLevel5INTEGER五审FMultiCheckLevel6INTEGER六审FOrderAffirmINTEGERFPOStyleINTEGER采购方式FRelateBrIDINTEGER供货机构FRelationBillNoSTRING关联单据号码FRelationInterIDINTEGER关联单据内码FRelationTranTypeINTEGER关联单据类型FRequestInterIDINTEGER申请单内码FSupplyIDINTEGER供应商内码FTranStatusINTEGER传输状态FTranTyp

22、eINTEGER单据类型键表键键名名类类型型PK_POOrder主键索引表索索引引名名字字段段PK_POOrderFBrNoIX_POOrder_FInterIDFTranType触发器表触触发发器器名名描描述述返回采购管理(工业)系统目录表结构字字段段名名类类型型描描述述FBrNoSTRING公司机构类码FCessFLOAT税率FMapNameSTRING对应名称FMapNumberSTRING对应代码FAmountFLOAT金额FAuxCommitQtyFLOAT辅助到货数量FAuxQtyFLOAT辅助订货数量FAuxPriceFLOAT辅助单价FAuxStockQtyFLOAT辅助入库数

23、量FCommitQtyFLOAT到货数量FDateDATETIME 交货日期FEntryIDINTEGER分录号FInterIDINTEGER采购订单内码FItemIDINTEGER物料内码FNoteSTRING备注FPriceFLOAT单价FQtyFLOAT订货数量FSourceEntryIDINTEGER原分录号FStockQtyFLOAT入库数量FTaxAmountFLOAT税额FTaxRateFLOAT税率FUnitIDINTEGER单位内码键表键键名名类类型型PK_POOrderEntry_1_18主键索引表索索引引名名字字段段PK_POOrderEntry_1_18FBrNoIX_

24、POOrderEntry_FInterIDFInterID触发器表触触发发器器名名描描述述返回采购管理(工业)系统目录表结构字字段段名名类类型型描描述述FBillerIDINTEGER制单人FCheckerIDINTEGER审核人FCheckTimeDATETIME 审批日期FClosedINTEGER是否关闭FDeptIDINTEGER使用部门FSCBillInterIDINTEGER原单分录号FMultiCheckDate1DATETIMEFBillNoSTRING申请单号FBrNoSTRING公司机构内码FCancellationINTEGER作废FCurCheckLevelINTEGE

25、RFDateDATETIME 单据日期FInterIDINTEGER申请单内码FMRPINTEGERMRP类型FMrpClosedINTEGER业务关闭状态FMultiCheckDate2DATETIMEFMultiCheckDate3DATETIMEFMultiCheckDate4DATETIMEFMultiCheckDate5DATETIMEFMultiCheckDate6DATETIMEFMultiCheckLevel1INTEGER一审FMultiCheckLevel2INTEGER二审FMultiCheckLevel3INTEGER三审FMultiCheckLevel4INTEGER

26、四审FMultiCheckLevel5INTEGER五审FMultiCheckLevel6INTEGER六审FNoteSTRING备注FOrderInterIDINTEGER订单内码FPlanOrderInterIDINTEGER计划订单号FRequesterIDINTEGER申请人FStatusINTEGER状态FTranTypeINTEGER单据类型键表键键名名类类型型PK_POre主键索引表索索引引名名字字段段PK_POreFBrNoIX_PORequest_FInterIDFInterID触发器表触触发发器器名名描描述述返回采购管理(工业)系统目录表结构字字段段名名类类型型描描述述FA

27、PurchTimeDATETIME 建议采购日期FBrNoSTRING公司机构类码FEntryIDINTEGER分录号FInterIDINTEGER申请单内码FAuxCommitQtyFLOAT辅助审批数量FAuxPriceFLOAT辅助单价FAuxQtyFLOAT辅助申请数量FCommitQtyFLOAT审批数量FFetchTimeDATETIME 到货日期FItemIDINTEGER物料内码FPlanOrderInterIDINTEGER计划订单号FPriceFLOAT单价FQtyFLOAT申请数量FSourceEntryIDINTEGER原分录号FSupplyIDINTEGER供应商内码

28、FUnitIDINTEGER单位内码FUseSTRING用途键表键键名名类类型型PK_PORequest主键索引表索索引引名名字字段段PK_PORequestFBrNoIX_PORequestEntry_FInterIDFInterID触发器表触触发发器器名名描描述述返回采购管理(工业)系统目录表结构字字段段名名类类型型描描述述FBrNoSTRING公司机构内码FCurrencyIDINTEGER 币别FItemIDINTEGER 物料内码FPOHighPriceFLOAT采购最高限价FSupIDINTEGER 供应商内码FPTypeINTEGER 单价类型键表键键名名类类型型PK_t_Sup

29、ply主键索引表索索引引名名字字段段PK_t_SupplyFBrNo触发器表触触发发器器名名描描述述返回采购管理(工业)系统目录表结构字字段段名名类类型型描描述述FDisableDateDATETIME 失效日期FDiscountFLOAT折扣率FItemIDINTEGER物料内码FQuoteTimeDATETIME 生效日期FUsedINTEGERFBrNoSTRING公司机构类码FCyIDINTEGER币别FEndQtyFLOAT订货终止数量FEntryIDINTEGER分录号FLeadTimeINTEGER订货提前期FPriceFLOAT单价FPTypeINTEGER单价类型FRemar

30、kSTRING备注FStartQtyFLOAT订货起始数量FSupIDINTEGER供应商内码FUnitIDINTEGER单位内码键表键键名名类类型型PK_t_SupplyEntry主键索引表索索引引名名字字段段PK_t_SupplyEntryFBrNo触发器表触触发发器器名名描描述述返回采购管理(工业)系统目录表结构字字段段名名类类型型描描述述FUseShortNumberINTEGER 是否使用短代码FCharacterSTRING补位符FDetailINTEGER 是否明细物料FFormatDateSTRING格式FPropertyIDINTEGER 批号属性值FSelDefineSTR

31、ING自定义批号FSubCharacterSTRING替换符FIDINTEGER 级次FItemIDINTEGER 物料内码FWidthINTEGER 宽度键表键键名名类类型型PK_ICBatchNoRule主键索引表索索引引名名字字段段PK_ICBatchNoRuleFID触发器表触触发发器器名名描描述述返回采购管理(工业)系统目录表结构字字段段名名类类型型描描述述FCompanyIDINTEGER 往来单位内码FIDINTEGER 基础资料类别FMapNumberSTRING基础资料映射代码FItemIDINTEGER 基础资料内码FMapNameSTRING基础资料映射名称FProper

32、tyIDINTEGER 往来单位类别键表键键名名类类型型PK_ICItemMapping主键索引表索索引引名名字字段段PK_ICItemMappingFID触发器表触触发发器器名名描描述述返回采购管理(工业)系统目录表结构字字段段名名类类型型描描述述FAPurchTimeDATETIME 建议采购日期FBillNoSTRING编号FCheckerIDSTRING审核人FCheckFlagSTRING审核标志FCheckTimeDATETIME 审批日期FCUUnitIDSTRING常用单位FdateDATETIME 日期FauxqtyFLOAT数量FBillerIDSTRING制单FCance

33、llationSTRING作废标志FClosedSTRING关闭标志FcuQtyFLOAT常用单位应收数量FDeptIDSTRING使用部门FEntryIDINTEGER单据分录号FFetchTimeDATETIME 到货日期FInterIDINTEGER单据内码FItemIDSTRING物料名称FLeadTimeFLOAT提前期FmodelSTRING规格型号FMRPSTRING单据来源FMRPClosedSTRINGMRP关闭标志FNoteSTRING备注FNumberSTRING物料长代码FOrderInterIDSTRING销售订单号FPlanOrderNoSTRING计划订单号FPP

34、OrderInterIDSTRING生产预测单号FQtyFLOAT基本单位数量FRelationSTRING关联标志FRequesterIDSTRING申请人FShortNumberSTRING物料代码FSupplyIDSTRING供应商名称FUnitGroupIDSTRING基本单位FUnitIDSTRING单位FUseSTRING用途键表键键名名类类型型索引表索索引引名名字字段段触发器表触触发发器器名名描描述述返回采购管理(工业)系统目录表结构字字段段名名类类型型描描述述FBillNoSTRING编号FcuQtyFLOAT常用单位数量FInterIDINTEGER单据内码FMRPClose

35、dSTRINGMRP关闭标志FNoteSTRING备注FAmountFLOAT金额FAuxQtyFLOAT数量FBillerIDSTRING制单FCheckerIDSTRING审核人FCommitdateDATETIME 交货日期FMangerIDSTRING主管FUnitIDSTRING单位FCurrencyIDSTRING币别FCUUnitIDSTRING常用单位FDeptIDSTRING部门FauxpriceFLOAT单价FCancellationSTRING作废标志FEmpIDSTRING业务员FEntryIDINTEGER单据分录号FMapNumberSTRING对应代码FPOSty

36、leSTRING采购方式FRequestInterIDSTRING采购申请单号FTaxRateFLOAT折扣率FCessFLOAT税率(%)FItemIDSTRING物料名称FMapNameSTRING对应名称FNumberSTRING物料长代码FRelateBrIDSTRING供货机构FShortNumberSTRING物料代码FAuxCommitQtyFLOAT关联数量FCompactNoSTRING合同号FmodelSTRING规格型号FRelationSTRING关联标志FStatus=3STRING关闭标志FSupplyIDSTRING供应商FAuxStockQtyFLOAT入库数量

37、FUnitGroupIDSTRING基本单位FCheckFlagSTRING审核标志FCommitQtyFLOAT基本单位关联数量FdateDATETIME 日期FExchangeRateFLOAT汇率FQtyFLOAT基本单位数量FStockQtyFLOAT基本单位入库数量键表键键名名类类型型索引表索索引引名名字字段段触发器表触触发发器器名名描描述述返回采购管理(工业)系统目录表结构字字段段名名类类型型描描述述FCurrencyIDSTRING币别FDeptIDSTRING部门FKFPeriodINTEGER保质期（天）FNoteSTRING备注FamountFLOAT金额FAuxQtyPa

38、ssFLOAT合格数量FExchangeRateFLOAT汇率FQtyFLOAT基本单位数量FQtyPassFLOAT基本单位合格数量FUnitGroupIDSTRING基本单位FauxpriceFLOAT单价FCnnInterIDSTRING采购订单号FCUQtyPassFLOAT常用单位数量FCUUnitIDSTRING常用单位FDCSPIDSTRING仓位FPOStyleSTRING采购方式FBillNoSTRING单据编号FUnitIDSTRING单位FClosedSTRING关闭标志FEntryIDINTEGER单据分录号FInterIDINTEGER单据内码FMapNameSTRI

39、NG对应名称FauxqtyFLOAT数量FCheckerIDSTRING审核人FCheckFlagSTRING审核标志FBillerIDSTRING制单FdateDATETIME 日期FEmpIDSTRING业务员FFManagerIDSTRING主管FItemIDSTRING物料名称FKFDateDATETIME 生产/采购日期FMapNumberSTRING对应代码FmodelSTRING规格型号FNumberSTRING物料长代码FPurchaseInterIDSTRING购货发票号FRelateBrIDSTRING供货机构FRelationSTRING关联标志FShortNumberS

40、TRING物料代码FStockIDSTRING收料仓库FSupplyIDSTRING供应商FCancellationSTRING作废标志FCUQtyFLOAT常用单位数量键表键键名名类类型型索引表索索引引名名字字段段触发器表触触发发器器名名描描述述返回采购管理(工业)系统目录表结构字字段段名名类类型型描描述述FBillNoSTRING编号FCurrencyIDSTRING币别FKFPeriodINTEGER保质期（天）FRemarkSTRING备注FamountFLOAT金额FauxpriceFLOAT单价FauxqtyFLOAT数量FBillerIDSTRING制单FCancellation

41、STRING作废标志FCheckerIDSTRING审核人FCheckFlagSTRING审核标志FClosedSTRING关闭标志FCnnInterIDSTRING原收料通知单号FcuQtyFLOAT常用单位数量FCUUnitIDSTRING常用单位FdateDATETIME 日期FDCSPIDSTRING仓位FDeptIDSTRING部门FEmpIDSTRING业务员FEntryIDINTEGER单据分录号FExchangeRateFLOAT汇率FFManagerIDSTRING主管FInterIDINTEGER单据内码FItemIDSTRING物料名称FKFDateDATETIME 生产

42、/采购日期FMapNameSTRING对应名称FMapNumberSTRING对应代码FmodelSTRING规格型号FnoteSTRING退料原因FNumberSTRING物料长代码FPOStyleSTRING采购方式FQCRBillInterIDSTRING质检单单号FQtyFLOAT基本单位数量FRelateBrIDSTRING供货机构FRelationSTRING关联标志FShortNumberSTRING物料代码FStockIDSTRING退料仓库FSupplyIDSTRING供货单位FUnitGroupIDSTRING基本单位FUnitIDSTRING单位键表键键名名类类型型索引表

43、索索引引名名字字段段触发器表触触发发器器名名描描述述返回采购管理(工业)系统目录表结构字字段段名名类类型型描描述述FaddressSTRING地址电话FAuxOrderPriceFLOAT订单单价FBillerIDSTRING制单人FCancellationSTRING作废标志FcuQtyFLOAT常用单位数量FShortNumberSTRING物料代码FamountFLOAT金额FTax_AmountFLOAT运费金额(本位币)FTaxAmountFLOAT税额FTaxNumSTRING纳税登记号FTaxRateFLOAT税率FUnitIDSTRING单位FVchInterIDSTRING凭

44、证字号FWWInStockInterIDSTRING委外加工入库单号FYearPeriodSTRING钩稽期间FYtdIntRateFLOAT年利率(%)FAmountMustFLOAT应记费用（本位币）FStdamountFLOAT金额（本位币）FauxpriceFLOAT单价FauxqtyFLOAT数量FBankSTRING开户银行及账号FStdTaxAmountFLOAT税额（本位币）FBillerNameSTRING开票人FBillNoSTRING发票号码FSupplyIDSTRING供货单位FCheckerIDSTRING审核人FCheckFlagSTRING审核标志FCompact

45、NoSTRING合同号FSupplyIDtSTRING基本单位FCurrencyIDSTRING币别FCUUnitIDSTRING常用单位FdateDATETIME 日期FDeductTaxFLOAT运费税金（本位币）FDeptIDSTRING部门FEmpIDSTRING业务员FEntryIDINTEGER单据分录号FExchangeRateFLOAT汇率FFullNameSTRING贷方科目FHookerIDSTRING钩稽人FHookFlagSTRING钩稽标志FInStockInterIDSTRING采购入库单号FInterIDINTEGER单据内码FInvStyleSTRING业务类型

46、FItemIDSTRING物料名称FMapNameSTRING对应名称FMapNumberSTRING对应代码FmodelSTRING规格型号FNoteSTRING备注FNumberSTRING物料长代码FOrderInterIDSTRING采购订单号FOrgBillInterIDSTRING拆单标志FPOStyleSTRING采购方式FQtyFLOAT基本单位数量FRelationSTRING关联标志FRSCBillInterIDSTRING原发票号键表键键名名类类型型索引表索索引引名名字字段段触发器表触触发发器器名名描描述述返回采购管理(工业)系统目录表结构字字段段名名类类型型描描述述FA

47、ddressSTRING地址FBillNoSTRING发票号码FCurrencyIDSTRING币别FDeptIDSTRING部门FBankSTRING开户银行FBillerIDSTRING制单人FCancellationSTRING作废标志FEmpIDSTRING业务员FEntryIDINTEGER单据分录号FExchangeRateFLOAT汇率FInStockInterIDSTRING委外加工入库单号FInterIDINTEGER单据内码FNumberSTRING费用长代码FShortNumberSTRING费用代码FStdTaxAmount)FLOAT不含税金额（本位币）FTaxAmo

48、unt)FLOAT不含税金额FVchInterIDSTRING凭证字号FYearPeriodSTRING钩稽期间FAmountFLOAT金额FAuxPriceFLOAT单价FAuxQtyFLOAT数量FCheckerIDSTRING审核人FCheckFlagSTRING审核标志FDateDATETIME 日期FFeeTypeSTRING费用类型FHookerIDSTRING钩稽人FHookFlagSTRING钩稽标志FInvoiceInterIDSTRING采购发票号FItemIDSTRING费用名称FNoteSTRING备注FPosterIDSTRING记账人FPOStyleSTRING采购

49、方式FRelationSTRING关联标志FRSCBillInterIDSTRING原费用发票号FStdamountFLOAT金额（本位币）FStdTaxAmountFLOAT可抵扣税额(本位币)FSupplyIDSTRING供货单位FTaxAmountFLOAT可抵扣税额FTaxNumSTRING纳税登记号FTaxRateFLOAT税率(%)FUnitIDSTRING计量单位FVoucherStatusSTRING记账标志键表键键名名类类型型索引表索索引引名名字字段段触发器表触触发发器器名名描描述述返回采购管理(工业)系统目录表结构字字段段名名类类型型描描述述FAuxPriceFLOAT单价

50、FAuxQtyFLOAT数量FNoteSTRING备注FTaxAmountFLOAT可抵扣税额FAmountFLOAT金额FAmountExFLOAT不含税金额FBrNoSTRINGFEntryIDINTEGER 分录号FInterIDINTEGER 单据内码FItemIDINTEGER 费用内码FSourceEntryIDINTEGER 源单分录号FStdAmountFLOAT金额（本位币）FStdTaxAmountFLOAT税额（本位币）FTaxRateFLOAT税率FUnitIDSTRING计量单位键表键键名名类类型型PK_ICExpensesEntry主键索引表索索引引名名字字段段PK

51、_ICExpensesEntryFBrNo触发器表触触发发器器名名描描述述返回采购管理(工业)系统目录表结构字字段段名名类类型型描描述述FAcctIDINTEGER会计科目FCustIDINTEGER购货单位FHookerIDINTEGER钩稽人FSaleStyleINTEGER销售方式FInvTypeINTEGER销售费用发票类型FPOStyleINTEGER采购方式FRelationInterIDINTEGER关联单据内码FRelationTranTypeINTEGER关联单据类型FCancellationINTEGER作废标志FCheckDateDATETIME 审核日期FMultiCh

52、eckDate3DATETIME 三级审核日期FMultiCheckDate6DATETIME 六级审核日期FRecBillInterIDINTEGER其他应收单据号FRelationBillNoSTRING关联单据编号FDateDATETIME 日期FExchangeRateFLOAT汇率FMultiCheckDate1DATETIME 一级审核日期FMultiCheckDate2DATETIME 二级审核日期FMultiCheckDate4DATETIME 四级审核日期FMultiCheckDate5DATETIME 五级审核日期FRSCBillInterIDINTEGER原费用发票号FS

53、upplyIDINTEGER供货单位FHookInterIDINTEGER钩稽单据内码FInStockInterIDINTEGER委外加工入库单号FInterIDINTEGERFBillNoSTRING单据号FBrNoSTRINGFClosedINTEGER关闭标志FCurCheckLevelINTEGER当前审核级次FCurrencyIDINTEGER币别FStatusINTEGER单据状态FInvoiceInterIDINTEGER采购发票号FBillerIDINTEGER制单人FCheckerIDINTEGER审核人FDeptIDINTEGER部门FEmpIDINTEGER业务员FTra

54、nTypeINTEGER单据类型FMultiCheckLevel1INTEGER一审FMultiCheckLevel2INTEGER二审FMultiCheckLevel3INTEGER三审FMultiCheckLevel4INTEGER四审FMultiCheckLevel5INTEGER五审FMultiCheckLevel6INTEGER六审FPayBillInterIDINTEGER其他应付单号FPosterIDINTEGER记账FVchInterIDINTEGER凭证内码FYearPeriodSTRING钩稽期间FROBINTEGER红蓝标志键表键键名名类类型型PK_ICExpenses主键索引表索索引引名名字字段段PK_ICExpensesFBrNo触发器表触触发发器器名名描描述述返回采购管理(工业)系统目录表结构字字段段名名类类型型描描述述FBillNoSTRING编号FSerialINTEG