CST_STD_COST_VARIANCE_DETAILS

This table stores the information pertaining to standard cost variance details.

Details

• Schema: FUSION

• Object owner: CST

• Object type: TABLE

• Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
CST_STD_COST_VARIANCE_DET_PK	STD_COST_VARIANCE_DETAIL_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
STD_COST_VARIANCE_DETAIL_ID	NUMBER		18	Yes	Generated identifier for the standard cost variance detail.	Active
STD_COST_VARIANCE_ID	NUMBER		18	Yes	Identifies the standard cost variance.	Active
COST_COMPONENT_ID	NUMBER		18		OBSOLETE: Identifies the cost component for which the standard cost variance was created.	Active
COST_ELEMENT_ID	NUMBER		18	Yes	Identifies the cost element of the standard cost variance detail.	Active
STD_UNIT_COST	NUMBER				Indicates the unit standard cost for the cost component / cost element in base currency.	Active
ACTUAL_STD_COST	NUMBER				Indicates the unit actual cost for the cost component / cost element in base currency.	Active
VARIANCE_COST	NUMBER				Indicates the unit variance cost for the cost component / cost element in base currency.	Active
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.	Active
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.	Active
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.	Active
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.	Active
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.	Active

Indexes

Index	Uniqueness	Tablespace	Columns	Status
CST_STD_COST_VARIANCE_DTLS_PK	Unique	FUSION_TS_TX_DATA	STD_COST_VARIANCE_DETAIL_ID	Active
CST_STD_COST_VAR_DTLS_U1	Unique	FUSION_TS_TX_DATA	STD_COST_VARIANCE_ID, COST_ELEMENT_ID, COST_COMPONENT_ID	Active