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

Advanced Supply Chain Planning - MSC_APPS_INSTANCES	This tables stores the information of each connected Application instance.
Column Name	Descritpion
APPS_VER	Application's version number
LAST_UPDATED_BY	Standard Who column
INSTANCE_TYPE	Specifies instance type (1 = disc apps, 2=OPM, 3= other)
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
ATTRIBUTE4	Descriptive flexfield segment
DBS_VER	Database version number
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
CURRENCY	Currency code
ASSIGNMENT_SET_ID	Assignment Set Id
LR_SOURCING_FLAG	refresh type of sourcing flag in last collections
COMPANY_ID	Company Id
SUMMARY_FLAG	Summary Flag
SUMMARY_REFRESH_NUMBER	Summary Refresh Flag
COLLECTIONS_START_TIME	Stores the Collections Start time (when the snapshots are refreshed)
A2M_DBLINK	Application to MSC's database link
LAST_TGT_CONT_COLL_TIME	Last Collection time of Entities with Snapshot
SUPPLIES_LOAD_FLAG	Flag to indicate the status of ODS Load of Supplies
M2A_DBLINK	MSC to Application's database link
INSTANCE_CODE	Unique code assigned to each application instance
ENABLE_FLAG	Y/N Flag to indicate whether the site is currently active or inactive
LRID	Last refresh ID
LRTYPE	Last refresh type: C = for complete refresh, I = for incremental,P=Partial
SO_LRTYPE	So lr type
SO_TBL_STATUS	So table status flag
APPS_LRN	Application instance's last refresh number
INSTANCE_ID	Applications' Instance Identifier
LCID	Last executed collection program number
ST_STATUS	The status of instance data in staging table
CLEANSED_FLAG	The data cleansing flag of the instance data
GMT_DIFFERENCE	The time difference to the GMT
LAST_UPDATE_DATE	Standard Who column

Advanced Supply Chain Planning - MSC_ASSIGNMENT_SETS	This table stores the assignment of sourcing rules (or bills of distribution) to item, organization, category, or at the global level.
Column Name	Descritpion
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
ASSIGNMENT_SET_ID	Assignment set 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
SR_INSTANCE_ID	Source application identifier
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
COLLECTED_FLAG	Flag to indicate whether the row is collected from application instance.
ASSIGNMENT_SET_NAME	Assignment set name
DESCRIPTION	Description
SR_ASSIGNMENT_SET_ID	Assignment set identifier from source application instance
DELETED_FLAG	Flag to indicate whether the row is no longer valid. SYS_YES means the row will be deleted
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_ATP_RULES	This table stores rules and options that are used in Available To Promise computation.
Column Name	Descritpion
RULE_NAME	Name of ATP rule
ACCEPTABLE_EARLY_FENCE	Acceptable early fence
ACCEPTABLE_LATE_FENCE	Acceptable late fence
DEFAULT_ATP_SOURCES	Indicate which subinventories to use for on-hand quantities
DEMAND_CLASS_ATP_FLAG	Yes/No flag for ATP computation to consider Demand Class when selecting supply and demand
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
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
DESCRIPTION	Desscription for ATP rule
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. Only has impact if accumulate available = Yes
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
ACCUMULATE_AVAILABLE_FLAG	Flag for ATP computation to accumulate quantity availability
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
INCLUDE_FLOW_SCHEDULE_RECEIPTS	Yes/No flag for ATP computation to include supply from repetitive MPS schedules
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
BACKWARD_CONSUMPTION_FLAG	Flag for ATP computation to backwardly consume shortage
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
ATTRIBUTE4	Descriptive flexfield segment
RULE_ID	ATP rule identifier
FORWARD_CONSUMPTION_FLAG	Flag for ATP computation to forwardly consume shortage
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
PAST_DUE_DEMAND_CUTOFF_FENCE	Demand before the specified number of days are not to be considered in ATP computation
SR_INSTANCE_ID	Instance id
PAST_DUE_SUPPLY_CUTOFF_FENCE	Supplies before the specified number of days are not to be considered in ATP computation
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

Advanced Supply Chain Planning - MSC_BILL_OF_RESOURCES	This table stores the set of resources required in an organization.
Column Name	Descritpion
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	Concurrent 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
BILL_OF_RESOURCES	Source application bill of resource 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
PLAN_ID	Plan identifier
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
ORGANIZATION_ID	Organization identifier
SR_INSTANCE_ID	Source application instance 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
REFRESH_NUMBER	Refresh number used by the collection program

Advanced Supply Chain Planning - MSC_BOMS	This table represents the Bills Of Material of an item created at source applications.
Column Name	Descritpion
ASSEMBLY_ITEM_ID	Identifier of the item being assembled
REFRESH_NUMBER	Refresh number populated by the collection program
SR_INSTANCE_ID	Identifier of the source application instance
ASSEMBLY_TYPE	Manufacturing Bill(1), or Engineering(2). Used for UI and reports.
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
PLAN_ID	Plan 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
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
SPECIFIC_ASSEMBLY_COMMENT	Comments for specific assembly
YIELDING_OP_SEQ_NUM
NEW_PLAN_ID
PENDING_FROM_ECN	Change notice that created this bill of material
NEW_PLAN_LIST
APPLIED
SIMULATION_SET_ID
REPAIRABLE
ACTIVITY_ITEM_ID
ALTERNATE_BOM_DESIGNATOR	Name of the bill for alternate bills (null for the primary bill)
SCALING_TYPE	(OPM) Controls scaling behavior
BILL_SEQUENCE_ID	Bill sequence identifier in the source application instance
ASSEMBLY_QUANTITY	Assembly quantity
UOM	Unit of measure code
ORGANIZATION_ID	Organization identifier of the item

Advanced Supply Chain Planning - MSC_BOM_COMPONENTS	This table stores Bill of material data for plans in Oracle Advanced Planning and Oracle Supply Chain Hub products.
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
BILL_SEQUENCE_ID	Identifier of the BOM
TO_UNIT_NUMBER	Effective up to this unit number
SR_INSTANCE_ID	Source application instance identifier
USE_UP_CODE	Yes/No flag - if yes this component is effective until the available quantity becomes null
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
COMPONENT_TYPE	Component (1), Ingredient component (-1), by-product (2)
OPTIONAL_COMPONENT	Yes/No flag if optional use planning factor to determine demand
ORGANIZATION_ID	Organization identifier
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
REFRESH_NUMBER	Refresh number populated by the collection program
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
ATTRIBUTE_CATEGORY	Descriptive Flexfield structure defining column
ATTRIBUTE1	Descriptive Flexfield segment
ATTRIBUTE2	Descriptive Flexfield segment
ATTRIBUTE3	Descriptive Flexfield segment
ATTRIBUTE4	Descriptive Flexfield segment
USING_ASSEMBLY_ID	Identifier of the item being assembled
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
SCALE_MULTIPLE	Scale Multiple
SCALE_ROUNDING_VARIANCE	Scale Rounding Variance
ROUNDING_DIRECTION	Rounding Direction
PRIMARY_FLAG	This Flag Indicates if this is a Primary Co-product in a Group.
PLAN_ID	Plan identifier
CONTRIBUTE_TO_STEP_QTY
OLD_COMPONENT_SEQUENCE_ID
OPERATION_SEQ_NUM
NEW_PLAN_ID
NEW_PLAN_LIST
APPLIED
SIMULATION_SET_ID
SCALING_TYPE	Scaling type
CHANGE_NOTICE	Code for ECO. Use for UI and reporting
REVISION	Inventory item revision code

Advanced Supply Chain Planning - MSC_BOR_REQUIREMENTS	This table stores the set of resources required in an organization for an item.
Column Name	Descritpion
SR_INSTANCE_ID	Source application instance identifier
BASIS	Operation Basis. Item(1), Lot(2), Resource Units(3), Resource value(4), Total value(5), Activity units(6)
BILL_OF_RESOURCES	Bill of resource set name
RESOURCE_ID	Resource identifier
DEPARTMENT_ID	Department identifier (Line identifier)
ORGANIZATION_ID	Organization identifier
ASSEMBLY_ITEM_ID	Assembly item identifier
SOURCE_ITEM_ID	Source item identifier
REFRESH_NUMBER	Refresh number populated by the collection program
LAST_UPDATE_DATE	Standard Who column
RESOURCE_DEPARTMENT_HOURS	Required resource hours
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
ATTRIBUTE4	Descriptive flexfield segment
OPERATION_SEQUENCE_ID	Routing operation sequence 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
ATTRIBUTE15	Descriptive flexfield segment
SR_TRANSACTION_ID	Source transaction identifier
OPERATION_SEQ_NUM	Operation sequence number in routing
PLAN_ID	Plan identifier
RESOURCE_SEQ_NUM	Resource sequence number
TRANSACTION_ID	Source application transaction identifier
SETBACK_DAYS	Resource set back days from assembly due date
ASSEMBLY_USAGE	Resource hours multiplier for assembly usage
ORIGINATION_TYPE	Load(1), Manual update(2), Manual addition(3)
RESOURCE_UNITS	Operation resource units

Advanced Supply Chain Planning - MSC_CALENDAR_DATES	MSC_CALENDAR_DATES stores every date between the calendar start date and calendar end date for the given calendar using a specified exception set.This tables stores data collected from source applications.
Column Name	Descritpion
CALENDAR_DATE	Calendar date
CALENDAR_START_DATE	Beginning date for the calendar
CALENDAR_END_DATE	Ending date for the calendar
DESCRIPTION	Calendar description
EXCEPTION_SET_ID	Exception set identifier
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
CALENDAR_CODE	Calendar code
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
SEQ_NUM	Sequence number (for working days only)
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
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

Advanced Supply Chain Planning - MSC_CATEGORY_SETS	This tables stores different category sets for an item.
Column Name	Descritpion
CATEGORY_SET_ID	Category set identifier
CREATED_BY	Standard Who column
CATEGORY_SET_NAME	Category set 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
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
DESCRIPTION	Category set description
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
CONTROL_LEVEL	Item or Item/org control level
SR_CATEGORY_SET_ID	Source application category set identifier
SR_INSTANCE_ID	Source application instance identifier
DEFAULT_FLAG	Flag indicating whether this is default category set
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

Advanced Supply Chain Planning - MSC_COMPONENT_SUBSTITUTES	This table represents possible substitutes component in a bill of material.
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
SUBSTITUTE_ITEM_ID	Substitute inventory item identifier
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
COMPONENT_SEQUENCE_ID	Source application identifier for that component
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
ROUNDING_DIRECTION	Rounding Direction
BILL_SEQUENCE_ID	Bill sequence identifier for the component
PLAN_ID	Plan identifier
SR_INSTANCE_ID	Source application instance identifier
USAGE_QUANTITY	Usage quantity for the substitute component
PRIORITY	Priority of the component substitute
REFRESH_NUMBER	Refresh number populated by the collection program
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column

