金蝶仓存管理数据库表结构 字段说明描述

1、仓仓存存管管理理系系统统数数据据表表- -表表结结构构表表名名表表描描述述1 ICABC库存ABC分析表2 ICBal存货余额表3 ICInvBackup盘点备份表4 ICInvBal库房存货余额表5 ICInventory存货表6 ICInvInitial存货初始数据表7 ICQueue物料批次表8 ICQueueInitial初始化物料批次表9 ICStockBill出入库单据表10 ICStockBillEntry出入库单据分录表11 POInvBal代管余额表12 POInventory代管库存表13 POStockBill虚仓调拨单据表14 POStockBillEntry虚仓调拨单

2、据分录表15 ZPStockBill赠品出入库单据表16 ZPStockBillEntry赠品出入库单据分录表17 t_LockStock锁库表18 ICBillType单据类型表19 vwICBill_1外购入库（视图）20 vwICBill_2产品入库（视图）21 vwICBill_5委外加工入库（视图）22 vwICBill_7其他入库（视图）23 vwICBill_8销售出库（视图）24 vwICBill_15委外加工发出（视图）25 vwICBill_11生产领料（视图）26 vwICBill_16其他出库（视图）27 vwICBill_17盘盈入库（视图）28 vwICBill_1

3、9盘亏毁损（视图）29 vwICBill_18仓库调拨（视图）30 vwICBill_4赠品入库（视图）31 vwICBill_14赠品出库（视图）32 vwICBill_22虚仓调拨（视图）33 ICSTJGBill受托加工单据表34 ICSTJGBillEntry受托加工单据分录表35 ICWorkFlow工业工作流定义表36 EISnInvBal序列号余额表37 EISNInventory序列号库存表38 EISNInvInitial序列号初始库存表39 EISNTrans序列号事务表40 T_SN序列号41 t_SN_Template序列号模板字段表42 vwICBill_103受托加

4、工材料入库单(视图)43 vwICBill_137受托加工领料单(视图)表表字字段段描描述述表表名名表表描描述述字字段段名名字字段段类类型型字字段段描描述述1 ICABC库存ABC分析表FAmountPercentFLOAT金额百分比1 ICABC库存ABC分析表FTotalEndQtyFLOAT总结存数量1 ICABC库存ABC分析表FAbcClsSTRINGABC分类1 ICABC库存ABC分析表FItemIDINTEGER物料内码1 ICABC库存ABC分析表FAvgPriceFLOAT平均单价1 ICABC库存ABC分析表FEndBalFLOAT结存金额1 ICABC库存ABC分析表F

5、EndQtyFLOAT结存数量1 ICABC库存ABC分析表FQtyPercentFLOAT百分比1 ICABC库存ABC分析表FSumAmountPercentFLOAT金额百分比1 ICABC库存ABC分析表FSumSortINTEGER顺序1 ICABC库存ABC分析表FTotalEndBalFLOAT总的结存金额2 ICBal存货余额表FBatchNoSTRING批号2 ICBal存货余额表FPeriodINTEGER会计期间2 ICBal存货余额表FYearINTEGER会计年度2 ICBal存货余额表FBegBalFLOAT期初余额2 ICBal存货余额表FBegDiffFLOAT

6、期初结存成本差异2 ICBal存货余额表FBegQtyFLOAT期初结存数量2 ICBal存货余额表FCreditFLOAT本期发出金额2 ICBal存货余额表FDebitFLOAT本期收入金额2 ICBal存货余额表FEndBalFLOAT期末余额2 ICBal存货余额表FBillInterIDINTEGER顺序号2 ICBal存货余额表FEndDiffFLOAT期末结存成本差异2 ICBal存货余额表FEndQtyFLOAT期末结存数量2 ICBal存货余额表FEntryIDINTEGER序号2 ICBal存货余额表FItemIDINTEGER物料内码2 ICBal存货余额表FReceiv

7、eFLOAT本期收货数量2 ICBal存货余额表FReceiveDiffFLOAT本期收入成本差异2 ICBal存货余额表FSendFLOAT本期发出数量2 ICBal存货余额表FSendDiffFLOAT本期发出成本差异2 ICBal存货余额表FStockGroupIDINTEGER仓库组内码2 ICBal存货余额表FYtdCreditFLOAT本年发出金额2 ICBal存货余额表FYtdDebitFLOAT本年收入金额2 ICBal存货余额表FYtdReceiveFLOAT本年收货数量2 ICBal存货余额表FYtdReceiveDiffFLOAT本年收入差异2 ICBal存货余额表FYt

