CMF_FD_EXCEPTIONS_INT
Stores the Exceptions found in Fiscal Document data validation.
Details
-
Schema: FUSION
-
Object owner: CMF
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
CMF_FD_EXCEPTIONS_INT_PK |
EXCEPTION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| EXCEPTION_ID | NUMBER | 18 | Yes | Stores the Unique key which identifies the row. | |
| FD_HEADERS_INT_ID | NUMBER | 18 | Yes | Stores the foreign key which identifies the Interface FD Header row. | |
| INTERFACE_ENTITY_ID | NUMBER | 18 | Yes | Stores the foreign key which identifies the Child Entity row. | |
| INTERFACE_ENTITY_TYPE | VARCHAR2 | 30 | Yes | Stores the child entity name identification. | |
| EXCEPTION_CODE | VARCHAR2 | 30 | Yes | Stores the identification of the error found in the validation process. The value will be taken from the lookup CMF_EXCEPTION_TYPE. | |
| ERROR_CODE | VARCHAR2 | 80 | Yes | Stores the error code found in the validations and derivations. | |
| ERROR_DESCR | VARCHAR2 | 900 | Stores the error description found in the validations and derivations. | ||
| TOKEN1_NAME | VARCHAR2 | 30 | Token name as required by error code message. | ||
| TOKEN1_VALUE | VARCHAR2 | 240 | Token value as required by error code message. | ||
| TOKEN2_NAME | VARCHAR2 | 30 | Token name as required by error code message. | ||
| TOKEN2_VALUE | VARCHAR2 | 240 | Token value as required by error code message. | ||
| TOKEN3_NAME | VARCHAR2 | 30 | Token name as required by error code message. | ||
| TOKEN3_VALUE | VARCHAR2 | 240 | Token value as required by error code message. | ||
| TOKEN4_NAME | VARCHAR2 | 30 | Token name as required by error code message. | ||
| TOKEN4_VALUE | VARCHAR2 | 240 | Token value as required by error code message. | ||
| TOKEN5_NAME | VARCHAR2 | 30 | Token name as required by error code message. | ||
| TOKEN5_VALUE | VARCHAR2 | 240 | Token value as required by error code message. | ||
| TOKEN6_NAME | VARCHAR2 | 30 | Token name as required by error code message. | ||
| TOKEN6_VALUE | VARCHAR2 | 240 | Token value as required by error code message. | ||
| EXTERNAL_SYSTEM_REFERENCE | VARCHAR2 | 240 | Is used for backend processing based on the interface records. | ||
| EXTERNAL_SYSTEM_REF_ID | VARCHAR2 | 30 | Is used for backend processing based on the interface records. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CMF_FD_EXCEPTIONS_INT_N1 | Non Unique | Default | FD_HEADERS_INT_ID |
| CMF_FD_EXCEPTIONS_INT_N2 | Non Unique | Default | INTERFACE_ENTITY_ID |
| CMF_FD_EXCEPTIONS_INT_U1 | Unique | FUSION_TS_TX_DATA | EXCEPTION_ID |