Advanced Supply Chain Planning - MSC_DEMANDS	This table stores all the demands taken into account for planning. Disposition_id would be a foreign key to MSC_SUPPLIES for dependent demands. For independent demands, disposition_id holds MRP_SCHEDULE_DATES.MPS_TRANSACTION_ID.
Column Name	Descritpion
SCHEDULE_DESIGNATOR_ID	Schedule designator identifier
UNIT_NUMBER	Unit number
QUANTITY_PER_ASSEMBLY
RELEASE_STATUS
RESCHEDULE_FLAG
LOAD_TYPE
IMPLEMENT_ORG_ID
IMPLEMENT_INSTANCE_ID
IMPLEMENT_DATE
RELEASE_ERRORS
ORG_FIRM_FLAG
ORIGINAL_ORG_ID
ORIGINAL_INST_ID
ARRIVAL_SET_ID
SHIP_SET_ID
ORDER_DATE_TYPE_CODE
SCHEDULE_ARRIVAL_DATE
LATEST_ACCEPTABLE_DATE
SHIPPING_METHOD_CODE
PLANNED_ARRIVAL_DATE
REQUEST_SHIP_DATE
PROMISE_SHIP_DATE
SCHEDULE_SHIP_DATE
ORIGINAL_DEMAND_ID
ZONE_ID
ORIG_SHIPPING_METHOD_CODE
INTRANSIT_LEAD_TIME
ORIG_INTRANSIT_LEAD_TIME
ATP_OVERRIDE_FLAG
IMPLEMENT_FIRM
IMPLEMENT_EARLIEST_DATE
IMPLEMENT_ARRIVAL_DATE
UNBUCKETED_DEMAND_DATE
ATO_LINE_ID
TOP_MODEL_LINE_ID
PARENT_MODEL_LINE_ID
STD_MANDATORY_COMP_FLAG
OLD_REFRESH_NUMBER
SHIP_METHOD
SHIP_CALENDAR
RECEIVING_CALENDAR
INTRANSIT_CALENDAR
SHIP_TO_LOCATION_ID
ORIGINAL_QUANTITY
USING_REQUIREMENT_QUANTITY	Required quantity
FINAL_USE_PRIORITY
FINAL_USE_DATE
ARRIVAL_SET_NAME
SHIP_SET_NAME
SOURCE_PHANTOM_ID
PRIMARY_COMPONENT_ID
ATP_SESSION_ID
IMPLEMENT_SHIP_DATE
PLANNED_SHIP_DATE
PRIOR_ALLOCATION_QTY
MANUAL_ALLOCATION_QTY
MANUAL_ALLOCATION_DATE
FIRM_ALLOCATION_FLAG
ASSET_SERIAL_NUMBER
ASSET_ITEM_ID
EXPIRATION_DATE
SALES_ORDER_LINE_SPLIT
PLANNED_INBOUND_DUE_DATE
FILL_KILL_FLAG
DEFINITION_LEVEL_USED
DEMAND_FULFILLMENT_LEAD_TIME
COMPONENT_SCALING_TYPE
COMPONENT_YIELD_FACTOR
SPLIT_FROM_DEMAND_ID
ITEM_TYPE_ID
ITEM_TYPE_VALUE
REPAIR_LINE_ID
OTM_ARRIVAL_DATE
WIP_ENTITY_NAME
MIN_REM_SHELF_LIFE_DAYS
REVISED_DMD_DATE
REVISED_DMD_PRIORITY
TOP_MODEL_ITEM_ID
PARENT_MODEL_ITEM_ID
DAYS_LATE
ORIG_FIRM_DATE
ORIG_FIRM_QUANTITY
OBJECT_TYPE
USING_ASSEMBLY_ITEM_ID	Using assembly iten identifier (item generating the demand for dependent demands)
DISPOSITION_ID	Disposition identifier, reference to the supply generating the demand.
PLAN_ID	Plan identifier
ORGANIZATION_ID	Organization identifier
INVENTORY_ITEM_ID	Demanded item identifier
PROJECT_ID	Project identifier to which the demand applies
TASK_ID	Task identifier to which the demand applies
CUSTOMER_ID	Customer identifier
ASSEMBLY_DEMAND_COMP_DATE	Using assembly completion date
CUSTOMER_SITE_ID	Customer site identifier
SR_INSTANCE_ID	Source application instance identifier
SHIP_TO_SITE_ID	Destination of the product
PROMISE_DATE	Date promised to the customer
SELLING_PRICE	Selling price
DMD_LATENESS_COST	Demand lateness cost for independent demands
DMD_SATISFIED_DATE	Date demand is satisfied
OP_SEQ_NUM	Operation sequence number within the routing used by the source supply
UPDATED	Flag to determine whether add workday modification was applied
STATUS	Used for online replanning
ORDER_PRIORITY	Order priority
APPLIED	Used for online replanning
DEMAND_CLASS	Demand class code
FIRM_QUANTITY	Firm quantity
FIRM_DATE	Firm quantity
OLD_DEMAND_QUANTITY	Old demand quantity
OLD_DEMAND_DATE	Old order due date
SOURCE_ORGANIZATION_ID	Source application identifier
RESERVATION_ID	Reservation identifier
PARENT_ID	Demand identifier of the parent demand transaction
USING_ASSEMBLY_DEMAND_DATE	Demand date (due date)
LENDING_PROJECT_ID	Lending project identifier for Payback Demand
LENDING_TASK_ID	Lending task identifier for Payback Demand
SUBST_ITEM_FLAG	Flag indicating whether item is a substitute item
RESERVED_QUANTITY	Quantity reserved
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
PREV_SUBST_ITEM
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
DEMAND_TYPE	Demand type. Discrete Demand(1), Rate-based demand(2)
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ORDER_NUMBER	Wip entity name
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
PROBABILITY	Probability
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
WIP_ENTITY_ID	WIP job identifier
ISSUED_QUANTITY	Quantity issued
REPETITIVE_SCHEDULE_ID	Repetitive schedule identifier
REFRESH_NUMBER	Refresh number populated by the collection program
REQUEST_DATE	Request date
WIP_STATUS_CODE	WIP job status code
WIP_SUPPLY_TYPE	WIP supply type
SOURCE_ORG_INSTANCE_ID	Source Org Instance Identifier
SALES_ORDER_LINE_ID	Sales order line identifier
CONFIDENCE_PERCENTAGE	Forecast confidence percentage
FORECAST_MAD	Forecash MAD
PREV_SUBST_ORG
BUCKET_TYPE	Bucket type
BILL_ID	Forecast billing address identifier
FORECAST_SET_ID	Forecast set identifier
GROUP_ID	Group identifier
SERVICE_LEVEL	Service Level
QUANTITY_BY_DUE_DATE	Quantity By Due Date
TARGET_SAFETY_STOCK	Target Safety Stock
SCENARIO_SET	Scenario Set
ORIGINATION_TYPE	Origin of the demand: Planned order, hard reservation, etc...
DEMAND_SOURCE_TYPE	Forecast billing address identifier
SUPPLY_ID	Forecast billing address identifier
ORIGINAL_SYSTEM_REFERENCE	Original System Reference
ORIGINAL_SYSTEM_LINE_REFERENCE	Original System Line Reference
STOLEN_FLAG	Stolen Flag
OLD_USING_REQUIREMENT_QUANTITY	for ATP SUmmary Calculation
OLD_USING_ASSEMBLY_DEMAND_DATE	for ATP SUmmary Calculation
OLD_ASSEMBLY_DEMAND_COMP_DATE	for ATP SUmmary Calculation
CUMMULATIVE_PROBABILITY	Cumulative Probaility
ORIGINAL_ITEM_ID	Original Item Id
UNMET_QUANTITY	Unmet Quantity for Independent Demands
RECORD_SOURCE	For plan order demands generated by ATP this field will have value 2. If this field is 1 or null then the plan order is generated by MBP
LINK_TO_LINE_ID	Parent Line Identifier
ERROR_TYPE	1=MAD, 2=MAPE, Null= Neither
ATP_SYNCHRONIZATION_FLAG
COMP_SEQ_ID	Component Sequence Id
DEMAND_PRIORITY	Demand priority. Used by scheduling heuristic
SALES_ORDER_PRIORITY	Sales order quantity
DEMAND_ID	Demand identifier
FORECAST_PRIORITY	Forecast priority
PLANNING_GROUP	Planning group
DAILY_DEMAND_RATE	Repetitive demand rate

Advanced Supply Chain Planning - MSC_DEPARTMENT_RESOURCES	This table stores the resources available for planning.
Column Name	Descritpion
ORGANIZATION_ID	Organization identifier
AGGREGATE_RESOURCE_ID	Reference to aggregate resource, if aggregated
AGGREGATE_RESOURCE_FLAG	Yes/No flag to indicate whether or not this is an aggregated resource
RESOURCE_GROUP_NAME	Name of the group of resource
RESOURCE_GROUP_CODE	Resource group code
RESOURCE_SHORTAGE_TYPE	Resource shortage type
RESOURCE_BALANCE_FLAG	Flag to indicate if the resource needs to load balanced
RESOURCE_EXCESS_TYPE	Resource excess type
RESOURCE_INCLUDE_FLAG	Flag to indicae if we need to consider this resource when planning
CRITICAL_RESOURCE_FLAG	Flag to indicate if this a critical resource. This is used by LP and HLS
OVERUTILIZED_PERCENT	Overutilization tolerance
BOTTLENECK_FLAG	Flag to indicate if the resource is a known bottleneck
UNDERUTILIZED_PERCENT	Underutilization tolerance
SR_INSTANCE_ID	Source application instance identifier
OWNING_DEPARTMENT_ID	Owning department identifier for share resources
CAPACITY_UNITS	Resource capacity
RESOURCE_ID	Source application resource identifier
UTILIZATION	Resource utilization
EFFICIENCY	Resource Efficiency
USER_TIME_FENCE	Number of days within which planning will generate an exception message
RESOURCE_TYPE	Resource type
DISABLE_DATE	Date on which resource/line was disabled
AVAILABLE_24_HOURS_FLAG	Resource is available 24 hours or by shifts
MIN_RATE	Hourly minimum rate of production line
MAX_RATE	Hourly maximum rate of production line
START_TIME	Start time of the line
DEPARTMENT_ID	Source application department identifier or line identifier
STOP_TIME	Stop time of the line
CTP_FLAG	Flag indicating whether the department resource is used for ATP or not
REFRESH_NUMBER	Refresh Number
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
RESOURCE_CODE	Resource code
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
RESOURCE_DESCRIPTION	Resource description
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_COST	Resource cost
RESOURCE_OVER_UTIL_COST	Resource overutilization cost
DEPARTMENT_CODE	Department code, also holds line code
DEPT_OVERHEAD_COST	Department overhead cost
PLANNING_EXCEPTION_SET	Planning Exception Set
BATCHABLE_FLAG	Batchable Flag
BATCHING_WINDOW	Batching Window
MIN_CAPACITY	Min Capacity
DEPARTMENT_DESCRIPTION	Department description, also hold line description
MAX_CAPACITY	Max Capacity
UNIT_OF_MEASURE	Unit Of Measure
UOM_CLASS_TYPE	Uom Class Type
PLAN_ID	Plan identifier
DEPARTMENT_CLASS	Department class
LINE_FLAG	Flag to indicate whether or not this resource is a line

Advanced Supply Chain Planning - MSC_DESIGNATORS	This table stores MPS and MDS schedule names defined at source applications and planning server. MPS_RELIEF indicates whether or not the Planning Manager should consume this master demand or master production schedule..INVENTORY_ATP_FLAG in
Column Name	Descritpion
DESIGNATOR	Source application schedule name
RECOMMENDATION_RELEASE	Planned order release 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
ORGANIZATION_ID	Source application 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 identifier
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
DESIGNATOR_TYPE	Indicate the designator type: MPS, MDS, MRP, or DRP
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
MPS_RELIEF	Flag to indicate whether MPS relief performed against this designator
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
COLLECTED_FLAG	Flag indicating whether the row is collected from source application instance
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
INVENTORY_ATP_FLAG	ATP supply flag
SHIP_ID	Forecast ship code identifier
BILL_ID	Forecast billing address identifier
BUCKET_TYPE	Forecast bucket type - days, weeks or periods
PROBABILITY	Probability
LAUNCH_WORKFLOW_FLAG	Launch Workflow Flag
COPY_DESIGNATOR_ID
DESIGNATOR_ID	Designator identifier
DESCRIPTION	Description of the this designator
DISABLE_DATE	Designator disable date
DEMAND_CLASS	Demand class identifier
ORGANIZATION_SELECTION	Single/Multiple organizations
PRODUCTION	Flag for auto release

Advanced Supply Chain Planning - MSC_EXCEPTION_DETAILS	This table stores the details of exceptions generated by Oracle Advanced Planning and Scheduling(APS) and Oracle Supply Chain Hub products.
Column Name	Descritpion
EXCEPTION_TYPE	Type of exception resource, material
NUMBER4	Generic number column
CHAR1	Generic character column
CHAR2	Generic character column
PLAN_ID	Plan identifier
ORGANIZATION_ID	Organization identifier
INVENTORY_ITEM_ID	Inventory item identifier
RESOURCE_ID	Resource identifier
DEPARTMENT_ID	Department identifer or Line identifier
QUANTITY	Exception quantity
SR_INSTANCE_ID	Source application instance identifier
DATE3	Generic date 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
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
DATE1	Generic date column
SUPPLIER_ID	Supplier identifier
SUPPLIER_SITE_ID	Supplier site identifier
CUSTOMER_ID	Customer Identifier
CUSTOMER_SITE_ID	Customer Site Identifier
ORDER_NUMBER	Order number
ORDER_REL_NUMBER	Release Number
ORDER_LINE_NUMBER	Line Number
END_ORDER_NUMBER	End Order Number
END_ORDER_REL_NUMBER	End order release number
END_ORDER_LINE_NUMBER	End order line number
DATE5	Generic date column
NUMBER5	Generic number column
TRANSACTION_ID	map to transaction_id in msc_supplies table
DEMAND_ID	map to demand_id in msc_demands table
ACTION_TAKEN	indicate if this exception detail has been deleted
DATE2	Generic date column
NUMBER6
NUMBER7
NUMBER8
CAUSE
NEW_EXCEPTION
ACTION_TAKEN_BY
EXCEPTION_DETAIL_ID	Exception detail identifier
ACTION_TAKEN_DATE
FIRST_GENERATED_DATE
PART_CONDITION
ZONE_ID
DATE6
DATE4	Generic date column
NUMBER1	Generic number column
NUMBER2	Generic number column
NUMBER3	Generic number column

Advanced Supply Chain Planning - MSC_FULL_PEGGING	This table represents the pegging from supply to demands.
Column Name	Descritpion
DEMAND_QUANTITY	Demand quantity
INVENTORY_ITEM_ID	Inventory item identifier
ORGANIZATION_ID	Organization identifier
PLAN_ID	Plan identifier
PREV_PEGGING_ID	Reference to previous level's pegging identifier
END_PEGGING_ID	Reference to end pegging node identifier
TRANSACTION_ID	Supply identifier
DISPOSITION_ID	Disposition identifier
DEMAND_ID	Demand identifier
PROJECT_ID	Project identifier
SUPPLY_QUANTITY	Supply quantity
TASK_ID	Task identifier
DEMAND_DATE	Demand date
SR_INSTANCE_ID	Source application instance identifier
DEMAND_CLASS	Demand class code
UPDATED	Flag to determine whether add workday modification was applied
STATUS	Attribute used for online replanning
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
ALLOCATED_QUANTITY	Portion of supply allocated to demand
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
UNIT_NUMBER	Unit number
END_ITEM_USAGE	Usage of current item in end assembly
PEGGING_ID	Pegging identifier
DEST_TRANSACTION_ID
SUPPLY_DATE	Supply date
SUPPLY_TYPE	Supply type identifier
END_ORIGINATION_TYPE	Origination type of the end demand

Advanced Supply Chain Planning - MSC_INSTANCE_ORGS	This stores the information of the association links between each organization and MSC.
Column Name	Descritpion
SR_INSTANCE_ID	Source application instance identifier
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
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
ORGANIZATION_ID	Organization identifier
ENABLED_FLAG	Yes/No flag indicating whether the instance org is enable
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

Advanced Supply Chain Planning - MSC_INTERORG_SHIP_METHODS	This table stores the different shipment methods and their availability.
Column Name	Descritpion
WEIGHT_CAPACITY	Weight capacity of this ship method
WEIGHT_UOM	Weight unit of measure
VOLUME_CAPACITY	Volumn capacity
VOLUME_UOM	Volume unit of measure
COST_PER_WEIGHT_UNIT	Cost per unit of weight
COST_PER_VOLUME_UNIT	Cost per unit of volume
FROM_LOCATION_NAME	From location name
TO_LOCATION_NAME	To location name
FROM_LOCATION_DESCR	From location description
FROM_ORGANIZATION_ID	Organization identifier for the origin organization
TO_LOCATION_DESCR	To location description
INTRANSIT_TIME	Used to specify the numerical value for the intransit lead timeof the shipment method relationship
SR_INSTANCE_ID	Instance corresponding to the source org
TRANSPORT_CAP_OVER_UTIL_COST	Transportation capacity overutilization cost
SR_INSTANCE_ID2	Instance corresponding to the destination org
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
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
TO_ORGANIZATION_ID	Organization identifier for the destination organization
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
TRANSACTION_ID	Transaction identifier
PLAN_ID	Plan identifier
SHIP_METHOD	Ship method code
TO_REGION_ID	To Region Id
COLLECTED_FLAG	Flag to indicate whether the Inter-Org Ship method is collected or not
TIME_UOM_CODE	Unit of measure used to specify the intransit lead 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

Advanced Supply Chain Planning - MSC_CALENDAR_SHIFTS	Workday calendar shifts
Column Name	Descritpion
CALENDAR_CODE	Workday calendar 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
SR_INSTANCE_ID	Source application instance identifier
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
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
SHIFT_NUM	Shift number
PROGRAM_ID	Concurrent Who column
DAYS_ON	Number of consecutive working days
PROGRAM_UPDATE_DATE	Concurrent Who column
SHIFT_NAME	Shift Name
DAYS_OFF	Number of consecutive non-working days
DESCRIPTION	Description
REFRESH_NUMBER	Refresh number populated by the collection program
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