8、dSendFLOAT本年发出数量2 ICBal存货余额表FYtdSendDiffFLOAT本年发出差异3 ICInvBackup盘点备份表FKFDateSTRING生产/采购日期3 ICInvBackup盘点备份表FKFPeriodINTEGER保质期3 ICInvBackup盘点备份表FAdjINTEGER已经调整3 ICInvBackup盘点备份表FAdjustActFLOAT盘点差异3 ICInvBackup盘点备份表FAuxCheckQtyFLOAT盘点数量3 ICInvBackup盘点备份表FAuxQtyFLOAT账存数量3 ICInvBackup盘点备份表FAuxQtyActFLO

9、AT实存数量3 ICInvBackup盘点备份表FBrNoSTRING3 ICInvBackup盘点备份表FBalFLOAT余额3 ICInvBackup盘点备份表FBatchNoSTRING批次3 ICInvBackup盘点备份表FBillInterIDINTEGER盘点单内码3 ICInvBackup盘点备份表FCheckerINTEGER盘点人3 ICInvBackup盘点备份表FCheckerManSTRING盘点员内码3 ICInvBackup盘点备份表FCheckQtyFLOAT实存数量二3 ICInvBackup盘点备份表FDateBackupDATETIME备份时间3 ICIn

10、vBackup盘点备份表FDateCheckDATETIME盘点时间3 ICInvBackup盘点备份表FItemIDINTEGER物料内码3 ICInvBackup盘点备份表FMaxBillInterIDINTEGER最大单号3 ICInvBackup盘点备份表FMinusFLOAT盘亏数量3 ICInvBackup盘点备份表FMinusPercentFLOAT盘亏率3 ICInvBackup盘点备份表FNoteSTRING备注3 ICInvBackup盘点备份表FQtyFLOAT账存数量3 ICInvBackup盘点备份表FQtyActFLOAT实存数量3 ICInvBackup盘点备份表

11、FSelectINTEGER打印3 ICInvBackup盘点备份表FStockIDINTEGER仓库内码3 ICInvBackup盘点备份表FStockPlaceIDINTEGER仓位内码3 ICInvBackup盘点备份表FUnitIDINTEGER计量单位4 ICInvBal库房存货余额表FBatchNoSTRING批号4 ICInvBal库房存货余额表FItemIDINTEGER物料内码4 ICInvBal库房存货余额表FPeriodINTEGER会计期间4 ICInvBal库房存货余额表FStockIDINTEGER库房內码4 ICInvBal库房存货余额表FYearINTEGER会

12、计年度4 ICInvBal库房存货余额表FBegBalFLOAT期初结存余额4 ICInvBal库房存货余额表FBegDiffFLOAT期初结存材料成本差异4 ICInvBal库房存货余额表FBegQtyFLOAT期初结存数量4 ICInvBal库房存货余额表FBillInterIDINTEGER顺序号4 ICInvBal库房存货余额表FCreditFLOAT本期发出余额4 ICInvBal库房存货余额表FDebitFLOAT本期收入余额4 ICInvBal库房存货余额表FEndBalFLOAT期末结存余额4 ICInvBal库房存货余额表FEndDiffFLOAT期末结存材料成本差异4 IC

13、InvBal库房存货余额表FEndQtyFLOAT期末结存数量4 ICInvBal库房存货余额表FKFDateSTRING生产/采购日期4 ICInvBal库房存货余额表FKFPeriodINTEGER保质期4 ICInvBal库房存货余额表FReceiveFLOAT本期收入数量4 ICInvBal库房存货余额表FReceiveDiffFLOAT本期收入成本差异4 ICInvBal库房存货余额表FSendFLOAT本期发出数量4 ICInvBal库房存货余额表FSendDiffFLOAT本期发出成本差异4 ICInvBal库房存货余额表FStockPlaceIDINTEGER仓位内码4 ICI

14、nvBal库房存货余额表FYtdCreditFLOAT本年发出余额4 ICInvBal库房存货余额表FYtdDebitFLOAT本年收入余额4 ICInvBal库房存货余额表FYtdReceiveFLOAT本年收入数量4 ICInvBal库房存货余额表FYtdReceiveDiffFLOAT本年收入差异4 ICInvBal库房存货余额表FYtdSendFLOAT本年发出数量4 ICInvBal库房存货余额表FYtdSendDiffFLOAT本年发出差异5 ICInventory存货表FKFDateSTRING生产/采购日期5 ICInventory存货表FBalFLOAT存货余额5 ICInv

