UFTData

MP_Com_Available Table  (MP 生产管理)  [T+12.3]

Summary

可用量计算

Columns

 Column NameDescriptionDatatypeLengthAllow Nulls
  SafeLowQuantity (T+12.3) 安全库存 decimal13 True 
  TransOnWayQuantity (T+12.3) 调拨在途量 decimal13 True 
  CurrentUserId (T+12.3) 当前用户ID nvarchar50 False 
  ProductForReceiveQuantity (T+12.3) 产成品待入量 decimal13 True 
  RetailOccupyQuantity (T+16.0) 零售占用量 decimal13 True 
  TransForDispatchQuantity (T+12.3) 调拨待出量 decimal13 True 
  OtherForDispatchQuantity (T+12.3) 其他待出量 decimal13 True 
  ManufacturePlanQuantityOccupy (T+16.0) 生产计划占用量 decimal13 True 
  DelegateOrderForProductQuantity (T+12.3) 委外待入量 decimal13 True 
  DelegateOrderForMaterialQuantity (T+12.3) 委外待发量 decimal13 True 
  ForSaleDispatchQuantity (T+12.3) 销售出库待出量 decimal13 True 
  OutSourcePlanQuantity (T+16.0) 委外计划量 decimal13 True 
  DistributionForDispatchQuantity (T+13.0) 配货待发量 decimal13 True 
  DistributionForReceiveQuantity (T+13.0) 配货待入量 decimal13 True 
  RetailOnWayQuantity (T+16.0) 零售在途量 decimal13 True 
  SaleDeliveryQuantity (T+12.3) 销售待出量 decimal13 True 
  CanUseQuantity (T+12.3) 计算后的可用量 decimal13 True 
  TempOutSourcePlanQuantityForOccupy (T+16.0) 无用字段 decimal13 True 
  ForSaleOrderQuantity (T+12.3) 销售订单占用量 decimal13 True 
  TempManufacturePlanQuantityForOccupy (T+16.0) 无用字段 decimal13 True 
  OtherOnWayQuantity (T+12.3) 其他在途量 decimal13 True 
  IdSku (T+12.3) SKu intFalse 
  PurchaseArrivalQuantity (T+12.3) 进货待入量 decimal13 True 
  ForStockOrderQuantity (T+12.3) 要货占用量 decimal13 True 
  OutSourcePlanQuantityOccupy (T+16.0) 委外计划占用量 decimal13 True 
  PurchaseForReceiveQuantity (T+12.3) 采购入库待入量 decimal13 True 
  ManufacturePlanQuantity (T+16.0) 生产计划量 decimal13 True 
  MaterialForSendQuantity (T+12.3) 材料待发量 decimal13 True 
  PurchaseRequisitionQuantity (T+12.3) 请购量 decimal13 True 
  LowQuantity (T+12.3) 最低库存 decimal13 True 
  ProduceForDispatchQuantity (T+12.3) 生产待发量 decimal13 True 
  OnProducingQuantity (T+12.3) 生产待入量 decimal13 True 
  DelegateForReceiveQuantity (T+12.3) 委外入库待入量 decimal13 True 
  PurchasePlanQuantity (T+16.0) 采购计划量 decimal13 True 
  VoucherTypeCode (T+12.3) 单据类型编码 nvarchar30 False 
  PurchaseOrderOnWayQuantity (T+12.3) 采购订单在途量 decimal13 True 
  ExistingQuantity (T+12.3) 现存量 decimal13 True 
  DelegateForDispatchQuantity (T+12.3) 委外发料待发量 decimal13 True 
  StockRequestForReceiveQuantity (T+13.0) 要货待入量 decimal13 True 

Send feedback

Copyright 2016 Chanjet Inc.