U8数据字典课案.doc

公共表 ufmodel CurrentStock Table ?(ST 库存管理) Summary 现存量汇总表 Remark 登记收发记录表时同时整理现存量表 Columns ? Column Name Description Datatype Length Allow Nulls ? AutoID 自动编号? int 4? False? ? cWhCode 仓库编码? varchar 10? False? ? cInvCode 存货编码? varchar 20? False? ? iQuantity 结存数量? userdecimal 13? True? ? iNum 结存辅计量数量? userdecimal 13? True? ? cFree1 存货自由项1? varchar 20? True? ? cFree2 存货自由项2? varchar 20? True? ? fOutQuantity 待发货数量? userdecimal 13? True? ? fOutNum 待发货辅计量数量? userdecimal 13? True? ? fInQuantity 待入库数量? userdecimal 13? True? ? fInNum 待入库辅计量数量? userdecimal 13? True? ? cFree3 存货自由项3? varchar 20? True? ? cFree4 存货自由项4? varchar 20? True? ? cFree5 存货自由项5? varchar 20? True? ? cFree6 存货自由项6? varchar 20? True? ? cFree7 存货自由项7? varchar 20? True? ? cFree8 存货自由项8? varchar 20? True? ? cFree9 存货自由项9? varchar 20? True? ? cFree10 存货自由项10? varchar 20? True? ? cBatch 批号? varchar 20? True? ? dVDate 失效日期? datetime 8? True? ? bStopFlag 库存是否冻结? bit 1? True? ? fTransInQuantity 调拨在途数量? userdecimal 13? True? ? dMdate 生产日期? datetime 8? True? ? fTransInNum 调拨在途辅计量数量? userdecimal 13? True? ? fTransOutQuantity 调拨待发数量? userdecimal 13? True? ? fTransOutNum 调拨待发辅计量数量? userdecimal 13? True? ? fPlanQuantity 计划备料数量? userdecimal 13? True? ? fPlanNum 计划备料辅计量数量? userdecimal 13? True? ? fDisableQuantity 不合格数量? userdecimal 13? True? ? fDisableNum 不合格辅计量数量? userdecimal 13? True? ? fAvaQuantity 可用数量? userdecimal 13? True? ? fAvaNum 可用辅计量数量? userdecimal 13? True? ? ufts 时间戳? timestamp 8? True? ? iMassDate 保质期天数? int 4? True? ? BGSPSTOP GSP是否冻结? bit 1? True? ? cMassUnit 保质期单位? smallint 2? True? ? cMassUnitName 保质期单位名称? varchar 2? False? ? fStopQuantity 冻结数量? userdecimal 13? True? ? fStopNum 冻结件数? userdecimal 13? True? ? dLastCheckDate 最后检验日期? datetime 8? True? ? cCheckState 检验状态? varchar 4? False? ? dLastYearCheckDate 上年最后检验日期? datetime 8? True? Indexes Index Description Primary Unique aaaaaCurrentStock_PK ? CurrentStock_ind ? UnionKey ? Send feedback Copyright