CST_COST_CONVERSION_TMP
This is a persisted temporary work table to process cost element mapping and currency conversion. Acquisition costs and adjustment costs are converted in a straightforward manner. Transfer costs, however, need special treatment. Transfer *cost elements* come from the costing engine and transfer *cost components* can optionally come from the incoming costs table. For transfers, the incoming costs table provides the same transfer component cost on both the transfer issue and receipt sides, so to avoid double booking we only use the issue side and ignore the receipt side. FOB RECEIPT (shipper owns intransit) transfer cost components are processed normally, but FOB SHIPMENT transfer cost components are shifted one leg to the transfer receipt transaction to book the proper cost organization ownership. These costs that are shifted must wait for the costing engine to first supply the derived transferring cost when the transfer is cost based so that the complete cost is posted to CTC together. Transfer Price cost components are uniquely handled in this flow: they are posted to the transaction costs table with a cost element of 0 and expense pool identifier of -2 for the costing engine to identify the TP and compute the profits in inventory. Likewise, transfer credits and freight charges are posted to the transaction costs table with an expense pool identifer of -1.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
CST_COST_CONVERSION_TMP_PK |
COST_ORG_ID, COST_BOOK_ID, CST_INV_TRANSACTION_ID, TRANSACTION_ID, ADJUSTMENT_TRANSACTION_ID, COST_COMPONENT_CODE, EXPENSE_POOL_ID, EFF_DATE |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| COST_ORG_ID | NUMBER | 18 | Yes | Single column FK: Identifies the Cost Organization associated with the inventory organization. | |
| COST_BOOK_ID | NUMBER | 18 | Yes | Single column FK: Identifies the Cost Book assigned to the Cost Organization. | |
| CST_INV_TRANSACTION_ID | NUMBER | 18 | Yes | Single column FK: Identifies the Inventory transaction. | |
| TRANSACTION_ID | NUMBER | 18 | Yes | Single column FK: Identifies the costing transaction. | |
| ADJUSTMENT_TRANSACTION_ID | NUMBER | 18 | Yes | Single column FK: Identifies the cost adjustment. | |
| COST_COMPONENT_CODE | VARCHAR2 | 30 | Yes | Identifies the cost component. Values are based on the seeded cost components in the lookup type CST_COMPONENT_CODES | |
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| COST_CONVERSION_TYPE | VARCHAR2 | 30 | Identifies the cost conversion type that is used internally by the cost conversion processor: ACQUISITION, ADJUSTMENT, TRANSFER. There is no LOOKUP_TYPE for these codes. | ||
| PROCESSOR_NAME | VARCHAR2 | 30 | Yes | Identifies the processor executing the conversion process and is the Alternate Short Name or the class name of the processor. | |
| BASE_TXN_TYPE_ID | NUMBER | 18 | Inventory transaction type identifier. For origin as INV the value comes from INV_TRANSACTION_TYPES_TL table. | ||
| BASE_TXN_SOURCE_TYPE_ID | NUMBER | 18 | Yes | Inventory transaction source type identifier. For origin as INV the value comes from INV_TXN_SOURCE_TYPES_TL table, and for CST it comes from Lookup_type CST_BASE_TXN_SOURCE_TYPES | |
| BASE_TXN_ACTION_ID | NUMBER | 18 | Yes | Inventory transaction action identifier. For Origin as INV, the value comes from lookup INV_TRANSACTION_ACTIONS and for Origin as CST the value is from lookup_type CST_BASE_TXN_ACTIONS. | |
| ITEM_COST_PROFILE_ID | NUMBER | 18 | Yes | Single column FK: Identifies the Item Cost Profile. | |
| EFF_DATE | TIMESTAMP | Yes | The effective date of the cost record. It is the date when the cost became in effect for the transaction. For new costs, the effective date is the date stamped on the transaction. For user adjustments, the effective date is the user entry date. For acquisition cost adjustments, the effective date is the system date at time of cost processing. | ||
| EXPENSE_TRANSACTION_FLAG | VARCHAR2 | 1 | Identifies whether a transaction is an asset or expense transaction. Expense = Y, Asset = N. | ||
| SOURCE_INV_ORG_ID | NUMBER | 18 | Identifies the source inventory organization and is used to retrieve the shipping inventory organization's profit in inventory cost element as required during the mapping process. | ||
| INTERNAL_PROFIT_TRACKING | VARCHAR2 | 1 | Indicator for tracking profit in inventory per the transaction and used during the mapping process. | ||
| PRICING_OPTION | NUMBER | 18 | Pricing Option identifier. It signifies whether the option is to use the PO price (1), transfer prce (2) or the cost+markup (3) as the transfer cost. | ||
| COST_TRANSACTION_TYPE | VARCHAR2 | 10 | Costing transaction type, ISSUE, RECEIPT, or LOGICAL. Primarily used in this table to identify the physical transfer issue so that we can apply the transfer pricing cost component if pricing option is to use Transfer Price and profit tracking is off. | ||
| ADDITIONAL_PROCESSING_CODE | VARCHAR2 | 240 | Code specifying what kind of processing needs to be done. Primarily used in this table to identify the physical transfer issue so that we can apply the transfer pricing cost component if pricing option is to use Transfer Price and profit tracking is off. | ||
| LOGICAL_FLAG | VARCHAR2 | 1 | Indicates whether this transaction type is logical. Primarily used in this table to identify the physical transfer issue so that we can apply the transfer pricing cost component if pricing option is to use Transfer Price and profit tracking is off. | ||
| EXPENSE_POOL_ID | NUMBER | 18 | Yes | Identifies the expense pool for the transaction's cost. Negative values are used by the costing engine for identifying transfer cost components. | |
| COST_COMPONENT_CONTEXT | VARCHAR2 | 30 | Identifies the cost component context. For transfers, this is the set identifier of the cost organization. For non-transfers, this value is null. | ||
| COST_COMPONENT_TYPE | VARCHAR2 | 30 | Identifies the cost component type: PREDEFINED or COST_ELEMENTS. PREDEFINED is used for cost component to cost element mapping, and COST_ELEMENTS is used for cost element to element mapping. | ||
| COST_PROFILE_ID | NUMBER | 18 | Single column FK: Identifies Cost Profile associated with the record. | ||
| COMPONENT_GROUP_ID | NUMBER | 18 | Single column FK: Identifies the Cost Component Group | ||
| COST | NUMBER | Yes | Identifies the unit cost of the cost component or cost element. | ||
| FROM_CURRENCY_CODE | VARCHAR2 | 30 | Identifies the original currency, or the currency of the transaction. | ||
| CURRENCY_CONVERSION_TYPE | VARCHAR2 | 30 | Conversion type that should be used for currency conversion. | ||
| CURRENCY_CONVERSION_DATE | TIMESTAMP | The date to be used to determine the exchange rates for currency conversion | |||
| CURRENCY_CONVERSION_RATE | NUMBER | Optional user specified currency conversion rate. | |||
| UOM_CONVERSION_FACTOR | NUMBER | Identifies the UOM conversion factor between primary UOM and transaction UOM. | |||
| COST_ELEMENT_MAPPED_FLAG | VARCHAR2 | 1 | Indicates the mapping status of the line: N=No/Ready, Y=Yes, E=Error, and X=not required. There is no LOOKUP_TYPE for these codes. | ||
| CURRENCY_CONVERTED_FLAG | VARCHAR2 | 1 | Indicates the currency conversion status of the line: N=No/Ready, Y=Yes, E=Error, and X=not required. There is no LOOKUP_TYPE for these codes. | ||
| UOM_CONVERTED_FLAG | VARCHAR2 | 1 | Identifies the UOM conversion status of the line: N=No, Y=Yes, E=Error, and X=not required. There is no LOOKUP_TYPE for these codes. | ||
| TO_COST_ELEMENT_ID | NUMBER | 18 | Cost element corresponding to the cost of the transaction. | ||
| TO_UNIT_COST | NUMBER | Identifies the new cost after currency conversion. | |||
| TO_CURRENCY_CODE | VARCHAR2 | 30 | Identifies the target, or default currency code as specified by the ledger. | ||
| ERROR_CODE_MAPPING | VARCHAR2 | 30 | Indicates the error encountered, if any, when performing cost element mapping for the line. | ||
| ERROR_CODE_CONVERSION | VARCHAR2 | 30 | Identifies the error encountered, if any, when performing currency conversion for the line. | ||
| TOKEN1_NAME | VARCHAR2 | 30 | Token name as required by error code message. | ||
| TOKEN1_VALUE | VARCHAR2 | 240 | Token value as required by error code message. | ||
| TOKEN2_NAME | VARCHAR2 | 30 | Token name as required by error code message. | ||
| TOKEN2_VALUE | VARCHAR2 | 240 | Token value as required by error code message. | ||
| TOKEN3_NAME | VARCHAR2 | 30 | Token name as required by error code message. | ||
| TOKEN3_VALUE | VARCHAR2 | 240 | Token value as required by error code message. | ||
| TOKEN4_NAME | VARCHAR2 | 30 | Token name as required by error code message. | ||
| TOKEN4_VALUE | VARCHAR2 | 240 | Token value as required by error code message. | ||
| TOKEN5_NAME | VARCHAR2 | 30 | Token name as required by error code message. | ||
| TOKEN5_VALUE | VARCHAR2 | 240 | Token value as required by error code message. | ||
| TOKEN6_NAME | VARCHAR2 | 30 | Token name as required by error code message. | ||
| TOKEN6_VALUE | VARCHAR2 | 240 | Token value as required by error code message. | ||
| TO_SET_ID | NUMBER | 18 | Identifies the destination cost organization's Set ID and is used to derive the descriptive code from surrogate key identifiers for token value error logging. | ||
| FROM_SET_ID | NUMBER | 18 | Identifies the source cost organization's Set ID and is used to derive the descriptive code from surrogate key identifiers for token value error logging. | ||
| 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. | ||
| 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_COST_CONVERSION_TMP | cst_cp_requests | REQUEST_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CST_COST_CONVERSION_TMP_N1 | Non Unique | FUSION_TS_TX_DATA | TRANSACTION_ID, EFF_DATE, TO_COST_ELEMENT_ID, EXPENSE_POOL_ID |
| CST_COST_CONVERSION_TMP_N2 | Non Unique | FUSION_TS_TX_DATA | REQUEST_ID, COST_CONVERSION_TYPE, FROM_CURRENCY_CODE, TO_CURRENCY_CODE, CURRENCY_CONVERSION_DATE, CURRENCY_CONVERSION_TYPE, CURRENCY_CONVERTED_FLAG |
| CST_COST_CONVERSION_TMP_N3 | Non Unique | FUSION_TS_TX_DATA | COST_ORG_ID, COST_BOOK_ID, COST_CONVERSION_TYPE |
| CST_COST_CONVERSION_TMP_U1 | Unique | FUSION_TS_TX_DATA | COST_ORG_ID, COST_BOOK_ID, CST_INV_TRANSACTION_ID, TRANSACTION_ID, ADJUSTMENT_TRANSACTION_ID, COST_COMPONENT_CODE, EXPENSE_POOL_ID, EFF_DATE |