多阶投产投产结果表
| 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 | |
| IdVoucher (T+16.0) | 单据ID | int | 4 | 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 | |
| PurchasePlanQuantity (T+16.0) | 采购计划量 | 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 | |
| ManufacturePlanQuantityOccupy (T+16.0) | 生产计划占用量 | 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 | |
| OutSourcePlanQuantity (T+16.0) | 委外计划量 | 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 | |
| IdRealParent (T+16.0) | 父ID | int | 4 | True | |
| suggestionQuantity2 (T+12.3) | 建议量2 | decimal | 13 | True | |
| operationDate (T+16.0) | 操作时间 | datetime | 8 | 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 | |
| ManufacturePlanQuantity (T+16.0) | 生产计划量 | decimal | 13 | True | |
| RetailOccupyQuantity (T+16.0) | 零售占用量 | decimal | 13 | 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 | |
| idBomRelation (T+16.0) | 子件BOM关系 | 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 | |
| RetailOnWayQuantity (T+16.0) | 零售占用量 | decimal | 13 | 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 | |
| IdBomRelationParent (T+16.0) | 父件BOMID | int | 4 | True | |
| freeItem2 (T+12.3) | 自由项3 | nvarchar | 300 | True | |
| otherForDispatchQuantity (T+12.3) | 其他待发量 | decimal | 13 | True | |
| RequirementAttribute (T+16.0) | 需求件属性 | int | 4 | 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 | |
| suggestionType (T+16.0) | 建议类型 | int | 4 | 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 | |
| OutSourcePlanQuantityOccupy (T+16.0) | 委外计划占用量 | 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 2016 Chanjet Inc.