MRP模塊常用表結(jié)構(gòu),,

表名:mrp.mrp_assembly_operations,,

說(shuō)明:計(jì)劃裝配實(shí)施表,,

ORGANIZATION_ID,NUMBER,組織代碼

INVENTORY_ITEM_ID,NUMBER,構(gòu)成項(xiàng)目?jī)?nèi)碼

COMPILE_DESIGNATOR,VARCHAR2(10),計(jì)劃員

USING_ASSEMBLY_ITEM_ID,NUMBER,裝配件內(nèi)碼

OPERATION_SEQ_NUM,NUMBER,工序號(hào)

OPTIONAL_COMPONENT,NUMBER,可選構(gòu)成數(shù)

OPERATION_USAGE_QUANTITY,NUMBER,實(shí)施數(shù)量

OPERATIOP_OFFSET_PERCENT,NUMBER,補(bǔ)嘗百分比

WIP_SUPPLY_TYPE,NUMBER,車間供應(yīng)類型

,,,

表名:mrp.mrp_forecast_items,,

說(shuō)明:預(yù)測(cè)項(xiàng)目表,,

INVENTORY_ITEM_ID,NUMBER,項(xiàng)目?jī)?nèi)碼

ORGANIZATION_ID,NUMBER,組織代碼

FORECAST_DESIGNATOR,VARCHAR(10),預(yù)測(cè)計(jì)劃名稱

,,,

表名:mrp.mrp_forecast_designators,,

說(shuō)明:預(yù)測(cè)名稱表,,

FORECAST_DESIGNATOR,VARCHAR2(10),預(yù)測(cè)名稱

ORGANIZATION_ID,NUMBER,組織代碼

DESCRIPTION,VARCHAR2(50),描述

CONSUME_FORECAST,NUMBER,

UPDATE_TYPE,NUMBER,更改類型

DISABLE_DATE,DATE,失效日期

FORECAST_SET,VARCHAR2(10),預(yù)測(cè)集

,,,

表名:mrp.mrp_forecast_dates,,

說(shuō)明:預(yù)測(cè)表,,

TRANSACTION_ID,NUMBER,交易代碼

INVENTORY_ITEM_ID,NUMBER,項(xiàng)目?jī)?nèi)碼

ORGANIZATION_ID,NUMBER,組織代碼

FORECAST_DESIGNATOR,VARCHAR2(10),預(yù)測(cè)名稱

CREATION_DATE,DATE,做預(yù)測(cè)時(shí)間

FORECAST_DATE,DATE,預(yù)測(cè)開(kāi)始時(shí)間

ORIGINAL_FORECAST_QUANTITY,NUMBER,原始數(shù)量

CURRENT_FORECAST_QUANTITY,NUMBER,現(xiàn)在數(shù)量

CONFIDENCE_PERCENTAGE,NUMBER,可信度

BUCKET_TYPE,NUMBER,"周期類型(1.日,2.周,3.周期)"

RATE_END_DATE,DATE,"預(yù)測(cè)結(jié)束日期(為空時(shí),只有一個(gè)周期)"

ORIGINATION_TYPE,NUMBER,原始類型

"注:數(shù)量為一個(gè)周期的數(shù)量。周期數(shù)為：1.當(dāng)周期類型為""日""時(shí),為預(yù)測(cè)起止日",,

"之間的工作天數(shù);2.當(dāng)周期為""周""時(shí),為預(yù)測(cè)起止日期所跨的周數(shù);3.當(dāng)類型為""周期""時(shí),",,

"周期數(shù)為起止日期所跨的周期數(shù)(1個(gè)季度共13周分為3個(gè)周期,分別為4\4\5周)",,

"在計(jì)算時(shí)可分別與BOM模塊的bom_calendar_dates,bom_cal_week_start_dates,",,

bom_period_start_dates關(guān)聯(lián)進(jìn)行計(jì)算,,

表名:mrp.mrp_forecast_updates,,

說(shuō)明:預(yù)測(cè)更改,,

TRANSACTION_ID,NUMBER,交易代碼

LAST_UPDATE_DATE,DATE,最后更新日期

INVENTORY_ITEM_ID,NUMBER,項(xiàng)目?jī)?nèi)碼

ORGANIZATION_ID,NUMBER,組織代碼

FORECAST_DESIGNATOR,VARCHAR2(10),預(yù)測(cè)名稱

UPDATE_SALES_ORDER,NUMBER,銷售訂單內(nèi)碼

SALES_ORDER_SCHEDULE_DATE,DATE,銷售訂單計(jì)劃日期

FORECAST_UPDATE_DATE,DATE,預(yù)測(cè)更改日期

SALES_ORDER_QUANTITY,NUMBER,銷售訂單數(shù)量

DEMAND_CLASS,VARCHAR2(30),需求類型

UPDATE_QUANTITY,NUMBER,更改數(shù)量

CUSTOMER_ID,NUMBER,用戶標(biāo)識(shí)碼

