Advanced Supply Chain Planning - MSC_NET_RESOURCE_AVAIL | This table stores the resource availability profile of the different resources. |
---|---|
Column Name | Descritpion |
PARENT_ID | Reference to parent transaction identifier |
STATUS | Attribute used for online replanning |
APPLIED | Attribute used for online replanning |
UPDATED | Flag to determine whether add workday modification was applied |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
PLAN_ID | Plan identifier |
REQUEST_ID | Concurrent Who column |
PROGRAM_APPLICATION_ID | Concurrent Who column |
PROGRAM_ID | Concurrent Who column |
PROGRAM_UPDATE_DATE | Concurrent Who column |
ATTRIBUTE_CATEGORY | Descriptive flexfield structure defining column |
ATTRIBUTE1 | Descriptive flexfield segment |
ATTRIBUTE2 | Descriptive flexfield segment |
ORGANIZATION_ID | Organization identifier |
ATTRIBUTE3 | Descriptive flexfield segment |
ATTRIBUTE4 | Descriptive flexfield segment |
ATTRIBUTE5 | Descriptive flexfield segment |
ATTRIBUTE6 | Descriptive flexfield segment |
ATTRIBUTE7 | Descriptive flexfield segment |
ATTRIBUTE8 | Descriptive flexfield segment |
ATTRIBUTE9 | Descriptive flexfield segment |
ATTRIBUTE10 | Descriptive flexfield segment |
ATTRIBUTE11 | Descriptive flexfield segment |
ATTRIBUTE12 | Descriptive flexfield segment |
SR_INSTANCE_ID | Source application instance identifier |
ATTRIBUTE13 | Descriptive flexfield segment |
ATTRIBUTE14 | Descriptive flexfield segment |
ATTRIBUTE15 | Descriptive flexfield segment |
REFRESH_NUMBER | Refresh number populated by the collection program |
RESOURCE_ID | Resource identifier |
DEPARTMENT_ID | Department identifier (-1 for lines) |
SIMULATION_SET | Simulation set identifier |
NEW_PLAN_ID | |
NEW_PLAN_LIST | |
SIMULATION_SET_ID | |
TRANSACTION_ID | System generated number which uniquely identifies the row |
SHIFT_NUM | Shift number |
SHIFT_DATE | Calendar date |
FROM_TIME | Shift start time |
TO_TIME | Shift end time |
CAPACITY_UNITS | Number of units available during the time interval |
AGGREGATE_RESOURCE_ID | Reference to aggregate resource, if resource aggregated (denormalized column) |
Advanced Supply Chain Planning - MSC_OPERATION_COMPONENTS | This table is the intersection table between MSC_BOM_COMPONENTS and MSC_ROUTING_OPERATIONS. |
---|---|
Column Name | Descritpion |
PLAN_ID | Plan identifier |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
REQUEST_ID | Concurrent Who column |
ORGANIZATION_ID | Organization identifier |
PROGRAM_APPLICATION_ID | Concurrent Who column |
PROGRAM_ID | Concurrent Who column |
PROGRAM_UPDATE_DATE | Concurrent Who column |
OPERATION_SEQUENCE_ID | Operation identifier |
COMPONENT_SEQUENCE_ID | Component item identifier |
SR_INSTANCE_ID | Source application instance identifier |
BILL_SEQUENCE_ID | Build sequence identifier |
ROUTING_SEQUENCE_ID | Routing identifier |
REFRESH_NUMBER | Refresh number populated by the collection program |
LAST_UPDATE_DATE | Standard Who column |
Advanced Supply Chain Planning - MSC_OPERATION_RESOURCES | This table stores operation resources from a resource sequence. For each resource sequence, we have an alternative between different set of operation resources. This is described by the Alternate Number. Resources with the same Alternate |
---|---|
Column Name | Descritpion |
PLAN_ID | Plan identifier |
RESOURCE_UNITS | Operation resource units (capacity). This can be fixed by the user and used as constraint |
UOM_CODE | Unit of measure code |
SR_INSTANCE_ID | Source application instance identifier |
REFRESH_NUMBER | Refresh number populated by the collection program |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
ROUTING_SEQUENCE_ID | Routing sequence identifier from source application instance |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
REQUEST_ID | Concurrent Who column |
PROGRAM_APPLICATION_ID | Concurrent Who column |
OPERATION_SEQUENCE_ID | Operation sequence identifier |
PROGRAM_ID | Concurrent Who column |
ALTERNATE_NUMBER | Resources with the same number are simultaneous. Different numbers are represent alternatives between groups of resources |
PROGRAM_UPDATE_DATE | Concurrent Who column |
ATTRIBUTE_CATEGORY | Descriptive flexfield structure defining column |
ATTRIBUTE1 | Descriptive flexfield segment |
ATTRIBUTE2 | Descriptive flexfield segment |
ATTRIBUTE3 | Descriptive flexfield segment |
ATTRIBUTE4 | Descriptive flexfield segment |
ATTRIBUTE5 | Descriptive flexfield segment |
ATTRIBUTE6 | Descriptive flexfield segment |
ATTRIBUTE7 | Descriptive flexfield segment |
ATTRIBUTE8 | Descriptive flexfield segment |
ATTRIBUTE9 | Descriptive flexfield segment |
ATTRIBUTE10 | Descriptive flexfield segment |
ATTRIBUTE11 | Descriptive flexfield segment |
ATTRIBUTE12 | Descriptive flexfield segment |
ATTRIBUTE13 | Descriptive flexfield segment |
ATTRIBUTE14 | Descriptive flexfield segment |
ATTRIBUTE15 | Descriptive flexfield segment |
RESOURCE_SEQ_NUM | Resource sequence number |
RESOURCE_TYPE | Resource type |
RESOURCE_ID | Resource identifier |
ORGANIZATION_ID | |
SETUP_ID | |
MINIMUM_CAPACITY | |
MAXIMUM_CAPACITY | |
ORIG_RESOURCE_SEQ_NUM | |
BREAKABLE_ACTIVITY_FLAG | |
NEW_PLAN_ID | |
NEW_PLAN_LIST | |
APPLIED | |
SIMULATION_SET_ID | |
PRINCIPAL_FLAG | Flag to indicate whether the resource is the principal resource |
BASIS_TYPE | Item(1), lot(2), resource units(3), resource value(4), total value(5), activity(6). |
RESOURCE_USAGE | Alternate resource volume necessary for this operation resource |
MAX_RESOURCE_UNITS | Maximum number of resource units consumed by this operation resource |
Advanced Supply Chain Planning - MSC_OPERATION_RESOURCE_SEQS | This tables stores the operation resources for each routing operation. |
---|---|
Column Name | Descritpion |
PLAN_ID | Plan identifier |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
ROUTING_SEQUENCE_ID | Routing sequence identifier from source application instance |
REQUEST_ID | Concurrent Who column |
PROGRAM_APPLICATION_ID | Concurrent Who column |
PROGRAM_ID | Concurrent Who column |
PROGRAM_UPDATE_DATE | Concurrent Who column |
CUMMULATIVE_PCT | Refresh number populated by the collection program |
ACTIVITY_GROUP_ID | Acttivity Group Id |
OPERATION_SEQUENCE_ID | Operation sequence identifier |
ORGANIZATION_ID | |
NEW_PLAN_ID | |
NEW_PLAN_LIST | |
APPLIED | |
SIMULATION_SET_ID | |
RESOURCE_SEQ_NUM | Resource sequence number from source application instance |
SCHEDULE_FLAG | Flag to determine the possibility of overlapping of this operation resource and operation resources in other operations |
RESOURCE_OFFSET_PERCENT | Percentage of total lead time up to the beginning of this operation resource |
DEPARTMENT_ID | Department identifier in which the operation takes place |
SR_INSTANCE_ID | Source application instance identifier |
REFRESH_NUMBER | Refresh number populated by the collection program |
Advanced Supply Chain Planning - MSC_PARAMETERS | This table stores information about how the planning process works for a given organization. Each organization will have an entry in MSC_PARAMETERS if it is using planning. |
---|---|
Column Name | Descritpion |
CONSIDER_RESERVATIONS | lag to indicate whether to plan material reservations |
PART_INCLUDE_TYPE | lag to indicate which part to include. All Planned Items(1), MDS/MPS components only(2), MDS/MPS and WIP components only(3) |
DEFAULT_ABC_ASSIGNMENT_GROUP | Default ABC assignment group identifier |
PERIOD_TYPE | Calculate periods based on work dates or calendar dates |
RESCHED_ASSUMPTION | Reschedule assumption |
PLAN_DATE_DEFAULT_TYPE | Plan date default type |
INCLUDE_REP_SUPPLY_DAYS | Flag to indicate whether to include Supply days |
INCLUDE_MDS_DAYS | Flag to indicate whether to include MDS days |
LAST_UPDATE_DATE | Standard Who column |
ORGANIZATION_ID | Organization identifier |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
REQUEST_ID | Concurrent Who column |
SR_INSTANCE_ID | Source application instance identifier |
PROGRAM_APPLICATION_ID | Concurrent Who column |
PROGRAM_ID | Concurrent Who column |
PROGRAM_UPDATE_DATE | Concurrent Who column |
ATTRIBUTE_CATEGORY | Descriptive flexfield structure defining column |
ATTRIBUTE1 | Descriptive flexfield segment |
ATTRIBUTE2 | Descriptive flexfield segment |
ATTRIBUTE3 | Descriptive flexfield segment |
ATTRIBUTE4 | Descriptive flexfield segment |
DEMAND_TIME_FENCE_FLAG | Flag to indicate whether to consider demand time fence |
ATTRIBUTE5 | Descriptive flexfield segment |
ATTRIBUTE6 | Descriptive flexfield segment |
ATTRIBUTE7 | Descriptive flexfield segment |
ATTRIBUTE8 | Descriptive flexfield segment |
ATTRIBUTE9 | Descriptive flexfield segment |
ATTRIBUTE10 | Descriptive flexfield segment |
ATTRIBUTE11 | Descriptive flexfield segment |
ATTRIBUTE12 | Descriptive flexfield segment |
ATTRIBUTE13 | Descriptive flexfield segment |
ATTRIBUTE14 | Descriptive flexfield segment |
ATTRIBUTE15 | Descriptive flexfield segment |
REPETITIVE_HORIZON1 | First repetitive horizon |
REPETITIVE_HORIZON2 | Second repetitive horizon |
REPETITIVE_BUCKET_SIZE1 | First repetitive bucket |
REPETITIVE_BUCKET_SIZE2 | Second repetitive bucket |
PLANNING_TIME_FENCE_FLAG | Flag to indicate whether to conside planning time fence |
REPETITIVE_BUCKET_SIZE3 | Third repetitive bucket |
REPETITIVE_ANCHOR_DATE | Repetitive anchor date |
COLLECTED_FLAG | Flag to indicate whether the row is collected from source applicaiton |
NETWORK_SCHEDULING_METHOD | Network Scheduling Method |
INCLUDE_PAST_DUE_FORECAST | |
OPERATION_SCHEDULE_TYPE | Schedule planned order demand to the operation that requires it, or to the start date of the planned order? |
CONSIDER_WIP | Flag to indicate whether to consider WIP |
CONSIDER_PO | Flag to indicate whether to consider PO |
SNAPSHOT_LOCK | Flag to indicate whether the snapshot should try to lock tables |
PLAN_SAFETY_STOCK | Flag to indicate whether to plan safety stock |
Advanced Supply Chain Planning - MSC_PLANS | This table stores different plans, with their names, and settings in the Oracle Advanced Planning and Scheduling(APS) and Oracle Supply Chain Hub products. |
---|---|
Column Name | Descritpion |
PLAN_ID | Plan identifier |
ASSIGNMENT_SET_ID | Assignment set identifier |
CURR_PLAN_TYPE | Specify whether the plan is MRP, DRP or MPS plan |
WEEKLY_ITEM_AGGREGATION_LEVEL | Weekly aggregation for material in this term (should be at least as aggregated as the preceding term) |
WEEKLY_MATERIAL_CONSTRAINTS | Material constraints at the weekly level |
WEEKLY_RESOURCE_CONSTRAINTS | Resource constraints at the weekly level |
WEEKLY_RES_AGGREGATION_LEVEL | Weekly aggregation for resources in this term (should be at least as aggregated as the preceding term) |
WEEKLY_TRANS_CONSTRAINTS | Transfortation constraints at the weekly level |
OPTIMIZE_FLAG | Optimize flag |
SCHEDULE_FLAG | Schedule flag |
ONLINE_PLANNER_START_DATE | Online Planner start date and time |
ONLINE_PLANNER_COMPLETION_DATE | Online Planner completion date and time |
TRANSPORT_CAP_OVER_UTIL_COST | The Penalty cost for transportation capacity |
ENFORCE_SL_CONSTRAINTS | Enforce SL constraints |
BILL_OF_RESOURCES | Bill of resource code |
SIMULATION_SET | Simulation set identifier |
CURR_ENFORCE_SL_CONSTRAINTS | Current enforce SL constraints |
CONSIDER_WIP | Consider work in process flag |
CONSIDER_PO | Consider purchase orders flag |
PLAN_SAFETY_STOCK | Plan safety stock flag |
CONSIDER_RESERVATIONS | Plan material reservations |
CURR_ENFORCE_DEM_DUE_DATES | Current value of enforce demand due dates |
CURR_RESERVATION_LEVEL | Current value of reservation level |
ENFORCE_DEM_DUE_DATES | Enforce demand due dates |
PLANNED_RESOURCES | Planned resources flag |
CURR_PLANNED_RESOURCES | Current value of planned resource flag |
DEM_PRIORITY_RULE_ID | Demand priority rule identifier |
CURR_DEM_PRIORITY_RULE_ID | Current value of demand priority rule identifier |
DAILY_RTG_AGGREGATION_LEVEL | Daily aggregation for routings |
WEEKLY_RTG_AGGREGATION_LEVEL | Weekly aggregation for routings |
PERIOD_RTG_AGGREGATION_LEVEL | Period aggregation for routings |
PERIOD_CUTOFF_BUCKET | Period cutoff bucket |
LOT_FOR_LOT_FLAG | Lot for lot flag |
ENFORCE_CAP_CONSTRAINTS | Enforce cap constraints flag |
CURR_ENFORCE_CAP_CONSTRAINTS | Current enforce cap constraints |
SERVICE_LEVEL | Service level |
BOTTLENECK_RES_GROUP | Bottleneck resource group |
CURR_BOTTLENECK_RES_GROUP | Current value of bottleneck resource group |
PERIOD_MATERIAL_CONSTRAINTS | Material constraints at the period level |
PERIOD_RESOURCE_CONSTRAINTS | Period aggregation for resources in this term (should be at least as aggregated as the preceeding term) |
PERIOD_TRANS_CONSTRAINTS | Transfortaion contraints at the period level |
PERIOD_ITEM_AGGREGATION_LEVEL | Period aggregation for material in this term (should be at least as aggregated as the preceding term) |
PERIOD_RES_AGGREGATION_LEVEL | Period aggregation for resources in this term (should be at least as aggregated as the preceeding term) |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
LOT_FOR_LOT | Lot for lot flag |
CURR_SCHEDULE_DESIGNATOR | Current schedule designator code |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
ATTRIBUTE1 | Descriptive Flexfield segment |
ATTRIBUTE2 | Descriptive Flexfield segment |
ATTRIBUTE3 | Descriptive Flexfield segment |
ATTRIBUTE4 | Descriptive Flexfield segment |
ATTRIBUTE5 | Descriptive Flexfield segment |
CURR_SCHEDULE_TYPE | MDS(1) or MPS(2). Used for single organization. Option to schedule against only MDS or only MPS |
ATTRIBUTE6 | Descriptive Flexfield segment |
ATTRIBUTE7 | Descriptive Flexfield segment |
ATTRIBUTE8 | Descriptive Flexfield segment |
ATTRIBUTE9 | Descriptive Flexfield segment |
ATTRIBUTE10 | Descriptive Flexfield segment |
ATTRIBUTE11 | Descriptive Flexfield segment |
ATTRIBUTE12 | Descriptive Flexfield segment |
ATTRIBUTE13 | Descriptive Flexfield segment |
ATTRIBUTE14 | Descriptive Flexfield segment |
ATTRIBUTE15 | Descriptive Flexfield segment |
CURR_SIMULATION_SET | Current value of simulation set |
ATTRIBUTE_CATEGORY | Descriptive Flexfield structure defining column |
REQUEST_ID | Concurrent Who column |
PROGRAM_APPLICATION_ID | Concurrent Who column |
PROGRAM_ID | Concurrent Who column |
PROGRAM_UPDATE_DATE | Concurrent Who column |
MIN_WF_EXCEPT_ID | Minimum workflow exception identifier |
MAX_WF_EXCEPT_ID | Maximum workflow exception identifier |
ONLINE_REPLAN | Online replan |
REFRESH_NUMBER | Refresh number |
REVISION | Revision |
PARENT_PLAN_ID | Parent plan identifier |
STATUS | Status |
PRODUCTION_FLAG | Production flag |
COMPANY_AGG_LEVEL | Company Aggregation level |
CURR_SNAPSHOT_LOCK | Current value of the flag that determines whether the Snapshot tries to lock tables |
TP_AGG_LEVEL | Trading partner aggregation level |
PRODUCT_AGG_LEVEL | Product aggregation level |
PURGE | Purge |
PLAN_INVENTORY_POINT | Flag to indicate whether to create and schedule orders till next planned inventory point |
ENABLE_CLOSEST_QTY_PEGGING | Enable Closest Qty Pegging |
CURR_CLOSEST_QTY_PEG | Curr Enable Closest Qty Peg |
ENABLE_PRIORITY_PEGGING | Enable Priority Pegging |
CURR_PRIORITY_PEGGING | Curr Enable Priority Pegging |
ENFORCE_SRC_CONSTRAINTS | Enforce Src Constraints |
CURR_ENFORCE_SRC_CONSTRAINTS | Curr Enforce Src Constraints |
BACKWARD_DAYS | Backward Days |
CURR_BACKWARD_DAYS | Curr Backward Days |
FORWARD_DAYS | Forward Days |
CURR_FORWARD_DAYS | Curr Forward Days |
SUMMARY_FLAG | summary flag |
USE_ALTERNATE_RESOURCES | use alternate resources. |
CURR_SPLIT_DEMANDS | Flag to indicate whether to allow demand splitting |
USE_END_ITEM_SUBSTITUTIONS | use end item substitutions |
USE_ALTERNATE_BOM_ROUTING | use alternate bom routing |
USE_SUBSTITUTE_COMPONENTS | use substitute component |
USE_ALTERNATE_SOURCES | use alternate resources |
SUBSTITUTION_DESIGNATOR | substitution designator |
KPI_REFRESH | kpi refresh option |
DISPLAY_KPI | display kpi option |
FORECAST_ALLOCATION_METHOD | |
FORECAST_CONSUMPTION_METHOD | |
COPY_PLAN_ID | |
CURR_START_DATE | Start date of the planning horizon |
CUTOFF_DATE | End date of the planning horizon |
DAILY_CUTOFF_BUCKET | Daily end date of the planning horizon |
COMPILE_DESIGNATOR | Name of the plan |
CURR_APPEND_PLANNED_ORDERS | Flag to indicate whether to create new planned orders - or just redo allocation |
DAILY_ITEM_AGGREGATION_LEVEL | Daily aggregation for material in this term (should be at least as aggregated as the preceding term) |
DAILY_MATERIAL_CONSTRAINTS | Flag to indicate whether to use constraint on material availability |
DAILY_RESOURCE_CONSTRAINTS | Flag to indicate whether to use constraint on resource availability |
DAILY_RES_AGGREGATION_LEVEL | Daily aggregation for resources in this term (should be at least as aggregated as the preceding term) |
DAILY_TRANS_CONSTRAINTS | Flag to indicate whether to use transportation constraints |
CURR_ASSIGNMENT_SET_ID | Current assignment set identifier |
DATA_COMPLETION_DATE | Data completion date |
DATA_START_DATE | Data start date |
DEMAND_TIME_FENCE_FLAG | Flag to indicate whether to use the demand time fence. The Demand Time Fence is defined at the item level |
DESCRIPTION | Textual description of the plan |
DMD_LATENESS_PENALTY_COST | Demand lateness penalty cost |
SR_INSTANCE_ID | Source instance id for the org |
CURR_BILL_OF_RESOURCES | Current value of bill of resources |
HARD_PEGGING_LEVEL | Plan level option that determines the pegging granularity of planned orders |
FULL_PEGGING | Full pegging flag |
HOUR_CUTOFF_BUCKET | End date of the planning horizon in hours |
INCLUDED_ITEMS | Complementary item to decide which item to plan. MRP(1), MRP and DRP(2), MPS(3), MRP and MPS(4), all items(5) |
MIN_CUTOFF_BUCKET | End date of the planning horizon in minutes |
MONTHLY_CUTOFF_BUCKET | Monthly end date of the planning horizon |
CURR_CONSIDER_PO | Current value of consider po flag |
CURR_CONSIDER_RESERVATIONS | Current value of consider reservations flag |
OBJECTIVE_WEIGHT_1 | Weight of the first objective |
OBJECTIVE_WEIGHT_10 | Weight of the tenth objective |
OBJECTIVE_WEIGHT_2 | Weight of the second objective |
OBJECTIVE_WEIGHT_3 | Weight of the third objective |
OBJECTIVE_WEIGHT_4 | Weight of the fourth objective |
CURR_CONSIDER_WIP | Current value of consider wip flag |
OBJECTIVE_WEIGHT_5 | Weight of the fifth objective |
OBJECTIVE_WEIGHT_6 | Weight of the sixth objective |
OBJECTIVE_WEIGHT_7 | Weight of the seventh objective |
OBJECTIVE_WEIGHT_8 | Weight of the eighth objective |
OBJECTIVE_WEIGHT_9 | Weight of the ninth objective |
APPEND_PLANNED_ORDERS | Flag to indicate whether to create new planned orders - or just redo allocation |
CURR_CUTOFF_DATE | End date of the planning horizon |
OPERATION_SCHEDULE_TYPE | Lead-time offset type |
ORGANIZATION_ID | Organization identifier of the organization owning the plan |
ORGANIZATION_SELECTION | Organizition selection flag |
OVERWRITE_OPTION | Flag to indicate whether to overwrite existing plan. All(1), Outside planning time fence(2), None(3) |
PART_INCLUDE_TYPE | What items to plan: all(1), MDS an MPS only(2), or MDS, MPS, and WIP components(3) |
CURR_DEMAND_TIME_FENCE_FLAG | Flag to indicate whether to use the demand time fence. The Demand Time Fence is defined at the item level |
PENALTY_COST_1 | Penalty cost for objective 1 |
PENALTY_COST_10 | Penalty cost for objective 10 |
PENALTY_COST_2 | Penalty cost for objective 2 |
PENALTY_COST_3 | Penalty cost for objective 3 |
PENALTY_COST_4 | Penalty cost for objective 4 |
CURR_HARD_PEGGING_LEVEL | Current value of hard pegging level |
PENALTY_COST_5 | Penalty cost for objective 5 |
PENALTY_COST_6 | Penalty cost for objective 6 |
PENALTY_COST_7 | Penalty cost for objective 7 |
CURR_FULL_PEGGING | Current value of full pegging flag |
PENALTY_COST_8 | Penalty cost for objective 8 |
PENALTY_COST_9 | Penalty cost for objective 9 |
CURR_INCLUDED_ITEMS | Complementary item to decide which item to plan. MRP(1), MRP and DRP(2), MPS(3), MRP and MPS(4), all items(5) |
PLANNED_REFRESHES | Plan refresh flag |
PLANNING_TIME_FENCE_FLAG | Flag to indicate whether to use the planning time fence. The Planning Time Fence is defined at the item level |
PLAN_CAPACITY_FLAG | Current flag to indicate whether to plan capacity requirements |
PLAN_COMPLETION_DATE | Plan completion date |
CURR_OPERATION_SCHEDULE_TYPE | Lead-time offset type |
PLAN_START_DATE | Plan start date |
PLAN_TYPE | Specify whether the plan is MRP, DRP or MPS plan |
QTRLY_CUTOFF_BUCKET | Quaterly end date of the planning horizon |
CURR_OVERWRITE_OPTION | Flag to indicate whether to overwrite existing plan. All(1), Outside planning time fence(2), None(3) |
RESERVATION_LEVEL | Plan level option which indicates at what level MRP will reserve supply against demand |
CURR_PART_INCLUDE_TYPE | What items to plan: all(1), MDS an MPS only(2), or MDS, MPS, and WIP components(3) |
RESOURCE_OVER_UTIL_COST | Resource overutilization cost |
SCHEDULE_DESIGNATOR | Schedule designator |
SCHEDULE_TYPE | MDS(1) or MPS(2). Used for single organization. Option to schedule against only MDS or only MPS |
SLACK_ALLOWED_FLAG_1 | Flag to indicate whether Slack allowed for objective 1 |
SLACK_ALLOWED_FLAG_10 | Flag to indicate whether Slack allowed for objective 10 |
CURR_PLANNING_TIME_FENCE_FLAG | Flag to indicate whether to use the planning time fence. The Planning Time Fence is defined at the item level |
SLACK_ALLOWED_FLAG_2 | Flag to indicate whether Slack allowed for objective 2 |
SLACK_ALLOWED_FLAG_3 | Flag to indicate whether Slack allowed for objective 3 |
SLACK_ALLOWED_FLAG_4 | Flag to indicate whether Slack allowed for objective 4 |
SLACK_ALLOWED_FLAG_5 | Flag to indicate whether Slack allowed for objective 5 |
SLACK_ALLOWED_FLAG_6 | Flag to indicate whether Slack allowed for objective 6 |
CURR_PLAN_CAPACITY_FLAG | Current flag to indicate whether to plan capacity requirements |
SLACK_ALLOWED_FLAG_7 | Flag to indicate whether Slack allowed for objective 7 |
SLACK_ALLOWED_FLAG_8 | Flag to indicate whether Slack allowed for objective 8 |
SLACK_ALLOWED_FLAG_9 | Flag to indicate whether Slack allowed for objective 9 |
SNAPSHOT_LOCK | Flag to determine whether the Snapshot should try to lock tables |
SPLIT_DEMANDS | Flag to indicate whether to allow demand splitting |
CURR_PLAN_SAFETY_STOCK | Current value of plan safety stock flag |
START_DATE | Start date of the planning horizon |
SUPPLIER_CAP_OVER_UTIL_COST | Supplier capacity overutilization cost |
WEEKLY_CUTOFF_BUCKET | Weekly end date of the planning horizon |
Advanced Supply Chain Planning - MSC_PLAN_BUCKETS | This table stores bucket dates for Planner Workbench Horizontal Plan. |
---|---|
Column Name | Descritpion |
PLAN_ID | Plan identifier |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
REQUEST_ID | Concurrent Who column |
PROGRAM_APPLICATION_ID | Concurrent Who column |
PROGRAM_ID | Concurrent Who column |
PROGRAM_UPDATE_DATE | Concurrent Who column |
ATTRIBUTE_CATEGORY | Descriptive flexfield structure defining column |
ATTRIBUTE1 | Descriptive flexfield segment |
ATTRIBUTE2 | Descriptive flexfield segment |
ATTRIBUTE3 | Descriptive flexfield segment |
ORGANIZATION_ID | Organization identifier |
ATTRIBUTE4 | Descriptive flexfield segment |
ATTRIBUTE5 | Descriptive flexfield segment |
ATTRIBUTE6 | Descriptive flexfield segment |
ATTRIBUTE7 | Descriptive flexfield segment |
ATTRIBUTE8 | Descriptive flexfield segment |
ATTRIBUTE9 | Descriptive flexfield segment |
ATTRIBUTE10 | Descriptive flexfield segment |
ATTRIBUTE11 | Descriptive flexfield segment |
ATTRIBUTE12 | Descriptive flexfield segment |
ATTRIBUTE13 | Descriptive flexfield segment |
SR_INSTANCE_ID | Source application identifier of the source organization |
BUCKET_INDEX | Used for sorting bucket dates within the plan organization |
ATTRIBUTE14 | Descriptive flexfield segment |
ATTRIBUTE15 | Descriptive flexfield segment |
CURR_FLAG | Flag indicating whether this record is the current record |
BKT_START_DATE | The start date of buckets |
BKT_END_DATE | The end date of buckets |
DAYS_IN_BKT | Number of Days in buckets |
BUCKET_TYPE | Specify the type of bucket date (period, weekly, daily) |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
Advanced Supply Chain Planning - MSC_PLAN_ORGANIZATIONS | This table stores the parameters relative to organizations that participate to the plan in Oracle Advanced Planning and Scheduling (APS). This table also contains the different companies which are collaborating in a supply or demand plan in |
---|---|
Column Name | Descritpion |
PLAN_ID | Plan identifier |
PLAN_LEVEL | Plan level |
ORGANIZATION_DESCRIPTION | Description of the organization |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
REQUEST_ID | Concurrent Who column |
PROGRAM_APPLICATION_ID | Concurrent Who column |
PROGRAM_ID | Concurrent Who column |
ORGANIZATION_ID | Organization identifier |
PROGRAM_UPDATE_DATE | Concurrent Who column |
ATTRIBUTE_CATEGORY | Descriptive Flexfield structure defining column |
ATTRIBUTE1 | Descriptive Flexfield segment |
ATTRIBUTE2 | Descriptive Flexfield segment |
ATTRIBUTE3 | Descriptive Flexfield segment |
ATTRIBUTE4 | Descriptive Flexfield segment |
ATTRIBUTE5 | Descriptive Flexfield segment |
ATTRIBUTE6 | Descriptive Flexfield segment |
ATTRIBUTE7 | Descriptive Flexfield segment |
ATTRIBUTE8 | Descriptive Flexfield segment |
SR_INSTANCE_ID | Source instance identifier for the org |
ATTRIBUTE9 | Descriptive Flexfield segment |
ATTRIBUTE10 | Descriptive Flexfield segment |
ATTRIBUTE11 | Descriptive Flexfield segment |
ATTRIBUTE12 | Descriptive Flexfield segment |
ATTRIBUTE13 | Descriptive Flexfield segment |
ATTRIBUTE14 | Descriptive Flexfield segment |
ATTRIBUTE15 | Descriptive Flexfield segment |
COLLAB_ROLE | Collaboration Role |
CONTACT | Collaboration contact |
CALENDAR_CODE | Calendar code used by exchange |
ORGANIZATION_CODE | Organization code |
INCLUDE_SALESORDER | Include sales order |
PLAN_COMPLETION_DATE | Plan completion date for exchange plans |
NET_WIP | Flag to indicate whether to allow netting from WIP |
NET_RESERVATIONS | Flag to indicate whether to allow netting from reservations |
NET_PURCHASING | Flag to indicate whether to allow netting from purchase orders |
PLAN_SAFETY_STOCK | Flag to indicate whether to allow netting from safety stock |
SIMULATION_SET | Simulation set identifier |
BILL_OF_RESOURCES | Bill of resource name |
Advanced Supply Chain Planning - MSC_PLAN_SCHEDULES | This table stores master production schedules and master demand schedules for the planning process in an organization. This table is also used to store the input production schedule namefor In line vehicle sequencing (ILVS) on Oracle Supply |
---|---|
Column Name | Descritpion |
PLAN_ID | Plan identifier |
REQUEST_ID | Concurrent Who column |
PROGRAM_APPLICATION_ID | Concurrent Who column |
PROGRAM_ID | Concurrent Who column |
PROGRAM_UPDATE_DATE | Concurrent Who column |
ATTRIBUTE_CATEGORY | Descriptive Flexfield structure defining column |
ATTRIBUTE1 | Descriptive Flexfield segment |
ATTRIBUTE2 | Descriptive Flexfield segment |
ATTRIBUTE3 | Descriptive Flexfield segment |
ATTRIBUTE4 | Descriptive Flexfield segment |
ATTRIBUTE5 | Descriptive Flexfield segment |
ATTRIBUTE6 | Descriptive Flexfield segment |
ATTRIBUTE7 | Descriptive Flexfield segment |
ATTRIBUTE8 | Descriptive Flexfield segment |
ATTRIBUTE9 | Descriptive Flexfield segment |
ATTRIBUTE10 | Descriptive Flexfield segment |
ATTRIBUTE11 | Descriptive Flexfield segment |
ATTRIBUTE12 | Descriptive Flexfield segment |
ORGANIZATION_ID | Organization identifier |
ATTRIBUTE13 | Descriptive Flexfield segment |
ATTRIBUTE14 | Descriptive Flexfield segment |
ATTRIBUTE15 | Descriptive Flexfield segment |
DESIGNATOR_TYPE | Designator type |
INTERPLANT_DEMAND_FLAG | Interplant demand flag |
SCENARIO_SET | Scenario Set |
PROBABILITY | Probability |
DEMAND_VARIABILITY_TYPE | |
MAPE_VALUE | |
INPUT_SCHEDULE_ID | Input schedule identifier |
SR_INSTANCE_ID | Source application instance identifier |
INPUT_TYPE | Schedule type. MDS or MPS |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
Advanced Supply Chain Planning - MSC_PROCESS_EFFECTIVITY | This table stores links between the bill of material and routings and store effectivities for this process. |
---|---|
Column Name | Descritpion |
PLAN_ID | Plan idenfitier |
ROUTING_SEQUENCE_ID | Routing sequence identifier from source appliation |
BILL_SEQUENCE_ID | BOM identifier |
SR_INSTANCE_ID | Source application instance identifier |
TOTAL_PRODUCT_CYCLE_TIME | Total time that an assembly takes along the primary path in the operation network calculated by flow manufacturing |
ITEM_PROCESS_COST | Cost of alternate BOM and routing |
LINE_ID | Line unique identifier |
PRIMARY_LINE_FLAG | Flag indicating whether the line is used for lead time calculations |
PRODUCTION_LINE_RATE | Number of assemblies which run down the line per hour |
REFRESH_NUMBER | Refresh number populated by the collection program |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
PROCESS_SEQUENCE_ID | Process sequence identifier |
LAST_UPDATE_LOGIN | Standard Who column |
REQUEST_ID | Concurrent Who column |
PROGRAM_APPLICATION_ID | Concurrent Who column |
PROGRAM_ID | Concurrent Who column |
PROGRAM_UPDATE_DATE | Concurrent Who column |
LOAD_DISTRIBUTION_PRIORITY | Load distribution priority |
ITEM_ID | Item identifier of the product/co-product |
ORGANIZATION_ID | Organization identifier |
EFFECTIVITY_DATE | Effectivity date of the process |
DISABLE_DATE | Disable date of the process |
MINIMUM_QUANTITY | Minimum quantity for which the process can be used to produce the item, expressed in primary UOM |
MAXIMUM_QUANTITY | Maximum quantity for which the process can be used to produce the item, expressed in primary UOM |
PREFERENCE | Preference |
Advanced Supply Chain Planning - MSC_PROJECTS | This table stores the manufacturing parameters for a given project and organization. |
---|---|
Column Name | Descritpion |
PROJECT_ID | Project identifier or Seiban identifier |
PROJECT_NUMBER_SORT_ORDER | Sort order |
PROJECT_DESCRIPTION | Project description |
START_DATE | Start date |
COMPLETION_DATE | Completion date |
OPERATING_UNIT | Operating unit |
SR_INSTANCE_ID | Source application instance identifier |
REFRESH_NUMBER | Refresh number populated by the collection program |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
PLAN_ID | Plan identifer |
LAST_UPDATE_LOGIN | Standard Who column |
REQUEST_ID | Concurrent Who column |
PROGRAM_APPLICATION_ID | Concurrent Who column |
PROGRAM_ID | Concurrent Who column |
PROGRAM_UPDATE_DATE | Concurrent Who column |
ATTRIBUTE_CATEGORY | Descriptive flexfield structure defining column |
ATTRIBUTE1 | Descriptive flexfield segment |
ATTRIBUTE2 | Descriptive flexfield segment |
ATTRIBUTE3 | Descriptive flexfield segment |
ATTRIBUTE4 | Descriptive flexfield segment |
ATTRIBUTE5 | Descriptive flexfield segment |
ATTRIBUTE6 | Descriptive flexfield segment |
ATTRIBUTE7 | Descriptive flexfield segment |
ATTRIBUTE8 | Descriptive flexfield segment |
ATTRIBUTE9 | Descriptive flexfield segment |
ATTRIBUTE10 | Descriptive flexfield segment |
ORGANIZATION_ID | Organization identifier |
ATTRIBUTE11 | Descriptive flexfield segment |
ATTRIBUTE12 | Descriptive flexfield segment |
ATTRIBUTE13 | Descriptive flexfield segment |
ATTRIBUTE14 | Descriptive flexfield segment |
ATTRIBUTE15 | Descriptive flexfield segment |
MATERIAL_ACCOUNT | Material account |
MANAGER_CONTACT | Manager contace |
PLANNING_GROUP | Planning group assigned to this project |
COSTING_GROUP_ID | Costing group assigned to this project |
WIP_ACCT_CLASS_CODE | Default WIP accouting class assigned to this project |
SEIBAN_NUMBER_FLAG | Flag to indicate whether project_id identifies a project or a seiban |
PROJECT_NAME | Project name |
PROJECT_NUMBER | Project number |
Advanced Supply Chain Planning - MSC_PROJECT_TASKS | This table stores the tasks maufacturing parameters. |
---|---|
Column Name | Descritpion |
PROJECT_ID | Project identifier |
END_DATE | Disable date of the task |
SR_INSTANCE_ID | Source application instance identifier |
REFRESH_NUMBER | Refresh number populated by the collection program |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
REQUEST_ID | Concurrent Who column |
PROGRAM_APPLICATION_ID | Concurrent Who column |
PROGRAM_ID | Concurrent Who column |
TASK_ID | Task identifier |
PROGRAM_UPDATE_DATE | Concurrent Who column |
MANAGER_CONTACT | Manager contact |
PLAN_ID | Plan identifier |
ORGANIZATION_ID | Organziation identifier |
TASK_NUMBER | Task number |
TASK_NAME | Task name |
DESCRIPTION | Task description |
MANAGER | Manager of the task |
START_DATE | Effective date of the task |
Advanced Supply Chain Planning - MSC_RESOURCE_GROUPS | This table stores different resource groups. |
---|---|
Column Name | Descritpion |
GROUP_CODE | Resource group code |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
REQUEST_ID | Concurren Who column |
PROGRAM_APPLICATION_ID | Concurren Who column |
PROGRAM_ID | Concurren Who column |
PROGRAM_UPDATE_DATE | Concurren Who column |
ATTRIBUTE_CATEGORY | Descriptive flexfield structure defining column |
ATTRIBUTE1 | Descriptive flexfield segment |
ATTRIBUTE2 | Descriptive flexfield segment |
ATTRIBUTE3 | Descriptive flexfield segment |
ATTRIBUTE4 | Descriptive flexfield segment |
ATTRIBUTE5 | Descriptive flexfield segment |
ATTRIBUTE6 | Descriptive flexfield segment |
MEANING | Meaning of the resource group |
ATTRIBUTE7 | Descriptive flexfield segment |
ATTRIBUTE8 | Descriptive flexfield segment |
ATTRIBUTE9 | Descriptive flexfield segment |
ATTRIBUTE10 | Descriptive flexfield segment |
ATTRIBUTE11 | Descriptive flexfield segment |
ATTRIBUTE12 | Descriptive flexfield segment |
ATTRIBUTE13 | Descriptive flexfield segment |
ATTRIBUTE14 | Descriptive flexfield segment |
ATTRIBUTE15 | Descriptive flexfield segment |
DESCRIPTION | Description of the resource group |
FROM_DATE | Date of effectivity |
TO_DATE | Date of end of effectivity |
ENABLED_FLAG | Flag to indicate whether the resource group is enabled |
SR_INSTANCE_ID | Source application instance identifier |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
Advanced Supply Chain Planning - MSC_RESOURCE_REQUIREMENTS | This table stores the resource requirments generated by existing supplies. |
---|---|
Column Name | Descritpion |
TRANSACTION_ID | Resource requirement identifier |
START_DATE | Start date of the resource requirement |
ALTERNATE_NUM | Alternate number of the corresponding operation resource |
END_DATE | End date of the resource requirement |
BKT_START_DATE | Bucketed start date |
RESOURCE_HOURS | Resource hours required |
SET_UP | Setup time |
BKT_END_DATE | Bucketed end date |
TEAR_DOWN | Tear down time |
AGGREGATE_RESOURCE_ID | Reference to aggregate resource, if resource aggregated (denormalized column) |
SCHEDULE_FLAG | Schedule flag |
PARENT_ID | Referent to parent transaction identifier |
STD_OP_CODE | Standard op code |
WIP_ENTITY_ID | Wip entity identifier for DJ resource requirements |
ASSIGNED_UNITS | Assigned units |
BASIS_TYPE | Basis type |
OPERATION_SEQ_NUM | Operation seq Number |
LOAD_RATE | Load rate |
DAILY_RESOURCE_HOURS | Daily resource hours needed for repetitive schedules |
STATUS | Attribute used for online replanning |
APPLIED | Attribute used for online replanning |
UPDATED | Flag to determine whether add workday modification was applied |
SUBST_RES_FLAG | Flag indicating whether resource is substitute resource |
REFRESH_NUMBER | Refresh number populated by the collection program |
LAST_UPDATED_BY | Standard Who column |
LAST_UPDATE_DATE | Standard Who column |
CREATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
PLAN_ID | Plan identifier |
LAST_UPDATE_LOGIN | Standard Who column |
RESOURCE_ID | Resource identifier |
REQUEST_ID | Standard Who column |
PROGRAM_APPLICATION_ID | Standard Who column |
PROGRAM_ID | Standard Who column |
PROGRAM_UPDATE_DATE | Standard Who column |
SOURCE_ITEM_ID | Source inventory item unique identifier |
ASSEMBLY_ITEM_ID | Assembly item unique identifier |
SUPPLY_TYPE | Sypply type code |
FIRM_START_DATE | Firm start date |
FIRM_END_DATE | Firm end date |
FIRM_FLAG | Firm flag |
CUMMULATIVE_QUANTITY | Resource requirement identifier |
YIELD | Yield |
REVERSE_CUMULATIVE_YIELD | Reverse cumulative yield |
SUPPLY_ID | Supplier identifier |
BATCH_NUMBER | Batch Number |
MINIMUM_TRANSFER_QUANTITY | Department identifier |
REMAINING_CAPACITY | Remaining Capacity |
OVERLOADED_CAPACITY | overloaded capacity |
EARLIEST_START_DATE | For Improved Exceptions |
EARLIEST_COMPLETION_DATE | For Improved Exceptions |
SCHEDULED_DEMAND_ID | For Improved Exceptions |
ULPSD | Unconstrained Latest Possible Start Date/Time |
ULPCD | Unconstrained Latest Possible Completion Date/Time |
UEPSD | Unconstrained Earliest Possible Start Date/Time |
UEPCD | Unconstrained Earliest Possible Completion Date/Time |
EACD | Earliest Allowable Completion Date/Time |
PARENT_SEQ_NUM | |
SETUP_ID | |
ORGANIZATION_ID | Organization identifier |
RESOURCE_SEQ_NUM | Identifier of the planned resource requirement |
SR_INSTANCE_ID | Source instance identifier for the source org |
ROUTING_SEQUENCE_ID | Routing identifier used |
OPERATION_SEQUENCE_ID | Operation sequence identifier which generating the requirement |
DEPARTMENT_ID | Department identifier |
QUANTITY_IN_QUEUE | |
QUANTITY_RUNNING | |
QUANTITY_WAITING_TO_MOVE | |
QUANTITY_COMPLETED | |
USAGE_RATE | |
HOURS_EXPENDED | |
RECORD_SOURCE | |
ACTIVITY_GROUP_ID | |
PRINCIPAL_FLAG | |
GROUP_SEQUENCE_ID | |
GROUP_SEQUENCE_NUMBER | |
MAXIMUM_ASSIGNED_UNITS | |
MINIMUM_CAPACITY | |
MAXIMUM_CAPACITY | |
ORIG_RESOURCE_SEQ_NUM | |
BREAKABLE_ACTIVITY_FLAG | |
CAPACITY_CONSUMED_RATIO | |
FROM_SETUP_ID | |
STEP_QUANTITY | |
STEP_QUANTITY_UOM | |
UNADJUSTED_RESOURCE_HOURS | |
TOUCH_TIME | |
JIT_END_DATE | |
UNBUCKETED_START_DATE | |
UNBUCKETED_END_DATE | |
ACTUAL_START_DATE | |
TOTAL_RESOURCE_HOURS | |
ACTIVITY_NAME | |
OPERATION_NAME | |
OPERATION_STATUS | |
SHUTDOWN_TYPE | |
OPERATION_CODE | |
ACTUAL_END_DATE |
Advanced Supply Chain Planning - MSC_ROUTINGS | This table stores the different routings available for a bill of material. |
---|---|
Column Name | Descritpion |
SR_INSTANCE_ID | Source application instance identifier |
UOM_CODE | Unit of measure |
CFM_ROUTING_FLAG | Flag to indicate whether the routing is continuos flow or traditional routing |
CTP_FLAG | Flag to indicate whether capacity must be checked when item is ordered |
ASSEMBLY_ITEM_ID | Assembly item identifier |
ORGANIZATION_ID | Organization identifier |
ROUTING_QUANTITY | Routing quantity |
REFRESH_NUMBER | Refresh number populated by the collection program |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
ROUTING_SEQUENCE_ID | Source application operational routing sequence identifier |
CREATED_BY | Standard Who column |
ROUTING_TYPE | Manufacturing(1), or Engineering(2). For UI and reports |
LAST_UPDATE_LOGIN | Standard Who column |
REQUEST_ID | Concurrent Who column |
PROGRAM_APPLICATION_ID | Concurrent Who column |
PROGRAM_ID | Concurrent Who column |
PROGRAM_UPDATE_DATE | Concurrent Who column |
FIRST_OP_SEQ_NUM | Concurrent Who column |
LAST_OP_SEQ_NUM | Concurrent Who column |
COMMON_ROUTING_SEQUENCE_ID | |
AUTO_STEP_QTY_FLAG | |
REPAIRABLE | |
ACTIVITY_ITEM_ID | |
ROUTING_COMMENT | Comments. Used for UI and reports |
PLAN_ID | Plan identifier |
ALTERNATE_ROUTING_DESIGNATOR | Name of the alternate routing. Null for primary routing |
PROJECT_ID | Project identifier for project manufacturing |
TASK_ID | Task identifier for project manufacturing |
LINE_ID | For flow manufacturing. A routing is actually a line (not used for now) |
Advanced Supply Chain Planning - MSC_ROUTING_OPERATIONS | This tables stores the operations composing each routing. |
---|---|
Column Name | Descritpion |
TO_UNIT_NUMBER | Effective up to this unit number |
OPTION_DEPENDENT_FLAG | Flag to indicate whether this operation option dependent |
OPERATION_TYPE | Indicate operation type: Process, Line, or Event. Events are not used here |
MINIMUM_TRANSFER_QUANTITY | Minimum operation transfer quantity |
YIELD | Process yield at this operation |
DEPARTMENT_ID | Department identifier (source application identifier) in which the operation takes place |
DEPARTMENT_CODE | Department code (for reporting) |
OPERATION_LEAD_TIME_PERCENT | Indicates the amount of overlape its lead time has with the parent lead time |
CUMULATIVE_YIELD | Cummulative process yield from the beginning of routing to this operation |
REVERSE_CUMULATIVE_YIELD | Cummulative process yield from the end of routing to comparable operation |
OPERATION_SEQUENCE_ID | Operation sequence identifier |
NET_PLANNING_PERCENT | Cummulative planning percents derived from the operation network |
SETUP_DURATION | Duration of the set-up |
TEAR_DOWN_DURATION | Duration of the tear down for this operation |
UOM_CODE | Unit of measure |
STANDARD_OPERATION_CODE | Code of the standard operation on which this operation is based. Operations having the same code are identical |
REFRESH_NUMBER | Refresh number populated by the collection program |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
REQUEST_ID | Concurrent Who column |
PROGRAM_APPLICATION_ID | Concurrent Who column |
PROGRAM_ID | Concurrent Who column |
PROGRAM_UPDATE_DATE | Concurrent Who column |
USE_IN_PLAN | This column is used for Routing Effectivity Timestamp |
ROUTING_SEQUENCE_ID | Routing identifier |
ORGANIZATION_ID | |
STEP_QUANTITY | |
STEP_QUANTITY_UOM | |
NEW_PLAN_ID | |
NEW_PLAN_LIST | |
APPLIED | |
SIMULATION_SET_ID | |
PLAN_ID | Plan identifier |
OPERATION_SEQ_NUM | Operation sequence number |
SR_INSTANCE_ID | Source application instance identifier |
OPERATION_DESCRIPTION | Operation description (use for UI and reports) |
EFFECTIVITY_DATE | Date operation is effective |
DISABLE_DATE | End of effectivity |
FROM_UNIT_NUMBER | Effective from this unit number |
Advanced Supply Chain Planning - MSC_SAFETY_STOCKS | Safety stock levels |
---|---|
Column Name | Descritpion |
ORGANIZATION_ID | Organization identifier |
LAST_UPDATE_LOGIN | Standard Who column |
REQUEST_ID | Concurrent Who column |
PROGRAM_ID | Concurrent Who column |
PROGRAM_UPDATE_DATE | Concurrent Who column |
PROGRAM_APPLICATION_ID | Concurrent Who column |
SR_INSTANCE_ID | Source application instance identifier |
TARGET_SAFETY_STOCK | Target safety stock |
PROJECT_ID | project id |
TASK_ID | task id |
PLANNING_GROUP | planning group |
INVENTORY_ITEM_ID | Inventory item identifier |
PERIOD_START_DATE | Period start date |
SAFETY_STOCK_QUANTITY | Safety stock quantity |
UPDATED | Updated flag |
PLAN_ID | Plan identifier |
STATUS | Status flag |
REFRESH_NUMBER | Refresh number |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
Advanced Supply Chain Planning - MSC_SCHEDULING_RULES | This table stores the scheduling rules used to schedule lines. |
---|---|
Column Name | Descritpion |
RULE_ID | Scheduling rule identifier |
HEURISTIC_CODE | Heuristic algorithm for scheduling rule |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
REQUEST_ID | Concurrent Who column |
PROGRAM_APPLICATION_ID | Concurrent Who column |
PROGRAM_ID | Concurrent Who column |
PROGRAM_UPDATE_DATE | Concurrent Who column |
ATTRIBUTE_CATEGORY | Descriptive flexfield structure defining column |
MEANING | Scheduling rule code |
ATTRIBUTE1 | Descriptive flexfield segment |
ATTRIBUTE2 | Descriptive flexfield segment |
ATTRIBUTE3 | Descriptive flexfield segment |
ATTRIBUTE4 | Descriptive flexfield segment |
ATTRIBUTE5 | Descriptive flexfield segment |
ATTRIBUTE6 | Descriptive flexfield segment |
ATTRIBUTE7 | Descriptive flexfield segment |
ATTRIBUTE8 | Descriptive flexfield segment |
ATTRIBUTE9 | Descriptive flexfield segment |
ATTRIBUTE10 | Descriptive flexfield segment |
ATTRIBUTE11 | Descriptive flexfield segment |
ATTRIBUTE12 | Descriptive flexfield segment |
ATTRIBUTE13 | Descriptive flexfield segment |
ATTRIBUTE14 | Descriptive flexfield segment |
ATTRIBUTE15 | Descriptive flexfield segment |
DESCRIPTION | Description of the scheduling rule |
USER_DEFINED | Flag to indicate if the row is user defined or seeded by Oracle |
PACKAGE_NAME | User defined package name |
ENABLED_FLAG | Flag to indicate whether scheduling rule is enabled |
DEFAULT_FLAG | Default flag |
USAGE_CODE | Field used for sequencing |
SEQUENCE_NUMBER | Order to sequence |
Advanced Supply Chain Planning - MSC_SEQUENCE_DEPENDENT_SETUPS | The table stores the sequence dependent setups and tears down. This is used by HLS to ensure a minimun delay between two operations using the same resource. |
---|---|
Column Name | Descritpion |
PLAN_ID | Plan identifier |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
REQUEST_ID | Concurrent Who column |
PROGRAM_APPLICATION_ID | Concurrent Who column |
PROGRAM_ID | Concurrent Who column |
PROGRAM_UPDATE_DATE | Concurrent Who column |
ORGANIZATION_ID | Organization identifier |
SR_INSTANCE_ID | Source application instance id for source org |
FROM_ITEM | Predecessor item |
TO_ITEM | Successor item |
STANDARD_OPERATION_CODE | Standard operation the two operations have to share |
RESOURCE_ID | Resource identifier the two operations have to share |
DURATION | Minimum duration of the transition |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
Advanced Supply Chain Planning - MSC_SIMULATION_SETS | This table stores the different simulation sets. |
---|---|
Column Name | Descritpion |
ORGANIZATION_ID | Organization identifier |
LAST_UPDATE_LOGIN | Standard Who column |
REQUEST_ID | Concurrent Who column |
PROGRAM_APPLICATION_ID | Concurrent Who column |
PROGRAM_ID | Concurrent Who column |
PROGRAM_UPDATE_DATE | Concurrent Who column |
ATTRIBUTE_CATEGORY | Descriptive flexfield structure defining column |
SR_INSTANCE_ID | Source application instance identifier |
ATTRIBUTE1 | Descriptive flexfield segment |
ATTRIBUTE2 | Descriptive flexfield segment |
ATTRIBUTE3 | Descriptive flexfield segment |
ATTRIBUTE4 | Descriptive flexfield segment |
ATTRIBUTE5 | Descriptive flexfield segment |
ATTRIBUTE6 | Descriptive flexfield segment |
ATTRIBUTE7 | Descriptive flexfield segment |
ATTRIBUTE8 | Descriptive flexfield segment |
ATTRIBUTE9 | Descriptive flexfield segment |
ATTRIBUTE10 | Descriptive flexfield segment |
SIMULATION_SET | Simulation set identifier |
ATTRIBUTE11 | Descriptive flexfield segment |
ATTRIBUTE12 | Descriptive flexfield segment |
ATTRIBUTE13 | Descriptive flexfield segment |
ATTRIBUTE14 | Descriptive flexfield segment |
ATTRIBUTE15 | Descriptive flexfield segment |
DESCRIPTION | Simulation set description |
USE_IN_WIP_FLAG | Use in WIP flag |
REFRESH_NUMBER | Refresh number populated by the collection program |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
Advanced Supply Chain Planning - MSC_SOURCING_RULES | This table stores sourcing rules and bills of distribution information. |
---|---|
Column Name | Descritpion |
SOURCING_RULE_ID | Sourcing rule unique identifier |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
SR_SOURCING_RULE_ID | Sourcing rule unique identifier from the source |
REQUEST_ID | Concurrent Who column |
PROGRAM_APPLICATION_ID | Concurrent Who column |
PROGRAM_ID | Concurrent Who column |
PROGRAM_UPDATE_DATE | Concurrent Who column |
ATTRIBUTE_CATEGORY | Descriptive flexfield structure defining column |
ATTRIBUTE1 | Descriptive flexfield segment |
SR_INSTANCE_ID | Source application instance identifier |
ATTRIBUTE2 | Descriptive flexfield segment |
ATTRIBUTE3 | Descriptive flexfield segment |
ORGANIZATION_ID | Organization identifier |
ATTRIBUTE4 | Descriptive flexfield segment |
ATTRIBUTE5 | Descriptive flexfield segment |
ATTRIBUTE6 | Descriptive flexfield segment |
ATTRIBUTE7 | Descriptive flexfield segment |
ATTRIBUTE8 | Descriptive flexfield segment |
ATTRIBUTE9 | Descriptive flexfield segment |
ATTRIBUTE10 | Descriptive flexfield segment |
ATTRIBUTE11 | Descriptive flexfield segment |
ATTRIBUTE12 | Descriptive flexfield segment |
ATTRIBUTE13 | Descriptive flexfield segment |
ATTRIBUTE14 | Descriptive flexfield segment |
ATTRIBUTE15 | Descriptive flexfield segment |
COLLECTED_FLAG | Flag indicates whether the row is collected from source |
SOURCING_RULE_NAME | Sourcing rule / Bill of Distribution name |
DESCRIPTION | Describe the Sourcing Rule / Bill of Distribution |
STATUS | Status |
SOURCING_RULE_TYPE | 1 = Srourcing Rule, 2 = Bill of Distribution |
PLANNING_ACTIVE | Flag indicates whether the row is active for planning |
DELETED_FLAG | Flag indicates whether the row is no longer valid |
REFRESH_NUMBER | Refresh number populated by the collection program |
Advanced Supply Chain Planning - MSC_SR_ASSIGNMENTS | This table stores the assignment of sourcing rules (or bills of distribution) to item, organization, category, or at the global level. |
---|---|
Column Name | Descritpion |
ASSIGNMENT_ID | Sourcing rule/Bills of Distribution identifier |
SHIP_TO_SITE_ID | Ship to site identifier |
CATEGORY_SET_ID | Category set identifier |
CATEGORY_NAME | Category name identifier |
DELETED_FLAG | Flag to indicate whether the row is no longer valid. SYS_YES means the row will be deleted |
REFRESH_NUMBER | Refresh number populated by the collection program |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
SR_ASSIGNMENT_ID | Sourcing rule/Bills of Distribution identifier from source application instance |
LAST_UPDATE_LOGIN | Standard Who column |
REQUEST_ID | Concurrent Who column |
PROGRAM_APPLICATION_ID | Concurrent Who column |
PROGRAM_ID | Concurrent Who column |
PROGRAM_UPDATE_DATE | Concurrent Who column |
ATTRIBUTE_CATEGORY | Descriptive flexfield structure defining column |
SR_ASSIGNMENT_INSTANCE_ID | Source application instance identifier of the assignment record |
ATTRIBUTE1 | Descriptive flexfield segment |
ATTRIBUTE2 | Descriptive flexfield segment |
ATTRIBUTE3 | Descriptive flexfield segment |
ATTRIBUTE4 | Descriptive flexfield segment |
ATTRIBUTE5 | Descriptive flexfield segment |
ATTRIBUTE6 | Descriptive flexfield segment |
ATTRIBUTE7 | Descriptive flexfield segment |
ATTRIBUTE8 | Descriptive flexfield segment |
ATTRIBUTE9 | Descriptive flexfield segment |
ATTRIBUTE10 | Descriptive flexfield segment |
ASSIGNMENT_SET_ID | Assignment set identifier |
ATTRIBUTE11 | Descriptive flexfield segment |
ATTRIBUTE12 | Descriptive flexfield segment |
ATTRIBUTE13 | Descriptive flexfield segment |
ATTRIBUTE14 | Descriptive flexfield segment |
ATTRIBUTE15 | Descriptive flexfield segment |
COLLECTED_FLAG | Flag indicates whether the row is collected from source |
REGION_ID | Region Id |
ASSIGNMENT_TYPE | Assignment type |
SOURCING_RULE_ID | Sourcing rule/Bill of Distribution identifier |
SOURCING_RULE_TYPE | Sourcing rule type |
ORGANIZATION_ID | Organization identifier |
SR_INSTANCE_ID | Source application instance identifier of item org |
INVENTORY_ITEM_ID | Inventory item identifier |
PARTNER_ID | Customer identifier |
Advanced Supply Chain Planning - MSC_SR_RECEIPT_ORG | Receiving Organizations for Sourcing Rules or Bills of distribution |
---|---|
Column Name | Descritpion |
SR_RECEIPT_ID | Unique identifier for a row generated at planning server |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
REQUEST_ID | Concurrent Who column |
SR_INSTANCE_ID | Source application instance identifier |
PROGRAM_APPLICATION_ID | Concurrent Who column |
PROGRAM_ID | Concurrent Who column |
PROGRAM_UPDATE_DATE | Concurrent Who column |
ATTRIBUTE_CATEGORY | Descriptive flexfield structure defining column |
ATTRIBUTE1 | Descriptive flexfield segment |
ATTRIBUTE2 | Descriptive flexfield segment |
ATTRIBUTE3 | Descriptive flexfield segment |
ATTRIBUTE4 | Descriptive flexfield segment |
SR_RECEIPT_ORG | Source application Sr Receipt identifier |
ATTRIBUTE5 | Descriptive flexfield segment |
ATTRIBUTE6 | Descriptive flexfield segment |
ATTRIBUTE7 | Descriptive flexfield segment |
ATTRIBUTE8 | Descriptive flexfield segment |
ATTRIBUTE9 | Descriptive flexfield segment |
ATTRIBUTE10 | Descriptive flexfield segment |
ATTRIBUTE11 | Descriptive flexfield segment |
ATTRIBUTE12 | Descriptive flexfield segment |
ATTRIBUTE13 | Descriptive flexfield segment |
ATTRIBUTE14 | Descriptive flexfield segment |
RECEIPT_ORG_INSTANCE_ID | Source application instance identitifer associated with the receiving org |
ATTRIBUTE15 | Descriptive flexfield segment |
SR_SR_RECEIPT_ID | Apps instance sr_receipt_id |
COLLECTED_FLAG | Flag indicating whether the row is collected from source application instance |
SOURCING_RULE_ID | Sourcing rule/Bill of Distribution identifier |
RECEIPT_PARTNER_ID | Trading partner identifier |
RECEIPT_PARTNER_SITE_ID | Trading partner site identifier |
EFFECTIVE_DATE | Date of effectivity |
DISABLE_DATE | Disable date |
DELETED_FLAG | Flag to indicate whether the row is no longer valid. |
REFRESH_NUMBER | Refresh number populated by the collection program |
LAST_UPDATE_DATE | Standard Who column |
Advanced Supply Chain Planning - MSC_SR_SOURCE_ORG | Source organization for Sourcing Rules or Bills of distribution |
---|---|
Column Name | Descritpion |
SR_SOURCE_ID | Unique identifier for a row |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
REQUEST_ID | Concurrent Who column |
PROGRAM_APPLICATION_ID | Concurrent Who column |
PROGRAM_ID | Concurrent Who column |
PROGRAM_UPDATE_DATE | Concurrent Who column |
ATTRIBUTE_CATEGORY | Descriptive flexfield structure defining column |
ATTRIBUTE1 | Descriptive flexfield segment |
ATTRIBUTE2 | Descriptive flexfield segment |
ATTRIBUTE3 | Descriptive flexfield segment |
SR_SR_SOURCE_ID | Unique identifier for a row from the source application instance |
ATTRIBUTE4 | Descriptive flexfield segment |
ATTRIBUTE5 | Descriptive flexfield segment |
ATTRIBUTE6 | Descriptive flexfield segment |
ATTRIBUTE7 | Descriptive flexfield segment |
ATTRIBUTE8 | Descriptive flexfield segment |
ATTRIBUTE9 | Descriptive flexfield segment |
ATTRIBUTE10 | Descriptive flexfield segment |
ATTRIBUTE11 | Descriptive flexfield segment |
ATTRIBUTE12 | Descriptive flexfield segment |
ATTRIBUTE13 | Descriptive flexfield segment |
ATTRIBUTE14 | Descriptive flexfield segment |
ATTRIBUTE15 | Descriptive flexfield segment |
MIN_TRANSFER_QTY | Minimum transfer quantity |
MAX_TRANSFER_QTY | Maximum transfer quantity |
TRANSFER_LOT_MULTIPLE | Transfer lot multiple |
FIXED_TRANSFER_QTY | Fixed transfer quantity |
SR_RECEIPT_ID | Identifier from the sourcing rule receipt org |
TRANSFER_TYPE | Transfer type |
COLLECTED_FLAG | Flag indicates whether the row is collected from source |
SOURCE_PARTNER_ID | Source supplier identifier |
SOURCE_PARTNER_SITE_ID | Source supplier site identifier |
ALLOCATION_PERCENT | Percent of supply allocated to this source |
RANK | Rank of source |
SHIP_METHOD | Specify the shipping method |
SOURCE_TYPE | Flag indicating the source type |
SR_INSTANCE_ID | Source instance id for the source organization |
DELETED_FLAG | Flag to indicate whether the row is no longer valid. SYS_YES means the row will be deleted |
SOURCE_ORGANIZATION_ID | Source organization identifier |
SOURCE_ORG_INSTANCE_ID | Source intance identifier of the source organization identifier |
REFRESH_NUMBER | Refresh number assigned by collection proram |
REPLENISHMENT_TYPE | Indicate type of replenishment. Null/0 = Force Transfer; 1 = Partial transfer; 2 = Full transfer |
Advanced Supply Chain Planning - MSC_PERIOD_START_DATES | Workday calendar period start dates |
---|---|
Column Name | Descritpion |
CALENDAR_CODE | Workday calendar identifier |
PERIOD_SEQUENCE_NUM | Sequence Number |
PERIOD_NAME | Period Name (depends on quarterly calendar type chosen) |
NEXT_DATE | Next calendar date corresponding to next sequence number |
PRIOR_DATE | Prior date corresponding to prior sequence number |
REQUEST_ID | Concurrent Who column |
PROGRAM_APPLICATION_ID | Concurrent Who column |
PROGRAM_ID | Concurrent Who column |
PROGRAM_UPDATE_DATE | Concurrent Who column |
SR_INSTANCE_ID | Source application instance identifier |
EXCEPTION_SET_ID | Exception set unique identifier |
PERIOD_START_DATE | Period start date |
REFRESH_NUMBER | Refresh number populated by the collection program |
LAST_UPDATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
LAST_UPDATE_DATE | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
Advanced Supply Chain Planning - MSC_RESOURCE_CHANGES | Resource capacity modifications |
---|---|
Column Name | Descritpion |
DEPARTMENT_ID | Department unique identifier |
FROM_DATE | Capacity exception from date |
TO_DATE | Capacity exception to date |
FROM_TIME | Capacity exception from time |
TO_TIME | Capacity exception to time |
CAPACITY_CHANGE | Capacity change |
SIMULATION_SET | Simulation set identifier |
REFRESH_NUMBER | Refresh number populated by the collection program |
ACTION_TYPE | Type of capacity modification |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
ATTRIBUTE_CATEGORY | Descriptive flexfield structure defining column |
ATTRIBUTE1 | Descriptive flexfield segment |
ATTRIBUTE2 | Descriptive flexfield segment |
ATTRIBUTE3 | Descriptive flexfield segment |
RESOURCE_ID | Resource unique identifier |
ATTRIBUTE4 | Descriptive flexfield segment |
ATTRIBUTE5 | Descriptive flexfield segment |
ATTRIBUTE6 | Descriptive flexfield segment |
ATTRIBUTE7 | Descriptive flexfield segment |
ATTRIBUTE8 | Descriptive flexfield segment |
ATTRIBUTE9 | Descriptive flexfield segment |
ATTRIBUTE10 | Descriptive flexfield segment |
ATTRIBUTE11 | Descriptive flexfield segment |
ATTRIBUTE12 | Descriptive flexfield segment |
ATTRIBUTE13 | Descriptive flexfield segment |
SR_INSTANCE_ID | Source application instance identifier |
ATTRIBUTE14 | Descriptive flexfield segment |
ATTRIBUTE15 | Descriptive flexfield segment |
REQUEST_ID | Concurrent Who column |
PROGRAM_APPLICATION_ID | Concurrent Who column |
PROGRAM_ID | Concurrent Who column |
PROGRAM_UPDATE_DATE | Concurrent Who column |
SHIFT_NUM | Shift number |
Advanced Supply Chain Planning - MSC_RESOURCE_SHIFTS | Resource shift information |
---|---|
Column Name | Descritpion |
DEPARTMENT_ID | Department unique identifier |
ATTRIBUTE_CATEGORY | Descriptive flexfield structure defining column |
ATTRIBUTE1 | Descriptive flexfield segment |
ATTRIBUTE2 | Descriptive flexfield segment |
ATTRIBUTE3 | Descriptive flexfield segment |
ATTRIBUTE4 | Descriptive flexfield segment |
ATTRIBUTE5 | Descriptive flexfield segment |
ATTRIBUTE6 | Descriptive flexfield segment |
ATTRIBUTE7 | Descriptive flexfield segment |
ATTRIBUTE8 | Descriptive flexfield segment |
ATTRIBUTE9 | Descriptive flexfield segment |
RESOURCE_ID | Resource unique identifier |
ATTRIBUTE10 | Descriptive flexfield segment |
ATTRIBUTE11 | Descriptive flexfield segment |
ATTRIBUTE12 | Descriptive flexfield segment |
ATTRIBUTE13 | Descriptive flexfield segment |
ATTRIBUTE14 | Descriptive flexfield segment |
ATTRIBUTE15 | Descriptive flexfield segment |
REQUEST_ID | Concurrent Who column |
PROGRAM_APPLICATION_ID | Concurrent Who column |
PROGRAM_ID | Concurrent Who column |
PROGRAM_UPDATE_DATE | Concurrent Who column |
CAPACITY_UNITS | capacity units |
SR_INSTANCE_ID | Source application instance identifier |
SHIFT_NUM | Shift number |
REFRESH_NUMBER | Refresh number populated by the collection program |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
Advanced Supply Chain Planning - MSC_SHIFT_DATES | Workday calendar shift dates |
---|---|
Column Name | Descritpion |
CALENDAR_CODE | Workday calendar identifier |
CREATED_BY | Standard Who column |
SEQ_NUM | Sequence number for shift date (only for working dates) |
NEXT_SEQ_NUM | Next sequence number for calendar date (working day) |
PRIOR_SEQ_NUM | Prior sequence number for calendar date (working day) |
NEXT_DATE | Next date corresponding to next sequence number |
PRIOR_DATE | Prior date corresponding to prior sequence number |
REQUEST_ID | Concurrent Who column |
PROGRAM_APPLICATION_ID | Concurrent Who column |
PROGRAM_ID | Concurrent Who column |
PROGRAM_UPDATE_DATE | Concurrent Who column |
SR_INSTANCE_ID | Source application instance identifier |
EXCEPTION_SET_ID | Exception set unique identifier |
SHIFT_NUM | Shift number |
SHIFT_DATE | Calendar date |
REFRESH_NUMBER | Refresh number populated by the collection program |
LAST_UPDATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
LAST_UPDATE_DATE | Standard Who column |
CREATION_DATE | Standard Who column |
Advanced Supply Chain Planning - MSC_SHIFT_EXCEPTIONS | Workday calendar shift exceptions |
---|---|
Column Name | Descritpion |
CALENDAR_CODE | Workday calendar identifier |
CREATION_DATE | Standard Who column |
EXCEPTION_TYPE | Exception type (1- On and 2- Off) |
REQUEST_ID | Concurrent Who column |
PROGRAM_APPLICATION_ID | Concurrent Who column |
PROGRAM_ID | Concurrent Who column |
PROGRAM_UPDATE_DATE | Concurrent Who column |
ATTRIBUTE_CATEGORY | Descriptive flexfield structure defining column |
ATTRIBUTE1 | Descriptive flexfield segment |
ATTRIBUTE2 | Descriptive flexfield segment |
ATTRIBUTE3 | Descriptive flexfield segment |
SR_INSTANCE_ID | Source application instance identifier |
ATTRIBUTE4 | Descriptive flexfield segment |
ATTRIBUTE5 | Descriptive flexfield segment |
ATTRIBUTE6 | Descriptive flexfield segment |
ATTRIBUTE7 | Descriptive flexfield segment |
ATTRIBUTE8 | Descriptive flexfield segment |
ATTRIBUTE9 | Descriptive flexfield segment |
ATTRIBUTE10 | Descriptive flexfield segment |
ATTRIBUTE11 | Descriptive flexfield segment |
ATTRIBUTE12 | Descriptive flexfield segment |
ATTRIBUTE13 | Descriptive flexfield segment |
SHIFT_NUM | Shift number |
ATTRIBUTE14 | Descriptive flexfield segment |
ATTRIBUTE15 | Descriptive flexfield segment |
EXCEPTION_SET_ID | Exception set unique identifier |
EXCEPTION_DATE | Exception Date |
REFRESH_NUMBER | Refresh number populated by the collection program |
LAST_UPDATED_BY | Standard Who column |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
CREATED_BY | Standard Who column |
Advanced Supply Chain Planning - MSC_SHIFT_TIMES | Workday calendar shift times |
---|---|
Column Name | Descritpion |
CALENDAR_CODE | Workday calendar identifier |
CREATED_BY | Standard Who column |
REQUEST_ID | Concurrent Who column |
PROGRAM_APPLICATION_ID | Concurrent Who column |
PROGRAM_ID | Concurrent Who column |
PROGRAM_UPDATE_DATE | Concurrent Who column |
ATTRIBUTE_CATEGORY | Descriptive flexfield structure defining column |
ATTRIBUTE1 | Descriptive flexfield segment |
ATTRIBUTE2 | Descriptive flexfield segment |
ATTRIBUTE3 | Descriptive flexfield segment |
ATTRIBUTE4 | Descriptive flexfield segment |
SR_INSTANCE_ID | Source application instance identifier |
ATTRIBUTE5 | Descriptive flexfield segment |
ATTRIBUTE6 | Descriptive flexfield segment |
ATTRIBUTE7 | Descriptive flexfield segment |
ATTRIBUTE8 | Descriptive flexfield segment |
ATTRIBUTE9 | Descriptive flexfield segment |
ATTRIBUTE10 | Descriptive flexfield segment |
ATTRIBUTE11 | Descriptive flexfield segment |
ATTRIBUTE12 | Descriptive flexfield segment |
ATTRIBUTE13 | Descriptive flexfield segment |
ATTRIBUTE14 | Descriptive flexfield segment |
SHIFT_NUM | Shift number |
ATTRIBUTE15 | Descriptive flexfield segment |
FROM_TIME | Shift start time in seconds |
TO_TIME | Shift end time in seconds |
REFRESH_NUMBER | Refresh number populated by the collection program |
LAST_UPDATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
LAST_UPDATE_DATE | Standard Who column |
CREATION_DATE | Standard Who column |
Advanced Supply Chain Planning - MSC_SNAPSHOT_TASKS | Tasks to be performed by Snapshot Workers |
---|---|
Column Name | Descritpion |
TASK | Task type |
REQUIRES_LOCK | Flag to indicate if the task requires a snapshot lock |
REQUIRES_ITEMS | Flag to indicate that this task requires that MSC_SYSTEM_ITEMS is complete |
DEPENDENCY_AGAINST | Flag to indicate if this task has other tasks that are dependent on it |
START_DATE | Date the task was started |
COMPLETION_DATE | Date task was completed |
DEPENDENT_TASK | Task which must be executed before this task |
DEPENDENT_TASK2 | Task which must be executed before this task |
LAST_UPDATE_DATE | Standard Who Column |
LAST_UPDATED_BY | Standard Who Column |
CREATION_DATE | Standard Who Column |
CREATED_BY | Standard Who Column |
LAST_UPDATE_LOGIN | Standard Who Column |
REQUEST_ID | Concurrent Who column |
PROGRAM_APPLICATION_ID | Concurrent Who column |
PROGRAM_ID | Concurrent Who column |
PROGRAM_UPDATE_DATE | Concurrent Who column |
PLAN_ID | Plan identifier |
Advanced Supply Chain Planning - MSC_RESERVATIONS | Material reservations |
---|---|
Column Name | Descritpion |
TRANSACTION_ID | Unique identifier generated from the source application instance |
DISPOSITION_TYPE | Disposition type |
DISPOSITION_ID | Disposition identifier |
PARENT_DEMAND_ID | Parent demand identifier |
SUBINVENTORY | Subinventory identifier |
DEMAND_CLASS | Demand class |
REVISION | Inventory item revision code |
PROJECT_ID | Project identifier |
TASK_ID | Task identifier |
PLANNING_GROUP | Planning group |
REFRESH_NUMBER | Refresh number populated by the collection program |
LAST_UPDATE_DATE | Standard Who column |
INVENTORY_ITEM_ID | Inventory item identifier |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
REQUEST_ID | Concurrent Who column |
PROGRAM_APPLICATION_ID | Concurrent Who column |
PROGRAM_ID | Concurrent Who column |
PROGRAM_UPDATE_DATE | Concurrent Who column |
PLAN_ID | Plan identifier |
ORGANIZATION_ID | Organization identifier |
SR_INSTANCE_ID | Source application instance identifier |
RESERVATION_DATE | Effectivity date of reservation |
REQUIREMENT_DATE | Date of need |
RESERVED_QUANTITY | Quantity reserved |
NONNET_QUANTITY_RESERVED | Quantity reserved allocated to nonnettable inventory |
Advanced Supply Chain Planning - MSC_SALES_ORDERS | This table stores sales order demand and reservations from source application instances. |
---|---|
Column Name | Descritpion |
DEMAND_ID | Unique identifier of a demand row from source application instance |
PRIMARY_UOM_QUANTITY | Demanded or reserved quantity expressed in the item's primary unit of measure |
RESERVATION_TYPE | Code for type of reservation |
RESERVATION_QUANTITY | Total quantity reserved expressed in primary unit of measure. Only populated for summary and derived demand rows. |
COMPLETED_QUANTITY | Shipped quantity in primary unit of measure code. |
REQUIREMENT_DATE | Planned ship date for summary demand. Parent planned ship date - ATP_LEAD_TIME for derived demand |
SUBINVENTORY | Subinventory demanded or reserved, can be populated for summary demand |
DEMAND_CLASS | Demand class code (containing sr_instance_code || ':' || demand class code from source application instance) |
PARENT_DEMAND_ID | Parent demand identifier |
REFRESH_NUMBER | Refresh number populated by the collection program |
LAST_UPDATE_DATE | Standard Who column |
SR_INSTANCE_ID | Source application instance identifier |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
REQUEST_ID | Concurrent Who column |
PROGRAM_APPLICATION_ID | Concurrent Who column |
PROGRAM_ID | Concurrent Who column |
PROGRAM_UPDATE_DATE | Concurrent Who column |
SALES_ORDER_NUMBER | Sales order number |
SALESREP_CONTACT | Salesrep contact |
INVENTORY_ITEM_ID | Inventory item identifier |
ORDERED_ITEM_ID | Ordered item identifier |
AVAILABLE_TO_MRP | Available to MRP flag |
CUSTOMER_ID | Customer identifier |
SHIP_TO_SITE_USE_ID | Ship to identifier of the sales order |
BILL_TO_SITE_USE_ID | Bill to identifier of the sales order |
LINE_NUM | Sales order line number |
TERRITORY_ID | Territory identifier of the sales order |
UPDATE_SEQ_NUM | Update sequence number |
DEMAND_TYPE | Demand type |
PROJECT_ID | Project identifier |
ORGANIZATION_ID | Organization identifier |
TASK_ID | Task identifier |
PLANNING_GROUP | Planning group |
END_ITEM_UNIT_NUMBER | Unit number identifier |
DEMAND_PRIORITY | Demand priority |
ATP_REFRESH_NUMBER | ATP refresh number |
REQUEST_DATE | Request Date |
SELLING_PRICE | Unique identifier of a demand row from source application instance |
DEMAND_VISIBLE | Demand Visibility Flag |
FORECAST_VISIBLE | Forecast Visibility Flag |
CTO_FLAG | Unique identifier of a demand row from source application instance |
DEMAND_SOURCE_TYPE | Code to indicate the source of the demand |
SUPPLY_ID | Unique identifier of a demand row from source application instance |
ORIGINAL_SYSTEM_REFERENCE | Original System Reference |
ORIGINAL_SYSTEM_LINE_REFERENCE | Original System Line Reference |
SOURCE_ORGANIZATION_ID | Source application identifier |
SOURCE_ORG_INSTANCE_ID | Source Org Instance Identifier |
OLD_PRIMARY_UOM_QUANTITY | for ATP SUmmary Calculation |
OLD_RESERVATION_QUANTITY | for ATP SUmmary Calculation |
OLD_COMPLETED_QUANTITY | for ATP SUmmary Calculation |
OLD_REQUIREMENT_DATE | for ATP SUmmary Calculation |
ORIGINAL_ITEM_ID | Original Item Id |
DEMAND_SOURCE_HEADER_ID | Header ID for the source of the demand. |
PROMISE_DATE | Date promised to the customer |
LINK_TO_LINE_ID | Parent Line Identifier |
PARENT_ID | Parent Demand Identifier |
CUST_PO_NUMBER | Customer Purchase Order Number |
CUSTOMER_LINE_NUMBER | Refrence Information.Contains customers line number, If specified while importing an order. |
SR_DEMAND_ID | Source Demand Identifier |
RECORD_SOURCE | For sales orders generated by ATP this field will have value 2. If this field is 1 or null then the sales order is collected from source. |
MFG_LEAD_TIME | |
ORDER_DATE_TYPE_CODE | |
SCHEDULE_ARRIVAL_DATE | |
DEMAND_SOURCE_LINE | Line id of demand source. For Sales Order demand this is: SO_LINES.LINE_ID from source application instance. |
LATEST_ACCEPTABLE_DATE | |
SHIPPING_METHOD_CODE | |
ORG_FIRM_FLAG | |
ATP_OVERRIDE_FLAG | |
SHIP_TO_LOCATION_ID | |
SHIP_SET_ID | |
ARRIVAL_SET_ID | |
ATO_LINE_ID | |
ARRIVAL_SET_NAME | |
SHIP_SET_NAME | |
DEMAND_SOURCE_DELIVERY | For Sales Order demand, Line id of Sales order line detail row (SO_LINE_DETAILS.LINE_DETAIL_ID) from source application instance. |
REQUEST_SHIP_DATE | |
SCHEDULE_SHIP_DATE | |
SALESREP_ID | |
INTRANSIT_LEAD_TIME | |
SR_CUSTOMER_ACCT_ID | |
PREV_COLL_ITEM_ID | |
ROW_TYPE | |
SR_SO_LINEID | |
MIN_REM_SHELF_LIFE_DAYS | |
REVISED_DMD_DATE | |
DEMAND_SOURCE_NAME | Identifier for user-defined Source Type |
REVISED_DMD_PRIORITY | |
ITEM_TYPE_ID | |
ITEM_TYPE_VALUE |
Advanced Supply Chain Planning - MSC_SELECTION_CRITERIA | MSC Selection Criteria Stores the UI Search selection criteria |
---|---|
Column Name | Descritpion |
SEQUENCE | Criteria sequence |
TREE_NODE | Tree node |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
AND_OR | And Or |
COUNT_BY | Store checkbox 'display message count' for find exceptions block |
SEARCH_QUERY_ID | Search query identifier |
SEARCH_QUERY_NAME | Search query name |
FOLDER_ID | Folder identifier |
DEFAULT_FLAG | Default flag |
PUBLIC_FLAG | Public flag |
FROM_FIELD_VALUE | From field value |
TO_FIELD_VALUE | To field value |
FIELD_NAME | Field name |
FIELD_TYPE | Field type |
HIDDEN_FROM_FIELD | From field value |
CONDITION | Condition |
FROM_FIELD | From field value |
TO_FIELD | To field value |
FOLDER_OBJECT | Folder object identifier |
Advanced Supply Chain Planning - MSC_ST_ASSIGNMENT_SETS | The staging table used by the collection program to valid and process data for table MSC_ASSIGNMENT_SETS. |
---|---|
Column Name | Descritpion |
SR_ASSIGNMENT_SET_ID | Assignment set identifier from source application instance |
REQUEST_ID | Concurrent Who column |
PROGRAM_APPLICATION_ID | Concurrent Who column |
PROGRAM_ID | Concurrent Who column |
PROGRAM_UPDATE_DATE | Concurrent Who column |
SR_INSTANCE_ID | Source application instance identifier |
REFRESH_ID | Refresh identifier |
ASSIGNMENT_SET_NAME | Assignment set name |
DESCRIPTION | Description |
DELETED_FLAG | Flag to indicate whether the row is no longer valid. SYS_YES means the row will be deleted |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
Advanced Supply Chain Planning - MSC_ST_BILL_OF_RESOURCES | The staging table used by the collection program to validate and process data for table MSC_BILL_OF_RESOURCES. |
---|---|
Column Name | Descritpion |
ORGANIZATION_ID | Organization identifier |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
REQUEST_ID | Concurrent Who column |
PROGRAM_APPLICATION_ID | Concurrent Who column |
PROGRAM_ID | Concurrent Who column |
PROGRAM_UPDATE_DATE | Concurrent Who column |
SR_INSTANCE_ID | Source application instance identifier |
REFRESH_ID | Refresh identifier |
BILL_OF_RESOURCES | Source application bill of resource identifier |
DESCRIPTION | Bill of resource description |
DISABLE_DATE | Bill of resource disable date |
ROLLUP_START_DATE | Bill of resources load start date |
ROLLUP_COMPLETION_DATE | Bill of resources load completion date |
DELETED_FLAG | Yes/No flag indicates whether corresponding record in ODS will be deleted |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
Advanced Supply Chain Planning - MSC_ST_BIS_BUSINESS_PLANS | The staging table used by the collection program to validate and process data for table MSC_BIS_BUSINESS_PLANS. |
---|---|
Column Name | Descritpion |
BUSINESS_PLAN_ID | Business plan identifier |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
REQUEST_ID | Concurrent Who column |
PROGRAM_APPLICATION_ID | Concurrent Who column |
PROGRAM_ID | Concurrent Who column |
PROGRAM_UPDATE_DATE | Concurrent Who column |
REFRESH_ID | Refresh identifier |
SR_INSTANCE_ID | Source application instance identifier |
SHORT_NAME | Busniess plan short name |
NAME | Business plan name |
DESCRIPTION | Describe the business plan |
VERSION_NO | Version number |
CURRENT_PLAN_FLAG | Yes/No flag indicating whether the business plan is current |
DELETED_FLAG | Yes/No flag indicating whether the row will be deleted |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
Advanced Supply Chain Planning - MSC_ST_BIS_PFMC_MEASURES | The staging table used by the collection program to validate and process data for table MSC_BIS_PFMC_MEASURES. |
---|---|
Column Name | Descritpion |
MEASURE_ID | Measure identifier |
DIMENSION4_ID | Forth dimension identifier' |
DIMENSION5_ID | Fifth dimension identifier' |
UNIT_OF_MEASURE_CLASS | Unit of measure class |
DELETED_FLAG | Yes/No flag indicates whether the row will be deleted |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
REQUEST_ID | Concurrent Who column |
MEASURE_SHORT_NAME | Source application instance identifier |
PROGRAM_APPLICATION_ID | Concurrent Who column |
PROGRAM_ID | Concurrent Who column |
PROGRAM_UPDATE_DATE | Concurrent Who column |
REFRESH_ID | Refresh identifier |
SR_INSTANCE_ID | Source application instance identifier |
MEASURE_NAME | Measure short name |
DESCRIPTION | Decribe the performance measure |
ORG_DIMENSION_ID | Organization dimension identifier |
TIME_DIMENSION_ID | Time dimention identifier |
DIMENSION1_ID | First dimension identifier |
DIMENSION2_ID | Second dimension identifier |
DIMENSION3_ID | Third dimension identifier' |
Advanced Supply Chain Planning - MSC_ST_BIS_TARGETS | The staging table used by the collection program to valid and process data for table MSC_BIS_TARGETS. |
---|---|
Column Name | Descritpion |
TARGET_ID | Target identifier |
DIM5_LEVEL_VALUE_ID | Fifth dimension level value identifier |
TARGET | Target number |
RANGE1_LOW | Low number of the first range |
RANGE1_HIGH | High number of the first range |
RANGE2_LOW | Low number of the second range |
RANGE2_HIGH | High number of the second range |
RANGE3_LOW | Low number of the third range |
RANGE3_HIGH | High number of the third range |
NOTIFY_RESP1_ID | First notify identifier |
NOTIFY_RESP1_SHORT_NAME | Short name of the first notify |
TARGET_LEVEL_ID | Target level identifier |
NOTIFY_RESP2_ID | Second notify identifier |
NOTIFY_RESP2_SHORT_NAME | Short name of the second notify |
NOTIFY_RESP3_ID | Third notify identifier |
NOTIFY_RESP3_SHORT_NAME | Short name of the third notify |
DELETED_FLAG | Yes/No flag indicating whether the row will be deleted |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
BUSINESS_PLAN_ID | Business plan identifier |
REQUEST_ID | Concurrent Who column |
PROGRAM_APPLICATION_ID | Concurrent Who column |
PROGRAM_ID | Concurrent Who column |
PROGRAM_UPDATE_DATE | Concurrent Who column |
REFRESH_ID | Refresh identifier |
SR_INSTANCE_ID | Source application instance identifier |
ORG_LEVEL_VALUE_ID | Org level value identifier |
TIME_LEVEL_VALUE_ID | Time level value identifier |
DIM1_LEVEL_VALUE_ID | First dimension level value identifier |
DIM2_LEVEL_VALUE_ID | Second dimension level value identifier |
DIM3_LEVEL_VALUE_ID | Third dimension level value identifier |
DIM4_LEVEL_VALUE_ID | Forth dimension level value identifier |
Advanced Supply Chain Planning - MSC_ST_BIS_TARGET_LEVELS | The staging table used by the collection program to validate and process data for table MSC_BIS_TARGET_LEVELS |
---|---|
Column Name | Descritpion |
TARGET_LEVEL_ID | Target level identifier |
DIMENSION3_LEVEL_ID | Third dimension level identifier |
DIMENSION4_LEVEL_ID | Forth dimension level identifier |
DIMENSION5_LEVEL_ID | Fifth dimension level identifier |
WORKFLOW_ITEM_TYPE | Workflow item type |
WORKFLOW_PROCESS_SHORT_NAME | Workflow process short name |
DEFAULT_NOTIFY_RESP_ID | Default notify identifier |
DEFAULT_NOTIFY_RESP_SHORT_NAME | Name of the default notify |
COMPUTING_FUNCTION_ID | Computing function identifier |
REPORT_FUNCTION_ID | Report function identifier |
UNIT_OF_MEASURE | Unit of measure |
TARGET_LEVEL_SHORT_NAME | Short name identifying the target level |
SYSTEM_FLAG | System flag |
DELETED_FLAG | Yes/No flag indicating whether the row will be deleted |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
REQUEST_ID | Concurrent Who column |
PROGRAM_APPLICATION_ID | Concurrent Who column |
PROGRAM_ID | Concurrent Who column |
TARGET_LEVEL_NAME | Target level name |
PROGRAM_UPDATE_DATE | Concurrent Who column |
REFRESH_ID | Refersh identifier |
SR_INSTANCE_ID | Source application instance identifier |
DESCRIPTION | Decribe the target level |
MEASURE_ID | Performance measure identifier |
ORG_LEVEL_ID | Organization level identifier |
TIME_LEVEL_ID | Time level identifier |
DIMENSION1_LEVEL_ID | First dimension level identifier |
DIMENSION2_LEVEL_ID | Second dimension level identifier |
Advanced Supply Chain Planning - MSC_ST_BOMS | The staging table used by the collection program to valid and process data for table MSC_BOMS. |
---|---|
Column Name | Descritpion |
BILL_SEQUENCE_ID | Bill sequence identifier in the source application instance |
BOM_SCALING_TYPE | BOM scalling type |
ASSEMBLY_QUANTITY | Assembly quantity |
UOM | Unit of measure code |
DELETED_FLAG | Yes/No flag indicating whether the row will be deleted |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
REQUEST_ID | Concurrent Who column |
ORGANIZATION_ID | Organization identifier of the item |
PROGRAM_APPLICATION_ID | Concurrent Who column |
PROGRAM_ID | Concurrent Who column |
PROGRAM_UPDATE_DATE | Concurrent Who column |
SR_INSTANCE_ID | Source application instance identifier |
REFRESH_ID | Refersh identifier |
COMPANY_ID | Company Identifier |
COMPANY_NAME | Company name |
BOM_NAME | BOM Name. If this is empty during uploads then it would be replaced by ASSEMBLY_NAME. |
ORGANIZATION_CODE | Organization Identifier |
ASSEMBLY_NAME | Assembly Name. This has to be provided for uploads from legacy. |
ASSEMBLY_ITEM_ID | Identifier of the item being assembled |
SR_INSTANCE_CODE | Source Instance Code |
MESSAGE_ID | This is a foreign key reference to ECX_DOCLOGS.INTERNAL_CONTROL_NUMBER for records got via XML. |
PROCESS_FLAG | Processing Flag indicating the status of records during pre-processing. 1- New Record, 2- In-Process, 3- Error, 4- Propagated Error, 5- Successfully Processed |
ERROR_TEXT | If PROCESS_FLAG is equal to 3 for a record, then this will describe the reason for the error |
DATA_SOURCE_TYPE | Source Type indicating the source of data , Batch/XML |
ST_TRANSACTION_ID | Transaction ID generated during pre-processing to uniquely identify a record in the staging table |
BATCH_ID | Batch identifier generated during pre-processing |
ITEM_PROCESS_COST | |
SOURCE_ORGANIZATION_ID | |
SOURCE_BILL_SEQUENCE_ID | |
ASSEMBLY_TYPE | Manufacturing Bill(1), or Engineering(2). Used for UI and reports. |
SOURCE_INVENTORY_ITEM_ID | |
OPERATION_SEQ_NUM | |
ALTERNATE_BOM_DESIGNATOR | Name of the bill for alternate bills (null for the primary bill) |
SPECIFIC_ASSEMBLY_COMMENT | Comments for specific assembly |
PENDING_FROM_ECN | Change notice that created this bill of material |
COMMON_BILL_SEQUENCE_ID | Common bill sequence identifier |
SCALING_TYPE | (OPM) Controls scaling behavior |
Advanced Supply Chain Planning - MSC_ST_BOM_COMPONENTS | The staging table used by the collection program to valid and process data for table MSC_BOM_COMPONENTS. |
---|---|
Column Name | Descritpion |
COMPONENT_SEQUENCE_ID | Component identifier on the source application instance |
UOM_CODE | Unit of measure code |
USAGE_QUANTITY | Quantity of the component to build one unit of item |
EFFECTIVITY_DATE | Date of effectivity for this component |
DISABLE_DATE | End of effectivity |
FROM_UNIT_NUMBER | Effective from this unit number |
TO_UNIT_NUMBER | Effective up to this unit number |
USE_UP_CODE | Yes/No flag indicating whether the component is effective |
SUGGESTED_EFFECTIVITY_DATE | Calculated use-up-date (if Use-up-code is yes) |
DRIVING_ITEM_ID | Item which consumption determine the switch to this component |
OPERATION_OFFSET_PERCENT | Operation offset percent |
ORGANIZATION_ID | Organization identifier |
OPTIONAL_COMPONENT | Yes/No flag - if optional use planning factor to determine demand |
OLD_EFFECTIVITY_DATE | Old effectivity date |
WIP_SUPPLY_TYPE | Used mainly for phantoms |
PLANNING_FACTOR | Planning factor for this component (percent) |
ATP_FLAG | Yes/No flag used for ATP |
COMPONENT_YIELD_FACTOR | Factor used to multiply component quantity with to obtain component quantity |
REVISED_ITEM_SEQUENCE_ID | Revised item sequence identifier |
STATUS_TYPE | Status type |
DELETED_FLAG | Yes/No flag indicating whether the row will be deleted |
LAST_UPDATE_DATE | Standard Who column |
INVENTORY_ITEM_ID | Identifier of the component item |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
REQUEST_ID | Concurrent Who column |
PROGRAM_APPLICATION_ID | Concurrent Who column |
PROGRAM_ID | Concurrent Who column |
PROGRAM_UPDATE_DATE | Concurrent Who column |
SR_INSTANCE_ID | Source application instance identifier |
REFRESH_ID | Refresh identifier |
USING_ASSEMBLY_ID | Identifier of the item being assembled |
COMPANY_ID | Company Identifier |
COMPANY_NAME | Company name |
BOM_NAME | BOM Name. If this is empty during uploads then it would be replaced by ASSEMBLY_NAME |
ORGANIZATION_CODE | Organization Identifier |
ASSEMBLY_NAME | Assembly Name. This has to be provided for uploads from legacy. |
SR_INSTANCE_CODE | Source Instance Code |
COMPONENT_NAME | Component Name |
OPERATION_SEQ_CODE | Operation Sequence Code. This has to be provided during loads from legacy to help link this component to a routing operation. |
DRIVING_ITEM_NAME | Item Name whose consumption determines whether to switch to this component or not |
ALTERNATE_BOM_DESIGNATOR | Alternate BOM's Reference |
BILL_SEQUENCE_ID | Identifier of the BOM |
ERROR_TEXT | If PROCESS_FLAG is equal to 3 for a record, then this will describe the reason for the error |
MESSAGE_ID | This is a foreign key reference to ECX_DOCLOGS.INTERNAL_CONTROL_NUMBER for records got via XML |
PROCESS_FLAG | Processing Flag indicating the status of records during pre-processing. |
DATA_SOURCE_TYPE | Source type indicates the source of data, BATCH/XML |
ST_TRANSACTION_ID | Transaction ID generated during pre-processing to uniquely identify a record in the staging table |
BATCH_ID | Batch identifier generated during pre-processing |
SCALE_MULTIPLE | Scale Multiple |
SCALE_ROUNDING_VARIANCE | Scale Rounding Variance |
ROUNDING_DIRECTION | Rounding Direction |
PRIMARY_FLAG | Primary Flag Indicator |
COMPONENT_TYPE | Component (1), Ingredient component (-1), by-product (2) |
SOURCE_ORGANIZATION_ID | |
SOURCE_BILL_SEQUENCE_ID | |
SOURCE_COMPONENT_SEQUENCE_ID | |
SOURCE_USING_ASSEMBLY_ID | |
SOURCE_INVENTORY_ITEM_ID | |
SOURCE_DRIVING_ITEM_ID | |
CONTRIBUTE_TO_STEP_QTY | |
OLD_COMPONENT_SEQUENCE_ID | |
OPERATION_SEQ_NUM | |
SCALING_TYPE | Scaling type |
CHANGE_NOTICE | Code for ECO. Use for UI and reporting |
REVISION | Inventory item revision code |
Advanced Supply Chain Planning - MSC_ST_BOR_REQUIREMENTS | The staging table used by the collection program to valid and process data for table MSC_BOR_REQUIREMENTS. |
---|---|
Column Name | Descritpion |
BILL_OF_RESOURCES | Bill of resources name |
RESOURCE_SEQ_NUM | Resource sequence number |
SETBACK_DAYS | Resource set back days from assembly due date |
DEPARTMENT_ID | Department identifier |
LINE_ID | Line identifier |
ASSEMBLY_USAGE | Resource hours multiplier for assembly usage |
ORIGINATION_TYPE | Load(1), Manual update(2), Manual addition(3) |
RESOURCE_UNITS | Operation resource units |
BASIS | peration Basis. Item(1), Lot(2), Resource Units(3), Resource value(4), Total value(5), Activity units(6) |
DELETED_FLAG | Yes/No flag indicating whether the row will be deleted |
LAST_UPDATE_DATE | Standard Who column |
ORGANIZATION_ID | Organization identifier |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
REQUEST_ID | Concurrent Who column |
PROGRAM_APPLICATION_ID | Concurrent Who column |
PROGRAM_ID | Concurrent Who column |
PROGRAM_UPDATE_DATE | Concurrent Who column |
SR_INSTANCE_ID | Source application instance identifier |
REFRESH_ID | Refresh identifier |
ASSEMBLY_ITEM_ID | Assembly item identifier |
SR_TRANSACTION_ID | Source application transaction identifier |
SOURCE_ITEM_ID | Source item identifier |
RESOURCE_ID | Resource identifier |
RESOURCE_DEPARTMENT_HOURS | Require resource hours |
OPERATION_SEQUENCE_ID | Operation sequence identifier |
OPERATION_SEQ_NUM | Operation sequence number |
Advanced Supply Chain Planning - MSC_ST_CALENDAR_DATES | The staging table used by the collection program to validate and process data for table MSC_CALENDAR_DATES. |
---|---|
Column Name | Descritpion |
CALENDAR_DATE | Calendar date |
CALENDAR_END_DATE | Ending date for the calendar |
DESCRIPTION | Calendar description |
DELETED_FLAG | Yes/No flag indicating whether the row will be deleted |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
REQUEST_ID | Concurrent Who column |
PROGRAM_APPLICATION_ID | Concurrent Who column |
CALENDAR_CODE | Calendar code |
PROGRAM_ID | Concurrent Who column |
PROGRAM_UPDATE_DATE | Concurrent Who column |
SR_INSTANCE_ID | Source application instance identifier |
REFRESH_ID | Refresh identifier |
EXCEPTION_SET_ID | Exception set identifier |
SEQ_NUM | Sequence number (for working days only) |
NEXT_SEQ_NUM | Next sequence number |
PRIOR_SEQ_NUM | Prior sequence number |
NEXT_DATE | Date corresponding to next sequence number |
PRIOR_DATE | Date corresponding to prior sequence number |
CALENDAR_START_DATE | Beginning date for the calendar |
Advanced Supply Chain Planning - MSC_ST_CALENDAR_SHIFTS | The staging table used by the collection program to validate and process data for table MSC_CALENDAR_SHIFTS. |
---|---|
Column Name | Descritpion |
CALENDAR_CODE | Workday Calendar Identifier |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
REQUEST_ID | Concurrent Who column |
PROGRAM_APPLICATION_ID | Concurrent Who column |
PROGRAM_ID | Concurrent Who column |
PROGRAM_UPDATE_DATE | Concurrent Who column |
REFRESH_ID | Refresh identifier |
SR_INSTANCE_ID | Source application instance identifier |
COMPANY_ID | Company identifier |
COMPANY_NAME | Company name |
SHIFT_NAME | To identify a shift |
SR_INSTANCE_CODE | Source Instance Code |
MESSAGE_ID | This is a foreign key reference to ECX_DOCLOGS.INTERNAL_CONTROL_NUMBER for records got via XML |
SHIFT_NUM | If SHIFT_NAME is numeric then SHIFT_NUM will be same as SHIFT_NAME. Otherwise it wiil be a unique number to identify this shift in the calendar. This should not be loaded directly into staging table during batch upload. |
PROCESS_FLAG | Processing Flag indicating the status of records during pre-processing.1- New Record, 2- In-Process, 3- Error, 4- Propagated Error, 5- Successfully Processed |
DATA_SOURCE_TYPE | Source Type indicating source of data, BATCH/XML |
ST_TRANSACTION_ID | Transaction ID generated during pre-processing to uniquely identify a record in the staging table |
ERROR_TEXT | If PROCESS_FLAG is equal to 3 for a record, then this will describe the reason for the error |
DAYS_ON | Number of consecutive working days |
DAYS_OFF | Number of consecutive non-working days |
DESCRIPTION | Description |
DELETED_FLAG | Yes/No flag indicating whether the row will be deleted |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
Advanced Supply Chain Planning - MSC_ST_CAL_WEEK_START_DATES | The staging table used by the collection program to validate and process data for table MSC_CAL_WEEK_START_DATES. |
---|---|
Column Name | Descritpion |
CALENDAR_CODE | Workday calendar identifier |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
REQUEST_ID | Concurrent Who column |
PROGRAM_APPLICATION_ID | Concurrent Who column |
PROGRAM_ID | Concurrent Who column |
PROGRAM_UPDATE_DATE | Concurrent Who column |
REFRESH_ID | Refresh identifier |
SR_INSTANCE_ID | Source application instance identifier |
EXCEPTION_SET_ID | Exception set identifier |
WEEK_START_DATE | Week start date |
NEXT_DATE | Date corresponding to the next working date |
PRIOR_DATE | Date corresponding to the prior working date |
SEQ_NUM | Sequence number (for working days) |
DELETED_FLAG | Yes/No flag indicating whether the row will be deleted |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
Advanced Supply Chain Planning - MSC_ST_CAL_YEAR_START_DATES | The staging table used by the collection program to validate and process data for table MSC_YEAR_START_DATES. |
---|---|
Column Name | Descritpion |
CALENDAR_CODE | Workday calendar identifier |
REQUEST_ID | Concurrent Who column |
PROGRAM_APPLICATION_ID | Concurrent Who column |
PROGRAM_ID | Concurrent Who column |
PROGRAM_UPDATE_DATE | Concurrent Who column |
REFRESH_ID | Refresh identifier |
SR_INSTANCE_ID | Source application instance identifier |
EXCEPTION_SET_ID | Exception set unique identifier |
YEAR_START_DATE | Year start date |
DELETED_FLAG | Yes/No flag indicating whether the row will be deleted |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
Advanced Supply Chain Planning - MSC_ST_CATEGORY_SETS | The staging table used by the collection program to validate and process data for table MSC_CATEGORY_SETS. |
---|---|
Column Name | Descritpion |
CATEGORY_SET_ID | Category set identifier |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
REQUEST_ID | Concurrent Who column |
PROGRAM_APPLICATION_ID | Concurrent Who column |
PROGRAM_ID | Concurrent Who column |
PROGRAM_UPDATE_DATE | Concurrent Who column |
SR_INSTANCE_ID | Source application instance identifier |
REFRESH_ID | Refresh identifier |
COMPANY_ID | Company identifier |
COMPANY_NAME | Company name |
SR_INSTANCE_CODE | Source Instance Code |
SR_CATEGORY_SET_ID | Category set identifier from source application instance |
MESSAGE_ID | This is a foreign key reference to ECX_DOCLOGS.INTERNAL_CONTROL_NUMBER for records got via XML |
PROCESS_FLAG | Processing Flag indicating the status of records during pre-processing. 1- New Record, 2- In-Process, 3- Error, 4- Propagated Error, 5- Successfully Processed |
DATA_SOURCE_TYPE | Source Type indicating the source of data |
ST_TRANSACTION_ID | Transaction ID generated during pre-processing to uniquely identify a record in the staging table |
ERROR_TEXT | If PROCESS_FLAG is equal to 3 for a record, then this will describe the reason for the error |
BATCH_ID | Batch identifier generated during pre-processing |
CATEGORY_SET_NAME | Category set name |
DESCRIPTION | Category set description |
CONTROL_LEVEL | Control level |
DEFAULT_FLAG | Default flag |
DELETED_FLAG | Yes/No flag indicating whether the row will be deleted |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
Advanced Supply Chain Planning - MSC_ST_COMPONENT_SUBSTITUTES | The staging table used by the collection program to validate and process data for table MSC_COMPONENT_SUBSTITUTES. |
---|---|
Column Name | Descritpion |
COMPONENT_SEQUENCE_ID | Component sequence identifier |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
REQUEST_ID | Concurrent Who column |
PROGRAM_APPLICATION_ID | Concurrent Who column |
PROGRAM_ID | Concurrent Who column |
PROGRAM_UPDATE_DATE | Concurrent Who column |
SR_INSTANCE_ID | Source application instance identifier |
REFRESH_ID | Refresh identifier |
BILL_SEQUENCE_ID | Bill sequence identifier |
COMPANY_ID | Company identifier |
COMPANY_NAME | Company name |
BOM_NAME | BOM Name. If this is empty during uploads then it would be replaced by ASSEMBLY_NAME |
SUBSTITUTE_ITEM_ID | Substitute item identifier |
ORGANIZATION_CODE | Organization Code |
ASSEMBLY_NAME | Assembly Name. This has to be provided for uploads from legacy. |
SR_INSTANCE_CODE | Source Instance Code |
COMPONENT_NAME | Component Name |
OPERATION_SEQ_CODE | Operation Sequence Code. This has to be provided during loads from legacy to help link this component to a routing operation. |
EFFECTIVITY_DATE | Effectivity Date |
SUB_ITEM_NAME | Substitute Component Name |
ALTERNATE_BOM_DESIGNATOR | Alternate BOM's Reference |
ERROR_TEXT | If PROCESS_FLAG is equal to 3 for a record, then this will describe the reason for the error |
MESSAGE_ID | This is a foreign key reference to ECX_DOCLOGS.INTERNAL_CONTROL_NUMBER for records got via XML |
PROCESS_FLAG | Processing Flag indicating the status of records during pre-processing. 1- New Record, 2- In-Process, 3- Error, 4- Propagated Error, 5- Successfully Processed |
DATA_SOURCE_TYPE | Source type indicating the source of records |
ST_TRANSACTION_ID | Transaction ID generated during pre-processing to uniquely identify a record in the staging table |
BATCH_ID | Batch identifier generated during pre-processing |
ROUNDING_DIRECTION | Rounding Direction |
USAGE_QUANTITY | Usage quantity for the substitute component |
ORGANIZATION_ID | Organization identifier |
PRIORITY | Priority code |
DELETED_FLAG | Yes/No flag indicating whether the row will be deleted |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
Advanced Supply Chain Planning - MSC_ST_DEMANDS | The staging table used by the collection program to validate and process data for table MSC_DEMANDS. |
---|---|
Column Name | Descritpion |
ORDER_PRIORITY | Order priority |
DAILY_DEMAND_RATE | Repetitive demand rate |
DATA_SOURCE_TYPE | Source Type indicating the source of data |
ST_TRANSACTION_ID | Transaction ID generated during pre-processing to uniquely identify a record in the staging table |
ERROR_TEXT | If PROCESS_FLAG is equal to 3 for a record, then this will describe the reason for the error |
COMMENTS | Comments |
PROMISE_DATE | Date promised to the customer |
LINK_TO_LINE_ID | Parent Line Identifier |
QUANTITY_PER_ASSEMBLY | |
ORDER_DATE_TYPE_CODE | |
LATEST_ACCEPTABLE_DATE | |
SHIPPING_METHOD_CODE | |
ORIGINATION_TYPE | Origin of the demand: Planned order, hard reversation, etc... |
SCHEDULE_SHIP_DATE | |
SCHEDULE_ARRIVAL_DATE | |
REQUEST_SHIP_DATE | |
PROMISE_SHIP_DATE | |
SOURCE_ORG_ID | |
SOURCE_INVENTORY_ITEM_ID | |
SOURCE_USING_ASSEMBLY_ITEM_ID | |
SOURCE_SALES_ORDER_LINE_ID | |
SOURCE_PROJECT_ID | |
SOURCE_TASK_ID | |
SOURCE_ORGANIZATION_ID | Source organization identifier |
SOURCE_CUSTOMER_SITE_ID | |
SOURCE_BILL_ID | |
SOURCE_DISPOSITION_ID | |
SOURCE_CUSTOMER_ID | |
SOURCE_OPERATION_SEQ_NUM | |
SOURCE_WIP_ENTITY_ID | |
ROUTING_SEQUENCE_ID | |
ASSET_SERIAL_NUMBER | |
ASSET_ITEM_ID | |
COMPONENT_SCALING_TYPE | |
DISPOSITION_ID | Identifier reference to the supply generating the demand |
COMPONENT_YIELD_FACTOR | |
ITEM_TYPE_ID | |
ITEM_TYPE_VALUE | |
REPAIR_LINE_ID | |
RO_STATUS_CODE | |
REPAIR_NUMBER | |
ENTITY | |
REVISED_DMD_DATE | |
REVISED_DMD_PRIORITY | |
SCHEDULE_DESIGNATOR_ID | |
RESERVATION_ID | Reservation identitfier |
OBJECT_TYPE | |
DEMAND_SCHEDULE_NAME | Demand schedule name |
PROJECT_ID | Project identifier to which the demand applies |
TASK_ID | Task identifier to which the demand applies |
PLANNING_GROUP | Planning group |
END_ITEM_UNIT_NUMBER | End item unit number |
DEMAND_ID | Demand identifier |
SCHEDULE_DATE | Schedule date |
OPERATION_SEQ_NUM | Operation sequence number |
QUANTITY_ISSUED | Quantity issued |
DEMAND_CLASS | Demand class code |
SALES_ORDER_NUMBER | Sales order number |
SALES_ORDER_PRIORITY | Sales order priority |
FORECAST_PRIORITY | Forecast priority |
MPS_DATE_REQUIRED | MPS date required |
PO_NUMBER | Purchase order number |
WIP_ENTITY_NAME | Wip job name |
INVENTORY_ITEM_ID | Inventory item identifier |
DELETED_FLAG | Yes/No flag indicating whether the row will be deleted |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
REQUEST_ID | Concurrent Who column |
PROGRAM_APPLICATION_ID | Concurrent Who column |
PROGRAM_ID | Concurrent Who column |
PROGRAM_UPDATE_DATE | Concurrent Who column |
ORGANIZATION_ID | Organization identifier |
SR_INSTANCE_ID | Source application instance identifier |
REFRESH_ID | Refresh identifier populated by the collection program |
REPETITIVE_SCHEDULE_ID | Repetitive schedule identifier |
WIP_ENTITY_ID | WIP job identifier |
SELLING_PRICE | Selling price |
DMD_LATENESS_COST | Demand lateness cost for independent demands |
DMD_SATISFIED_DATE | Date demand is satisfied |
DMD_SPLIT_FLAG | Demand split flag |
REQUEST_DATE | Request date |
ORDER_NUMBER | WIP entity name |
USING_ASSEMBLY_ITEM_ID | Using assembly iten identifier (item generates demand for dependent demands) |
WIP_STATUS_CODE | WIP job status code |
WIP_SUPPLY_TYPE | WIP supply type |
ATTRIBUTE1 | Descriptive flexfield segment |
ATTRIBUTE2 | Descriptive flexfield segment |
ATTRIBUTE3 | Descriptive flexfield segment |
ATTRIBUTE4 | Descriptive flexfield segment |
ATTRIBUTE5 | Descriptive flexfield segment |
ATTRIBUTE6 | Descriptive flexfield segment |
ATTRIBUTE7 | Descriptive flexfield segment |
ATTRIBUTE8 | Descriptive flexfield segment |
USING_ASSEMBLY_DEMAND_DATE | Demand date (due date) |
ATTRIBUTE9 | Descriptive flexfield segment |
ATTRIBUTE10 | Descriptive flexfield segment |
ATTRIBUTE11 | Descriptive flexfield segment |
ATTRIBUTE12 | Descriptive flexfield segment |
ATTRIBUTE13 | Descriptive flexfield segment |
ATTRIBUTE14 | Descriptive flexfield segment |
ATTRIBUTE15 | Descriptive flexfield segment |
SALES_ORDER_LINE_ID | Sales order line identifier |
CONFIDENCE_PERCENTAGE | Forecast confidence percentage |
BUCKET_TYPE | Bucket type |
USING_REQUIREMENT_QUANTITY | Required quantity |
BILL_ID | Forecast billing address identifier |
CUSTOMER_ID | Customer Id |
PROBABILITY | Demand probability |
SERVICE_LEVEL | Service Level |
FORECAST_MAD | Forecast Mad |
FORECAST_DESIGNATOR | Forecast Designator |
ORIGINAL_SYSTEM_REFERENCE | Original System Reference |
ORIGINAL_SYSTEM_LINE_REFERENCE | Original System Line Reference |
DEMAND_SOURCE_TYPE | Demand Source Type |
SHIP_TO_SITE_ID | Destination of the product |
ASSEMBLY_DEMAND_COMP_DATE | Using assembly completion date |
COMPANY_ID | Company identifier |
COMPANY_NAME | Company name |
CUSTOMER_NAME | Customer Name |
CUSTOMER_SITE_ID | Customer Site Id |
CUSTOMER_SITE_CODE | Customer Site Code |
BILL_CODE | Bill to site code |
ITEM_NAME | Item for which MDS is given |
ROUTING_NAME | Routing Name |
ALTERNATE_ROUTING_DESIGNATOR | Alternate Routing Designator |
OPERATION_EFFECTIVITY_DATE | Effectivity Date |
DEMAND_TYPE | Discrete Demand(1), Rate-based demand(2) |
USING_ASSEMBLY_ITEM_NAME | Assembly Item name for which job is created in WIP |
PROJECT_NUMBER | Project Identifier |
TASK_NUMBER | Task Identifier |
SCHEDULE_LINE_NUM | Schedule Line Number. This would be used to uniqely identify a demand record for a schedule during batch loads. |
OPERATION_SEQ_CODE | Operation Sequence Code |
ORGANIZATION_CODE | Organization Code |
SR_INSTANCE_CODE | Source Instance code |
MESSAGE_ID | This is a foreign key reference to ECX_DOCLOGS.INTERNAL_CONTROL_NUMBER for records got via XML |
PROCESS_FLAG | Processing Flag indicating the status of records during pre-processing. 1- New Record, 2- In-Process, 3- Error, 4- Propagated Error, 5- Successfully Processed |
BATCH_ID | Batch identifier generated during pre-processing |
Advanced Supply Chain Planning - MSC_ST_DEPARTMENT_RESOURCES | The staging table used by the collection program to validate and process data for table MSC_DEPARTMENT_RESOURCES. |
---|---|
Column Name | Descritpion |
ORGANIZATION_ID | Organization identifier |
MAX_RATE | Hourly minimum rate of production line |
MIN_RATE | Hourly maximum rate of production line |
AGGREGATED_RESOURCE_ID | Reference to aggregate resource, if aggregated |
AGGREGATED_RESOURCE_FLAG | Yes/No flag to indicate whether this is an aggregated resource |
RESOURCE_GROUP_NAME | Resource group name |
RESOURCE_GROUP_CODE | Resource group code |
RESOURCE_BALANCE_FLAG | Flag to indicate if the resource needs to load balanced |
BOTTLENECK_FLAG | Flag to indicate if the resource is a known bottleneck |
START_TIME | Start time of the line |
STOP_TIME | Stop tiem of the line |
RESOURCE_ID | Source application resource identifier |
DEPARTMENT_DESCRIPTION | Describes of the line or department |
RESOURCE_DESCRIPTION | Describes the resource |
OVER_UTILIZED_PERCENT | Overutilization tolerance |
UNDER_UTILIZED_PERCENT | Underutilization tolerance |
RESOURCE_SHORTAGE_TYPE | Resource shortage type |
RESOURCE_EXCESS_TYPE | Resource excess type |
USER_TIME_FENCE | User time fence |
UTILIZATION | Utilization |
EFFICIENCY | Efficiency |
RESOURCE_INCLUDE_FLAG | Resource include flag |
RESOURCE_CODE | Resource code |
CRITICAL_RESOURCE_FLAG | Critical resource flag |
RESOURCE_TYPE | Resource type |
DISABLE_DATE | Disable date |
LINE_DISABLE_DATE | Line disable date |
AVAILABLE_24_HOURS_FLAG | Resource is available 24 hours or by shifts |
CTP_FLAG | Flag indicating whether the department resource is used for ATP or not |
DELETED_FLAG | Yes/No flag indicating whether the row will be deleted |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
DEPARTMENT_ID | Source application department identifier or line identifier |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
REQUEST_ID | Concurrent Who column |
PROGRAM_APPLICATION_ID | Concurrent Who column |
PROGRAM_ID | Concurrent Who column |
PROGRAM_UPDATE_DATE | Concurrent Who column |
SR_INSTANCE_ID | Source application instance identifier |
REFRESH_ID | Refresh identifier populated by the collection program |
DEPT_OVERHEAD_COST | Department overhead cost |
RESOURCE_COST | Resource cost |
DEPARTMENT_CODE | Department code, also holds line code |
RESOURCE_OVER_UTIL_COST | Resource overutilization cost |
PLANNING_EXCEPTION_SET | Planning Exception Set |
BATCHABLE_FLAG | Batchable Flag |
BATCHING_WINDOW | Batching Window |
MIN_CAPACITY | Min Capacity |
MAX_CAPACITY | Max Capacity |
UNIT_OF_MEASURE | Unit Of Measure |
UOM_CLASS_TYPE | Uom Class Type |
COMPANY_ID | Company identifier |
COMPANY_NAME | Company name |
DEPARTMENT_CLASS | Department class |
OWNING_DEPARTMENT_CODE | Owning Department Code |
ORGANIZATION_CODE | Organization Code |
SR_INSTANCE_CODE | Source instance code |
MESSAGE_ID | This is a foreign key reference to ECX_DOCLOGS.INTERNAL_CONTROL_NUMBER for records got via XML |
PROCESS_FLAG | Processing Flag indicating the status of records during pre-processing. 1- New Record, 2- In-Process, 3- Error, 4- Propagated Error, 5- Successfully Processed |
ERROR_TEXT | If PROCESS_FLAG is equal to 3 for a record, then this will describe the reason for the error |
ST_TRANSACTION_ID | Transaction ID generated during pre-processing to uniquely identify a record in the staging table |
BATCH_ID | Batch identifier generated during pre-processing |
DATA_SOURCE_TYPE | Source Type indicating the source of the records |
ATP_RULE_ID | |
LINE_FLAG | Flag to indicate whether or not this resource is a line |
SOURCE_ORGANIZATION_ID | |
SOURCE_DEPARTMENT_ID | |
SOURCE_RESOURCE_ID | |
SOURCE_OWNING_DEPARTMENT_ID | |
CAPACITY_TOLERANCE | |
CHARGEABLE_FLAG | |
IDLE_TIME_TOLERANCE | |
BATCHING_PENALTY | |
LAST_KNOWN_SETUP | |
SCHEDULE_TO_INSTANCE | |
OWNING_DEPARTMENT_ID | Owning department identifier |
SDS_SCHEDULING_WINDOW | |
SETUP_TIME_PERCENT | |
UTILIZATION_CHANGE_PERCENT | |
SETUP_TIME_TYPE | |
UTILIZATION_CHANGE_TYPE | |
CAPACITY_UNITS | Resource capacity |
Advanced Supply Chain Planning - MSC_ST_DESIGNATORS | The staging table used by the collection program to validate and process data for table MSC_DESIGNTORS. |
---|---|
Column Name | Descritpion |
DESIGNATOR_ID | Designator identifier |
DEMAND_CLASS | Demand class code |
ORGANIZATION_SELECTION | Single/Multiple organizations |
PRODUCTION | Production flag |
RECOMMENDATION_RELEASE | Planned order release flag |
DESIGNATOR_TYPE | Schedule type |
DELETED_FLAG | Yes/No flag indicating whether the row will be deleted |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
DESIGNATOR | Source application schedule name |
LAST_UPDATE_LOGIN | Standard Who column |
REQUEST_ID | Concurrent Who column |
PROGRAM_APPLICATION_ID | Concurrent Who column |
PROGRAM_ID | Concurrent Who column |
PROGRAM_UPDATE_DATE | Concurrent Who column |
SR_INSTANCE_ID | Source application instance identifier |
REFRESH_ID | Refresh number populated by the collection program |
CONSUME_FORECAST | Consume forecast flag |
UPDATE_TYPE | Forecast update type code |
FORWARD_UPDATE_TIME_FENCE | Forward consumption days |
BACKWARD_UPDATE_TIME_FENCE | Backward consumption days |
OUTLIER_UPDATE_PERCENTAGE | Forecast outlier update percentage |
FORECAST_SET_ID | Forecast set identifier |
CUSTOMER_ID | Customer identifier |
SR_DESIGNATOR | Source designator identifier |
SHIP_ID | Forecast ship code identifier |
BILL_ID | Forecast billing address identifier |
BUCKET_TYPE | Forecast bucket type - days, weeks or periods |
PROBABILITY | Probability |
FORECAST_SET | Source Forecast Set |
COMPANY_ID | Company identifier |
COMPANY_NAME | Company name |
ORGANIZATION_CODE | Organization Code |
CUSTOMER_NAME | Customer Name |
SHIP_TO_SITE_CODE | Shipping site code |
BILL_TO_SITE_CODE | Billing site code |
SR_INSTANCE_CODE | Source Instance code |
MESSAGE_ID | This is a foreign key reference to ECX_DOCLOGS.INTERNAL_CONTROL_NUMBER for records got via XML |
PROCESS_FLAG | Processing Flag indicating the status of records during pre-processing. 1- New Record, 2- In-Process, 3- Error, 4- Propagated Error, 5- Successfully Processed |
DATA_SOURCE_TYPE | Source type indicating the source of data |
ST_TRANSACTION_ID | Transaction ID generated during pre-processing to uniquely identify a record in the staging table |
ERROR_TEXT | If PROCESS_FLAG is equal to 3 for a record, then this will describe the reason for the error |
BATCH_ID | Batch identifier generated during pre-processing |
SELLER_FLAG | Seller Flag |
ORGANIZATION_ID | Organization identifier |
SR_ORGANIZATION_ID | Source organization identifier |
MPS_RELIEF | Flag to indicate whether MPS relief performed against this designator |
INVENTORY_ATP_FLAG | ATP supply flag |
DESCRIPTION | Description of the this designator |
DISABLE_DATE | Designator disable date |
Advanced Supply Chain Planning - MSC_ST_INTERORG_SHIP_METHODS | The staging table used by the collection program to validate and process data for table MSC_INTERORG_SHIP_METHODS. |
---|---|
Column Name | Descritpion |
FROM_ORGANIZATION_ID | Organization identifier for the origin organization |
WEIGHT_CAPACITY | Weight capacity of this ship method |
WEIGHT_UOM | Weight unit of measure |
VOLUME_CAPACITY | Weight capacity |
VOLUME_UOM | Volume unit of measure |
COST_PER_WEIGHT_UNIT | Cost per weight unit |
COST_PER_VOLUME_UNIT | Cost per volume unit |
INTRANSIT_TIME | Intransit time |
DELETED_FLAG | Deleted flag |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
TO_ORGANIZATION_ID | Organization identifier for the destination organization' |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
REQUEST_ID | Concurrent Who column |
PROGRAM_APPLICATION_ID | Concurrent Who column |
PROGRAM_ID | Concurrent Who column |
PROGRAM_UPDATE_DATE | Concurrent Who column |
REFRESH_ID | Refresh identifier |
SR_INSTANCE_ID | Source application instance identifier of the source org |
TRANSPORT_CAP_OVER_UTIL_COST | Transport cap over utilized cost |
SHIP_METHOD | Ship method |
SR_INSTANCE_ID2 | Source application instance identifier of the destination org |
TO_REGION_ID | To Region Id |
FROM_ORGANIZATION_CODE | Source Organization Code |
TO_ORGANIZATION_CODE | Receipt Organization Code |
SR_INSTANCE_CODE | Instance Code |
MESSAGE_ID | This is a foriegn key reference to ECX_DOCLOGS.INTERNAL_CONTROL_NUMBER for records got via XML |
PROCESS_FLAG | Processing flag indicating the status of records during pre-processing 1-New record, 2-Inprocess, 3-Error , 4- Propagated error, 5-Successfully Processed |
DATA_SOURCE_TYPE | Source type indicating the source of records |
ST_TRANSACTION_ID | Transaction ID generated during pre-processing to uniquely identify a record |
ERROR_TEXT | If PROCESS_FLAG=3 for a record, then this will describe the reason for the error |
TIME_UOM_CODE | Unit of measure used to specify the intransit lead time |
BATCH_ID | Batch Identifier generated during pre-processing |
COMPANY_NAME | Company Name |
FROM_LOCATION_CODE | Ship from location in the shipment method relationship |
TO_LOCATION_CODE | Ship to location in the shipment method relationship |
INSTRANSIT_TIME | Instransit time |
DEFAULT_FLAG | Flag to indicate if this is a default ship method |
FROM_LOCATION_ID | Location identifier of the origin location |
TO_LOCATION_ID | Location identifier of the destination location |
AVAILABILITY_DATE | Availability date |
Advanced Supply Chain Planning - MSC_ST_ITEM_CATEGORIES | The staging table used by the collection program to validate and process data for table MSC_ITEM_CATEGORIES. |
---|---|
Column Name | Descritpion |
INVENTORY_ITEM_ID | Inventory item identifier |
START_DATE_ACTIVE | Start date |
END_DATE_ACTIVE | End date |
CATEGORY_SET_NAME | Category set name |
DELETED_FLAG | Deleted flag |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
REQUEST_ID | Concurrent Who column |
ORGANIZATION_ID | Organization identifer |
PROGRAM_APPLICATION_ID | Concurrent Who column |
PROGRAM_ID | Concurrent Who column |
PROGRAM_UPDATE_DATE | Concurrent Who column |
SR_INSTANCE_ID | Source application instance identifier |
REFRESH_ID | Refresh identifier |
COMPANY_ID | Company identifier |
COMPANY_NAME | Company name |
ITEM_NAME | Item Name |
ORGANIZATION_CODE | Organization Code |
SR_INSTANCE_CODE | Source Instance code |
SR_CATEGORY_SET_ID | Category set identifer from source applicaiton |
MESSAGE_ID | This is a foreign key reference to ECX_DOCLOGS.INTERNAL_CONTROL_NUMBER for records got via XML |
PROCESS_FLAG | Processing Flag indicating the status of records during pre-processing. 1- New Record, 2- In-Process, 3- Error, 4- Propagated Error, 5- Successfully Processed |
DATA_SOURCE_TYPE | Source type indicating the source of data |
ST_TRANSACTION_ID | Transaction ID generated during pre-processing to uniquely identify a record in the staging table |
BATCH_ID | Batch identifier generated during pre-processing |
ERROR_TEXT | If PROCESS_FLAG is equal to 3 for a record, then this will describe the reason for the error |
SOURCE_ORG_ID | |
SOURCE_INVENTORY_ITEM_ID | |
SOURCE_SR_CATEGORY_SET_ID | |
SOURCE_SR_CATEGORY_ID | |
SR_CATEGORY_ID | Category identifer from source application |
CATEGORY_NAME | Category name |
DESCRIPTION | Description |
DISABLE_DATE | Disable date |
SUMMARY_FLAG | Summary flag |
ENABLED_FLAG | Enabled flag |
Advanced Supply Chain Planning - MSC_ST_ITEM_SUPPLIERS | The staging table used by the collection program to validate and process data for table MSC_ITEM_SUPPLIERS. |
---|---|
Column Name | Descritpion |
INVENTORY_ITEM_ID | Inventory item identifier |
DELIVERY_CALENDAR_CODE | Delivery calendar code |
VENDOR_NAME | Supplier name |
VENDOR_SITE_CODE | Supplier site code |
SUPPLIER_CAP_OVER_UTIL_COST | Supplier cap over util cost |
DELETED_FLAG | Deleted flag |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
ORGANIZATION_ID | Organization identifier |
REQUEST_ID | Concurrent Who column |
PROGRAM_APPLICATION_ID | Concurrent Who column |
PROGRAM_ID | Concurrent Who column |
PROGRAM_UPDATE_DATE | Concurrent Who column |
SR_INSTANCE_ID | Source application instance identifier |
SR_INSTANCE_ID2 | Source application instance identifier of using organization |
REFRESH_ID | Refresh identifer |
PURCHASING_UNIT_OF_MEASURE | Purchasing unit of measure |
ITEM_PRICE | Item Price |
COMPANY_ID | Company identifier |
COMPANY_NAME | Company name |
ITEM_NAME | Item Name |
ORGANIZATION_CODE | Organization Code |
SR_INSTANCE_CODE | Source Instance code |
MESSAGE_ID | This is a foreign key reference to ECX_DOCLOGS.INTERNAL_CONTROL_NUMBER for records got via XML |
PROCESS_FLAG | Processing Flag indicating the status of records during pre-processing. 1- New Record, 2- In-Process, 3- Error, 4- Propagated Error, 5- Successfully Processed |
SUPPLIER_ID | Supplier identifier |
DATA_SOURCE_TYPE | Source Type indicating the source of data |
ST_TRANSACTION_ID | Transaction ID generated during pre-processing to uniquely identify a record in the staging table |
ERROR_TEXT | If PROCESS_FLAG is equal to 3 for a record, then this will describe the reason for the error |
BATCH_ID | Batch identifier generated during pre-processing |
SUPPLIER_ITEM_NAME | Supplier cross reference item name |
PLANNER_CODE | Planner code |
SUPPLIER_COMPANY_ID | Supplier company identifier |
SUPPLIER_COMPANY_SITE_ID | Supplier company site identifier |
VMI_FLAG | Flag to identify item is VMI planned |
MIN_MINMAX_QUANTITY | Minimum minmax quantity |
MAX_MINMAX_QUANTITY | Maximum minmax quantity |
MAXIMUM_ORDER_QUANTITY | Maximum order quantity |
VMI_REPLENISHMENT_APPROVAL | VMI Replenishment Approval |
ENABLE_VMI_AUTO_REPLENISH_FLAG | Flag to indicate VMI Auto Replenishment |
ASL_LEVEL | asl level |
USING_ORGANIZATION_CODE | using organization id |
SUPPLIER_SITE_ID | Supplier site identifer |
USING_ORGANIZATION_ID | Using organization identifier |
ASL_ID | ASL identifier |
PROCESSING_LEAD_TIME | Processing lead time |
MINIMUM_ORDER_QUANTITY | Minimum order quantity |
FIXED_LOT_MULTIPLE | Fixed lot multiple |
Advanced Supply Chain Planning - MSC_LOCATION_ASSOCIATIONS | This table stores location associations for organization, customer, customer sites, supplier, and supplier sites. |
---|---|
Column Name | Descritpion |
SR_INSTANCE_ID | Source application instance identifier |
LOCATION_CODE | Location code |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
ORGANIZATION_ID | Organization identifier |
CREATION_DATE | Standard Who column |
PARTNER_ID | Partner identifier |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
REQUEST_ID | Concurrent Who column |
PROGRAM_APPLICATION_ID | Concurrent Who column |
PROGRAM_ID | Concurrent Who column |
PARTNER_SITE_ID | Partner site identifer |
PROGRAM_UPDATE_DATE | Concurrent Who column |
LOCATION_ID | Location identifier |
Advanced Supply Chain Planning - MSC_PLAN_PARTITIONS | The table stores partition information for plans. |
---|---|
Column Name | Descritpion |
PLAN_NAME | Plan name |
FREE_FLAG | Flag indicating whether the partition is free or not |
PARTITION_NUMBER | Partition number |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
PLAN_ID | Plan identifier |
REQUEST_ID | Concurrent Who column |
PROGRAM_APPLICATION_ID | Concurrent Who column |
PROGRAM_ID | Concurrent Who column |
PROGRAM_UPDATE_DATE | Concurrent Who column |
Advanced Supply Chain Planning - MSC_PLAN_REFRESHES | This table used by collection program to keep track of the refresh numbers for each plan. |
---|---|
Column Name | Descritpion |
SR_INSTANCE_ID | Source application instance identifier |
REFRESH_NUMBER | Indicates the last refresh number from destination database. Represents the sequence msc_collection_s from destination database. |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
REQUEST_ID | Concurrent Who column |
PROGRAM_APPLICATION_ID | Concurrent Who column |
PLAN_ID | Plan identifier |
PROGRAM_ID | Concurrent Who column |
PROGRAM_UPDATE_DATE | Concurrent Who column |
APPS_LRN | Indicates the last refresh number from source database. The apps_lrn is used by Collections/ATP Purposes. Represents the Sequence mrp_ap_refresh_s from source database. |
Advanced Supply Chain Planning - MSC_REPETITIVE_PERIODS | Repetitive planning period start dates |
---|---|
Column Name | Descritpion |
PERIOD_START_DATE | Period start date |
PROGRAM_APPLICATION_ID | Concurrent Who Column |
PROGRAM_ID | Concurrent Who Column |
PROGRAM_UPDATE_DATE | Concurrent Who Column |
ORGANIZATION_ID | Organization identifier |
SR_INSTANCE_ID | Source application instance identifier |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
REQUEST_ID | Concurrent Who Column |
Advanced Supply Chain Planning - MSC_ST_BIS_PERIODS | The staging table used by the collection program to validate and process data for table MSC_BIS_PERIODS. |
---|---|
Column Name | Descritpion |
ORGANIZATION_ID | Organization identifier |
ENTERED_PERIOD_NAME | User entered accounting period name |
ADJUSTMENT_PERIOD_FLAG | Calendar period adjustment status |
DESCRIPTION | Accounting period description |
CONTEXT | Descriptive flexfield segment |
YEAR_START_DATE | Date on which the year containing this accounting period starts |
QUARTER_START_DATE | Date on which the quarter containing this accounting period starts |
LAST_UPDATE_DATE | Standard Who Column |
LAST_UPDATED_BY | Standard Who Column |
CREATION_DATE | Standard Who Column |
CREATED_BY | Standard Who Column |
PERIOD_SET_NAME | Accounting calendar name |
LAST_UPDATE_LOGIN | Standard Who Column |
REQUEST_ID | Concurrent Who Column |
PROGRAM_APPLICATION_ID | Concurrent Who Column |
PROGRAM_ID | Concurrent Who Column |
PROGRAM_UPDATE_DATE | Concurrent Who Column |
REFRESH_ID | Refresh identifier |
SR_INSTANCE_ID | Source application instance identifier |
PERIOD_NAME | Accounting calendar name |
START_DATE | Date on which accounting period begins |
END_DATE | Date on which accounting period ends |
PERIOD_TYPE | Accounting period type |
PERIOD_YEAR | Accounting period year |
PERIOD_NUM | Accounting period number |
QUARTER_NUM | Accounting period number |
Advanced Supply Chain Planning - MSC_PO_REQUISITIONS_INTERFACE | Requisition Import interface table |
---|---|
Column Name | Descritpion |
PROJECT_ACCOUNTING_CONTEXT | Project accouting descriptive flexfield context column |
GROUP_CODE | Import group code |
PREPARER_ID | Preparer identifier |
AUTOSOURCE_FLAG | Flag indicates whether autosourcing |
SOURCE_ORGANIZATION_ID | Source organization identifier |
DESTINATION_ORGANIZATION_ID | Destination organization identifier |
DELIVER_TO_LOCATION_ID | Deliver-to-location unique identifier |
DELIVER_TO_REQUESTOR_ID | Requestor unique identifier |
SUGGESTED_VENDOR_ID | Suggested supplier unique identifier |
SUGGESTED_VENDOR_SITE_ID | Suggested supplier site unique identifier |
LAST_UPDATED_BY | Standard Who Column |
PROJECT_ID | Project identifier |
LAST_UPDATE_DATE | Standard Who Column |
LAST_UPDATE_LOGIN | Standard Who Column |
CREATION_DATE | Standard Who Column |
CREATED_BY | Standard Who Column |
INTERFACE_SOURCE_CODE | Interface transaction source |
SOURCE_TYPE_CODE | Requisition source |
DESTINATION_TYPE_CODE | Requisition destionation type |
QUANTITY | Quantity ordered |
UOM_CODE | Unit of measure code |
LINE_TYPE_ID | Line type identifier |
TASK_ID | Task identifier |
ORG_ID | Organization identifier |
END_ITEM_UNIT_NUMBER | End item unit number |
SR_INSTANCE_ID | Source application instance identifier |
SUGGESTED_VENDOR_SITE | Suggested supplier site name |
SOURCE_LINE_ID | Source Line Id |
VMI_FLAG | VMI Flag Identifier |
NEED_BY_DATE | Date the requisition is needed internally |
ITEM_ID | Item identifier |
ITEM_REVISION | Item name |
CHARGE_ACCOUNT_ID | Charge account identifier |
AUTHORIZATION_STATUS | Authorization status type |
BATCH_ID | Import batch identifier |
Advanced Supply Chain Planning - MSC_PO_RESCHEDULE_INTERFACE | Requisition reschedule interface table |
---|---|
Column Name | Descritpion |
LINE_ID | Unique identifier for the requisition line |
REQUEST_ID | Concurrent Who Column |
PROGRAM_APPLICATION_ID | Concurrent Who Column |
PROGRAM_ID | Concurrent Who Column |
PROGRAM_UPDATE_DATE | Concurrent Who Column |
SR_INSTANCE_ID | Source application instance identifier |
PURCHASE_ORDER_ID | Purchase Order Id |
PO_NUMBER | Purchase Order Number |
SOURCE_LINE_ID | Source Line Id |
UOM | Unit of Measure |
PLAN_ID | Plan Identifier |
QUANTITY | New quantity for the requisition line |
NEED_BY_DATE | New need-by date for the requisition line |
PROCESS_ID | Process identifier |
LAST_UPDATE_DATE | Standard Who Column |
LAST_UPDATED_BY | Standard Who Column |
CREATION_DATE | Standard Who Column |
CREATED_BY | Standard Who Column |
LAST_UPDATE_LOGIN | Standard Who Column |
Advanced Supply Chain Planning - MSC_ST_ATP_RULES | The staging table used by the collection program to validate and process data for table MSC_ATP_RULES. |
---|---|
Column Name | Descritpion |
RULE_ID | ATP rule identifier |
INFINITE_SUPPLY_FENCE_CODE | Source code for infinite supply time fence |
INFINITE_SUPPLY_TIME_FENCE | Infinite supply time fence days only when user-defined is specified in the time fence code |
ACCEPTABLE_EARLY_FENCE | Acceptable early fence |
ACCEPTABLE_LATE_FENCE | Acceptable late fence |
DEFAULT_ATP_SOURCES | Indicate which subinventories to use for on-hand quantities |
INCLUDE_SALES_ORDERS | Yes/No flag for ATP computation to include demand from sales orders |
INCLUDE_DISCRETE_WIP_DEMAND | Yes/No flag for ATP computation to include demand from WIP discrete jobs |
INCLUDE_REP_WIP_DEMAND | Yes/No flag for ATP computation to include demand from WIP repetitive discrete jobs |
INCLUDE_NONSTD_WIP_DEMAND | Yes/No flag for ATP computation to include demand from WIP non-standard jobs' |
SR_INSTANCE_ID | Instance id |
INCLUDE_DISCRETE_MPS | Yes/No flag for ATP computation to include supply from discrete MPS schedule |
INCLUDE_USER_DEFINED_DEMAND | Yes/No flag for ATP computation to include user defined demand |
INCLUDE_PURCHASE_ORDERS | Yes/No flag for ATP computation to include supply from purchase orders |
INCLUDE_DISCRETE_WIP_RECEIPTS | Yes/No flag for ATP computation to include supply from WIP discrete jobs |
INCLUDE_REP_WIP_RECEIPTS | Yes/No flag for ATP computation to include supply from WIP repetitive schedule jobs |
INCLUDE_NONSTD_WIP_RECEIPTS | Yes/No flag for ATP computation to include supply from WIP non-standard jobs |
INCLUDE_INTERORG_TRANSFERS | Yes/No flag for ATP computation to include supply from inter-organization transfers |
INCLUDE_ONHAND_AVAILABLE | Yes/No flag for ATP computation to include supply from on-hand inventory |
INCLUDE_USER_DEFINED_SUPPLY | Yes/No flag for ATP computation to include supply from user defined source |
ACCUMULATION_WINDOW | Maximum number of days that available supply should be accumulated |
RULE_NAME | Name of ATP rule |
INCLUDE_REP_MPS | Yes/No flag for ATP computation to include supply from repetitive MPS schedules |
INCLUDE_INTERNAL_REQS | Yes/No flag for ATP computation include from internal requisitions |
INCLUDE_SUPPLIER_REQS | Yes/No flag for ATP computation include from internal orders |
INCLUDE_INTERNAL_ORDERS | Yes/No flag for ATP computation to include demand from internal orders |
INCLUDE_FLOW_SCHEDULE_DEMAND | Yes/No flag for ATP computation to include demand from flow schedule |
USER_ATP_SUPPLY_TABLE_NAME | Not currently used |
USER_ATP_DEMAND_TABLE_NAME | Not currently used |
MPS_DESIGNATOR | Not currently used |
LAST_UPDATE_DATE | Standard Who Column |
DESCRIPTION | Desscription for ATP rule |
LAST_UPDATED_BY | Standard Who Column |
CREATION_DATE | Standard Who Column |
CREATED_BY | Standard Who Column |
LAST_UPDATE_LOGIN | Standard Who Column |
REQUEST_ID | Concurrent Who Column |
PROGRAM_APPLICATION_ID | Concurrent Who Column |
PROGRAM_ID | Concurrent Who Column |
PROGRAM_UPDATE_DATE | Concurrent Who Column |
REFRESH_ID | Refresh identifier |
DEMAND_CLASS_ATP_FLAG | Yes/No flag for ATP computation to consider Demand Class when selecting supply and demand |
ACCUMULATE_AVAILABLE_FLAG | Flag for ATP computation to accumulate quantity availability |
INCLUDE_FLOW_SCHEDULE_RECEIPTS | Yes/No flag for ATP computation to include supply from repetitive MPS schedules |
BACKWARD_CONSUMPTION_FLAG | Flag for ATP computation to backwardly consume shortage |
FORWARD_CONSUMPTION_FLAG | Flag for ATP computation to forwardly consume shortage |
PAST_DUE_DEMAND_CUTOFF_FENCE | Demand before the specified number of days are not to be considered in ATP computation |
PAST_DUE_SUPPLY_CUTOFF_FENCE | Supplies before the specified number of days are not to be considered in ATP computation |
Advanced Supply Chain Planning - MSC_QUESTIONS_B | This table stores the seeded and user defined questions for Ask Oracle. The associated MSC_QUESTIONS_TL table contains the translated questions by language. |
---|---|
Column Name | Descritpion |
QUESTION_ID | Unique identifier for the row |
LAST_UPDATE_LOGIN | Standard Who column |
ANSWER_ID | Answer unique identifier |
QUESTION_CODE | Question code |
QUESTION_TYPE | Question type |
PACKAGE_NAME | Package name |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
Advanced Supply Chain Planning - MSC_QUESTIONS_TL | This table contains the translated questions for Ask Oracle |
---|---|
Column Name | Descritpion |
QUESTION_ID | Unique identifier assigned to the row in MSC_QUESTIONS_B |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
LANGUAGE | Language of the question |
USER_QUESTION_NAME | User questions |
DESCRIPTION | Describe the question |
SOURCE_LANG | Source language for the question |
TRANSLATED | Flag indicating whether the question is translated |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
Advanced Supply Chain Planning - MSC_SOURCING_HISTORY | Historical information related to sourcing. |
---|---|
Column Name | Descritpion |
INVENTORY_ITEM_ID | Inventory Item Id |
REFRESH_NUMBER | Refresh Number |
LAST_CALCULATED_DATE | Last Calculated Date |
LAST_UPDATED_BY | Standard Who column |
LAST_UPDATE_DATE | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
REQUEST_ID | Concurrent Who Column |
PROGRAM_APPLICATION_ID | Concurrent Who Column |
PROGRAM_ID | Concurrent Who Column |
ORGANIZATION_ID | Organization Id |
PROGRAM_UPDATE_DATE | Concurrent Who Column |
SR_INSTANCE_ID | sr instance Id |
SOURCING_RULE_ID | Sourcing Rule Id |
SOURCE_ORG_ID | Source Org Id |
SOURCE_SR_INSTANCE_ID | source org sr instance Id |
SUPPLIER_ID | Supplier identifier |
SUPPLIER_SITE_ID | Supplier site identifier |
HISTORICAL_ALLOCATION | Historical Allocation |
Advanced Supply Chain Planning - MSC_MATERIAL_PLANS | MSC_MATERIAL_PLANS is a generic table used by forms for querying data. |
---|---|
Column Name | Descritpion |
QUERY_ID | Query identifier |
HORIZONTAL_PLAN_TYPE | Horizontal plan type |
BUCKET_TYPE | Bucket type |
BUCKET_DATE | Bucket date |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
HORIZONTAL_PLAN_TYPE_TEXT | Horizontal plan type text |
QUANTITY1 | Generic quantity column |
QUANTITY2 | Generic quantity column |
ORGANIZATION_ID | Organization identifier |
QUANTITY3 | Generic quantity column |
QUANTITY4 | Generic quantity column |
QUANTITY5 | Generic quantity column |
QUANTITY6 | Generic quantity column |
QUANTITY7 | Generic quantity column |
QUANTITY8 | Generic quantity column |
QUANTITY9 | Generic quantity column |
QUANTITY10 | Generic quantity column |
QUANTITY11 | Generic quantity column |
QUANTITY12 | Generic quantity column |
SR_INSTANCE_ID | Source application instance identifer |
QUANTITY13 | Generic quantity column |
QUANTITY14 | Generic quantity column |
QUANTITY15 | Generic quantity column |
QUANTITY16 | Generic quantity column |
QUANTITY17 | Generic quantity column |
QUANTITY18 | Generic quantity column |
QUANTITY19 | Generic quantity column |
QUANTITY20 | Generic quantity column |
QUANTITY21 | Generic quantity column |
QUANTITY22 | Generic quantity column |
PLAN_ID | Plan identifier |
QUANTITY23 | Generic quantity column |
QUANTITY24 | Generic quantity column |
QUANTITY25 | Generic quantity column |
QUANTITY26 | Generic quantity column |
QUANTITY27 | Generic quantity column |
QUANTITY28 | Generic quantity column |
QUANTITY29 | Generic quantity column |
QUANTITY30 | Generic quantity column |
QUANTITY31 | Generic quantity column |
QUANTITY32 | Generic quantity column |
PLAN_ORGANIZATION_ID | Planned organization identifier |
QUANTITY33 | Generic quantity column |
QUANTITY34 | Generic quantity column |
QUANTITY35 | Generic quantity column |
QUANTITY36 | Generic quantity column |
QUANTITY37 | |
QUANTITY38 | |
QUANTITY39 | |
QUANTITY40 | |
QUANTITY41 | |
QUANTITY42 | |
PLAN_INSTANCE_ID | Source application instance identifier for the planned org |
QUANTITY43 | |
QUANTITY44 | |
QUANTITY45 | |
QUANTITY46 | |
QUANTITY47 | |
QUANTITY48 | |
QUANTITY49 | |
QUANTITY50 | |
QUANTITY51 | |
QUANTITY52 | |
ORGANIZATION_CODE | Planned organization code |
QUANTITY53 | |
QUANTITY54 | |
QUANTITY55 | |
QUANTITY56 | |
INVENTORY_ITEM_ID | Inventory item identifier |
ITEM_SEGMENTS | Decribe the inventory item |
Advanced Supply Chain Planning - MSC_PLANNERS | This table stores and maintains a list of planner codes. |
---|---|
Column Name | Descritpion |
PLANNER_CODE | Planner code |
DISABLE_DATE | Date on which the planner record is disable |
ATTRIBUTE_CATEGORY | Descriptive flexfield structure defining column |
ATTRIBUTE1 | Descriptive flexfield segment |
ATTRIBUTE2 | Descriptive flexfield segment |
ATTRIBUTE3 | Descriptive flexfield segment |
ATTRIBUTE4 | Descriptive flexfield segment |
ATTRIBUTE5 | Descriptive flexfield segment |
ATTRIBUTE6 | Descriptive flexfield segment |
ATTRIBUTE7 | Descriptive flexfield segment |
ATTRIBUTE8 | Descriptive flexfield segment |
ORGANIZATION_ID | Organization identifier |
ATTRIBUTE9 | Descriptive flexfield segment |
ATTRIBUTE10 | Descriptive flexfield segment |
ATTRIBUTE11 | Descriptive flexfield segment |
ATTRIBUTE12 | Descriptive flexfield segment |
ATTRIBUTE13 | Descriptive flexfield segment |
ATTRIBUTE14 | Descriptive flexfield segment |
ATTRIBUTE15 | Descriptive flexfield segment |
REQUEST_ID | Concurrent Who Column |
PROGRAM_APPLICATION_ID | Concurrent Who Column |
PROGRAM_ID | Concurrent Who Column |
SR_INSTANCE_ID | Source application instance identifier |
PROGRAM_UPDATE_DATE | Concurrent Who Column |
ELECTRONIC_MAIL_ADDRESS | Planner's Email address |
EMPLOYEE_ID | Employee identifier |
CURRENT_EMPLOYEE_FLAG | Flag indicating whether the employee record is current |
REFRESH_NUMBER | Refresh number populated by the collection program |
USER_NAME | Planner's user name |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
DESCRIPTION | Describe the planner |
Advanced Supply Chain Planning - MSC_ST_DEMAND_CLASSES | The staging table used by the collection program to validate and process data for demand classes. |
---|---|
Column Name | Descritpion |
DEMAND_CLASS | Demand class code |
CREATION_DATE | Standard Who Column |
CREATED_BY | Standard Who Column |
LAST_UPDATE_LOGIN | Standard Who Column |
REQUEST_ID | Concurrent Who Column |
PROGRAM_APPLICATION_ID | Concurrent Who Column |
PROGRAM_ID | Concurrent Who Column |
PROGRAM_UPDATE_DATE | Concurrent Who Column |
ATTRIBUTE_CATEGORY | Descriptive flexfield structure defining column |
ATTRIBUTE1 | Descriptive flexfield segment |
ATTRIBUTE2 | Descriptive flexfield segment |
MEANING | Damand class meaning |
ATTRIBUTE3 | Descriptive flexfield segment |
ATTRIBUTE4 | Descriptive flexfield segment |
ATTRIBUTE5 | Descriptive flexfield segment |
ATTRIBUTE6 | Descriptive flexfield segment |
ATTRIBUTE7 | Descriptive flexfield segment |
ATTRIBUTE8 | Descriptive flexfield segment |
ATTRIBUTE9 | Descriptive flexfield segment |
ATTRIBUTE10 | Descriptive flexfield segment |
ATTRIBUTE11 | Descriptive flexfield segment |
ATTRIBUTE12 | Descriptive flexfield segment |
DESCRIPTION | Describe the demand class |
ATTRIBUTE13 | Descriptive flexfield segment |
ATTRIBUTE14 | Descriptive flexfield segment |
ATTRIBUTE15 | Descriptive flexfield segment |
DELETED_FLAG | Deleted flag |
REFRESH_ID | Refresh identifier |
SR_INSTANCE_CODE | Instance Code |
MESSAGE_ID | This is a foreign key reference to ECX_DOCLOGS.INTERNAL_CONTROL_NUMBER for records got via XML |
PROCESS_FLAG | Processing flag indicating the status of records during pre-processing. 1-New Record, 2- In-Process, 3- Error, 4-Propagated Error, 5- Successfully Processed |
DATA_SOURCE_TYPE | Source Type indicating the source of records |
ST_TRANSACTION_ID | Transaction ID generated during pre-processing to uniquely identify a record in the staging table |
FROM_DATE | Start date |
ERROR_TEXT | If PROCESS_FLAG is equals to 3 for a record then it will describe the reason for the error |
BATCH_ID | Batch Identifier generated during pre-processing |
COMPANY_NAME | Company name |
TO_DATE | End date |
ENABLED_FLAG | Enabled flag |
SR_INSTANCE_ID | Source application instance identifer |
LAST_UPDATE_DATE | Standard Who Column |
LAST_UPDATED_BY | Standard Who Column |
Advanced Supply Chain Planning - MSC_PARTNER_CONTACTS | This table stores the partner contacts. |
---|---|
Column Name | Descritpion |
NAME | Partner's user name |
SR_INSTANCE_ID | Source application instance identifier |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
REQUEST_ID | Concurrent Who column |
PROGRAM_APPLICATION_ID | Concurrent Who column |
PROGRAM_ID | Concurrent Who column |
PROGRAM_UPDATE_DATE | Concurrent Who column |
DISPLAY_NAME | Partner's display name |
PARTNER_ID | Partner Identifier |
PARTNER_SITE_ID | Partner site identifier |
PARTNER_TYPE | Indicate type of partner, supplier, customer, or buyer |
Partner's email address | |
FAX | Partner's FAX number |
ENABLED_FLAG | Flag indicating contact is enabled |
REFRESH_NUMBER | Refresh number populated by the collection program |
Advanced Supply Chain Planning - MSC_PLAN_ORG_KPIS | Maintains the key performance indicators and thresholds for plans created on Oracle Supply Chain Hub. |
---|---|
Column Name | Descritpion |
ORGANIZATION_ID | Stores the owning organization of the plan |
SR_INSTANCE_ID | Contains the source instance identifier, currently defaulted to -1 |
KPI_ID | Contains the code of the key performance indicator or threshold |
KPI_VALUE | Contains the KPI or threshold value depending on the KPI_ID |
PLAN_ID | Contains the plan identifier |
Advanced Supply Chain Planning - MSC_PLAN_ORG_STATUSES | |
---|---|
Column Name | Descritpion |
ORGANIZATION_ID | |
SR_INSTANCE_ID | |
STATUS | |
STATUS_DATE | |
PLAN_ID |
Advanced Supply Chain Planning - MSC_SORT_DATA | This table describes the sorted details used by the Find window. |
---|---|
Column Name | Descritpion |
FOLDER_ID | Folder identifier |
CREATED_BY | Standard Who Column |
CREATION_DATE | Standard Who Column |
LAST_UPDATED_BY | Standard Who Column |
LAST_UPDATE_DATE | Standard Who Column |
LAST_UPDATE_LOGIN | Standard Who Column |
FOLDER_OBJECT | Folder object |
FIELD_NAME1 | First field name |
ORDERBY1 | Orderby1 |
FIELD_NAME2 | Second field name |
ORDERBY2 | Orderby2 |
FIELD_NAME3 | Field Name3 |
ORDERBY3 | Orderby3 |
Advanced Supply Chain Planning - MSC_REGIONS_TEMP | This table temporarily contains geographical regions data needed during an ATP request. |
---|---|
Column Name | Descritpion |
PARTNER_SITE_ID | Partner Site Id |
REGION_ID | Region Id |
REGION_TYPE | (0) Country, (1) State, (2) City, (3) Zipcode |
ZONE_FLAG | (Y) Region zone, (N) Region |
SESSION_ID | Session Id |
Advanced Supply Chain Planning - MSC_ST_ITEM_SOURCING | This is a denormalized table for staging Sourcing Rules related data from Legacy Instances. The data in this table would be processed by the 'Pre-Processor' and sent to MSC_ST_ASSIGNMENT_SETS, MSC_ST_SR_ASSIGNMENTS, MSC_ST_SOURCING_RULES, M |
---|---|
Column Name | Descritpion |
SR_RECEIPT_ID | Receipt Id |
ALLOCATION_PERCENT | Percent of supply allocated to this source |
RANK | Rank of source |
SOURCE_TYPE | Type of source. Possible values 1- Transfer from, 2- Make it, 3- Buy From |
DESCRIPTION | sourcing/assignment description |
PLANNING_ACTIVE | Flag indicates whether the row is planning active. Possible values 1- Yes and 2-No |
SHIP_METHOD | Ship method |
ASSIGNMENT_TYPE | Assignment Set Type. Possible values 1- Global, 2- Category, 3- Item, 4- Organization, 5- Category-Org, 6- Item_Org |
ITEM_NAME | Item name |
CATEGORY_NAME | Category name |
ORGANIZATION_CODE | Organization code |
SR_INSTANCE_CODE | Source instance code |
REFRESH_ID | Refresh Id |
RECEIPT_ORGANIZATION_CODE | Receipt Organization Code |
RECEIPT_ORG_INSTANCE_CODE | Receipt Organization Instance Code |
SOURCE_ORGANIZATION_CODE | Source Organization Code |
SOURCE_ORG_INSTANCE_CODE | Source Organization Instance Code |
SOURCE_PARTNER_NAME | Source Partner Name |
SOURCE_PARTNER_SITE_CODE | Source Partner Site Code |
SOURCING_RULE_NAME | Sourcing Rule Name |
ASSIGNMENT_SET_NAME | Assignment Set Name |
DELETED_FLAG | Deleted Flag |
MESSAGE_ID | This is a foreign key reference to ECX_DOCLOGS.INTERNAL_CONTROL_NUMBER for records got via XMLl |
ASSIGNMENT_ID | Assignment Id |
ERROR_TEXT | If PROCESS_FLAG is equal to 3 for a record, then this will describe the reason for the error |
PROCESS_FLAG | Processing Flag indicating the status of records during pre-processing. 1- New Record, 2- In-Process, 3- Error, 4- Propagated Error, 5- Successfully Processed |
BATCH_ID | Batch identifier generated during pre-processing. |
DATA_SOURCE_TYPE | Source Type indicating the source of the records |
ST_TRANSACTION_ID | Transaction ID generated during pre-processing to uniquely identify a record in the staging table |
LAST_UPDATED_BY | Standard WHO Column |
LAST_UPDATE_DATE | Standard WHO Column |
CREATED_BY | Standard WHO Column |
SOURCING_RULE_ID | Sourcing Rule Id |
CREATION_DATE | Standard WHO Column |
LAST_UPDATE_LOGIN | Standard WHO Column |
REQUEST_ID | Concurrent WHO column |
PROGRAM_APPLICATION_ID | Concurrent WHO column |
PROGRAM_ID | Concurrent WHO column |
PROGRAM_UPDATE_DATE | Concurrent WHO column |
COMPANY_NAME | Company Name |
COMPANY_ID | Company Id |
ASSIGNMENT_SET_ID | Assignment Set Id |
CATEGORY_ID | Category Id |
CATEGORY_SET_ID | Category Set Id |
INVENTORY_ITEM_ID | Inventory Item Id |
SR_SOURCE_ID | Source Id |
ORGANIZATION_ID | Organization ID |
SR_INSTANCE_ID | Instance ID |
RECEIPT_ORGANIZATION_ID | Receipt Organization Id |
RECEIPT_ORG_INSTANCE_ID | Receipt Organization Instance |
EFFECTIVE_DATE | Effectivity date |
DISABLE_DATE | Disable date |
SOURCE_ORGANIZATION_ID | Source Organization Id |
SOURCE_ORG_INSTANCE_ID | Source organization instance identifier |
SOURCE_PARTNER_ID | Source Partner Id |
SOURCE_PARTNER_SITE_ID | Source Partner Site identifier |
Advanced Supply Chain Planning - MSC_ST_CALENDAR_EXCEPTIONS | This is an interface table for staging exception dates for calendar from Legacy Instances. The 'Pre-Processor' would then validate the data in this table and insert into MSC_CALENDAR_EXCEPTIONS. |
---|---|
Column Name | Descritpion |
DATA_SOURCE_TYPE | Source Type indicating source of data |
ST_TRANSACTION_ID | Transaction ID generated during pre-processing to uniquely identify a record in the staging table |
EXCEPTION_DATE | Should be within the calendar start date and end date |
ERROR_TEXT | If PROCESS_FLAG is equal to 3 for a record, then this will describe the reason for the error |
COMPANY_NAME | Party Name with which the Company is registered |
COMPANY_ID | Company Identifier |
EXCEPTION_TYPE | Exception Type Possible values 1 - On 2- Off |
SR_INSTANCE_ID | Source Instance ID |
DELETED_FLAG | Deleted Flag |
LAST_UPDATE_DATE | Standard WHO column |
LAST_UPDATED_BY | Standard WHO column |
CREATION_DATE | Standard WHO column |
CREATED_BY | Standard WHO column |
LAST_UPDATE_LOGIN | Standard WHO column |
REQUEST_ID | Concurrent WHO column |
CALENDAR_CODE | Workday calendar Identifier |
PROGRAM_APPLICATION_ID | Concurrent WHO column |
PROGRAM_ID | Concurrent WHO column |
PROGRAM_UPDATE_DATE | Concurrent WHO column |
REFRESH_ID | Refresh Id |
EXCEPTION_SET_ID | Exception Set Id |
SR_INSTANCE_CODE | Source instance code |
MESSAGE_ID | This is a foreign key reference to ECX_DOCLOGS.INTERNAL_CONTROL_NUMBER for records got via XML |
PROCESS_FLAG | Processing Flag indicating the status of records during pre-processing. 1- New Record, 2- In-Process, 3- Error, 4- Propagated Error, 5- Successfully Processed |
Advanced Supply Chain Planning - MSC_ST_CALENDARS | This is an interface table for staging definition of workday calendars from Legacy Instances. The 'Pre-Processor' would then validate the data in this table and insert into MSC_CALENDARS.You can follow any of the four following type of quar |
---|---|
Column Name | Descritpion |
DESCRIPTION | Description |
PROGRAM_UPDATE_DATE | Concurrent WHO column |
REFRESH_ID | Refresh Id |
MESSAGE_ID | This is a foreign key reference to ECX_DOCLOGS.INTERNAL_CONTROL_NUMBER for records got via XML |
PROCESS_FLAG | Processing Flag indicating the status of records during pre-processing. 1- New Record, 2- In-Process, 3- Error, 4- Propagated Error, 5- Successfully Processed |
DATA_SOURCE_TYPE | Data Source Type |
ST_TRANSACTION_ID | Transaction ID generated during pre-processing to uniquely identify a record in the staging table |
ERROR_TEXT | If PROCESS_FLAG is equal to 3 for a record, then this will describe the reason for the error |
OVERWRITE_FLAG | This is used by the pre-processor during the batch load to determine whether an existing calendar needs to be rebuilt. Possible values for this field are 'Y' and 'N'. If this flag is 'Y' and the calendar does not exist in the planning syste |
WEEK_START_DAY | Start day of the week, possible values are 1- Monday, 2- First day of the calendar |
DAYS_ON | Number of consecutive working Days |
COMPANY_NAME | Party name with which the company is registered |
COMPANY_ID | Company Id |
DAYS_OFF | Number of consecutive non-working days |
CALENDAR_START_DATE | Begining date of the calendar |
CALENDAR_END_DATE | End date of calendar |
QUARTERLY_CALENDAR_TYPE | Quarterely calendar type code. Possible Values:1. 4-4-5 : quarterly pattern having two 4 weeks followedby a 5 week period2. 5-4-4 : one 5 week followed by two 4 week periods3. 13 periods : for calendar year4. regular months of calendar year |
SR_INSTANCE_CODE | Source Instance code |
SR_INSTANCE_ID | Source instance id |
CALENDAR_CODE | Workday calendar identifier |
DELETED_FLAG | Deleted Flag |
LAST_UPDATE_DATE | Standard WHO column |
LAST_UPDATED_BY | Standard WHO column |
CREATION_DATE | Standard WHO column |
CREATED_BY | Standard WHO column |
LAST_UPDATE_LOGIN | Standard WHO column |
REQUEST_ID | Concurrent WHO column |
PROGRAM_APPLICATION_ID | Concurrent WHO column |
PROGRAM_ID | Concurrent WHO column |
Advanced Supply Chain Planning - MSC_REGIONS | This table contains geographical regions data |
---|---|
Column Name | Descritpion |
REGION_ID | Region Id |
ROAD_TERMINAL_FLAG | Road Terminal Flag |
RAIL_TERMINAL_FLAG | Rail Terminal Flag |
LONGITUDE | Longitude |
TIMEZONE | Timezone |
SR_INSTANCE_ID | Source Instance Id |
REFRESH_NUMBER | Refresh Number |
CREATED_BY | Standard Who Column |
CREATION_DATE | Standard Who Column |
LAST_UPDATED_BY | Standard Who Column |
LAST_UPDATE_DATE | Standard Who Column |
REGION_TYPE | Region Type |
LAST_UPDATE_LOGIN | Standard Who Column |
REQUEST_ID | Concurrent WHO column |
PROGRAM_APPLICATION_ID | Concurrent WHO column |
PROGRAM_ID | Concurrent WHO column |
PROGRAM_UPDATE_DATE | Concurrent WHO column |
LATITUDE | Latitude |
CONTINENT | Continent |
COUNTRY | Country |
COUNTRY_REGION | Country Region |
STATE | State |
PARENT_REGION_ID | Parent Region Id |
CITY | City |
ZONE | Zone |
ZONE_LEVEL | Zone Level |
POSTAL_CODE_FROM | Postal Code From |
POSTAL_CODE_TO | Postal Code To |
ALTERNATE_NAME | Alternate Name |
COUNTY | County |
ZONE_USAGE | |
SR_INSTANCE_CODE | |
DELETED_FLAG | |
COUNTRY_CODE | Country Code |
PROCESS_FLAG | |
DATA_SOURCE_TYPE | |
ST_TRANSACTION_ID | |
ERROR_TEXT | |
BATCH_ID | |
MESSAGE_ID | |
COMPANY_NAME | |
COUNTRY_REGION_CODE | Country Region Code |
STATE_CODE | State Code |
CITY_CODE | City Code |
PORT_FLAG | Port Flag |
AIRPORT_FLAG | Airport Flag |
Advanced Supply Chain Planning - MSC_REGION_LOCATIONS | Stores mapping of locations to regions. This includes separate records for the most specific region mapped as well as records for its parents. |
---|---|
Column Name | Descritpion |
REGION_ID | Region Indentifier. Foreign key to WSH_REGIONS.REGION_ID |
PARENT_REGION_FLAG | Flag to indicate whether the region is a parent region. |
EXCEPTION_TYPE | Indicates whether an exception occurred during mapping process. |
SR_INSTANCE_ID | Source Instance Id |
REFRESH_NUMBER | Refresh Number |
SR_INSTANCE_CODE | |
DELETED_FLAG | |
PROCESS_FLAG | |
DATA_SOURCE_TYPE | |
ST_TRANSACTION_ID | |
ERROR_TEXT | |
LOCATION_ID | Location Identifier. Foreign key to either HR_LOCATIONS.LOCATION_ID OR HZ_LOCATIONS.LOCATION_ID |
BATCH_ID | |
MESSAGE_ID | |
COMPANY_NAME | |
LOCATION_CODE | |
COUNTRY | |
COUNTRY_CODE | |
STATE | |
STATE_CODE | |
CITY | |
CITY_CODE | |
LOCATION_SOURCE | |
POSTAL_CODE_FROM | |
REQUEST_ID | |
PROGRAM_APPLICATION_ID | |
PROGRAM_ID | |
PROGRAM_UPDATE_DATE | |
POSTAL_CODE_TO | |
REGION_TYPE | Region level Identifier (0 - Country, 1 - State, 2 - City ,3 - Postal Code) |
LAST_UPDATE_DATE | Standard Who Column |
LAST_UPDATE_LOGIN | Standard Who Column |
LAST_UPDATED_BY | Standard Who Column |
CREATION_DATE | Standard Who Column |
CREATED_BY | Standard Who Column |
Advanced Supply Chain Planning - MSC_ST_GROUP_COMPANIES | The staging table used by the collection program to validate and process data for table MSC_GROUP_COMPANIES |
---|---|
Column Name | Descritpion |
GROUP_NAME | Name of the group. |
LAST_UPDATE_DATE | Standard Who column. |
LAST_UPDATED_BY | Standard Who column. |
LAST_UPDATE_LOGIN | Standard Who column. |
CONTEXT | Descriptive flexfield structure defining column. |
ATTRIBUTE1 | Descriptive flexfield segment. |
ATTRIBUTE2 | Descriptive flexfield segment. |
ATTRIBUTE3 | Descriptive flexfield segment. |
ATTRIBUTE4 | Descriptive flexfield segment. |
ATTRIBUTE5 | Descriptive flexfield segment. |
ATTRIBUTE6 | Descriptive flexfield segment. |
COMPANY_NAME | Name of the company that is member of the group. |
ATTRIBUTE7 | Descriptive flexfield segment. |
ATTRIBUTE8 | Descriptive flexfield segment. |
ATTRIBUTE9 | Descriptive flexfield segment. |
ATTRIBUTE10 | Descriptive flexfield segment. |
ATTRIBUTE11 | Descriptive flexfield segment. |
ATTRIBUTE12 | Descriptive flexfield segment. |
ATTRIBUTE13 | Descriptive flexfield segment. |
ATTRIBUTE14 | Descriptive flexfield segment. |
ATTRIBUTE15 | Descriptive flexfield segment. |
SR_INSTANCE_CODE | Source instance code |
COMPANY_ID | Identifier of the company that is member of the group. |
SR_INSTANCE_ID | Source application instance identifier. |
BATCH_ID | Batch identifier generated during pre-processing. |
REQUEST_ID | Concurrent Who column. |
PROCESS_FLAG | Processing Flag indicating the status of records during pre-processing. 1- New Record, 2- In-Process, 3- Error,4-Propagated Error,5-Sucessfully Processed. |
ERROR_TEXT | If PROCESS_FLAG is equal to 3 for a record, then this will describe the reason for the error. |
DELETED_FLAG | Yes/No flag indicates whether corresponding record in ODS will be deleted. |
MESSAGE_ID | This is a foreign key reference to ECX_DOCLOGS.INTERNAL_CONTROL_NUMBER for records got via XML. |
DATA_SOURCE_TYPE | Source Type indicating the source of the records. |
ST_TRANSACTION_ID | Transaction ID generated during pre-processing to uniquely identify a record in the staging table. |
POSTING_PARTY_ID | Identifier of the company whose employee has loaded the data. |
EFFECTIVE_DATE | The date the membership becomes effective. |
PROGRAM_APPLICATION_ID | Concurrent Who column. |
PROGRAM_ID | Concurrent Who column. |
PROGRAM_UPDATE_DATE | Concurrent Who column. |
GROUP_ID | Unique identifier for the group. |
DISABLE_DATE | The date the membership expires. |
CONTACT_USER_NAME | Name of the user that is the member's contact person for the group. |
CONTACT_USER_ID | Identifier of the user that is the member's contact person for the group. |
CREATION_DATE | Standard Who column. |
CREATED_BY | Standard Who column. |
Advanced Supply Chain Planning - MSC_ST_GROUPS | The staging table used by the collection program to validate and process data for table MSC_GROUPS |
---|---|
Column Name | Descritpion |
GROUP_NAME | Name of the group. |
ATTRIBUTE1 | Descriptive flexfield segment. |
ATTRIBUTE2 | Descriptive flexfield segment. |
ATTRIBUTE3 | Descriptive flexfield segment. |
ATTRIBUTE4 | Descriptive flexfield segment. |
ATTRIBUTE5 | Descriptive flexfield segment. |
DESCRIPTION | Textual description of the group. |
ATTRIBUTE6 | Descriptive flexfield segment. |
ATTRIBUTE7 | Descriptive flexfield segment. |
ATTRIBUTE8 | Descriptive flexfield segment. |
ATTRIBUTE9 | Descriptive flexfield segment. |
ATTRIBUTE10 | Descriptive flexfield segment. |
GROUP_TYPE | Flag to specify the type of the group, 1 = Public and 2 = Private. |
ATTRIBUTE11 | Descriptive flexfield segment. |
ATTRIBUTE12 | Descriptive flexfield segment. |
ATTRIBUTE13 | Descriptive flexfield segment. |
ATTRIBUTE14 | Descriptive flexfield segment. |
ATTRIBUTE15 | Descriptive flexfield segment. |
GROUP_OWNER_ID | Identifier of the company that is owner of the group. |
SR_INSTANCE_CODE | Source instance code |
SR_INSTANCE_ID | Source application instance identifier. |
BATCH_ID | Batch identifier generated during pre-processing. |
REQUEST_ID | Concurrent Who column. |
PROCESS_FLAG | Processing Flag indicating the status of records during pre-processing. 1- New Record, 2-In Process,3- Error,4-Propagated Error,5-Sucessfully Processed. |
CONTACT_USER_NAME | Name of the user that is the owner's contact person for the group. |
ERROR_TEXT | If PROCESS_FLAG is equal to 3 for a record, then this will describe the reason for the error |
DELETED_FLAG | Yes/No flag indicates whether corresponding record in ODS will be deleted. |
MESSAGE_ID | This is a foreign key reference to ECX_DOCLOGS.INTERNAL_CONTROL_NUMBER for records got via XML. |
DATA_SOURCE_TYPE | Source Type indicating the source of the records. |
ST_TRANSACTION_ID | Transaction ID generated during pre-processing to uniquely identify a record in the staging table. |
CONTACT_USER_ID | Identifier of the user that is the owner's contact person for the group. |
PROGRAM_APPLICATION_ID | Concurrent Who column. |
PROGRAM_ID | Concurrent Who column. |
PROGRAM_UPDATE_DATE | Concurrent Who column. |
CONTRACT_DOC_URL | URL pointing to contract document of the group. |
EFFECTIVE_DATE | The date the group becomes effective. |
GROUP_ID | Unique identifier for the group. |
DISABLE_DATE | The date the group expires. |
CREATION_DATE | Standard Who column. |
CREATED_BY | Standard Who column. |
LAST_UPDATE_DATE | Standard Who column. |
LAST_UPDATED_BY | Standard Who column. |
LAST_UPDATE_LOGIN | Standard Who column. |
CONTEXT | Descriptive flexfield structure defining column. |
Advanced Supply Chain Planning - MSC_ST_CO_PRODUCTS | This table is used for collecting the CO Product Bill in Legacy Collections |
---|---|
Column Name | Descritpion |
COMPONENT_ID | Component identifier |
ST_TRANSACTION_ID | Transaction ID generated during pre-processing to uniquely identify a record in the staging table. |
BATCH_ID | Batch identifier generated during pre-processing. |
REFRESH_ID | Refresh Id of last collections |
LAST_UPDATED_BY | Standard Who Column |
REQUEST_ID | Standard Who Column |
PROGRAM_APPLICATION_ID | Standard Who Column |
PROGRAM_ID | Standard Who Column |
PROGRAM_UPDATE_DATE | Standard Who Column |
CO_PRODUCT_GROUP_ID | Co Product Group Id |
CO_PRODUCT_NAME | The co -product name for the component |
CO_PRODUCT_ID | Co-product identifier |
SPLIT | The split percentage indicating the percentage of each co-product |
PRIMARY_FLAG | The promary co-product will have value 1, the non-primary co-product will have value 2 |
ORGANIZATION_CODE | Organization Code |
DELETED_FLAG | This flag indicates whether corresponding record in ODS will be deleted or not. 1-Yes 2-No |
SR_INSTANCE_ID | Source application instance identifier |
COMPONENT_NAME | The name of the component for which the co-product is defined |
COMPANY_NAME | Required only for SCE. should provide the party name with which the company is registered on Exchange. |
LAST_UPDATE_LOGIN | Standard Who Column |
LAST_UPDATE_DATE | Standard Who Column |
CREATION_DATE | Standard Who Column |
CREATED_BY | Standard Who Column |
SR_INSTANCE_CODE | Source instance code defined on planning server |
MESSAGE_ID | This is a foreign key reference to ECX_DOCLOGS.INTERNAL_CONTROL_NUMBER for records got via XML |
PROCESS_FLAG | Processing Flag indicating the status of records during pre-processing. 1- New Record, 2-In Process,3- Error,4-Propagated Error,5-Sucessfully Processed. |
ERROR_TEXT | Pre-defined error text generated by the pre-processor |
DATA_SOURCE_TYPE | Source Type indicating the source of the records. |
Advanced Supply Chain Planning - MSC_ST_COMPANY_USERS | Staging table for user company association information. |
---|---|
Column Name | Descritpion |
USER_NAME | User name |
MESSAGE_ID | Message identifier |
PROCESS_FLAG | Process flag |
ERROR_TEXT | Error text |
DATA_SOURCE_TYPE | Data source type |
ST_TRANSACTION_ID | Staging table transaction identifier |
BATCH_ID | Batch identifier |
REFRESH_ID | Refresh identifier |
REQUEST_ID | Concurrent Who column |
LAST_UPDATED_BY | Standard Who column |
COLLECTION_PARAMETER | Collection parameter |
SR_COMPANY_ID | Company identifier from source application instance |
SR_INSTANCE_ID | Source application instance identifier |
PARTNER_TYPE | Partner type |
START_DATE | Start date |
END_DATE | End date |
DESCRIPTION | Description |
EMAIL_ADDRESS | Email address |
FAX | Fax |
COMPANY_NAME | Company name |
LAST_UPDATE_LOGIN | Standard Who column |
LAST_UPDATE_DATE | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
SR_INSTANCE_CODE | Source application instance code |
Advanced Supply Chain Planning - MSC_ST_ITEM_CUSTOMERS | Staging table to hold item customers data. |
---|---|
Column Name | Descritpion |
INVENTORY_ITEM_ID | Inventory item identifier |
LEAD_TIME | Lead time |
UOM_CODE | Unit of measure code |
LIST_PRICE | List price |
PLANNER_CODE | Planner code |
REFRESH_NUMBER | Refresh number populated by the collection program |
PROCESS_FLAG | Process flag |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
SR_INSTANCE_ID | Source application instance identifier |
LAST_UPDATE_LOGIN | Standard Who column |
COMPANY_ID | Company identifier |
REQUEST_ID | Concurrent Who column |
SR_INSTANCE_CODE | Source instance code |
MESSAGE_ID | Message identifier |
ERROR_TEXT | Error text |
DATA_SOURCE_TYPE | Data source type |
DELETED_FLAG | Deleted flag |
COMPANY_NAME | Company name |
PROGRAM_UPDATE_DATE | Concurrent Who column |
PROGRAM_ID | Concurrent Who column |
PROGRAM_APPLICATION_ID | Concurrent Who column |
CUSTOMER_ID | Customer identifier |
BATCH_ID | Batch identifier |
ST_TRANSACTION_ID | Staging table transaction identifier |
REFRESH_ID | Refresh identifier |
CUSTOMER_NAME | Customer name |
CUSTOMER_SITE_ID | Customer site identifier |
CUSTOMER_SITE_NAME | Customer site name |
ITEM_NAME | Item name |
CUSTOMER_ITEM_NAME | Customer item name |
DESCRIPTION | Description |
Advanced Supply Chain Planning - MSC_ST_ITEM_SUBSTITUTES | The staging table used by the collection program to validate and process data for table MSC_DEMANDS. |
---|---|
Column Name | Descritpion |
SR_INSTANCE_ID | Source application instance identifier |
RECIPROCAL_FLAG | Reciprocal Flag |
SUBSTITUTION_SET | Substitution set name used to define Item relationship |
PARTIAL_FULFILLMENT_FLAG | Partial Fulfillment Flag |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
SUBSTITUTE_ITEM_NAME | Substitute Item Name |
ITEM_NAME | Item Name |
LOWER_ITEM_ID | Inventory item identifier |
CUSTOMER_NAME | Customer Name |
CUSTOMER_SITE_CODE | Customer Site Code |
SR_INSTANCE_CODE | Sr Instance Code |
MESSAGE_ID | Message Id |
PROCESS_FLAG | Process Flag |
DATA_SOURCE_TYPE | Data Source Type |
ST_TRANSACTION_ID | Sr Transaction Id |
ERROR_TEXT | Error TExt |
BATCH_ID | Batch Id |
DELETED_FLAG | Deleted Flag |
HIGHER_ITEM_ID | Inventory item identifier |
COMPANY_NAME | Company Name |
REQUEST_ID | request Id |
PROGRAM_APPLICATION_ID | program application id |
PROGRAM_ID | program id |
PROGRAM_UPDATE_DATE | program update date |
ORGANIZATION_ID | |
REFRESH_ID | |
ORGANIZATION_CODE | |
HIGHEST_ITEM_ID | Highest Item Id |
CUSTOMER_ID | Partner identifier |
CUSTOMER_SITE_ID | Partner Site identifier |
EFFECTIVE_DATE | Effective date of Item relationship |
DISABLE_DATE | Disable date of Item relationship |
RELATIONSHIP_TYPE | Type of Item relationship |
Advanced Supply Chain Planning - MSC_NET_CHANGE_CRITERIA | This table stores the criteria used in Plan Comparison Reports. |
---|---|
Column Name | Descritpion |
CRITERIA_ID | criteira identifier |
OPTIONS_FLAG | to calculate plan options or not |
LAST_UPDATE_DATE | Standard Who Column |
LAST_UPDATED_BY | Standard Who Column |
CREATION_DATE | Standard Who Column |
CREATED_BY | Standard Who Column |
LAST_UPDATE_LOGIN | Standard Who Column |
CRITERIA_NAME | criteria name |
USER_ID | the user who created this criteria |
PUBLIC_FLAG | Is this criteria available to the other users? |
AUTO_QUERY_FLAG | auto query flag |
EXCEPTION_GROUP | exception group |
EXCEPTION_TYPE | exception type |
ALL_EXCEPTIONS | display all exceptions or not |
GROUP_BY_ID | group by id, not used yet |
Advanced Supply Chain Planning - MSC_NEC_EXC_DTL_COMPARE | This table is a working table for Plan Comparison Reports. |
---|---|
Column Name | Descritpion |
REPORT_ID | report identifier |
MATCH_ID | pair up the exceptions which are compared |
CHAR1 | Generic Char Column |
CHAR2 | Generic Char Column |
LAST_UPDATE_DATE | Standard Who Column |
LAST_UPDATED_BY | Standard Who Column |
CREATION_DATE | Standard Who Column |
CREATED_BY | Standard Who Column |
LAST_UPDATE_LOGIN | Standard Who Column |
STATUS | report status |
EXCEPTION_DETAIL_ID | map to exception_detail_id in msc_exception_details table |
PLAN_ID | plan identifier |
EXCEPTION_TYPE | exception type |
EXCEPTION_GROUP | exception group |
FROM_PLAN | indicate if this is from plan or to plan |
ID_KEY | exception identifier |
COMPARE_KEY | field to distinquish if the exceptions are the same or changed |
Advanced Supply Chain Planning - MSC_NEC_COMPARE_PLANS | This table store the the status of the plan which has launched the "Compare Plan Exceptions" concurrent program. |
---|---|
Column Name | Descritpion |
REPORT_ID | report identifier |
LAST_UPDATE_LOGIN | Standard Who Column |
FROM_PLAN | plan identifier for form plan |
TO_PLAN | plan identifier for to plan |
COMPARE_START_DATE | The start time when the report is launched |
COMPARE_COMPLETION_DATE | the end time when the report is done |
LAST_UPDATE_DATE | Standard Who Column |
LAST_UPDATED_BY | Standard Who Column |
CREATION_DATE | Standard Who Column |
CREATED_BY | Standard Who Column |
Advanced Supply Chain Planning - MSC_RELATED_EXCEPTIONS | This table is for storing related exceptions to a custom exceptions. This table is not used presently. |
---|---|
Column Name | Descritpion |
RELATION_ID | System defined sequence |
CREATED_BY | Standard who column |
LAST_UPDATE_LOGIN | Standard who column |
ATTRIBUTE1 | Descriptive Flexfield Column |
ATTRIBUTE2 | Descriptive Flexfield Column |
ATTRIBUTE3 | Descriptive Flexfield Column |
ATTRIBUTE4 | Descriptive Flexfield Column |
ATTRIBUTE5 | Descriptive Flexfield Column |
ATTRIBUTE6 | Descriptive Flexfield Column |
ATTRIBUTE7 | Descriptive Flexfield Column |
ATTRIBUTE8 | Descriptive Flexfield Column |
EXCEPTION_ID | Custom exception Id |
ATTRIBUTE9 | Descriptive Flexfield Column |
ATTRIBUTE10 | Descriptive Flexfield Column |
ATTRIBUTE11 | Descriptive Flexfield Column |
ATTRIBUTE12 | Descriptive Flexfield Column |
ATTRIBUTE13 | Descriptive Flexfield Column |
ATTRIBUTE14 | Descriptive Flexfield Column |
ATTRIBUTE15 | Descriptive Flexfield Column |
CONTEXT | Context for descriptive flexfield |
LINK_TYPE | Type of link. This specify whether it is a url or custom exception |
RELATED_EXCEPTION_ID | Related custom exception id |
URLNAME | Name of the url |
URL | Url details |
LAST_UPDATE_DATE | Standard who column |
LAST_UPDATED_BY | Standard who column |
CREATION_DATE | Standard who column |
Advanced Supply Chain Planning - MSC_QUERY | Table used to pass data across sessions. |
---|---|
Column Name | Descritpion |
QUERY_ID | Query identifier |
DATE4 | Generic date column |
DATE5 | Generic date column |
DATE6 | Generic date column |
DATE7 | Generic date column |
DATE8 | Generic date column |
NUMBER1 | Generic number column |
NUMBER2 | Generic number column |
NUMBER3 | Generic number column |
NUMBER4 | Generic number column |
NUMBER5 | Generic number column |
LAST_UPDATE_DATE | Standard Who column |
NUMBER6 | Generic number column |
NUMBER7 | Generic number column |
NUMBER8 | Generic number column |
NUMBER9 | Generic number column |
NUMBER10 | Generic number column |
NUMBER11 | Generic number column |
NUMBER12 | Generic number column |
NUMBER13 | Generic number column |
NUMBER14 | Generic number column |
NUMBER15 | Generic number column |
LAST_UPDATED_BY | Standard Who column |
REQUEST_ID | Concurrent Who column |
CHAR1 | Generic character column |
CHAR2 | Generic character column |
CHAR3 | Generic character column |
CHAR4 | Generic character column |
CHAR5 | Generic character column |
CHAR6 | Generic character column |
CHAR7 | Generic character column |
CHAR8 | Generic character column |
CHAR9 | Generic character column |
CREATION_DATE | Standard Who column |
PROGRAM_UPDATE_DATE | Concurrent Who column |
PROGRAM_APPLICATION_ID | Concurrent Who column |
PROGRAM_ID | Concurrent Who column |
NUMBER16 | Generic number column |
CHAR10 | Generic character column |
CHAR11 | Generic character column |
CHAR12 | Generic character column |
CHAR13 | Generic character column |
CHAR14 | Generic character column |
CHAR15 | Generic character column |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
DATE1 | Generic date column |
DATE2 | Generic date column |
DATE3 | Generic date column |
Advanced Supply Chain Planning - MSC_SERIAL_NUMBERS | This table stores unit level details for an onhand item. |
---|---|
Column Name | Descritpion |
LAST_UPDATE_DATE | Standard Who column. |
LAST_UPDATED_BY | Standard Who column. |
SERIAL_NUMBER | Serial number of the unit. |
LAST_UPDATE_LOGIN | Standard Who column. |
CONTEXT | Descriptive flexfield structure defining column. |
ATTRIBUTE1 | Descriptive flexfield segment. |
ATTRIBUTE2 | Descriptive flexfield segment. |
ATTRIBUTE3 | Descriptive flexfield segment. |
ATTRIBUTE4 | Descriptive flexfield segment. |
ATTRIBUTE5 | Descriptive flexfield segment. |
ATTRIBUTE6 | Descriptive flexfield segment. |
ATTRIBUTE7 | Descriptive flexfield segment. |
ATTRIBUTE8 | Descriptive flexfield segment. |
ATTRIBUTE9 | Descriptive flexfield segment. |
ATTRIBUTE10 | Descriptive flexfield segment. |
DISABLE_DATE | The date the unit's details were deleted. |
ATTRIBUTE11 | Descriptive flexfield segment. |
ATTRIBUTE12 | Descriptive flexfield segment. |
ATTRIBUTE13 | Descriptive flexfield segment. |
ATTRIBUTE14 | Descriptive flexfield segment. |
ATTRIBUTE15 | Descriptive flexfield segment. |
PLAN_ID | Plan identifier. |
ATTACHMENT_URL | URL pointing to attachment. |
USER_DEFINED1 | Generic user defined field. |
USER_DEFINED2 | Generic user defined field. |
USER_DEFINED3 | Generic user defined field. |
USER_DEFINED4 | Generic user defined field. |
USER_DEFINED5 | Generic user defined field. |
USER_DEFINED6 | Generic user defined field. |
SERIAL_TXN_ID | Transaction identifier for the onhand. |
USER_DEFINED7 | Generic user defined field. |
USER_DEFINED8 | Generic user defined field. |
USER_DEFINED9 | Generic user defined field. |
USER_DEFINED10 | Generic user defined field. |
LINE_ID | Contains the line identifier. |
PARENT_HEADER_ID | Contains the header id to which the line is associated - generated through sequence MSC_SUPDEM_HEADERS_S. |
CREATION_DATE | Standard Who column. |
CREATED_BY | Standard Who column. |
Advanced Supply Chain Planning - MSC_PLAN_ORG_STATUS | Maintains the history of statuses of collaborating organizations in a plan. |
---|---|
Column Name | Descritpion |
ORGANIZATION_ID | Contains the party identifier |
SR_INSTANCE_ID | Contains the source instance identifier, currently defaulted to -1 |
STATUS | Contains the status code of the organization in the plan |
STATUS_DATE | Contains the date the record was inserted. |
PLAN_ID | Contains the plan identifier |
Advanced Supply Chain Planning - MSC_OPERATION_NETWORKS | This table is a child table of msc_operations. Describes the network structure of operations of a network routing. |
---|---|
Column Name | Descritpion |
TO_OP_SEQ_ID | To routing operation identifier |
ATTRIBUTE9 | Descriptive flexfield segment |
ATTRIBUTE10 | Descriptive flexfield segment |
ATTRIBUTE11 | Descriptive flexfield segment |
ATTRIBUTE12 | Descriptive flexfield segment |
ATTRIBUTE13 | Descriptive flexfield segment |
ATTRIBUTE14 | Descriptive flexfield segment |
ATTRIBUTE15 | Descriptive flexfield segment |
ORIGINAL_SYSTEM_REFERENCE | Descriptive flexfield segment |
ROUTING_SEQUENCE_ID | Standard Who column |
FROM_OP_SEQ_NUM | From Routing operation sequence number |
TO_OP_SEQ_NUM | To Routing operation sequence number |
TRANSITION_TYPE | Primary, Alternate or Rework connection |
REFRESH_NUMBER | From routing operation identifier |
PLANNING_PCT | Planning Percentage |
CUMMULATIVE_PCT | Cumulative Percentage |
EFFECTIVITY_DATE | Effective Date |
DISABLE_DATE | Disable Date |
PLAN_ID | To routing operation identifier |
CREATED_BY | Standard Who column |
SR_INSTANCE_ID | To routing operation identifier |
CREATION_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
FROM_OP_SEQ_ID | From routing operation identifier |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
ATTRIBUTE_CATEGORY | Descriptive flexfield structure defining column |
ATTRIBUTE1 | Descriptive flexfield segment |
ATTRIBUTE2 | Descriptive flexfield segment |
ATTRIBUTE3 | Descriptive flexfield segment |
ATTRIBUTE4 | Descriptive flexfield segment |
ATTRIBUTE5 | Descriptive flexfield segment |
ATTRIBUTE6 | Descriptive flexfield segment |
ATTRIBUTE7 | Descriptive flexfield segment |
ATTRIBUTE8 | Descriptive flexfield segment |
Advanced Supply Chain Planning - MSC_SQLLOAD_PARAMETERS | This table stores sql load parameters like table name, bindsize, number of rows etc. |
---|---|
Column Name | Descritpion |
TABLE_NAME | This column stores the table name used by the sql loader. |
BINDSIZE | This column stores the bindsize used by the sql loader. |
NUMBER_OF_ROWS | This column stores the number of rows to be loaded by the sql loader. |
LAST_UPDATE_DATE | Standard Who Column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who Column |
CREATED_BY | Standard Who Column |
LAST_UPDATE_LOGIN | Standard Who Column |
Advanced Supply Chain Planning - MSC_PURCHASE_ORDER_INTERFACE | This table stores the Purchase Order information to be rescheduled in the Source instance. |
---|---|
Column Name | Descritpion |
BATCH_ID | Batch Identifier generated during pre-processing |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
SR_INSTANCE_ID | Source application instance identifier |
OLD_NEED_BY_DATE | old need by date |
NEW_NEED_BY_DATE | new need by date |
PO_HEADER_ID | Purchase Header ID |
PO_LINE_ID | Purchase Line ID |
PO_NUMBER | Purchase Order Number |
PO_QUANTITY | Quantity Ordered |
LAST_UPDATE_DATE | Standard Who column |
Advanced Supply Chain Planning - MSC_PROFILES | |
---|---|
Column Name | Descritpion |
LEVEL_TYPE | |
LEVEL_NAME | |
PROFILE_OPTION_NAME | |
PROFILE_OPTION_VALUE | |
APPLICATION_NAME | |
LAST_UPDATE_DATE | |
LAST_UPDATED_BY | |
CREATION_DATE | |
PREFERENCE_SET_NAME | |
CREATED_BY | |
LAST_UPDATE_LOGIN |
Advanced Supply Chain Planning - MSC_PDR_PARAMETERS | Store the parameters user entered in the Planning Detailed Reports |
---|---|
Column Name | Descritpion |
USER_ID | user identifier |
PLANNER_CODE_ID | planner identifier |
BUYER_NAME_ID | buyer identifier |
SUPPLIER_ID | supplier identifier |
PLANNING_GROUP_ID | planning group |
PROJECT_ID | project identifier |
RESOURCE_GROUP_ID | resource group |
DEPT_LINE_ID | department identifer |
RESOURCE_ID | resource identifier |
REPORT_PERIOD_FROM | The start date of the planning detail report period |
REPORT_PERIOD_TO | The end date of the planning detail report period |
PLAN_ID | plan identifier |
REPORT_DATE_REC | parameter type |
PLAN_NAME | plan name |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
ORGANIZATION_ID | org identifier |
SR_INSTANCE_ID | source application instance identifier |
CATEGORY_SET_ID | category set identifier |
PRODUCT_CATEGORY_ID | category identifier |
ABC_CLASS_ID | ABC class identifier |
INVENTORY_ITEM_ID | itemidentifier |
Advanced Supply Chain Planning - MSC_PDR_PARAMETERS_NEW | Store the parameters user entered in the Planning Detailed Reports |
---|---|
Column Name | Descritpion |
PARM_TYPE | parameter type |
CREATED_BY | Standard Who Column |
LAST_UPDATE_LOGIN | Standard Who Column |
NUMBER1 | Generic Number Column |
NUMBER2 | Generic Number Column |
NUMBER3 | Generic Number Column |
NUMBER4 | Generic Number Column |
NUMBER5 | Generic Number Column |
NUMBER6 | Generic Number Column |
VCHAR1 | Generic Char Column |
USER_ID | user identifier |
VCHAR2 | Generic Char Column |
VCHAR3 | Generic Char Column |
VCHAR4 | Generic Char Column |
VCHAR5 | Generic Char Column |
VCHAR6 | Generic Char Column |
VDATE1 | Generic Date Column |
VDATE2 | Generic Date Column |
VDATE3 | Generic Date Column |
LAST_UPDATE_DATE | Standard Who Column |
LAST_UPDATED_BY | Standard Who Column |
CREATION_DATE | Standard Who Column |
Advanced Supply Chain Planning - MSC_OUTBOUND_ENTRIES | Outbound XML transactions from Collaborative Planning |
---|---|
Column Name | Descritpion |
RESPONSE_NUMBER | |
BUCKET_TYPE | |
UOM_CODE | |
DESIGNATOR | |
VERSION | |
COMMENTS | |
SOURCE_LOCATION_CODE | |
EXTERNAL_LOCATION_CODE | |
PUBLISHER_NAME | |
PUBLISHER_SITE_NAME | |
CUSTOMER_NAME | |
CUSTOMER_SITE_NAME | |
SUPPLIER_NAME | |
SUPPLIER_SITE_NAME | |
SHIP_TO_PARTY_NAME | |
DOCUMENT_NUMBER | |
SHIP_TO_PARTY_SITE_NAME | |
SHIP_FROM_PARTY_NAME | |
SHIP_FROM_PARTY_SITE_NAME | |
ITEM_NAME | |
PUBLISHER_ORDER_TYPE | |
REF_HEADER_ID | |
QUANTITY | |
SHIP_DATE | |
RECEIPT_DATE | |
KEY_DATE |
Advanced Supply Chain Planning - MSC_SECURITY_RULES | This table is not used. |
---|---|
Column Name | Descritpion |
GRANTEE_TYPE | Grantee type |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
PROGRAM_ID | Concurrent Who column |
EFFECTIVE_FROM_DATE | Effective from date |
EFFECTIVE_TO_DATE | Effective to date |
ORDER_TYPE_MEANING | Order type meaning |
PRIVILEGE | Privilege |
ORDER_TYPE | Order type |
SR_INSTANCE_ID | Source application instance identifier |
ITEM_ID | Inventory item identifier |
ITEM_NAME | Item name |
CATEGORY_ID | Category identifier |
CATEGORY_NAME | Category name |
RULE_ID | Rule identifier |
CUSTOMER_ID | Customer identifier |
SUPPLIER_ID | Supplier identifier |
CUSTOMER_SITE_ID | Customer site identifier |
SUPPLIER_SITE_ID | Supplier site identifier |
ORG_ID | Organization identifier |
ORDER_NUMBER | Order number |
GRANTEE_KEY | Grantee key |
COMPANY_ID | Company identifier |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
Advanced Supply Chain Planning - MSC_ORG_ACCESS | This table stores the organizations to which a responsibility has access |
---|---|
Column Name | Descritpion |
SR_INSTANCE_ID | source application instance identifier |
RESPONSIBILITY_ID | responsibility identifier |
LAST_UPDATE_DATE | Standard Who column |
RESP_APPLICATION_ID | application identifier |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
EFFECTIVE_FROM_DATE | effectivity start date |
EFFECTIVE_TO_DATE | effectivity end date |
ORGANIZATION_ID | org identifier |
Advanced Supply Chain Planning - MSC_PQ_RESULTS | Stores results of different types of personal queries. |
---|---|
Column Name | Descritpion |
QUERY_ID | |
SUPPLIER_ID | |
RESOURCE_ID | |
SUPPLIER_SITE_ID | |
CATEGORY_ID | |
EXCEPTION_COUNT | |
SOURCE_TYPE | |
CREATED_BY | |
CREATION_DATE | |
LAST_UPDATE_DATE | |
LAST_UPDATED_BY | |
PLAN_ID | |
LAST_UPDATE_LOGIN | |
RESOURCE_TYPE | |
FROM_ORG_ID | |
FROM_ORG_INSTANCE_ID | |
TO_ORG_ID | |
TO_ORG_INSTANCE_ID | |
SHIPMENT_ID | |
CHAR1 | |
CHAR2 | |
CHAR3 | |
ORGANIZATION_ID | |
CHAR4 | |
CHAR5 | |
GROUPBY_ORG | |
GROUPBY_ITEM | |
GROUPBY_SUPPLY_ITEM | |
GROUPBY_CATEGORY | |
GROUPBY_PLANNER | |
GROUPBY_DEPT | |
GROUPBY_RES | |
GROUPBY_CUSTOMER | |
SR_INSTANCE_ID | |
GROUPBY_SUPPLIER | |
SEQUENCE_ID | |
TRANSACTION_ID | |
DETAIL_QUERY_ID | |
CUSTOMER_ID | |
CUSTOMER_SITE_ID | |
PRIORITY | |
GROUPBY_SUPPLIER_SITE | |
GROUPBY_CUSTOMER_SITE | |
PLANNER_CODE | |
SUMMARY_DATA | |
SOURCE_TABLE | |
ORDER_TYPE | |
ROW_ID | |
INVENTORY_ITEM_ID | |
EXCEPTION_TYPE | |
EXCEPTION_ID | |
DEPARTMENT_ID |
Advanced Supply Chain Planning - MSC_SINGLE_LVL_PEG | Single level supply to supply or supply to demand pegging. Currently used for DRP plans |
---|---|
Column Name | Descritpion |
PLAN_ID | |
LAST_UPDATE_LOGIN | |
PARENT_ID | |
CHILD_ID | |
PEGGING_TYPE | |
QUANTITY | |
CREATED_BY | |
CREATION_DATE | |
LAST_UPDATED_BY | |
LAST_UPDATE_DATE |
Advanced Supply Chain Planning - MSC_OE_DATA_TEMP | |
---|---|
Column Name | Descritpion |
SEQ_ID | |
LAST_UPDATE_LOGIN | |
ORDER_LINE_ID | |
OE_FLAG | |
INTERNAL_ORG_ID | |
SESSION_ID | |
CREATION_DATE | |
CREATED_BY | |
LAST_UPDATE_DATE | |
LAST_UPDATED_BY |
Advanced Supply Chain Planning - MSC_NET_RES_INST_AVAIL | |
---|---|
Column Name | Descritpion |
INST_TRANSACTION_ID | |
SERIAL_NUMBER | |
SIMULATION_SET | |
SHIFT_NUM | |
SHIFT_DATE | |
FROM_TIME | |
TO_TIME | |
STATUS | |
APPLIED | |
UPDATED | |
LAST_UPDATE_DATE | |
PLAN_ID | |
LAST_UPDATED_BY | |
CREATION_DATE | |
CREATED_BY | |
LAST_UPDATE_LOGIN | |
REQUEST_ID | |
PROGRAM_APPLICATION_ID | |
PROGRAM_ID | |
PROGRAM_UPDATE_DATE | |
ATTRIBUTE_CATEGORY | |
ATTRIBUTE1 | |
SR_INSTANCE_ID | |
ATTRIBUTE2 | |
ATTRIBUTE3 | |
ATTRIBUTE4 | |
ATTRIBUTE5 | |
ATTRIBUTE6 | |
ATTRIBUTE7 | |
ATTRIBUTE8 | |
ATTRIBUTE9 | |
ATTRIBUTE10 | |
ATTRIBUTE11 | |
ORGANIZATION_ID | |
ATTRIBUTE12 | |
ATTRIBUTE13 | |
ATTRIBUTE14 | |
ATTRIBUTE15 | |
REFRESH_NUMBER | |
CAPACITY_UNITS | |
DEPARTMENT_ID | |
RESOURCE_ID | |
RES_INSTANCE_ID | |
EQUIPMENT_ITEM_ID | |
PARENT_ID |
Advanced Supply Chain Planning - MSC_RESOURCE_INSTANCE_REQS | |
---|---|
Column Name | Descritpion |
RES_INST_TRANSACTION_ID | |
RESOURCE_ID | |
RES_INSTANCE_ID | |
SERIAL_NUMBER | |
EQUIPMENT_ITEM_ID | |
ORGANIZATION_ID | |
CAPACITY_CONSUMED_RATIO | |
START_DATE | |
END_DATE | |
WIP_ENTITY_ID | |
RESOURCE_INSTANCE_HOURS | |
PLAN_ID | |
DAILY_RES_INSTANCE_HOURS | |
BATCH_NUMBER | |
PARENT_SEQ_NUM | |
SETUP_SEQUENCE_NUM | |
LAST_UPDATE_DATE | |
LAST_UPDATED_BY | |
CREATION_DATE | |
CREATED_BY | |
LAST_UPDATE_LOGIN | |
REQUEST_ID | |
SR_INSTANCE_ID | |
PROGRAM_APPLICATION_ID | |
PROGRAM_ID | |
PROGRAM_UPDATE_DATE | |
ATTRIBUTE_CATEGORY | |
ATTRIBUTE1 | |
ATTRIBUTE2 | |
ATTRIBUTE3 | |
ATTRIBUTE4 | |
ATTRIBUTE5 | |
ATTRIBUTE6 | |
SUPPLY_ID | |
ATTRIBUTE7 | |
ATTRIBUTE8 | |
ATTRIBUTE9 | |
ATTRIBUTE10 | |
ATTRIBUTE11 | |
ATTRIBUTE12 | |
ATTRIBUTE13 | |
ATTRIBUTE14 | |
ATTRIBUTE15 | |
REFRESH_NUMBER | |
OPERATION_SEQ_NUM | |
APPLIED | |
CAPACITY_CONSUMED | |
STATUS | |
UPDATED | |
ASSEMBLY_ITEM_ID | |
UNADJUSTED_RESOURCE_HOURS | |
TOUCH_TIME | |
UNBUCKETED_START_DATE | |
UNBUCKETED_END_DATE | |
ROUTING_SEQUENCE_ID | |
RESOURCE_SEQ_NUM | |
DEPARTMENT_ID | |
ORIG_RESOURCE_SEQ_NUM | |
PARENT_ID |
Advanced Supply Chain Planning - MSC_SOURCING_TRANSACTIONS | |
---|---|
Column Name | Descritpion |
INVENTORY_ITEM_ID | |
ORGANIZATION_ID | |
SOURCE_ORG_ID | |
SUPPLIER_ID | |
SUPPLIER_SITE_ID | |
TRANSACTION_DATE | |
TRANSACTION_QTY | |
TRANSACTION_TYPE |
Advanced Supply Chain Planning - MSC_ST_JOB_OPERATIONS | |
---|---|
Column Name | Descritpion |
WIP_ENTITY_ID | |
STANDARD_OPERATION_CODE | |
DEPARTMENT_ID | |
OPERATION_LEAD_TIME_PERCENT | |
MINIMUM_TRANSFER_QUANTITY | |
EFFECTIVITY_DATE | |
DISABLE_DATE | |
OPERATION_TYPE | |
YIELD | |
CUMULATIVE_YIELD | |
REVERSE_CUMULATIVE_YIELD | |
SR_INSTANCE_ID | |
NET_PLANNING_PERCENT | |
LAST_UPDATE_DATE | |
LAST_UPDATED_BY | |
LAST_UPDATE_LOGIN | |
CREATION_DATE | |
CREATED_BY | |
REQUEST_ID | |
PROGRAM_APPLICATION_ID | |
PROGRAM_ID | |
PROGRAM_UPDATE_DATE | |
OPERATION_SEQ_NUM | |
REFRESH_ID | |
DELETED_FLAG | |
COMPANY_NAME | |
SR_INSTANCE_CODE | |
WIP_ENTITY_NAME | |
ORGANIZATION_CODE | |
OPERATION_SEQ_CODE | |
ROUTING_NAME | |
ASSEMBLY_NAME | |
ALTERNATE_ROUTING_DESIGNATOR | |
RECOMMENDED | |
DEPARTMENT_CODE | |
ROUTING_SEQUENCE_ID | |
DATA_SOURCE_TYPE | |
BATCH_ID | |
ST_TRANSACTION_ID | |
MESSAGE_ID | |
PROCESS_FLAG | |
ERROR_TEXT | |
OPERATION_DESC | |
OPERATION_CODE | |
NETWORK_START_END | |
ACTUAL_START_DATE | |
ACTUAL_END_DATE | |
RECO_START_DATE | |
RECO_COMPLETION_DATE | |
OPERATION_SEQUENCE_ID | |
ORGANIZATION_ID |
Advanced Supply Chain Planning - MSC_ST_JOB_OP_RESOURCES | |
---|---|
Column Name | Descritpion |
WIP_ENTITY_ID | |
RESOURCE_ID | |
ASSIGNED_UNITS | |
USAGE_RATE_OR_AMOUNT | |
UOM_CODE | |
BASIS_TYPE | |
SCHEDULE_FLAG | |
RESOURCE_OFFSET_PERCENT | |
SCHEDULE_SEQ_NUM | |
PRINCIPAL_FLAG | |
DEPARTMENT_ID | |
SR_INSTANCE_ID | |
ACTIVITY_GROUP_ID | |
LAST_UPDATE_DATE | |
LAST_UPDATED_BY | |
LAST_UPDATE_LOGIN | |
CREATION_DATE | |
CREATED_BY | |
REQUEST_ID | |
PROGRAM_APPLICATION_ID | |
PROGRAM_ID | |
PROGRAM_UPDATE_DATE | |
OPERATION_SEQ_NUM | |
REFRESH_ID | |
DELETED_FLAG | |
SR_INSTANCE_CODE | |
COMPANY_NAME | |
WIP_ENTITY_NAME | |
ORGANIZATION_CODE | |
OPERATION_SEQ_CODE | |
ROUTING_SEQUENCE_ID | |
DATA_SOURCE_TYPE | |
BATCH_ID | |
RESOURCE_SEQ_NUM | |
ST_TRANSACTION_ID | |
MESSAGE_ID | |
ERROR_TEXT | |
PROCESS_FLAG | |
RESOURCE_SEQ_CODE | |
OPERATION_EFFECTIVITY_DATE | |
DEPARTMENT_CODE | |
ALTERNATE_ROUTING_DESIGNATOR | |
ITEM_NAME | |
ROUTING_NAME | |
ORGANIZATION_ID | |
RESOURCE_CODE | |
SETUP_ID | |
GROUP_SEQUENCE_ID | |
GROUP_SEQUENCE_NUMBER | |
MAXIMUM_ASSIGNED_UNITS | |
BATCH_NUMBER | |
PARENT_SEQ_NUM | |
FIRM_FLAG | |
ALTERNATE_NUM | |
RECOMMENDED | |
RECO_START_DATE | |
RECO_COMPLETION_DATE |
Advanced Supply Chain Planning - MSC_PART_DEMANDS | |
---|---|
Column Name | Descritpion |
DESIGNATOR_TYPE | |
SR_INSTANCE_ID | |
INVENTORY_ITEM_ID | |
QUANTITY | |
ORIGINATION_TYPE | |
DEMAND_TYPE | |
PLAN_ID | |
IMPLEMENT_DATE | |
IMPLEMENT_EARLIEST_DATE | |
IMPLEMENT_FIRM | |
IMPLEMENT_INSTANCE_ID | |
ITEM_TYPE_VALUE | |
IMPLEMENT_ORG_ID | |
IMPLEMENT_SHIP_DATE | |
DISPOSITION_ID | |
FINAL_USE_DATE | |
REQUEST_DATE | |
USING_ASSEMBLY_ITEM_ID | |
ORIG_DEMAND_ID | |
DEMAND_ID | |
ORGANIZATION_ID |
Advanced Supply Chain Planning - MSC_PART_PEGGING | |
---|---|
Column Name | Descritpion |
PEGGING_ID | |
INVENTORY_ITEM_ID | |
ORGANIZATION_ID | |
PLAN_ID | |
PREV_PEGGING_ID | |
END_PEGGING_ID | |
TRANSACTION_ID | |
DISPOSITION_ID | |
DEMAND_ID | |
PROJECT_ID | |
TASK_ID | |
DEMAND_QUANTITY | |
SR_INSTANCE_ID | |
DEMAND_CLASS | |
UPDATED | |
STATUS | |
LAST_UPDATE_DATE | |
LAST_UPDATED_BY | |
CREATION_DATE | |
CREATED_BY | |
LAST_UPDATE_LOGIN | |
REQUEST_ID | |
SUPPLY_QUANTITY | |
PROGRAM_APPLICATION_ID | |
PROGRAM_ID | |
PROGRAM_UPDATE_DATE | |
ATTRIBUTE_CATEGORY | |
ATTRIBUTE1 | |
ATTRIBUTE2 | |
ATTRIBUTE3 | |
ATTRIBUTE4 | |
ATTRIBUTE5 | |
ATTRIBUTE6 | |
ALLOCATED_QUANTITY | |
ATTRIBUTE7 | |
ATTRIBUTE8 | |
ATTRIBUTE9 | |
ATTRIBUTE10 | |
ATTRIBUTE11 | |
ATTRIBUTE12 | |
ATTRIBUTE13 | |
ATTRIBUTE14 | |
ATTRIBUTE15 | |
UNIT_NUMBER | |
END_ITEM_USAGE | |
DEMAND_DATE | |
SUPPLY_DATE | |
SUPPLY_TYPE | |
END_ORIGINATION_TYPE |
Advanced Supply Chain Planning - MSC_PART_SUPPLIES | |
---|---|
Column Name | Descritpion |
INVENTORY_ITEM_ID | |
ITEM_TYPE_VALUE | |
NEW_SCHEDULE_DATE | |
ORIG_TRANSACTION_ID | |
TRANSACTION_ID | |
ORDER_TYPE | |
NEW_ORDER_QUANTITY | |
FIRM_PLANNED_TYPE | |
PLAN_ID | |
IMPLEMENTED_QUANTITY | |
IMPLEMENT_DEMAND_CLASS | |
ORGANIZATION_ID | |
IMPLEMENT_DATE | |
IMPLEMENT_QUANTITY | |
IMPLEMENT_FIRM | |
IMPLEMENT_WIP_CLASS_CODE | |
IMPLEMENT_JOB_NAME | |
IMPLEMENT_DOCK_DATE | |
IMPLEMENT_STATUS_CODE | |
IMPLEMENT_EMPLOYEE_ID | |
IMPLEMENT_UOM_CODE | |
IMPLEMENT_LOCATION_ID | |
SR_INSTANCE_ID | |
IMPLEMENT_SOURCE_ORG_ID | |
IMPLEMENT_SR_INSTANCE_ID | |
IMPLEMENT_SUPPLIER_ID | |
IMPLEMENT_SUPPLIER_SITE_ID | |
IMPLEMENT_AS | |
LOAD_TYPE | |
RELEASE_ERRORS | |
RELEASABLE | |
BATCH_ID | |
NEW_DOCK_DATE | |
SOURCE_SUPPLIER_ID | |
IMPLEMENT_PROJECT_ID | |
IMPLEMENT_UNIT_NUMBER | |
IMPLEMENT_SHIP_DATE | |
IMPLEMENT_SHIP_METHOD | |
SHIP_METHOD | |
SOURCE_SUPPLIER_SITE_ID | |
SOURCE_SR_INSTANCE_ID | |
SOURCE_ORGANIZATION_ID | |
SUPPLIER_ID | |
SUPPLIER_SITE_ID |
Advanced Supply Chain Planning - MSC_RESOURCES_F | |
---|---|
Column Name | Descritpion |
PLAN_ID | |
AVAILABLE_HOURS | |
REQUIRED_HOURS | |
SETUP_TIME_HRS | |
ORDER_QUANTITY | |
RESOURCE_HOURS | |
NO_OF_ORDERS | |
CREATED_BY | |
CREATION_DATE | |
LAST_UPDATE_DATE | |
LAST_UPDATED_BY | |
PLAN_RUN_ID | |
LAST_UPDATE_LOGIN | |
CATEGORY_SET_ID | |
PROGRAM_ID | |
PROGRAM_LOGIN_ID | |
PROGRAM_APPLICATION_ID | |
REQUEST_ID | |
RESOURCE_COST | |
RESOURCE_COST2 | |
AGGR_TYPE | |
RESOURCE_GROUP | |
SR_CATEGORY_ID | |
SR_INSTANCE_ID | |
ORGANIZATION_ID | |
DEPARTMENT_ID | |
OWNING_DEPARTMENT_ID | |
RESOURCE_ID | |
INVENTORY_ITEM_ID | |
ANALYSIS_DATE |
Advanced Supply Chain Planning - MSC_SRP_ITEM_EXCEPTIONS | |
---|---|
Column Name | Descritpion |
PLAN_ID | |
LAST_UPDATE_LOGIN | |
SUPPLIER_ID | |
SUPPLIER_SITE_ID | |
SOURCE_ORG_ID | |
EXIST | |
ACTION_TAKEN_DATE | |
LAST_GENERATED_DATE | |
ORGANIZATION_ID | |
SR_INSTANCE_ID | |
INVENTORY_ITEM_ID | |
EXCEPTION_TYPE | |
LAST_UPDATE_DATE | |
LAST_UPDATED_BY | |
CREATION_DATE | |
CREATED_BY |
Advanced Supply Chain Planning - MSC_RESOURCES_CUM_F | |
---|---|
Column Name | Descritpion |
PLAN_ID | |
RESOURCE_GROUP | |
CUM_NET_RESOURCE_AVAIL | |
CREATED_BY | |
CREATION_DATE | |
LAST_UPDATED_BY | |
LAST_UPDATE_DATE | |
LAST_UPDATE_LOGIN | |
PROGRAM_ID | |
PROGRAM_LOGIN_ID | |
PROGRAM_APPLICATION_ID | |
PLAN_RUN_ID | |
REQUEST_ID | |
SR_INSTANCE_ID | |
ORGANIZATION_ID | |
DEPARTMENT_ID | |
RESOURCE_ID | |
INVENTORY_ITEM_ID | |
ANALYSIS_DATE | |
AGGR_TYPE |
Advanced Supply Chain Planning - MSC_RP_CTB_DONOR_COMPONENTS | |
---|---|
Column Name | Descritpion |
PLAN_ID | |
POTENTIAL_ONHAND_INCREASE | |
TOTAL_COMPONENT_ON_HAND | |
PERCENT_PEGGED_BY_ON_HAND | |
LAST_UPDATE_DATE | |
LAST_UPDATED_BY | |
CREATION_DATE | |
CREATED_BY | |
LAST_UPDATE_LOGIN | |
MAKE_ORDER_TRANSACTION_ID | |
DONOR_ORDER_TRANSACTION_ID | |
INVENTORY_ITEM_ID | |
ORGANIZATION_ID | |
SR_INSTANCE_ID | |
PEGGED_ON_HAND_QUANTITY | |
COMPONENT_QUANTITY | |
PERCENT_OF_ON_HAND |
Advanced Supply Chain Planning - MSC_RP_CTB_ORDER_COMPONENTS | |
---|---|
Column Name | Descritpion |
PLAN_ID | |
PERCENT_OF_ON_HAND | |
MAXIMUM_CTB_PERCENT | |
CTB_PRIORITY | |
LAST_UPDATE_DATE | |
LAST_UPDATED_BY | |
CREATION_DATE | |
CREATED_BY | |
LAST_UPDATE_LOGIN | |
MAKE_ORDER_TRANSACTION_ID | |
INVENTORY_ITEM_ID | |
ORGANIZATION_ID | |
SR_INSTANCE_ID | |
COMPONENT_QUANTITY | |
PEGGED_ON_HAND_QUANTITY | |
TOTAL_COMPONENT_ON_HAND | |
PERCENT_PEGGED_BY_ON_HAND |
Advanced Supply Chain Planning - MSC_RP_KPI | |
---|---|
Column Name | Descritpion |
PLAN_ID | |
RESOURCE_ID | |
DEPARTMENT_ID | |
SUPPLIER_ID | |
SUPPLIER_SITE_ID | |
KPI_TIME | |
KPI_VALUE_NUM1 | |
KPI_VALUE_NUM2 | |
KPI_VALUE_NUM3 | |
KPI_VALUE_NUM4 | |
KPI_VALUE_NUM5 | |
KPI_TYPE_ID | |
KPI_VALUE_NUM6 | |
KPI_VALUE_NUM7 | |
KPI_VALUE_NUM8 | |
LAST_UPDATE_DATE | |
LAST_UPDATED_BY | |
CREATION_DATE | |
CREATED_BY | |
LAST_UPDATE_LOGIN | |
END_ITEM_ID | |
KPI_VALUE | |
ITEM_ID | |
ITEM_CAT_ID | |
ORG_ID | |
INSTANCE_ID | |
CUSTOMER_ID | |
CUSTOMER_SITE_ID |
Advanced Supply Chain Planning - MSC_ST_BUDGETS_F | |
---|---|
Column Name | Descritpion |
ST_TRANSACTION_ID | |
CATEGORY_NAME | |
BUDGET_LEVEL | |
BUDGET_VALUE | |
CREATED_BY | |
CREATION_DATE | |
LAST_UPDATED_BY | |
LAST_UPDATE_DATE | |
LAST_UPDATE_LOGIN | |
PROGRAM_ID | |
PROGRAM_LOGIN_ID | |
ERROR_CODE | |
PROGRAM_APPLICATION_ID | |
REQUEST_ID | |
BUDGET_VALUE2 | |
SR_INSTANCE_ID | |
ORGANIZATION_ID | |
CATEGORY_SET_ID | |
CATEGORY_INSTANCE_ID | |
SR_CATEGORY_ID | |
ORGANIZATION_CODE | |
CATEGORY_INSTANCE_CODE |
Advanced Supply Chain Planning - MSC_ST_COSTS_F | |
---|---|
Column Name | Descritpion |
ST_TRANSACTION_ID | |
CUSTOMER_REGION_ID | |
SUPPLIER_ID | |
SUPPLIER_SITE_ID | |
SUPPLIER_REGION_ID | |
ORGANIZATION_CODE | |
SOURCE_ORG_CODE | |
ITEM_NAME | |
CUSTOMER_NAME | |
CUSTOMER_SITE_CODE | |
CUSTOMER_ZONE | |
ERROR_CODE | |
SUPPLIER_NAME | |
SUPPLIER_SITE_CODE | |
SUPPLIER_ZONE | |
SHIP_METHOD | |
DETAIL_DATE | |
REVENUE | |
REVENUE2 | |
MANUFACTURING_COST | |
MANUFACTURING_COST2 | |
PURCHASING_COST | |
SR_INSTANCE_ID | |
PURCHASING_COST2 | |
TRANSPORTATION_COST | |
TRANSPORTATION_COST2 | |
CARRYING_COST | |
CARRYING_COST2 | |
SUPPLY_CHAIN_COST | |
SUPPLY_CHAIN_COST2 | |
GROSS_MARGIN | |
GROSS_MARGIN2 | |
FIXED_COST | |
ORGANIZATION_ID | |
FIXED_COST2 | |
CREATED_BY | |
CREATION_DATE | |
LAST_UPDATED_BY | |
LAST_UPDATE_DATE | |
LAST_UPDATE_LOGIN | |
PROGRAM_ID | |
PROGRAM_LOGIN_ID | |
PROGRAM_APPLICATION_ID | |
REQUEST_ID | |
SOURCE_ORG_INSTANCE_ID | |
OWNING_INST_ID | |
OWNING_ORG_ID | |
OWNING_ORG_CODE | |
FACILITY_COST | |
FACILITY_COST2 | |
ITEM_TRAVEL_DISTANCE | |
SOURCE_COUNT | |
RISK_ITEM_COUNT | |
CTB_MAKE_ORDER_CNT | |
TOTAL_MAKE_ORDER_CNT | |
SOURCE_ORGANIZATION_ID | |
AVAIL_COMPONENT_QTY | |
TOTAL_COMPONENT_QTY | |
READY_TO_BUILD_QTY | |
TOTAL_BUILD_QTY | |
INVENTORY_ITEM_ID | |
CUSTOMER_ID | |
CUSTOMER_SITE_ID |
Advanced Supply Chain Planning - MSC_ST_DEMANTRA_F | |
---|---|
Column Name | Descritpion |
ST_TRANSACTION_ID | |
REGION_ID | |
ORGANIZATION_CODE | |
OWNING_ORG_CODE | |
ITEM_NAME | |
CUSTOMER_NAME | |
CUSTOMER_SITE_CODE | |
ZONE | |
DEMAND_CLASS | |
START_DATE | |
CONSENSUS_FCST | |
ERROR_CODE | |
CONSENSUS_FCST_VALUE | |
CONSENSUS_FCST_VALUE2 | |
CONSENSUS_FCST_CUM | |
PRIORITY | |
CREATED_BY | |
CREATION_DATE | |
LAST_UPDATED_BY | |
LAST_UPDATE_DATE | |
LAST_UPDATE_LOGIN | |
PROGRAM_ID | |
SR_INSTANCE_ID | |
PROGRAM_LOGIN_ID | |
PROGRAM_APPLICATION_ID | |
REQUEST_ID | |
ATTRIBUTE1 | |
ATTRIBUTE2 | |
ATTRIBUTE3 | |
ATTRIBUTE4 | |
ATTRIBUTE5 | |
ATTRIBUTE6 | |
ATTRIBUTE7 | |
ORGANIZATION_ID | |
ATTRIBUTE8 | |
ATTRIBUTE9 | |
ATTRIBUTE10 | |
OWNING_INST_ID | |
OWNING_ORG_ID | |
INVENTORY_ITEM_ID | |
CUSTOMER_ID | |
CUSTOMER_SITE_ID |
Advanced Supply Chain Planning - MSC_ST_DEMANDS_F | |
---|---|
Column Name | Descritpion |
ST_TRANSACTION_ID | |
CUSTOMER_SITE_ID | |
REGION_ID | |
PROJECT_ID | |
TASK_ID | |
ORGANIZATION_CODE | |
OWNING_ORG_CODE | |
ITEM_NAME | |
ORIGINAL_ITEM_NAME | |
CUSTOMER_NAME | |
CUSTOMER_SITE_CODE | |
ERROR_CODE | |
ZONE | |
SALES_ORDER_PD_VALUE2 | |
PROJECT_NUMBER | |
TASK_NUMBER | |
DEMAND_CLASS | |
ORDER_TYPE | |
PART_CONDITION | |
VMI_FLAG | |
ORDER_DATE | |
DEMAND_QTY | |
QTY_BY_DUE_DATE | |
SR_INSTANCE_ID | |
INDEP_DEMAND_COUNT | |
INDEP_MET_ONTIME_COUNT | |
INDEP_MET_FULL_COUNT | |
INDEP_DEMAND_VALUE | |
INDEP_DEMAND_VALUE2 | |
INDEP_DEMAND_QTY | |
INDEP_BY_DUE_DATE_QTY | |
SALES_ORDER_QTY | |
SALES_ORDER_COUNT | |
SALES_ORDER_METR_COUNT | |
ORGANIZATION_ID | |
SALES_ORDER_META_COUNT | |
FORECAST_QTY | |
LATE_DMD_STF_FACTOR | |
LATE_ORDER_COUNT | |
LATE_ORDER_VALUE | |
LATE_ORDER_VALUE2 | |
QTY_BY_DUE_DATE_VALUE | |
QTY_BY_DUE_DATE_VALUE2 | |
IO_DELIVERED_QTY | |
IO_REQUIRED_QTY | |
OWNING_INST_ID | |
NET_DEMAND | |
CONSTRAINED_FCST | |
CONSTRAINED_FCST_VALUE | |
CONSTRAINED_FCST_VALUE2 | |
SERVICE_LEVEL | |
CREATED_BY | |
CREATION_DATE | |
LAST_UPDATED_BY | |
LAST_UPDATE_DATE | |
LAST_UPDATE_LOGIN | |
OWNING_ORG_ID | |
PROGRAM_ID | |
PROGRAM_LOGIN_ID | |
PROGRAM_APPLICATION_ID | |
REQUEST_ID | |
ITEM_PARENT_DEMAND | |
ITEM_PARENT_DEMAND_VALUE | |
DEMAND_FULFILLMENT_LEAD_TIME | |
ANNUALIZED_COGS | |
SALES_ORDER_RD | |
SALES_ORDER_RD_VALUE | |
INVENTORY_ITEM_ID | |
SALES_ORDER_RD_VALUE2 | |
SALES_ORDER_PD | |
SALES_ORDER_PD_VALUE | |
LATE_ORDER_QTY | |
SALES_ORDER_SD | |
SALES_ORDER_SD_VALUE | |
SALES_ORDER_SD_VALUE2 | |
ORIGINAL_ITEM_ID | |
CUSTOMER_ID |
Advanced Supply Chain Planning - MSC_ST_DEMANDS_CUM_F | |
---|---|
Column Name | Descritpion |
ST_TRANSACTION_ID | |
CUSTOMER_SITE_ID | |
REGION_ID | |
ORGANIZATION_CODE | |
OWNING_ORG_CODE | |
ITEM_NAME | |
ORIGINAL_ITEM_NAME | |
CUSTOMER_NAME | |
CUSTOMER_SITE_CODE | |
ZONE | |
DEMAND_CLASS | |
ERROR_CODE | |
VMI_FLAG | |
ORDER_DATE | |
BACKLOG_QTY | |
CUM_SALES_ORDER_QTY | |
CUM_FORECAST_QTY | |
CUM_QTY_BY_DUE_DATE | |
CUM_QTY_BY_DUE_DATE_VALUE | |
CUM_QTY_BY_DUE_DATE_VALUE2 | |
CUM_CONSTRAINED_FCST | |
CUM_CONSTRAINED_FCST_VALUE | |
SR_INSTANCE_ID | |
CUM_CONSTRAINED_FCST_VALUE2 | |
CREATED_BY | |
CREATION_DATE | |
LAST_UPDATED_BY | |
LAST_UPDATE_DATE | |
LAST_UPDATE_LOGIN | |
PROGRAM_ID | |
PROGRAM_LOGIN_ID | |
PROGRAM_APPLICATION_ID | |
REQUEST_ID | |
ORGANIZATION_ID | |
OWNING_INST_ID | |
OWNING_ORG_ID | |
INVENTORY_ITEM_ID | |
ORIGINAL_ITEM_ID | |
CUSTOMER_ID |
Advanced Supply Chain Planning - MSC_ST_DEMANTRA_ODS_F | |
---|---|
Column Name | Descritpion |
ST_TRANSACTION_ID | |
ITEM_NAME | |
CUSTOMER_NAME | |
CUSTOMER_SITE_CODE | |
ZONE | |
DEMAND_CLASS | |
END_DATE | |
PRODUCTION_HISTORY | |
SALES_FCST | |
SALES_FCST_VALUE | |
SALES_FCST_VALUE2 | |
ERROR_CODE | |
SALES_FCST_CUM | |
MKTG_FCST | |
MKTG_FCST_VALUE | |
MKTG_FCST_VALUE2 | |
MKTG_FCST_CUM | |
BUDGET | |
BUDGET2 | |
BUDGET_CUM | |
BUDGET2_CUM | |
BOOKING_FCST | |
SR_INSTANCE_ID | |
BOOKING_FCST_VALUE | |
BOOKING_FCST_VALUE2 | |
BOOKING_FCST_CUM | |
SHIPMENT_FCST | |
SHIPMENT_FCST_VALUE | |
SHIPMENT_FCST_VALUE2 | |
SHIPMENT_FCST_CUM | |
PROJECTED_BACKLOG | |
ACTUAL_BACKLOG | |
SHIPMENT_HISTORY | |
ORGANIZATION_ID | |
SHIPMENT_HISTORY_VALUE | |
SHIPMENT_HISTORY_VALUE2 | |
SHIPMENT_HISTORY_CUM | |
BOOKING_HISTORY | |
BOOKING_HISTORY_VALUE | |
BOOKING_HISTORY_VALUE2 | |
BOOKING_HISTORY_CUM | |
CONSEN_FCST_ACCRCY_MAPE_4WEEK | |
CONSEN_FCST_ACCRCY_MAPE_8WEEK | |
CONSEN_FCST_ACCRCY_MAPE_13WEEK | |
INVENTORY_ITEM_ID | |
CREATED_BY | |
CREATION_DATE | |
LAST_UPDATED_BY | |
LAST_UPDATE_DATE | |
LAST_UPDATE_LOGIN | |
PROGRAM_ID | |
PROGRAM_LOGIN_ID | |
PROGRAM_APPLICATION_ID | |
REQUEST_ID | |
RETURNS_HISTORY | |
CUSTOMER_ID | |
ANNUAL_PLAN_VALUE | |
ANNUAL_PLAN_VALUE2 | |
FINANCIAL_FCST_VALUE | |
FINANCIAL_FCST_VALUE2 | |
FINAL_FCST | |
FINAL_FCST_VALUE | |
FINAL_FCST_VALUE2 | |
FINAL_FCST_CUM | |
PROJECTED_BACKLOG_VALUE | |
PROJECTED_BACKLOG_VALUE2 | |
CUSTOMER_SITE_ID | |
ACTUAL_BACKLOG_VALUE | |
ACTUAL_BACKLOG_VALUE2 | |
INVENTORY_HISTORY | |
INVENTORY_HISTORY_VALUE | |
INVENTORY_HISTORY_VALUE2 | |
BOOKING_HISTORY_RD | |
BOOKING_HISTORY_RD_VALUE | |
BOOKING_HISTORY_RD_VALUE2 | |
REGION_ID | |
ORGANIZATION_CODE |
Advanced Supply Chain Planning - MSC_ST_EXCEPTIONS_F | |
---|---|
Column Name | Descritpion |
ST_TRANSACTION_ID | |
CUSTOMER_ID | |
CUSTOMER_SITE_ID | |
CUSTOMER_REGION_ID | |
SUPPLIER_ID | |
SUPPLIER_SITE_ID | |
SUPPLIER_REGION_ID | |
PROJECT_ID | |
TASK_ID | |
ORGANIZATION_CODE | |
OWNING_ORG_CODE | |
ERROR_CODE | |
ITEM_NAME | |
REQUEST_ID | |
DEPARTMENT_CODE | |
DEPARTMENT_CLASS | |
RESOURCE_CODE | |
RESOURCE_GROUP_NAME | |
CUSTOMER_NAME | |
CUSTOMER_SITE_CODE | |
CUSTOMER_ZONE | |
SUPPLIER_NAME | |
SUPPLIER_SITE_CODE | |
SR_INSTANCE_ID | |
SUPPLIER_ZONE | |
PROJECT_NUMBER | |
TASK_NUMBER | |
SHIP_METHOD | |
ANALYSIS_DATE | |
EXCEPTION_TYPE | |
EXCEPTION_COUNT | |
EXCEPTION_VALUE | |
EXCEPTION_VALUE2 | |
EXCEPTION_DAYS | |
ORGANIZATION_ID | |
EXCEPTION_QUANTITY | |
PROGRAM_APPLICATION_ID | |
EXCEPTION_RATIO | |
CREATED_BY | |
CREATION_DATE | |
LAST_UPDATED_BY | |
LAST_UPDATE_DATE | |
LAST_UPDATE_LOGIN | |
PROGRAM_ID | |
PROGRAM_LOGIN_ID | |
VMI_FLAG | |
OWNING_INST_ID | |
ORDER_TYPE | |
OWNING_ORG_ID | |
INVENTORY_ITEM_ID | |
DEPARTMENT_ID | |
RESOURCE_ID |
Advanced Supply Chain Planning - MSC_ST_ITEMS_F | |
---|---|
Column Name | Descritpion |
ST_TRANSACTION_ID | |
EXCESS_ONORDER | |
EXCESS_ONHAND | |
OBSOLETE_ONORDER | |
OBSOLETE_ONHAND | |
TOTAL_EXCESS | |
EXCESS_FROM_ONHAND_VALUE | |
EXCESS_FROM_ONORDER_VALUE | |
TOTAL_EXCESS_VALUE | |
EXCESS_FROM_ONHAND_VALUE2 | |
EXCESS_FROM_ONORDER_VALUE2 | |
ERROR_CODE | |
TOTAL_EXCESS_VALUE2 | |
TOTAL_OBS | |
OBSOLETE_ONHAND_VALUE | |
OBSOLETE_ONORDER_VALUE | |
TOTAL_OBS_VALUE | |
OBSOLETE_ONHAND_VALUE2 | |
OBSOLETE_ONORDER_VALUE2 | |
TOTAL_OBS_VALUE2 | |
CREATED_BY | |
CREATION_DATE | |
SR_INSTANCE_ID | |
LAST_UPDATED_BY | |
LAST_UPDATE_DATE | |
LAST_UPDATE_LOGIN | |
PROGRAM_ID | |
PROGRAM_LOGIN_ID | |
PROGRAM_APPLICATION_ID | |
REQUEST_ID | |
AVG_DAILY_DEMAND | |
ORGANIZATION_ID | |
INVENTORY_ITEM_ID | |
ORGANIZATION_CODE | |
ITEM_NAME | |
DMD_WITHIN_OBS_HORIZON | |
DMD_WITHIN_EXCESS_HORIZON |
Advanced Supply Chain Planning - MSC_ST_ITEM_INVENTORY_F | |
---|---|
Column Name | Descritpion |
ST_TRANSACTION_ID | |
ITEM_NAME | |
VMI_FLAG | |
ORDER_DATE | |
PAB_QTY | |
PAB_VALUE | |
PAB_VALUE2 | |
SAFETY_STOCK_QTY | |
MIN_INVENTORY_LEVEL | |
MAX_INVENTORY_LEVEL | |
AVG_DAILY_DEMAND | |
ERROR_CODE | |
INV_BUILD_TARGET | |
CREATED_BY | |
CREATION_DATE | |
LAST_UPDATED_BY | |
LAST_UPDATE_DATE | |
LAST_UPDATE_LOGIN | |
PROGRAM_ID | |
PROGRAM_LOGIN_ID | |
PROGRAM_APPLICATION_ID | |
REQUEST_ID | |
SR_INSTANCE_ID | |
DEMAND_VAR_SS_QTY | |
SUP_LTVAR_SS_QTY | |
TRANSIT_LTVAR_SS_QTY | |
MFG_LTVAR_SS_QTY | |
TOTAL_UNPOOLED_SAFETY_STOCK | |
INVENTORY_COST_POST | |
INVENTORY_COST_NO_POST2 | |
INVENTORY_COST_NO_POST | |
INVENTORY_VALUE_NO_POST | |
INVENTORY_VALUE_POST | |
ORGANIZATION_ID | |
INVENTORY_COST_POST2 | |
INVENTORY_VALUE_NO_POST2 | |
INVENTORY_VALUE_POST2 | |
SAFETY_STOCK_VALUE | |
SAFETY_STOCK_VALUE2 | |
SAFETY_STOCK_DAYS | |
INVENTORY_VALUE | |
INVENTORY_VALUE2 | |
OWNING_INST_ID | |
OWNING_ORG_ID | |
INVENTORY_ITEM_ID | |
ORGANIZATION_CODE | |
OWNING_ORG_CODE |
Advanced Supply Chain Planning - MSC_ST_ITEM_ORDERS_F | |
---|---|
Column Name | Descritpion |
ST_TRANSACTION_ID | |
ITEM_NAME | |
VMI_FLAG | |
ORDER_DATE | |
DEMAND_QTY | |
PEGGED_TO_EXCESS_QTY | |
SUPPLY_QTY | |
PLANNED_ORDER_QTY | |
INDEP_DEMAND_QTY | |
DEP_DEMAND_QTY | |
SALES_ORDER_VALUE | |
ERROR_CODE | |
RETURN_ORDER_VALUE | |
SCHEDULED_REPT_VALUE | |
MAKE_ORDER_QTY | |
MAKE_ORDER_LEADTIME | |
MAKE_ORDER_COUNT | |
STOCK_OUTS_COUNT | |
NO_ACTIVITY_ITEM_COUNT | |
ITEM_LEADTIME | |
AVG_DAILY_DEMAND | |
DAYS_IN_BKT | |
INDEP_DEMAND_VALUE | |
SR_INSTANCE_ID | |
SCHEDULED_REPT_QTY | |
ONHAND_QTY | |
FORECAST_QTY | |
CREATED_BY | |
CREATION_DATE | |
LAST_UPDATED_BY | |
LAST_UPDATE_DATE | |
LAST_UPDATE_LOGIN | |
PROGRAM_ID | |
PROGRAM_LOGIN_ID | |
ORGANIZATION_ID | |
PROGRAM_APPLICATION_ID | |
REQUEST_ID | |
ONHAND_USABLE | |
INTRANSIT_USABLE | |
PLND_XFER_USABLE | |
ONHAND_DEFECTIVE | |
INTRANSIT_DEFECTIVE | |
PLND_XFER_DEFECTIVE | |
DMD_PGD_TO_SCHD_RECP | |
DMD_PGD_TO_PLND_ORDER | |
OWNING_INST_ID | |
DMD_PGD_TO_ONHAND | |
SUP_END_PGD_TO_FCST | |
SUP_END_PGD_TO_SO | |
SUP_END_PGD_TO_SS | |
SUP_END_PGD_TO_EXCESS | |
DMD_PGD_TO_SCHD_RECP_VALUE | |
DMD_PGD_TO_PLND_ORDER_VALUE | |
DMD_PGD_TO_ONHAND_VALUE | |
SUP_END_PGD_TO_FCST_VALUE | |
SUP_END_PGD_TO_SO_VALUE | |
OWNING_ORG_ID | |
SUP_END_PGD_TO_SS_VALUE | |
SUP_END_PGD_TO_EXCESS_VALUE | |
DMD_PGD_TO_SCHD_RECP_VALUE2 | |
DMD_PGD_TO_PLND_ORDER_VALUE2 | |
DMD_PGD_TO_ONHAND_VALUE2 | |
SUP_END_PGD_TO_FCST_VALUE2 | |
SUP_END_PGD_TO_SO_VALUE2 | |
SUP_END_PGD_TO_SS_VALUE2 | |
SUP_END_PGD_TO_EXCESS_VALUE2 | |
SUPPLY_QTY_USABLE | |
INVENTORY_ITEM_ID | |
SUPPLY_QTY_DEFECTIVE | |
ONHAND_VALUE | |
ONHAND_VALUE2 | |
SUBINVENTORY_CODE | |
SCHEDULED_REPT_VALUE2 | |
SALES_ORDER_VALUE2 | |
ORGANIZATION_CODE | |
OWNING_ORG_CODE |
Advanced Supply Chain Planning - MSC_ST_ITEM_WIPS_F | |
---|---|
Column Name | Descritpion |
ST_TRANSACTION_ID | |
WIP_QTY | |
CREATED_BY | |
CREATION_DATE | |
LAST_UPDATED_BY | |
LAST_UPDATE_DATE | |
LAST_UPDATE_LOGIN | |
PROGRAM_ID | |
PROGRAM_LOGIN_ID | |
PROGRAM_APPLICATION_ID | |
REQUEST_ID | |
ERROR_CODE | |
SR_INSTANCE_ID | |
ORGANIZATION_ID | |
INVENTORY_ITEM_ID | |
ORGANIZATION_CODE | |
ITEM_NAME | |
VMI_FLAG | |
WIP_START_DATE |
Advanced Supply Chain Planning - MSC_PHUB_DATES_MV | |
---|---|
Column Name | Descritpion |
CALENDAR_DATE | |
MFG_PERIOD_START_DATE | |
MFG_PERIOD_END_DATE | |
MFG_PERIOD_NAME | |
FIS_PERIOD_SET_NAME | |
FIS_PERIOD_NUM | |
FIS_PERIOD_NAME | |
FIS_PERIOD_DESCRIPTION | |
FIS_PERIOD_START_DATE | |
FIS_PERIOD_END_DATE | |
FIS_QUARTER_NUM | |
MONTH_START_DATE | |
FIS_QUARTER_NAME | |
FIS_QUARTER_START_DATE | |
FIS_YEAR | |
FIS_YEAR_START_DATE | |
MONTH_END_DATE | |
YEAR_START_DATE | |
MONTH_NAME | |
YEAR_NAME | |
MFG_SEQ_NUM | |
MFG_WEEK_START_DATE | |
MFG_WEEK_END_DATE |
Advanced Supply Chain Planning - MSC_PHUB_CUSTOMERS_MV | |
---|---|
Column Name | Descritpion |
CUSTOMER_ID | |
STATE_CODE | |
CITY_CODE | |
COUNTRY | |
STATE | |
CITY | |
CUSTOMER_SITE_ID | |
SR_INSTANCE_ID | |
REGION_ID | |
CUSTOMER_NAME | |
CUSTOMER_SITE | |
ZONE | |
ADDRESS | |
COUNTRY_CODE |
Advanced Supply Chain Planning - MSC_PHUB_RESOURCES_MV | |
---|---|
Column Name | Descritpion |
SR_INSTANCE_ID | |
RESOURCE_GROUP_DESCRIPTION | |
RESOURCE_NAME | |
RESOURCE_DESCRIPTION | |
EFFICIENCY | |
UTILIZATION | |
MIN_CAPACITY | |
MAX_CAPACITY | |
BOTTLENECK_FLAG | |
RESOURCE_TYPE | |
ORGANIZATION_ID | |
DEPARTMENT_ID | |
DEPARTMENT_CODE | |
DEPARTMENT_DESCRIPTION | |
DEPARTMENT_CLASS | |
RESOURCE_ID | |
RESOURCE_GROUP_ID | |
RESOURCE_GROUP_CODE |
Advanced Supply Chain Planning - MSC_PHUB_ITEM_CATEGORIES_MV | |
---|---|
Column Name | Descritpion |
CATEGORY_SET_ID | |
SR_INSTANCE_ID | |
ORGANIZATION_ID | |
INVENTORY_ITEM_ID | |
SR_CATEGORY_ID |
Advanced Supply Chain Planning - MSC_PHUB_PROJECTS_MV | |
---|---|
Column Name | Descritpion |
PROJECT_ID | |
TASK_NUMBER | |
SR_INSTANCE_ID | |
ORGANIZATION_ID | |
PROJECT_NAME | |
PROJECT_NUMBER | |
PROJECT_DESCRIPTION | |
PLANNING_GROUP | |
TASK_ID | |
TASK_NAME |
Advanced Supply Chain Planning - MSC_PHUB_SUPPLIERS_MV | |
---|---|
Column Name | Descritpion |
SUPPLIER_ID | |
CITY_CODE | |
REGION_ID | |
COUNTRY | |
STATE | |
SR_INSTANCE_ID | |
CITY | |
SUPPLIER_SITE_ID | |
SUPPLIER_NAME | |
SUPPLIER_SITE_CODE | |
ZONE | |
LOCATION | |
ADDRESS | |
COUNTRY_CODE | |
STATE_CODE |
Advanced Supply Chain Planning - MSC_RP_CATEGORY_MV | |
---|---|
Column Name | Descritpion |
SR_INSTANCE_ID | |
SR_CATEGORY_ID | |
CATEGORY_NAME | |
DESCRIPTION | |
CATEGORY_SET_ID |
Advanced Supply Chain Planning - MSC_LONG_TEXT | This table Stores the Short text Content |
---|---|
Column Name | Descritpion |
SR_INSTANCE_ID | Instance id |
MEDIA_ID | MEDIA IDENTIFIER (sequence) |
LONG_TEXT | LONG TEXT content |
REFRESH_NUMBER | REFRESH NUMBER |
LAST_UPDATE_DATE | STANDARD WHO COLUMN |
LAST_UPDATED_BY | STANDARD WHO COLUMN |
CREATION_DATE | STANDARD WHO COLUMN |
CREATED_BY | STANDARD WHO COLUMN |
LAST_UPDATE_LOGIN | STANDARD WHO COLUMN |
Advanced Supply Chain Planning - MSC_ORP_RESOURCE_PLANS | |
---|---|
Column Name | Descritpion |
TRANSACTION_ID | |
LAST_UPDATED_BY | |
CREATION_DATE | |
CREATED_BY | |
LAST_UPDATE_LOGIN | |
ORGANIZATION_ID | |
PLAN_ID | |
SR_INSTANCE_ID | |
RESOURCE_ID | |
DEPARTMENT_ID | |
RESOURCE_HOUR_TYPE | |
RESOURCE_HOUR_DATE | |
RESOURCE_HOURS | |
LAST_UPDATE_DATE |
Advanced Supply Chain Planning - MSC_ORG_AGGR_IBUC | This table Stores the aggregated quantity of the install base item instances at item,date,org level |
---|---|
Column Name | Descritpion |
SR_INSTANCE_ID | |
CREATION_DATE | |
CREATED_BY | |
LAST_UPDATE_LOGIN | |
REGION_ID | |
INVENTORY_ITEM_ID | |
SAMPLE_DATE | |
ZONE | |
SUPPLYING_ORG_ID | |
QUANTITY | |
REFRESH_NUMBER | |
LAST_UPDATE_DATE | |
LAST_UPDATED_BY |
Advanced Supply Chain Planning - MSC_ORP_MATERIAL_PLANS | |
---|---|
Column Name | Descritpion |
PLAN_ID | |
MEASURE_QUANTITY | |
MEASURE_DATE | |
LAST_UPDATE_DATE | |
LAST_UPDATED_BY | |
CREATION_DATE | |
CREATED_BY | |
LAST_UPDATE_LOGIN | |
TRANSACTIONID | |
INVENTORY_ITEM_ID | |
ORGANIZATION_ID | |
SR_INSTANCE_ID | |
PRODUCT_FAMILY_ID | |
CATEGORY_SET_ID | |
CATEGORY_ID | |
MEASURE_TYPE |
Advanced Supply Chain Planning - MSC_PLAN_CONSTRAINTS | |
---|---|
Column Name | Descritpion |
CONSTRAINT_ID | |
RESOURCE_ID | |
OPERATION_SEQ_NUM | |
RESOURCE_SEQ_NUM | |
ROUTING_ID | |
SUPPLIER_ID | |
SUPPLIER_SITE_ID | |
REQUIRED_QUANTITY | |
PROMISED_QUANTITY | |
REQUIRED_DATE | |
BUFFER_LEVEL | |
PLAN_ID | |
LAST_UPDATE_DATE | |
LAST_UPDATED_BY | |
CREATION_DATE | |
CREATED_BY | |
LAST_UPDATE_LOGIN | |
SOURCE_ORGANIZATION_ID | |
SOURCE_INSTANCE_ID | |
SHIP_METHOD | |
EXHAUSTIVE_CONSTRAINT_FLAG | |
EARLIEST_AVAILABLE_DATE | |
DEMAND_ID | |
SEARCH_PATH | |
CONSTRAINT_TYPE | |
MATERIAL_CONSTRAINT_TYPE | |
INVENTORY_ITEM_ID | |
ORGANIZATION_ID | |
SR_INSTANCE_ID | |
DEPARTMENT_ID |
Advanced Supply Chain Planning - MSC_RP_ITEM_UPDATES | |
---|---|
Column Name | Descritpion |
PLAN_ID | |
CREATED_BY | |
LAST_UPDATE_LOGIN | |
INVENTORY_ITEM_ID | |
ORGANIZATION_ID | |
SR_INSTANCE_ID | |
PLANNING_TIME_FENCE_DATE | |
SAFETY_STOCK_PERCENT | |
LAST_UPDATE_DATE | |
LAST_UPDATED_BY | |
CREATION_DATE |
Advanced Supply Chain Planning - MSC_RP_RELEASED_ORDERS | |
---|---|
Column Name | Descritpion |
PLAN_ID | |
LAST_UPDATE_LOGIN | |
RELEASE_STATUS | |
TRANSACTION_ID | |
IMPLEMENTED_QUANITY | |
IMPLEMENTED_DATE | |
PLAN_VERSION | |
LAST_UPDATE_DATE | |
LAST_UPDATED_BY | |
CREATION_DATE | |
CREATED_BY |
Advanced Supply Chain Planning - MSC_SHORT_TEXT | This table Stores the Short text Content |
---|---|
Column Name | Descritpion |
SR_INSTANCE_ID | Instance id |
MEDIA_ID | MEDIA IDENTIFIER (sequence) |
SHORT_TEXT | SHORT TEXT content |
REFRESH_NUMBER | REFRESH NUMBER |
LAST_UPDATE_DATE | STANDARD WHO COLUMN |
LAST_UPDATED_BY | STANDARD WHO COLUMN |
CREATION_DATE | STANDARD WHO COLUMN |
CREATED_BY | STANDARD WHO COLUMN |
LAST_UPDATE_LOGIN | STANDARD WHO COLUMN |
Advanced Supply Chain Planning - MSC_SR_ZN_AGGR_IBUC | Source side table that Stores the aggregated quantity of the install base item instances at item,date,zone level |
---|---|
Column Name | Descritpion |
SR_INVENTORY_ITEM_ID | |
LAST_UPDATE_LOGIN | |
REGION_ID | |
ZONE | |
SAMPLE_DATE | |
QUANTITY | |
RN | |
LAST_UPDATE_DATE | |
LAST_UPDATED_BY | |
CREATION_DATE | |
CREATED_BY |
Advanced Supply Chain Planning - MSC_ST_DOC_ATTACHMENTS | This staging table Stores the Attachment information |
---|---|
Column Name | Descritpion |
SR_INSTANCE_ID | Instance ID |
DOC_TYPE | DOCUMENT_TYPE(1- Short Text, 2- long text) |
DESCRIPTION | DOCUMENT Description |
START_DATE_ACTIVE | DATE ON WHICH THE DOCUMENT IS AVAILABLE FOR USE |
END_DATE_ACTIVE | DATE ON WHICH THE DOCUMENT IS NO LONGER AVAILABLE FOR USE |
REFRESH_ID | CYCLE ID OF PLANNING DATA PULL |
LAST_UPDATE_DATE | STANDARD WHO COLUMN |
LAST_UPDATED_BY | STANDARD WHO COLUMN |
CREATION_DATE | STANDARD WHO COLUMN |
CREATED_BY | STANDARD WHO COLUMN |
LAST_UPDATE_LOGIN | STANDARD WHO COLUMN |
ENTITY_NAME | Entity Name |
SEQ_NUM | Sequence Number |
URL | URL |
TITLE | Title |
PK_VALUE1 | HIGH_ITEM_ID |
PK_VALUE2 | LOW_ITEM_ID |
PK_VALUE3 | |
PK_VALUE4 | |
PK_VALUE5 | |
MEDIA_ID | MEDIA IDENTIFIER TO SUB TABLE |
DOC_ID | Currently not used; DOCUMENT_IDENTIFIER (Sequence) |
Advanced Supply Chain Planning - MSC_ST_EAM_ACT_ASSOCIATIONS | |
---|---|
Column Name | Descritpion |
SR_INSTANCE_ID | |
LAST_UPDATE_DATE | |
LAST_UPDATED_BY | |
CREATION_DATE | |
CREATED_BY | |
LAST_UPDATE_LOGIN | |
DELETED_FLAG | |
RN | |
ASSET_ACTIVITY_ID | |
ORGANIZATION_ID | |
ACTIVITY | |
ASSET_REBUILD_ITEM_ID | |
ACTIVITY_TYPE | |
ASSET_REBUILD_GROUP | |
EAM_ITEM_TYPE | |
REFRESH_NUMBER |
Advanced Supply Chain Planning - MSC_ST_EAM_ASSET_EQUIP_DTLS | |
---|---|
Column Name | Descritpion |
ASSET_GROUP_ITEM_ID | |
REFRESH_NUMBER | |
RESOURCE_ID | |
DEPARTMENT_ID | |
RESOURCE_CODE | |
SCHEDULE_TO_INSTANCE | |
ORGANIZATION_ID | |
ASSET_ACTIVITY_ID | |
ASSET_NUMBER_ID | |
ASSET_NUMBER | |
EQUIPMENT_ITEM_ID | |
EQUIPMENT_SERIAL_NUM | |
DELETED_FLAG | |
SR_INSTANCE_ID |
Advanced Supply Chain Planning - MSC_PHUB_ORGS_MV | |
---|---|
Column Name | Descritpion |
SR_INSTANCE_ID | |
SUB_INVENTORY_CODE | |
SUB_INVENTORY_DESC | |
OPERATING_UNIT | |
OPERATING_UNIT_NAME | |
ORGANIZATION_ID | |
ORGANIZATION_CODE | |
CURRENCY_CODE | |
ORGANIZATION_NAME | |
MODELED_CUSTOMER_FLAG | |
MODELED_SUPPLIER_FLAG |
Advanced Supply Chain Planning - MSC_PHUB_CATEGORIES_MV | |
---|---|
Column Name | Descritpion |
CATEGORY_SET_ID | |
SR_CATEGORY_ID | |
SR_INSTANCE_ID | |
CATEGORY_NAME | |
DESCRIPTION |
No hay comentarios:
Publicar un comentario