U8数据字典.docx

1、U8数据字典U8数据字典公共表ufmodelCurrentStock Table (ST 库存管理) Summary现存量汇总表Remark登记收发记录表时同时整理现存量表ColumnsColumn NameDescriptionDatatypeLengthAllow NullsAutoID自动编号int4FalsecWhCode仓库编码varchar10FalsecInvCode存货编码varchar20FalseiQuantity结存数量userdecimal13TruecFree5存货自由项5varchar20TruecFree6存货自由项6varchar20TruecFree7存货自由

2、项7varchar20TruecFree8存货自由项8varchar20TruecFree9存货自由项9varchar20TruecFree10存货自由项10varchar20TruecBatch批号varchar20TruedVDate失效日期datetime8TruebStopFlag库存是否冻结bit1TruefTransInQuantity调拨在途数量userdecimal13TruedMdate生产日期datetime8TruefTransInNum调拨在途辅计量数量userdecimal13TruefTransOutQuantity调拨待发数量userdecimal13TruefT

3、ransOutNum调拨待发辅计量数量userdecimal13TruefPlanQuantity计划备料数量userdecimal13TruefPlanNum计划备料辅计量数量userdecimal13TruefDisableQuantity不合格数量userdecimal13TruefDisableNum不合格辅计量数量userdecimal13TruefAvaQuantity可用数量userdecimal13TruefAvaNum可用辅计量数量userdecimal13Trueufts时间戳timestamp8TrueiMassDate保质期天数int4TrueBGSPSTOPGSP是否

4、冻结bit1TruecMassUnit保质期单位smallint2TruecMassUnitName保质期单位名称varchar2FalsefStopQuantity冻结数量userdecimal13TruefStopNum冻结件数userdecimal13TruedLastCheckDate最后检验日期datetime8TruecCheckState检验状态varchar4FalsedLastYearCheckDate上年最后检验日期datetime8TrueIndexesIndexDescriptionPrimaryUniqueaaaaaCurrentStock_PKCurrentStoc

5、k_indUnionKeySend feedbackCopyright 2004 UFSoft Inc.单据DispatchList Table (SA 销售管理) Summary发货退货单主表Remark发货单、退货单、委托代销发货单、委托代销发货退回、委托代销调整单ColumnsColumn NameDescriptionDatatypeLengthAllow NullsDLID发货退货单主表标识int4FalsecDLCode发货退货单号varchar30TruecVouchType单据类型编码varchar2FalsecSTCode销售类型编码varchar2FalsedDate单据日

6、期datetime8FalsecRdCode收发类别编码varchar5TruecDepCode部门编码varchar12FalsecPersonCode业务员编码varchar20TrueSBVID销售发票主表标识int4TruecSBVCode销售发票号varchar255TruecSOCode销售订单号varchar30TruecCusCode客户编码varchar20TruecPayCode付款条件编码varchar3TruecSCCode发运方式编码varchar2TruecShipAddress发往地址varchar200Truecexch_name币种名称varchar8Fals

7、eiExchRate汇率float8FalseiTaxRate表头税率float8TruebFirst销售期初标志bit1FalsebReturnFlag退货标志bit1FalsebSettleAll结算标志bit1FalsecMemo备注varchar60TruecSaleOut出库单据号字符串varchar255TruecDefine1自定义项1varchar20TruecDefine2自定义项2varchar20TruecDefine3自定义项3varchar20TruecDefine4自定义项4datetime8TruecDefine5自定义项5int4TruecDefine6自定义项

8、6datetime8TruecDefine7自定义项7float8TruecDefine8自定义项8varchar4TruecDefine9自定义项9varchar8TruecDefine10自定义项10varchar60TruecVerifier审核人varchar20TruecMaker制单人varchar20TrueiNetLock现无用real4TrueiSale是否先发货smallint2TruecCusName客户名称varchar120TrueiVTid单据模版号int4Falseufts时间戳timestamp8TruecBusType业务类型varchar8TruecClos

9、er关闭人varchar20TruecAccounter记账人varchar20TruecCreChpName信用审核人varchar20TruecDefine11自定义项11varchar120TruecDefine12自定义项12varchar120TruecDefine13自定义项13varchar120TruecDefine14自定义项14varchar120TruecDefine15自定义项15int4TruecDefine16自定义项16float8TruebIAFirst存货期初标志bit1TrueIndexesIndexDescriptionPrimaryUniqueaaaaa

10、DispatchList_PKcDLCodeCodeCustomerDispatchListDepartmentDispatchListforeigncurrencyDispatchListIdx_dispatchlist_ddatePayConditionDispatchListPersonDispatchListRd_StyleDispatchListSaleTypeDispatchListSBVIDShippingChoiceDispatchListDispatchLists Table (SA 销售管理) Summary发货退货单子表Remark发货单、退货单、委托代销发货单、委托代销