SHIP_ID,NUMBER,發(fā)運(yùn)標(biāo)識(shí)碼

BILL_ID,NUMBER,清單標(biāo)識(shí)碼

LINE_NUM,VARCHAR2(30),欄目

UPDATE_SEQ_NUM,NUMBER,更改序號(hào)

,,,

表名:mrp.mrp_gross_requirements,,

說(shuō)明:毛需求,,

DEMAND_ID,NUMBER,需求標(biāo)識(shí)碼

INVENTORY_ITEM_ID,NUMBER,項(xiàng)目?jī)?nèi)碼

ORGANIZATION_ID,NUMBER,組織代碼

COMPILE_DESIGNATOR,VARCHAR2(10),計(jì)劃名稱

USING_ASSEMBLY_ITEM_ID,NUMBER,用于裝配件內(nèi)碼

USING_ASSEMBLY_DEMAND_DATE,DATE,裝配需求日期

USING_REQUIREMENTS_QUANTITY,NUMBER,裝配需求數(shù)量

DEMAND_TYPE,NUMBER,需求類型

ORIGINATION_TYPE,NUMBER,原始類型

DISPOSITION_ID,NUMBER,

其中:ORIGINATION_TYPE,1,計(jì)劃訂單

,2,非標(biāo)準(zhǔn)作業(yè)

,3,獨(dú)立作業(yè)

,4,重復(fù)計(jì)劃

,5,Expiredlot

,6,銷售訂單MDS

,7,預(yù)測(cè)MDS

,8,手工MDS

,9,其它獨(dú)立需求

,10,Hardreservation

,11,MDS獨(dú)立需求

,12,MPS匯總需求

,15,Copiedscheduledemand

,16,計(jì)劃訂單報(bào)廢

,17,獨(dú)立作業(yè)報(bào)廢

,18,采購(gòu)訂單報(bào)廢

,19,采購(gòu)請(qǐng)求報(bào)廢

,20,PO接收?qǐng)?bào)廢

,21,重復(fù)計(jì)劃報(bào)廢

,22,模型/選擇類需求

,23,在途運(yùn)輸報(bào)廢

,24,組織內(nèi)部訂單

表名:mrp.mrp_item_purchase_orders,,

說(shuō)明:MRP采購(gòu)計(jì)劃,,

TRANSACTION_ID,NUMBER,交易標(biāo)識(shí)碼

INVENTORY_ITEM_ID,NUMBER,項(xiàng)目?jī)?nèi)碼

ORGANIZATION_ID,NUMBER,組織代碼

COMPILE_DESIGNATOR,VARCHAR2(10),計(jì)劃名稱

PURCHASE_ORDER_ID,NUMBER,采購(gòu)訂單標(biāo)識(shí)碼

VENDOR_ID,NUMBER,供應(yīng)商標(biāo)識(shí)碼

ORDER_TYPE,NUMBER,訂單類型

DELIVERY_SCHEDULE_DATE,DATE,計(jì)劃交付日期

PO_NUMBER,VARCHAR2(62),采購(gòu)訂單號(hào)

DELIVERY_BALANCE,NUMBER,

EXPECTED_SCRAP_QUANTITY,NUMBER,預(yù)計(jì)報(bào)廢數(shù)量

UOM_CODE,VARCHAR2(3),單位

PO_UOM_DELIVERY_BALANCE,NUMBER,

DELIVERY_PRICE,NUMBER,交付價(jià)格

DELIVERY_STATUS_TYPE,NUMBER,交付狀態(tài)

PURCH_LINE_NUM,NUMBER,采購(gòu)行欄目號(hào)

LINE_ID,NUMBER,行號(hào)

FIRM_PLANNED_STATUS_TYPE,NUMBER,

DELIVERY_NEED_DATE,DATE,交付到岸日期

REVISION,VARCHAR2(3),版本

PRINT_DATE,DATE,制單日期

其中:ORDER_TYPE,1,采購(gòu)訂單(PO)

,2,采購(gòu)請(qǐng)求(PR)

,3,獨(dú)立作業(yè)

,4,建議匯總重復(fù)計(jì)劃

,5,計(jì)劃訂單

,7,非標(biāo)準(zhǔn)作業(yè)

,8,采購(gòu)訂單接收

,11,在途運(yùn)輸

,12,在途接收

,13,建議重復(fù)計(jì)劃

,14,按產(chǎn)品獨(dú)立作業(yè)

,15,按產(chǎn)品非標(biāo)準(zhǔn)作業(yè)

,16,按產(chǎn)品重復(fù)計(jì)劃

,17,按產(chǎn)品計(jì)劃訂單

表名:mrp.mrp_item_wip_entities,,

說(shuō)明:MRP項(xiàng)目離散作業(yè),,

INVENTORY_ITEM_ID,NUMBER,項(xiàng)目?jī)?nèi)碼

ORGANIZATION_ID,NUMBER,組織代碼

COMPILE_DESIGNATOR,VARCHAR2(10),計(jì)劃名稱

