1. Tables and Views for SCM
  2. CST_COST_DISTRIBUTIONS_I_GT

CST_COST_DISTRIBUTIONS_I_GT

This table is used to temporarily store a subset of the data from cst_cost_distributions 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_DISTRIBUTIONS_I_GT_PK

DISTRIBUTION_ID

Columns

Name Datatype Length Precision Not-null Comments
DISTRIBUTION_ID NUMBER 18 Yes Surrogate identifying distribution header record.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
EVENT_ID NUMBER 18 Reference to the event created in the SLA for this distribution header line.
ENTITY_CODE VARCHAR2 30 Yes Entity of the event for distribution.
EVENT_CLASS_CODE VARCHAR2 30 Yes Reference to event class for which the accounting template is defined.
EVENT_TYPE_CODE VARCHAR2 30 Yes Reference to the Event type of the event for the distribution.
LEGAL_ENTITY_ID NUMBER 18 Yes Legal entity (linked to the cost organization of the transaction) of the distribution.
LEDGER_ID NUMBER 18 Ledger, corresponding to the cost organization book, where the distribution should be recorded.
COST_ORGANIZATION_ID NUMBER 18 Yes Cost organization of the transaction for which the distribution is created.
COST_BOOK_ID NUMBER 18 Yes Cost book within the cost organization for which the distribution is created.
TRANSACTION_ID NUMBER 18 Reference to the transaction for which the distribution is created.
REC_TRXN_ID NUMBER 18 Receipt Transaction Identifier
DEP_TRXN_ID NUMBER 18 Deplete Transaction Identifier
COST_TRANSACTION_TYPE VARCHAR2 10 Costing transaction types are ISSUE, RECEIPT and ADJUST
ADDITIONAL_PROCESSING_CODE VARCHAR2 20 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 240 Transaction number used in SLA Events creation
EFF_DATE TIMESTAMP Effective date of the cost.
EFF_DATE_CHAR VARCHAR2 30 Effective date in varchar as sent to SLA event API.
GL_DATE DATE Yes 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 30 Cost UOM ( is this same as the costing UOM).
BASE_CURRENCY_CODE VARCHAR2 30 Yes Base currency of the legal entity.
ACCOUNTED_FLAG VARCHAR2 1 Yes Indicates if the distribution has been accounted by the SLA. N - Not accounted, D - Draft Accounted, F - Final Accounted
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.
PJC_TXN_STATUS_CODE VARCHAR2 1 Indicates whether the distribution record has been interfaced to projects or not.
PERIOD_NAME VARCHAR2 15 Period in which the inventory valuation will be calculated.
START_DATE DATE Start Date of the period.
END_DATE DATE End date of the period.

Indexes

Index Uniqueness Columns
CST_COST_DISTRIBUTIONS_I_GT_U1 Unique DISTRIBUTION_ID
CST_COST_DISTRIBUTIONS_I_GT_U2 Unique EVENT_ID