1. Tables and Views for Financials
  2. ZX_IMPORT_TAX_LINES_GT

ZX_IMPORT_TAX_LINES_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 Not-null Comments Status
SUMMARY_TAX_LINE_NUMBER NUMBER Yes Line number to uniquely identify this imported tax line Active
INTERNAL_ORGANIZATION_ID NUMBER Yes Internal organization identifier of the imported transaction Active
APPLICATION_ID NUMBER Yes Application Identifier of the imported transaction Active
ENTITY_CODE VARCHAR2 30 Yes Entity code of the application event class for the imported transaction Active
EVENT_CLASS_CODE VARCHAR2 30 Yes Application event class of the imported transaction Active
TRX_ID NUMBER Primary transaction identifier for the imported transaction Active
HDR_TRX_USER_KEY1 VARCHAR2 150 First component of the user composite key to uniquely identify the imported transaction Active
HDR_TRX_USER_KEY2 VARCHAR2 150 Second component of the user composite key to uniquely identify the imported transaction Active
HDR_TRX_USER_KEY3 VARCHAR2 150 Third component of the user composite key to uniquely identify the imported transaction Active
HDR_TRX_USER_KEY4 VARCHAR2 150 Fourth component of the user composite key to uniquely identify the imported transaction Active
HDR_TRX_USER_KEY5 VARCHAR2 150 Fifth component of the user composite key to uniquely identify the imported transaction Active
HDR_TRX_USER_KEY6 VARCHAR2 150 Sixth component of the user composite key to uniquely identify the imported transaction Active
TAX_REGIME_CODE VARCHAR2 30 Tax regime code for this tax line Active
TAX VARCHAR2 30 Tax for this tax line Active
TAX_STATUS_CODE VARCHAR2 30 Tax status code for this tax line Active
TAX_RATE_CODE VARCHAR2 50 Tax rate code for this tax line Active
TAX_RATE NUMBER Tax rate for this tax line Active
TAX_AMT NUMBER Tax amount for this tax line Active
TAX_JURISDICTION_CODE VARCHAR2 30 Tax jurisdiction code for this tax line Active
TAX_AMT_INCLUDED_FLAG VARCHAR2 1 Y or N indicates whether this tax line is inclusive Active
TAX_RATE_ID NUMBER 18 Tax rate identifier for this tax line Active
TAX_PROVIDER_ID NUMBER 18 Party tax profile identifier for the third party service provider for the regime of this tax line Active
TAX_EXCEPTION_ID NUMBER Tax exception identifier for this tax line Active
TAX_EXEMPTION_ID NUMBER Tax exemption identifier for this tax line Active
EXEMPT_REASON_CODE VARCHAR2 30 Tax exemption reason code Active
EXEMPT_CERTIFICATE_NUMBER VARCHAR2 80 Tax exemption certificate number Active
TAX_LINE_ALLOCATION_FLAG VARCHAR2 1 Y or N indicates whether ZX_TRX_TAX_LINK_GT contains allocations of this imported tax line to multiple transaction lines Active
INTERFACE_ENTITY_CODE VARCHAR2 30 Column to temporarily store entity code of the tax line interface table Active
INTERFACE_TAX_LINE_ID NUMBER Column to temporarily store identifier of the interface line corresponding to this tax line during import of transactions into Receivables Active
TRX_LINE_ID NUMBER Transaction line identifier for the imported transaction line to which this tax line is fully allocated; NULL if this tax line is allocated to more than one transaction line or is not allocated to any transaciton line Active
TAX_DATE DATE Oracle internal use only
SUBSCRIPTION_DATE DATE Oracle internal use only
ATTRIBUTE_CATEGORY VARCHAR2 50 Descriptive Flexfield: structure definition of the user descriptive flexfield.
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 150 Global Descriptive Flexfield: structure definition of the global descriptive flexfield.
GLOBAL_ATTRIBUTE1 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE2 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE3 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE4 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE5 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE6 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE7 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE8 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE9 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE10 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE11 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE12 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE13 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE14 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE15 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE16 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE17 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE18 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE19 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE20 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER1 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER2 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER3 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER4 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER5 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE1 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE2 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE3 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE4 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE5 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
REPORTING_ONLY_FLAG VARCHAR2 1 Indicates whether this tax line is created for reporting only. Valid values: Y and N.

Indexes

Index Uniqueness Columns Status
ZX_IMPORT_TAX_LINES_GT_N1 Non Unique APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, TAX_REGIME_CODE, TAX
ZX_IMPORT_TAX_LINES_GT_U1 Unique APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, SUMMARY_TAX_LINE_NUMBER Active