Product: | MSC - Advanced Supply Chain Planning |
---|---|
Description: | This table stores all the demands taken into account for planning. Disposition_id would be a foreign key to MSC_SUPPLIES for dependent demands. For independent demands, disposition_id holds MRP_SCHEDULE_DATES.MPS_TRANSACTION_ID. |
Implementation/DBA Data: |
![]() |
Table | |
Foreign Table | Foreign Key Column |
---|---|---|---|
MSC_DEMANDS | ![]() |
![]() |
MSC_DEMANDS.INVENTORY_ITEM_ID
MSC_DEMANDS.PLAN_ID MSC_DEMANDS.SR_INSTANCE_ID MSC_DEMANDS.ORGANIZATION_ID |
MSC_DEMANDS | ![]() |
![]() |
MSC_DEMANDS.ORGANIZATION_ID
MSC_DEMANDS.TASK_ID MSC_DEMANDS.PROJECT_ID MSC_DEMANDS.SR_INSTANCE_ID MSC_DEMANDS.PLAN_ID |
MSC_DEMANDS | ![]() |
![]() |
MSC_DEMANDS.SHIP_TO_SITE_ID |
MSC_DEMANDS | ![]() |
![]() |
MSC_DEMANDS.SCHEDULE_DESIGNATOR_ID |
MSC_DEMANDS | ![]() |
![]() |
MSC_DEMANDS.PLAN_ID
MSC_DEMANDS.DISPOSITION_ID |
MSC_DEMANDS | ![]() |
![]() |
MSC_DEMANDS.CUSTOMER_ID |
MSC_DEMANDS | ![]() |
![]() |
MSC_DEMANDS.CUSTOMER_SITE_ID |
MSC_DEMANDS | ![]() |
![]() |
MSC_DEMANDS.USING_ASSEMBLY_ITEM_ID
MSC_DEMANDS.PLAN_ID MSC_DEMANDS.SR_INSTANCE_ID MSC_DEMANDS.ORGANIZATION_ID |
MSC_DEMANDS | ![]() |
![]() |
MSC_DEMANDS.PLAN_ID
MSC_DEMANDS.SR_INSTANCE_ID MSC_DEMANDS.PROJECT_ID MSC_DEMANDS.ORGANIZATION_ID |
MSC_DEMANDS | ![]() |
![]() |
MSC_DEMANDS.PLAN_ID
MSC_DEMANDS.PARENT_ID |
![]() |
![]() |
MSC_DEMANDS |
MSC_DEMANDS.PLAN_ID
MSC_DEMANDS.PARENT_ID |
![]() |
![]() |
MSC_DEMANDS |
MSC_FORECAST_UPDATES.PLAN_ID
MSC_FORECAST_UPDATES.FORECAST_DEMAND_ID MSC_FORECAST_UPDATES.SR_INSTANCE_ID |
![]() |
![]() |
MSC_DEMANDS |
MSC_FULL_PEGGING.PLAN_ID
MSC_FULL_PEGGING.DEMAND_ID |
|
|
|