CST_COST_CONVERSION_GT
This is a global temporary 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: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| 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. | |
| COMPONENT_MAPPING_TYPE | VARCHAR2 | 30 | Yes | 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. | |
| SOURCE_COST_COMPONENT_ID | NUMBER | 18 | Source cost component identifier | ||
| SOURCE_COST_ELEMENT_ID | NUMBER | 18 | Source cost element identifier | ||
| 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. | |
| ABSORPTION_TYPE | VARCHAR2 | 30 | Identifies the absorption type for which this cost is created. | ||
| 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. | ||
| COST | NUMBER | Yes | Identifies the unit cost of the cost component or cost element. | ||
| FROM_CURRENCY_CODE | VARCHAR2 | 30 | Yes | Identifies the original currency, or the currency of the transaction. | |
| DEST_SET_ID | NUMBER | 18 | Identifies the destination cost organization's Set ID. | ||
| SOURCE_SET_ID | NUMBER | 18 | Identifies the source cost organization's Set ID and is used as the cost component context to derive the cost element mapping. | ||
| 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_ELEMENT_TYPE | VARCHAR2 | 30 | Indicates the cost element type for special handling of certain costs such as PROFIT_IN_INVENTORY and TRANSFER_PRICE. Column is active when SOURCE_COST_ELEMENT_ID from transfer logic is set to 0. | ||
| 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. | ||
| COMPONENT_GROUP_ID | NUMBER | 18 | Single column FK: Identifies the Cost Component Group | ||
| 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 | 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 | 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. | ||
| 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. | ||
| 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. | ||
| COMPONENT_GROUP_CODE | VARCHAR2 | 30 | Component mapping group code for the destination. | ||
| PROCESSOR_NAME | VARCHAR2 | 30 | Identifies the processor executing the conversion process and is the Alternate Short Name or the class name of the processor. | ||
| COST_ORG_ID | NUMBER | 18 | Single column FK: Identifies the Cost Organization associated with the inventory organization. | ||
| COST_BOOK_ID | NUMBER | 18 | Single column FK: Identifies the Cost Book assigned to the Cost Organization. | ||
| CST_INV_TRANSACTION_ID | NUMBER | 18 | Single column FK: Identifies the Inventory transaction. | ||
| ADJUSTMENT_FLAG | VARCHAR2 | 1 | Identifies if the transfer cost row represents an adjustment being propagated. N - Not an adjustment or transfer cost row, Y - Delta adjustment cost, Z - Full adjustment cost due to a new transaction at source. There is no lookup for these codes. | ||
| ADJUSTMENT_DATE | TIMESTAMP | Indicates the adjustment date derived in pre processing to be used in cost processing acquisition cost adjustments. | |||
| 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. | ||
| 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. | ||
| CODE_COMBINATION_ID | NUMBER | 18 | Contains the Code combination of the account entered by the users while creating costs (IMT outbound taxes). | ||
| SOURCE_DOC_CURR_CODE | VARCHAR2 | 15 | Indicates the transaction source document currency code. | ||
| SOURCE_DOC_CURR_CONV_RATE | NUMBER | Indicates the transaction source document currency conversion rate. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_COST_CONVERSION_GT_N1 | Non Unique | REQUEST_ID, TRANSACTION_ID |
| CST_COST_CONVERSION_GT_N2 | Non Unique | TRANSACTION_ID, EFF_DATE, TO_COST_ELEMENT_ID, EXPENSE_POOL_ID |