Advanced Supply Chain Planning - MSC_CAL_WEEK_START_DATES	This table stores the workday calendar weekly start dates
Column Name	Descritpion
CALENDAR_CODE	Workday calendar identifier
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)
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
SR_INSTANCE_ID	Source application instance identifier
EXCEPTION_SET_ID	Exception set unique identifier
WEEK_START_DATE	Week start date

Advanced Supply Chain Planning - MSC_CAL_YEAR_START_DATES	Workday calendar yearly 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
SR_INSTANCE_ID	Source application instance identifier
EXCEPTION_SET_ID	Exception set unique identifier
YEAR_START_DATE	Calendar Year Start date
REFRESH_NUMBER	Refresh number populated by the
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

Advanced Supply Chain Planning - MSC_FILES	File names used by the planner
Column Name	Descritpion
FILE_NAME	Name of file
FILE_SIZE	File size
FILE_CREATION_DATE	File creation date
ROW_COUNT	Row count
COPY_FLAG	Copy flag(used in Copy Plan program)
NETCHANGE	Net Change
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
LOAD_ID	Load identfier
ATTACHMENT_ID	Attachment identifier
REQUEST_ID	Request identifier
HEADER_ID	Header identifier
FILE_TYPE	File type
PLAN_ID	Plan identifier

Advanced Supply Chain Planning - MSC_FORM_QUERY	Temporaray table used in computation of results in Oracle Advanced planning and Oracle Supply Chain Hub products.
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
CREATED_BY	Standard Who 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
NUMBER17
NUMBER18
NUMBER19
NUMBER20
LAST_UPDATE_LOGIN	Standard Who column
DATE1	Generic date column
DATE2	Generic date column
DATE3	Generic date column

Advanced Supply Chain Planning - MSC_CATEGORY_SET_ID_LID	This table is used by the collection program to maintain the correspondence between the source instances identifiers and the planning identifiers for category sets.
Column Name	Descritpion
SR_CATEGORY_SET_ID	Category set identifier from source application instance
SR_INSTANCE_ID	Source application instance identifier
CATEGORY_SET_ID	Category set identifier generated at planning server

Advanced Supply Chain Planning - MSC_BIS_BUSINESS_PLANS	A business plan in this context is one of possibly many scenarios which set performance targets to particular values anticipated under that scenario.
Column Name	Descritpion
BUSINESS_PLAN_ID	Business plan 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
SR_INSTANCE_ID	Source application instance identifier
SHORT_NAME	Short name of business plan
NAME	Business plan name
DESCRIPTION	Describe the business plan
VERSION_NO	Version number
CURRENT_PLAN_FLAG	Yes/No flag indicating whether the plan is current
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_BIS_PERFORMANCE_MEASURES	MSC_BIS_PERFORMANCE_MEASURES contains business performance measures collected from source applications.
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
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
SR_INSTANCE_ID	Source application instance identifier
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
MEASURE_SHORT_NAME	Measure short name
MEASURE_NAME	Measure 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_BIS_RES_SUMMARY	MSC_BIS_RES_SUMMARY stores resource required hours and available hours for BIS reports.
Column Name	Descritpion
PLAN_ID	Plan identifier
DEPARTMENT_CLASS	Department Class
RESOURCE_GROUP	Resource group code
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
OVERUTILIZATION_COST	Overutilization Cost
UTIL_BY_WT_VOL	Util By Wt Vol
BATCH_COUNT	Batch Count
SR_INSTANCE_ID	Source application instance identifier
DEPARTMENT_ID	Department identifier/Line identifier from source application instance
RESOURCE_ID	Resource identifier from source application instance. (-1 for LINE)
RESOURCE_DATE	Resource required date
REQUIRED_HOURS	Resource required hours
AVAILABLE_HOURS	Resource available hours
UTILIZATION	Resource utilization

Advanced Supply Chain Planning - MSC_BIS_TARGETS	MSC_BIS_TARGETS stores the target values for the BIS reports.
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
SR_INSTANCE_ID	Source application instance identifier
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
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
BUSINESS_PLAN_ID	Business plan 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_BIS_TARGET_LEVELS	MSC_BIS_TARGET_LEVELS contains different combinations of dimension levels to be applied simultaneously to get a performance indicator relevant to a particular reporting need. For example, if someone wants to know sales revenues broken down
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
SR_INSTANCE_ID	Source application instance identifier
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
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
TARGET_LEVEL_NAME	Target level name
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_AMONG_VALUES	User selected criteria for 10SC Planner Workbench
Column Name	Descritpion
FOLDER_ID	Folder identifier
LAST_UPDATE_LOGIN	Standard Who column
SEQUENCE	Criteria sequence
FIELD_NAME	Field name
OR_VALUES	selected values from 'IN' function
HIDDEN_VALUES	selected values from 'IN' function
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column

Advanced Supply Chain Planning - MSC_BIS_PERIODS	MSC_BIS_PERIODS stores periods between the calendar start date and end dates.
Column Name	Descritpion
ORGANIZATION_ID	Organization identifier
QUARTER_START_DATE	Date on which the quarter containing this accounting period starts
PERIOD_TYPE	Accounting period type
PERIOD_YEAR	Accounting period year
PERIOD_NUM	Accounting period number
QUARTER_NUM	Quarter number of accounting period
ENTERED_PERIOD_NAME	User entered accounting period name
ADJUSTMENT_PERIOD_FLAG	Calendar period adjustment status
DESCRIPTION	Accounting period description
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_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
CONTEXT	Descriptive flexfield segment
PERIOD_SET_NAME	Accounting calendar name
PERIOD_NAME	System generated accounting period name
START_DATE	Date on which accounting period begins
END_DATE	Date on which accounting period ends
YEAR_START_DATE	Date on which the year containing this accounting period starts

Advanced Supply Chain Planning - MSC_CRITERIA	Seeded criteria for Planner Workbench
Column Name	Descritpion
FOLDER_OBJECT	Unique folder object identifier
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
APP_SHORT_NAME	Flexfield owning application
FLEX_NUM	Flexfield identifier
DATA_SET	Flexfield data set
FLEX_CODE	Flexfield code
LOV_TYPE	Type of LOV
LONG_LIST	Long list indicator for flexfields
FIELD_NAME	Field name
FIELD_TYPE	Field type
LOV_NAME	List of Value name
SQL_STATEMENT	SQL Statement for creating the list of values
FIELD_PROMPT	Field prompt
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column

Advanced Supply Chain Planning - MSC_AVAILABLE_TO_PROMISE	Available to promise information for master scheduled parts
Column Name	Descritpion
TRANSACTION_ID	Unique identifier
LAST_UPDATE_LOGIN	Standard Who column
QUANTITY_AVAILABLE	ATP quantity
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
UPDATED	Flag indicating whether the row is updated
STATUS	Flag indicating the status of the row
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
INVENTORY_ITEM_ID	Inventory item identifier
PLAN_ID	Plan identifier
ORGANIZATION_ID	Organization identifier
SR_INSTANCE_ID	Source application instance identifier
SCHEDULE_DATE	Date of ATP

Advanced Supply Chain Planning - MSC_BIS_INV_DETAIL	MSC_BIS_INV_DETAIL contains Inventory balance details collected from source applications.
Column Name	Descritpion
PLAN_ID	Organization identifier
INVENTORY_QUANTITY	Total inventory quantity of the plan
INVENTORY_COST	Total inventory cost of the plan
MDS_COST	Tota MDS cost of the plan
MDS_PRICE	Total MDS price of the plan
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
PRODUCTION_COST	Total production cost of the plan
PURCHASING_COST	Total purchasing cost for the plan
CARRYING_COST	Total carrying cost for the plan
SERVICE_LEVEL	Service level attained for the plan
DEMAND_PENALTY_COST	Penalty cost for the plan demand
INVENTORY_VALUE	Inventory value
SUPPLIER_OVERCAP_COST	Supplier Overcap Cost
INVENTORY_VALUE_NO_POST	Inventory Value No Post
INVENTORY_VALUE_POST	Inventory Value No Post
INVENTORY_COST_POST	Inventory Value No Post
INVENTORY_COST_NO_POST	Inventory Value No Post
SR_INSTANCE_ID	Source application instance identifier
DETAIL_DATE	Detail date
INVENTORY_ITEM_ID	Inventory item identifier
PROJECT_ID	Project identifier
TASK_ID	Task identifier
MDS_QUANTITY	Total MSD quantify of the plan

Advanced Supply Chain Planning - MSC_ANSWERS	Stores the Answers for Ask Oracle Questions
Column Name	Descritpion
ANSWER_ID	Unique identifier for the row
LAST_UPDATE_LOGIN	Standard who column
QUESTION_ID	Unique identifier associated with the question
SEQ_NUM	Answer sequence number
SESSION_ID	Session unique identifier
ANSWER_TEXT	Answer text
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_CAPACITY_PLANS	MSC_CAPACITY_PLANS is a generic table used by forms for querying data. This table is used to display capacity horizontal plan information in the Planner Workbench. QUERY_ID is the query identifier used while populating the table. The QUANT
Column Name	Descritpion
QUERY_ID	Query identifier
RESOURCE_ID	Resource identifier
DEPARTMENT_NAME	Department name
DEPARTMENT_CLASS	Department class
RESOURCE_NAME	Resource name
RESOURCE_TYPE	Resource type
RESOURCE_GROUP_NAME	Resource group name
BUCKET_TYPE	Indicate the type of bucket
BUCKET_DATE	Bucket date
QUANTITY1	Generic quantity column
QUANTITY2	Generic quantity column
LAST_UPDATE_DATE	Standard Who Column
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
LAST_UPDATED_BY	Standard Who Column
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
CREATION_DATE	Standard Who Column
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
CREATED_BY	Standard Who Column
QUANTITY33	Generic quantity column
QUANTITY34	Generic quantity column
QUANTITY35	Generic quantity column
QUANTITY36	Generic quantity column
QUANTITY37
QUANTITY38
QUANTITY39
QUANTITY40
QUANTITY41
QUANTITY42
LAST_UPDATE_LOGIN	Standard Who Column
ORGANIZATION_ID	Organization identifier
SR_INSTANCE_ID	Source application instance identifier
DEPARTMENT_ID	Department identifier

Advanced Supply Chain Planning - MSC_DEMAND_CLASSES	This table stores the demand classes.
Column Name	Descritpion
DEMAND_CLASS	Demand Class
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
REQUEST_ID	Standard Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
ATTRIBUTE_CATEGORY	Attribute Category
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
MEANING	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	Description
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
FROM_DATE	From Date
TO_DATE	To Date
ENABLED_FLAG	Enabled Flag
SR_INSTANCE_ID	Source application instance identifier
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column

Advanced Supply Chain Planning - MSC_INST_PARTITIONS	This table stores the available and used instance partition information. Instance partitions are used to store the ODS data of specific instance.
Column Name	Descritpion
INSTANCE_ID	Source application identifier
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
FREE_FLAG	Free 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

Advanced Supply Chain Planning - MSC_FCTI_HEADERS_INTERFACE
Column Name	Descritpion
FCTCODE
DESCRIPTION
FCTSTATUS
HEADER_ID
ROW_STATUS
CUSTOMER_NAME
CUSTOMER_SITE_ID
CREATION_DATE
FCT_CREATION_DATE
FCTHDRID
LAST_UPDATE_DATE
CREATED_BY
LAST_UPDATED_BY
LAST_UPDATE_LOGIN

Advanced Supply Chain Planning - MSC_FCTI_LINES_INTERFACE
Column Name	Descritpion
LINE_ID
SUPPLIER_SITE_ID
ERROR_MSG
ROW_STATUS
CREATION_DATE
LAST_UPDATE_DATE
CREATED_BY
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
QUANTITY
UOM
START_DATE
END_DATE
SUPPLY_STMT_NAME
LINE_NUMBER
TYPE_CODE
PARENT_HEADER_ID
ADJ_CODE
PRIORITY
FCTLNSTATUS
ITEM_NAME
BUCKET_TYPE
CUSTOMER_NAME
CUSTOMER_ONETIME_FLAG
CUSTOMER_SITE_ID
SUPPLIER_NAME
SUPPLIER_ONETIME_FLAG

Advanced Supply Chain Planning - MSC_ALLOCATIONS	This table describes the allocations
Column Name	Descritpion
ALLOCATION_ID	Allocation identifier
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
TIME_PHASE_ID	Time Phase 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
CLASS	Dummy demand class
PARTNER_ID	Partner Id
PARTNER_SITE_ID	Partner Site Identifier
LEVEL_ID	Allocation level identifier
LEVEL_ALLOC_PERCENT	Allocation level percentage
LEVEL_PRIORITY	Allocation level priority
MIN_ALLOCATION_PERCENT	Minimum Allocation percentage
ALLOCATION_PERCENT	Allocation Percentage
MIN_LEVEL_ALLOC_PERCENT	Minimum Allocation level percentage
PRIORITY	priority of allocation
DEMAND_CLASS	demand class allocated to
SERVICE_LEVEL	service level for demand class
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_ALLOCATION_ASSIGNMENTS	This table describes the allocation assignments
Column Name	Descritpion
ASSIGNMENT_ID	Assignment Identifier
CATEGORY_SET_ID	Category Identifier to which assignment is made
INVENTORY_ITEM_ID	Item wo which assignment is made
RESOURCE_GROUP	Resource group to which assignment is made
SR_INSTANCE_ID	instance identifier
ORGANIZATION_ID	organization identifier
DEPARTMENT_ID	Department identifier
RESOURCE_ID	Resource Identifier
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ASSIGNMENT_TYPE	Type of Assignmemnt
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
ALLOCATION_RULE_NAME	Allocation rule name
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
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
CATEGORY_NAME	Category to which assignment is made

Advanced Supply Chain Planning - MSC_ALLOCATION_RULES	This table describes the allocation rules
Column Name	Descritpion
ALLOCATION_RULE_NAME	Allocation rule name
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
DESCRIPTION	Description
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
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

