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 |