15、entory存货表FBatchNoSTRING批次5 ICInventory存货表FItemIDINTEGER物料内码5 ICInventory存货表FKFPeriodINTEGER保质期5 ICInventory存货表FQtyFLOAT存货数量5 ICInventory存货表FQtyLockFLOAT锁库数量5 ICInventory存货表FStockIDINTEGER库房內码5 ICInventory存货表FStockPlaceIDINTEGER仓位内码6 ICInvInitial存货初始数据表FBatchNoSTRING批号6 ICInvInitial存货初始数据表FItemIDINTE

16、GER物料内码6 ICInvInitial存货初始数据表FPeriodINTEGER会计期间6 ICInvInitial存货初始数据表FStockIDINTEGER库房內码6 ICInvInitial存货初始数据表FAuxBegQtyFLOAT辅助期初数量6 ICInvInitial存货初始数据表FBegBalFLOAT期初余额6 ICInvInitial存货初始数据表FBegDiffFLOAT期初料成本差异6 ICInvInitial存货初始数据表FBegQtyFLOAT期初数量6 ICInvInitial存货初始数据表FBillInterIDINTEGER顺序号6 ICInvInitial

17、存货初始数据表FBrNoSTRING公司机构类码6 ICInvInitial存货初始数据表FCreditFLOAT本期发出余额6 ICInvInitial存货初始数据表FDebitFLOAT本期收入余额6 ICInvInitial存货初始数据表FEndBalFLOAT期末余额6 ICInvInitial存货初始数据表FEndQtyFLOAT期末数量6 ICInvInitial存货初始数据表FKFDateSTRING生产日期6 ICInvInitial存货初始数据表FKFPeriodFLOAT保质期(天)6 ICInvInitial存货初始数据表FReceiveFLOAT本期收入数量6 ICIn

18、vInitial存货初始数据表FReceiveDiffFLOAT本期收入成本差异6 ICInvInitial存货初始数据表FSendFLOAT本期发出数量6 ICInvInitial存货初始数据表FSendDiffFLOAT本期发出成本差异6 ICInvInitial存货初始数据表FSPIDINTEGER仓位内码6 ICInvInitial存货初始数据表FUnitIDINTEGER单位内码6 ICInvInitial存货初始数据表FYtdAuxBegQtyFLOAT年初辅助单位数量6 ICInvInitial存货初始数据表FYtdAuxReceiveFLOAT年累计辅助单位接收数量6 ICIn

19、vInitial存货初始数据表FYtdAuxSendFLOAT年累计辅助单位发出数量6 ICInvInitial存货初始数据表FYtdBegBalFLOAT年初余额6 ICInvInitial存货初始数据表FYtdBegDiffFLOAT年初差异6 ICInvInitial存货初始数据表FYtdBegQtyFLOAT年初基本单位数量6 ICInvInitial存货初始数据表FYtdCreditFLOAT本年发出余额6 ICInvInitial存货初始数据表FYtdDebitFLOAT本年收入余额6 ICInvInitial存货初始数据表FYtdReceiveFLOAT本年收入数量6 ICInv

20、Initial存货初始数据表FYtdReceiveDiffFLOAT本年累计收入差异6 ICInvInitial存货初始数据表FYtdSendFLOAT本年发出数量6 ICInvInitial存货初始数据表FYtdSendDiffFLOAT本年累计支出差异7 ICQueue物料批次表FAmountFLOAT金额7 ICQueue物料批次表FAuxQtyFLOAT辅助数量7 ICQueue物料批次表FBatchNoSTRING批号7 ICQueue物料批次表FItemIDINTEGER物料内码7 ICQueue物料批次表FQtyFLOAT库存数量8 ICQueueInitial初始化物料批次表F

21、ItemIDINTEGER物料内码8 ICQueueInitial初始化物料批次表FAmountFLOAT金额8 ICQueueInitial初始化物料批次表FAuxQtyFLOAT辅助数量8 ICQueueInitial初始化物料批次表FBatchNoSTRING批号8 ICQueueInitial初始化物料批次表FBillInterIDINTEGER单据内码8 ICQueueInitial初始化物料批次表FQtyFLOAT数量9 ICStockBill出入库单据表FAcctIDINTEGER科目内码9 ICStockBill出入库单据表FBrNoSTRING9 ICStockBill出入库