11、发货退回、委托代销调整单ColumnsColumn NameDescriptionDatatypeLengthAllow NullsAutoID发货退货单子表标识int4FalseDLID发货退货单主表标识int4FalseiCorID原发货退货单子表标识int4TruecWhCode仓库编码varchar10TruecInvCode存货编码varchar20FalseiQuantity数量float8TrueiNum辅计量数量float8TrueiQuotedPrice报价float8TrueiUnitPrice原币无税单价float8TrueiTaxUnitPrice原币含税单价float

12、8TrueiMoney原币无税金额money8TrueiTax原币税额money8TrueiSum原币价税合计money8TrueiDisCount原币折扣额money8TrueiNatUnitPrice本币无税单价float8TrueiNatMoney本币无税金额money8TrueiNatTax本币税额money8TrueiNatSum本币价税合计money8TrueiNatDisCount本币折扣额money8TrueiSettleNum累计结算金额float8TrueiSettleQuantity开票数量float8TrueiBatch批次int4TruecBatch批号varchar

13、20TruebSettleAll结算标志bit1FalsecMemo备注varchar60TruecFree1存货自由项1varchar20TruecFree2存货自由项2varchar20TrueiTB退补标志tinyint1TruedvDate失效日期datetime8TrueTBQuantity退补数量real4TrueTBNum退补辅计量数量real4TrueiSOsID销售订单子表标识int4TrueiDLsID发货退货单子表标识2int4FalseKL扣率float8TrueKL2二次扣率float8TruecInvName存货名称varchar60TrueiTaxRate税率fl

14、oat8TruecDefine22表体自定义项22varchar60TruecDefine23表体自定义项23varchar60TruecDefine24表体自定义项24varchar60TruecDefine25表体自定义项25varchar60TruecDefine26表体自定义项26float8TruecDefine27表体自定义项27float8TruefOutQuantity累计出库数量float8TruefOutNum累计出库辅计量数量float8TruecItemCode项目编码varchar20TruecItem_class项目大类编码varchar10TruefSaleCos

15、t零售单价float8TruefSalePrice零售金额float8TruecVenAbbName供应商简称varchar60TruecItemName项目名称varchar60TruecItem_CName项目大类名称varchar20TruecFree3存货自由项3varchar20TruecFree4存货自由项4varchar20TruecFree5存货自由项5varchar20TruecFree6存货自由项6varchar20TruecFree7存货自由项7varchar20TruecFree8存货自由项8varchar20TruecFree9存货自由项9varchar20Truec

16、Free10存货自由项10varchar20TruebIsSTQc库存期初标记bit1TrueiInvExchRate换算率userdecimal13TruecUnitID计量单位编码varchar10TruecCode出库单据号varchar30TrueiRetQuantity退货数量userdecimal13TruefEnSettleQuan委托结算数量userdecimal13TruefEnSettleSum委托结算辅计量数量money8TrueiSettlePrice结算单价float8TruecDefine28表体自定义项28varchar120TruecDefine29表体自定义项

17、29varchar120TruecDefine30表体自定义项30varchar120TruecDefine31表体自定义项31varchar120TruecDefine32表体自定义项32varchar120TruecDefine33表体自定义项33varchar120TruecDefine34表体自定义项34int4TruecDefine35表体自定义项35int4TruecDefine36表体自定义项36datetime8TruecDefine37表体自定义项37datetime8TruedMDate生产日期datetime8TruebGsp是否质检bit1TruecGspState质检

18、状态varchar20TruecSoCode销售订单号varchar30TruecCorCode（暂时不用）varchar30TrueiPPartSeqIDPTO母件顺序号int4TrueiPPartID母件物料IDint4TrueiPPartQty母件数量userdecimal13TruecContractID合同号varchar64TruecContractTagCode合同标的varchar64TruecContractRowGuid合同cGuiduniqueidentifier16TrueiMassDate保质期int4TruecMassUnit保值期单位smallint2TruebQ

19、ANeedCheck是否质检bit1FalsebQAUrgency是否急料bit1FalsebQAChecking是否在检bit1FalsebQAChecked是否报检bit1FalseiQAQuantity检验合格数量float8TrueiQANum检验合格件数float8TruecCusInvCode客户存货编码varchar40TruecCusInvName客户存货名称varchar100TrueIndexesIndexDescriptionPrimaryUniqueaaaaaDispatchLists_PKDisp_iSOsIDDispatchListDispatchListsiCor

20、IDiDLsIDInventoryDispatchListsWarehouseDispatchListsTriggersTriggerDescriptiondbo.SA_DispsDELTrigdbo.SA_DispsINSTrigdbo.SA_DispsUPSTrigRdRecord Table (ST 库存管理) Summary收发记录主表Remark采购入库单、产成品入库单、销售出库单、材料出库单、其他入库单、其他出库单、库存期初ColumnsColumn NameDescriptionDatatypeLengthAllow NullsID收发记录主表标识int4FalsebRdFlag收发标志int4FalsecVouchType单据类型编码varchar2FalsecBusType业务类型varchar12TruecSource单据来源varchar50FalsecBusCode对应业务单号varchar30TruecWhCode仓库编码varchar10FalsedDate单据日期datetime8FalsecCode收发单据号varchar30FalsecRdCode收发类别编码varchar5True