CST_STD_COSTS

Details

Schema: FUSION
Object owner: CST
Object type: TABLE
Tablespace: INTERFACE

Primary Key

Name	Columns
CST_STD_COSTS_INT_PK	STD_COST_INTERFACE_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
STD_COST_INTERFACE_ID	NUMBER		18	Yes	Generated identifier for standard cost detail record from bulk desktop integration spreadsheet.
COST_ORG_CODE	VARCHAR2	30			Identifies the cost organization for which the standard cost is entered.
COST_BOOK_CODE	VARCHAR2	30			Identifies the cost book for which the standard cost is entered.
STD_COST_INT_HDR_ID	NUMBER		18		Generated identifier for standard cost header record from bulk desktop integration spreadsheet.
SCENARIO_NUMBER	VARCHAR2	30		Yes	Identifies the scenario for which the standard cost is entered.
VAL_UNIT_CODE	VARCHAR2	1000		Yes	Indicates the valuation unit of the standard cost record.
ITEM_NUMBER	VARCHAR2	300		Yes	Indicates the item identifier of the standard cost record.
COST_ELEMENT_SET_CODE	VARCHAR2	30			Identifies the set of the cost element of the standard cost detail.
COST_ELEMENT_CODE	VARCHAR2	80		Yes	Identifies the cost element of the standard cost detail.
EXPENSE_POOL_SET_CODE	VARCHAR2	30			Identifies the set of the expense pool of the standard cost detail.
EXPENSE_POOL_CODE	VARCHAR2	30			Indicates the expense pool code for the standard cost detail. It is populated for cost details of overhead cost element type.
UNIT_COST	NUMBER			Yes	Indicates the unit cost of the standard cost detail record.
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
LOAD_REQUEST_ID	NUMBER		18		Used by Enterprise Service Scheduler: indicates the request ID of the interface load job that created the row.
BATCH_ID	NUMBER		18		Identifies the Batch identifier in which the standard cost is entered.
STATUS	VARCHAR2	1			Processing status: N=New, P=In process, E=Error, S=Successful.
ERROR_CODES	VARCHAR2	1000			Comma separated validation error codes.
BUY_COST_FLAG	VARCHAR2	1			Indicates the buy cost type. This can be either Y or N.
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
JOB_DEFINITION_NAME	VARCHAR2	100			Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE	VARCHAR2	900			Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.

Indexes

Index	Uniqueness	Tablespace	Columns
CST_STD_COSTS_INT_N1	Non Unique	Default	SCENARIO_NUMBER
CST_STD_COSTS_INT_N2	Non Unique	Default	STATUS
CST_STD_COSTS_INT_N3	Non Unique	Default	STD_COST_INT_HDR_ID
CST_STD_COSTS_INT_U1	Unique	Default	STD_COST_INTERFACE_ID
CST_STD_COSTS_INT_U2	Unique	Default	BATCH_ID, SCENARIO_NUMBER, VAL_UNIT_CODE, ITEM_NUMBER, COST_ELEMENT_CODE, EXPENSE_POOL_CODE, COST_ORG_CODE, COST_BOOK_CODE, BUY_COST_FLAG