U8数据字典.doc

公共表ufmodelCurrentStock Table (ST 库存管理) Summary现存量汇总表Remark登记收发记录表时同时整理现存量表ColumnsColumn NameDescriptionDatatypeLengthAllow NullsAutoID自动编号int4FalsecWhCode仓库编码varchar10FalsecInvCode存货编码varchar20FalseiQuantity结存数量userdecimal13TrueiNum结存辅计量数量userdecimal13TruecFree1存货自由项1varchar20TruecFree2存货自由项2varchar20TruefOutQuantity待发货数量userdecimal13TruefOutNum待发货辅计量数量userdecimal13TruefInQuantity待入库数量userdecimal13TruefInNum待入库辅计量数量userdecimal13TruecFree3存货自由项3varchar20TruecFree4存货自由项4varchar20TruecFree5存货自由项5varchar20TruecFree6存货自由项6varchar20TruecFree7存货自由项7varchar20TruecFree8存货自由项8varchar20TruecFree9存货自由项9varchar20TruecFree10存货自由项10varchar20TruecBatch批号varchar20TruedVDate失效日期datetime8TruebStopFlag库存是否冻结bit1TruefTransInQuantity调拨在途数量userdecimal13TruedMdate生产日期datetime8TruefTransInNum调拨在途辅计量数量userdecimal13TruefTransOutQuantity调拨待发数量userdecimal13TruefTransOutNum调拨待发辅计量数量userdecimal13TruefPlanQuantity计划备料数量userdecimal13TruefPlanNum计划备料辅计量数量userdecimal13TruefDisableQuantity不合格数量userdecimal13TruefDisableNum不合格辅计量数量userdecimal13TruefAvaQuantity可用数量userdecimal13TruefAvaNum可用辅计量数量userdecimal13Trueufts时间戳timestamp8TrueiMassDate保质期天数int4TrueBGSPSTOPGSP是否冻结bit1TruecMassUnit保质期单位smallint2TruecMassUnitName保质期单位名称varchar2FalsefStopQuantity冻结数量userdecimal13TruefStopNum冻结件数userdecimal13TruedLastCheckDate最后检验日期datetime8TruecCheckState检验状态varchar4FalsedLastYearCheckDate上年最后检验日期datetime8TrueIndexesIndexDescriptionPrimaryUniqueaaaaaCurrentStock_PKCurrentStock_indUnionKeySend feedbackCopyright 2004 UFSoft Inc.单据DispatchList Table (SA 销售管理) Summary发货退货单主表Remark发货单、退货单、委托代销发货单、委托代销发货退回、委托代销调整单ColumnsColumn NameDescriptionDatatypeLengthAllow NullsDLID发货退货单主表标识int4FalsecDLCode发货退货单号varchar30TruecVouchType单据类型编码varchar2FalsecSTCode销售类型编码varchar2FalsedDate单据日期datetime8FalsecRdCode收发类别编码varchar5TruecDepCode部门编码varchar12FalsecPersonCode业务员编码varchar20TrueSBVID销售发票主表标识int4TruecSBVCode销售发票号varchar255TruecSOCode销售订单号varchar30TruecCusCode客户编码varchar20TruecPayCode付款条件编码varchar3TruecSCCode发运方式编码varchar2TruecShipAddress发往地址varchar200Truecexch_name币种名称varchar8FalseiExchRate汇率float8FalseiTaxRate表头税率float8TruebFirst销售期初标志bit1FalsebReturnFlag退货标志bit1FalsebSettleAll结算标志bit1FalsecMemo备注varchar60TruecSaleOut出库单据号字符串varchar255TruecDefine1自定义项1varchar20TruecDefine2自定义项2varchar20TruecDefine3自定义项3varchar20TruecDefine4自定义项4datetime8TruecDefine5自定义项5int4TruecDefine6自定义项6datetime8TruecDefine7自定义项7float8TruecDefine8自定义项8varchar4TruecDefine9自定义项9varchar8TruecDefine10自定义项10varchar60TruecVerifier审核人varchar20TruecMaker制单人varchar20TrueiNetLock现无用real4TrueiSale是否先发货smallint2TruecCusName客户名称varchar120TrueiVTid单据模版号int4Falseufts时间戳timestamp8TruecBusType业务类型varchar8TruecCloser关闭人varchar20TruecAccounter记账人varchar20TruecCreChpName信用审核人varchar20TruecDefine11自定义项11varchar120TruecDefine12自定义项12varchar120TruecDefine13自定义项13varchar120TruecDefine14自定义项14varchar120TruecDefine15自定义项15int4TruecDefine16自定义项16float8TruebIAFirst存货期初标志bit1TrueIndexesIndexDescriptionPrimaryUniqueaaaaaDispatchList_PKcDLCodeCodeCustomerDispatchListDepartmentDispatchListforeigncurrencyDispatchListIdx_dispatchlist_ddatePayConditionDispatchListPersonDispatchListRd_StyleDispatchListSaleTypeDispatchListSBVIDShippingChoiceDispatchListDispatchLists Table (SA 销售管理) Summary发货退货单子表Remark发货单、退货单、委托代销发货单、委托代销发货退回、委托代销调整单ColumnsColumn NameDescriptionDatatypeLengthAllow NullsAutoID发货退货单子表标识int4FalseDLID发货退货单主表标识int4FalseiCorID原发货退货单子表标识int4TruecWhCode仓库编码varchar10TruecInvCode存货编码varchar20FalseiQuantity数量float8TrueiNum辅计量数量float8TrueiQuotedPrice报价float8TrueiUnitPrice原币无税单价float8TrueiTaxUnitPrice原币含税单价float8TrueiMoney原币无税金额money8TrueiTax原币税额money8TrueiSum原币价税合计money8TrueiDisCount原币折扣额money8TrueiNatUnitPrice本币无税单价float8TrueiNatMoney本币无税金额money8TrueiNatTax本币税额money8TrueiNatSum本币价税合计money8TrueiNatDisCount本币折扣额money8TrueiSettleNum累计结算金额float8TrueiSettleQuantity开票数量float8TrueiBatch批次int4TruecBatch批号varchar20TruebSettleAll结算标志bit1FalsecMemo备注varchar60TruecFree1存货自由项1varchar20TruecFree2存货自由项2varchar20TrueiTB退补标志tinyint1TruedvDate失效日期datetime8TrueTBQuantity退补数量real4TrueTBNum退补辅计量数量real4TrueiSOsID销售订单子表标识int4TrueiDLsID发货退货单子表标识2int4FalseKL扣率float8TrueKL2二次扣率float8TruecInvName存货名称varchar60TrueiTaxRate税率float8TruecDefine22表体自定义项22varchar60TruecDefine23表体自定义项23varchar60TruecDefine24表体自定义项24varchar60TruecDefine25表体自定义项25varchar60TruecDefine26表体自定义项26float8TruecDefine27表体自定义项27float8TruefOutQuantity累计出库数量float8TruefOutNum累计出库辅计量数量float8TruecItemCode项目编码varchar20TruecItem_class项目大类编码varchar10TruefSaleCost零售单价float8TruefSalePrice零售金额float8TruecVenAbbName供应商简称varchar60TruecItemName项目名称varchar60TruecItem_CName项目大类名称varchar20TruecFree3存货自由项3varchar20TruecFree4存货自由项4varchar20TruecFree5存货自由项5varchar20TruecFree6存货自由项6varchar20TruecFree7存货自由项7varchar20TruecFree8存货自由项8varchar20TruecFree9存货自由项9varchar20TruecFree10存货自由项10varchar20TruebIsSTQc库存期初标记bit1TrueiInvExchRate换算率userdecimal13TruecUnitID计量单位编码varchar10TruecCode出库单据号varchar30TrueiRetQuantity退货数量userdecimal13TruefEnSettleQuan委托结算数量userdecimal13TruefEnSettleSum委托结算辅计量数量money8TrueiSettlePrice结算单价float8TruecDefine28表体自定义项28varchar120TruecDefine29表体自定义项29varchar120TruecDefine30表体自定义项30varchar120TruecDefine31表体自定义项31varchar120TruecDefine32表体自定义项32varchar120TruecDefine33表体自定义项33varchar120TruecDefine34表体自定义项34int4TruecDefine35表体自定义项35int4TruecDefine36表体自定义项36datetime8TruecDefine37表体自定义项37datetime8TruedMDate生产日期datetime8TruebGsp是否质检bit1TruecGspState质检状态varchar20TruecSoCode销售订单号varchar30TruecCorCode（暂时不用）varchar30TrueiPPartSeqIDPTO母件顺序号int4TrueiPPartID母件物料IDint4TrueiPPartQty母件数量userdecimal13TruecContractID合同号varchar64TruecContractTagCode合同标的varchar64TruecContractRowGuid合同cGuiduniqueidentifier16TrueiMassDate保质期int4TruecMassUnit保值期单位smallint2TruebQANeedCheck是否质检bit1FalsebQAUrgency是否急料bit1FalsebQAChecking是否在检bit1FalsebQAChecked是否报检bit1FalseiQAQuantity检验合格数量float8TrueiQANum检验合格件数float8TruecCusInvCode客户存货编码varchar40TruecCusInvName客户存货名称varchar100TrueIndexesIndexDescriptionPrimaryUniqueaaaaaDispatchLists_PKDisp_iSOsIDDispatchListDispatchListsiCorIDiDLsIDInventoryDispatchListsWarehouseDispatchListsTriggersTriggerDescriptiondbo.SA_DispsDELTrigdbo.SA_DispsINSTrigdbo.SA_DispsUPSTrigRdRecord Table (ST 库存管理) Summary收发记录主表Remark采购入库单、产成品入库单、销售出库单、材料出库单、其他入库单、其他出库单、库存期初ColumnsColumn NameDescriptionDatatypeLengthAllow NullsID收发记录主表标识int4FalsebRdFlag收发标志int4FalsecVouchType单据类型编码varchar2FalsecBusType业务类型varchar12TruecSource单据来源varchar50FalsecBusCode对应业务单号varchar30TruecWhCode仓库编码varchar10FalsedDate单据日期datetime8FalsecCode收发单据号varchar30FalsecRdCode收发类别编码varchar5TruecDepCode部门编码varchar12TruecPersonCode业务员编码varchar20TruecPTCode采购类型编码varchar2TruecSTCode销售类型编码varchar2TruecCusCode客户编码varchar20TruecVenCode供应商编码varchar20TruecOrderCode采购订单号varchar30TruecARVCode采购到货单号varchar30TruecBillCode发票主表标识int4TruecDLCode发货退货单主表标识int4TruecProBatch生产批号varchar50TruecHandler审核人varchar20TruecMemo备注varchar60TruebTransFlag是否传递bit1FalsecAccounter记账人varchar20TruecMaker制单人varchar20TrueiNetLock现无用real4TruecDefine1自定义项1varchar20TruecDefine2自定义项2varchar20TruecDefine3自定义项3varchar20TruecDefine4自定义项4datetime8TruecDefine5自定义项5int4TruecDefine6自定义项6datetime8TruecDefine7自定义项7float8TruecDefine8自定义项8varchar4TruecDefine9自定义项9varchar8TruecDefine10自定义项10varchar60TruedKeepDate记账日期varchar5TruedVeriDate审核日期datetime8Truebpufirst采购期初标志bit1Truebiafirst存货期初标志bit1TrueiMQuantity产量float8TruedARVDate到货日期datetime8TruecChkCode检验单号varchar30TruedChkDate检验日期datetime8TruecChkPerson检验员varchar40TrueVT_ID单据模版号int4TruebIsSTQc库存期初标志bit1FalsecDefine11自定义项11varchar120TruecDefine12自定义项12varchar120TruecDefine13自定义项13varchar120TruecDefine14自定义项14varchar120TruecDefine15自定义项15int4TruecDefine16自定义项16float8TruecPsPcode父项产品编码varchar20TruecMPoCode生产订单编号varchar30Truegspcheck是否自检varchar10Trueipurorderid采购订单主表标识int4Trueipurarriveid采购到货单主表标识int4Trueiproorderid生产订单主表标识int4Trueiarriveid发货退货单号varchar30Trueisalebillid发票号varchar30Trueufts时间戳timestamp8TrueiTaxRate税率decimal13TrueiExchRate汇率float8TruecExch_Name币种名称varchar8TruecShipAddress发货地址varchar200TruebOMFirst委外期初bit1TrueIndexesIndexDescriptionPrimaryUniqueaaaaaRdRecord_PKaaRdRecord_PKbRdFlagcARVCodecBillCodecBusCodecBusTypecCodecDLCodecOrderCodeCustomerRdRecordcVouchTypedDateDepartmentRdRecordPersonRdRecordPurchaseTypeRdRecordRd_StyleRdRecordSaleTypeRdRecordVendorRdRecordWarehouseRdRecordRdRecords Table (ST 库存管理) Summary收发记录子表Remark采购入库单、产成品入库单、销售出库单、材料出库单、其他入库单、其他出库单、库存期初ColumnsColumn NameDescriptionDatatypeLengthAllow NullsAutoID收发记录子表标识int4FalseID收发记录主表标识int4FalsecInvCode存货编码varchar20FalseiNum辅计量数量float8TrueiQuantity数量float8TrueiUnitCost单价float8TrueiPrice金额money8TrueiAPrice暂估金额money8TrueiPUnitCost计划价或售价float8TrueiPPrice计划金额或售价金额money8TruecBatch批号varchar20TruecObjCode成本对象编码varchar12TruecVouchCode对应入库单子表标识varchar10TruecFree1存货自由项1varchar20TruecFree2存货自由项2varchar20TrueiFlag标志tinyint1FalsedSDate结算日期datetime8TrueiTax税额money8TrueiSQuantity累计结算数量float8TrueiSNum累计结算辅计量数量float8TrueiMoney累计结算金额money8TrueiSOutQuantity累计出库数量float8TrueiSOutNum累计出库辅计量数量float8TrueiFNum实际辅计量数量float8TrueiFQuantity实际数量float8TruedVDate失效日期datetime8TrueiTrIds库存调拨单子表标识int4TruecPosition货位编码varchar20TruecDefine22表体自定义项22varchar60TruecDefine23表体自定义项23varchar60TruecDefine24表体自定义项24varchar60TruecDefine25表体自定义项25varchar60TruecDefine26表体自定义项26float8TruecDefine27表体自定义项27float8TruecItem_class项目大类编码varchar10TruecItemCode项目编码varchar20TrueiPOsID采购订单子表标识int4TruefACost暂估单价float8TrueiDLsID发货退货单子表标识int4TrueiSBsID发票子表标识int4TrueiSendQuantity本次发货数量float8TrueiSendNum本次发货辅计量数量float8TruecName项目名称varchar60TruecItemCName项目大类名称varchar20TrueiEnsID委托代销发货单子表标识int4TruecFree3存货自由项3varchar20TruecFree4存货自由项4varchar20TruecFree5存货自由项5varchar20TruecFree6存货自由项6varchar20TruecFree7存货自由项7varchar20TruecFree8存货自由项8varchar20TruecFree9存货自由项9varchar20TruecFree10存货自由项10varchar20TruecBarCode对应条形码编码varchar200TrueiNQuantity应收应发数量float8TrueiNNum应收应发辅计量数量float8TruecAssUnit辅计量单位编码varchar10TruedMadeDate生产日期datetime8TrueiMassDate保质期天数int4TruecDefine28表体自定义项28varchar120TruecDefine29表体自定义项29varchar120TruecDefine30表体自定义项30varchar120TruecDefine31表体自定义项31varchar120TruecDefine32表体自定义项32varchar120TruecDefine33表体自定义项33varchar120TruecDefine34表体自定义项34int4TruecDefine35表体自定义项35int4TruecDefine36表体自定义项36datetime8TruecDefine37表体自定义项37datetime8TrueiMPoIds生产订单子表标识int4TrueiCheckIds检验单子表标识int4TruecBVencode供应商编码varchar20TruecInVouchCode对应入库单号varchar30TruebGsp是否质检bit1TruecGspState质检状态varchar20TrueiArrsId采购到货单子表标识int4TruecCheckCode检验单号varchar30TrueiCheckIdBaks检验单子表IDint4TruecRejectCode不良品处理单号varchar30TrueiRejectIds不良品处理单IDint4TruecCheckPersonCode检验员varchar20TruedCheckDate检验日期datetime8TrueiOriTaxCost原币含税单价decimal13TrueiOriCost原币无税单价decimal13TrueiOriMoney原币无税金额money8TrueiOriTaxPrice原币税额money8TrueioriSum原币价税合计money8TrueiTaxRate税率decimal13TrueiTaxPrice本币税额money8TrueiSum本币价税合计money8TruebTaxCost记税方式bit1TruecPOID订单号varchar30TruecMassUnit保质期单位smallint2TruecMoLotCode生产批号生产批号生产批号varchar50TrueiRefundInspectFlag是否已经生成退货报检单1：生成,0:没有生成int4TrueiMaterialFee材料费money8TrueiProcessCost加工费单价money8TrueiProcessFee加工费money8TruedMSDate核销日期datetime8TrueiSMaterialFee累计结算材料费money8TrueiSProcessFee累计结算加工费money8TrueiOMoDID委外订单子表IDint4TrueiSoDID销售订单子表IDint4TruestrContractId合同标标识varchar64TruestrCode合同号varchar64TruebFilled否已经盘点补差int4TruebChecked销售出库单是否报检bit1TruebRelated是否为联副产品bit1TrueiOMoMID委外订单用料表IDint4TrueIndexesIndexDescriptionPrimaryUniqueaaaaaRdRecords_PKaaRdRecords_PKCostObjRdRecordscpositionidlsidiFlagInventoryRdRecordsiSBsIDRdRecordRdRecordsST_AppTransVouch Table (ST 库存管理) Summary调拨申请单主表RemarkU860新增单据.ColumnsColumn NameDescriptionDatatypeLength