MSC_ST_PRICE_LIST_DETAILS

The staging table used by the collection program to validate and process data for table MSC_PRICE_LISTS and MSC_PRICE_LIST_DETAILS.

Details

• Schema: FUSION

• Object owner: MSC

• Object type: TABLE

• Tablespace: INTERFACE

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
SR_INSTANCE_CODE	VARCHAR2	30			The value indicates the source system code from where the data is collected.	Active
SR_INSTANCE_ID	NUMBER		18		Identifier of the source system from where the data is collected.	Active
PLAN_NAME	VARCHAR2	250			Name of the plan. If left blank, the Price List is not plan-specific.	Active
PLAN_ID	NUMBER		18		Identifier of the plan for which the data was uploaded	Active
ITEM_NAME	VARCHAR2	300			Member name for the product level for which data was loaded.	Active
INVENTORY_ITEM_ID	NUMBER				Identifier of the product level for which data was loaded.	Active
PRICE_LIST_NAME	VARCHAR2	80			Name of the Price List uploaded.	Active
PRICE_LIST_ID	NUMBER		18		Identifier of the Price List uploaded.	Active
ORGANIZATION_CODE	VARCHAR2	49			Code of the organization for which the price list was uploaded.
ORGANIZATION_ID	NUMBER		18		Identifier of the organization for which the price list was uploaded.
ORG_LEVEL_NAME	VARCHAR2	100			Name of the organization level for which the data is loaded. The valid values are Business Unit, Operating Unit, Organization.
ORG_MEMBER_NAME	VARCHAR2	240			Member name for the organization level for which data is loaded.
PRICE_CURRENCY	VARCHAR2	30			Short code designated for the currency. Use to designate the currency when organization is not a dimension.	Active
PRICE_UOM	VARCHAR2	50			Unique short code for the unit of measure.	Active
PRICE_LIST_DESCRIPTION	VARCHAR2	1000			Long description of the price list.	Active
PRICE_LIST_START_DATE	DATE				Date from which the price list becomes active.
PRICE_LIST_END_DATE	DATE				Date after which the price list becomes inactive.
ITEM_PRICE_START_DATE	DATE				Date from which the price for the item becomes active.	Active
ITEM_PRICE_END_DATE	DATE				Date after which the price for the item becomes inactive.	Active
PRICE	NUMBER				Price of the item, which varies over time and across organizations.	Active
PROCESS_FLAG	NUMBER		2		Processing Flag indicating the status of records during pre-processing. 1- Complete Record, 2- Error Record, 3- Warning Record, 4- Retry Record, 5- New Record.	Active
DELETED_FLAG	NUMBER				Indicates whether the row is no longer valid. If Yes, then this row is deleted from the planning table. Valid values are Yes, No. Default value is No.	Active
REFRESH_NUMBER	NUMBER				Refresh identifier populated by the collection program.	Active
ERROR_CODE	VARCHAR2	150			Error code for functional validation errors in the record	Active
ERROR_TEXT	VARCHAR2	2000			If PROCESS_FLAG is equal to 3 for a record, then this will describe the reason for the error	Active
RETRY_COUNT	NUMBER		18		Number of retries to process failed records	Active
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.	Active
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.	Active
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.	Active
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.	Active
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.	Active
LOAD_REQUEST_ID	NUMBER				Stores the Request ID of the job that loaded the data.