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 |