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