Advanced Supply Chain Planning - MSC_ALLOC_RULE_TIME_PHASES	This table describes the time-phased allocation rules
Column Name	Descritpion
TIME_PHASE_ID	Time phase identifier
ALLOCATION_RULE_NAME	Allocation rule name
EFFECTIVE_DATE	Date rule is effective form
DISABLE_DATE	Date that the rule gets disabled
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_ALLOC_DEMANDS
Column Name	Descritpion
INVENTORY_ITEM_ID	Item ID
ORGANIZATION_ID	Orgnaization ID
PF_DISPLAY_FLAG
ORIGINAL_ITEM_ID
ORIGINAL_ORIGINATION_TYPE
ORIGINAL_DEMAND_DATE
SOURCE_ORGANIZATION_ID
USING_ASSEMBLY_ITEM_ID
CUSTOMER_ID
SHIP_TO_SITE_ID
REFRESH_NUMBER
OLD_REFRESH_NUMBER
DEMAND_SOURCE_TYPE
REQUEST_DATE
PARENT_DEMAND_ID	Parent transaction ID
ALLOCATED_QUANTITY	Allocated Quantity
SR_INSTANCE_ID	Source instance ID
ORIGINATION_TYPE	Origin of demand. Discrete WIP demand, flow schedule_demand, etc
DEMAND_CLASS
ORDER_NUMBER	Order number
SALES_ORDER_LINE_ID	Sales order line ID
OLD_DEMAND_DATE	Old demand date (to undo changes when scheduling fails)
DEMAND_DATE	Demand date
OLD_ALLOCATED_QUANTITY	Old allocated quantity
CREATED_BY	Created by
CREATION_DATE	Creation date
LAST_UPDATED_BY	Last updated by
PLAN_ID	Plan ID
LAST_UPDATE_DATE	Last update date
DEMAND_QUANTITY	The unallocated demand quantity

Advanced Supply Chain Planning - MSC_ALLOC_SUPPLIES
Column Name	Descritpion
INVENTORY_ITEM_ID	Item ID
FROM_DEMAND_CLASS	The demand class from which the stealing has taken place
SUPPLY_QUANTITY	The unallocated supply quantity
ORGANIZATION_ID	Organization ID
SR_INSTANCE_ID	Source instance ID
ORIGINAL_ORDER_TYPE
ORIGINAL_ITEM_ID
CUSTOMER_ID
SHIP_TO_SITE_ID
REFRESH_NUMBER
OLD_REFRESH_NUMBER
ATO_MODEL_LINE_ID
DEMAND_SOURCE_TYPE
SUPPLY_DATE	Date supply is created
PARENT_TRANSACTION_ID	Parent transaction ID
ALLOCATED_QUANTITY	Allocated Quantity
PLAN_ID	Plan ID
ORDER_TYPE	Specifies type of order: planned order, purchase order, etc...
DEMAND_CLASS	Demand class supply belongs to
ORDER_NUMBER	Purchase order number
SCHEDULE_DESIGNATOR_ID	Schedule designator
SALES_ORDER_LINE_ID	Sales order line ID
OLD_SUPPLY_DATE	Old supply date (to undo changes when scheduling fails)
OLD_ALLOCATED_QUANTITY	Old allocated quantity
STEALING_FLAG	(1) If supply is stolen supply
CREATED_BY	Created By
CREATION_DATE	Creation Date
LAST_UPDATED_BY	Last updated by
LAST_UPDATE_DATE	Last update date

Advanced Supply Chain Planning - MSC_BOM_TEMP	BOM Temp Table
Column Name	Descritpion
SESSION_ID	Session Id
DISABLE_DATE	Disable Date
ASSEMBLY_IDENTIFIER	Assembly Identifier
ATP_CHECK	Atp Check
ASSEMBLY_ITEM_ID	Assembly Item Id
WIP_SUPPLY_TYPE	Wip Supply Type
COMPONENT_IDENTIFIER	Component Identifier
SMC_FLAG	Standard mandatory component flag
COMPONENT_ITEM_ID	Component Item Id
PRE_PROCESS_LT	Preprocessing Lead Time
QUANTITY	Quantity of component needed per item
SOURCE_ORGANIZATION_ID	Source Organization ID to fix Sourcing mismatch for Multi-Org ATO Models
ATP_FLAG	ATP flag value for a given item on source
FIXED_LT	Fixed Lead Time
VARIABLE_LT	Variable Lead Time
EFFECTIVE_DATE	Effective Date

Advanced Supply Chain Planning - MSC_ATP_PARAMETERS	ATP related parameters storage
Column Name	Descritpion
PRE_ALLOC_SORT_SIZE	Sort Area Size for ATP Pre-allocation
PRE_ALLOC_PARALLEL_DEGREE	Degree of parallelism for ATP Pre-allocation
CREATION_DATE	Record creation date
CREATED_BY	Record Creation userid
LAST_UPDATE_DATE	Last update date for record
LAST_UPDATE_BY	Last update userid for record
LAST_UPDATE_LOGIN	Last update login for record
PRE_ALLOC_HASH_SIZE	Hash Area Size for ATP Pre-allocation

Advanced Supply Chain Planning - MSC_ATP_SUMMARY_RES
Column Name	Descritpion
PLAN_ID	Plan ID
SD_DATE	Date of Supply/Demand
SD_QTY	Supply/Demand quantity. Negative for demands
LAST_UPDATE_DATE	Last update date
LAST_UPDATED_BY	Last updated by
CREATION_DATE	Creation Date
CREATED_BY	Created By
SR_INSTANCE_ID	Source instance ID
DEPARTMENT_ID	Department ID
RESOURCE_ID	Resource ID
ORGANIZATION_ID	Organization ID
CUSTOMER_CLASS	Customer class
CUSTOMER_ID	Customer ID
SHIP_TO_SITE_ID	Ship-to site ID
DEMAND_CLASS	Demand class

Advanced Supply Chain Planning - MSC_ATP_SUMMARY_SD
Column Name	Descritpion
PLAN_ID	Plan ID
SD_QTY	Supply/Demand quantity. negative for demands
LAST_UPDATE_DATE	Last update date
LAST_UPDATED_BY	Last updated by
CREATION_DATE	Creation date
CREATED_BY	Created By
TASK_ID	Task ID (unused)
PROJECT_ID	Project ID (unused)
PLANNING_GROUP	Planning group (unused)
SR_INSTANCE_ID	Source Instance ID
ORGANIZATION_ID	Organization ID
INVENTORY_ITEM_ID	Item ID
DEMAND_CLASS	Demand class
CUSTOMER_CLASS	Customer class
CUSTOMER_ID	Customer_ID
SHIP_TO_SITE_ID	Ship-to site ID
SD_DATE	Date of Supply/Demand

Advanced Supply Chain Planning - MSC_ATP_SUMMARY_SUP
Column Name	Descritpion
PLAN_ID	Plan ID
SD_DATE	Date of Supply/Demand
SD_QTY	Supply/Demand quantity. Negative for demands
LAST_UPDATE_DATE	Last update date
LAST_UPDATED_BY	Last updated by
CREATION_DATE	Creation date
CREATED_BY	Created by
SR_INSTANCE_ID	Source Instance ID
INVENTORY_ITEM_ID	Item ID
SUPPLIER_ID	Supplier ID
SUPPLIER_SITE_ID	Supplier site ID
CUSTOMER_CLASS	Customer class
CUSTOMER_ID	Customer ID
SHIP_TO_SITE_ID	Ship-to site ID
DEMAND_CLASS	Demand class

Advanced Supply Chain Planning - MSC_ATP_SUMMARY_SO
Column Name	Descritpion
PLAN_ID	Plan ID
SD_QTY	Supply/Demand quantity. Negative for demands
LAST_UPDATE_DATE	Last update date
LAST_UPDATED_BY	Last updated by
CREATION_DATE	Creation date
CREATED_BY	Created by
TASK_ID	Task ID (unused)
PROJECT_ID	Project ID (unused)
PLANNING_GROUP	Planning group (unused)
SR_INSTANCE_ID	Source instance ID
ORGANIZATION_ID	Organization ID
INVENTORY_ITEM_ID	Item ID
DEMAND_CLASS	Demand class
CUSTOMER_CLASS	Customer class
CUSTOMER_ID	Customer ID
SHIP_TO_SITE_ID	Ship-to site
SD_DATE	Date of Supply/Demand

Advanced Supply Chain Planning - MSC_BIS_SUPPLIER_SUMMARY	MSC_BIS_SUPPLIER_SUMMARY Stores BIS Supplier Summaruy Entries
Column Name	Descritpion
PLAN_ID	Plan Id
OVERCAP_COST	Overcap Cost
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
INVENTORY_ITEM_ID	Inventory Item Id
ORGANIZATION_ID	Organization Id
SR_INSTANCE_ID	Sr Instance Id
SUPPLIER_ID	Supplier Id
SUPPLIER_SITE_ID	Supplier Site Id
DETAIL_DATE	Detail Date
REQUIRED_QUANTITY	Required Quantity
AVAILABLE_CAPACITY	Available Capacity
UTILIZATION	Utilization

Advanced Supply Chain Planning - MSC_BIS_INV_DATE_MV_TAB	KPI Summary Table
Column Name	Descritpion
LAST_UPDATE_DATE	Standard Who Column
PURCHASING_COST	map to purchasing_cost in msc_bis_inv_detail table
DEMAND_PENALTY_COST	map to the sum of dmand_penalty_cost and supplier_overcap_cost in msc_bis_inv_detail table
CARRYING_COST	map to carrying_cost in msc_bis_inv_detail table
PLAN_ID	plan identifier
ORGANIZATION_ID	organization identifier
SR_INSTANCE_ID	source application instance identifier
DETAIL_DATE	map to detail_date in msc_bis_inv_detail table
LAST_UPDATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
MDS_PRICE	map to mds_price in msc_bis_inv_detail table
MDS_COST	map to mds_cost in msc_bis_inv_detail table
INVENTORY_COST	map to inventory_cost in msc_bis_inv_detail table
PRODUCTION_COST	map to production_cost in msc_bis_inv_detail table

Advanced Supply Chain Planning - MSC_DEMAND_MV_TAB	KPI Summary Table
Column Name	Descritpion
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
ORGANIZATION_ID	organization identifier
SR_INSTANCE_ID	source application instance identifier
DEMAND_COUNT	map the total count of independent demands in msc_demands table

Advanced Supply Chain Planning - MSC_BIS_RES_DATE_MV_TAB	KPI Summary Table
Column Name	Descritpion
LAST_UPDATE_DATE	Standard Who Column
UTILIZATION	map to average of utilization in msc_bis_res_summary
UTIL_COUNT	map to the record count in msc_bis_res_summary
UTIL_SUM	map to the sum of utilization in msc_bis_res_summary table
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
ORGANIZATION_ID	organization identifier
SR_INSTANCE_ID	source application instance identifier
RESOURCE_DATE	map to resource_date in msc_bis_res_summary table

Advanced Supply Chain Planning - MSC_BIS_INV_CAT_MV_TAB	KPI Summary Table
Column Name	Descritpion
LAST_UPDATE_DATE	Standard who column
PURCHASING_COST	map to purchasing_cost in msc_bis_inv_detail table
DEMAND_PENALTY_COST	map to the sum of demand_penalty_cost and supplier_overcap_cost in msc_bis_inv_detail table
CARRYING_COST	map to carrying_cost in msc_bis_inv_detail table
PLAN_ID	plan identifier
ORGANIZATION_ID	organization identifier
SR_INSTANCE_ID	source application instance identifier
SR_CATEGORY_ID	category id in the source instance
CATEGORY_NAME	category name
CATEGORY_SET_ID	category set identifier
DETAIL_DATE	map to detail_date from msc_bis_inv_detail table
LAST_UPDATED_BY	Standard who column
CREATION_DATE	Standard who column
CREATED_BY	Standard who column
LAST_UPDATE_LOGIN	Standard who column
MDS_PRICE	map to mds_price in msc_bis_inv_detail table
MDS_COST	map to mds_cost in msc_bis_inv_detail table
INVENTORY_COST	map to inventory_cost in msc_bis_inv_detail table
PRODUCTION_COST	map to production_cost in msc_bis_inv_detail table

Advanced Supply Chain Planning - MSC_COLL_PARAMETERS	Table to Store Collection Session Parameter Information
Column Name	Descritpion
DELETE_ODS_DATA	FLAG DELETION of ODS DATA.
NRA	NRA Flag
SAFETY_STOCK	Safety Stock Flag
SALES_ORDER	Sales Orders Flag
SOURCING_HISTORY	Sourcing History Flag
SOURCING	Sourcing Flag
SUB_INVENTORIES	Sub Inventories Flag
CUSTOMER	Customer Flag
SUPPLIER	Vendor/Supplier Flag
UNIT_NUMBERS	Unit Numbers Flag
UOM	Unit of Measure (UOM) Flag
SUPPLIER_CAPACITY	Supplier Capacity Flag
USER_SUPPLY_DEMAND	User Supply & Demand Flag
WIP	Work In Process (WIP) Flag
ATP_RULES	ATP_RULES LOAD FLAG
BOM	BOM Flag
BOR	BOR Flag
LAST_UPDATE_DATE	Last Update Timestamp for Record
LAST_UPDATED_BY	Last Update user
CREATION_DATE	Creation Timestamp for Record
CREATED_BY	Record creation User
ITEM_SUBSTITUTES	Item Substitution Flag
USER_COMP_ASSOCIATION	User Company Association
BOM_SN_FLAG	BOM Snapshot Collection Status
BOR_SN_FLAG	BOR Snapshot Collection Status
CALENDAR_CHECK	Calendar Flag
ITEM_SN_FLAG	Item Snapshot Collection Status
OH_SN_FLAG	Onhand Snapshot Collection Status
USUP_SN_FLAG	User Supply Snapshot Collection Status
UDMD_SN_FLAG	User Demand Snapshot Collection Status
SO_SN_FLAG	Sales Orders Snapshot Collection Status
FCST_SN_FLAG	Forecast Snapshot Collection Status
WIP_SN_FLAG	WIP Snapshot Collection Status
SUPCAP_SN_FLAG	Supplier Capacity Snapshot Collection Status
PO_SN_FLAG	PO Snapshot Collection Status
MDS_SN_FLAG	MDS Snapshot Collection Status
DEMAND_CLASS	Demand_Class Flag
MPS_SN_FLAG	MPS Snapshot Collection Status
NOSNAP_FLAG	Collection status for entities with no Snapshot
SUPPLIER_RESPONSE
SUPREP_SN_FLAG
FORECAST	Forecast Flag
INSTANCE_ID	Instance Id of the source of collection.
ITEM	Item Flag
KPI_TARGETS_BIS	Business Key Performance Indicator (KPI) Flag
MDS	MDS Flag
MPS	MPS Flag
OH	On Hand Flag
PARAMETER	Parameters Load Flag
PLANNERS	Planners Load Flag
PROJECTS	Projects Flag
PO	Purchase Order (PO) Flag
RESERVATIONS	Hard Reservations Flag

Advanced Supply Chain Planning - MSC_ABC_CLASSES	This table describes the classification of inventory goods into class A, B, C class types.
Column Name	Descritpion
ABC_CLASS_NAME	ABC Class Name
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
DESCRIPTION	Description
ABC_CLASS_ID	ABC Class ID
LAST_UPDATE_LOGIN	Standard WHO Column

