ZX_TRX_TAX_LINK_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 | Not-null | Comments |
|---|---|---|---|---|
| APPLICATION_ID | NUMBER | Yes | Application identifier of the transaction | |
| ENTITY_CODE | VARCHAR2 | 30 | Yes | Entity code of the transaction |
| EVENT_CLASS_CODE | VARCHAR2 | 30 | Yes | Event class code of the transaction |
| TRX_ID | NUMBER | Transaction identifier | ||
| HDR_TRX_USER_KEY1 | VARCHAR2 | 150 | First component of the user composite key to uniquely identify the transaction | |
| HDR_TRX_USER_KEY2 | VARCHAR2 | 150 | Second component of the user composite key to uniquely identify the transaction | |
| HDR_TRX_USER_KEY3 | VARCHAR2 | 150 | Third component of the user composite key to uniquely identify the transaction | |
| HDR_TRX_USER_KEY4 | VARCHAR2 | 150 | Fourth component of the user composite key to uniquely identify the transaction | |
| HDR_TRX_USER_KEY5 | VARCHAR2 | 150 | Fifth component of the user composite key to uniquely identify the transaction | |
| HDR_TRX_USER_KEY6 | VARCHAR2 | 150 | Sixth component of the user composite key to uniquely identify the transaction | |
| TRX_LEVEL_TYPE | VARCHAR2 | 30 | Yes | Column to record the level at which the transaction line identifier is stored. Possible values are LINE, SHIPMENT and FREIGHT. |
| TRX_LINE_ID | NUMBER | Transaction line identifier | ||
| LINE_TRX_USER_KEY1 | VARCHAR2 | 150 | First component of the line user composite key for uniquely identifying the transaction line | |
| LINE_TRX_USER_KEY2 | VARCHAR2 | 150 | Second component of the line user composite key for uniquely identifying the transaction line | |
| LINE_TRX_USER_KEY3 | VARCHAR2 | 150 | Third component of the line user composite key for uniquely identifying the transaction line | |
| LINE_TRX_USER_KEY4 | VARCHAR2 | 150 | Fourth component of the line user composite key for uniquely identifying the transaction line | |
| LINE_TRX_USER_KEY5 | VARCHAR2 | 150 | Fifth component of the line user composite key for uniquely identifying the transaction line | |
| LINE_TRX_USER_KEY6 | VARCHAR2 | 150 | Sixth component of the line user composite key for uniquely identifying the transaction line | |
| SUMMARY_TAX_LINE_NUMBER | NUMBER | Yes | Summary tax line number for the imported tax line | |
| LINE_AMT | NUMBER | Yes | Transaction line amount | |
| INTERFACE_LINE_ENTITY_CODE | VARCHAR2 | 30 | Column to temporarily store entity code of the transaction line interface table | |
| INTERFACE_LINE_ID | NUMBER | Column to temporarily store identifier of the interface line corresponding to the transaction line during import of transactions into Receivables | ||
| INTERFACE_TAX_ENTITY_CODE | VARCHAR2 | 30 | Column to temporarily store entity code of the tax line interface table | |
| 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 |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| ZX_TRX_TAX_LINK_GT_U1 | Unique | APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, TRX_LEVEL_TYPE, SUMMARY_TAX_LINE_NUMBER |