《U8数据字典.doc》由会员分享，可在线阅读，更多相关《U8数据字典.doc（27页珍藏版）》请在金锄头文库上搜索。
1、公共表ufmodelCurrentStock Table (ST 库存管理) Summary现存量汇总表Remark登记收发记录表时同时整理现存量表ColumnsColumn NameDescriptionDatatypeLengthAllow NullsAutoID自动编号int4FalsecWhCode仓库编码varchar10FalsecInvCode存货编码varchar20FalseiQuantity结存数量userdecimal13TrueiNum结存辅计量数量userdecimal13TruecFree1存货自由项1varchar20TruecFree2存货自由项2varchar
2、20TruefOutQuantity待发货数量userdecimal13TruefOutNum待发货辅计量数量userdecimal13TruefInQuantity待入库数量userdecimal13TruefInNum待入库辅计量数量userdecimal13TruecFree3存货自由项3varchar20TruecFree4存货自由项4varchar20TruecFree5存货自由项5varchar20TruecFree6存货自由项6varchar20TruecFree7存货自由项7varchar20TruecFree8存货自由项8varchar20TruecFree9存货自由项9va
3、rchar20TruecFree10存货自由项10varchar20TruecBatch批号varchar20TruedVDate失效日期datetime8TruebStopFlag库存是否冻结bit1TruefTransInQuantity调拨在途数量userdecimal13TruedMdate生产日期datetime8TruefTransInNum调拨在途辅计量数量userdecimal13TruefTransOutQuantity调拨待发数量userdecimal13TruefTransOutNum调拨待发辅计量数量userdecimal13TruefPlanQuantity计划备料数
4、量userdecimal13TruefPlanNum计划备料辅计量数量userdecimal13TruefDisableQuantity不合格数量userdecimal13TruefDisableNum不合格辅计量数量userdecimal13TruefAvaQuantity可用数量userdecimal13TruefAvaNum可用辅计量数量userdecimal13Trueufts时间戳timestamp8TrueiMassDate保质期天数int4TrueBGSPSTOPGSP是否冻结bit1TruecMassUnit保质期单位smallint2TruecMassUnitName保质期单
5、位名称varchar2FalsefStopQuantity冻结数量userdecimal13TruefStopNum冻结件数userdecimal13TruedLastCheckDate最后检验日期datetime8TruecCheckState检验状态varchar4FalsedLastYearCheckDate上年最后检验日期datetime8TrueIndexesIndexDescriptionPrimaryUniqueaaaaaCurrentStock_PKCurrentStock_indUnionKeySend feedbackCopyright 2004 UFSoft Inc.单据
6、DispatchList Table (SA 销售管理) Summary发货退货单主表Remark发货单、退货单、委托代销发货单、委托代销发货退回、委托代销调整单ColumnsColumn NameDescriptionDatatypeLengthAllow NullsDLID发货退货单主表标识int4FalsecDLCode发货退货单号varchar30TruecVouchType单据类型编码varchar2FalsecSTCode销售类型编码varchar2FalsedDate单据日期datetime8FalsecRdCode收发类别编码varchar5TruecDepCode部门编码va
7、rchar12FalsecPersonCode业务员编码varchar20TrueSBVID销售发票主表标识int4TruecSBVCode销售发票号varchar255TruecSOCode销售订单号varchar30TruecCusCode客户编码varchar20TruecPayCode付款条件编码varchar3TruecSCCode发运方式编码varchar2TruecShipAddress发往地址varchar200Truecexch_name币种名称varchar8FalseiExchRate汇率float8FalseiTaxRate表头税率float8TruebFirst销售期
8、初标志bit1FalsebReturnFlag退货标志bit1FalsebSettleAll结算标志bit1FalsecMemo备注varchar60TruecSaleOut出库单据号字符串varchar255TruecDefine1自定义项1varchar20TruecDefine2自定义项2varchar20TruecDefine3自定义项3varchar20TruecDefine4自定义项4datetime8TruecDefine5自定义项5int4TruecDefine6自定义项6datetime8TruecDefine7自定义项7float8TruecDefine8自定义项8varc
9、har4TruecDefine9自定义项9varchar8TruecDefine10自定义项10varchar60TruecVerifier审核人varchar20TruecMaker制单人varchar20TrueiNetLock现无用real4TrueiSale是否先发货smallint2TruecCusName客户名称varchar120TrueiVTid单据模版号int4Falseufts时间戳timestamp8TruecBusType业务类型varchar8TruecCloser关闭人varchar20TruecAccounter记账人varchar20TruecCreChpNam
10、e信用审核人varchar20TruecDefine11自定义项11varchar120TruecDefine12自定义项12varchar120TruecDefine13自定义项13varchar120TruecDefine14自定义项14varchar120TruecDefine15自定义项15int4TruecDefine16自定义项16float8TruebIAFirst存货期初标志bit1TrueIndexesIndexDescriptionPrimaryUniqueaaaaaDispatchList_PKcDLCodeCodeCustomerDispatchListDepartmentDispatchListforeigncurrencyDispatchListIdx_dispatchlist_ddatePayConditionDispatchListPersonDispatchListRd_StyleDispatchListSaleTypeDispatchListSBVIDShippingChoiceDispatchListDispatchLists Table (SA 销售管理) Summary发货退货单子表Remark发货单、退货单、委托代销发货单、委托代销发货
