This table contains the distribution header information for the costing transactions.
Module: Cost Management
DISTRIBUTION_ID
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. |