JL_MX_JE_LINE_DETAILS_T

This table contains the data used to populate the subledger transcation and its payments details.

Details

• Schema: FUSION

• Object owner: JL

• Object type: TABLE

• Tablespace: SUMMARY

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		Journal line unique identifier	Active
INVOICE_ID	NUMBER		18		Invoice unique identifier	Active
INVOICE_CFDI	VARCHAR2	150			Invoice digital tax receipt via internet unique identifier	Active
INVOICE_CFD_CBB_SERIES	VARCHAR2	150			Invoice digital tax receipt serial number	Active
INVOICE_CFD_CBB_NUMBER	VARCHAR2	150			Invoice digital tax receipt number	Active
FOREIGN_INVOICE_NUMBER	VARCHAR2	150			Foreign invoice number	Active
INVOICE_AMOUNT	NUMBER				Invoice amount in entered currency	Active
INV_CUR_CODE	VARCHAR2	15			Invoice currency code	Active
INV_EXCHANGE_RATE	NUMBER				Invoice exchange rate	Active
THIRD_PARTY_ID	NUMBER		18		Third-party identifier	Active
THIRD_PARTY_NAME	VARCHAR2	360			Third-party name	Active
THIRD_PARTY_TAXPAYER_NUM	VARCHAR2	30			Third-party taxpayer identifier	Active
PAY_SCHED_NUM	NUMBER		18		Payment schedule number	Active
PAY_SCHED_CFDI	VARCHAR2	150			Payment schedule digital tax receipt via internet unique identifier	Active
PAY_SCHED_CFD_CBB_SERIES	VARCHAR2	150			Payment schedule digital tax receipt serial number	Active
PAY_SCHED_CFD_CBB_NUMBER	VARCHAR2	150			Payment schedule digital tax receipt number	Active
PAY_SCHED_AMOUNT	NUMBER				Payment schedule amount in entered currency	Active
PAYMENT_ID	NUMBER		18		Payment idemtifier	Active
PAYMENT_NUMBER	NUMBER		18		Payment number	Active
PAYMENT_AMOUNT	NUMBER				Payment amount in entered currency	Active
PAYMENT_DATE	DATE				Payment date	Active
PAYMENT_CUR_CODE	VARCHAR2	15			Payment currency code	Active
PAYMENT_EXCHANGE_RATE	NUMBER		18		Payment exchange rate	Active
PAYMENT_METHOD_CODE	VARCHAR2	30			Payment method code	Active
PAYMENT_TYPE_CODE	VARCHAR2	25			Payment type code	Active
PROCESSING_TYPE	VARCHAR2	30			Payment processing type	Active
SOURCE_BANK_ID	NUMBER		18		Source bank identifier	Active
FOREIGN_SOURCE_BANK_FLAG	VARCHAR2	1			Indicates whether source bank is located in foreign country	Active
SOURCE_BANK_NAME	VARCHAR2	360			Source bank name	Active
SOURCE_ACCOUNT_ID	NUMBER		18		Source bank account identifier	Active
SOURCE_ACCOUNT_NUM	VARCHAR2	30			Source bank account number	Active
FOREIGN_DEST_BANK_FLAG	VARCHAR2	1			Indicates whether destination bank is located in foreign country	Active
DEST_BANK_ID	NUMBER		18		Destination bank identifier	Active
DEST_BANK_NAME	VARCHAR2	360			Destination bank name	Active
DEST_ACCT_ID	NUMBER		18		Destination account identifier	Active
DEST_ACCT_NUM	VARCHAR2	30			Destination account number	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_LINE_DETAILS_T	jl_mx_je_lines_t	MX_JE_LINE_ID

Indexes

Index	Uniqueness	Tablespace	Columns	Status
JL_MX_JE_LINES_DETAILS_T_U1	Unique	FUSION_TS_TX_IDX	MX_JE_LINE_ID, PAY_SCHED_NUM	Active