22、单据表FInvoiceInterIDINTEGER发票内码9 ICStockBill出入库单据表FBillerIDINTEGER制单人9 ICStockBill出入库单据表FCancellationINTEGER作废9 ICStockBill出入库单据表FFManagerIDINTEGER验收人9 ICStockBill出入库单据表FOrderInterIDINTEGER定单内码9 ICStockBill出入库单据表FBackFlushedINTEGER倒冲标志9 ICStockBill出入库单据表FPurposeIDINTEGER9 ICStockBill出入库单据表FQCRBillInte

23、rIDINTEGER质检单内码9 ICStockBill出入库单据表FQTBILLINTERIDINTEGER其他入库单号9 ICStockBill出入库单据表FRelateBrIDINTEGER分支机构内码9 ICStockBill出入库单据表FRelateInvoiceIDINTEGER关联发票号9 ICStockBill出入库单据表FRelationBillNoSTRING关联单据号码9 ICStockBill出入库单据表FRelationInterIDINTEGER关联单据内码9 ICStockBill出入库单据表FRelationTranTypeINTEGER关联单据类型9 ICSt

24、ockBill出入库单据表FResourceIDINTEGER9 ICStockBill出入库单据表FReturnBillInterIDINTEGER退货单号9 ICStockBill出入库单据表FROBINTEGER红蓝字9 ICStockBill出入库单据表FRSCBillInterIDINTEGER红单原单9 ICStockBill出入库单据表FRSCBillNoSTRING9 ICStockBill出入库单据表FSaleStyleINTEGER销售方式9 ICStockBill出入库单据表FSCBillInterIDINTEGER通知单9 ICStockBill出入库单据表FSCBil

25、lNoSTRING9 ICStockBill出入库单据表FSCStockIDINTEGER发出库房9 ICStockBill出入库单据表FPostedINTEGER过账9 ICStockBill出入库单据表FSManagerIDINTEGER保管人9 ICStockBill出入库单据表FStatusINTEGER状态9 ICStockBill出入库单据表FBillTypeIDINTEGER单据类别9 ICStockBill出入库单据表FSystemTypeINTEGER系统类型9 ICStockBill出入库单据表FTaskIDINTEGER应付单号码9 ICStockBill出入库单据表FT

26、ranStatusINTEGER传输状态9 ICStockBill出入库单据表FBQCRBillInterIDINTEGER退货检验申请单内码9 ICStockBill出入库单据表FUpStockWhenSaveINTEGER更新库存9 ICStockBill出入库单据表FUseSTRING用途9 ICStockBill出入库单据表FUUIDUnKnown9 ICStockBill出入库单据表FVchInterIDINTEGER凭证内码9 ICStockBill出入库单据表FWBInterIDINTEGER9 ICStockBill出入库单据表FZPBillInterIDINTEGER赠品单据

27、内码9 ICStockBill出入库单据表FOrgBillInterIDINTEGER原单内码9 ICStockBill出入库单据表FBSCBillInterIDINTEGER退货通知单9 ICStockBill出入库单据表FPosterIDINTEGER记账人9 ICStockBill出入库单据表FCheckerIDINTEGER审核人9 ICStockBill出入库单据表FCheckSelectINTEGER9 ICStockBill出入库单据表FCostOBJIDINTEGER成本对象代码9 ICStockBill出入库单据表FCostOBJNameSTRING成本对象名称9 ICSto

28、ckBill出入库单据表FCPInStockInterIDINTEGER产品入库单9 ICStockBill出入库单据表FCurCheckLevelINTEGER9 ICStockBill出入库单据表FCurrencyIDINTEGER币别9 ICStockBill出入库单据表FDCStockIDINTEGER收入库房9 ICStockBill出入库单据表FSupplyIDINTEGER供应商内码9 ICStockBill出入库单据表FSendBillNoSTRING发出单号9 ICStockBill出入库单据表FBillNoSTRING入库单号9 ICStockBill出入库单据表FTran

29、TypeINTEGER单据类型9 ICStockBill出入库单据表FDateDATETIME单据日期9 ICStockBill出入库单据表FDeptIDINTEGER部门9 ICStockBill出入库单据表FEmpIDINTEGER业务员9 ICStockBill出入库单据表FPOStyleINTEGER采购方式9 ICStockBill出入库单据表FHookInterIDINTEGER钩稽单据9 ICStockBill出入库单据表FImportINTEGER引入标志9 ICStockBill出入库单据表FINBillInterIDINTEGER9 ICStockBill出入库单据表FIN

