LNS Tables (38)

LNS - Loans — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

Table	Columns	Description
`LNS_AMORTIZATION_LINES`	16	Amortization Lines reprensents the details of any give Amortization represented on the Amortization Schedules table
`LNS_AMORTIZATION_SCHEDS`	53	Amortizations Table - Records installments due for a loan as billing generates them. Also stores any reversal and re-amortization informati
`LNS_AMORT_SCHEDS_GT`	27
`LNS_APPROVAL_ACTIONS`	32	Loans Approval Actions Table
`LNS_ASSETS`	51	LNS_ASSETS is used to store the assets of a loan participant.
`LNS_ASSET_ASSIGNMENTS`	33	LNS_ASSET_ASSIGNMENTS stores the assignment of assets to a loan as collateral.
`LNS_BORROWER_SUMMARIES`	51	Borrower Summary Table
`LNS_CONDITIONS`	35	Loan Conditions Table
`LNS_COND_ASSIGNMENTS`	20	Loan Condition Assignment Table
`LNS_CUSTOM_PAYMNT_SCHEDS`	43	Loans Custom Schedule Table
`LNS_DEFAULT_DISTRIBS_ALL`	48	Loans Default Distributions Table - This table establishes the accounting to default for loans and fees. The Default for loans will be base
`LNS_DISB_HEADERS`	18	This table stores header level disbursement information
`LNS_DISB_HISTORIES_H`	15	This table stores disbursement changes
`LNS_DISB_LINES`	22	Stores line level disbursement information
`LNS_DISTRIBUTIONS`	54	Loans Distributions Table - stores actual accounting distributions for a give loan_id
`LNS_EVENTS`	13	This table stores actionable events for a loan class
`LNS_EVENT_ACTIONS`	26	This table stores actionable events for a Loan type and loan class
`LNS_EVT_ACTION_HISTORY_H`	16	This table stores the information about workflow actions performed for a Loan event
`LNS_FEES_ALL`	26	Loan Fees Setup Table
`LNS_FEE_ASSIGNMENTS`	26	Loan Fees Assignment Table
`LNS_FEE_SCHEDULES`	20	Loans Fees Schedules Table
`LNS_INT_RATE_HEADERS`	9	Interest Rate Headers table
`LNS_INT_RATE_LINES`	11	Interest Rate Lines Table
`LNS_LOAN_API_ERRORS_GT`	4
`LNS_LOAN_CREATE_ERRORS_GT`	4
`LNS_LOAN_DOCUMENTS`	17	This table stores all the documents related to a Source Object
`LNS_LOAN_HEADERS_ALL`	108	Loans Header Table
`LNS_LOAN_HISTORIES_H`	14	Loan History Table
`LNS_LOAN_LINES`	24	Loan Lines Table
`LNS_LOAN_PRODUCTS_ALL`	94	Loan Product Setup Table
`LNS_LOAN_PRODUCTS_ALL_TL`	10	Stores the multi lingual columns for each record of the base table LNS_LOAN_PRODUCTS_ALL
`LNS_LOAN_PRODUCT_FLAGS`	8	Loan Product Setup Read-Only Column Names Table
`LNS_LOAN_PRODUCT_LINES`	17	Loan Product Setup Lines Table
`LNS_LOAN_TYPES`	21	Loan Types Setup Table
`LNS_PARTICIPANTS`	42	Loan Participants Table
`LNS_RATE_SCHEDULES`	19	Loan Interest Rate Schedule Table
`LNS_SYSTEM_OPTIONS_ALL`	67	Loans System Options Table
`LNS_TERMS`	71	Loans Terms Table