DW_CST_COST_DISTRIBUTION_LINES_EN

This table contains the distribution details, e.g. debit, credits and the distribution amounts along with distribution header details.

Details

Module: Cost Management

Key Columns

DISTRIBUTION_LINE_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
DISTRIBUTION_LINE_ID NUMBER 38 0 True Surrogate identifying the distribution line.    
SOURCE_RECORD_ID VARCHAR2 256     System    
SUBLEDGER_LINKAGE_DST_ENTITY_ID VARCHAR2 256     Subledger linkage distribution entity ID    
TRANSACTION_EVENT_ID NUMBER 38 0   References to the transaction event type from cst_transaction_events.    
DISTRIBUTION_ID NUMBER 38 0   Single column FK: Identifies the cost distribution header record.    
EVENT_ID NUMBER 38 0   Reference to the event created in the SLA for this distribution header line.    
ACCOUNTING_DEFINITION_ID NUMBER 38 0   Reference to the cost accounting definition line.    
COST_ID NUMBER 38 0   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 38 0   Reference to the receipt costs in the cst_transaction_costs table.    
SOURCE_TABLE VARCHAR2 32     Indicates the the source_table from which the distribution is created.    
LINE_NUMBER NUMBER 38 0   Distribution line number.    
ACCOUNTING_LINE_TYPE VARCHAR2 32     Accounting line type of the distribution line.    
ENTERED_CURRENCY_AMOUNT NUMBER       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 indictaes which events will have the transaction currency code & amounts.    
LEDGER_AMOUNT NUMBER       Distribution line amount in the base currency.    
ENTERED_CURRENCY_CODE VARCHAR2 32     Transaction currency code for selected events. Note that not all events will have the transaction currency code. cst_acct_definitions.use_txn_curr_amount indictaes 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 32     Exchange Rate Type    
CODE_COMBINATION_ID NUMBER 38 0   Contains the Code combination of the account entered by the users while creating the transctions (Misc. Transactions).    
DR_CR_SIGN VARCHAR2 16     Debit or Credit for the amount.    
COST_ELEMENT_ID NUMBER 38 0   Cost element corresponding to the cost of the transaction.    
PJC_TXN_STATUS_CODE VARCHAR2 16     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     Who column: indicates the user who created the row.    
CREATION_DATE TIMESTAMP       Who column: indicates the date and time of the creation of the row.    
LAST_UPDATED_BY VARCHAR2 64     Who column: indicates the user who last updated the row.    
LAST_UPDATE_DATE TIMESTAMP       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 38 0   Accounting code combination identifier.    
AE_HEADER_ID NUMBER 38 0   Subledger journal entry identifier.    
AE_LINE_NUM NUMBER 38 0   Subledger journal entry line number.    
H_ENTITY_CODE VARCHAR2 32     Entity of the event for distribution.    
H_EVENT_CLASS_CODE VARCHAR2 32     Entity of the event for distribution.    
H_EVENT_TYPE_CODE VARCHAR2 32     Reference to the Event type of the event for the distribution.    
H_LEGAL_ENTITY_ID NUMBER 38 0   Legal entity (linked to the cost organization of the transaction) of the distribution.    
H_LEDGER_ID NUMBER 38 0   Ledger, corresponding to the cost organization book, where the distribution should be recorded.    
H_COST_ORGANIZATION_ID NUMBER 38 0   Cost organization of the transaction for which the distribution is created.    
H_COST_BOOK_ID NUMBER 38 0   Cost book within the cost organization for which the distribution is created.    
H_TRANSACTION_ID NUMBER 38 0   Reference to the transaction for which the distribution is created.    
H_REC_TRXN_ID NUMBER 38 0   Receipt Transaction Identifier    
H_DEP_TRXN_ID NUMBER 38 0   Deplete Transaction Identifier    
H_COST_TRANSACTION_TYPE VARCHAR2 16     Costing transaction types are ISSUE, RECEIPT and ADJUST    
H_ADDITIONAL_PROCESSING_CODE VARCHAR2 32     Additional Processing Code is an optional further definition of the Cost Transaction Type such as TRANSFER of an issue transaction, or an adjustment transaction due to USER, ACQUISITION or an ITEM.    
H_TRANSACTION_NUMBER VARCHAR2 256     Transaction number used in SLA Events creation    
H_EFF_DATE TIMESTAMP       Effective date of the cost. This is defined as varachar becuase SLA doesn't support the DATE as system identifiers.    
H_EFF_DATE_CHAR VARCHAR2 32     Effective date in varchar as sent to SLA event API.    
H_GL_DATE DATE       Accounting date of the transaction. Depending upon the status of the costing period, this date can be different from the transaction date.    
H_LAYER_QUANTITY NUMBER       Layer quantity in the costing UOM. This can be different from the transaction quantity due to multiple depletions.    
H_COST_TRANSACTION_UOM VARCHAR2 32     Cost UOM (This is same as the costing UOM)    
H_BASE_CURRENCY_CODE VARCHAR2 32     Base currency of the legal entity.    
H_ACCOUNTED_FLAG VARCHAR2 16     Indicates if the distribution has been accounted by the SLA. N - Not accounted, D - Draft Accounted, F - Final Accounted    
H_VAL_ONHAND_FLAG VARCHAR2 16     Indicates if the onhand calculations have been done for the distribution. Values: N = No processed, NULL = Processed for onhand calculations    
H_GROSS_MARGIN_FLAG VARCHAR2 16     Indicates if the gross margin calculations have been done for the distribution. Values: 1. N = Not processed 2. NULL = Processed for gross margin calculations