30、SCBillInterIDINTEGER入库单内码9 ICStockBill出入库单据表FInterIDINTEGER单据内码9 ICStockBill出入库单据表FPayBillIDINTEGER应付单内码9 ICStockBill出入库单据表FMultiCheckDate1DATETIME一级审核日期9 ICStockBill出入库单据表FMultiCheckDate2DATETIME二级审核日期9 ICStockBill出入库单据表FMultiCheckDate3DATETIME三级审核日期9 ICStockBill出入库单据表FMultiCheckDate4DATETIME四级审核日期

31、9 ICStockBill出入库单据表FMultiCheckDate5DATETIME五级审核日期9 ICStockBill出入库单据表FMultiCheckDate6DATETIME六级审核日期9 ICStockBill出入库单据表FMultiCheckLevel1INTEGER9 ICStockBill出入库单据表FMultiCheckLevel2INTEGER9 ICStockBill出入库单据表FMultiCheckLevel3INTEGER9 ICStockBill出入库单据表FMultiCheckLevel4INTEGER9 ICStockBill出入库单据表FMultiCheck

32、Level5INTEGER9 ICStockBill出入库单据表FMultiCheckLevel6INTEGER9 ICStockBill出入库单据表FNoteSTRING备注9 ICStockBill出入库单据表FOperDateUnKnown时间戳10 ICStockBillEntry出入库单据分录表FAmountFLOAT金额10 ICStockBillEntry出入库单据分录表FAuxQtyActualFLOAT辅助实存数量10 ICStockBillEntry出入库单据分录表FAuxQtyMustFLOAT辅助账存数量10 ICStockBillEntry出入库单据分录表FBatch

33、NoSTRING批次10 ICStockBillEntry出入库单据分录表FAuxCommitQtyFLOAT辅助提交数量10 ICStockBillEntry出入库单据分录表FAuxPlanPriceFLOAT辅助计划价10 ICStockBillEntry出入库单据分录表FAuxPriceFLOAT辅助单价10 ICStockBillEntry出入库单据分录表FAuxQtyFLOAT辅助实际数量10 ICStockBillEntry出入库单据分录表FBrNoSTRING10 ICStockBillEntry出入库单据分录表FCommitQtyFLOAT提交数量10 ICStockBillE

34、ntry出入库单据分录表FConsignAmountFLOAT代销金额10 ICStockBillEntry出入库单据分录表FConsignPriceFLOAT代销单价10 ICStockBillEntry出入库单据分录表FDCSPIDINTEGER目标仓位10 ICStockBillEntry出入库单据分录表FEntryIDINTEGER分录号10 ICStockBillEntry出入库单据分录表FInterIDINTEGER单据内码10 ICStockBillEntry出入库单据分录表FItemIDINTEGER物料内码10 ICStockBillEntry出入库单据分录表FKFDateD

35、ATETIME生产/采购日期10 ICStockBillEntry出入库单据分录表FKFPeriodINTEGER保质期10 ICStockBillEntry出入库单据分录表FMapNameSTRING对应名称10 ICStockBillEntry出入库单据分录表FMapNumberSTRING对应代码10 ICStockBillEntry出入库单据分录表FMaterialCostFLOAT材料费10 ICStockBillEntry出入库单据分录表FNoteSTRING备注10 ICStockBillEntry出入库单据分录表FOperIDINTEGER工序10 ICStockBillEnt

36、ry出入库单据分录表FOrgBillEntryIDINTEGER10 ICStockBillEntry出入库单据分录表FPlanAmountFLOAT计划价金额10 ICStockBillEntry出入库单据分录表FPlanPriceFLOAT计划价10 ICStockBillEntry出入库单据分录表FPriceFLOAT单价10 ICStockBillEntry出入库单据分录表FProcessCostFLOAT加工费10 ICStockBillEntry出入库单据分录表FProcessPriceFLOAT加工入库单加工单价10 ICStockBillEntry出入库单据分录表FQtyFLO

37、AT实际数量10 ICStockBillEntry出入库单据分录表FQtyActualFLOAT实存数量10 ICStockBillEntry出入库单据分录表FQtyMustFLOAT申请数量10 ICStockBillEntry出入库单据分录表FSCBillInterIDINTEGER原单内码10 ICStockBillEntry出入库单据分录表FSCBillNoSTRING10 ICStockBillEntry出入库单据分录表FSCSPIDINTEGER源仓位10 ICStockBillEntry出入库单据分录表FSnListIDINTEGER序列号10 ICStockBillEntry出

