CST_TXN_COMPONENT_COSTS
This table contains the lower level cost component reference for a cost element of the unit of cost that is stored in the primary cost table CST_TRANSACTION_COSTS. For example, if given a cost in primary cost table CST_TRANSACTION_COSTS which is based on cost elements, this detail table will show the cost components prior to mapping to the cost element, and there can be multiple cost components mapped to a single cost element. These costs are in the functional currency and not the transaction currency; that is, after any currency conversion has been done.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
CST_TXN_COMPONENT_COSTS_PK |
TRANSACTION_COST_ID, SOURCE_COST_COMPONENT_ID, SOURCE_COST_ELEMENT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TRANSACTION_COST_ID | NUMBER | 18 | Yes | Single column FK: Identifies the transaction cost. | |
| COST_COMPONENT_CODE | VARCHAR2 | 30 | OBSOLETE: Identifies the cost component. Values are based on the seeded cost components in the lookup type CST_COMPONENT_CODES | ||
| COST_COMPONENT_TYPE | VARCHAR2 | 30 | OBSOLETE: Identifies the cost component type for this cost: PREDEFINED or COST_ELEMENTS. There is no LOOKUP_TYPE for these codes. | ||
| COMPONENT_MAPPING_TYPE | VARCHAR2 | 30 | Identifies the component mapping type: COMPONENTS or COST_ELEMENTS. COMPONENTS is used for cost component to cost element mapping, and COST_ELEMENTS is used for cost element to element mapping. PIN is also used for the special case where the transfers logic computes the profit in inventory amount which gets transformed into the PIN cost element of the source. | ||
| SOURCE_COST_COMPONENT_ID | NUMBER | 18 | Yes | Source cost component identifier | |
| SOURCE_COST_ELEMENT_ID | NUMBER | 18 | Yes | Source cost element identifier | |
| UNIT_COST | NUMBER | Yes | Indicates the unit cost after currency conversion. | ||
| CURRENCY_CODE | VARCHAR2 | 30 | Identifies the currency code of the unit cost. This is the functional currency based on the ledger / cost org book combination. | ||
| 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. | ||
| 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. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| CST_TXN_COMPONENT_COSTS | cst_transaction_costs | TRANSACTION_COST_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CST_TXN_COMPONENT_COSTS_U1 | Unique | FUSION_TS_TX_DATA | TRANSACTION_COST_ID, SOURCE_COST_COMPONENT_ID, SOURCE_COST_ELEMENT_ID |