My crEme Jrun command params to run MSCA GUI are:

–classpath \Application\Windows\CrEme\lib\TAWTclasses.zip;\mwagui\mscaclient.jar; oracle.apps.mwa.awt.client.StartGUI

How To solve Facebook Is down Page

I looks like everybody is having problems to login to facebook.

Well here are some solutions :


Read a Book.

Go to a park with our dog  or your pet  it's really funny when some one takes his turtle to a park.

Cats prefer to go by them self.

Have a good day.

Get EBS Version and Instance name

select release_name, applications_system_name
  from fnd_product_groups;

STARTING AN ORACLE DATABASE

You must perform some preliminary steps before attempting to start an instance of your database using SQL*Plus.

1. Ensure that environment variables are set so that you connect to the desired Oracle instance.
2. Start SQL*Plus without connecting to the database:
   

   SQLPLUS /NOLOG
   
   

3. Connect to Oracle Database as SYSDBA:
   

   CONNECT username/password AS SYSDBA
   
   

My Advanced Supply Chain Planning Table Descriptions hand book (I have big hands) Part 4

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
EMAIL	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