38、入库单据分录表FSourceEntryIDINTEGER原分录号10 ICStockBillEntry出入库单据分录表FTaxAmountFLOAT税额10 ICStockBillEntry出入库单据分录表FTaxRateFLOAT税率10 ICStockBillEntry出入库单据分录表FUnitIDINTEGER单位内码11 POInvBal代管余额表FEndQtyFLOAT结存数量11 POInvBal代管余额表FPeriodINTEGER会计期间11 POInvBal代管余额表FYearINTEGER会计年度11 POInvBal代管余额表FBatchNoSTRING批号11 POIn

39、vBal代管余额表FBegDiffFLOAT期初差异11 POInvBal代管余额表FBillInterIDINTEGER单据内码11 POInvBal代管余额表FEndBalFLOAT结存余额11 POInvBal代管余额表FBegBalFLOAT期初余额11 POInvBal代管余额表FBegQtyFLOAT期初数量11 POInvBal代管余额表FBrNoSTRING11 POInvBal代管余额表FCreditFLOAT发出余额11 POInvBal代管余额表FDCSPIDINTEGER11 POInvBal代管余额表FDebitFLOAT入库余额11 POInvBal代管余额表FEn

40、dDiffFLOAT结存差异11 POInvBal代管余额表FItemIDINTEGER物料内码11 POInvBal代管余额表FKFDateSTRING生产/采购日期11 POInvBal代管余额表FKFPeriodINTEGER保质期11 POInvBal代管余额表FReceiveFLOAT入库数量11 POInvBal代管余额表FReceiveDiffFLOAT入库差异11 POInvBal代管余额表FSendFLOAT发出数量11 POInvBal代管余额表FSendDiffFLOAT发出差异11 POInvBal代管余额表FSPIDINTEGER仓位11 POInvBal代管余额表F

41、StockIDINTEGER库房內码11 POInvBal代管余额表FYtdCreditFLOAT本年发出余额11 POInvBal代管余额表FYtdDebitFLOAT本年入库余额11 POInvBal代管余额表FYtdReceiveFLOAT本年入库数量11 POInvBal代管余额表FYtdSendFLOAT本年发出数量12 POInventory代管库存表FBalFLOAT库存余额12 POInventory代管库存表FBatchNoSTRING批号12 POInventory代管库存表FItemIDINTEGER物料内码12 POInventory代管库存表FQtyFLOAT库存数量

42、12 POInventory代管库存表FKFDateSTRING生产/采购日期12 POInventory代管库存表FKFPeriodINTEGER保质期12 POInventory代管库存表FStockIDINTEGER库房內码12 POInventory代管库存表FStockPlaceIDINTEGER仓位内码12 POInventory代管库存表FStockTypeIDINTEGER仓库类型13 POStockBill虚仓调拨单据表FBillerIDINTEGER制单人内码13 POStockBill虚仓调拨单据表FBillNoSTRING单据编号13 POStockBill虚仓调拨单据

43、表FCheckerIDINTEGER审核人内码13 POStockBill虚仓调拨单据表FDateDATETIME日期13 POStockBill虚仓调拨单据表FCancellationINTEGER作废标志13 POStockBill虚仓调拨单据表FCurrencyIDINTEGER币别内码13 POStockBill虚仓调拨单据表FDCStockIDINTEGER目标仓库内码13 POStockBill虚仓调拨单据表FFManagerIDINTEGER验收员内码13 POStockBill虚仓调拨单据表FInterIDINTEGER单据内码13 POStockBill虚仓调拨单据表FPos

44、terIDINTEGER记账员内码13 POStockBill虚仓调拨单据表FSCStockIDINTEGER源仓库内码13 POStockBill虚仓调拨单据表FSManagerIDINTEGER保管员内码13 POStockBill虚仓调拨单据表FStatusINTEGER状态13 POStockBill虚仓调拨单据表FTranTypeINTEGER事务类型13 POStockBill虚仓调拨单据表FUpStockWhenSaveINTEGER更新库存标志14 POStockBillEntry虚仓调拨单据分录表FAmountFLOAT金额14 POStockBillEntry虚仓调拨单据分

45、录表FAuxPriceFLOAT单价14 POStockBillEntry虚仓调拨单据分录表FAuxQtyFLOAT数量14 POStockBillEntry虚仓调拨单据分录表FCommitQtyFLOAT提交数量14 POStockBillEntry虚仓调拨单据分录表FAuxCommitQtyFLOAT辅助提交数量14 POStockBillEntry虚仓调拨单据分录表FEntryIDINTEGER分录内码14 POStockBillEntry虚仓调拨单据分录表FInterIDINTEGER单据内码14 POStockBillEntry虚仓调拨单据分录表FBatchNoSTRING批次14

