CST_INTERFACE_STD_DTLS_GT
Transaction temporary table used to hold the standard cost details by the standard cost bulk desktop integration process.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
cst_interface_std_dtls_gt_PK |
STD_COST_INTERFACE_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
STD_COST_INTERFACE_ID | NUMBER | 18 | Yes | Generated identifier for bulk adfdi interface standard cost detail record. | |
STD_COST_INT_HDR_ID | NUMBER | 18 | Identifier for bulk adfdi interface standard cost header record. | ||
LINE_NUMBER | NUMBER | 18 | Indicates the order of the detail record for a given standard cost header record. | ||
COST_ELEMENT_SET_CODE | VARCHAR2 | 30 | Identifies the set of the cost element of the standard cost detail. | ||
COST_ELEMENT_CODE | VARCHAR2 | 30 | Identifies the cost element code of the standard cost detail. | ||
COST_ELEMENT_ID | NUMBER | 18 | Indicates the cost element identifier 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. | ||
EXPENSE_POOL_ID | NUMBER | 18 | Indicates the expense pool identifier for the standard cost detail. It is populated for cost details for overhead cost element type. | ||
UNIT_COST | NUMBER | Indicates the unit cost of the standard cost detail record. |
Indexes
Index | Uniqueness | Columns |
---|---|---|
CST_INTFC_STD_DTLS_GT_N1 | Non Unique | STD_COST_INT_HDR_ID |
CST_INTFC_STD_DTLS_GT_U1 | Unique | STD_COST_INTERFACE_ID |