JL_BR_EILOG
This table is an audit trial (log) table to keep track of the communication between partner software and tax authority, related to the submission and status transition changes for the electronic invoice.
Details
-
Schema: FUSION
-
Object owner: JL
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
Name | Columns |
---|---|
JL_BR_EILOG_PK |
OCCURRENCE_ID, OCCURRENCE_DATE, CUSTOMER_TRX_ID, ELECTRONIC_INV_STATUS |
Columns
Name | Datatype | Length | Precision | Not-null | Comments | Status |
---|---|---|---|---|---|---|
OCCURRENCE_ID | NUMBER | 18 | Yes | Bank correction identifier on audit trial table. | Active | |
OCCURRENCE_DATE | DATE | Yes | Correction date on an imported bank occurrence document. | Active | ||
CUSTOMER_TRX_ID | NUMBER | 18 | Yes | Customer transaction identifier on an audit trial table. | Active | |
ELECTRONIC_INV_STATUS | VARCHAR2 | 1 | Yes | Customer electronic invoice status on audit trail. | Active | |
MESSAGE_TXT | VARCHAR2 | 1000 | Error message from tax authority on audit trial table. | Active | ||
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | Active | ||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | Active | |
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | Active | ||
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | Active | ||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | Active | |
OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
JL_BR_EILOG_U1 | Unique | Default | OCCURRENCE_ID, OCCURRENCE_DATE, CUSTOMER_TRX_ID, ELECTRONIC_INV_STATUS |