ZX_ERRORS_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 |
|---|---|---|---|---|---|
| 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 | Yes | Primary transaction identifier | ||
| TRX_LINE_ID | NUMBER | Transaction line identifier | |||
| SUMMARY_TAX_LINE_NUMBER | NUMBER | Summary tax line identifier | |||
| TRX_LINE_DIST_ID | NUMBER | Item distribution identifier | |||
| MESSAGE_TEXT | VARCHAR2 | 2000 | Yes | Translated message text | |
| TAX_LINE_ID | NUMBER | 18 | Tax line identifier | ||
| TRX_LEVEL_TYPE | VARCHAR2 | 30 | Column to record the level at which the transaction line identifier is stored. Possible values are LINE, SHIPMENT and FREIGHT. | ||
| MESSAGE_CAUSE | VARCHAR2 | 4000 | Message cause | ||
| MESSAGE_USER_ACTION | VARCHAR2 | 4000 | Message user action | ||
| MESSAGE_NAME | VARCHAR2 | 60 | Oracle internal use only. | ||
| TOKEN1_NAME | VARCHAR2 | 60 | Oracle internal use only. | ||
| TOKEN1_VALUE | VARCHAR2 | 240 | Oracle internal use only. | ||
| TOKEN2_NAME | VARCHAR2 | 60 | Oracle internal use only. | ||
| TOKEN2_VALUE | VARCHAR2 | 240 | Oracle internal use only. | ||
| TOKEN3_NAME | VARCHAR2 | 60 | Oracle internal use only. | ||
| TOKEN3_VALUE | VARCHAR2 | 240 | Oracle internal use only. | ||
| TOKEN4_NAME | VARCHAR2 | 60 | Oracle internal use only. | ||
| TOKEN4_VALUE | VARCHAR2 | 240 | Oracle internal use only. | ||
| TOKEN5_NAME | VARCHAR2 | 60 | Oracle internal use only. | ||
| TOKEN5_VALUE | VARCHAR2 | 240 | Oracle internal use only. | ||
| TOKEN6_NAME | VARCHAR2 | 60 | Oracle internal use only. | ||
| TOKEN6_VALUE | VARCHAR2 | 240 | Oracle internal use only. | ||
| ERROR_PROCEDURE_NAME | VARCHAR2 | 30 | Column to store the procedure or function name that raises the error during tax calculation or recovery processing. | ||
| ERROR_PACKAGE_NAME | VARCHAR2 | 30 | Column to store the package name that raises the error during tax calculation or recovery processing. | ||
| ERROR_DETAILS | VARCHAR2 | 2000 | Column to store the details of the error raised during tax calculation or recovery processing. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| ZX_ERRORS_GT_N1 | Non Unique | APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, TRX_LEVEL_TYPE, SUMMARY_TAX_LINE_NUMBER, TAX_LINE_ID, TRX_LINE_DIST_ID |