CMF_FISCAL_DOC_EVENT_LOG
Fiscal document Event Log stores any sort of electronic transmission history that is made regarding a Fiscal Document. Any need for electronic transmission of any fiscal document information is going to be sent/received through this Log table.
Details
-
Schema: FUSION
-
Object owner: CMF
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CMF_FISCAL_DOC_EVENT_LOG_PK |
EVENT_LOG_IDENTIFIER |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| EVENT_LOG_IDENTIFIER | NUMBER | 18 | Yes | Fiscal Document Event Log identifier. | |
| FD_HEADER_IDENTIFIER | NUMBER | 18 | Yes | Fiscal Document Header identifier. | |
| FD_LINE_IDENTIFIER | NUMBER | 18 | Fiscal Document Line identifier. | ||
| FD_SCHEDULE_IDENTIFIER | NUMBER | 18 | Fiscal Document Schedule identifier. | ||
| TAXPAYERID | VARCHAR2 | 64 | Tax Payer ID that issued the fiscal document. | ||
| ACCESS_KEY | VARCHAR2 | 64 | Fiscal Document Access Key Code. | ||
| PARENT_EVENT_LOG_IDENTIFIER | NUMBER | 18 | References the Event Log Identifier of the parent record. | ||
| EVENT_NAME | VARCHAR2 | 32 | Event Name related to the message. Possible values are: NFEVALIDATION, CTEVALIDATION, NFECONFIRM. | ||
| EVENT_CODE | VARCHAR2 | 32 | Event Code to be informed when event can perform several actions. | ||
| EVENT_DATE | DATE | Indicates the date when the event is created. | |||
| EVENT_ACTION | VARCHAR2 | 32 | Event action can be SEND or RECEIVE. | ||
| EVENT_STATUS | VARCHAR2 | 32 | Returned Status as provided by government (Action = RECEIVE). For action = SEND, the value is NULL. | ||
| COUNTRY | VARCHAR2 | 64 | Country information related to the Fiscal Document origin. | ||
| STATE | VARCHAR2 | 64 | State to process the transaction. | ||
| PROCESSING_DATE | DATE | Date when the line was processed. | |||
| 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_FISCAL_DOC_EVENT_LOG_N1 | Non Unique | Default | FD_HEADER_IDENTIFIER |
| CMF_FISCAL_DOC_EVENT_LOG_U1 | Unique | Default | EVENT_LOG_IDENTIFIER |