This table contains the distribution details, e.g. debit, credits and the distribution amounts along with distribution header details.
Module: Cost Management
DISTRIBUTION_LINE_ID
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 |