46、POStockBillEntry虚仓调拨单据分录表FBrNoSTRING14 POStockBillEntry虚仓调拨单据分录表FDCSPIDINTEGER收料仓位14 POStockBillEntry虚仓调拨单据分录表FItemIDINTEGER物料内码14 POStockBillEntry虚仓调拨单据分录表FKFDateDATETIME生产/采购日期14 POStockBillEntry虚仓调拨单据分录表FKFPeriodINTEGER保质期14 POStockBillEntry虚仓调拨单据分录表FNoteSTRING备注14 POStockBillEntry虚仓调拨单据分录表FPrice

47、FLOAT基本单位单价14 POStockBillEntry虚仓调拨单据分录表FQtyFLOAT基本单位数量14 POStockBillEntry虚仓调拨单据分录表FSCSPIDINTEGER发料仓位14 POStockBillEntry虚仓调拨单据分录表FSourceEntryIDINTEGER源单分录内码14 POStockBillEntry虚仓调拨单据分录表FUnitIDINTEGER单位内码15 ZPStockBill赠品出入库单据表FCheckerIDINTEGER审核人内码15 ZPStockBill赠品出入库单据表FDCStockIDINTEGER目标仓库内码15 ZPStock

48、Bill赠品出入库单据表FDeptIDINTEGER部门内码15 ZPStockBill赠品出入库单据表FROBINTEGER红蓝字标志15 ZPStockBill赠品出入库单据表FRSCBillInterIDINTEGER源赠品入库单内码15 ZPStockBill赠品出入库单据表FBillerIDINTEGER制单人内码15 ZPStockBill赠品出入库单据表FBillNoSTRING单据编号15 ZPStockBill赠品出入库单据表FCancellationINTEGER作废标志15 ZPStockBill赠品出入库单据表FCustIDINTEGER客户内码15 ZPStockBi

49、ll赠品出入库单据表FDateDATETIME日期15 ZPStockBill赠品出入库单据表FFManagerIDINTEGER验收员内码15 ZPStockBill赠品出入库单据表FInterIDINTEGER单据内码15 ZPStockBill赠品出入库单据表FPosterIDINTEGER记账员内码15 ZPStockBill赠品出入库单据表FRelateBillInterIDINTEGER连属单据内码15 ZPStockBill赠品出入库单据表FSCBillInterIDINTEGER赠品入库单内码15 ZPStockBill赠品出入库单据表FSManagerIDINTEGER保管员

50、内码15 ZPStockBill赠品出入库单据表FStatusINTEGER状态15 ZPStockBill赠品出入库单据表FSupplyIDINTEGER供应商内码15 ZPStockBill赠品出入库单据表FTranTypeINTEGER事务类型15 ZPStockBill赠品出入库单据表FUpStockWhenSaveINTEGER更新库存标志16 ZPStockBillEntry赠品出入库单据分录表FItemIDINTEGER物料内码16 ZPStockBillEntry赠品出入库单据分录表FNoteSTRING备注16 ZPStockBillEntry赠品出入库单据分录表FSourc

51、eEntryIDINTEGER源单分录内码16 ZPStockBillEntry赠品出入库单据分录表FAuxCommitQtyFLOAT辅助提交数量16 ZPStockBillEntry赠品出入库单据分录表FAuxQtyFLOAT数量16 ZPStockBillEntry赠品出入库单据分录表FCommitQtyFLOAT提交数量16 ZPStockBillEntry赠品出入库单据分录表FEntryIDINTEGER分录内码16 ZPStockBillEntry赠品出入库单据分录表FBatchNoSTRING批号16 ZPStockBillEntry赠品出入库单据分录表FBrNoSTRING16

52、 ZPStockBillEntry赠品出入库单据分录表FDCSPIDINTEGER仓位16 ZPStockBillEntry赠品出入库单据分录表FInterIDINTEGER单据内码16 ZPStockBillEntry赠品出入库单据分录表FKFDateDATETIME生产/采购日期16 ZPStockBillEntry赠品出入库单据分录表FKFPeriodINTEGER保质期16 ZPStockBillEntry赠品出入库单据分录表FMapNameSTRING对应名称16 ZPStockBillEntry赠品出入库单据分录表FMapNumberSTRING对应代码16 ZPStockBill