Advanced Supply Chain Planning - MSC_COMPANY_SITE_ID_LID	This table contains the link between the company site identifier in the source and thecompany site identifier generated in APS.
Column Name	Descritpion
SR_INSTANCE_ID	Source application instance identifier
SR_COMPANY_ID	Source application company identifier
SR_COMPANY_SITE_ID	Source application company site identifier
COMPANY_SITE_ID	Company site identifier
PARTNER_TYPE	Partner type

Advanced Supply Chain Planning - MSC_COMPANY_ID_LID	Table which contains the link between the company identifier in the source ERP system and the company identifier generated in APS.
Column Name	Descritpion
SR_INSTANCE_ID	Source application instance identifier
COMPANY_ID	Company identifier
PARTNER_TYPE	Partner type
SR_COMPANY_ID	Source application company identifier

Advanced Supply Chain Planning - MSC_EXC_DETAILS_ALL	This is an Exception Details table to be populated for Plan Comparison Reports.
Column Name	Descritpion
EXCEPTION_DETAIL_ID	map to exception_detail_id in msc_exception_details table
DATE5	Generic Date 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
CHAR1	Generic Char Column
CHAR2	Generic Char Column
CHAR3	Generic Char Column
EXCEPTION_TYPE	exception type
CHAR4	Generic Char Column
CHAR5	Generic Char Column
CHAR6	Generic Char Column
CHAR7	Generic Char Column
CHAR8	Generic Char Column
CHAR9	Generic Char Column
CHAR10	Generic Char Column
CHAR11	Generic Char Column
CHAR12	Generic Char Column
CHAR13	Generic Char Column
QUANTITY	Quantity
PLAN_ID	plan identifier
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
LOAD_RATIO	load ratio
ORGANIZATION_CODE	org code
ID_KEY	exception identifier
COMPARE_KEY	field to distinguish if the exceptions are the same or changed
DATE1	Generic Date Colum
DATE2	Generic Date Column
DATE3	Generic Date Column
DATE4	Generic Date Column

Advanced Supply Chain Planning - MSC_EXCEPTION_THRESHOLDS	This table is for storing the effective date of threshold defined for seeded and custom exceptions. This table is not used presently
Column Name	Descritpion
EXCEPTION_TYPE	This can either be seeded exception type or exception id of the user defined exception
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
COMPANY_ID	Company id for which this threshold is defined
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
CONTEXT	Context for descriptive flexfield segment
FROM_DAY	Effective from date for the threshold
TO_DAY	Effective to date of the threshold
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_EXCEPTION_PREFERENCES	This table stores the order in which a user chooses to see the exception types.
Column Name	Descritpion
USER_ID	Id of the user
EXCEPTION_TYPE_LOOKUP_CODE	Exception type
RANK	rank used for ordering the exceptions
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

Advanced Supply Chain Planning - MSC_GROUP_COMPANIES	This table stores membership information of various companies in different groups.
Column Name	Descritpion
COMPANY_ID	Identifier of the company that is member of the group.
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.
EFFECTIVE_DATE	The date the membership becomes effective.
DISABLE_DATE	The date the membership expires.
CONTACT_USER	Identifier of the user that is the member's contact person for the group.
CREATION_DATE	Standard Who column.
CREATED_BY	Standard Who column.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
GROUP_ID	Unique identifier for the group.
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.

Advanced Supply Chain Planning - MSC_GROUPS	This table stores information about groups of trading partners.
Column Name	Descritpion
GROUP_NAME	Name of the group.
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	Textual description of the group.
ATTRIBUTE13	Descriptive flexfield segment.
ATTRIBUTE14	Descriptive flexfield segment.
ATTRIBUTE15	Descriptive flexfield segment.
GROUP_TYPE	Flag to specify the type of the group, 1 = Public and 2 = Private.
GROUP_OWNER_ID	Identifier of the company that is owner of the group.
OWNER_CONTACT	Identifier of the user that is the owner's contact person for the group.
CONTRACT_DOC_URL	URL pointing to contract document of the group.
EFFECTIVE_DATE	The date the group becomes effective.
DISABLE_DATE	The date the group expires.
GROUP_ID	Unique identifier for the group.
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.
ATTRIBUTE1	Descriptive flexfield segment.
ATTRIBUTE2	Descriptive flexfield segment.
ATTRIBUTE3	Descriptive flexfield segment.
ATTRIBUTE4	Descriptive flexfield segment.

Advanced Supply Chain Planning - MSC_EXCEPTION_THRESHOLD_VALUES	This table stores threshold values for each exception type. For supplier facing exceptions, the threshold values are obtained in the following order (specific to general):company_id, company_site_id, item, supplier_id, supplier_site_idcom
Column Name	Descritpion
THRESHOLD_VALUE_ID	Threshold id
COMPANY_SITE_ID	company site id
VALUE	threshold value
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
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
EXCEPTION_TYPE	Exception type
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
ASSIGNED_TO_CODE	assigned to code
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
CONTEXT	Context
INVENTORY_ITEM_ID	item id
SUPPLIER_ID	supplier id
SUPPLIER_SITE_ID	supplier site id
CUSTOMER_ID	customer id
CUSTOMER_SITE_ID	customer site id
COMPANY_ID	company id

Advanced Supply Chain Planning - MSC_BOM_BOD_INTERFACE	Interface table that contains the BOM/BOD data before validation
Column Name	Descritpion
BOM_BOD_ID	Generated by the sequence MSC_BOM_BOD_INTF_S
INVENTORY_ITEM_UOM	Contains the unit of measure of the inventory item
USAGE_QUANTITY	Contains the quantity being used
BOM_EFFECTIVITY_DATE	Contains the date the BOM becomes effective
BOM_DISABLE_DATE	Contains the date BOM is disabled
SUPPLIER_ID	Contains the party identifier of the supplier
SUPPLIER_NAME	Contains the supplier's name
AVG_TRANSIT_LEAD_TIME	Contains the average intransit lead time
SOURCING_EFFECTIVITY_DATE	Contains the date the sourcing rule becomes effective
SOURCING_DISABLE_DATE	Contains the date the sourcing rule is disabled
LAST_UPDATE_DATE	Contains the date the record was last updated
PLAN_ID	Contains the plan identifier
LAST_UPDATED_BY	Contains the use identifier of the person who last updated the record
CREATION_DATE	Contains the date the record was created
CREATED_BY	Contains the user identifier of the person who created the record
ROW_STATUS	Contains the row status after the validation
ERROR_MSG	Contains the error message in case the record fails validation
BATCH_ID	Holds the batch identifier
SR_INSTANCE_ID	Contains the source instance identifier, defaulted to -1
PARTY_ID	Contains the party identifier of the publisher
ASSEMBLY_ITEM_ID	Contains the assembly item identifier
ASSEMBLY_ITEM_NAME	Contains the assembly item name
ASSEMBLY_ITEM_UOM	Contains the unit of measure of the assembly item
INVENTORY_ITEM_ID	Contains the inventory item identifier
INVENTORY_ITEM_NAME	Contains the inventory item name

Advanced Supply Chain Planning - MSC_COMPANIES	Contains list of companies involved in collaboration
Column Name	Descritpion
COMPANY_NAME	Company name
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
DISABLE_DATE	Disable date
REFRESH_NUMBER	Refresh number
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
COMPANY_ID	Company 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

Advanced Supply Chain Planning - MSC_COMPANY_RELATIONSHIPS	Table to hold relationship between companies for interenterprise collaboration and planning.
Column Name	Descritpion
RELATIONSHIP_ID	Relationship identifier
LAST_UPDATED_BY	Standard Who column
SUBJECT_ID	Subject identifier
OBJECT_ID	Object identifier
RELATIONSHIP_TYPE	Relationship type
START_DATE	Start date
END_DATE	End date
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column

Advanced Supply Chain Planning - MSC_COMPANY_SITES	This table contains the list of company site used in interenterprise collaboration and planning.
Column Name	Descritpion
COMPANY_SITE_ID	Company site identifier
DISABLE_DATE	Disable date
PLANNING_ENABLED	Planning enabled
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
COMPANY_ID	Company identifier
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
COMPANY_SITE_NAME	Company site name
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_ID	Concurrent Who Column
PROGRAM_UPDATE_DATE	Concurrent Who Column
SR_INSTANCE_ID	Source application instance identifier
LOCATION	Location
ADDRESS1	Address 1
ADDRESS2	Address 2
ADDRESS3	Address 3
ADDRESS4	Address 4
COUNTRY	Country
STATE	State
CITY	City
COUNTY	County
PROVINCE	Province
POSTAL_CODE	Postal code
DELETED_FLAG	Deleted flag
LONGITUDE	Longitude
LATITUDE	Latitude
REFRESH_NUMBER	Refresh number

Advanced Supply Chain Planning - MSC_CRITICAL_PATHS	Table created for Improved Exceptions
Column Name	Descritpion
SR_INSTANCE_ID	Source application instance identifier
ROUTING_SEQUENCE_ID	Source application identifier for that routing
EARLIEST_START_DATE
EARLIEST_END_DATE
OPERATION_SEQUENCE_ID	Source application identifier for that operation
DEMAND_ID	Demand Identifier
SUPPLY_ID	Supply Identifier
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
PLAN_ID	Plan identifier
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
REQUEST_ID	Concurrent Who column
LEVEL_NUMBER	The level of operation in the demand
PATH_NUMBER	The number of critical in this demand
TIME_GAP	The gap between this level's operation and previous level's operations in minutes

Advanced Supply Chain Planning - MSC_FORECAST_UPDATES	This table describes the relationship between consumed forecast entries and sales order demands
Column Name	Descritpion
FORECAST_DEMAND_ID	Forecast Demand identifier
CUSTOMER_ID	Customer Id
SALES_ORDER_QTY	Sales order quantity
CONSUMED_QTY	Quantity Consumed
OVERCONSUMPTION_QTY	Over COnsumption Quantity
FORECAST_QTY	Forecast Quantity
SALES_ORDER_DATE	Sales order date
CONSUMPTION_DATE	Quantity Consumed
DEMAND_CLASS	Demand class identifier
LAST_UPDATE_DATE	Standard Who column
CREATION_DATE	Standard Who column
SALES_ORDER_ID	Sales order identifier
LAST_UPDATED_BY	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
SALES_ORDER_NUMBER	Sales order Number
ORIGINAL_ITEM_ID	Original Item Id
PLAN_ID	Plan Identifier
INVENTORY_ITEM_ID	Inventory Item Identifier
ORGANIZATION_ID	Organization Identifier
SR_INSTANCE_ID	Source application identifier
DESIGNATOR_ID	Designator identifier
SHIP_ID	Forecast ship code identifier
BILL_ID	Forecast billing address identifier

Advanced Supply Chain Planning - MSC_CALENDARS	MSC_CALENDARS stores the definition of your workday calendar.You can follow any of the four following type of quarters for your yearly calendar identified by Quarterly Calendar Type=1. 4-4-5 : quarterly pattern having two 4 weeks followedby
Column Name	Descritpion
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
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
DESCRIPTION	Description
DAYS_ON	Number of consecutive working days
DAYS_OFF	Number of consecutive non working days
CALENDAR_START_DATE	Start date of 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_ID	Source Instance id
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_CALENDAR_EXCEPTIONS	MSC_CALENDAR_EXCEPTIONS stores exception dates for a calendar. You can define these exception dates to be working or non-working days. The workday calendar program uses this information to generate your workday calendar.
Column Name	Descritpion
EXCEPTION_DATE	Should be with in the calendar start date and end date
EXCEPTION_TYPE	Exception type Possible values 1 - On 2- Off
SR_INSTANCE_ID	Source Instance ID
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
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 Id
EXCEPTION_SET_ID	Exception Set Id

Advanced Supply Chain Planning - MSC_ERRORS	Stores the Errors that have occured during the pre-processing. ERROR_ID is a unique identifier for each record. TABLE_NAME stores the staging table name in which the error occured. TRANSACTION_ID maps to ST_TRANSACTION_ID of the staging tab
Column Name	Descritpion
TRANSACTION_ID	Transaction Id from the staging table for this record
PROGRAM_ID	Concurrent WHO column
PROGRAM_UPDATE_DATE	Concurrent WHO column
MESSAGE_ID	Message Id
INSTANCE_CODE	Instance Code
TABLE_NAME	Table name in which error has occured
PROPAGATED	Flag to indicate whether the error occured for this record or was propagated to this by some related record
SOURCE	Source
RROW	Concatenated data for the errored record
ERROR_ID	Error Identifier to uniquely identify the error
ERROR_TEXT	If PROCESS_FLAG is equal to 3 for a record, then this will describe the reason for the error
SEVERITY	Severity
MESSAGE_SENT	Message Sent
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

Advanced Supply Chain Planning - MSC_COMPANY_USERS	This table contains the user company association for Oracle Collaborative planning functionality.
Column Name	Descritpion
USER_ID	User identifier
COMPANY_ID	Company identifier
SR_INSTANCE_ID	Source application instance identifier

Advanced Supply Chain Planning - MSC_ATP_PEGGING
Column Name	Descritpion
PLAN_ID
DEMAND_ID
DEMAND_QUANTITY
DISPOSITION_ID
DEMAND_CLASS
CONSUMED_QTY
OVERCONSUMPTION_QTY
SUPPLY_ID
SUPPLY_QUANTITY
ALLOCATED_QUANTITY
RESOURCE_ID
SR_INSTANCE_ID
DEPARTMENT_ID
RESOURCE_HOURS
DAILY_RESOURCE_HOURS
START_DATE
END_DATE
RELIEF_TYPE
RELIEF_QUANTITY
DAILY_RELIEF_QTY
PEGGING_ID
PREV_PEGGING_ID
REFERENCE_ITEM_ID
END_PEGGING_ID
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
CUSTOMER_ID
CUSTOMER_SITE_ID
DEMAND_SOURCE_TYPE
END_DEMAND_ID
ORIGINAL_ITEM_ID
INVENTORY_ITEM_ID
ORIGINAL_DATE
OFFSET_SUPPLY_ID
OFFSET_TYPE	Offset Type of a particular record
ORGANIZATION_ID
SALES_ORDER_LINE_ID
BOM_ITEM_TYPE
SALES_ORDER_QTY
TRANSACTION_DATE

Advanced Supply Chain Planning - MSC_GANTT_QUERY
Column Name	Descritpion
LAST_UPDATE_DATE
NODE_PATH
NODE_TYPE
NODE_LEVEL
PARENT_LINK
PLAN_ID
SR_INSTANCE_ID
ORGANIZATION_ID
TRANSACTION_ID
OP_SEQ_ID
OP_SEQ_NUM
LAST_UPDATED_BY
OP_DESC
DEPENDENCY_TYPE
CRITICAL_FLAG
INVENTORY_ITEM_ID
SUPPLIER_ID
SUPPLIER_SITE_ID
DEPARTMENT_ID
RESOURCE_ID
RES_INSTANCE_ID
SERIAL_NUMBER
CREATION_DATE
IS_FETCHED
ROW_FLAG
CREATED_BY
LAST_UPDATE_LOGIN
QUERY_ID
ROW_INDEX
CHILD_QUERY_ID
SORT_INDEX

