1. Tables and Views for SCM
  2. CST_TRANSACTION_COSTS_GT

CST_TRANSACTION_COSTS_GT

Global temporary table used in summing unit costs by its cost elements.

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: TABLE

  • Tablespace: Default

Columns

Name Datatype Length Precision Comments
TRANSACTION_ID NUMBER 18 Single column FK: Identifies the cost transaction.
EFF_DATE TIMESTAMP 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_ELEMENT_ID NUMBER 18 Cost element corresponding to the cost of the transaction.
EXPENSE_POOL_ID NUMBER 18 Identifies the expense pool of cost.
ABSORPTION_TYPE VARCHAR2 30 Identifies the absorption type for which this cost is created.
UNIT_COST NUMBER Unit cost, after currency conversion
CURRENCY_CODE VARCHAR2 15 Identifies the currency of the transaction / cost.
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.
CST_INV_TRANSACTION_ID NUMBER 18 Single column FK: Identifies the Inventory transaction.
ADJUSTMENT_TRANSACTION_ID NUMBER 18 Single column FK: Identifies the cost adjustment.
TXN_UNIT_COST NUMBER Indicates the unit cost of the transaction before currency conversion.
TXN_CURRENCY_CODE VARCHAR2 15 Identifies the currency code of the transaction.
TXN_CURRENCY_CONVERSION_TYPE VARCHAR2 30 Identifies the rate type that was used for currency conversion.
TXN_CURRENCY_CONVERSION_DATE DATE Identifies the date that was used for currency conversion
TXN_CURRENCY_CONVERSION_RATE NUMBER Identifies the rate that was used for currency conversion. This value is null if conversion was not required.
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.
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.
VAL_UNIT_ID NUMBER 18 Valuation unit identifier associated with cost.
COST_TRANSACTION_TYPE VARCHAR2 10 Costing transaction type ISSUE or RECEIPT
ADDITIONAL_PROCESSING_CODE VARCHAR2 240 Code specifying what kind of processing needs to be done. The value is defined in CST_INTERNAL_TXN_TYPE for the transaction type and is used by Cost Processors for additional processing.
USE_ITEM_COST_FLAG VARCHAR2 1 Identifies receipt transactions that did not come with its own cost and are to use an existing item cost in the system (current perpetual average, a specific layer cost, or the current standard cost). Valid values are Y/N. Does not apply to transfer transactions.
COST_METHOD_CODE VARCHAR2 30 The cost method code like PERPETUAL AVERAGE, FIFO etc. Value comes from lookup_type CST_COST_METHODS
TRANSFER_CST_INV_TXN_ID NUMBER 18 Source inventory transaction identifying the other leg of transfer transaction
PO_DISTRIBUTION_ID NUMBER 18 Purchasing distribution identifier
DOO_FULLFILL_LINE_ID NUMBER 18 Distributed Order Orchestration (Sales Order) fulfillment line identifier
TXN_SOURCE_DOC_NUMBER VARCHAR2 240 Transactions Source Document Number
TRANSACTION_FLOW_TYPE NUMBER 18 Transaction Flow Identifier, 1 - Internal Drop Shipment, 2 - Global Procurement, 3 - Customer Drop Shipment, 4 - Intransit Interorg Transfer, 5 - Direct Interorg Transfer, 6 - Intraorg Transfer, 7 - Transfer Order Intransit Interorg Transfer, 8 - Transfer Order Direct Interorg Transfer, 9 - Transfer Order Intraorg Transfer, 10 - TIR/TIRR at ownership change in procuring org for consigned PO, 11 - TIRR of TO Return with Scrap or null for others.
TRANSFER_TRANSACTION_GROUP_ID NUMBER 18 The transaction group whose average cost is required to process this transaction.
REFERENCE_DOO_FULLFILL_LINE_ID NUMBER 18 Populated only for referenced RMA transaction, it points to OM fulfilment line identifier.
CODE_COMBINATION_ID NUMBER 18 Contains the Code combination of the account entered by the users while creating costs (IMT outbound taxes).
ADJUSTMENT_DATE TIMESTAMP Indicates the adjustment date derived in preprocessing to be used in cost processing acquisition cost adjustments.
PERIOD_NAME VARCHAR2 15 Period in which the transaction is processed. This value is populated for the transactions in periodic average cost method.

Indexes

Index Uniqueness Columns
CST_TRANSACTION_COSTS_GT_N1 Non Unique TRANSACTION_ID, EFF_DATE, COST_ELEMENT_ID, EXPENSE_POOL_ID, ABSORPTION_TYPE