JL_MX_JE_LINES_T

This table contains all the information about the journals created for the period.

Details

• Schema: FUSION

• Object owner: JL

• Object type: TABLE

• Tablespace: SUMMARY

Primary Key

Name	Columns
JL_MX_JE_LINES_T_PK	MX_JE_LINE_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.	Active
MX_JE_LINE_ID	NUMBER		18	Yes	Journal line unique identifier	Active
APPLICATION_ID	NUMBER		18		Application identifier	Active
JE_HEADER_ID	NUMBER		18		Journal header identifier	Active
GL_JE_NAME	VARCHAR2	100			Journal header name	Active
HEADER_DESCRIPTION	VARCHAR2	1000			Journal header description	Active
JOURNAL_DATE	DATE				Journal entry date	Active
GL_DATE	DATE				Journal accounting date	Active
SLA_HEADER_ID	NUMBER		18		Subledger journal header identifier	Active
JE_LINE_NUM	NUMBER		18		Journal line number	Active
ORIG_LINE_NUMBER	NUMBER		18		Original journal or subledger line number	Active
LINE_DESCRIPTION	VARCHAR2	1000			Original journal or subledger line description	Active
ENTITY_ID	NUMBER		18		Source application entity identifier	Active
ENTITY_CODE	VARCHAR2	30			Source application entity code	Active
EVENT_ID	NUMBER		18		Subledger event identifier	Active
EVENT_CLASS_CODE	VARCHAR2	30			Subledger event class code	Active
EVENT_TYPE_CODE	VARCHAR2	30			Subledger event type code	Active
SOURCE_ID_INT_1	NUMBER		38		Subledger entity identifier	Active
ACCOUNTED_DR	NUMBER				Accounted debit amount	Active
ACCOUNTED_CR	NUMBER				Accounted credit amount	Active
ENTERED_DR	NUMBER				Entered debit amount	Active
ENTERED_CR	NUMBER				Entered credit amount	Active
CODE_COMBINATION_ID	NUMBER		18		Accounting code combination identifier	Active
COMPANY_BSV	VARCHAR2	25			Balancing segment value	Active
COMPANY_BSV_DESC	VARCHAR2	240			Balancing segment description	Active
NATURAL_ACCOUNT	VARCHAR2	25			Natural account segment value	Active
NATURAL_ACCOUNT_DESC	VARCHAR2	240			Natural account segment description	Active
SUB_ACCT	VARCHAR2	25			Subaccount segment value	Active
SUB_ACCT_DESC	VARCHAR2	240			Subaccount segment description	Active
PARTY_NAME	VARCHAR2	360			Third-party name	Active
PARTY_TAXPAYER_NUM	VARCHAR2	30			Third-party taxpayer identifier	Active
ADDIT_INFO_1	VARCHAR2	100			Additional information	Active
ADDIT_INFO_2	VARCHAR2	100			Additional information	Active
ADDIT_INFO_3	VARCHAR2	100			Additional information	Active
ADDIT_INFO_4	VARCHAR2	100			Additional information	Active
ADDIT_INFO_5	VARCHAR2	100			Additional information	Active
JOB_DEFINITION_NAME	VARCHAR2	100			Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.	Active
JOB_DEFINITION_PACKAGE	VARCHAR2	900			Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.	Active
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.	Active
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.	Active
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.	Active
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.	Active
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.	Active

Foreign Keys

Table	Foreign Table	Foreign Key Column
JL_MX_JE_LINES_T	gl_je_headers	JE_HEADER_ID
jl_mx_je_line_details_t	jl_mx_je_lines_t	MX_JE_LINE_ID

Indexes

Index	Uniqueness	Tablespace	Columns	Status
JL_MX_JE_LINES_T_U1	Unique	FUSION_TS_TX_IDX	MX_JE_LINE_ID	Active