CST_INTERFACE_STD_COST_DETAILS
Interfaced details for a standard cost header
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: FUSION_TS_INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
CST_INTF_STD_COST_DETAILS_PK |
EXTERNAL_SYSTEM_REFERENCE, EXTERNAL_SYSTEM_REF_ID, LINE_NUMBER |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| EXTERNAL_SYSTEM_REFERENCE | VARCHAR2 | 240 | Yes | External system reference | |
| EXPENSE_POOL_ID | NUMBER | 18 | Indicates the expense pool identifier for the standard cost detail. It is populated for cost details for overhead and resource cost components. For other cost component types, this attribute is not populated. | ||
| EXPENSE_POOL_CODE | VARCHAR2 | 30 | Indicates the expense pool code for the standard cost detail. It is populated for cost details for overhead and resource cost components. For other cost component types, this attribute is not populated. | ||
| LOAD_REQUEST_ID | NUMBER | 18 | Used by Enterprise Service Scheduler: indicates the request ID of the interface load job that created the row. | ||
| EXTERNAL_SYSTEM_REF_ID | VARCHAR2 | 30 | Yes | external system identifyer | |
| LINE_NUMBER | NUMBER | 18 | Yes | line number | |
| COST_COMPONENT_SET_CODE | VARCHAR2 | 240 | component set code | ||
| COST_COMPONENT_CODE | VARCHAR2 | 30 | component code | ||
| UNIT_COST | NUMBER | unit cost | |||
| 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. | |
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or 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. | ||
| 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. | ||
| COST_ELEMENT_CODE | VARCHAR2 | 30 | Identifies the cost element code of the standard cost detail. | ||
| COST_ELEMENT_ID | NUMBER | 18 | Identifies the cost element of the standard cost detail. | ||
| COST_ELEMENT_SET_CODE | VARCHAR2 | 30 | Identifies the set of 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CST_INTFC_STD_COST_DTLS_U1 | Unique | FUSION_TS_INTERFACE | EXTERNAL_SYSTEM_REFERENCE, EXTERNAL_SYSTEM_REF_ID, LINE_NUMBER |