Advanced Supply Chain Planning - MSC_INT_10_TV
Column Name	Descritpion
OI__BRANCH_CODE
OI__RESOURCE_SET_CODE
OI__OPERATION_CODE
OI__RESOURCE_GROUP_NAME
OI__SAFETY_LEVEL
OI__RESOURCE_CODE
A__EFFECTIVE_DATE
OI__ITEM_CODE
OI__CAPACITY_REQUIRED
OI__REQUIRED
OI__PLAN_NAME

Advanced Supply Chain Planning - MSC_INT_11_E
Column Name	Descritpion
OI__WORK_ORDER_CODE
OI__END_TIME_OFFSET
OI__PARENT_WORK_ORDER_CODE
OI__9
OI__BRANCH_CODE
OI__OPERATION_SET_NAME
OI__CONSUMED_ITEM_SET
OI__ITEM_CODE
OI__QUANTITY
OI__REMAINING_QUANTITY
OI__SCRAP_FACTOR
OI__LEAD_TIME_OFFSET

Advanced Supply Chain Planning - MSC_INT_12_E
Column Name	Descritpion
OI__WORK_ORDER_CODE
OI__END_TIME_OFFSET
OI__10
OI__PARENT_WORK_ORDER_CODE
OI__13
OI__YIELD
OI__BRANCH_CODE
OI__OPERATION_SET_NAME
OI__CONSUMED_ITEM_SET
OI__ITEM_CODE
OI__QUANTITY
OI__REMAINING_QUANTITY
OI__SCRAP_FACTOR
OI__LEAD_TIME_OFFSET

Advanced Supply Chain Planning - MSC_INT_13_TV_SNO
Column Name	Descritpion
OI__CUSTOMER_CODE
OI__USE_COVER_FOR_MAXIMUM
OI__MAXIMUM_COVERAGE
OI__MAXIMUM_LEVEL
OI__AVAILABLE
OI__ITEM_CODE
OI__TRANSPORT_MODE_CODE
OI__SUBSTITUTE_ITEM_CODE
OI__BRANCH_CODE
OI__MINIMUM_LEVEL
A__START_DATE
A__END_DATE
OI__STOCKOUT_COST
OI__COST
OI__PREFERENCE
OI__USE_COVER_FOR_SAFETY

Advanced Supply Chain Planning - MSC_INT_14_E_SNO
Column Name	Descritpion
OI__ITEM_CODE
OI__BRANCH_CODE
OI__RATIO
OI__LANE_CODE
OI__SUBSTITUTE_ITEM_CODE
OI__TRANSPORT_MODE_CODE
OI__AVAILABILITY_CALENDAR
OI__MULTIPLE
OI__SHIP_MULTIPLE
OI__MINIMUM_SHIPMENT
OI__DEPLOYMENT_PULL_FORWARD
OI__CUSTOMER_CODE

Advanced Supply Chain Planning - MSC_INT_15_TV_SNO
Column Name	Descritpion
OI__CUSTOMER_CODE
OI__ITEM_CODE
OI__SUBSTITUTE_ITEM_CODE
OI__BRANCH_CODE
A__START_DATE
A__END_DATE
OI__COST
OI__PREFERENCE

Advanced Supply Chain Planning - MSC_INT_16_E_SNO
Column Name	Descritpion
OI__ITEM_CODE
OI__AVAILABLE_DATE
OI__STORAGE_NAME
OI__QUALITY_CODE
OI__USER_COMMENT
OI__LOT_STATUS
OI__LANE_CODE
OI__LOT_NUMBER
OI__TRANSPORT_MODE_CODE
OI__AVAILABILITY_CALENDAR
OI__STATUS_DATE
OI__SHIP_MULTIPLE
OI__MINIMUM_SHIPMENT
OI__QUANTITY
OI__DEPLOYMENT_PULL_FORWARD
OI__MANUFACTURING_DATE
OI__BRANCH_CODE
OI__EXPIRY_DATE

Advanced Supply Chain Planning - MSC_INT_17_TV_SNO
Column Name	Descritpion
OI__CUSTOMER_CODE
OI__ITEM_CODE
OI__BRANCH_CODE
A__START_DATE
A__END_DATE
OI__PREFERENCE
OI__LEAD_TIME

Advanced Supply Chain Planning - MSC_INT_18_E_SNO
Column Name	Descritpion
OI__FORECAST_CODE
OI__WEIGHT_CAPACITY_UOM
OI__CUSTOMER_CODE
OI__VOLUME_CAPACITY_UOM
OI__LEAD_TIME_UOM
OI__DESCRIPTION
OI__BRANCH_CODE
OI__SUBSTITUTE_ITEM_CODE
OI__TRANSPORT_MODE_CODE
OI__CREATED_DATE
OI__FORECAST_SOURCE
OI__RATIO
OI__START_DATE
OI__NUMBER_OF_PERIODS
OI__ITEM_CODE
OI__PERIOD_SIZE
OI__MULTIPLE

Advanced Supply Chain Planning - MSC_INT_20_E_SNO
Column Name	Descritpion
OI__PLAN_NAME
OI__TRANSPORT_MODE_CODE
OI__ITEM_CODE
OI__AVAILABILITY_CALENDAR
OI__BRANCH_CODE
OI__COVERAGE_UNIT
OI__LANE_CODE
OI__SHIP_MULTIPLE
OI__MINIMUM_SHIPMENT
OI__DEPLOYMENT_PULL_FORWARD
OI__CUSTOMER_CODE

Advanced Supply Chain Planning - MSC_INT_1_E
Column Name	Descritpion
OI__STORAGE_REQUIREMENT

Advanced Supply Chain Planning - MSC_INT_21_E_SNO
Column Name	Descritpion
OI__FORECAST_CODE
OI__DESCRIPTION
OI__CREATED_DATE
OI__FORECAST_SOURCE
OI__START_DATE
OI__NUMBER_OF_PERIODS
OI__PERIOD_SIZE

Advanced Supply Chain Planning - MSC_INT_19_TV_SNO
Column Name	Descritpion
OI__OPERATION_CODE
OI__LEAD_TIME
OI__COST
OI__AVAILABLE
OI__CUSTOMER_CODE
OI__TRANSPORT_MODE_CODE
OI__WEIGHT_CAPACITY
OI__ITEM_CODE
OI__SUBSTITUTE_ITEM_CODE
OI__VOLUME_CAPACITY
OI__QUANTITY
OI__BRANCH_CODE
OI__TRANSACTION_ID
A__START_DATE
A__END_DATE
OI__PRODUCTION_OVERHEAD_COST
OI__COST_PER_WEIGHT_UNIT
OI__PREFERENCE
OI__COST_PER_VOLUME_UNIT

Advanced Supply Chain Planning - MSC_INT_22_E_SNO
Column Name	Descritpion
OI__BRANCH_OR_GROUP
OI__BRANCH_CODE
OI__ROUTING_CODE
OI__FORECAST_CODE
OI__OPERATION_SET_CODE
OI__PREFERRED_OPERATION
OI__SUBSTITUTE_ITEM_CODE
OI__MULTIPLE
OI__RATIO
OI__CUSTOMER_CODE
OI__ITEM_CODE

Advanced Supply Chain Planning - MSC_INT_25_E_SNO
Column Name	Descritpion
OI__SUPPLIER_CODE
OI__ORDER_POLICY
OI__DEMAND_COVERAGE_UNITS
OI__FORECAST_CODE
OI__NUMBER_OF_PERIODS
OI__DESCRIPTION
OI__FORECAST_SOURCE
OI__BRANCH_CODE
OI__START_DATE
OI__PLAN_NAME
OI__PERIOD_SIZE
OI__CREATED_DATE
OI__ITEM_CODE
OI__LEAD_TIME_UOM
OI__COVERAGE_UNIT
OI__ORDER_MULTIPLE
OI__SHIPPING_CALENDAR
OI__SAFETY_COVERAGE
OI__RECEIVING_CALENDAR
OI__MINMAX_ORDER_PERIOD
OI__MINMAX_ORDER_PERIOD_UNIT

Advanced Supply Chain Planning - MSC_INT_26_TV_SNO
Column Name	Descritpion
OI__SUPPLIER_CODE
OI__MAXIMUM_PERIOD_ORDER
OI__FIXED_ORDER_QUANTITY
OI__DEMAND_COVERAGE_ORDER
OI__QUANTITY
OI__STANDARD_LEAD_TIME
OI__PREMIUM_LEAD_TIME
OI__BRANCH_CODE
OI__ITEM_CODE
A__START_DATE
OI__PLAN_NAME
A__END_DATE
OI__PREFERENCE
OI__STANDARD_COST
OI__PREMIUM_COST
OI__SAFETY_LEVEL
OI__MINIMUM_PERIOD_ORDER

Advanced Supply Chain Planning - MSC_INT_27_TV_SNO
Column Name	Descritpion
OI__BRANCH_CODE
OI__OPERATION_CODE
A__START_DATE
A__END_DATE
OI__PRODUCTION_OVERHEAD_COST
OI__AVAILABLE
OI__OVERHEAD_COST
OI__ITEM_CODE

Advanced Supply Chain Planning - MSC_INT_24_E_SNO
Column Name	Descritpion
OI__BRANCH_OR_GROUP
OI__PLAN_NAME
OI__CREATED_DATE
OI__NUMBER_OF_PERIODS
OI__TRANSPORT_MODE_CODE
OI__ITEM_CODE
OI__ROUTING_CODE
OI__LANE_CODE
OI__PLAN_SOURCE
OI__AVAILABILITY_CALENDAR
OI__OPERATION_SET_CODE
OI__PREFERRED_OPERATION
OI__PERIOD_SIZE
OI__SHIP_MULTIPLE
OI__MINIMUM_SHIPMENT
OI__SNAPSHOT_DATE
OI__DEPLOYMENT_PULL_FORWARD
OI__DESCRIPTION

Advanced Supply Chain Planning - MSC_INT_23_TV_SNO
Column Name	Descritpion
OI__BRANCH_CODE
OI__PREFERENCE
OI__CUSTOMER_CODE
OI__SUBSTITUTE_ITEM_CODE
OI__OPERATION_CODE
OI__FORECAST_CODE
OI__COST
OI__RESOURCE_GROUP_NAME
OI__RESOURCE_SET_CODE
A__START_DATE
OI__RESOURCE_CODE
A__END_DATE
OI__AVAILABLE
OI__OVERHEAD_COST
OI__QUANTITY
OI__CAPACITY_REQUIRED
OI__ITEM_CODE
OI__REQUIRED

Advanced Supply Chain Planning - MSC_INT_28_TV_SNO
Column Name	Descritpion
OI__SUPPLIER_CODE
OI__MAXIMUM_PERIOD_ORDER
OI__PLAN_NAME
OI__FIXED_ORDER_QUANTITY
OI__DEMAND_COVERAGE_ORDER
OI__SCRAP
OI__STANDARD_LEAD_TIME
OI__PREMIUM_LEAD_TIME
OI__SAFETY_LEVEL
OI__SAFETY_COVERAGE
OI__QUANTITY
OI__BRANCH_CODE
OI__CONSUMPTION_OVERHEAD_COST
OI__ITEM_CODE
A__START_DATE
OI__CONSUMED_ITEM_SET_CODE
A__END_DATE
OI__PREFERENCE
OI__AVAILABLE
OI__STANDARD_COST
OI__PREMIUM_COST
OI__OPERATION_CODE
OI__MINIMUM_PERIOD_ORDER

Advanced Supply Chain Planning - MSC_INT_29_E_SNO
Column Name	Descritpion
OI__SUPPLIER_CODE
OI__ORDER_POLICY
OI__DEMAND_COVERAGE_UNITS
OI__BRANCH_CODE
OI__BRANCH_OR_GROUP
OI__ITEM_CODE
OI__LEAD_TIME_UOM
OI__ROUTING_CODE
OI__ORDER_MULTIPLE
OI__SHIPPING_CALENDAR
OI__PREFERRED_OPERATION
OI__RECEIVING_CALENDAR
OI__MINMAX_ORDER_PERIOD
OI__OPERATION_SET_CODE
OI__MINMAX_ORDER_PERIOD_UNIT

Advanced Supply Chain Planning - MSC_INT_30_TV_SNO
Column Name	Descritpion
OI__SUPPLIER_CODE
OI__MAXIMUM_PERIOD_ORDER
OI__FIXED_ORDER_QUANTITY
OI__DEMAND_COVERAGE_ORDER
OI__QUANTITY
OI__STANDARD_LEAD_TIME
OI__PREMIUM_LEAD_TIME
OI__OPERATION_CODE
OI__CONSUMPTION_OVERHEAD_COST
OI__BRANCH_CODE
OI__OVERHEAD_COST
OI__ITEM_CODE
A__START_DATE
OI__CONSUMED_ITEM_SET_CODE
A__END_DATE
OI__PREFERENCE
OI__SCRAP
OI__STANDARD_COST
OI__PREMIUM_COST
OI__AVAILABLE
OI__MINIMUM_PERIOD_ORDER

Advanced Supply Chain Planning - MSC_INT_2_E
Column Name	Descritpion
OI__BRANCH_CODE
OI__ITEM_CODE
OI__SUBSTITUTE_ITEM_CODE
OI__RATIO
OI__MULTIPLE

Advanced Supply Chain Planning - MSC_ATP_DETAIL_PEG_TEMP
Column Name	Descritpion
REFERENCE_ITEM_ID
VARIABLE_LT
SALES_ORDER_LINE_ID
SALES_ORDER_QTY
DEMAND_ID
DEMAND_DATE
DEMAND_QUANTITY
DISPOSITION_ID
DEMAND_CLASS
DEMAND_TYPE
ORIGINAL_DEMAND_ID
BASE_ITEM_ID
FCST_ORGANIZATION_ID
FORECAST_QTY
CONSUMED_QTY
OVERCONSUMPTION_QTY
PROCESS_SEQ_ID
SUPPLY_ID
SUPPLY_DATE
SUPPLY_QUANTITY
ALLOCATED_QUANTITY
TOT_RELIEF_QTY
INVENTORY_ITEM_ID
SUPPLY_TYPE
FIRM_PLANNED_TYPE
RELEASE_STATUS
EXCLUDE_FLAG
ORDER_NUMBER
END_PEGGING_ID
PEGGING_ID
PREV_PEGGING_ID
DEMAND_SOURCE_TYPE
END_DEMAND_ID
PLAN_ID
ATF_DATE
PRODUCT_FAMILY_ID
SR_INSTANCE_ID
ORGANIZATION_ID
END_ITEM_USAGE
BOM_ITEM_TYPE
FIXED_LT

