CMR_TRADE_TAXES_GT
This table contains the trade event taxes for current loaded trade events and is a global temporary table.
Details
-
Schema: FUSION
-
Object owner: CMR
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TRADE_EVENT_TAX_ID | NUMBER | 18 | Yes | Trade Event Tax Identifier. | |
| TRX_ID | VARCHAR2 | 30 | Yes | Transaction Identifier. | |
| TRADE_EVENT_ID | NUMBER | 18 | Yes | Trade Event Identifier. | |
| APPLICATION_ID | NUMBER | Yes | Application Identifier. | ||
| EVENT_CLASS_CODE | VARCHAR2 | 30 | Yes | Event Class Code of the tax transaction. | |
| ENTITY_CODE | VARCHAR2 | 30 | Yes | Entity Code of the tax transaction. | |
| REC_NREC_TAX_AMT | NUMBER | Yes | The calculated tax amount of the tax line. | ||
| TXN_CURRENCY_CODE | VARCHAR2 | 15 | Transaction Currency Code. | ||
| TAX_CURRENCY_CODE | VARCHAR2 | 15 | Tax Currency Code of the transaction. | ||
| TXN_UOM_CODE | VARCHAR2 | 30 | Transaction Unit of Measure. | ||
| RECOVERABLE_FLAG | VARCHAR2 | 1 | Yes | This option indicates whether it is recoverable or non recoverable tax. | |
| TAX_POINT_BASIS | VARCHAR2 | 30 | Tax point basis applicable to the tax line. | ||
| INCLUSIVE_FLAG | VARCHAR2 | 1 | This option indicates that the line amount is inclusive of tax. | ||
| RECOVERY_TYPE_CODE | VARCHAR2 | 30 | Tax recovery type code based on tax set up and returned by TAX call API. | ||
| RECOVERY_RATE_CODE | VARCHAR2 | 150 | Recovery rate code defined on tax. | ||
| REC_NREC_TAX_DIST_ID | NUMBER | 18 | Yes | Recoverable or non recoverable tax distribution identifier. | |
| REC_NREC_CCID | NUMBER | Recoverable tax account. | |||
| TAX_LIABILITY_CCID | NUMBER | Tax liability account. | |||
| TRX_LINE_DIST_AMT | NUMBER | Transaction line distribution amount. | |||
| TRX_LINE_DIST_QTY | NUMBER | Transaction line distribution quantity. | |||
| TRX_LINE_ID | NUMBER | Yes | Transaction line identifier. | ||
| TRX_LINE_DIST_ID | NUMBER | Yes | Transaction line distribution identifier. | ||
| TRX_LEVEL_TYPE | VARCHAR2 | 30 | Transaction level type. | ||
| TAX_REGIME_ID | NUMBER | 18 | Tax regime identifier. | ||
| TAX_REGIME_CODE | VARCHAR2 | 30 | Tax regime. | ||
| TAX_ID | NUMBER | 18 | Tax identifier. | ||
| TAX | VARCHAR2 | 30 | Tax name. | ||
| TAX_STATUS_ID | NUMBER | 18 | Tax status identifier. | ||
| TAX_STATUS_CODE | VARCHAR2 | 30 | Tax status name. | ||
| TAX_RATE_ID | NUMBER | 18 | Tax rate identifer. | ||
| TAX_RATE_CODE | VARCHAR2 | 150 | Tax rate name. | ||
| TAX_RATE | NUMBER | Tax rate for the tax line based on the tax setup. | |||
| TAX_JURISDICTION_ID | NUMBER | 18 | Tax jurisdiction identifier. | ||
| SELF_ASSESSED_FLAG | VARCHAR2 | 1 | This option indicates that the tax on this tax line is self assessed. | ||
| REPORTABLE_FLAG | VARCHAR2 | 1 | Reportable indicator. | ||
| REVERSED_TAX_DIST_ID | NUMBER | Reversed tax distribution identifier. | |||
| REVERSE_FLAG | VARCHAR2 | 1 | Reverse indicator. | ||
| REF_DOC_PER_UNIT_NREC_TAX_AMT | NUMBER | Reference document per unit non recoverable tax amount. | |||
| DEL_BASED_TAX_CONSIGNED_FLAG | VARCHAR2 | 150 | Delivery based tax indicator for consigned transactions. | ||
| CURRENCY_CONVERSION_RATE | NUMBER | Currency conversion rate for tax transaction. |