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 |