UFTData

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

Summary

分析运算参数DTO

Columns

 Column NameDescriptionDatatypeLengthAllow Nulls
  OutSourcePlanQuantityUnaudit (T+16.0) 委外计划量含未审 intTrue 
  AvailableQuantityDate (T+12.3) 预计可用量日期 datetimeTrue 
  OtherOnWayQuantity (T+12.3) 其他在途量 tinyintTrue 
  OutSourcePlanQuantityOccupy (T+16.0) 委外计划占用量 intTrue 
  BomAnalysisMode (T+12.3) BOM分析方式 intTrue 
  IdSolution (T+16.0) 方案ID intTrue 
  FIDivided (T+12.3) 有启用自由项的存货严格按照自由项运算,区分自由项配送 tinyintTrue 
  Name (T+12.3) 名称 nvarchar200 True 
  ManufactureForSendQuantity (T+12.3) 生产待发量 tinyintTrue 
  ISCheckedAvailableQuantityDate (T+12.3) 考虑成品率 tinyintTrue 
  ForSaleDispatchQuantity (T+12.3) 销售出库待出量 tinyintTrue 
  RetailOccupyQuantity (T+16.0) 零售占用量 intTrue 
  PurchaseRequisitionUnaudit (T+12.3) 请购量包含未审 tinyintTrue 
  ManufacturePlanQuantity (T+16.0) 生产计划量 intTrue 
  StockRequestForReceiveQuantity (T+13.0) 要货待入量 intTrue 
  ISDefault (T+12.3) 是否为默认方案 tinyintTrue 
  DelegateOrderForProductQuantityWithUnAudit (T+12.3) 委外待入量(含未审) intTrue 
  ManufacturePlanQuantityUnaudit (T+16.0) 生产计划量(含未审) intTrue 
  PurchaseOrderOnWayQuantity (T+12.3) 采购在途量 tinyintTrue 
  SuggestionType (T+16.0) 建议类型 intTrue 
  StockRequestForReceiveQuantityUnaudit (T+13.0) 要货待入量(含未审) intTrue 
  ManufacturePlanQuantityOccupyUnaudit (T+16.0) 生产计划占用量(含未审) intTrue 
  OtherForDispatchQuantity (T+12.3) 其他待发量 tinyintTrue 
  IsResultMerge (T+16.0) 结果是否合并 intTrue 
  IsConsiderWasteRate (T+16.0) 是否考虑损耗率 intTrue 
  ISConsiderManufactureLeadTime (T+16.0) 是否考虑生产提前期 intTrue 
  OnProducingQuantity (T+12.3) 生产在产量 tinyintTrue 
  RetailOnWayQuantity (T+16.0) 零售在途量 intTrue 
  TransOnWayQuantity (T+12.3) 调拨在途量 tinyintTrue 
  DelegateForDispatchQuantity (T+12.3) 委外发料待发量 intTrue 
  DelegateOrderForMaterialQuantityWithUnAudit (T+12.3) 委外待发量未审核 intTrue 
  SaleOrderQuantityUnaudit (T+12.3) 销售订单占用量(未审) tinyintTrue 
  DeliveryOnWayQuantity (T+12.3) 要货待发量 tinyintTrue 
  ISCheckedProductRate (T+12.3) 考虑成品率 tinyintTrue 
  IsCalculateNullBomByDefaultBom (T+16.0) 未指定BOM时按默认BOM运算 intTrue 
  DistributionForReceiveQuantity (T+13.0) 配货待入量 intTrue 
  OutSourcePlanQuantity (T+16.0) 委外计划量 intTrue 
  Updated (T+12.3) 更新时间 datetimeTrue 
  PurchaseForReceiveQuantity (T+12.3) 采购入库待入量 tinyintTrue 
  ISConsiderPurchasingLeadTime (T+16.0) 是否考虑采购提前期 intTrue 
  DeliveryOnWayQuantityUnaudit (T+12.3) 要货待发量(未审) tinyintTrue 
  IsMustFreeitemNotConsiderSafeQuantity (T+16.0) 有必录自由项的存货不考虑安全库存 intTrue 
  SafeQuantity (T+12.3) 安全库存 tinyintTrue 
  PurchaseOnWayQuantity (T+12.3) 采购在途量 tinyintTrue 
  DelegateOrderForProductQuantity (T+12.3) 委外待入量 intTrue 
  Ts (T+12.3) 时间戳 timestampFalse 
  LowQuantity (T+12.3) 最低库存 tinyintTrue 
  IsMustFreeitemConsiderSafeQuantityByFreeitem (T+16.0) 有必录自由项的存货按必录自由项组合考虑安全库存 intTrue 
  ManufactureMaterialsQuantity (T+12.3) 生产占用量 tinyintTrue 
  IsNotRecordSourceRelation (T+16.0) 是否不记录来源关系(无用) intTrue 
  IsOnlyCalculateMRPInventoryForEndlevel (T+16.0) 末级只运算“MRP运算件”的存货 intTrue 
  PlanPriorityLevel (T+16.0) 生成计划优先级 intTrue 
  ManufacturePlanQuantityOccupy (T+16.0) 生产计划量占用 intTrue 
  PurchaseOrderOnWayUnaudit (T+12.3) 采购订单在途量包含未审 tinyintTrue 
  DistributionForDispatchQuantityUnaudit (T+13.0) 配货待发量(含未审) intTrue 
  ManufactureForSendUnaudit (T+12.3) 生产待发量包含未审 tinyintTrue 
  DelegateForReceiveQuantity (T+12.3) 委外入库待入量 intTrue 
  DistributionForDispatchQuantity (T+13.0) 配货待发量 intTrue 
  SaleOnWayQuantity (T+12.3) 销售待发量 tinyintTrue 
  OutSourcePlanQuantityOccupyUnaudit (T+16.0) 委外计划量占用(未审) intTrue 
  ProductForReceiveQuantity (T+12.3) 采购入库待入量 tinyintTrue 
  DelegateOrderForMaterialQuantity (T+12.3) 委外待发量 intTrue 
  ExistingQuantity (T+12.3) 现存量 tinyintTrue 
  ID (T+12.3) 主键 intFalse 
  Code (T+12.3) 编码 nvarchar30 True 
  TransForDispatchQuantity (T+12.3) 调拨待发量 tinyintTrue 
  AnalyseWarehouseMode (T+12.3) 分析仓库类型 intTrue 
  ContainsNullWarehouse (T+12.3) 包含空仓库 tinyintTrue 
  CurrentUserId (T+12.3) 当前用户 nvarchar50 True 
  PurchasePlanQuantity (T+16.0) 采购计划量 intTrue 
  PurchaseArrivalQuantity (T+12.3) 进货待入量 tinyintTrue 
  ManufactureQuantityUnaudit (T+12.3) 生产待入量含未审 tinyintTrue 
  PurchasePlanQuantityUnaudit (T+16.0) 采购计划量(未审) intTrue 
  SaleOrderQuantity (T+12.3) 销售订单占用量 tinyintTrue 
  MaterialForSendQuantity (T+12.3) 材料待发量 tinyintTrue 
  SaleDeliveryQuantity (T+12.3) 销货待出量 tinyintTrue 
  ManufactureQuantity (T+12.3) 生产待入量 tinyintTrue 
  PurchaseRequisitionQuantity (T+12.3) 请购量 tinyintTrue 
  ResultMergeType (T+12.3) 投产合并规则 intTrue 
  IsPlanAutoAudit (T+16.0) 生成计划自动审核 intTrue 
  DistributionForReceiveQuantityUnaudit (T+13.0) 配货待发量(含未审) intTrue 
  ISConsiderManufactureBatch (T+16.0) 考虑生产批量 intTrue 
  VoucherTypeCode (T+12.3) 单据类型编码 nvarchar30 True 

Send feedback

Copyright 2016 Chanjet Inc.