Advanced Supply Chain Planning - MSC_ANALYSIS_QUERY
Column Name	Descritpion
QUERY_ID
ORG_LIST
INST_ID
ORG_ID
ORG_CODE
ORG_LIST_STATE
TOP_ITEM_ID
TOP_ITEM_NAME
ITEM_ID
ITEM_NAME
TOP_ITEM_NAME_STATE
ROW_INDEX
DTL_QUERY_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
PARENT_ROW_INDEX
REGION_LIST_ID
REGION_LIST
REGION_ID
REGION_CODE
REGION_LIST_STATE
ORG_LIST_ID

Advanced Supply Chain Planning - MSC_DELIVERY_DETAILS
Column Name	Descritpion
SR_INSTANCE_ID
ORGANIZATION_ID
SHIP_TO_LOCATION_ID
SHIP_TO_SITE_USE_ID
DELIVER_TO_LOCATION_ID
DELIVER_TO_SITE_USE_ID
CANCELLED_QUANTITY
REQUESTED_QUANTITY
REQUESTED_QUANTITY_UOM
SHIPPED_QUANTITY
DELIVERED_QUANTITY
DELIVERY_DETAIL_ID
DATE_REQUESTED
DATE_SCHEDULED
OPERATING_UNIT
INV_INTERFACED_FLAG
EARLIEST_PICKUP_DATE
LATEST_PICKUP_DATE
EARLIEST_DROPOFF_DATE
LATEST_DROPOFF_DATE
REFRESH_NUMBER
LAST_UPDATE_DATE
SOURCE_CODE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
SOURCE_HEADER_ID
SOURCE_LINE_ID
SOURCE_HEADER_NUMBER
SHIP_SET_ID
ARRIVAL_SET_ID
SHIP_FROM_LOCATION_ID

Advanced Supply Chain Planning - MSC_DEMANDS_CUM_F
Column Name	Descritpion
PLAN_ID
CUM_SALES_ORDER_QTY
CUM_QTY_BY_DUE_DATE
CUM_FORECAST_QTY
ORDER_DATE
DEMAND_CLASS
CUM_QTY_BY_DUE_DATE_VALUE
CUM_QTY_BY_DUE_DATE_VALUE2
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
PLAN_RUN_ID
LAST_UPDATE_DATE
BACKLOG_QTY
PROGRAM_ID
PROGRAM_LOGIN_ID
PROGRAM_APPLICATION_ID
REQUEST_ID
LAST_UPDATE_LOGIN
CUM_CONSTRAINED_FCST_VALUE
CUM_CONSTRAINED_FCST_VALUE2
OWNING_ORG_ID
SR_INSTANCE_ID
OWNING_INST_ID
IO_PLAN_FLAG
REGION_ID
AGGR_TYPE
CATEGORY_SET_ID
SR_CATEGORY_ID
ORIGINAL_ITEM_ID
ORGANIZATION_ID
VMI_FLAG
INVENTORY_ITEM_ID
CUSTOMER_ID
CUM_CONSTRAINED_FCST
CUSTOMER_SITE_ID

Advanced Supply Chain Planning - MSC_DEMANDS_F
Column Name	Descritpion
PLAN_ID
DEMAND_CLASS
ORDER_DATE
ORDER_TYPE
VMI_FLAG
DEMAND_QTY
QTY_BY_DUE_DATE
INDEP_DEMAND_COUNT
INDEP_MET_ONTIME_COUNT
INDEP_MET_FULL_COUNT
INDEP_DEMAND_VALUE
PLAN_RUN_ID
INDEP_DEMAND_VALUE2
REGION_ID
INDEP_DEMAND_QTY
INDEP_BY_DUE_DATE_QTY
SALES_ORDER_QTY
SALES_ORDER_COUNT
SALES_ORDER_METR_COUNT
SALES_ORDER_META_COUNT
FORECAST_QTY
LATE_DMD_STF_FACTOR
LATE_ORDER_COUNT
SR_INSTANCE_ID
LATE_ORDER_VALUE
LATE_ORDER_VALUE2
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
PROGRAM_ID
PROGRAM_LOGIN_ID
PROGRAM_APPLICATION_ID
ORGANIZATION_ID
REQUEST_ID
SALES_ORDER_PD_VALUE2
ZONE_ID
QTY_BY_DUE_DATE_VALUE
QTY_BY_DUE_DATE_VALUE2
IO_DELIVERED_QTY
IO_REQUIRED_QTY
NET_DEMAND
CONSTRAINED_FCST
CONSTRAINED_FCST_VALUE
CONSTRAINED_FCST_VALUE2
INVENTORY_ITEM_ID
OWNING_ORG_ID
OWNING_INST_ID
IO_PLAN_FLAG
PART_CONDITION
AGGR_TYPE
CATEGORY_SET_ID
SR_CATEGORY_ID
SERVICE_LEVEL
ORIGINAL_ITEM_ID
ITEM_PARENT_DEMAND
PROJECT_ID
ITEM_PARENT_DEMAND_VALUE
DEMAND_FULFILLMENT_LEAD_TIME
ANNUALIZED_COGS
SALES_ORDER_RD
SALES_ORDER_RD_VALUE
SALES_ORDER_RD_VALUE2
SALES_ORDER_PD
SALES_ORDER_PD_VALUE
LATE_ORDER_QTY
SALES_ORDER_SD
TASK_ID
SALES_ORDER_SD_VALUE
SALES_ORDER_SD_VALUE2
CUSTOMER_ID
CUSTOMER_SITE_ID

Advanced Supply Chain Planning - MSC_DEMANTRA_F
Column Name	Descritpion
ODS_PLAN_ID
START_DATE
CONSENSUS_FCST
CONSENSUS_FCST_VALUE
CONSENSUS_FCST_VALUE2
CONSENSUS_FCST_CUM
PRIORITY
REGION_ID
OWNING_ORG_ID
AGGR_TYPE
CATEGORY_SET_ID
PLAN_ID
SR_CATEGORY_ID
CREATED_BY
CREATION_DATE
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
PROGRAM_ID
PROGRAM_LOGIN_ID
PROGRAM_APPLICATION_ID
PLAN_RUN_ID
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
SR_INSTANCE_ID
OWNING_INST_ID
ORGANIZATION_ID
CUSTOMER_ID
REQUEST_ID
CUSTOMER_SITE_ID
INVENTORY_ITEM_ID
DEMAND_CLASS

Advanced Supply Chain Planning - MSC_EXCEPTIONS_F
Column Name	Descritpion
PLAN_ID
CUSTOMER_ID
CUSTOMER_SITE_ID
PROJECT_ID
TASK_ID
ANALYSIS_DATE
EXCEPTION_TYPE
EXCEPTION_COUNT
EXCEPTION_VALUE
EXCEPTION_VALUE2
EXCEPTION_DAYS
PLAN_RUN_ID
EXCEPTION_QUANTITY
RESOURCE_GROUP
EXCEPTION_RATIO
CREATED_BY
CREATION_DATE
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
PROGRAM_ID
PROGRAM_LOGIN_ID
PROGRAM_APPLICATION_ID
SR_INSTANCE_ID
REQUEST_ID
OWNING_ORG_ID
OWNING_INST_ID
CUSTOMER_REGION_ID
SUPPLIER_REGION_ID
SHIP_METHOD
AGGR_TYPE
CATEGORY_SET_ID
VMI_FLAG
ORDER_TYPE
ORGANIZATION_ID
SR_CATEGORY_ID
INVENTORY_ITEM_ID
DEPARTMENT_ID
RESOURCE_ID
SUPPLIER_ID
SUPPLIER_SITE_ID

Advanced Supply Chain Planning - MSC_HUB_QUERY
Column Name	Descritpion
QUERY_ID
DATE4
NUMBER1
NUMBER2
NUMBER3
NUMBER4
NUMBER5
NUMBER6
NUMBER7
NUMBER8
NUMBER9
LAST_UPDATE_DATE
NUMBER10
NUMBER11
NUMBER12
NUMBER13
NUMBER14
NUMBER15
NUMBER16
NUMBER17
NUMBER18
NUMBER19
LAST_UPDATED_BY
NUMBER20
NUMBER21
NUMBER22
NUMBER23
NUMBER24
NUMBER25
CHAR1
CHAR2
CHAR3
DATE5
CREATION_DATE
BLOB1
NUMBER26
NUMBER27
NUMBER28
NUMBER29
NUMBER30
NUMBER31
NUMBER32
NUMBER33
CREATED_BY
LAST_UPDATE_LOGIN
DATE1
DATE2
DATE3

Advanced Supply Chain Planning - MSC_INT_13_E
Column Name	Descritpion
OI__WORK_ORDER_CODE
OI__PARENT_WORK_ORDER_CODE
OI__14
OI__BRANCH_CODE
OI__OPERATION_SET_NAME
OI__ITEM_CODE
OI__QUANTITY
OI__REMAINING_QUANTITY
OI__YIELD
OI__LEAD_TIME_OFFSET
OI__END_TIME_OFFSET

Advanced Supply Chain Planning - MSC_INT_14_TV_SNO
Column Name	Descritpion
OI__ITEM_CODE
OI__USE_COVER_FOR_MAXIMUM
OI__MAXIMUM_COVERAGE
OI__MAXIMUM_LEVEL
OI__CUSTOMER_CODE
OI__BRANCH_CODE
OI__TRANSPORT_MODE_CODE
OI__MINIMUM_LEVEL
A__START_DATE
A__END_DATE
OI__STOCKOUT_COST
OI__PREFERENCE
OI__AVAILABLE
OI__USE_COVER_FOR_SAFETY

Advanced Supply Chain Planning - MSC_INT_11_TV
Column Name	Descritpion
OI__SUPPLIER_CODE
OI__FIXED_ORDER_QUANTITY
OI__DEMAND_COVERAGE_ORDER
OI__STANDARD_LEAD_TIME
OI__PREMIUM_LEAD_TIME
OI__BRANCH_CODE
OI__ITEM_CODE
A__EFFECTIVE_DATE
OI__PREFERENCE
OI__STANDARD_COST
OI__PREMIUM_COST
OI__MINIMUM_PERIOD_ORDER
OI__MAXIMUM_PERIOD_ORDER

Advanced Supply Chain Planning - MSC_INT_15_E_SNO
Column Name	Descritpion
OI__FORECAST_CODE
OI__ITEM_CODE
OI__SUBSTITUTE_ITEM_CODE
OI__DESCRIPTION
OI__RATIO
OI__CREATED_DATE
OI__FORECAST_SOURCE
OI__CUSTOMER_CODE
OI__START_DATE
OI__NUMBER_OF_PERIODS
OI__MULTIPLE
OI__PERIOD_SIZE
OI__BRANCH_CODE

Advanced Supply Chain Planning - MSC_INT_16_TV_SNO
Column Name	Descritpion
OI__ITEM_CODE
OI__BRANCH_CODE
A__START_DATE
A__END_DATE
OI__QUANTITY
OI__CUSTOMER_CODE
OI__COST
OI__PREFERENCE
OI__SUBSTITUTE_ITEM_CODE

Advanced Supply Chain Planning - MSC_INT_17_E_SNO
Column Name	Descritpion
OI__PLAN_NAME
OI__AVAILABLE_DATE
OI__STORAGE_NAME
OI__QUALITY_CODE
OI__USER_COMMENT
OI__LOT_NUMBER
OI__FORECAST_CODE
OI__DESCRIPTION
OI__ITEM_CODE
OI__CREATED_DATE
OI__LOT_STATUS
OI__FORECAST_SOURCE
OI__BRANCH_CODE
OI__COVERAGE_UNIT
OI__START_DATE
OI__NUMBER_OF_PERIODS
OI__STATUS_DATE
OI__PERIOD_SIZE
OI__MANUFACTURING_DATE
OI__QUANTITY
OI__EXPIRY_DATE

Advanced Supply Chain Planning - MSC_INT_21_TV_SNO
Column Name	Descritpion
OI__BRANCH_CODE
OI__AVAILABLE
OI__PRODUCTION_OVERHEAD_COST
OI__PREFERENCE
OI__RESOURCE_SET_CODE
OI__OPERATION_CODE
OI__RESOURCE_GROUP_NAME
OI__CUSTOMER_CODE
OI__RESOURCE_CODE
A__START_DATE
OI__TRANSPORT_MODE_CODE
A__END_DATE
OI__CAPACITY_REQUIRED
OI__ITEM_CODE
OI__REQUIRED

Advanced Supply Chain Planning - MSC_INT_27_E_SNO
Column Name	Descritpion
OI__SUPPLIER_CODE
OI__ORDER_POLICY
OI__DEMAND_COVERAGE_UNITS
OI__BRANCH_CODE
OI__PLAN_NAME
OI__ITEM_CODE
OI__LEAD_TIME_UOM
OI__ORDER_MULTIPLE
OI__SHIPPING_CALENDAR
OI__COVERAGE_UNIT
OI__RECEIVING_CALENDAR
OI__MINMAX_ORDER_PERIOD
OI__MINMAX_ORDER_PERIOD_UNIT

Advanced Supply Chain Planning - MSC_INT_29_TV_SNO
Column Name	Descritpion
OI__OPERATION_CODE
OI__ITEM_CODE
OI__BRANCH_CODE
A__START_DATE
A__END_DATE
OI__PRODUCTION_OVERHEAD_COST

Advanced Supply Chain Planning - MSC_ANALYSIS_AGGREGATE
Column Name	Descritpion
PLAN_ID
USERDEF_SAFETY_STOCK_DOLLARS
USERDEF_SAFETY_STOCK_DOS
ACHIEVED_SERVICE_LEVEL
ACHIEVED_SERVICE_LEVEL_QTY1
ACHIEVED_SERVICE_LEVEL_QTY2
TARGET_SERVICE_LEVEL
INVENTORY_VALUE_DOLLARS
PERIOD_TYPE
WEEK_START_DATE
PERIOD_START_DATE
RECORD_TYPE
SR_INSTANCE_ID
ORGANIZATION_ID
SR_CAT_INSTANCE_ID
SR_CATEGORY_ID
CATEGORY_NAME
INVENTORY_ITEM_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
SAFETY_STOCK_QTY
LAST_UPDATE_LOGIN
TOTAL_UNPOOLED_SAFETY_STOCK
DEMAND_VAR_SS_PERCENT
MFG_LTVAR_SS_PERCENT
TRANSIT_LTVAR_SS_PERCENT
SUP_LTVAR_SS_PERCENT
DEMAND_CLASS
CATEGORY_SET_ID
PLANNED_PRODUCTION_COST
PLANNED_CARRYING_COST
SAFETY_STOCK_DOLLARS
PLANNED_PURCHASING_COST
PLANNED_TP_COST
PLANNED_TOTAL_COST
PLANNED_REVENUE
PLAN_NAME
DETAIL_LEVEL
CATEGORY_ID
SAFETY_STOCK_DOS
TARGET_SAFETY_STOCK_QTY
TARGET_SAFETY_STOCK_DOLLARS
TARGET_SAFETY_STOCK_DOS
USERDEF_SAFETY_STOCK_QTY

