1. Tables and Views for SCM
  2. CST_COST_DIST_LINES_I_GT

CST_COST_DIST_LINES_I_GT

This table is used to temporarily store a subset of the data from cst_cost_distribution_lines table for internal processing within the cost processor.

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

CST_COST_DIST_LINES_I_GT_PK

DISTRIBUTION_LINE_ID

Columns

Name Datatype Length Precision Not-null Comments
DISTRIBUTION_LINE_ID NUMBER 18 Yes Surrogate identifying the distribution line.
TRANSACTION_EVENT_ID NUMBER 18 References to the transaction event type from cst_transaction_events.
DISTRIBUTION_ID NUMBER 18 Yes Single column FK: Identifies the cost distribution header record.
EVENT_ID NUMBER 18 Reference to the event created in the SLA for this distribution header line.
ACCOUNTING_DEFINITION_ID NUMBER 18 Yes Reference to the cost accounting definition line.
COST_ID NUMBER 18 Yes Reference to the layer, write-off or transfer cost id. The source table in the distribution header table will determine which id is stored here.
TRANSACTION_COST_ID NUMBER 18 Reference to the receipt costs in the cst_transaction_costs table.
SOURCE_TABLE VARCHAR2 30 Yes Indicates the source_table from which the distribution is created.
LINE_NUMBER NUMBER 5 Yes Distribution line number.
ACCOUNTING_LINE_TYPE VARCHAR2 30 Yes Accounting line type of the distribution line.
ENTERED_CURRENCY_AMOUNT NUMBER Yes Distribution line amount in the transaction currency. Note that not all events will have the transaction currency amount. cst_acct_definitions.use_txn_curr_amount indicates which events will have the transaction currency code & amounts.
LEDGER_AMOUNT NUMBER Yes Distribution line amount in the base currency.
ENTERED_CURRENCY_CODE VARCHAR2 30 Transaction currency code for selected events. Note that not all events will have the transaction currency code. cst_acct_definitions.use_txn_curr_amount indicates which events will have the transaction currency code & amounts.
EXCHANGE_RATE NUMBER Exchange Rate from transaction (entered) to base currency.
EXCHANGE_DATE DATE Exchange Rate Date
EXCHANGE_RATE_TYPE VARCHAR2 30 Exchange Rate Type associated to the Exchange Rate.
CODE_COMBINATION_ID NUMBER 18 Contains the Code combination of the account entered by the users while creating the transactions (Misc. Transactions).
DR_CR_SIGN VARCHAR2 6 Yes Debit or Credit for the amount.
COST_ELEMENT_ID NUMBER 18 Yes Cost element corresponding to the cost of the transaction.
PJC_TXN_STATUS_CODE VARCHAR2 1 Indicates the status of transactions that have been transferred to projects. A: stands for "Successfully interfaced to projects". P: stands for "Interfaced and pending cost processing in Oracle Projects". R: stands for "Rejected". F: stands for "Failed to interface".
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.
DISTRIBUTION_QUANTITY_RATE NUMBER For cases where there are multiple distribution lines for a transaction, this column stores the value of distribution line quantity by total transaction quantity.
SLA_CODE_COMBINATION_ID NUMBER 18 Accounting code combination identifier.
AE_HEADER_ID NUMBER 18 Subledger journal entry identifier.
AE_LINE_NUM NUMBER 38 Subledger journal entry line number.

Indexes

Index Uniqueness Columns
CST_COST_DIST_LINES_I_GT_U1 Unique DISTRIBUTION_LINE_ID