JG_FSCL_ATRB_INT_ERRORS_ALL_GT
This table stores information about interface data required for generating fiscal document that failed the validation process.
Details
-
Schema: FUSION
-
Object owner: JG
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| INTERFACE_HDR_ID | NUMBER | 18 | Yes | Interface header identifier of the document. | |
| INTERFACE_LINE_ID | NUMBER | 18 | Interface line identifier corresponding to the transaction line during importing transactions. | ||
| INTERFACE_LINE_DETAIL_ID | NUMBER | 18 | Interface line detail identifier. | ||
| HDR_ATRB_DTL_INT_ID | NUMBER | 18 | Interface legal message identifier for a transaction. | ||
| TRX_LINE_NUMBER | NUMBER | 18 | Numeric identifier of a transaction line. | ||
| APP_SHORT_NAME | VARCHAR2 | 30 | Yes | Application short name of the transaction. | |
| ENTITY_CODE | VARCHAR2 | 30 | Yes | Entity code of the transaction, which indicates the type of transaction being created. | |
| EVENT_CLASS_CODE | VARCHAR2 | 30 | Yes | Application event class of the transaction, such as requisition, purchase order and agreement, and release. | |
| TRX_NUMBER | VARCHAR2 | 150 | Numeric identifier of a transaction. | ||
| ORG_ID | NUMBER | 18 | Indicates the identifier of the business unit associated to the row. | ||
| MESSAGE_TEXT | VARCHAR2 | 1000 | Yes | Message text associated with the error code. | |
| MESSAGE_CAUSE | VARCHAR2 | 1000 | Message cause associated with the error code. | ||
| MESSAGE_USER_ACTION | VARCHAR2 | 1000 | Message user action associated with the error code. | ||
| MESSAGE_NAME | VARCHAR2 | 30 | Standard message name for the validation error. | ||
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| JG_FSCL_ATRB_INT_ERRORS_ALL_N1 | Non Unique | Default | INTERFACE_HDR_ID, INTERFACE_LINE_ID, INTERFACE_LINE_DETAIL_ID, HDR_ATRB_DTL_INT_ID, APP_SHORT_NAME, ENTITY_CODE, EVENT_CLASS_CODE |