eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Table: LNS_LOAN_HEADERS_ALL

Product:	LNS - Loans
Description:	Loans Header Table
Implementation/DBA Data:	LNS.LNS_LOAN_HEADERS_ALL

Primary Key: LNS_LOAN_HEADERS_ALL_PK

LOAN_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
LNS_LOAN_HEADERS_ALL	HZ_PARTIES	LNS_LOAN_HEADERS_ALL.PRIMARY_BORROWER_ID
LNS_LOAN_HEADERS_ALL	HZ_PARTIES	LNS_LOAN_HEADERS_ALL.CONTACT_PERS_PARTY_ID
LNS_LOAN_HEADERS_ALL	HZ_PARTIES	LNS_LOAN_HEADERS_ALL.CONTACT_REL_PARTY_ID
LNS_LOAN_HEADERS_ALL	HZ_CUST_ACCOUNTS	LNS_LOAN_HEADERS_ALL.CUST_ACCOUNT_ID
LNS_LOAN_HEADERS_ALL	RA_CUSTOMER_TRX_ALL	LNS_LOAN_HEADERS_ALL.REFERENCE_ID
LNS_LOAN_HEADERS_ALL	RA_CUST_TRX_TYPES_ALL	LNS_LOAN_HEADERS_ALL.REFERENCE_TYPE_ID
LNS_LOAN_HEADERS_ALL	HZ_CUST_ACCT_SITES_ALL	LNS_LOAN_HEADERS_ALL.BILL_TO_ACCT_SITE_ID
LNS_LOAN_HEADERS_ALL	%	LNS_LOAN_HEADERS_ALL.PRODUCT_ID
LNS_LOAN_HEADERS_ALL	JTF_RS_RESOURCE_EXTNS	LNS_LOAN_HEADERS_ALL.LOAN_ASSIGNED_TO
LNS_LOAN_HEADERS_ALL	JTF_RS_RESOURCE_EXTNS	LNS_LOAN_HEADERS_ALL.LOAN_APPROVED_BY
LNS_LOAN_HEADERS_ALL	HR_ALL_ORGANIZATION_UNITS	LNS_LOAN_HEADERS_ALL.ORG_ID
LNS_LOAN_HISTORIES_H	LNS_LOAN_HEADERS_ALL	LNS_LOAN_HISTORIES_H.LOAN_ID
LNS_PARTICIPANTS	LNS_LOAN_HEADERS_ALL	LNS_PARTICIPANTS.LOAN_ID
LNS_TERMS	LNS_LOAN_HEADERS_ALL	LNS_TERMS.LOAN_ID