CST_COST_DISTRIBUTIONS
This table contains the distribution header information for the costing transactions. Distribution processor creates data in this table before it is accounted into SLA.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
CST_COST_DISTRIBUTIONS_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 | Transaction identifier of a receipt transaction. | ||
| DEP_TRXN_ID | NUMBER | 18 | Transaction identifier of a depleting transaction. | ||
| 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 | Date from which the cost is effective. | |||
| 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. | ||
| PERIOD_NAME | VARCHAR2 | 15 | Period in which the transaction is costed. This value is populated for the transactions in periodic average cost method. | ||
| ACCOUNTING_PERIOD_NAME | VARCHAR2 | 15 | Period in which the transaction is accounted. This value is populated for the transactions in periodic average cost method. | ||
| 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 | Unit of measure for the transaction quantity. | ||
| 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. | |
| VAL_ONHAND_FLAG | VARCHAR2 | 1 | Indicates if the onhand calculations have been done for the distribution. Values: N = No processed, NULL = Processed for onhand calculations. | ||
| GROSS_MARGIN_FLAG | VARCHAR2 | 1 | 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 | 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. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| CST_COST_DISTRIBUTIONS | cst_cost_org_books | COST_ORGANIZATION_ID, COST_BOOK_ID |
| CST_COST_DISTRIBUTIONS | gl_ledgers | LEDGER_ID |
| cst_cost_distribution_lines | cst_cost_distributions | DISTRIBUTION_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CST_COST_DISTRIBUTIONS_N1 | Non Unique | FUSION_TS_TX_DATA | COST_ORGANIZATION_ID, COST_BOOK_ID, EVENT_CLASS_CODE, EVENT_TYPE_CODE |
| CST_COST_DISTRIBUTIONS_N2 | Non Unique | Default | TRANSACTION_ID, REC_TRXN_ID, DEP_TRXN_ID, COST_TRANSACTION_TYPE, ADDITIONAL_PROCESSING_CODE |
| CST_COST_DISTRIBUTIONS_N3 | Non Unique | FUSION_TS_TX_DATA | REQUEST_ID |
| CST_COST_DISTRIBUTIONS_N4 | Non Unique | Default | COST_ORGANIZATION_ID, ACCOUNTED_FLAG, GL_DATE |
| CST_COST_DISTRIBUTIONS_N5 | Non Unique | Default | PJC_TXN_STATUS_CODE |
| CST_COST_DISTRIBUTIONS_N6 | Non Unique | Default | VAL_ONHAND_FLAG, COST_ORGANIZATION_ID, COST_BOOK_ID, ACCOUNTED_FLAG, TRUNC("GL_DATE") |
| CST_COST_DISTRIBUTIONS_N7 | Non Unique | Default | GROSS_MARGIN_FLAG, COST_ORGANIZATION_ID |
| CST_COST_DISTRIBUTIONS_PK | Unique | FUSION_TS_TX_DATA | DISTRIBUTION_ID |
| CST_COST_DISTRIBUTIONS_U2 | Unique | FUSION_TS_TX_DATA | EVENT_ID |