53、Entry赠品出入库单据分录表FQtyFLOAT基本单位数量16 ZPStockBillEntry赠品出入库单据分录表FUnitIDINTEGER单位内码17 t_LockStock锁库表FEntryIDINTEGER物料行号17 t_LockStock锁库表FIDINTEGER内码17 t_LockStock锁库表FInterIDINTEGER单据内码17 t_LockStock锁库表FStockIDINTEGER仓库内码17 t_LockStock锁库表FItemIDINTEGER物料内码17 t_LockStock锁库表FQtyFLOAT锁库数量17 t_LockStock锁库表FTra

54、nTypeINTEGER单据事务类型18 ICBillType单据类型表FIDINTEGER内码18 ICBillType单据类型表FNoteSTRING备注18 ICBillType单据类型表FSystemicINTEGER是否系统预设18 ICBillType单据类型表FAcctIDINTEGER会计科目18 ICBillType单据类型表FNameSTRING名称18 ICBillType单据类型表FNumberSTRING代码19 vwICBill_1外购入库（视图）FKFPeriodINTEGER保质期(天)19 vwICBill_1外购入库（视图）FamountFLOAT金额19

55、vwICBill_1外购入库（视图）FBatchNoSTRING批号19 vwICBill_1外购入库（视图）FcheckeridSTRING审核人19 vwICBill_1外购入库（视图）FSManagerIDSTRING保管19 vwICBill_1外购入库（视图）FCheckFlagSTRING审核标志19 vwICBill_1外购入库（视图）FCUQtyFLOAT常用单位实收数量19 vwICBill_1外购入库（视图）FauxpriceFLOAT单价19 vwICBill_1外购入库（视图）FBillNoSTRING单据号码19 vwICBill_1外购入库（视图）FUnitIDST

56、RING单位19 vwICBill_1外购入库（视图）FVchFlagSTRING记账标志19 vwICBill_1外购入库（视图）FCUUnitIDSTRING常用单位19 vwICBill_1外购入库（视图）FdateDATETIME日期19 vwICBill_1外购入库（视图）FEntryIDINTEGER单据分录号19 vwICBill_1外购入库（视图）FInterIDINTEGER赠品单据号码19 vwICBill_1外购入库（视图）FKFDateDATETIME生产/采购日期19 vwICBill_1外购入库（视图）FNoteSTRING备注19 vwICBill_1外购入库（视

57、图）FOrderInterIDSTRING采购订单号19 vwICBill_1外购入库（视图）FOrgBillInterIDSTRING拆单标志19 vwICBill_1外购入库（视图）FPOStyleSTRING采购方式19 vwICBill_1外购入库（视图）FQCRBillInterIDSTRING采购检验申请单号19 vwICBill_1外购入库（视图）FZPInterIDSTRING凭证编号19 vwICBill_1外购入库（视图）FSupplyIDSTRING供应商19 vwICBill_1外购入库（视图）FInvoiceInterIDSTRING购货发票号19 vwICBill_

58、1外购入库（视图）FMapNumberSTRING对应代码19 vwICBill_1外购入库（视图）FRelateBrIDSTRING供货机构19 vwICBill_1外购入库（视图）FRelationSTRING关联标志19 vwICBill_1外购入库（视图）FAuxPlanPriceFLOAT计划单价19 vwICBill_1外购入库（视图）FUnitGroupIDSTRING基本单位19 vwICBill_1外购入库（视图）FmodelSTRING规格型号19 vwICBill_1外购入库（视图）FPlanAmountFLOAT计划价金额19 vwICBill_1外购入库（视图）FQt

59、yFLOAT基本单位实收数量19 vwICBill_1外购入库（视图）FShortNumberSTRING物料代码19 vwICBill_1外购入库（视图）FauxqtyFLOAT实收数量19 vwICBill_1外购入库（视图）FBSCBillInterIDSTRING退料通知单号19 vwICBill_1外购入库（视图）FDCStockIDSTRING收料仓库19 vwICBill_1外购入库（视图）FAuxQtyMustFLOAT应收数量19 vwICBill_1外购入库（视图）FBillerIDSTRING制单19 vwICBill_1外购入库（视图）FCancellationSTRI

60、NG作废标志19 vwICBill_1外购入库（视图）FCUQtyMustFLOAT常用单位应收数量19 vwICBill_1外购入库（视图）FDCSPIDSTRING仓位19 vwICBill_1外购入库（视图）FFManagerIDSTRING验收19 vwICBill_1外购入库（视图）FHookFlagSTRING钩稽标志19 vwICBill_1外购入库（视图）FItemIDSTRING物料名称19 vwICBill_1外购入库（视图）FSCBillInterIDSTRING收料通知单号19 vwICBill_1外购入库（视图）FMapNameSTRING对应名称19 vwICBil