ZX_VALIDATION_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 | 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 | Transaction identifier | |
| SUMMARY_TAX_LINE_NUMBER | NUMBER | Summary tax line number for the imported tax line | ||
| MESSAGE_TEXT | VARCHAR2 | 2000 | Yes | Translated message text |
| 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. | |
| TRX_LINE_ID | NUMBER | Transaction line identifier | ||
| MESSAGE_NAME | VARCHAR2 | 30 | Yes | Standard message name for the validation error |
| 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_LINE_ID | NUMBER | Column to temporarily store identifier of the interface line corresponding to this tax 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 | |
| OTHER_DOC_APPLICATION_ID | NUMBER | Application identifier for other documents like adjusted document if this error is specific to the other document | ||
| OTHER_DOC_ENTITY_CODE | VARCHAR2 | 30 | Entity code for other documents like adjusted document if this error is specific to the other document | |
| OTHER_DOC_EVENT_CLASS_CODE | VARCHAR2 | 30 | Event class code for other documents like adjusted document if this error is specific to the other document | |
| OTHER_DOC_TRX_ID | NUMBER | Transaction identifier for other documents like adjusted document if this error is specific to the other document |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| ZX_VALIDATION_ERRORS_GT_N1 | Non Unique | APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, TRX_LEVEL_TYPE, SUMMARY_TAX_LINE_NUMBER |