ZX_PTNR_NEG_TAX_LINE_GT
This is a temporary table which is used internally by Oracle.
Details
-
Schema: FUSION
-
Object owner: ZX
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Columns
| Name | Datatype | Length | Precision | Comments |
|---|---|---|---|---|
| TAX_LINE_ID | NUMBER | 18 | Tax line identifier | |
| DOCUMENT_TYPE_ID | NUMBER | 18 | Event class mapping identifier | |
| APPLICATION_ID | NUMBER | 18 | Application Identifier of the transaction | |
| ENTITY_CODE | VARCHAR2 | 30 | Entity code of the application event class for the transaction | |
| EVENT_CLASS_CODE | VARCHAR2 | 30 | Application event class of the transaction | |
| TRX_ID | NUMBER | 18 | Primary transaction identifier | |
| TRX_LINE_ID | NUMBER | 18 | Transaction line identifier | |
| TRX_LEVEL_TYPE | VARCHAR2 | 30 | Column to record the level at which the transaction line identifier is stored. Possible values are LINE, SHIPMENT and FREIGHT. | |
| COUNTRY_CODE | VARCHAR2 | 30 | Tax regime code | |
| TAX | VARCHAR2 | 30 | Tax | |
| SITUS | VARCHAR2 | 30 | Lookup code for place of supply type | |
| TAX_JURISDICTION | VARCHAR2 | 30 | Tax jurisdiction code | |
| TAX_CURRENCY_CODE | VARCHAR2 | 30 | Tax currency code | |
| TAX_CURR_TAX_AMOUNT | NUMBER | Tax amount in tax currency | ||
| TAX_AMOUNT | NUMBER | Tax amount in transaction currency | ||
| TAX_RATE_PERCENTAGE | NUMBER | 18 | Tax rate | |
| TAXABLE_AMOUNT | NUMBER | Taxable amount in transaction currency | ||
| EXEMPT_CERTIFICATE_NUMBER | VARCHAR2 | 180 | Tax exemption certificate number | |
| EXEMPT_RATE_MODIFIER | NUMBER | 18 | Percentage of the original tax rate that is exempt | |
| EXEMPT_REASON | VARCHAR2 | 240 | Tax exemption reason | |
| TAX_ONLY_LINE_FLAG | VARCHAR2 | 1 | Y or N indicates whether this is a tax only line | |
| INCLUSIVE_TAX_LINE_FLAG | VARCHAR2 | 1 | Y or N indicates whether this tax line is inclusive | |
| USE_TAX_FLAG | VARCHAR2 | 1 | Y or N indicates whether this is a self-assessed tax line | |
| EBIZ_OVERRIDE_FLAG | VARCHAR2 | 1 | Y or N indicates whether Oracle eBusiness suite has overridden this tax line | |
| USER_OVERRIDE_FLAG | VARCHAR2 | 1 | Y or N indicates whether user has overridden this tax line | |
| LAST_MANUAL_ENTRY | VARCHAR2 | 30 | Column to indicate which column is last overridden by the user. Possible values are TAX_STATUS, TAX_RATE, TAX_RATE_CODE and TAX_AMOUNT. | |
| MANUALLY_ENTERED_FLAG | VARCHAR2 | 1 | Y or N indicates whether this tax line is manually entered by the user | |
| CANCEL_FLAG | VARCHAR2 | 1 | Y or N indicates whether this tax line is cancelled by the user | |
| DELETE_FLAG | VARCHAR2 | 1 | Y or N indicates whether this tax line is marked for delete by the user |