WIP_ENTITY_ID,NUMBER,任務(wù)令內(nèi)碼

WIP_ENTITY_NAME,VARCHAR2(240),任務(wù)令號(hào)

JOB_QUANTITY,NUMBER,作業(yè)數(shù)量

QUANTITY_COMPLETED,NUMBER,完工數(shù)量

QUANTITY_SCRAPPED,NUMBER,報(bào)廢數(shù)量

EXPECTED_SCRAP_QUANTITY,NUMBER,允許報(bào)廢數(shù)量

SCHEDULE_COMPLETION_DATE,DATE,計(jì)劃完工日期

FIRM_PLANNED_STATUS_TYPE,NUMBER,

START_DATE,DATE,開(kāi)工日期

STATUS_CODE,NUMBER,狀態(tài)

REVISION,VARCHAR2(3),版本

,,,

表名:mrp.mrp_plans,,

說(shuō)明:計(jì)劃表,,

ORGANIZATION_ID,NUMBER,組織代碼

COMPILE_DESIGNATOR,VARCHAR2(10),計(jì)劃名稱

CURR_SCHEDULE_DESIGNATOR,VARCHAR2(10),當(dāng)前計(jì)劃名稱

CURR_OPERATION_SCHEDULE_TYPE,NUMBER,當(dāng)前操作計(jì)劃類型

CURR_PLAN_TYPE,NUMBER,當(dāng)計(jì)劃計(jì)劃類型

CURR_OVERWRITE_OPTION,NUMBER,

CURR_APPEND_PLANNED_ORDERS,NUMBER,

CURR_SCHEDULE_TYPE,NUMBER,

CURR_CUTOFF_DATE,DATE,

CURR_PART_INCLUDE_TYPE,NUMBER,

CURR_PLANNING_TIME_FENCE_FLAG,NUMBER,

CURR_DEMAND_TIME_FENCE_FLAG,NUMBER,

CURR_CONSIDER_RESERVATIONS,NUMBER,

CURR_PLAN_SAFETY_STOCK,NUMBER,

CURR_CONSIDER_WIP,NUMBER,

CURR_CONSIDER_PO,NUMBER,

CURR_SNAPSHOT_LOCK,NUMBER,

COMPILE_DEFINITION_DATE,DATE,

SCHEDULE_DESIGNATOR,VARCHAR2(10),

OPERATION_SCHEDULE_TYPE,NUMBER,

PLAN_TYPE,NUMBER,

OVERWRITE_OPTION,NUMBER,

APPEND_PLANNED_ORDERS,NUMBER,

SCHEDULE_TYPE,NUMBER,

CUTOFF_DATE,DATE,

PART_INCLUDE_TYPE,NUMBER,

PLANNING_TIME_FENCE_FLAG,NUMBER,

DEMAND_TIME_FENCE_FLAG,NUMBER,

CONSIDER_RESERVATIONS,NUMBER,

PLAN_SAFETY_STOCK,NUMBER,

CONSIDER_WIP,NUMBER,

CONSIDER_PO,NUMBER,

SNAPSHOT_LOCK,NUMBER,

EXPLOSION_START_DATE,DATE,

EXPLOSION_COMPLETION_DATE,DATE,

DATA_START_DATE,DATE,

DATA_COMPLETION_DATE,DATE,

PLAN_START_DATE,DATE,

CRP_PLAN_COMPLETION_DATE,DATE,

PLAN_COMPLETION_DATE,DATE,

CRP_PLAN_START_DATE,DATE,

CURRENT_PLANNER_LEVEL,NUMBER,

PLANNER_BATCH_NUMBER,NUMBER,

DESCRIPTION,VARCHAR2(50),

UPDATE_BOM,NUMBER,

USE_NEW_PLANNER,NUMBER,

,,,

表名:mrp.mrp_recommendations,,

說(shuō)明:計(jì)劃建議(含例外信息),,

TRANSACTION_ID,NUMBER,交易標(biāo)識(shí)碼

INVENTORY_ITEM_ID,NUMBER,項(xiàng)目?jī)?nèi)碼

ORGANIZATION_ID,NUMBER,組織代碼

COMPILE_DESIGNATOR,VARCHAR2(10),計(jì)劃名稱

NEW_SCHEDULE_DATE,DATE,新計(jì)劃日期

OLD_SCHEDULE_DATE,DATE,老計(jì)劃日期

NEW_WIP_START_DATE,DATE,新的作業(yè)開(kāi)始時(shí)間

OLD_WIP_START_DATE,DATE,老的作業(yè)開(kāi)始時(shí)間

DISPOSITION_ID,NUMBER,聯(lián)接標(biāo)識(shí)*

DISPOSITION_STATUS_TYPE,NUMBER,聯(lián)接類型

ORDER_TYPE,NUMBER,訂單類型

VENDOR_ID,NUMBER,供應(yīng)商標(biāo)識(shí)碼

NEW_ORDER_QU