Advanced Supply Chain Planning - MSC_BUDGETS_F
Column Name	Descritpion
PLAN_ID
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
PROGRAM_ID
PROGRAM_LOGIN_ID
PROGRAM_APPLICATION_ID
REQUEST_ID
BUDGET_VALUE2
PLAN_RUN_ID
BUDGET_LEVEL
SR_INSTANCE_ID
ORGANIZATION_ID
CATEGORY_SET_ID
CATEGORY_INSTANCE_ID
SR_CATEGORY_ID
BUDGET_VALUE

Advanced Supply Chain Planning - MSC_COSTS_F
Column Name	Descritpion
PLAN_ID
CUSTOMER_REGION_ID
SUPPLIER_ID
SUPPLIER_SITE_ID
SUPPLIER_REGION_ID
IO_PLAN_FLAG
SHIP_METHOD
DETAIL_DATE
REVENUE
REVENUE2
MANUFACTURING_COST
PLAN_RUN_ID
MANUFACTURING_COST2
PURCHASING_COST
PURCHASING_COST2
TRANSPORTATION_COST
TRANSPORTATION_COST2
CARRYING_COST
CARRYING_COST2
SUPPLY_CHAIN_COST
SUPPLY_CHAIN_COST2
GROSS_MARGIN
SR_INSTANCE_ID
GROSS_MARGIN2
FIXED_COST
FIXED_COST2
AGGR_TYPE
CATEGORY_SET_ID
SR_CATEGORY_ID
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
ORGANIZATION_ID
LAST_UPDATE_LOGIN
PROGRAM_ID
PROGRAM_LOGIN_ID
PROGRAM_APPLICATION_ID
REQUEST_ID
OWNING_INST_ID
OWNING_ORG_ID
FACILITY_COST
FACILITY_COST2
ITEM_TRAVEL_DISTANCE
INVENTORY_ITEM_ID
SOURCE_COUNT
RISK_ITEM_COUNT
CTB_MAKE_ORDER_CNT
TOTAL_MAKE_ORDER_CNT
AVAIL_COMPONENT_QTY
TOTAL_COMPONENT_QTY
READY_TO_BUILD_QTY
TOTAL_BUILD_QTY
SOURCE_ORG_INSTANCE_ID
SOURCE_ORGANIZATION_ID
CUSTOMER_ID
CUSTOMER_SITE_ID

Advanced Supply Chain Planning - MSC_INT_11_E_SNO
Column Name	Descritpion
OI__BRANCH_CODE
OI__ITEM_CODE
OI__SUBSTITUTE_ITEM_CODE
OI__RATIO
OI__MULTIPLE

Advanced Supply Chain Planning - MSC_INT_10_E_SNO
Column Name	Descritpion
OI__ITEM_CODE
OI__AVAILABLE_DATE
OI__QUALITY_CODE
OI__USER_COMMENT
OI__BRANCH_CODE
OI__RATIO
OI__LOT_NUMBER
OI__STORAGE_NAME
OI__MULTIPLE
OI__QUANTITY
OI__LOT_STATUS
OI__SUBSTITUTE_ITEM_CODE
OI__STATUS_DATE
OI__MANUFACTURING_DATE
OI__EXPIRY_DATE

Advanced Supply Chain Planning - MSC_INT_10_TV_SNO
Column Name	Descritpion
OI__ITEM_CODE
OI__USE_COVER_FOR_MAXIMUM
OI__BRANCH_CODE
A__START_DATE
A__END_DATE
OI__MAXIMUM_LEVEL
OI__MINIMUM_LEVEL
OI__STOCKOUT_COST
OI__MAXIMUM_COVERAGE
OI__USE_COVER_FOR_SAFETY

Advanced Supply Chain Planning - MSC_INT_11_TV_SNO
Column Name	Descritpion
OI__ITEM_CODE
OI__SUBSTITUTE_ITEM_CODE
OI__CUSTOMER_CODE
OI__BRANCH_CODE
OI__TRANSPORT_MODE_CODE
OI__COST
A__START_DATE
A__END_DATE
OI__PREFERENCE
OI__AVAILABLE

Advanced Supply Chain Planning - MSC_INT_12_TV_SNO
Column Name	Descritpion
OI__BRANCH_CODE
OI__ITEM_CODE
OI__SUBSTITUTE_ITEM_CODE
A__START_DATE
A__END_DATE
OI__COST
OI__PREFERENCE

Advanced Supply Chain Planning - MSC_INT_12_E_SNO
Column Name	Descritpion
OI__CUSTOMER_CODE
OI__AVAILABLE_DATE
OI__QUALITY_CODE
OI__USER_COMMENT
OI__STORAGE_NAME
OI__ITEM_CODE
OI__LOT_STATUS
OI__SUBSTITUTE_ITEM_CODE
OI__BRANCH_CODE
OI__LOT_NUMBER
OI__MULTIPLE
OI__RATIO
OI__QUANTITY
OI__STATUS_DATE
OI__MANUFACTURING_DATE
OI__EXPIRY_DATE

Advanced Supply Chain Planning - MSC_INT_13_E_SNO
Column Name	Descritpion
OI__ITEM_CODE
OI__AVAILABLE_DATE
OI__QUALITY_CODE
OI__USER_COMMENT
OI__BRANCH_CODE
OI__LOT_NUMBER
OI__STORAGE_NAME
OI__QUANTITY
OI__LOT_STATUS
OI__STATUS_DATE
OI__MANUFACTURING_DATE
OI__EXPIRY_DATE

Advanced Supply Chain Planning - MSC_INT_18_TV_SNO
Column Name	Descritpion
OI__PLAN_NAME
OI__ITEM_CODE
OI__QUANTITY
OI__BRANCH_CODE
A__START_DATE
A__END_DATE
OI__SAFETY_COVERAGE
OI__SAFETY_LEVEL

Advanced Supply Chain Planning - MSC_INT_19_E_SNO
Column Name	Descritpion
OI__PLAN_NAME
OI__ITEM_CODE
OI__BRANCH_CODE
OI__COVERAGE_UNIT

Advanced Supply Chain Planning - MSC_INT_22_TV_SNO
Column Name	Descritpion
OI__CONSUMED_ITEM_SET_CODE
OI__CONSUMPTION_OVERHEAD_COST
OI__PREFERENCE
OI__OPERATION_CODE
OI__BRANCH_CODE
OI__ITEM_CODE
A__START_DATE
A__END_DATE
OI__AVAILABLE
OI__QUANTITY
OI__SCRAP

Advanced Supply Chain Planning - MSC_INT_20_TV_SNO
Column Name	Descritpion
OI__CONSUMED_ITEM_SET_CODE
OI__CONSUMPTION_OVERHEAD_COST
OI__PLAN_NAME
OI__PREFERENCE
OI__OPERATION_CODE
OI__SAFETY_LEVEL
OI__BRANCH_CODE
OI__ITEM_CODE
A__START_DATE
A__END_DATE
OI__AVAILABLE
OI__QUANTITY
OI__SAFETY_COVERAGE
OI__SCRAP

Advanced Supply Chain Planning - MSC_INT_25_TV_SNO
Column Name	Descritpion
OI__BRANCH_CODE
OI__OPERATION_CODE
A__START_DATE
A__END_DATE
OI__AVAILABLE
OI__OVERHEAD_COST

Advanced Supply Chain Planning - MSC_INT_26_MEM_SNO
Column Name	Descritpion
OI__GROUP_CODE
OI__OPERATION_CODE

Advanced Supply Chain Planning - MSC_INT_26_E_SNO
Column Name	Descritpion
OI__BRANCH_OR_GROUP
OI__ROUTING_CODE
OI__OPERATION_SET_CODE
OI__PREFERRED_OPERATION

Advanced Supply Chain Planning - MSC_INT_28_MEM_SNO
Column Name	Descritpion
OI__GROUP_CODE
OI__OPERATION_CODE

Advanced Supply Chain Planning - MSC_INT_29_E_PLAN
Column Name	Descritpion
OI__DESCRIPTION
OI__CREATED_DATE
OI__CUSTOMER_CODE
OI__FORECAST_SOURCE
OI__START_DATE
OI__BRANCH_CODE
OI__NUMBER_OF_PERIODS
OI__PERIOD_SIZE
OI__ITEM_CODE

Advanced Supply Chain Planning - MSC_INT_30_TV_PLAN
Column Name	Descritpion
OI__BRANCH_CODE
OI__ITEM_CODE
OI__CUSTOMER_CODE
A__START_DATE
A__END_DATE
OI__QUANTITY

Advanced Supply Chain Planning - MSC_CURRENCY_CONV_MV
Column Name	Descritpion
FROM_CURRENCY
TO_CURRENCY
CALENDAR_DATE
CONV_RATE

Advanced Supply Chain Planning - MSC_APCC_ITEM_D
Column Name	Descritpion
PLAN_ID
SR_CATEGORY_ID1
SR_CATEGORY_ID2
SR_CATEGORY_ID3
LATEST_ITEM_ID
VMI_FLAG
AVERAGE_DAILY_DEMAND
AVERAGE_DISCOUNT
BUYER_NAME
FIXED_LEAD_TIME
LIST_PRICE
SR_INSTANCE_ID
MAX_MINMAX_QUANTITY
MIN_MINMAX_QUANTITY
MINIMUM_ORDER_QUANTITY
MRP_PLANNING_CODE
PLANNER_CODE
PLANNING_MAKE_BUY_CODE
POSTPROCESSING_LEAD_TIME
PREPROCESSING_LEAD_TIME
STANDARD_COST
UNIT_VOLUME
ORGANIZATION_ID
UNIT_WEIGHT
UOM_CODE
VARIABLE_LEAD_TIME
VOLUME_UOM
WEIGHT_UOM
BASE_ITEM_ID
BUILD_IN_WIP_FLAG
REPETITIVE_TYPE
SAFETY_STOCK_CODE
PURCHASING_ENABLED_FLAG
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
ITEM_NAME
DESCRIPTION
PEGGING_SR_CATEGORY_ID
ABC_CLASS
PRODUCT_FAMILY_ID

Advanced Supply Chain Planning - MSC_DMD_SCN_METRICS
Column Name	Descritpion
PLAN_ID
CREATED_BY
CREATION_DATE
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
SCENARIO_ID
INVENTORY_ITEM_ID
ORGANIZATION_ID
SR_INSTANCE_ID
MAPE_IN_SAMPLE
MAPE_OUT_SAMPLE
FORECAST_VOLATILITY
AVG_DEMAND

Advanced Supply Chain Planning - MSC_DOC_ATTACHMENTS	This 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_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
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_EAM_ACT_ASSOCIATIONS	This table Stores the association relationship between an EAM Activty and the corresponding Asset/rebuildable item
Column Name	Descritpion
SR_INSTANCE_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
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_EAM_ASSET_EQUIP_DTLS
Column Name	Descritpion
ASSET_GROUP_ITEM_ID
RESOURCE_ID
RESOURCE_CODE
DEPARTMENT_ID
SCHEDULE_TO_INSTANCE
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
REFRESH_NUMBER
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_ATP_PEG_TEMP
Column Name	Descritpion
PLAN_ID
DEMAND_ID
DEMAND_QUANTITY
DISPOSITION_ID
DEMAND_CLASS
CONSUMED_QTY
OVERCONSUMPTION_QTY
SUPPLY_ID
SUPPLY_QUANTITY
ALLOCATED_QUANTITY
RESOURCE_ID
SR_INSTANCE_ID
DEPARTMENT_ID
RESOURCE_HOURS
DAILY_RESOURCE_HOURS
START_DATE
END_DATE
RELIEF_TYPE
RELIEF_QUANTITY
DAILY_RELIEF_QTY
PEGGING_ID
PREV_PEGGING_ID
REFERENCE_ITEM_ID
END_PEGGING_ID
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
CUSTOMER_ID
CUSTOMER_SITE_ID
DEMAND_SOURCE_TYPE
END_DEMAND_ID
ORIGINAL_ITEM_ID
INVENTORY_ITEM_ID
ORIGINAL_DATE
ATF_DATE
PRODUCT_FAMILY_ID
OFFSET_TYPE	Offset Type of a particular record
ORGANIZATION_ID
SALES_ORDER_LINE_ID
BOM_ITEM_TYPE
SALES_ORDER_QTY
TRANSACTION_DATE

Advanced Supply Chain Planning - MSC_IB_CONTRACTS_TEMP
Column Name	Descritpion
INVENTORY_ITEM_ID
CONTRACT_NUM_MODIFIER
STS_CODE
SERVICE_NAME
SERVICE_LINE_ID
SERVICE_START_DATE
SERVICE_END_DATE
COTERM_DATE
REFRESH_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
ITEM_INSTANCE_ID
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
REGION_ID
QUANTITY
ZONE
LOCATION_ID
INSTALL_DATE
EXPIRATION_DATE
CONTRACT_ID
CONTRACT_NUMBER

Advanced Supply Chain Planning - MSC_INT_24_MEM_SNO
Column Name	Descritpion
OI__GROUP_CODE
OI__OPERATION_CODE

Advanced Supply Chain Planning - MSC_INT_27_E_PLAN
Column Name	Descritpion
OI__BRANCH_CODE
OI__ITEM_CODE
OI__CUSTOMER_CODE

Advanced Supply Chain Planning - MSC_INT_28_TV_PLAN
Column Name	Descritpion
OI__BRANCH_CODE
OI__ITEM_CODE
OI__CUSTOMER_CODE
A__START_DATE
A__END_DATE
OI__QUANTITY

Advanced Supply Chain Planning - MSC_INT_30_E_PLAN
Column Name	Descritpion
OI__PRODUCTION_SCHEDULE_CODE
OI__RUN_TIME
OI__TIME_UOM
OI__INTEGRATION_ID
OI__RESOURCE_CODE
OI__BRANCH_CODE
OI__SCHEDULED_START_TIME
OI__PRECEDING_OPERATION_CODE
OI__NEXT_OPERATION_CODE
OI__SCHEDULED_END_TIME
OI__ELAPSED_TIME