可用量计算
Column Name | Description | Datatype | Length | Allow Nulls | |
---|---|---|---|---|---|
SafeLowQuantity (T+12.3) | 安全库存 | decimal | 13 | True | |
TransOnWayQuantity (T+12.3) | 调拨在途量 | decimal | 13 | True | |
CurrentUserId (T+12.3) | 当前用户ID | nvarchar | 50 | False | |
ProductForReceiveQuantity (T+12.3) | 产成品待入量 | decimal | 13 | True | |
TransForDispatchQuantity (T+12.3) | 调拨待出量 | decimal | 13 | True | |
OtherForDispatchQuantity (T+12.3) | 其他待出量 | decimal | 13 | True | |
DelegateOrderForProductQuantity (T+12.3) | 委外待入量 | decimal | 13 | True | |
DelegateOrderForMaterialQuantity (T+12.3) | 委外待发量 | decimal | 13 | True | |
ForSaleDispatchQuantity (T+12.3) | 销售出库待出量 | decimal | 13 | True | |
DistributionForDispatchQuantity (T+13.0) | 配货待发量 | decimal | 13 | True | |
DistributionForReceiveQuantity (T+13.0) | 配货待入量 | decimal | 13 | True | |
SaleDeliveryQuantity (T+12.3) | 销售待出量 | decimal | 13 | True | |
CanUseQuantity (T+12.3) | 计算后的可用量 | decimal | 13 | True | |
ForSaleOrderQuantity (T+12.3) | 销售订单占用量 | decimal | 13 | True | |
OtherOnWayQuantity (T+12.3) | 其他在途量 | decimal | 13 | True | |
IdSku (T+12.3) | SKu | int | 4 | False | |
PurchaseArrivalQuantity (T+12.3) | 进货待入量 | decimal | 13 | True | |
ForStockOrderQuantity (T+12.3) | 要货占用量 | decimal | 13 | True | |
PurchaseForReceiveQuantity (T+12.3) | 采购入库待入量 | decimal | 13 | True | |
MaterialForSendQuantity (T+12.3) | 材料待发量 | decimal | 13 | True | |
PurchaseRequisitionQuantity (T+12.3) | 请购量 | decimal | 13 | True | |
LowQuantity (T+12.3) | 最低库存 | decimal | 13 | True | |
ProduceForDispatchQuantity (T+12.3) | 生产待发量 | decimal | 13 | True | |
OnProducingQuantity (T+12.3) | 生产待入量 | decimal | 13 | True | |
DelegateForReceiveQuantity (T+12.3) | 委外入库待入量 | decimal | 13 | True | |
VoucherTypeCode (T+12.3) | 单据类型编码 | nvarchar | 30 | False | |
PurchaseOrderOnWayQuantity (T+12.3) | 采购订单在途量 | decimal | 13 | True | |
ExistingQuantity (T+12.3) | 现存量 | decimal | 13 | True | |
DelegateForDispatchQuantity (T+12.3) | 委外发料待发量 | decimal | 13 | True | |
StockRequestForReceiveQuantity (T+13.0) | 要货待入量 | decimal | 13 | True |
Copyright 2019 Chanjet Inc.