1. Tables and Views for Financials
  2. ZX_TAX_ALLOCS_INTERFACE

ZX_TAX_ALLOCS_INTERFACE

This table stores the transaction line information to which the external tax line should be allocated to.

Details

  • Schema: FUSION

  • Object owner: ZX

  • Object type: TABLE

  • Tablespace: INTERFACE

Primary Key

Name Columns

ZX_TAX_ALLOCS_INTERFACE_PK

APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, SUMMARY_TAX_LINE_NUMBER, TRX_LEVEL_TYPE, TRX_ID, TRX_LINE_ID

Columns

Name Datatype Length Precision Not-null Comments Status
INTERFACE_LINE_ID NUMBER 18 Column to temporarily store identifier of the interface line corresponding to the transaction line during import of transactions into Receivables Active
INTERFACE_TAX_LINE_ID NUMBER 18 Column to temporarily store identifier of the interface line corresponding to this tax line during import of transactions into Receivables Active
APPLICATION_ID NUMBER 18 Yes Application identifier of the transaction Active
ENTITY_CODE VARCHAR2 30 Yes Entity code of the transaction Active
EVENT_CLASS_CODE VARCHAR2 30 Yes Event class code of the transaction Active
INTERFACE_LINE_ENTITY_CODE VARCHAR2 30 Column to temporarily store entity code of the transaction line interface table Active
INTERFACE_TAX_ENTITY_CODE VARCHAR2 30 Column to temporarily store entity code of the tax line interface table Active
LINE_AMT NUMBER Yes Transaction line amount Active
SUMMARY_TAX_LINE_NUMBER NUMBER Yes Summary tax line number for the imported tax line Active
TRX_ID NUMBER 18 Yes Transaction identifier Active
TRX_LEVEL_TYPE VARCHAR2 30 Yes Column to record the level at which the transaction line identifier is stored. Possible values are LINE Active
TRX_LINE_ID NUMBER 18 Yes Transaction line identifier Active
LAST_UPDATE_DATE TIMESTAMP Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
LAST_UPDATED_BY VARCHAR2 64 Who column: indicates the user who last updated the row. Active
CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the row. Active
CREATED_BY VARCHAR2 64 Who column: indicates the user who created the row. Active
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.
LINE_NUMBER NUMBER Numeric identifier of a line on a transaction.
TAX_ALLOC_APPL_SHORT_NAME VARCHAR2 1000 Application short name of the transaction.
BATCH_NAME VARCHAR2 80 To identify the name of the batch containing external taxable transactions.

Indexes

Index Uniqueness Tablespace Columns
ZX_TAX_ALLOCS_INTERFACE_U1 Unique Default APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, SUMMARY_TAX_LINE_NUMBER, TRX_LEVEL_TYPE, TRX_ID, TRX_LINE_ID