CST_COST_DIST_LINES_GT
Temporary table used within the distribution processor to create the distribution lines.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Comments |
|---|---|---|---|---|
| DISTRIBUTION_ID | NUMBER | 18 | Single column FK: Identifies the cost distribution header record. | |
| TRANSACTION_EVENT_ID | NUMBER | 18 | Reference to the transaction event type from cst_transaction_events. | |
| 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. | |
| SOURCE_TABLE | VARCHAR2 | 30 | Indicates the source_table from which the distribution is created. | |
| EVENT_ID | NUMBER | 18 | Reference to the event created in the SLA for this distribution header line. | |
| ENTITY_CODE | VARCHAR2 | 30 | Reference to the Entity of the event for distribution. | |
| EVENT_CLASS_CODE | VARCHAR2 | 30 | Reference to event class for which the accounting template is defined. | |
| EVENT_TYPE_CODE | VARCHAR2 | 30 | Reference to the Event type of the event for the distribution. | |
| LEGAL_ENTITY_ID | NUMBER | 18 | 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 will be recorded. | |
| COST_ORGANIZATION_ID | NUMBER | 18 | Cost organization of the transaction for which the distribution is created. | |
| COST_BOOK_ID | NUMBER | 18 | Cost book within the cost organization for which the distribution is created. | |
| INVENTORY_ORG_ID | NUMBER | 18 | Indicates The Inventory Org To Which The Item Belongs. | |
| COST_ID | NUMBER | 18 | Reference to layer_cost_id, writeoff_cost_id, transfer_cost_id. | |
| TRANSACTION_ID | NUMBER | 18 | Reference to the transaction for which the distribution is created. | |
| REC_TRXN_ID | NUMBER | 18 | Reference to the receipt layer for which the distribution is created. | |
| DEP_TRXN_ID | NUMBER | 18 | Reference to the depletion layer for which the distribution is created. | |
| 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. | |
| EFF_DATE | TIMESTAMP | Date from which the cost is effective. | ||
| ACCOUNTING_DATE | TIMESTAMP | 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 processed. 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. | |
| ENTERED_CURRENCY_CODE | VARCHAR2 | 30 | Transaction currency for a distribution line. | |
| BASE_CURRENCY_CODE | VARCHAR2 | 30 | Base currency of the legal entity. | |
| ACCOUNTED_FLAG | VARCHAR2 | 1 | Indicates if the distribution has been accounted by the SLA. N - Not accounted, D - Draft Accounted, F - Final Accounted. | |
| DISTRIBUTION_LINE_ID | NUMBER | 18 | Surrogate identifying the distribution line. | |
| ACCOUNTING_DEFINITION_ID | NUMBER | 18 | Reference to the cost accounting definition line. | |
| TRANSACTION_COST_ID | NUMBER | 18 | Reference to the transaction cost of the receipt for which the distribution is created. | |
| LINE_NO | NUMBER | 5 | Line number for a distribution. | |
| JOURNAL_LINE_TYPE | VARCHAR2 | 30 | Journal line type of the distribution line. | |
| ENTERED_CURRENCY_AMOUNT | NUMBER | Distribution line amount in the transaction currency. | ||
| LEDGER_AMOUNT | NUMBER | Distribution line amount in the base currency. | ||
| EXCHANGE_RATE | NUMBER | Exchange rate on the transaction date. | ||
| EXCHANGE_DATE | DATE | Date for which exchange rate is picked. | ||
| EXCHANGE_RATE_TYPE | VARCHAR2 | 30 | Exchange rate conversion type used. | |
| CODE_COMBINATION_ID | NUMBER | 18 | Contains the Code combination of the account entered by the users while creating the transactions (Misc. Transactions). | |
| DR_CR_SIGN | VARCHAR2 | 6 | Debit or Credit indicator for the amount. | |
| COST_ELEMENT_ID | NUMBER | 18 | Cost element corresponding to the cost of the transaction. | |
| TRANSACTION_NUMBER | VARCHAR2 | 240 | Numeric identifier on a transaction that is used as a primary identifier of the transaction. | |
| ERROR_CODE | VARCHAR2 | 30 | Error, if any, for the transaction. If the transaction has an error, it will logged and no distribution will be created for the transaction. | |
| TOKEN1_NAME | VARCHAR2 | 30 | Token name as required by error code message. | |
| TOKEN1_VALUE | VARCHAR2 | 240 | Token value as required by error code message. | |
| TOKEN2_NAME | VARCHAR2 | 30 | Token name as required by error code message. | |
| TOKEN2_VALUE | VARCHAR2 | 240 | Token value as required by error code message. | |
| TOKEN3_NAME | VARCHAR2 | 30 | Token name as required by error code message. | |
| TOKEN3_VALUE | VARCHAR2 | 240 | Token value as required by error code message. | |
| TOKEN4_NAME | VARCHAR2 | 30 | Token name as required by error code message. | |
| TOKEN4_VALUE | VARCHAR2 | 240 | Token value as required by error code message. | |
| TOKEN5_NAME | VARCHAR2 | 30 | Token name as required by error code message. | |
| TOKEN5_VALUE | VARCHAR2 | 240 | Token value as required by error code message. | |
| TOKEN6_NAME | VARCHAR2 | 30 | Token name as required by error code message. | |
| TOKEN6_VALUE | VARCHAR2 | 240 | Token value as required by error code message. | |
| 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. | ||
| PJC_TXN_STATUS_CODE | VARCHAR2 | 1 | Indicates whether the distribution record has been interfaced to projects or not. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_COST_DIST_LINES_GT_N1 | Non Unique | COST_ID |
| CST_COST_DIST_LINES_GT_N2 | Non Unique | DISTRIBUTION_LINE_ID |
| CST_COST_DIST_LINES_GT_N3 | Non Unique | SOURCE_TABLE |
| CST_COST_DIST_LINES_GT_N4 | Non Unique | DISTRIBUTION_ID |
| CST_COST_DIST_LINES_GT_N5 | Non Unique | ERROR_CODE, DISTRIBUTION_ID, DISTRIBUTION_LINE_ID |