Oracle-ERP-表结构-MRP.xls

MRPMRP模模块块常常用用表表结结构构表表名名:mrp.mrp_assembly_operationsmrp.mrp_assembly_operations说说明明:计计划划装装配配实实施施表表ORGANIZATION_IDNUMBER组织代码INVENTORY_ITEM_IDNUMBER构成项目内码COMPILE_DESIGNATORVARCHAR2(10)计划员USING_ASSEMBLY_ITEM_IDNUMBER装配件内码OPERATION_SEQ_NUMNUMBER工序号OPTIONAL_COMPONENTNUMBER可选构成数OPERATION_USAGE_QUANTITYNUMBER实施数量OPERATIOP_OFFSET_PERCENTNUMBER补尝百分比WIP_SUPPLY_TYPENUMBER车间供应类型表表名名:mrp.mrp_forecast_itemsmrp.mrp_forecast_items说说明明:预预测测项项目目表表INVENTORY_ITEM_ID NUMBER项目内码ORGANIZATION_ID NUMBER组织代码FORECAST_DESIGNATORVARCHAR(10)预测计划名称表表名名:mrp.mrp_forecast_designatorsmrp.mrp_forecast_designators说说明明:预预测测名名称称表表FORECAST_DESIGNATOR VARCHAR2(10)预测名称ORGANIZATION_ID NUMBER组织代码DESCRIPTION VARCHAR2(50)描述CONSUME_FORECAST NUMBERUPDATE_TYPE NUMBER更改类型DISABLE_DATE DATE失效日期FORECAST_SETVARCHAR2(10)预测集表表名名:mrp.mrp_forecast_datesmrp.mrp_forecast_dates说说明明:预预测测表表TRANSACTION_ID NUMBER交易代码INVENTORY_ITEM_ID NUMBER项目内码ORGANIZATION_ID NUMBER组织代码FORECAST_DESIGNATOR VARCHAR2(10)预测名称CREATION_DATEDATE做预测时间FORECAST_DATE DATE预测开始时间ORIGINAL_FORECAST_QUANTITY NUMBER原始数量CURRENT_FORECAST_QUANTITY NUMBER现在数量CONFIDENCE_PERCENTAGE NUMBER可信度BUCKET_TYPE NUMBER周期类型(1.日,2.周,3.周期)RATE_END_DATE DATE预测结束日期(为空时,只有一个周期)ORIGINATION_TYPE NUMBER原始类型注:数量为一个周期的数量。周期数为：1.当周期类型为日时,为预测起止日之间的工作天数;2.当周期为周时,为预测起止日期所跨的周数;3.当类型为周期时,周期数为起止日期所跨的周期数(1个季度共13周分为3个周期,分别为445周)在计算时可分别与BOM模块的bom_calendar_dates,bom_cal_week_start_dates,bom_period_start_dates关联进行计算表表名名:mrp.mrp_forecast_updatesmrp.mrp_forecast_updates说说明明:预预测测更更改改TRANSACTION_ID NUMBER交易代码LAST_UPDATE_DATE DATE最后更新日期INVENTORY_ITEM_ID NUMBER项目内码ORGANIZATION_ID NUMBER组织代码FORECAST_DESIGNATOR VARCHAR2(10)预测名称UPDATE_SALES_ORDER NUMBER销售订单内码SALES_ORDER_SCHEDULE_DATEDATE销售订单计划日期FORECAST_UPDATE_DATE DATE预测更改日期SALES_ORDER_QUANTITY NUMBER销售订单数量DEMAND_CLASS VARCHAR2(30)需求类型UPDATE_QUANTITY NUMBER更改数量CUSTOMER_ID NUMBER用户标识码SHIP_ID NUMBER发运标识码BILL_ID NUMBER清单标识码LINE_NUM VARCHAR2(30)栏目UPDATE_SEQ_NUMNUMBER更改序号表表名名:mrp.mrp_gross_requirementsmrp.mrp_gross_requirements说说明明:毛毛需需求求DEMAND_ID NUMBER需求标识码INVENTORY_ITEM_ID NUMBER项目内码ORGANIZATION_ID NUMBER组织代码COMPILE_DESIGNATOR VARCHAR2(10)计划名称USING_ASSEMBLY_ITEM_ID NUMBER用于装配件内码USING_ASSEMBLY_DEMAND_DATE DATE装配需求日期USING_REQUIREMENTS_QUANTITYNUMBER装配需求数量DEMAND_TYPE NUMBER需求类型ORIGINATION_TYPE NUMBER原始类型DISPOSITION_ID NUMBER其中:ORIGINATION_TYPE 1 计划订单2 非标准作业3 独立作业4 重复计划5 Expired lot6 销售订单MDS7 预测MDS8 手工MDS9 其它独立需求10 Hard reservation11 MDS 独立需求12 MPS 汇总需求15 Copied schedule demand16 计划订单报废17 独立作业报废18 采购订单报废19 采购请求报废20 PO 接收报废21 重复计划报废22 模型/选择类需求23 在途运输报废24 组织内部订单表表名名:mrp.mrp_item_purchase_ordersmrp.mrp_item_purchase_orders说说明明:MRPMRP采采购购计计划划TRANSACTION_ID NUMBER交易标识码INVENTORY_ITEM_ID NUMBER项目内码ORGANIZATION_ID NUMBER组织代码COMPILE_DESIGNATOR VARCHAR2(10)计划名称PURCHASE_ORDER_ID NUMBER采购订单标识码VENDOR_ID NUMBER供应商标识码ORDER_TYPE NUMBER订单类型DELIVERY_SCHEDULE_DATE DATE计划交付日期PO_NUMBER VARCHAR2(62)采购订单号DELIVERY_BALANCE NUMBEREXPECTED_SCRAP_QUANTITY NUMBER预计报废数量UOM_CODE VARCHAR2(3)单位PO_UOM_DELIVERY_BALANCE NUMBERDELIVERY_PRICE NUMBER交付价格DELIVERY_STATUS_TYPE NUMBER交付状态PURCH_LINE_NUM NUMBER采购行栏目号LINE_ID NUMBER行号FIRM_PLANNED_STATUS_TYPE NUMBERDELIVERY_NEED_DATE DATE交付到岸日期REVISION VARCHAR2(3)版本PRINT_DATE DATE制单日期其中:ORDER_TYPE1 采购订单(PO)2 采购请求(PR)3 独立作业4 建议汇总重复计划5 计划订单7 非标准作业8 采购订单接收11 在途运输12 在途接收13 建议重复计划14 按产品独立作业15 按产品非标准作业16 按产品重复计划17 按产品计划订单表表名名:mrp.mrp_item_wipentitiesmrp.mrp_item_wip_entities说说明明:MRPMRP项项目目离离散散作作业业INVENTORY_ITEM_ID NUMBER项目内码ORGANIZATION_ID NUMBER组织代码COMPILE_DESIGNATOR VARCHAR2(10)计划名称WIP_ENTITY_ID NUMBER任务令内码WIP_ENTITY_NAME VARCHAR2(240)任务令号JOB_QUANTITY NUMBER作业数量QUANTITY_COMPLETED NUMBER完工数量QUANTITY_SCRAPPED NUMBER报废数量EXPECTED_SCRAP_QUANTITY NUMBER允许报废数量SCHEDULE_COMPLETION_DATE DATE计划完工日期FIRM_PLANNED_STATUS_TYPENUMBERSTART_DATE DATE开工日期STATUS_CODE NUMBER状态REVISIONVARCHAR2(3)版本表表名名:mrp.mrp_plansmrp.mrp_plans说说明明:计计划划表表ORGANIZATION_ID NUMBER组织代码COMPILE_DESIGNATOR VARCHAR2(10)计划名称CURR_SCHEDULE_DESIGNATOR VARCHAR2(10)当前计划名称CURR_OPERATION_SCHEDULE_TYPENUMBER当前操作计划类型CURR_PLAN_TYPE NUMBER当计划计划类型CURR_OVERWRITE_OPTION NUMBERCURR_APPEND_PLANNED_ORDERS NUMBERCURR_SCHEDULE_TYPE NUMBERCURR_CUTOFF_DATE DATECURR_PART_INCLUDE_TYPE NUMBERCURR_PLANNING_TIME_FENCE_FLAGNUMBERCURR_DEMAND_TIME_FENCE_FLAG NUMBERCURR_CONSIDER_RESERVATIONS NUMBERCURR_PLAN_SAFETY_STOCK NUMBERCURR_CONSIDER_WIP NUMBERCURR_CONSIDER_PO NUMBERCURR_SNAPSHOT_LOCK NUMBERCOMPILE_DEFINITION_DATE DATESCHEDULE_DESIGNATOR VARCHAR2(10)OPERATION_SCHEDULE_TYPE NUMBERPLAN_TYPE NUMBEROVERWRITE_OPTION NUMBERAPPEND_PLANNED_ORDERS NUMBERSCHEDULE_TYPE NUMBERCUTOFF_DATE DATEPART_INCLUDE_TYPE NUMBERPLANNING_TIME_FENCE_FLAG NUMBERDEMAND_TIME_FENCE_FLAG NUMBERCONSIDER_RESERVATIONS NUMBERPLAN_SAFETY_STOCK NUMBERCONSIDER_WIP NUMBERCONSIDER_PO NUMBERSNAPSHOT_LOCK NUMBEREXPLOSION_START_DATEDATEEXPLOSION_COMPLETION_DATEDATEDATA_START_DATE DATEDATA_COMPLETION_DATE DATEPLAN_START_DATE DATECRP_PLAN_COMPLETION_DATE DATEPLAN_COMPLETION_DATE DATECRP_PLAN_START_DATE DATECURRENT_PLANNER_LEVEL NUMBERPLANNER_BATCH_NUMBER NUMBERDESCRIPTION VARCHAR2(50)UPDATE_BOM NUMBERUSE_NEW_PLANNERNUMBER表表名名:mrp.mrp_recommendationsmrp.mrp_recommendations说说明明:计计划划建建议议(含含例例外外信信息息)TRANSACTION_ID NUMBER交易标识码INVENTORY_ITEM_ID NUMBER项目内码ORGANIZATION_ID NUMBER组织代码COMPILE_DESIGNATOR VARCHAR2(10)计划名称NEW_SCHEDULE_DATE DATE新计划日期OLD_SCHEDULE_DATE DATE老计划日期NEW_WIP_START_DATE DATE新的作业开始时间OLD_WIP_START_DATE DATE老的作业开始时间DISPOSITION_ID NUMBER联接标识*DISPOSITION_STATUS_TYPE NUMBER联接类型ORDER_TYPE NUMBER订单类型VENDOR_ID NUMBER供应商标识码NEW_ORDER_QUANTITY NUMBER新的订单数量OLD_ORDER_QUANTITY NUMBER老的订单数量NEW_ORDER_PLACEMENT_DATE DATE新的订单定位日期OLD_ORDER_PLACEMENT_DATE DATE老的订单定位日期FIRM_PLANNED_TYPE NUMBERRESCHEDULED_FLAG NUMBER重复计划标志SCHEDULE_COMPRESSION_DAYS NUMBER计划压缩天数NEW_PROCESSING_DAYS NUMBER新的处理天数PURCH_LINE_NUM NUMBER采购订单栏目号REVISION VARCHAR2(3)版本LAST_UNIT_COMPLETION_DATE DATE最后单位完工日期FIRST_UNIT_START_DATE DATE最早单位开工日期LAST_UNIT_START_DATE DATE最后单位开工日期DAILY_RATE NUMBER每天速率OLD_DOCK_DATE DATE老的到岸日期NEW_DOCK_DATE DATE新的到岸日期RESCHEDULE_DAYSNUMBER重复计划天数注:DISPOSITION_ID视情况与mrp.mrp_item_purchase_orders中的transaction_id关联 或与mrp.mrp_item_wip_entities中的wip_entity_id关联