UFTData

MP_PRA_PraOption Table  (MP 生产管理)  [T+12.1]

Summary

PRA运算参数选项DTO

Columns

 Column NameDescriptionDatatypeLengthAllow Nulls
  DeliveryOnWayQuantityUnaudit (T+12.1) 要货待发量(未审) bitTrue 
  DelegateOrderForProductQuantityWithUnAudit (T+12.3) 委外入库待入量(未审) intTrue 
  DelegateForDispatchQuantity (T+12.3) 委外发料待发量 intTrue 
  materialforsendquantity (T+12.1) 材料待发 tinyintTrue 
  otheronwayquantity (T+12.1) 其他在途 tinyintTrue 
  availablequantitydate (T+12.1) 可用量日期 datetimeTrue 
  isCarriedForwardOut (T+12.1) 是否已结转 tinyintTrue 
  notquantityonfreeitems (T+12.1) 有自由项的存货不考虑安全库存 tinyintTrue 
  onquantityonfreeitems (T+12.1) 有自由项的存货按每一 必输自由项组合考虑安全库存 tinyintTrue 
  saledeliveryquantity (T+12.1) 销售待出量 tinyintTrue 
  existingquantity (T+12.1) 现存量 tinyintTrue 
  DistributionForDispatchQuantityUnaudit (T+13.0) 配货待出量(未审) intTrue 
  code (T+12.1) 编号 nvarchar30 True 
  resultmergetype (T+12.1) 运算结果合并规则 intTrue 
  purchaserequisitionunaudit (T+12.1) 请购量包含未审 tinyintTrue 
  SourceDocType (T+12.1) 来源单据 intTrue 
  id (T+12.1) 主键 intFalse 
  saleorderquantityunaudit (T+12.1) 销售订单占用量(未审) tinyintTrue 
  suggestiontype (T+12.1) 建议量计算方式 intTrue 
  StockRequestForReceiveQuantityUnaudit (T+13.0) 要货待入量含未申 intTrue 
  manufacturequantityunaudit (T+12.1) 生产待入量含未申 tinyintTrue 
  purchaserequisitionquantity (T+12.1) 请购量 tinyintTrue 
  DistributionForReceiveQuantity (T+13.0) 配货待入量 intTrue 
  DistributionForDispatchQuantity (T+13.0) 配货待出量 intTrue 
  DistributionForReceiveQuantityUnaudit (T+13.0) 配货待入量含未申 intTrue 
  purchasearrivalquantity (T+12.1) 进货带入 tinyintTrue 
  manufacturequantity (T+12.1) 生产待入量 tinyintTrue 
  manufactureforsendunaudit (T+12.1) 生产待发量包含未审 tinyintTrue 
  manufactureforsendquantity (T+12.1) 生产待发量 tinyintTrue 
  StockRequestForReceiveQuantity (T+13.0) 要货待入量 intTrue 
  transonwayquantity (T+12.1) 调拨在途 tinyintTrue 
  purchaseorderonwayunaudit (T+12.1) 采购订单在途量包含未审 tinyintTrue 
  saleorderquantity (T+12.1) 销售订单占用量 tinyintTrue 
  containsnullwarehouse (T+12.1) 含未指定仓库的可用量 tinyintTrue 
  DelegateOrderForProductQuantity (T+12.3) 委外待入量 intTrue 
  DelegateOrderForMaterialQuantity (T+12.3) 委外待发量 intTrue 
  transfordispatchquantity (T+12.1) 调拨待发量 tinyintTrue 
  DelegateForReceiveQuantity (T+12.3) 委外入库待入量 intTrue 
  manufactureMaterialsQuantity (T+12.1) 生产占用量 tinyintTrue 
  otherfordispatchquantity (T+12.1) 其他待发 tinyintTrue 
  createdtime (T+12.1) 创建时间 datetimeTrue 
  completmentTypeForHeigh (T+12.1) 当补至最高库存时,高于()不补充 intTrue 
  sequencenumber (T+12.1) 顺序号 intTrue 
  purchaseonwayquantity (T+12.1) 采购在途量 tinyintTrue 
  getavailablebeforesomedate (T+12.1) 取日期前的可用量 tinyintTrue 
  GeneratedType (T+12.1) 生单方式 intTrue 
  DeliveryOnWayQuantity (T+12.1) 要货待发量 bitTrue 
  lowquantity (T+12.1) 最低库存 tinyintTrue 
  isCarriedForwardIn (T+12.1) 是否结转来的单据 tinyintTrue 
  DelegateOrderForMaterialQuantityWithUnAudit (T+12.3) 委外待发量未审核 intTrue 
  safequantity (T+12.1) 安全库存 tinyintTrue 
  productforreceivequantity (T+12.1) 产成品待入量 tinyintTrue 
  completmentType (T+12.1) 存货补充方式 intTrue 
  saleonwayquantity (T+12.1) 销售待发量 tinyintTrue 
  isPurchaseInventory (T+12.1) 只运算面向库存采购存货 tinyintTrue 
  ts (T+12.1) 分布时间戳 timestampFalse 
  purchaseorderonwayquantity (T+12.1) 采购订单在途量 tinyintTrue 
  isPraInventory (T+12.1) 只运算按计划分析存货 tinyintTrue 
  name (T+12.1) 名称 nvarchar200 True 
  purchaseforreceivequantity (T+12.1) 采购入库待入 tinyintTrue 
  forsaledispatchquantity (T+12.1) 销售出库待出量 tinyintTrue 
  onProducingQuantity (T+12.1) 生产待入 tinyintTrue 

Send feedback

Copyright 2019 Chanjet Inc.