多阶投产投产结果表
Column Name | Description | Datatype | Length | Allow Nulls | |
---|---|---|---|---|---|
freeItem7 (T+12.3) | 自由项8 | nvarchar | 300 | True | |
ts (T+12.3) | 时间戳 | timestamp | 8 | False | |
idSourceUnit2 (T+12.3) | 来源计量单位2 | int | 4 | True | |
code (T+12.3) | 编号 | nvarchar | 30 | True | |
availablequantity (T+12.3) | 可用量 | decimal | 13 | True | |
idSourceUnit (T+12.3) | 来源计量单位 | int | 4 | True | |
StockRequestForReceiveQuantity (T+13.0) | 要货待入量 | decimal | 13 | True | |
openingquantity (T+12.3) | 期初库存可用量 | decimal | 13 | True | |
saleOrderCode (T+12.3) | 销售订单号 | nvarchar | 30 | True | |
RealLevel (T+12.3) | 实际级次 | int | 4 | True | |
freeItem0 (T+12.3) | 自由项1 | nvarchar | 300 | True | |
DelegateOrderForProductQuantity (T+12.3) | 委外待入量 | decimal | 13 | True | |
idunit2 (T+12.3) | 计量单位2ID | int | 4 | True | |
ForSaleDispatchQuantity (T+12.3) | 销售出库待出量 | decimal | 13 | True | |
name (T+12.3) | 名称 | nvarchar | 200 | True | |
saleOrderId (T+12.3) | 销售订单ID | int | 4 | True | |
StockRequestOnWayQuantity (T+12.3) | 要货在途量 | decimal | 13 | True | |
freeItem8 (T+12.3) | 自由项9 | nvarchar | 300 | True | |
computervoucherid (T+12.3) | 多阶投产选单数据ID | int | 4 | True | |
demandingDate (T+12.3) | 需求日期 | datetime | 8 | True | |
DistributionForReceiveQuantity (T+13.0) | 配货待入量 | decimal | 13 | True | |
idproject (T+12.3) | 项目ID | int | 4 | True | |
tempClosingQuantity (T+12.3) | 临时期末库存可用量 | decimal | 13 | True | |
sourceVoucherDetailId (T+12.3) | 来源单明细ID | int | 4 | True | |
createdtime (T+12.3) | 创建时间 | datetime | 8 | True | |
ManufactureForSendQuantity (T+12.3) | 生产待发量 | decimal | 13 | True | |
purchaseRequisitionQuantity (T+12.3) | 请购量 | decimal | 13 | True | |
freeItem6 (T+12.3) | 自由项7 | nvarchar | 300 | True | |
existingQuantity (T+12.3) | 现存量 | decimal | 13 | True | |
SaleOrderQuantity (T+12.3) | 销售订单数量 | decimal | 13 | True | |
PurchaseForReceiveQuantity (T+12.3) | 采购入库待入量 | decimal | 13 | True | |
PurchaseOrderOnWayQuantity (T+12.3) | 采购订单在途量 | decimal | 13 | True | |
isEnd (T+12.3) | 是否末级 | int | 4 | False | |
freeItem4 (T+12.3) | 自由项5 | nvarchar | 300 | True | |
MaterialForSendQuantity (T+12.3) | 材料待发量 | decimal | 13 | True | |
idinventory (T+12.3) | 存货ID | int | 4 | True | |
tempOpeningQuantity (T+12.3) | 临时期初库存可用量 | decimal | 13 | True | |
suggestionQuantity2 (T+12.3) | 建议量2 | decimal | 13 | True | |
tempbatchaq (T+12.3) | 临时批号可用量 | decimal | 13 | True | |
ProductForReceiveQuantity (T+12.3) | 产成品待入量 | decimal | 13 | True | |
unitExchangeRate (T+12.3) | 换算率 | decimal | 13 | True | |
safeQuantity (T+12.3) | 安全库存 | decimal | 13 | True | |
sortno (T+12.3) | 分配顺寻 | int | 4 | True | |
idunit (T+12.3) | 计量单位ID | int | 4 | True | |
idbom (T+12.3) | 物料清单ID | int | 4 | True | |
idsourcevouchertype (T+12.3) | 来源单据类型ID | int | 4 | True | |
DelegateForReceiveQuantity (T+12.3) | 委外入库待入量 | decimal | 13 | True | |
topQuantity (T+12.3) | 最好库存 | decimal | 13 | True | |
ManufactureQuantity (T+12.3) | 生产在产量 | decimal | 13 | True | |
idWarehouse (T+12.3) | 仓库ID | int | 4 | True | |
SaleDeliveryQuantity (T+12.3) | 销售待出量 | decimal | 13 | True | |
idbomchild (T+12.3) | 子物料清单ID | int | 4 | True | |
isIndependence (T+12.3) | 是否独立需求件 | tinyint | 1 | True | |
suggestionQuantity (T+12.3) | 建议量 | decimal | 13 | True | |
transOnWayQuantity (T+12.3) | 调拨在途量 | decimal | 13 | True | |
actualDemand2 (T+12.3) | 净需求2 | decimal | 13 | True | |
PurchaseArrivalQuantity (T+12.3) | 进货待入量 | decimal | 13 | True | |
otherOnWayQuantity (T+12.3) | 其他在途量 | decimal | 13 | True | |
mergetype (T+12.3) | 合并类型 | int | 4 | True | |
grossDemand (T+12.3) | 毛需求 | decimal | 13 | True | |
watchtime (T+12.3) | 监视时间 | datetime | 8 | True | |
actualDemand (T+12.3) | 净需求 | decimal | 13 | True | |
quantity (T+12.3) | 可用量 | decimal | 13 | True | |
closingquantity (T+12.3) | 期末库存可用量 | decimal | 13 | True | |
parentid (T+12.3) | 父节点ID | int | 4 | True | |
freeItem9 (T+12.3) | 自由项10 | nvarchar | 300 | True | |
idsourceinventory (T+12.3) | 来源存货ID | int | 4 | True | |
iduser (T+12.3) | 用户ID | int | 4 | True | |
sourceVoucherCode (T+12.3) | 来源单号 | nvarchar | 50 | True | |
freeItem2 (T+12.3) | 自由项3 | nvarchar | 300 | True | |
otherForDispatchQuantity (T+12.3) | 其他待发量 | decimal | 13 | True | |
sourceVoucherId (T+12.3) | 来源单ID | int | 4 | True | |
lowquantity (T+12.3) | 最低库存 | decimal | 13 | True | |
voucherTypeCode (T+12.3) | 单据类型编号 | nvarchar | 10 | True | |
freeItem1 (T+12.3) | 自由项2 | nvarchar | 300 | True | |
DelegateForDispatchQuantity (T+12.3) | 委外发料待发量 | decimal | 13 | True | |
VoucherCode (T+12.3) | 投产编号 | nvarchar | 50 | True | |
freeItem5 (T+12.3) | 自由项6 | nvarchar | 300 | True | |
sequencenumber (T+12.3) | 序号 | int | 4 | True | |
DelegateOrderForMaterialQuantity (T+12.3) | 委外待发量 | decimal | 13 | True | |
saleorderdetailid (T+12.3) | 销售订单明细ID | int | 4 | True | |
freeItem3 (T+12.3) | 自由项4 | nvarchar | 300 | True | |
DistributionForDispatchQuantity (T+13.0) | 配货待出量 | decimal | 13 | True | |
id (T+12.3) | ID | int | 4 | False | |
transForDispatchQuantity (T+12.3) | 调拨待发量 | decimal | 13 | True |
Copyright 2019 Chanjet Inc.