STATUS_TYPE NUMBER 状态 PRIMARY_ITEM_ID NUMBER 加工件内码 FIRM_PLANNED_FLAG NUMBER JOB_TYPE NUMBER 作业类型(1.标准,3.非标准) WIP_SUPPLY_TYPE NUMBER 供应类型 CLASS_CODE VARCHAR2(10) 任务类别 MATERIAL_ACCOUNT NUMBER 物料帐目 MATERIAL_OVERHEAD_ACCOUNT NUMBER 物料经常费用帐目 RESOURCE_ACCOUNT NUMBER...
l_CompRec.WIP_SUPPLY_TYPE := Rs.Wip_Supply_Type; --主要 需求日期 WIP_REQUIREMENT_OPERATIONS.DATE_REQUIRED l_CompRec.DATE_REQUIRED := Sysdate; --供应 子库存 WIP_REQUIREMENT_OPERATIONS.SUPPLY_SUBINVENTORY l_CompRec.SUPPLY_SUBINVENTORY := Rs.Supply_Subinventory; --供应 货位标识 WIP_REQUIREMENT_O...
supply_subinventory 供应子库存supply_locator_id 供应货位IDBOM_ITEM_TYPE NUMBER 清单项目类型(1.模型2.选项类3.计划中4.标准)INCLUDE_ON_SHIP_DOCS NUMBER 包含在发运文档中(1.是;2.否)REQUIRED_FOR_REVENUE NUMBER 需要进款(1.是;2.否)REQUIRED_TO_SHIP NUMBER 需要发运(1.是;2.否)SHIPPING ALLOWED ...
ROUNDING_CONTROL_TYPE四舍五入控制 FIXED_LEAD_TIME固定提前期 POSTPROCESSING_LEAD_TIME后处理提前期 WIP_SUPPLY_SUBINVENTORY离散作业子库存 CUSTOMER_ORDER_ENABLED_FLAG是否是销售定单 ACCEPTABLE_RATE_INCREASE可接受的增加率 22 2627
WIP_SUPPLY_TYPE 表名:wip.wip_entities 说明:任务令信息表 WIP_ENTITY_IDORGANIZATION_IDWIP_ENTITY_NAMEENTITY_TYPEDESCRIPTIONPRIMARY_ITEM_IDNUMBERNUMBERVARCHAR2(240)NUMBERVARCHAR2(240)NUMBER 表名:wip.wip_requirement_operations说明:任务令物料需求发放表 INVENTORY_ITEM_IDORGANIZATION_IDWIP_ENTITY_IDOPERATION_...
wip_supply_subinventory离散作业子库存 customer_order_enabled_flag是否是销售定单 acceptable_rate_increase可接受的增加率 ont.oe_order_headers_all( oe模块常用表结构 so_headers_all;so_lines_all; 表名:ont.oe_order_headers_all 说明:订单头 header_idnumber订单头标识码 org_idnumberouid order_type_id...
JOB_TYPE :Type of discrete job WIP_SUPPLY_TYPE :Method of material consumption within WIP START_QUANTITY:Job start quantity QUANTITY_COMPLETED:Current job quantity completed COMMON_BOM_SEQUENCE_ID:--> BOM_COMPONENTS_B.BILL_SEQUENCE_ID COMMON_ROUTING_SEQUENCE_ID:-->BOM_OPERATIONAL_ROUTINGS.ROUTING...
User Item Type See Main Variable Lead Time See Lead Times Vehicle See Physical Attributes Volume Unit of Measure See Physical Attributes Web Status See Web Option Weight Unit of Measure SeePhysical Attributes WIP Supply Locator See Work in Process WIP Supply Subinventory See Work in Process WIP Su...
and ML.LOOKUP_TYPE = 'WIP_SUPPLY' and ML.LOOKUP_CODE = WRO.WIP_SUPPLY_TYPE and (MFG_LOOKUPS_WJS.LOOKUP_TYPE = 'WIP_JOB_STATUS') and (wdj.STATUS_TYPE = MFG_LOOKUPS_WJS.LOOKUP_CODE) and CIC.INVENTORY_ITEM_ID = MSI2.INVENTORY_ITEM_ID ...
WIP_ENTITY_ID:Jobor schedule Identifier ORGANIZATION_ID:OrganizationIdentifier INVENTORY_ITEM_ID:ComponentItemIdCOMPONENT_SEQUENCE_ID: -->BOM_COMPONENTS_B.COMPONENT_SEQUENCE_ID WIP_SUPPLY_TYPE:Method of material consumption within WIP Value Meaning ...