DBA Data[Home] [Help] [Dependency Information]

TABLE: JL.JL_BR_EILOG

Object Details
Object Name: JL_BR_EILOG
Object Type: TABLE
Owner: JL
FND Design Data: TableJL.JL_BR_EILOG
Subobject Name:
Status: VALID


JL_BR_EILOG is an audit trial(log) table to keep track of the communication between partner software and tax authority (and vice-versa), related to the submission and status transition changes for the electronic invoice


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
OCCURRENCE_ID NUMBER (15) Yes Sequential Number
OCCURRENCE_DATE DATE
Yes Occurrence Date
CUSTOMER_TRX_ID NUMBER (15) Yes Invoice Identifier
ELECTRONIC_INV_STATUS VARCHAR2 (1) Yes Electronic Invoice Status
MESSAGE_TXT VARCHAR2 (2000)
Error Message from Tax Authority
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who last updated this row
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row
CREATION_DATE DATE
Yes Standard who column - date when this row was created
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT OCCURRENCE_ID
,      OCCURRENCE_DATE
,      CUSTOMER_TRX_ID
,      ELECTRONIC_INV_STATUS
,      MESSAGE_TXT
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
FROM JL.JL_BR_EILOG;

Dependencies

[top of page]

JL.JL_BR_EILOG does not reference any database object

JL.JL_BR_EILOG is referenced by following:

SchemaAPPS
SynonymJL_BR_EILOG