1. Tables and Views for Financials
  2. ZX_TAX_LINES_INTERFACE

ZX_TAX_LINES_INTERFACE

This table stores external transaction tax lines to be imported into tax repository directly.

Details

  • Schema: FUSION

  • Object owner: ZX

  • Object type: TABLE

  • Tablespace: INTERFACE

Primary Key

Name Columns

ZX_TAX_LINES_INTERFACE_PK

APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, SUMMARY_TAX_LINE_NUMBER, TRX_ID

Columns

Name Datatype Length Precision Not-null Comments
TRX_LINE_ID NUMBER 18 Transaction line identifier
INTERFACE_TAX_LINE_ID NUMBER 18 Column to temporarily store identifier of the interface line corresponding to this tax line
INTERFACE_ENTITY_CODE VARCHAR2 30 Column to temporarily store entity code of the tax line interface table
TAX_LINE_ALLOCATION_FLAG VARCHAR2 4 Y or N indicates whether ZX_TRX_TAX_LINK_GT contains allocations of this imported tax line to multiple transaction lines
EXEMPT_CERTIFICATE_NUMBER VARCHAR2 80 Tax exemption certificate number
EXEMPT_REASON_CODE VARCHAR2 30 Tax exemption reason code
TAX_EXEMPTION_ID NUMBER 18 Tax exemption identifier for this tax line
TAX_EXCEPTION_ID NUMBER 18 Tax exception identifier for this tax line
TAX_RATE_ID NUMBER 18 Tax rate identifier for this tax line
TAX_AMT_INCLUDED_FLAG VARCHAR2 1 Y or N indicates whether this tax line is inclusive
TAX_JURISDICTION_CODE VARCHAR2 30 Tax jurisdiction code for this tax line
TAX_AMT NUMBER Tax amount for this tax line
TAX_RATE NUMBER Tax rate for this tax line
TAX_RATE_CODE VARCHAR2 50 Tax rate code for this tax line
TAX_STATUS_CODE VARCHAR2 30 Tax status code for this tax line
TAX VARCHAR2 30 Tax for this tax line
TAX_REGIME_CODE VARCHAR2 30 Tax regime code for this tax line
TRX_ID NUMBER 18 Yes Primary transaction identifier for the imported transaction
EVENT_CLASS_CODE VARCHAR2 30 Yes Application event class of the imported transaction
ENTITY_CODE VARCHAR2 30 Yes Entity code of the application event class for the imported transaction
APPLICATION_ID NUMBER 18 Yes Application Identifier of the imported transaction
INTERNAL_ORGANIZATION_ID NUMBER 18 Yes Internal organization identifier of the imported transaction
SUMMARY_TAX_LINE_NUMBER NUMBER Yes Line number to uniquely identify this imported tax line
SUBSCRIPTION_DATE DATE Oracle internal use only
TAX_DATE DATE Oracle internal use only
RECORD_TYPE_CODE VARCHAR2 30 Internal Use Only.
LAST_UPDATE_DATE TIMESTAMP Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
LAST_UPDATED_BY VARCHAR2 64 Who column: indicates the user who last updated the row.
CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Who column: indicates the user who created the row.
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
LOAD_REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the interface load job that created the row.
LOAD_STATUS VARCHAR2 30 Enterprise Service Scheduler: indicates the request status of the interface load job that created the row.
TRX_NUMBER VARCHAR2 150 Alphanumeric identifier on a transaction.
TRX_APPL_SHORT_NAME VARCHAR2 1000 Application short name of the transaction.
BU_NAME VARCHAR2 240 Business unit associated with the transaction.
LINE_NUMBER NUMBER Numeric identifier of a line on a transaction.
BATCH_NAME VARCHAR2 80 To identify the name of the batch containing external taxable transactions.

Indexes

Index Uniqueness Tablespace Columns
ZX_TAX_LINES_INTERFACE_N1 Non Unique Default BATCH_NAME, TRX_NUMBER, LINE_NUMBER
ZX_TAX_LINES_INTERFACE_U1 Unique Default APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, SUMMARY_TAX_LINE_NUMBER, TRX_ID