CST_TXN_DISTRIBUTIONS_GT
This is a flattened table with distribution details for all transactions in CST_TRANSACTIONS_GT table.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CST_TXN_DISTRIBUTIONS_PK |
DISTRIBUTION_LINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| DISTRIBUTION_LINE_ID | NUMBER | 18 | Yes | Surrogate identifying the distribution line. | |
| TRANSACTION_ID | NUMBER | 18 | Yes | Transaction identifier which uniquely identifies a transaction in costing. | |
| COST_ORG_NAME | VARCHAR2 | 240 | Yes | Denotes the translated name for the Cost Organization Unit. | |
| COST_BOOK_CODE | VARCHAR2 | 30 | Yes | A unique code given for a particular cost book. Usually named to indicate the purpose of that cost book. | |
| ITEM_NUMBER | VARCHAR2 | 300 | Yes | Value that identifies the inventory item associated with the transaction. | |
| INVENTORY_ORG_NAME | VARCHAR2 | 240 | Denotes the translated name for the Inventory Organization Unit. | ||
| TRANSACTION_NUMBER | VARCHAR2 | 240 | Transaction source doc type and txn_source_doc_number separated with '-'. | ||
| TRANSACTION_DATE | TIMESTAMP | The date when this transaction happened. | |||
| COST_DATE | TIMESTAMP | The date to be used for transaction sequencing. | |||
| TXN_SOURCE_REF_DOC_TYPE | VARCHAR2 | 50 | Transactions Source Documents Reference Document Type. | ||
| TXN_SOURCE_REF_DOC_NUMBER | VARCHAR2 | 240 | Transactions Source Documents Reference Document Number. | ||
| COSTING_STATUS | VARCHAR2 | 1 | Status of the transaction which denotes, whether a transaction has been pre-processed, processed by cost processors, distributions have been created or processed by sub-ledger accounting. | ||
| RESOURCE_NAME | VARCHAR2 | 120 | Indicates the name of the resource. | ||
| TRANSACTION_TYPE | VARCHAR2 | 80 | Transaction type name translated to the language. | ||
| ACCOUNTING_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. | ||
| ACCOUNTING_STATUS | VARCHAR2 | 1 | Current accounting status of the transaction for display: N-Not Processed, D-Draft Accounted, F-Final Accounted, E-Error, X-Excluded from Accounting. | ||
| ACCOUNTING_LINE_TYPE | VARCHAR2 | 80 | Accounting line type of the distribution line. | ||
| COST_ELEMENT_CODE | VARCHAR2 | 80 | Indicates the value of cost element code. | ||
| ENTERED_AMOUNT | NUMBER | Distribution line amount in the transaction currency. | |||
| ENTERED_CURRENCY_CODE | VARCHAR2 | 30 | Transaction currency code for selected events. Note that not all events will have the transaction currency code. cst_acct_definitions.use_txn_curr_amount indictaes which events will have the transaction currency code & amounts. | ||
| ACCOUNTED_AMOUNT | NUMBER | Distribution line amount in the base currency. | |||
| ACCOUNTED_CURRENCY_CODE | VARCHAR2 | 30 | Base currency of the legal entity. | ||
| DR_CR_SIGN | VARCHAR2 | 6 | Debit or Credit for the amount. | ||
| ENTERED_PRECISION | NUMBER | 1 | Indicates the value of entered precision. | ||
| ENTERED_EXTENDED_PRECISION | NUMBER | 2 | Indicates the value of entered extended precision. | ||
| ACCOUNTED_PRECISION | NUMBER | 1 | Indicates the value of accounted precision. | ||
| ACCOUNTED_EXTENDED_PRECISION | NUMBER | 2 | Indicates the value of accounted extended precision. | ||
| EVENT_TYPE | VARCHAR2 | 80 | Reference to the Event type of the event for the distribution. | ||
| TRANSACTION_ACCOUNT | VARCHAR2 | 300 | Account entered by the users while creating the transactions. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_TXN_DISTRIBUTIONS_U1 | Unique | DISTRIBUTION_LINE_ID |