DW_CST_COST_DISTRIBUTIONS_EN

This table contains the distribution header information for the costing transactions.

Details

Module: Cost Management

Key Columns

DISTRIBUTION_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
DISTRIBUTION_ID NUMBER 38 0 True Surrogate identifying distribution header record.    
SOURCE_RECORD_ID VARCHAR2 256     System    
SUBLEDGER_LINKAGE_HDR_ENTITY_ID VARCHAR2 256     Subledger linkage header entity ID    
EVENT_ID NUMBER 38 0   Reference to the event created in the SLA for this distribution header line.    
ENTITY_CODE VARCHAR2 32     Entity of the event for distribution.    
EVENT_CLASS_CODE VARCHAR2 32     Reference to event class for which the accounting template is defined.    
EVENT_TYPE_CODE VARCHAR2 32     Reference to the Event type of the event for the distribution.    
LEGAL_ENTITY_ID NUMBER 38 0   Legal entity (linked to the cost organization of the transaction) of the distribution.    
LEDGER_ID NUMBER 38 0   Ledger, corresponding to the cost organization book, where the distribution should be recorded.    
COST_ORGANIZATION_ID NUMBER 38 0   Cost organization of the transaction for which the distribution is created.    
COST_BOOK_ID NUMBER 38 0   Cost book within the cost organization for which the distribution is created.    
TRANSACTION_ID NUMBER 38 0   Reference to the transaction for which the distribution is created.    
REC_TRXN_ID NUMBER 38 0   Receipt Transaction Identifyer    
DEP_TRXN_ID NUMBER 38 0   Deplete Transaction Identifyer    
COST_TRANSACTION_TYPE VARCHAR2 16     Costing transaction types are ISSUE, RECEIPT and ADJUST    
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.    
TRANSACTION_NUMBER VARCHAR2 256     Transaction number used in SLA Events creation    
EFF_DATE TIMESTAMP       Effective date of the cost. This is defined as varachar becuase SLA doesn't support the DATE as system identifiers.    
EFF_DATE_CHAR VARCHAR2 32     Effective date in varchar as sent to SLA event API.    
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.    
LAYER_QUANTITY NUMBER       Layer quantity in the costing UOM. This can be different from the transaction quantity due to multiple depletions.    
COST_TRANSACTION_UOM VARCHAR2 32     Cost UOM ( is this same as the costing UOM).    
BASE_CURRENCY_CODE VARCHAR2 32     Base currency of the legal entity.    
ACCOUNTED_FLAG VARCHAR2 16     Indicates if the distribution has been accounted by the SLA. N - Not accounted, D - Draft Accounted, F - Final Accounted    
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    
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    
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.    
PJC_TXN_STATUS_CODE VARCHAR2 16     Indicates whether the distribution record has been interfaced to projects or not.