Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - LNS Tables and Views

TABLE - LNS.LNS_AMORTIZATION_LINES
TABLE - LNS.LNS_AMORTIZATION_SCHEDS
TABLE - LNS.LNS_AMORT_SCHEDS_GT
TABLE - LNS.LNS_APPROVAL_ACTIONS
TABLE - LNS.LNS_ASSETS
TABLE - LNS.LNS_ASSET_ASSIGNMENTS
TABLE - LNS.LNS_BORROWER_SUMMARIES
TABLE - LNS.LNS_CONDITIONS
TABLE - LNS.LNS_COND_ASSIGNMENTS
TABLE - LNS.LNS_CUSTOM_PAYMNT_SCHEDS
TABLE - LNS.LNS_DEFAULT_DISTRIBS_ALL
TABLE - LNS.LNS_DISB_HEADERS
TABLE - LNS.LNS_DISB_HISTORIES_H
TABLE - LNS.LNS_DISB_LINES
TABLE - LNS.LNS_DISTRIBUTIONS
TABLE - LNS.LNS_EVENTS
TABLE - LNS.LNS_EVENT_ACTIONS
TABLE - LNS.LNS_EVT_ACTION_HISTORY_H
TABLE - LNS.LNS_FEES_ALL
TABLE - LNS.LNS_FEE_ASSIGNMENTS
TABLE - LNS.LNS_FEE_SCHEDULES
TABLE - LNS.LNS_INT_RATE_HEADERS
TABLE - LNS.LNS_INT_RATE_LINES
TABLE - LNS.LNS_LOAN_API_ERRORS_GT
TABLE - LNS.LNS_LOAN_CREATE_ERRORS_GT
TABLE - LNS.LNS_LOAN_DOCUMENTS
TABLE - LNS.LNS_LOAN_HEADERS_ALL
TABLE - LNS.LNS_LOAN_HISTORIES_H
TABLE - LNS.LNS_LOAN_LINES
TABLE - LNS.LNS_LOAN_PRODUCTS_ALL
TABLE - LNS.LNS_LOAN_PRODUCTS_ALL_TL
TABLE - LNS.LNS_LOAN_PRODUCT_FLAGS
TABLE - LNS.LNS_LOAN_PRODUCT_LINES
TABLE - LNS.LNS_LOAN_TYPES
TABLE - LNS.LNS_PARTICIPANTS
TABLE - LNS.LNS_RATE_SCHEDULES
TABLE - LNS.LNS_SYSTEM_OPTIONS_ALL
TABLE - LNS.LNS_TERMS
VIEW - APPS.LNS_AEL_GL_V
VIEW - APPS.LNS_AMORTIZATION_SCHEDULES_V
VIEW - APPS.LNS_AM_SCHEDS_DTL_V
VIEW - APPS.LNS_AM_SCHEDS_V
VIEW - APPS.LNS_AR_AMORTIZATIONS_V
VIEW - APPS.LNS_LOAN_DETAILS_EXT_V
VIEW - APPS.LNS_LOAN_HEADERS_EXT_V
VIEW - APPS.LNS_LOAN_INFO
VIEW - APPS.LNS_LOAN_PARTICIPANTS_V
VIEW - APPS.LNS_LOAN_PAYMENT_SUMMARY_V
VIEW - APPS.LNS_LOAN_PRODUCTS_ALL_VL
VIEW - APPS.LNS_LOAN_PRODUCTS_VL
VIEW - APPS.LNS_LOAN_SUMMARY_V
VIEW - APPS.LNS_LOOKUPS
VIEW - APPS.LNS_OPEN_RECEIVABLES_V
VIEW - APPS.LNS_PAYMENTS_SUMMARY_V
VIEW - APPS.LNS_PAY_SUM_OVERDUE_V
VIEW - APPS.LNS_PAY_SUM_V
VIEW - APPS.LNS_PAY_SUM_YEARLY_V
VIEW - APPS.LNS_RECEIVABLE_ACTIVITIES_V
VIEW - APPS.LNS_REC_ACT_ADJ_V
VIEW - APPS.LNS_REC_ACT_CASH_CM_V
VIEW - APPS.LNS_SL_GL_V2

Table: LNS_AMORTIZATION_LINES

Description: Amortization Lines reprensents the details of any give Amortization represented on the Amortization Schedules table
Primary Key: LNS_AMORTIZATION_LINES_PK
  1. AMORTIZATION_LINE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
LNS_AMORTIZATION_LINES.AMORTIZATION_SCHEDULE_ID %
LNS_AMORTIZATION_LINES.LOAN_ID %
LNS_AMORTIZATION_LINES.CUST_TRX_ID RA_CUSTOMER_TRX_ALL
LNS_AMORTIZATION_LINES.CUST_TRX_LINE_ID RA_CUSTOMER_TRX_LINES_ALL
Comments

Amortization Lines reprensents the details of any give Amortization represented on the Amortization Schedules table

Indexes
Index Type Tablespace Column
LNS_AMORTIZATION_LINES_U1 UNIQUE APPS_TS_TX_IDX AMORTIZATION_LINE_ID
LNS_AMORTIZATION_LINES_U2 UNIQUE APPS_TS_TX_IDX CUST_TRX_LINE_ID
LNS_AMORTIZATION_LINES_N1 NONUNIQUE APPS_TS_TX_IDX LOAN_ID
AMORTIZATION_SCHEDULE_ID
Columns
Name Datatype Length Mandatory Comments
AMORTIZATION_LINE_ID NUMBER (15) Y Amortization Line Identifier
AMORTIZATION_SCHEDULE_ID NUMBER (15) Y Amortization Schedule identifier (foreign key to LNS_AMORTIZATION_SCHEDS.AMORTIZATION_SCHEDULE_ID)
LOAN_ID NUMBER (15) Y Loan identifier (foreign key to LNS_LOAN_HEADERS_ALL.LOAN_ID)
FEE_SCHEDULE_ID NUMBER (15)
FK to LNS_FEE_SCHEDULES
LINE_TYPE VARCHAR2 (30)
Amortization Line Type (INTEREST, PRINCIPAL, FEES)
AMOUNT NUMBER

Amortization Line Amount
CUST_TRX_ID NUMBER (15)
Customer Transaction identifier (foreign key to RA_CUSTOMER_TRX.CUSTOMER_TRX_ID)
CUST_TRX_LINE_ID NUMBER (15)
Customer Transaction Line identifier (foreign key to RA_CUSTOMER_TRX_LINES.CUSTOMER_TRX_LINE_ID)
FEE_ID NUMBER (15)
Fee identifier (foreign key to LNS_FEE_ASSIGNMENTS.FEE_ID)
OBJECT_VERSION_NUMBER NUMBER
Y Standard who column
CREATION_DATE DATE
Y Standard who column
CREATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
LINE_DETAILS VARCHAR2 (2000)
Line Details

[top of page]

LNS.LNS_AMORTIZATION_LINES does not reference any database object

LNS.LNS_AMORTIZATION_LINES is referenced by following:

LNS
VIEW - LNS_AMORTIZATION_LINES#

[top of page]

Table: LNS_AMORTIZATION_SCHEDS

Description: Amortizations Table - Records installments due for a loan as billing generates them. Also stores any reversal and re-amortization information
Primary Key: LNS_AMORTIZATION_SCHEDS_PK
  1. AMORTIZATION_SCHEDULE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
LNS_AMORTIZATION_SCHEDS.LOAN_ID %
LNS_AMORTIZATION_SCHEDS.PRINCIPAL_TRX_ID RA_CUSTOMER_TRX_ALL
LNS_AMORTIZATION_SCHEDS.INTEREST_TRX_ID RA_CUSTOMER_TRX_ALL
LNS_AMORTIZATION_SCHEDS.FEE_TRX_ID RA_CUSTOMER_TRX_ALL
LNS_AMORTIZATION_SCHEDS.RATE_ID %
Comments

Amortizations Table - Records installments due for a loan as billing generates them. Also stores any reversal and re-amortization information

Indexes
Index Type Tablespace Column
LNS_AMORTIZATION_SCHEDS_U1 UNIQUE APPS_TS_TX_IDX AMORTIZATION_SCHEDULE_ID
SYS_IL0000406253C00020$$ UNIQUE APPS_TS_TX_DATA
LNS_AMORTIZATION_SCHEDS_N1 NONUNIQUE APPS_TS_TX_IDX LOAN_ID
PAYMENT_NUMBER
Columns
Name Datatype Length Mandatory Comments
AMORTIZATION_SCHEDULE_ID NUMBER (15) Y Primary Key
LOAN_ID NUMBER (15) Y FK to LNS_LOAN_HEADERS_ALL.LOAN_ID
PAYMENT_NUMBER NUMBER

Payment or installment number ordered numerically
DUE_DATE DATE

Payment Due Date
LATE_DATE DATE

Date after which payment is considered late
PRINCIPAL_AMOUNT NUMBER

Amount of principal on installment
INTEREST_AMOUNT NUMBER

Amount of interest on installment
OTHER_AMOUNT NUMBER

Any other amount on installment (not fees)
REVERSED_FLAG VARCHAR2 (1)
Flag indicating if payment was reversed or not
REVERSED_DATE DATE

Date on which payment was reversed
RATE_ID NUMBER (15)
FK to LNS_RATE_SCHEDULES.RATE_ID
PARENT_AMORTIZATION_ID NUMBER

PARENT_AMORTIZATION_ID
REAMORTIZATION_AMOUNT NUMBER

Amount to be re-amortized
REAMORTIZE_FROM_INSTALLMENT NUMBER

Installment to begin reamortization from (includes this installment number)
REAMORTIZE_TO_INSTALLMENT NUMBER

for future use
FEE_AMOUNT NUMBER

Any fees amount on installment
PRINCIPAL_TRX_ID NUMBER

FK to RA_CUSTOMER_TRX_ALL.Customer_Trx_ID for principal
INTEREST_TRX_ID NUMBER

FK to RA_CUSTOMER_TRX_ALL.Customer_Trx_ID for interest
FEE_TRX_ID NUMBER

FK to RA_CUSTOMER_TRX_ALL.Customer_Trx_ID for fees
STATEMENT_XML CLOB (4000)
xml doc representing the generated invoice
PRINCIPAL_BALANCE NUMBER

Principal balance at the time of billing. Set only for open phase installments.
PHASE VARCHAR2 (30)
Phase of installment
CREATED_BY NUMBER (15) Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Attribute Category
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE1
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE2
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE3
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE4
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE5
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE6
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE7
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE8
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE9
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE10
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE11
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE12
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE13
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE14
ATTRIBUTE15 VARCHAR2 (150)
ATTRIBUTE15
ATTRIBUTE16 VARCHAR2 (150)
ATTRIBUTE16
ATTRIBUTE17 VARCHAR2 (150)
ATTRIBUTE17
ATTRIBUTE18 VARCHAR2 (150)
ATTRIBUTE18
ATTRIBUTE19 VARCHAR2 (150)
ATTRIBUTE19
ATTRIBUTE20 VARCHAR2 (150)
ATTRIBUTE20
OBJECT_VERSION_NUMBER NUMBER
Y OBJECT_VERSION_NUMBER
FUNDED_AMOUNT NUMBER

Funded Amount
DEFERRED_INT_AMOUNT NUMBER

Deferred Interest Amount
CAP_INT_AMOUNT NUMBER

Total Capitalized Interest Amount
CURR_CAP_INT_AMOUNT NUMBER

Capitalized Interest Amount for current installment

[top of page]

LNS.LNS_AMORTIZATION_SCHEDS does not reference any database object

LNS.LNS_AMORTIZATION_SCHEDS is referenced by following:

LNS
VIEW - LNS_AMORTIZATION_SCHEDS#

[top of page]

Table: LNS_AMORT_SCHEDS_GT

Description:
Comments
Indexes
Index Type Tablespace Column
LNS_AMORT_SCHEDS_GT_U1 UNIQUE LOAN_ID
INSTALLMENT_NUMBER
Columns
Name Datatype Length Mandatory Comments
LOAN_ID NUMBER (15) Y
INSTALLMENT_NUMBER NUMBER
Y
DUE_DATE DATE

PRINCIPAL_AMOUNT NUMBER

INTEREST_AMOUNT NUMBER

FEE_AMOUNT NUMBER

OTHER_AMOUNT NUMBER

BEGIN_BALANCE NUMBER

END_BALANCE NUMBER

TOTAL NUMBER

INTEREST_CUMULATIVE NUMBER

PRINCIPAL_CUMULATIVE NUMBER

FEES_CUMULATIVE NUMBER

OTHER_CUMULATIVE NUMBER

RATE_ID NUMBER (15)
SOURCE VARCHAR2 (30)
GRAND_TOTAL_FLAG VARCHAR2 (1)
PREV_DEFERRED_INT_AMOUNT NUMBER

DEFERRED_INT_AMOUNT NUMBER

PREV_CAP_INT_AMOUNT NUMBER

CURR_CAP_INT_AMOUNT NUMBER

CAP_INT_AMOUNT NUMBER

NORMAL_INT_AMOUNT NUMBER

DISBURSEMENT_AMOUNT NUMBER

NORMAL_INT_DETAILS VARCHAR2 (2000)
DEFERRED_INT_DETAILS VARCHAR2 (2000)
CAP_INT_DETAILS VARCHAR2 (2000)

[top of page]

LNS.LNS_AMORT_SCHEDS_GT does not reference any database object

LNS.LNS_AMORT_SCHEDS_GT is referenced by following:

APPS
SYNONYM - LNS_AMORT_SCHEDS_GT

[top of page]

Table: LNS_APPROVAL_ACTIONS

Description: Loans Approval Actions Table
Primary Key: LNS_APPROVAL_ACTIONS_PK
  1. ACTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
LNS_APPROVAL_ACTIONS.LOAN_ID %
Comments

LNS_APPROVAL_ACTIONS logs all the actions taken on the loan throughout the approval process.

Indexes
Index Type Tablespace Column
LNS_APPROVAL_ACTIONS_U1 UNIQUE APPS_TS_TX_IDX ACTION_ID
LNS_APPROVAL_ACTIONS_N1 NONUNIQUE APPS_TS_TX_IDX LOAN_ID
Columns
Name Datatype Length Mandatory Comments
ACTION_ID NUMBER (15) Y Approval Action Id
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER (15) Y Standard Who Column
OBJECT_VERSION_NUMBER NUMBER
Y Object Version Number
LOAN_ID NUMBER (15) Y Loan Id
ACTION_TYPE VARCHAR2 (30) Y Type of Action Taken
AMOUNT NUMBER

Amount involved (e.g. amount submitted for approval, approved amount)
REASON_CODE VARCHAR2 (30)
Reason for Action (e.g. reason for rejecting loan)
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE_CATEGORY
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE1
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE2
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE3
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE4
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE5
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE6
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE7
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE8
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE9
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE10
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE11
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE12
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE13
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE14
ATTRIBUTE15 VARCHAR2 (150)
ATTRIBUTE15
ATTRIBUTE16 VARCHAR2 (150)
ATTRIBUTE16
ATTRIBUTE17 VARCHAR2 (150)
ATTRIBUTE17
ATTRIBUTE18 VARCHAR2 (150)
ATTRIBUTE18
ATTRIBUTE19 VARCHAR2 (150)
ATTRIBUTE19
ATTRIBUTE20 VARCHAR2 (150)
ATTRIBUTE20

[top of page]

LNS.LNS_APPROVAL_ACTIONS does not reference any database object

LNS.LNS_APPROVAL_ACTIONS is referenced by following:

LNS
VIEW - LNS_APPROVAL_ACTIONS#

[top of page]

Table: LNS_ASSETS

Description: LNS_ASSETS is used to store the assets of a loan participant.
Primary Key: LNS_ASSETS_PK
  1. ASSET_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
LNS_ASSETS.ASSET_OWNER_ID HZ_PARTIES
LNS_ASSETS.CUSTODIAN_ID HZ_PARTIES
LNS_ASSETS.CONTACT_PERS_PARTY_ID HZ_PARTIES
LNS_ASSETS.CONTACT_REL_PARTY_ID HZ_PARTIES
Foreign Keys to this table:
Foreign Key Column Foreign Table
LNS_ASSET_ASSIGNMENTS.ASSET_ID LNS_ASSETS
Comments

LNS_ASSETS is used to store the assets of a loan participant.

Indexes
Index Type Tablespace Column
LNS_ASSETS_U1 UNIQUE APPS_TS_TX_IDX ASSET_ID
LNS_ASSETS_N1 NONUNIQUE APPS_TS_TX_IDX ASSET_OWNER_ID
Columns
Name Datatype Length Mandatory Comments
ASSET_ID NUMBER (15) Y Asset identifier
CREATED_BY NUMBER (15) Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
ASSET_OWNER_ID NUMBER (15) Y Asset Owner Identifier
ASSET_CLASS_CODE VARCHAR2 (30) Y Asset Class Code
ASSET_TYPE_CODE VARCHAR2 (30) Y Asset Type Code
DESCRIPTION VARCHAR2 (360)
Description
VALUATION NUMBER
Y Value of asset
QUANTITY NUMBER
Y Quantity
UOM_CODE VARCHAR2 (30) Y Unit of measure
REFERENCE_TYPE VARCHAR2 (30) Y Reference Type
REFERENCE_NAME VARCHAR2 (250) Y Reference Name
ACQUIRED_ASSET_LOAN_ID NUMBER (15)
Loan identifier which this asset is acquired for
CURRENCY_CODE VARCHAR2 (30) Y Currency code
VALUATION_DATE DATE
Y Valuation date
VALUATION_METHOD_CODE VARCHAR2 (30) Y Valuation method code
START_DATE_ACTIVE DATE
Y Start date active
END_DATE_ACTIVE DATE

End date active
NEXT_EVALUATION_DATE DATE

Next valuation date
APPRAISER_NAME VARCHAR2 (250)
Name of appraiser
APPRAISER_PHONE_NUMBER VARCHAR2 (80)
Appraiser's phone number
CUSTODIAN_ID NUMBER (15)
Custodian identifier
CUSTODIAN_REF_NUM VARCHAR2 (250)
Custodian reference number
LIEN_AMOUNT NUMBER

Amount of lien
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE16 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE17 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE18 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE19 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE20 VARCHAR2 (150)
Descriptive flexfield segment
CONTACT_PERS_PARTY_ID NUMBER (15)
Identifier for Loan Contact Person Party
CONTACT_REL_PARTY_ID NUMBER (15)
Identifier for Loan Primary Contact Relationship Party
OBJECT_VERSION_NUMBER NUMBER
Y Object Version Number

[top of page]

LNS.LNS_ASSETS does not reference any database object

LNS.LNS_ASSETS is referenced by following:

LNS
VIEW - LNS_ASSETS#

[top of page]

Table: LNS_ASSET_ASSIGNMENTS

Description: LNS_ASSET_ASSIGNMENTS stores the assignment of assets to a loan as collateral.
Primary Key: LNS_ASSET_ASSIGNMENTS_PK
  1. ASSET_ASSIGNMENT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
LNS_ASSET_ASSIGNMENTS.ASSET_ID LNS_ASSETS
Comments

LNS_ASSET_ASSIGNMENTS stores the assignment of assets to a loan as collateral

Indexes
Index Type Tablespace Column
LNS_ASSET_ASSIGNMENTS_U1 UNIQUE APPS_TS_TX_IDX ASSET_ASSIGNMENT_ID
LNS_ASSET_ASSIGNMENTS_N1 NONUNIQUE APPS_TS_TX_IDX LOAN_ID
LNS_ASSET_ASSIGNMENTS_N2 NONUNIQUE APPS_TS_TX_IDX ASSET_ID
Columns
Name Datatype Length Mandatory Comments
ASSET_ASSIGNMENT_ID NUMBER (15) Y Asset assignment identifier
CREATED_BY NUMBER (15) Y Standard who column
CREATION_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
LOAN_ID NUMBER (15) Y Loan identifier
ASSET_ID NUMBER (15) Y Asset identifier
PLEDGED_AMOUNT NUMBER
Y Amount pledged for loan
START_DATE_ACTIVE DATE

Start date active
END_DATE_ACTIVE DATE

End date active
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE16 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE17 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE18 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE19 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE20 VARCHAR2 (150)
Descriptive flexfield segment
OBJECT_VERSION_NUMBER NUMBER
Y Object Version Number

[top of page]

LNS.LNS_ASSET_ASSIGNMENTS does not reference any database object

LNS.LNS_ASSET_ASSIGNMENTS is referenced by following:

LNS
VIEW - LNS_ASSET_ASSIGNMENTS#

[top of page]

Table: LNS_BORROWER_SUMMARIES

Description: Borrower Summary Table
Comments

Borrower Summary Table

Columns
Name Datatype Length Mandatory Comments
BORROWER_PARTY_ID NUMBER (15) Y Borrower party ID. Primary key
BORROWER_NAME VARCHAR2 (360)
Borrower party name
TAX_PAYER_CODE VARCHAR2 (50)
Borrower tax ID
CUSTOMER_CLASSIFICATION VARCHAR2 (100)
Borrower customer classification
INDUSTRIAL_CLASSIFICATION VARCHAR2 (100)
Borrower industrial classification
YEAR_ESTABLISHED NUMBER

Year that the borrower began doing business
COUNTRY VARCHAR2 (60)
County of the Identifying address
ADDRESS1 VARCHAR2 (240)
First line of the Identifying address
ADDRESS2 VARCHAR2 (240)
Second line of the Identifying address
ADDRESS3 VARCHAR2 (240)
Third line of the Identifying address
ADDRESS4 VARCHAR2 (240)
Fourth line of the Identifying address
CITY VARCHAR2 (60)
City of the Identifying address
POSTAL_CODE VARCHAR2 (60)
Postal Code of the Identifying address
STATE VARCHAR2 (60)
State of the Identifying address
PRIMARY_CONTACT_NAME VARCHAR2 (360)
Primary contact name
PRIMARY_PHONE_COUNTRY_CODE VARCHAR2 (10)
Primary phone country code
PRIMARY_PHONE_AREA_CODE VARCHAR2 (10)
Primary phone area code
PRIMARY_PHONE_NUMBER VARCHAR2 (40)
Primary phone number
PRIMARY_PHONE_EXTENSION VARCHAR2 (20)
Primary phone extension
ANNUAL_REVENUE NUMBER

Borrowers organization potential revenue this fiscal year
CUSTOMER_SINCE DATE

Year that the borrower began to be a customer
NUM_ACTIVE_LOANS NUMBER

Number of active loans as primary borrower or co-borrower
TOTAL_REMAINING_PRINCIPAL NUMBER

Total remaining unpaid principal for all loans
TOTAL_PRINCIPAL_PAID_YTD NUMBER

Total paid principal for all loans
TOTAL_INTEREST_PAID_YTD NUMBER

Total paid interest for all loans
TOTAL_FEE_PAID_YTD NUMBER

Total paid fee for all loans
TOTAL_REQUESTED_LOAN_AMOUNT NUMBER

Total requested amount for all loans
TOTAL_APPROVED_LOAN_AMOUNT NUMBER

Total approved amount for all loans
PLEDGED_COLL_AMOUNT NUMBER

Pledge colletaral amount
LAST_COLL_VALUATION_DATE DATE

Last colletaral valuation date
CREDIT_CLASSIFICATION VARCHAR2 (30)
Borrower credit classification
REVIEW_CYCLE VARCHAR2 (30)
Review cycle of borrower profile data
LAST_CREDIT_REVIEW_DATE DATE

Date of last borrower profile data review
CREDIT_RATING VARCHAR2 (30)
Borrower credit rating
CREDIT_HOLD VARCHAR2 (1)
Indicates if a credit hold exists on this account. Yes for a credit hold is in place, No for nocredit hold
CREDIT_CHECKING VARCHAR2 (1)
Indicates whether a credit check is to be carried out
TOLERANCE NUMBER

Percentage over credit limit that this borrower can exceed before action is taken
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row
LAST_UPDATED_BY NUMBER (15) Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID)
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID)
CREATION_DATE DATE
Y Standard who column - date when this row was created
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID)
REQUEST_ID NUMBER (15)
Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID)
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID)
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row)
OBJECT_VERSION_NUMBER NUMBER
Y Object Version Number
ORG_ID NUMBER (15) Y Org ID.
ORG_NAME VARCHAR2 (240)
Org name
LEGAL_ENTITY_ID NUMBER (15)
Legal Entity Id
LEGAL_ENTITY_NAME VARCHAR2 (240)
Legal Entity Name
FUNCTIONAL_CURRENCY VARCHAR2 (15)
Set of Books Currency

[top of page]

LNS.LNS_BORROWER_SUMMARIES does not reference any database object

LNS.LNS_BORROWER_SUMMARIES is referenced by following:

LNS
VIEW - LNS_BORROWER_SUMMARIES#

[top of page]

Table: LNS_CONDITIONS

Description: Loan Conditions Table
Primary Key: LNS_CONDITIONS_PK
  1. CONDITION_ID
Primary Key: UNIQUE_CONDITION_NAME
  1. CONDITION_NAME
Foreign Keys to this table:
Foreign Key Column Foreign Table
LNS_COND_ASSIGNMENTS.CONDITION_ID LNS_CONDITIONS
Comments

LNS_CONDITIONS is a setup table where loan conditions are defined and stored. They can then be assigned to a loan upon creating the loan application.

Indexes
Index Type Tablespace Column
LNS_CONDITIONS_U1 UNIQUE APPS_TS_SEED CONDITION_ID
Columns
Name Datatype Length Mandatory Comments
CONDITION_ID NUMBER (15) Y Condition Id
CONDITION_NAME VARCHAR2 (50)
Condition Name
CONDITION_DESCRIPTION VARCHAR2 (250)
Condition Description
CONDITION_TYPE VARCHAR2 (30)
Type of Condition (based on lookup 'CONDITION_TYPE')
MANDATORY_FLAG VARCHAR2 (1)
Flag determines if condition must be fulfilled before the loan can be submitted for approval.
CONDITION_DUE_BY NUMBER

Condition due by
CONDITION_DUE_PERIOD VARCHAR2 (30)
Due by Period (e.g. Days, Weeks, Months)
CREATED_BY NUMBER (15) Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
OBJECT_VERSION_NUMBER NUMBER
Y Object Version Number
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Attribute Category
ATTRIBUTE1 VARCHAR2 (150)
Attribute1
ATTRIBUTE2 VARCHAR2 (150)
Attribute2
ATTRIBUTE3 VARCHAR2 (150)
Attribute3
ATTRIBUTE4 VARCHAR2 (150)
Attribute4
ATTRIBUTE5 VARCHAR2 (150)
Attribute5
ATTRIBUTE6 VARCHAR2 (150)
Attribute6
ATTRIBUTE7 VARCHAR2 (150)
Attribute7
ATTRIBUTE8 VARCHAR2 (150)
Attribute8
ATTRIBUTE9 VARCHAR2 (150)
Attribute9
ATTRIBUTE10 VARCHAR2 (150)
Attribute10
ATTRIBUTE11 VARCHAR2 (150)
Attribute11
ATTRIBUTE12 VARCHAR2 (150)
Attribute12
ATTRIBUTE13 VARCHAR2 (150)
Attribute13
ATTRIBUTE14 VARCHAR2 (150)
Attribute14
ATTRIBUTE15 VARCHAR2 (150)
Attribute15
ATTRIBUTE16 VARCHAR2 (150)
Attribute16
ATTRIBUTE17 VARCHAR2 (150)
Attribute17
ATTRIBUTE18 VARCHAR2 (150)
Attribute18
ATTRIBUTE19 VARCHAR2 (150)
Attribute19
ATTRIBUTE20 VARCHAR2 (150)
Attribute20
CUSTOM_PROCEDURE VARCHAR2 (250)
Identifies the custom procedure

[top of page]

LNS.LNS_CONDITIONS does not reference any database object

LNS.LNS_CONDITIONS is referenced by following:

LNS
VIEW - LNS_CONDITIONS#

[top of page]

Table: LNS_COND_ASSIGNMENTS

Description: Loan Condition Assignment Table
Primary Key: LNS_COND_ASSIGNMENTS_PK
  1. COND_ASSIGNMENT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
LNS_COND_ASSIGNMENTS.CONDITION_ID LNS_CONDITIONS
LNS_COND_ASSIGNMENTS.LOAN_ID %
LNS_COND_ASSIGNMENTS.FULFILLMENT_UPDATED_BY FND_USER
Comments

LNS_COND_ASSIGNMENTS stores the assignments of conditions to existing loans. It allows the user to override the default condition description with more descriptive text, or change the mandatory property of the condition at the time of assignment. The table also tracks when the condition is fulfilled.

Indexes
Index Type Tablespace Column
LNS_COND_ASSIGNMENTS_U1 UNIQUE APPS_TS_TX_IDX COND_ASSIGNMENT_ID
LNS_COND_ASSIGNMENTS_N1 NONUNIQUE APPS_TS_TX_IDX LOAN_ID
LNS_COND_ASSIGNMENTS_N2 NONUNIQUE APPS_TS_TX_IDX DISB_HEADER_ID
LNS_COND_ASSIGNMENTS_U2 NONUNIQUE APPS_TS_TX_IDX CONDITION_ID
Columns
Name Datatype Length Mandatory Comments
COND_ASSIGNMENT_ID NUMBER (15) Y Condition Assignment Identifier
LOAN_ID NUMBER (15)
Loan Identifier
CONDITION_ID NUMBER (15) Y Condition Identifier
CONDITION_DESCRIPTION VARCHAR2 (250)
Condition Description
CONDITION_MET_FLAG VARCHAR2 (1)
Flag to indicate if condition has been met
MANDATORY_FLAG VARCHAR2 (1)
Flag to indicate if condition must be met prior to submitting the loan for approval
CREATED_BY NUMBER (15) Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
OBJECT_VERSION_NUMBER NUMBER
Y Object Version Number
FULFILLMENT_DATE DATE

Date Condition is Fulfilled
FULFILLMENT_UPDATED_BY NUMBER (15)
User Id that updates the condition as fulfilled
START_DATE_ACTIVE DATE

Start Date Active
END_DATE_ACTIVE DATE

End Date Active
DISB_HEADER_ID NUMBER (15)
FK to LNS_DISB_HEADERS
DELETE_DISABLED_FLAG VARCHAR2 (1)
Delete Disabled Flag
OWNER_OBJECT_ID NUMBER

Condition owner id. For example, loan_line_id for additional receivable condition or loan_adjustment_id for loan amount adjustment condition.
OWNER_TABLE VARCHAR2 (100)
Condition owner table name. For example, lns_loan_lines for additional receivable condition or LNS_LOAN_AMOUNT_ADJS for loan amount adjustment condition.

[top of page]

LNS.LNS_COND_ASSIGNMENTS does not reference any database object

LNS.LNS_COND_ASSIGNMENTS is referenced by following:

LNS
VIEW - LNS_COND_ASSIGNMENTS#

[top of page]

Table: LNS_CUSTOM_PAYMNT_SCHEDS

Description: Loans Custom Schedule Table
Foreign Keys from this table:
Foreign Key Column Foreign Table
LNS_CUSTOM_PAYMNT_SCHEDS.LOAN_ID %
Comments

Loans Custom Schedule Table

Indexes
Index Type Tablespace Column
LNS_CUSTOM_PAYMNT_SCHEDS_U1 UNIQUE APPS_TS_TX_IDX CUSTOM_SCHEDULE_ID
LNS_CUSTOM_PAYMNT_SCHEDS_N1 NONUNIQUE APPS_TS_TX_IDX LOAN_ID
PAYMENT_NUMBER
Columns
Name Datatype Length Mandatory Comments
CUSTOM_SCHEDULE_ID NUMBER (15) Y Primary key
LOAN_ID NUMBER (15) Y Loan identifier
PAYMENT_NUMBER NUMBER

Payment number
DUE_DATE DATE

Due date
PRINCIPAL_AMOUNT NUMBER

Principal amount due
INTEREST_AMOUNT NUMBER

Interest amount due
PRINCIPAL_PAID_TODATE NUMBER

Total principal paid
INTEREST_PAID_TODATE NUMBER

Total interest paid
OTHER_AMOUNT NUMBER

Other amount due
INSTALLMENT_BEGIN_BALANCE NUMBER

Installment beginning balance
INSTALLMENT_END_BALANCE NUMBER

Installment ending balance
CURRENT_TERM_PAYMENT NUMBER

Current term payment.
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Attribute category
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE16 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE17 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE18 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE19 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE20 VARCHAR2 (150)
Descriptive Flexfield segment
OBJECT_VERSION_NUMBER NUMBER
Y Object version number
FEE_AMOUNT NUMBER

Fee amount due
LOCK_INT VARCHAR2 (1)
Value of 'Y' means we can't modify the customized interest in that schedule row.
LOCK_PRIN VARCHAR2 (1)
Value of 'Y' means we can't modify the customized principal in that schedule row.
PRINCIPAL_PERCENT NUMBER

Principal Percent

[top of page]

LNS.LNS_CUSTOM_PAYMNT_SCHEDS does not reference any database object

LNS.LNS_CUSTOM_PAYMNT_SCHEDS is referenced by following:

LNS
VIEW - LNS_CUSTOM_PAYMNT_SCHEDS#

[top of page]

Table: LNS_DEFAULT_DISTRIBS_ALL

Description: Loans Default Distributions Table - This table establishes the accounting to default for loans and fees. The Default for loans will be based on the combination of LOAN_CLASS + LOAN_TYPE. The default for fees is associated to the fee_id.
Foreign Keys from this table:
Foreign Key Column Foreign Table
LNS_DEFAULT_DISTRIBS_ALL.CODE_COMBINATION_ID GL_CODE_COMBINATIONS
LNS_DEFAULT_DISTRIBS_ALL.ORG_ID HR_ALL_ORGANIZATION_UNITS
Comments

Loans Default Distributions Table - This table establishes the accounting to default for loans and fees. The Default for loans will be based on the combination of LOAN_CLASS + LOAN_TYPE. The default for fees is associated to the fee_id.

Indexes
Index Type Tablespace Column
LNS_DEFAULT_DISTRIBS_U1 UNIQUE APPS_TS_SEED DEFAULT_DISTRIBUTION_ID
LNS_DEFAULT_DISTRIBS_N1 NONUNIQUE APPS_TS_SEED LOAN_CLASS
LOAN_TYPE
LNS_DEFAULT_DISTRIBS_N2 NONUNIQUE APPS_TS_SEED FEE_ID
Columns
Name Datatype Length Mandatory Comments
DEFAULT_DISTRIBUTION_ID NUMBER (15) Y Primary key
LOAN_CLASS VARCHAR2 (30)
Loan Class
LOAN_TYPE VARCHAR2 (30)
Loan Type
LINE_TYPE VARCHAR2 (30) Y Distribution Line Type ('INT', 'PRIN', 'CLEAR','ORIG', 'FEE')
ACCOUNT_NAME VARCHAR2 (30) Y Distribution Account Name. 'LOAN_RECEIVABLE', 'LOAN_CLEARING', 'PRINCIPAL_RECEIVABLE', 'INTEREST_RECEIVABLE', 'INTEREST_INCOME', 'FEE_RECEIVABLE', 'FEE_INCOME'
CODE_COMBINATION_ID NUMBER (15) Y FK to GL_CODE_COMBINATIONS.Code_Combination_ID
ACCOUNT_TYPE VARCHAR2 (30) Y CREDIT (CR) or DEBIT (DR)
DISTRIBUTION_PERCENT NUMBER
Y Percent of Line_Type to go to this line - should be 100% for Principal_Receviable and 100% for interest_receivable. For loans_receivable, the sum of all lines for a given loan should equal 100%
DISTRIBUTION_TYPE VARCHAR2 (30)
'ORIGINATION' , 'BILLING'
CREATION_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who Column
OBJECT_VERSION_NUMBER NUMBER
Y object_version_number
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Attribute_Category
ATTRIBUTE1 VARCHAR2 (150)
Attribute1
ATTRIBUTE2 VARCHAR2 (150)
Attribute2
ATTRIBUTE3 VARCHAR2 (150)
Attribute3
ATTRIBUTE4 VARCHAR2 (150)
Attribute4
ATTRIBUTE5 VARCHAR2 (150)
Attribute5
ATTRIBUTE6 VARCHAR2 (150)
Attribute6
ATTRIBUTE7 VARCHAR2 (150)
Attribute7
ATTRIBUTE8 VARCHAR2 (150)
Attribute8
ATTRIBUTE9 VARCHAR2 (150)
Attribute9
ATTRIBUTE10 VARCHAR2 (150)
Attribute10
ATTRIBUTE11 VARCHAR2 (150)
Attribute11
ATTRIBUTE12 VARCHAR2 (150)
Attribute12
ATTRIBUTE13 VARCHAR2 (150)
Attribute13
ATTRIBUTE14 VARCHAR2 (150)
Attribute14
ATTRIBUTE15 VARCHAR2 (150)
Attribute15
ATTRIBUTE16 VARCHAR2 (150)
Attribute16
ATTRIBUTE17 VARCHAR2 (150)
Attribute17
ATTRIBUTE18 VARCHAR2 (150)
Attribute18
ATTRIBUTE19 VARCHAR2 (150)
Attribute19
ATTRIBUTE20 VARCHAR2 (150)
Attribute20
USSGL_TRANSACTION_CODE VARCHAR2 (30)
the USSGL transaction code to be stamped on any distribution created for this invoice
FEE_ID NUMBER (15)
if this is accounting for fees, the FK to LNS_FEES.FEE_ID
ORG_ID NUMBER (15) Y Organization ID
MFAR_BALANCING_SEGMENT VARCHAR2 (60)
Multi-Fund Accounting Balancing Segment
MFAR_NATURAL_ACCOUNT_REC VARCHAR2 (60)
Multi-Fund Natural Account Segment for Receivable
MFAR_NATURAL_ACCOUNT_CLR VARCHAR2 (60)
obsoleted
LOAN_TYPE_ID NUMBER (15)
FK to LNS_LOAN_TYPES
PROJECT_ID NUMBER

FK to PA_PROJECTS_ALL
TASK_ID NUMBER

FK to PA_TASKS
AWARD_ID NUMBER

FK to GMS_AWARDS
EXPENDITURE_TYPE VARCHAR2 (30)
EXPENDITURE_TYPE
EXPENDITURE_ITEM_DATE DATE

EXPENDITURE_ITEM_DATE

[top of page]

LNS.LNS_DEFAULT_DISTRIBS_ALL does not reference any database object

LNS.LNS_DEFAULT_DISTRIBS_ALL is referenced by following:

LNS
VIEW - LNS_DEFAULT_DISTRIBS_ALL#

[top of page]

Table: LNS_DISB_HEADERS

Description: This table stores header level disbursement information
Comments

Disbursement Headers Table

Indexes
Index Type Tablespace Column
LNS_DISB_HEADERS_U1 UNIQUE APPS_TS_TX_IDX DISB_HEADER_ID
LNS_DISB_HEADERS_U2 NONUNIQUE APPS_TS_TX_IDX LOAN_ID
DISBURSEMENT_NUMBER
Columns
Name Datatype Length Mandatory Comments
DISB_HEADER_ID NUMBER (15) Y Primary Key
LOAN_ID NUMBER (15) Y FK to LNS_LOAN_HEADERS
TARGET_DATE DATE

Target Date
PAYMENT_REQUEST_DATE DATE

Payment Requested Date
ACTIVITY_CODE VARCHAR2 (30)
Activity Code
DISBURSEMENT_NUMBER NUMBER

Disbursement Number
HEADER_AMOUNT NUMBER

Total Header Amount
HEADER_PERCENT NUMBER

Header Percent
STATUS VARCHAR2 (30)
Disbursement Status
AUTOFUNDING_FLAG VARCHAR2 (1)
Flag that indicates whether funding advice is created automatically or manually
OBJECT_VERSION_NUMBER NUMBER
Y Obj Version Num
CREATION_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
DESCRIPTION VARCHAR2 (250)
Disbursement Description
PHASE VARCHAR2 (30)
Phase (Disbursement or Term)

[top of page]

LNS.LNS_DISB_HEADERS does not reference any database object

LNS.LNS_DISB_HEADERS is referenced by following:

LNS
VIEW - LNS_DISB_HEADERS#

[top of page]

Table: LNS_DISB_HISTORIES_H

Description: This table stores disbursement changes
Comments

Disbursement History

Indexes
Index Type Tablespace Column
LNS_DISB_HISTORIES_H_U1 UNIQUE APPS_TS_TX_IDX DISB_HISTORY_ID
Columns
Name Datatype Length Mandatory Comments
DISB_HISTORY_ID NUMBER (15) Y Primary Key
DISB_LINE_ID NUMBER (15) Y FK to LNS_DISB_LINES
ATTEMPT_NUMBER NUMBER

Attempt Number
BANK_ACCOUNT_ID NUMBER (15)
Bank Account
PAYMENT_METHOD_CODE VARCHAR2 (30)
Payment Method Code
REQUEST_DATE DATE

Request Date
PAYMENT_REQUEST_DATE DATE

Payment Request Date
STATUS VARCHAR2 (30)
Status
MESSAGES VARCHAR2 (1000)
Messages
OBJECT_VERSION_NUMBER NUMBER
Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column

[top of page]

LNS.LNS_DISB_HISTORIES_H does not reference any database object

LNS.LNS_DISB_HISTORIES_H is referenced by following:

LNS
VIEW - LNS_DISB_HISTORIES_H#

[top of page]

Table: LNS_DISB_LINES

Description: Stores line level disbursement information
Comments

Disbursement Lines

Indexes
Index Type Tablespace Column
LNS_DISB_LINES_U1 UNIQUE APPS_TS_TX_IDX DISB_LINE_ID
Columns
Name Datatype Length Mandatory Comments
DISB_LINE_ID NUMBER (15) Y Primary Key
DISB_HEADER_ID NUMBER (15) Y FK to LNS_DISB_HEADERS
DISB_LINE_NUMBER NUMBER

Disbursement Line Number
LINE_AMOUNT NUMBER

Line Amount
LINE_PERCENT NUMBER

Percentage
PAYEE_PARTY_ID NUMBER (15)
Payee Party Id
BANK_ACCOUNT_ID NUMBER (15)
Bank Account ID
PAYMENT_METHOD_CODE VARCHAR2 (30)
Payment Method Code
REQUEST_DATE DATE

Requested Date
DISBURSEMENT_DATE DATE

Disbursement Date
OBJECT_VERSION_NUMBER NUMBER
Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
STATUS VARCHAR2 (30)
Disbursement Status
INVOICE_INTERFACE_ID NUMBER (15)
Invoice Interface ID
INVOICE_ID NUMBER (15)
Invoice ID
PARTY_SITE_ID NUMBER

Party Site ID
INCOME_TAX_REGION VARCHAR2 (10)
Income Tax Region for 1099 Compliance
TYPE_1099 VARCHAR2 (10)
Income Tax Type for 1099 Compliance

[top of page]

LNS.LNS_DISB_LINES does not reference any database object

LNS.LNS_DISB_LINES is referenced by following:

LNS
VIEW - LNS_DISB_LINES#

[top of page]

Table: LNS_DISTRIBUTIONS

Description: Loans Distributions Table - stores actual accounting distributions for a give loan_id
Primary Key: LNS_DISTRIBUTIONS_PK
  1. DISTRIBUTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
LNS_DISTRIBUTIONS.LOAN_ID %
Comments

Loans Distributions Table - stores actual accounting distributions for a give loan_id

Indexes
Index Type Tablespace Column
LNS_DISTRIBUTIONS_U1 UNIQUE APPS_TS_TX_IDX DISTRIBUTION_ID
LNS_DISTRIBUTIONS_N1 NONUNIQUE APPS_TS_TX_IDX LOAN_ID
Columns
Name Datatype Length Mandatory Comments
DISTRIBUTION_ID NUMBER (15) Y Primary Key
CODE_COMBINATION_ID NUMBER (15) Y Lookup (i.e. "Loan Receivable")
LOAN_ID NUMBER (15) Y FK to LNS_LOAN_HEADERS_ALL.Loan_ID
DISB_HEADER_ID NUMBER (15)
FK to LNS_DISB_HEADERS
DISTRIBUTION_TYPE VARCHAR2 (30)
'ORIGINATION' , 'BILLING'
LINE_TYPE VARCHAR2 (30) Y Distribution Line Type ('INT', 'PRIN', 'CLEAR','ORIG', 'FEE')
ACCOUNT_NAME VARCHAR2 (30) Y GL account type, Asset account, Revenue, or Expense (REC or REV)
ACCOUNT_TYPE VARCHAR2 (30) Y Distribution Account Name. 'LOAN_RECEIVABLE', 'LOAN_CLEARING', 'PRINCIPAL_RECEIVABLE', 'INTEREST_RECEIVABLE', 'INTEREST_INCOME', 'FEE_RECEIVABLE', 'FEE_INCOME'
DISTRIBUTION_PERCENT NUMBER
Y percent of amount going to this distribution
DISTRIBUTION_AMOUNT NUMBER

Amount going to this distribution
USSGL_TRANSACTION_CODE VARCHAR2 (30)
the USSGL transaction code to be stamped on any distribution created for this invoice
FEE_ID NUMBER (15)
if this is accounting for fees, the FK to LNS_FEES.FEE_ID
EVENT_ID NUMBER (15)
FK to XLA_EVENTS.EVENT_ID
POSTED_FLAG VARCHAR2 (1)
Posted Flag
START_DATE_ACTIVE DATE

start date
END_DATE_ACTIVE DATE

end date
CREATED_BY NUMBER (15) Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
OBJECT_VERSION_NUMBER NUMBER
Y object_version_number
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Attribute_Category
ATTRIBUTE1 VARCHAR2 (150)
Attribute1
ATTRIBUTE2 VARCHAR2 (150)
Attribute2
ATTRIBUTE3 VARCHAR2 (150)
Attribute3
ATTRIBUTE4 VARCHAR2 (150)
Attribute4
ATTRIBUTE5 VARCHAR2 (150)
Attribute5
ATTRIBUTE6 VARCHAR2 (150)
Attribute6
ATTRIBUTE7 VARCHAR2 (150)
Attribute7
ATTRIBUTE8 VARCHAR2 (150)
Attribute8
ATTRIBUTE9 VARCHAR2 (150)
Attribute9
ATTRIBUTE10 VARCHAR2 (150)
Attribute10
ATTRIBUTE11 VARCHAR2 (150)
Attribute11
ATTRIBUTE12 VARCHAR2 (150)
Attribute12
ATTRIBUTE13 VARCHAR2 (150)
Attribute13
ATTRIBUTE14 VARCHAR2 (150)
Attribute14
ATTRIBUTE15 VARCHAR2 (150)
Attribute15
ATTRIBUTE16 VARCHAR2 (150)
Attribute16
ATTRIBUTE17 VARCHAR2 (150)
Attribute17
ATTRIBUTE18 VARCHAR2 (150)
Attribute18
ATTRIBUTE19 VARCHAR2 (150)
Attribute19
ATTRIBUTE20 VARCHAR2 (150)
Attribute20
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
LOAN_AMOUNT_ADJ_ID NUMBER (15)
FK to LNS_LOAN_AMOUNT_ADJS.LOAN_AMOUNT_ADJ_ID
LOAN_LINE_ID NUMBER (15)
ERS Loan Additional Receivable Line Id
ACTIVITY VARCHAR2 (30)
The activity of the distribution
ACCRUAL_PERIOD VARCHAR2 (15)
Identifies the Accrual Period
ACCRUAL_DATE DATE

Identifies the Accrual Date
ACCRUAL_COMPLETED_FLAG VARCHAR2 (1)
Identifies whether the Accrual is completed in loans for an Accrual period/date
PROJECT_ID NUMBER

Project Id used for projects accounting
TASK_ID NUMBER

Task Id used in projects accounting
EXPENDITURE_TYPE VARCHAR2 (30)
Expenditure Type used for Projects Accounting
AWARD_ID NUMBER

Award Id used for Projects Accounting
EXPENDITURE_ITEM_DATE DATE

Expenditure Item Date used for Projects Accounting

[top of page]

LNS.LNS_DISTRIBUTIONS does not reference any database object

LNS.LNS_DISTRIBUTIONS is referenced by following:

LNS
VIEW - LNS_DISTRIBUTIONS#

[top of page]

Table: LNS_EVENTS

Description: This table stores actionable events for a loan class
Primary Key: LNS_EVENTS_PK
  1. EVENT_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
LNS_EVENT_ACTIONS.EVENT_ID LNS_EVENTS
Comments

Actionable Events

Indexes
Index Type Tablespace Column
LNS_EVENTS_U1 UNIQUE APPS_TS_SEED EVENT_ID
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
EVENT_ID NUMBER (15) Y Event Id
LOAN_CLASS_CODE VARCHAR2 (30) Y Loan Class Code
EVENT_NAME VARCHAR2 (30) Y Event Name
DESCRIPTION VARCHAR2 (250) Y Event Description
ENABLED_FLAG VARCHAR2 (1) Y This column indicates whether the event is enabled or not
WF_BUSINESS_EVENT VARCHAR2 (240) Y Workflow Business Event
OBJECT_VERSION_NUMBER NUMBER
Y Object Version Number
CREATION_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

LNS.LNS_EVENTS does not reference any database object

LNS.LNS_EVENTS is referenced by following:

LNS
VIEW - LNS_EVENTS#

[top of page]

Table: LNS_EVENT_ACTIONS

Description: This table stores actionable events for a Loan type and loan class
Primary Key: LNS_EVENT_ACTIONS_PK
  1. EVENT_ACTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
LNS_EVENT_ACTIONS.EVENT_ID LNS_EVENTS
Foreign Keys to this table:
Foreign Key Column Foreign Table
LNS_EVT_ACTION_HISTORY_H.EVENT_ACTION_ID LNS_EVENT_ACTIONS
Comments

This table stores actionable events for a Loan type and loan class

Indexes
Index Type Tablespace Column
LNS_EVENT_ACTIONS_U1 UNIQUE APPS_TS_SEED EVENT_ACTION_ID
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
EVENT_ACTION_ID NUMBER (15) Y Event Action Id
EVENT_ID NUMBER (15) Y Event Id
EVENT_ACTION_NAME VARCHAR2 (30) Y Event Action Name
DESCRIPTION VARCHAR2 (250) Y Description
DELIVERY_METHOD VARCHAR2 (30)
Notification Delivery method
LOAN_TYPE VARCHAR2 (30)
Loan Type
ACTION_TYPE VARCHAR2 (30) Y Action Type
ENABLED_FLAG VARCHAR2 (1) Y This column indicates whether the event action is enabled or not
API_NAME VARCHAR2 (250)
API Name
NOTIFICATION_TYPE VARCHAR2 (30)
Notification Type
SETUP_TYPE VARCHAR2 (30)
Setup Type
PRIMARY_RECIPIENT_TYPE VARCHAR2 (30)
Primary Recipient Type
PRIMARY_RECIPIENT_NAME VARCHAR2 (30)
Primary Recipient Name
SECONDARY_RECIPIENT_TYPE VARCHAR2 (30)
Secondary Recipient Type
SECONDARY_RECIPIENT_NAME VARCHAR2 (30)
Secondary Recipient Name
PRIORITY_NUM NUMBER

Priority
DAYS_PRIOR_NUM NUMBER

Days Prior
ACTIVE_FOR_NUM NUMBER

Active For
LOAN_TYPE_ID NUMBER (15)
Loan Type Id
OBJECT_VERSION_NUMBER NUMBER
Y Object Version Number
CREATION_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

LNS.LNS_EVENT_ACTIONS does not reference any database object

LNS.LNS_EVENT_ACTIONS is referenced by following:

LNS
VIEW - LNS_EVENT_ACTIONS#

[top of page]

Table: LNS_EVT_ACTION_HISTORY_H

Description: This table stores the information about workflow actions performed for a Loan event
Primary Key: LNS_EVT_ACTION_HISTORY_H_PK
  1. EVENT_ACTION_HISTORY_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
LNS_EVT_ACTION_HISTORY_H.EVENT_ACTION_ID LNS_EVENT_ACTIONS
LNS_EVT_ACTION_HISTORY_H.LOAN_ID %
Comments

This table stores the information about workflow actions performed for a Loan event

Indexes
Index Type Tablespace Column
LNS_EVT_ACTION_HISTORY_U1 UNIQUE APPS_TS_TX_IDX EVENT_ACTION_HISTORY_ID
Columns
Name Datatype Length Mandatory Comments
EVENT_ACTION_HISTORY_ID NUMBER (15) Y Event Action History Id
EVENT_ACTION_ID NUMBER (15) Y Event Action Id
LOAN_ID NUMBER (15) Y Loan Id
WF_ITEMKEY VARCHAR2 (240)
Workflow Itemkey
WF_ITEMTYPE VARCHAR2 (240)
Workflow Itemvalue
ACTIVITY_DATE DATE
Y Date of Activity
CONCURRENT_REQUEST_ID NUMBER (15)
Concurrent Request Id
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
PROGRAM_UPDATE_DATE DATE

Extended Who column
PROGRAM_APPLICATION_ID NUMBER (15)
Extended Who column
PROGRAM_ID NUMBER (15)
Extended Who column
REQUEST_ID NUMBER (15)
Extended Who column

[top of page]

LNS.LNS_EVT_ACTION_HISTORY_H does not reference any database object

LNS.LNS_EVT_ACTION_HISTORY_H is referenced by following:

LNS
VIEW - LNS_EVT_ACTION_HISTORY_H#

[top of page]

Table: LNS_FEES_ALL

Description: Loan Fees Setup Table
Primary Key: UNIQUE_FEE_NAME
  1. FEE_NAME
  2. ORG_ID
Comments

LNS_FEES is a setup table where loan fees are defined and stored. They can then be assigned to a loan upon creating the loan application.

Columns
Name Datatype Length Mandatory Comments
FEE_ID NUMBER (15) Y Fee Id
FEE_NAME VARCHAR2 (50) Y Fee Name
FEE_DESCRIPTION VARCHAR2 (250)
Fee Description
FEE_CATEGORY VARCHAR2 (30)
Fee Category (lookup type: 'FEE_CATEGORY')
FEE_TYPE VARCHAR2 (30)
Fee Type as driven by Fee Category (lookups type: 'ORIGINATION_FEE_APPLICABLE_TO', 'SERVICING_FEE_APPLICABLE_TO', 'MEMO_FEE_APPLICABLE_TO')
FEE NUMBER

Fee (amount or rate percentage based on RATE_TYPE)
FEE_BASIS VARCHAR2 (30)
Basis of Fee (lookup type: 'FEE_BASIS')
START_DATE_ACTIVE DATE

Start date active
END_DATE_ACTIVE DATE

End date active
NUMBER_GRACE_DAYS NUMBER

Number of grace days allowed (applies to Late Payment)
CREATED_BY NUMBER (15) Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
OBJECT_VERSION_NUMBER NUMBER
Y Object Version Number
RATE_TYPE VARCHAR2 (30)
Rate Type (lookup type: 'RATE_TYPE')
BILLING_OPTION VARCHAR2 (30)
Billing option as driven by Fee Category (lookup types: 'ORIGINATION_FEE_BILLING_OPTION', 'SERVICING_FEE_BILLING_OPTION', 'MEMO_FEE_BILLING_OPTION')
COLLECTED_THIRD_PARTY_FLAG VARCHAR2 (1)
Flag to indicate if fee is collected for third party
CURRENCY_CODE VARCHAR2 (30)
Currency Code
MINIMUM_OVERDUE_AMOUNT NUMBER

Minimum overdue amount
FEE_BASIS_RULE VARCHAR2 (30)
Fee Basis Rule
FEE_WAIVABLE_FLAG VARCHAR2 (1)
Fee Waivable Flag
FEE_EDITABLE_FLAG VARCHAR2 (1)
Fee Editable Flag
ORG_ID NUMBER (15) Y Organization ID
CUSTOM_PROCEDURE VARCHAR2 (250)
Custom Procudure

[top of page]

LNS.LNS_FEES_ALL does not reference any database object

LNS.LNS_FEES_ALL is referenced by following:

LNS
VIEW - LNS_FEES_ALL#

[top of page]

Table: LNS_FEE_ASSIGNMENTS

Description: Loan Fees Assignment Table
Primary Key: LNS_FEE_ASSIGNMENTS_PK
  1. FEE_ASSIGNMENT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
LNS_FEE_ASSIGNMENTS.LOAN_ID %
Comments

LNS_FEE_ASSIGNMENTS stores the assignments of fees to existing loans. It allows the user to override the following default properties setup in LNS_FEES: Fee Type, Fee, Fee Basis, Number of Grace Days, Collected for Third Party Flag, Billing Option, Rate Type. Begin Installment Number and End Installment Number are mandatory when the Billing Option is 'Amortize'. Number of Payments is required for Memo Fees which has Billing Option that is 'Due Before First Loan Payment'.

Indexes
Index Type Tablespace Column
LNS_FEE_ASSIGNMENTS_U1 UNIQUE APPS_TS_TX_IDX FEE_ASSIGNMENT_ID
LNS_FEE_ASSIGNMENTS_N1 NONUNIQUE APPS_TS_TX_IDX LOAN_ID
LNS_FEE_ASSIGNMENTS_N2 NONUNIQUE APPS_TS_TX_IDX FEE_ID
LNS_FEE_ASSIGNMENTS_N3 NONUNIQUE APPS_TS_TX_IDX DISB_HEADER_ID
Columns
Name Datatype Length Mandatory Comments
FEE_ASSIGNMENT_ID NUMBER (15) Y Fee Assignment Id
LOAN_ID NUMBER (15)
Loan Id
FEE_ID NUMBER (15) Y Fee Id
FEE_TYPE VARCHAR2 (30)
Type of Fee (lookup type: 'FEE_TYPE')
FEE NUMBER

Fee (Amount or rate percentage based on RATE_TYPE)
FEE_BASIS VARCHAR2 (30)
Basis of Fee (lookup type: 'FEE_BASIS')
NUMBER_GRACE_DAYS NUMBER

Number of grace days alowed for late payment
CREATED_BY NUMBER (15) Y Standard Who Column
CREATION_DATE DATE

Standard Who Column
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
OBJECT_VERSION_NUMBER NUMBER
Y Object Version Number
COLLECTED_THIRD_PARTY_FLAG VARCHAR2 (1)
Flag to indicate if fee is collected for third party
BILLING_OPTION VARCHAR2 (30)
Billing option (lookup types: 'ORIGINATION_FEE_BILLING_OPTION', 'SERVICING_FEE_BILLING_OPTION', 'MEMO_FEE_BILLING_OPTION')
RATE_TYPE VARCHAR2 (30)
Rate Type (lookup type: 'RATE_TYPE')
BEGIN_INSTALLMENT_NUMBER NUMBER

Installment number of loan for which the fee begins to apply
END_INSTALLMENT_NUMBER NUMBER

Installment number of loan for which the fee ends to apply
NUMBER_OF_PAYMENTS NUMBER

Number of payments (applies to Memo Fees only)
START_DATE_ACTIVE DATE

Start date active
END_DATE_ACTIVE DATE

End date active
DISB_HEADER_ID NUMBER (15)
FK to LNS_DISB_HEADERS
OPEN_PHASE_FLAG VARCHAR2 (1)
Fee is in Open Phase
DELETE_DISABLED_FLAG VARCHAR2 (1)
Disable Deleting Fee
PHASE VARCHAR2 (30)
Phase of the assigned fee
CUSTOM_PROCEDURE VARCHAR2 (250)
Custom Procedure

[top of page]

LNS.LNS_FEE_ASSIGNMENTS does not reference any database object

LNS.LNS_FEE_ASSIGNMENTS is referenced by following:

LNS
VIEW - LNS_FEE_ASSIGNMENTS#

[top of page]

Table: LNS_FEE_SCHEDULES

Description: Loans Fees Schedules Table
Primary Key: LNS_FEE_SCHEDULES_PK
  1. FEE_SCHEDULE_ID
Comments

Fees calculated and scheduled to be billed

Indexes
Index Type Tablespace Column
LNS_FEE_SCHEDULES_U1 UNIQUE APPS_TS_TX_IDX FEE_SCHEDULE_ID
LNS_FEE_SCHEDULES_N1 NONUNIQUE APPS_TS_TX_IDX LOAN_ID
Columns
Name Datatype Length Mandatory Comments
FEE_SCHEDULE_ID NUMBER (15) Y primary key
FEE_ID NUMBER (15)
Fee identifier (foreign key to LNS_FEES.FEE_ID)
LOAN_ID NUMBER (15) Y Loan identifier (foreign key to LNS_LOAN_HEADERS_ALL.LOAN_ID)
FEE_AMOUNT NUMBER
Y Amount of Fee. Amount should be > 0
FEE_INSTALLMENT NUMBER
Y Installment fee is associated with
FEE_DESCRIPTION VARCHAR2 (250)
Description of the fee
ACTIVE_FLAG VARCHAR2 (1)
Fee is active or not
BILLED_FLAG VARCHAR2 (1)
Fee is billed or not
FEE_WAIVABLE_FLAG VARCHAR2 (1)
Fee is waivable or not
WAIVED_AMOUNT NUMBER

Amount that was waived
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID)
CREATION_DATE DATE
Y Standard who column - date when this row was created
LAST_UPDATED_BY NUMBER (15) Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID)
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID)
PROGRAM_ID NUMBER (15)
Concurrent Program ID
REQUEST_ID NUMBER (15)
Concurrent Request ID
OBJECT_VERSION_NUMBER NUMBER
Y This column is used for locking purposes
DISB_HEADER_ID NUMBER

FK to LNS_DISB_HEADERS
PHASE VARCHAR2 (30)
Phase of the scheduled fee

[top of page]

LNS.LNS_FEE_SCHEDULES does not reference any database object

LNS.LNS_FEE_SCHEDULES is referenced by following:

LNS
VIEW - LNS_FEE_SCHEDULES#

[top of page]

Table: LNS_INT_RATE_HEADERS

Description: Interest Rate Headers table
Primary Key: LNS_INT_RATE_HEADERS_PK
  1. INTEREST_RATE_ID
Primary Key: UNIQUE_INDEX_NAME
  1. INTEREST_RATE_NAME
Comments

Interest Rate Headers table

Indexes
Index Type Tablespace Column
LNS_INT_RATE_HEADERS_U1 UNIQUE APPS_TS_SEED INTEREST_RATE_ID
Columns
Name Datatype Length Mandatory Comments
INTEREST_RATE_ID NUMBER (15) Y Primary Key
INTEREST_RATE_NAME VARCHAR2 (50)
Index Name
INTEREST_RATE_DESCRIPTION VARCHAR2 (250)
Index Descriptions
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER (15) Y Standard Who Column
OBJECT_VERSION_NUMBER NUMBER
Y Standard Who Column

[top of page]

LNS.LNS_INT_RATE_HEADERS does not reference any database object

LNS.LNS_INT_RATE_HEADERS is referenced by following:

LNS
VIEW - LNS_INT_RATE_HEADERS#

[top of page]

Table: LNS_INT_RATE_LINES

Description: Interest Rate Lines Table
Primary Key: LNS_INT_RATE_LINES_PK
  1. INTEREST_RATE_LINE_ID
Primary Key: UNIQUE_START_DATE
  1. INTEREST_RATE_ID
  2. START_DATE_ACTIVE
Comments

Interest Rate Lines Table

Indexes
Index Type Tablespace Column
LNS_INT_RATE_LINES_U1 UNIQUE APPS_TS_TX_IDX INTEREST_RATE_LINE_ID
LNS_INT_RATE_LINES_N1 NONUNIQUE APPS_TS_TX_IDX INTEREST_RATE_ID
Columns
Name Datatype Length Mandatory Comments
INTEREST_RATE_LINE_ID NUMBER (15) Y Interest Rate Line identifier
INTEREST_RATE_ID NUMBER (15) Y Interest Rate identifier (foreign key to LNS_INT_RATE_HEADERS.INTEREST_RATE_ID)
INTEREST_RATE NUMBER

Interest Rate value
END_DATE_ACTIVE DATE

Effective End Date of interest rate value
START_DATE_ACTIVE DATE

Effective Start Date of interest rate value
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
CREATION_DATE DATE
Y Standard who column
CREATED_BY NUMBER (15) Y Standard who column
OBJECT_VERSION_NUMBER NUMBER
Y This column is used for locking purposes

[top of page]

LNS.LNS_INT_RATE_LINES does not reference any database object

LNS.LNS_INT_RATE_LINES is referenced by following:

LNS
VIEW - LNS_INT_RATE_LINES#

[top of page]

Table: LNS_LOAN_API_ERRORS_GT

Description:
Comments
Columns
Name Datatype Length Mandatory Comments
ERROR_NUMBER NUMBER (15) Y
LINE_NUMBER NUMBER (15)
MESSAGE_NAME VARCHAR2 (30) Y
MESSAGE_TEXT VARCHAR2 (2000) Y

[top of page]

LNS.LNS_LOAN_API_ERRORS_GT does not reference any database object

LNS.LNS_LOAN_API_ERRORS_GT is referenced by following:

APPS
SYNONYM - LNS_LOAN_API_ERRORS_GT

[top of page]

Table: LNS_LOAN_CREATE_ERRORS_GT

Description:
Comments
Columns
Name Datatype Length Mandatory Comments
ERROR_NUMBER NUMBER (15) Y
LINE_NUMBER NUMBER (15)
MESSAGE_NAME VARCHAR2 (30) Y
MESSAGE_TEXT VARCHAR2 (2000) Y

[top of page]

LNS.LNS_LOAN_CREATE_ERRORS_GT does not reference any database object

LNS.LNS_LOAN_CREATE_ERRORS_GT is referenced by following:

APPS
SYNONYM - LNS_LOAN_CREATE_ERRORS_GT

[top of page]

Table: LNS_LOAN_DOCUMENTS

Description: This table stores all the documents related to a Source Object
Primary Key: LNS_LOAN_DOCUMENTS_PK
  1. DOCUMENT_ID
Comments

Loan Documents

Indexes
Index Type Tablespace Column
LNS_LOAN_DOCUMENTS_U1 UNIQUE APPS_TS_TX_IDX DOCUMENT_ID
LNS_LOAN_DOCUMENTS_U2 UNIQUE APPS_TS_TX_IDX SOURCE_ID
SOURCE_TABLE
DOCUMENT_TYPE
VERSION
SYS_IL0000406349C00006$$ UNIQUE APPS_TS_TX_DATA
Columns
Name Datatype Length Mandatory Comments
DOCUMENT_ID NUMBER (15) Y Document Id
SOURCE_ID NUMBER (15) Y Source Id of the source of the document
SOURCE_TABLE VARCHAR2 (60) Y Source Table of the source of the document
DOCUMENT_TYPE VARCHAR2 (30) Y Document Type of the document
VERSION NUMBER (15) Y Version Number of the document
DOCUMENT_XML CLOB (4000) Y Document in XML Format
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
PROGRAM_UPDATE_DATE DATE

Extended Who column
PROGRAM_APPLICATION_ID NUMBER (15)
Extended Who column
PROGRAM_ID NUMBER (15)
Extended Who column
REQUEST_ID NUMBER (15)
Extended Who column
OBJECT_VERSION_NUMBER NUMBER
Y Object Version Number
REASON VARCHAR2 (4000)
Reason for generating a new agreement report.

[top of page]

LNS.LNS_LOAN_DOCUMENTS does not reference any database object

LNS.LNS_LOAN_DOCUMENTS is referenced by following:

LNS
VIEW - LNS_LOAN_DOCUMENTS#

[top of page]

Table: LNS_LOAN_HEADERS_ALL

Description: Loans Header Table
Primary Key: LNS_LOAN_HEADERS_ALL_PK
  1. LOAN_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
LNS_LOAN_HEADERS_ALL.PRIMARY_BORROWER_ID HZ_PARTIES
LNS_LOAN_HEADERS_ALL.CONTACT_PERS_PARTY_ID HZ_PARTIES
LNS_LOAN_HEADERS_ALL.CONTACT_REL_PARTY_ID HZ_PARTIES
LNS_LOAN_HEADERS_ALL.CUST_ACCOUNT_ID HZ_CUST_ACCOUNTS
LNS_LOAN_HEADERS_ALL.REFERENCE_ID RA_CUSTOMER_TRX_ALL
LNS_LOAN_HEADERS_ALL.REFERENCE_TYPE_ID RA_CUST_TRX_TYPES_ALL
LNS_LOAN_HEADERS_ALL.BILL_TO_ACCT_SITE_ID HZ_CUST_ACCT_SITES_ALL
LNS_LOAN_HEADERS_ALL.PRODUCT_ID %
LNS_LOAN_HEADERS_ALL.LOAN_ASSIGNED_TO JTF_RS_RESOURCE_EXTNS
LNS_LOAN_HEADERS_ALL.LOAN_APPROVED_BY JTF_RS_RESOURCE_EXTNS
LNS_LOAN_HEADERS_ALL.ORG_ID HR_ALL_ORGANIZATION_UNITS
Foreign Keys to this table:
Foreign Key Column Foreign Table
LNS_LOAN_HISTORIES_H.LOAN_ID LNS_LOAN_HEADERS_ALL
LNS_PARTICIPANTS.LOAN_ID LNS_LOAN_HEADERS_ALL
LNS_TERMS.LOAN_ID LNS_LOAN_HEADERS_ALL
Comments

Loans Header Table

Indexes
Index Type Tablespace Column
LNS_LOAN_HEADERS_ALL_U1 UNIQUE APPS_TS_TX_IDX LOAN_ID
LNS_LOAN_HEADERS_ALL_U2 UNIQUE APPS_TS_TX_IDX LOAN_NUMBER
LNS_LOAN_HEADERS_ALL_N1 NONUNIQUE APPS_TS_TX_IDX CUST_ACCOUNT_ID
LNS_LOAN_HEADERS_ALL_N2 NONUNIQUE APPS_TS_TX_IDX PRIMARY_BORROWER_ID
LNS_LOAN_HEADERS_ALL_N3 NONUNIQUE APPS_TS_TX_IDX LOAN_STATUS
LNS_LOAN_HEADERS_ALL_N4 NONUNIQUE APPS_TS_TX_IDX SYS_NC00103$
LNS_LOAN_HEADERS_ALL_N5 NONUNIQUE APPS_TS_TX_IDX LEGAL_ENTITY_ID
Columns
Name Datatype Length Mandatory Comments
LOAN_ID NUMBER (15) Y Loan identifier
LOAN_NUMBER VARCHAR2 (60) Y Unique identification number for the loan
LOAN_DESCRIPTION VARCHAR2 (250)
Description of the loan
INITIAL_LOAN_BALANCE NUMBER
Y Initial loan balance
LAST_PAYMENT_DATE DATE

Last payment date
LAST_PAYMENT_AMOUNT NUMBER

Last payment amount
LOAN_TERM NUMBER
Y Loan term
LOAN_TERM_PERIOD VARCHAR2 (30) Y Loan term period. Lookup type is PERIOD
LOAN_CURRENCY VARCHAR2 (15) Y Loan currency code (foreign key to FND_CURRENCIES.CURRENCY_CODE)
LOAN_CLASS_CODE VARCHAR2 (30)
Loan class code. Lookup type is LOAN_CLASS
LOAN_TYPE VARCHAR2 (30)
Loan type code. Lookup Type is LOAN_TYPE
LOAN_SUBTYPE VARCHAR2 (30)
Loan subtype code. Lookup type is LOAN_SUBTYPE
LOAN_PURPOSE_CODE VARCHAR2 (30)
Loan purpose code. Lookup type is LOAN_PURPOSE
AMORTIZED_TERM NUMBER

Amortized term of the loan
AMORTIZED_TERM_PERIOD VARCHAR2 (30)
Amortized term period. Lookup type is PERIOD
LOAN_MATURITY_DATE DATE

Loan maturity date
LOAN_START_DATE DATE
Y Loan start date
LOAN_APPLICATION_DATE DATE
Y Loan application date
LOAN_CLOSING_DATE DATE

Loan closing date
LAST_BILLED_DATE DATE

Last billed date
END_DATE DATE

End date for the loan. The loan is end-dated on deletion.
PRODUCT_FLAG VARCHAR2 (1)
Product flag. This specifies if this row is considered a template product instead of a regular loan.
CUST_ACCOUNT_ID NUMBER (15)
Customer account identifier for the primary borrower of this loan (foreign key to HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID). This value is denormalized from LNS_PARTICIPANTS.CUST_ACCOUNT_ID
PRIMARY_BORROWER_ID NUMBER (15)
Party identifier for the primary borrower of this loan (foreign key to HZ_PARTIES.PARTY_ID). This value is denormalized from LNS_PARTICIPANTS.HZ_PARTY_ID
PRODUCT_ID NUMBER (15)
Product identifier for this loan if created from a template product (foreign key to LNS_LOAN_HEADERS_ALL.LOAN_ID for the corresponding product row)
REQUESTED_AMOUNT NUMBER
Y Loan requested amount
FUNDED_AMOUNT NUMBER

Loan funded amount
REFERENCE_AMOUNT NUMBER

When REFERENCE_TYPE='RECEIVABLE', this amount refers to the remaining outstanding receivable amount when this loan is created from an invoice.
REFERENCE_NUMBER VARCHAR2 (60)
When REFERENCE_TYPE='RECEIVABLE', this refers to invoice number of the outstanding receivable that is used for creating this loan.
REFERENCE_NAME VARCHAR2 (60)
Reference name
REFERENCE_TYPE VARCHAR2 (30)
Reference type. If the values is 'RECEIVABLE', it indicates whether this loan is created from an outstanding receivable.
REFERENCE_DESCRIPTION VARCHAR2 (250)
User entered Reference/Cost Report FYE
LOAN_APPROVAL_DATE DATE

Loan approval date
LOAN_APPROVED_BY NUMBER

Identifier for the user who approved this loan (foreign key to JTF_RS_RESOURCE_EXTNS.RESOURCE_ID)
LOAN_STATUS VARCHAR2 (30) Y Loan status code. Lookup type is LOAN_STATUS
LOAN_ASSIGNED_TO NUMBER

Identifier for the user who is assigned to this loan (foreign key to JTF_RS_RESOURCE_EXTNS.RESOURCE_ID)
REFERENCE_ID NUMBER (15)
When REFERENCE_TYPE='RECEIVABLE', this refers to the transaction identifier of the outstanding receivable that is used for creating this loan (foreign key to RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID).
CUSTOM_PAYMENTS_FLAG VARCHAR2 (1)
Flag to indicate if this loan has a customized amortization schedule.
BILLED_FLAG VARCHAR2 (1)
Flag to indicate if the loan has been billed
ORG_ID NUMBER (15) Y Organization identifier (foreign key to HR_OPERATING_UNITS.ORGANIZATION_ID)
USSGL_TRANSACTION_CODE VARCHAR2 (30)
Not currently used
REQUEST_ID NUMBER (15)
Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID)
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row
LAST_UPDATED_BY NUMBER (15) Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID)
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID)
CREATION_DATE DATE
Y Standard who column - date when this row was created
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID)
PROGRAM_ID NUMBER (15)
Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID)
OBJECT_VERSION_NUMBER NUMBER
Y This column is used for locking purposes
GL_DATE DATE

GL date
REFERENCE_TYPE_ID NUMBER (15)
The transaction type identifier that will be used for billing the loan (foreign key to RA_CUST_TRX_TYPES.CUST_TRX_TYPE_ID).
BILL_TO_ACCT_SITE_ID NUMBER (15)
Customer account billing site identifier for the primary borrower of the loan (foreign key to HZ_CUST_ACCT_SITES_ALL.CUST_ACCT_SITE_ID). This value is denormalized from LNS_PARTICIPANTS.BILL_TO_ACCT_SITE_ID
REC_ADJUSTMENT_NUMBER VARCHAR2 (20)
Adjustment Number for Loans Original Receivable
CONTACT_PERS_PARTY_ID NUMBER (15)
Identifier for Loan Contact Person Party
CONTACT_REL_PARTY_ID NUMBER (15)
Identifier for Loan Primary Contact Relationship Party
COLLATERAL_PERCENT NUMBER

This column defines the required collateral loan-to-value ratio for secured loan as a percentage of the loan amount
CREDIT_REVIEW_FLAG VARCHAR2 (1)
Indicates if credit review is needed for this loan.
EXCHANGE_RATE_TYPE VARCHAR2 (30)
Exchange rate type. Required if loan currency different from functional accounting currency
EXCHANGE_DATE DATE

Date of the exchange rate. Required if loan currency different from functional accounting currency
EXCHANGE_RATE NUMBER

Exchange rate. Required if loan currency different from functional accounting currency
LAST_PAYMENT_NUMBER NUMBER

This column defines the last billed payment number
LAST_AMORTIZATION_ID NUMBER

This column defines the last billed amortization schedule
LEGAL_ENTITY_ID NUMBER (15)
This Column Stores the Legal Entity Identifier
OPEN_TO_TERM_FLAG VARCHAR2 (1)
Indicates whether or not the loan can be converted to TERM loan
MULTIPLE_FUNDING_FLAG VARCHAR2 (1)
Indicates whether or not loan disbursements can be one or many
LOAN_TYPE_ID NUMBER (15)
FK to LNS_LOAN_TYPES
SECONDARY_STATUS VARCHAR2 (30)
Secondary Loan Status
OPEN_TO_TERM_EVENT VARCHAR2 (30)
Open To Term Event
BALLOON_PAYMENT_TYPE VARCHAR2 (30)
Balloon Payment Type
BALLOON_PAYMENT_AMOUNT NUMBER

Balloon Payment Amount
OPEN_LOAN_START_DATE DATE

Loan Start Date for the Open Phase
OPEN_LOAN_TERM NUMBER

Loan Term for the Open Phase
OPEN_LOAN_TERM_PERIOD VARCHAR2 (30)
Loan Term Period for Open Phase
CURRENT_PHASE VARCHAR2 (30)
Denotes the Current Phase of the loan. Contains values OPEN or TERM to denote Open-ended phase versus regular Term phase of the loan.
OPEN_MATURITY_DATE DATE

Open Maturity Date
FUNDS_RESERVED_FLAG VARCHAR2 (1)
Funds Reserved Flag
FUNDS_CHECK_DATE DATE

Last Funds Check Date
SUBSIDY_RATE NUMBER

Subsidy Rate
APPLICATION_ID NUMBER (15)
FK to FND_APPLICATION
CREATED_BY_MODULE VARCHAR2 (150)
Created By Module
PARTY_TYPE VARCHAR2 (30)
Party Type
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE16 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE17 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE18 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE19 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE20 VARCHAR2 (150)
Descriptive flexfield segment
FORGIVENESS_FLAG VARCHAR2 (1)
Identifies whether the loan is enabled for forgiveness
FORGIVENESS_PERCENT NUMBER

This column defines the required forgiveness loanEMIPrincipal-to-value ratio for forgiveness enabled loan as a percentage of the loanEMI Principal
DISABLE_BILLING_FLAG VARCHAR2 (1)
Identifies whether the billing of a loan is disabled
ADD_REQUESTED_AMOUNT NUMBER

Additional Requested Amount
DISABLE_INT_ACCRUAL_FLAG VARCHAR2 (1)
Identifies whether the accrual of a loan is disabled
BILL_ON_APPR_AMOUNT_FLAG VARCHAR2 (1)
Service Based On Approved Amounts

[top of page]

LNS.LNS_LOAN_HEADERS_ALL does not reference any database object

LNS.LNS_LOAN_HEADERS_ALL is referenced by following:

LNS
VIEW - LNS_LOAN_HEADERS_ALL#

[top of page]

Table: LNS_LOAN_HISTORIES_H

Description: Loan History Table
Foreign Keys from this table:
Foreign Key Column Foreign Table
LNS_LOAN_HISTORIES_H.LOAN_ID LNS_LOAN_HEADERS_ALL
Comments

LNS_LOAN_HISTORIES_H logs the activities that has happened to a loan. Upon updating the loan, both the old value and new value are stored into this table, as well as the affected table name and column.

Indexes
Index Type Tablespace Column
LNS_LOAN_HISTORIES_U1 UNIQUE APPS_TS_TX_IDX LOAN_HISTORY_ID
LNS_LOAN_HISTORIES_N1 NONUNIQUE APPS_TS_TX_IDX LOAN_ID
TABLE_NAME
COLUMN_NAME
Columns
Name Datatype Length Mandatory Comments
LOAN_HISTORY_ID NUMBER (15) Y Loan History Id
LOAN_ID NUMBER (15)
Loan Id
TABLE_NAME VARCHAR2 (50)
Name of table
COLUMN_NAME VARCHAR2 (50)
Name of column
OLD_VALUE VARCHAR2 (250)
Original value before update
NEW_VALUE VARCHAR2 (250)
New value after update
CREATED_BY NUMBER (15) Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
DATA_TYPE VARCHAR2 (106)
Datatype of column
OBJECT_VERSION_NUMBER NUMBER
Y Object Version Number
PRIMARY_KEY_ID NUMBER (15)
Primary Key ID

[top of page]

LNS.LNS_LOAN_HISTORIES_H does not reference any database object

LNS.LNS_LOAN_HISTORIES_H is referenced by following:

LNS
VIEW - LNS_LOAN_HISTORIES_H#

[top of page]

Table: LNS_LOAN_LINES

Description: Loan Lines Table
Primary Key: LNS_LOAN_LINES_PK
  1. LOAN_LINE_ID
Comments

Loan Lines Table

Indexes
Index Type Tablespace Column
LNS_LOAN_LINES_U1 UNIQUE APPS_TS_TX_IDX LOAN_LINE_ID
LNS_LOAN_LINES_U2 NONUNIQUE APPS_TS_TX_IDX LOAN_ID
REFERENCE_TYPE
REFERENCE_ID
PAYMENT_SCHEDULE_ID
INSTALLMENT_NUMBER
END_DATE
Columns
Name Datatype Length Mandatory Comments
LOAN_LINE_ID NUMBER (15) Y Loan Line identifier
LOAN_ID NUMBER (15) Y Loan identifier (foreign key to LNS_LOAN_HEADERS_ALL.LOAN_ID)
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row
LAST_UPDATED_BY NUMBER (15) Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID)
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID)
CREATION_DATE DATE
Y Standard who column - date when this row was created
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID)
OBJECT_VERSION_NUMBER NUMBER
Y This column is used for locking purposes
REFERENCE_TYPE VARCHAR2 (30)
Reference type. If the values is RECEIVABLE, it indicates whether this loan is created from an outstanding receivable.
REFERENCE_ID NUMBER (15)
When REFERENCE_TYPE=RECEIVABLE, this refers to the transaction identifier of the outstanding receivable that is used for creating this loan (foreign key to RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID)
REFERENCE_NUMBER VARCHAR2 (60)
When REFERENCE_TYPE=RECEIVABLE, this refers to invoice number of the outstanding receivable that is used for creating this loan
REFERENCE_DESCRIPTION VARCHAR2 (250)
User entered Reference/Cost Report FYE
REFERENCE_AMOUNT NUMBER

When REFERENCE_TYPE=RECEIVABLE, this amount refers to the remaining outstanding receivable amount when this loan is created from an invoice
REQUESTED_AMOUNT NUMBER
Y Loan line requested amount
REC_ADJUSTMENT_NUMBER VARCHAR2 (20)
When REFERENCE_TYPE=RECEIVABLE, AR Adjustment Number for Loans Original Receivable
REC_ADJUSTMENT_ID NUMBER (15)
When REFERENCE_TYPE=RECEIVABLE, AR Adjustment Id for Loans Original Receivable
PAYMENT_SCHEDULE_ID NUMBER (15)
foreign key to ar_payment_schedules.PAYMENT_SCHEDULE_ID
INSTALLMENT_NUMBER NUMBER (15)
foreign key to ar_payment_schedules.TERMS_SEQUENCE_NUMBER
END_DATE DATE

End date for the loan line. The loan line is end-dated on deletion.
STATUS VARCHAR2 (30)
Loans line status: pending, approved and rejected
APPR_REJECT_DATE DATE

Approval or Rejection Date
APPR_REJECT_BY NUMBER

Identifies the user who approved or rejected the loan line
ADJUSTMENT_DATE DATE

Date from which the loan line is effective
ORIGINAL_FLAG VARCHAR2 (1)
Identifies whether the loan line was assigned during loan creation or not.

[top of page]

LNS.LNS_LOAN_LINES does not reference any database object

LNS.LNS_LOAN_LINES is referenced by following:

LNS
VIEW - LNS_LOAN_LINES#

[top of page]

Table: LNS_LOAN_PRODUCTS_ALL

Description: Loan Product Setup Table
Primary Key: LNS_LOAN_PRODUCTS_ALL_PK
  1. LOAN_PRODUCT_ID
Primary Key: UNIQUE_PRODUCT_NAME
  1. LOAN_PRODUCT_NAME
  2. ORG_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
LNS_LOAN_PRODUCT_FLAGS.LOAN_PRODUCT_ID LNS_LOAN_PRODUCTS_ALL
LNS_LOAN_PRODUCT_LINES.LOAN_PRODUCT_ID LNS_LOAN_PRODUCTS_ALL
Comments

Loan Product Setup Table

Indexes
Index Type Tablespace Column
LNS_LOAN_PRODUCTS_ALL_U1 UNIQUE APPS_TS_TX_IDX LOAN_PRODUCT_ID
SYS_IL0000406354C00089$$ UNIQUE APPS_TS_TX_DATA
Columns
Name Datatype Length Mandatory Comments
LOAN_PRODUCT_ID NUMBER (15) Y Loan product identifier. This column defaults the value for LNS_LOAN_HEADERS_ALL.LOAN_PRODUCT_ID
LOAN_CLASS_CODE VARCHAR2 (30)
Loan class code. Lookup type is LOAN_CLASS. This column defaults the value for LNS_LOAN_HEADERS_ALL.LOAN_CLASS_CODE
LOAN_TYPE_ID NUMBER (15) Y Loan type id (foreign key to LNS_LOAN_TYPES.LOAN_TYPE_ID). This column defaults the value for LNS_LOAN_HEADERS_ALL.LOAN_TYPE_ID
LOAN_PRODUCT_NAME VARCHAR2 (80)
Loan product name
LOAN_PRODUCT_DESC VARCHAR2 (250)
Description of the loan product
START_DATE_ACTIVE DATE

Start date of loan product
END_DATE_ACTIVE DATE

End date of loan product
STATUS VARCHAR2 (30)
Loan product setup status code. Lookup type is XXXXXXXX
LOAN_TERM NUMBER

Loan term range from. This column defaults the value for LNS_LOAN_HEADERS_ALL.LOAN_TERM
LOAN_TERM_PERIOD VARCHAR2 (30)
Period of loan term range from. This column defaults the value for LNS_LOAN_HEADERS_ALL.LOAN_TERM_PERIOD
MAX_LOAN_TERM NUMBER

Loan term range to. This column defaults the value for LNS_LOAN_HEADERS_ALL.LOAN_TERM
MAX_LOAN_TERM_PERIOD VARCHAR2 (30)
Period of loan term range to. This column defaults the value for LNS_LOAN_HEADERS_ALL.LOAN_TERM_PERIOD
OPEN_LOAN_TERM NUMBER

Open Loan Term
OPEN_LOAN_TERM_PERIOD VARCHAR2 (30)
Open Loan Term Period
OPEN_MAX_LOAN_TERM NUMBER

Open Max Loan Term
OPEN_MAX_LOAN_TERM_PERIOD VARCHAR2 (30)
Open Max Loan Term Period
LOAN_CURRENCY VARCHAR2 (30)
Loan currency code (foreign key to FND_CURRENCIES.CURRENCY_CODE). This column defaults the value for LNS_LOAN_HEADERS_ALL.LOAN_CURRENCY
REQUESTED_AMOUNT NUMBER

Requested amount range from. This column defaults the value for LNS_LOAN_HEADERS_ALL.REQUESTED_AMOUNT
MAX_REQUESTED_AMOUNT NUMBER

Requested amount range to. This column defaults the value for LNS_LOAN_HEADERS_ALL.REQUESTED_AMOUNT
INDEX_RATE_ID NUMBER (15)
Interest rate index (foreign key to LNS_INT_RATE_HEADERS.INTEREST_RATE_ID). This column defaults the value for is LNS_TERMS.INDEX_RATE_ID
RATE_TYPE VARCHAR2 (30)
Loan rate type code. Lookup type is RATE_TYPE. This column defaults the value for LNS_TERMS.RATE_TYPE
SPREAD NUMBER

Spread percentage rate. This column defaults the value for LNS_RATE_SCHEDULES.SPREAD
OPEN_SPREAD NUMBER

Spread during open phase of loan product
FLOOR_RATE NUMBER

Floor percentage rate. This column defaults the value for LNS_TERMS.FLOOR_RATE
CEILING_RATE NUMBER

Ceiling percentage rate. This column defaults the value for LNS_TERMS.CEILING_RATE
OPEN_FLOOR_RATE NUMBER

Open Phase Floor Rate
OPEN_CEILING_RATE NUMBER

Open Phase Ceiling Rate
INTEREST_COMPOUNDING_FREQ VARCHAR2 (30)
Interest accrual frequency code. Lookup type is XXXXXXXX. This column defaults the value for LNS_TERMS.INTEREST_COMPOUNDING_FREQ
LOAN_PAYMENT_FREQUENCY VARCHAR2 (30)
Loan payment frequency code. Lookup type is FREQUENCY. This column defaults the value for LNS_TERMS.LOAN_PAYMENT_FREQUENCY
AMORTIZATION_FREQUENCY VARCHAR2 (30)
Amortization Frequency
LOAN_SUBTYPE VARCHAR2 (30)
Loan subtype code. Lookup type is LOAN_SUBTYPE. This column defaults the value for LNS_LOAN_HEADERS_ALL.LOAN_SUBTYPE
COLLATERAL_PERCENT NUMBER

Loan to value ratio. This column defaults the value for LNS_LOAN_HEADERS_ALL.COLLATERAL_PERCENT
ALLOW_INTEREST_ONLY_FLAG VARCHAR2 (1)
Flag to indicate if interest only payments are allowed. This column defaults the value for LNS_RATE_SCHEDULES.INTEREST_ONLY_FLAG
REAMORTIZE_OVER_PAYMENT VARCHAR2 (1)
Flag to indicate if reamortize on overpayments. This column defaults the value for is LNS_TERMS.REAMORTIZE_OVER_PAYMENT
REAMORTIZE_UNDER_PAYMENT VARCHAR2 (30)
Reamortize on underpayment
ORG_ID NUMBER (15) Y Organization identifier (foreign key to HR_OPERATING_UNITS.ORGANIZATION_ID). This column defaults the value for LNS_LOAN_HEADERS_ALL.ORG_ID
CREATED_BY NUMBER (15) Y Standard who column
CREATION_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
OBJECT_VERSION_NUMBER NUMBER
Y This column is used for locking purposes
LEGAL_ENTITY_ID NUMBER (15)
Legal Entity ID
RATE_CHANGE_FREQUENCY VARCHAR2 (30)
Rate Change Frequency
BDGT_REQ_FOR_APPR_FLAG VARCHAR2 (1)
Budget Required for Loan Approval
LOAN_APPR_REQ_FLAG VARCHAR2 (1)
Loan Approval Required
APPR_REQ_FOR_CNCL_FLAG VARCHAR2 (1)
Approval Required for Cancellation
PERCENT_INCREASE NUMBER

Maximum Rate Percentage Increase
PERCENT_INCREASE_LIFE NUMBER

Maximum Rate Percentage Increase life
FIRST_PERCENT_INCREASE NUMBER

First Percentage Increase Max/Min
OPEN_PERCENT_INCREASE NUMBER

Percentage Increase Max/Min
OPEN_PERCENT_INCREASE_LIFE NUMBER

Open Percentage Increase Max/Min Life
OPEN_FIRST_PERCENT_INCREASE NUMBER

Open First Percentage Increase Max/Min
CREDIT_REVIEW_TYPE VARCHAR2 (30)
AR_CMGT_CHECK_LISTS.REVIEW_TYPE
GUARANTOR_REVIEW_TYPE VARCHAR2 (30)
AR_CMGT_CHECK_LISTS.REVIEW_TYPE
PARTY_TYPE VARCHAR2 (30)
This column will store either ORGANIZATION or PERSON and denotes whether its a Business or Consumer product.
INTEREST_CALCULATION_METHOD VARCHAR2 (30)
This column stores the Interest Calculation Method of the loan.
DAY_COUNT_METHOD VARCHAR2 (30)
This column stores the Day Count Method
FORGIVENESS_FLAG VARCHAR2 (1)
Identifies whether the loan is enabled for forgiveness
FORGIVENESS_PERCENT NUMBER

This column defines the required forgiveness loanEMI-to-value ratio for forgiveness enabled loan as a percentage of the loanEMI
PAYMENT_CALC_METHOD VARCHAR2 (30)
Payment calculation method
PENAL_INT_RATE NUMBER

Penal Interest Rate
PENAL_INT_GRACE_DAYS NUMBER

Penal interest grace days
CALC_ADD_INT_UNPAID_PRIN VARCHAR2 (1)
Calculate additional interest on unpaid principal
CALC_ADD_INT_UNPAID_INT VARCHAR2 (1)
Calculate additional interest on unpaid interest
PRINCIPAL_PAYMENT_FREQUENCY VARCHAR2 (30)
Principal Payment Frequency
REAMORTIZE_ON_FUNDING VARCHAR2 (30)
Reamortize On Funding
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE16 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE17 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE18 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE19 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE20 VARCHAR2 (150)
Descriptive flexfield segment
CUSTOM_SCHED_DATA CLOB (4000)
Custom Schedule Data
CUSTOM_CALC_METHOD VARCHAR2 (30)
Custom Calculation Method
CAPITALIZE_INT VARCHAR2 (1)
Capitalize Interest
BILL_ON_APPR_AMOUNT_FLAG VARCHAR2 (1)
Activate and Bill Based On Approved Amounts
CALC_EARLY_PAY_CR VARCHAR2 (1)
Issue Interest Credit On Early Payments
FLUCTUATE_EQ_PAY_AMOUNT VARCHAR2 (1)
Fluctuate Payment Due to Additional Interest

[top of page]

LNS.LNS_LOAN_PRODUCTS_ALL does not reference any database object

LNS.LNS_LOAN_PRODUCTS_ALL is referenced by following:

LNS
VIEW - LNS_LOAN_PRODUCTS_ALL#

[top of page]

Table: LNS_LOAN_PRODUCTS_ALL_TL

Description: Stores the multi lingual columns for each record of the base table LNS_LOAN_PRODUCTS_ALL
Primary Key: LNS_LOAN_PRODUCTS_ALL_TL_PK
  1. LOAN_PRODUCT_ID
  2. LANGUAGE
Comments

Stores the multi lingual columns for each record of the base table LNS_LOAN_PRODUCTS_ALL

Columns
Name Datatype Length Mandatory Comments
LOAN_PRODUCT_ID NUMBER (15) Y Identifies the Loan Product
LOAN_PRODUCT_NAME VARCHAR2 (80) Y Loan product name
LOAN_PRODUCT_DESC VARCHAR2 (250)
Description of the loan product
LANGUAGE VARCHAR2 (4) Y Language of the tranlated columns
SOURCE_LANG VARCHAR2 (4) Y Source Language used to store the translated columns
CREATION_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column

[top of page]

LNS.LNS_LOAN_PRODUCTS_ALL_TL does not reference any database object

LNS.LNS_LOAN_PRODUCTS_ALL_TL is referenced by following:

LNS
VIEW - LNS_LOAN_PRODUCTS_ALL_TL#

[top of page]

Table: LNS_LOAN_PRODUCT_FLAGS

Description: Loan Product Setup Read-Only Column Names Table
Foreign Keys from this table:
Foreign Key Column Foreign Table
LNS_LOAN_PRODUCT_FLAGS.LOAN_PRODUCT_ID LNS_LOAN_PRODUCTS_ALL
Comments

Loan Product Setup Read-Only Column Names Table

Indexes
Index Type Tablespace Column
LNS_LOAN_PRODUCT_FLAGS_U1 UNIQUE APPS_TS_TX_IDX LOAN_PRODUCT_ID
READONLY_COLUMN_NAME
Columns
Name Datatype Length Mandatory Comments
LOAN_PRODUCT_ID NUMBER (15) Y Loan product identifier (foreign ket to LNS_LOAN_PRODUCTS_ALL.LOAN_PRODUCT_ID)
READONLY_COLUMN_NAME VARCHAR2 (30) Y Database Column name of the field which update is not allowed in the UI
CREATED_BY NUMBER (15) Y Standard who column
CREATION_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
OBJECT_VERSION_NUMBER NUMBER
Y This column is used for locking purposes

[top of page]

LNS.LNS_LOAN_PRODUCT_FLAGS does not reference any database object

LNS.LNS_LOAN_PRODUCT_FLAGS is referenced by following:

LNS
VIEW - LNS_LOAN_PRODUCT_FLAGS#

[top of page]

Table: LNS_LOAN_PRODUCT_LINES

Description: Loan Product Setup Lines Table
Primary Key: LNS_LOAN_PRODUCT_LINES_PK
  1. LOAN_PRODUCT_LINES_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
LNS_LOAN_PRODUCT_LINES.LOAN_PRODUCT_ID LNS_LOAN_PRODUCTS_ALL
LNS_LOAN_PRODUCT_LINES.PARENT_PRODUCT_LINES_ID LNS_LOAN_PRODUCT_LINES
Foreign Keys to this table:
Foreign Key Column Foreign Table
LNS_LOAN_PRODUCT_LINES.PARENT_PRODUCT_LINES_ID LNS_LOAN_PRODUCT_LINES
Comments

Loan Product Setup Lines Table

Indexes
Index Type Tablespace Column
LNS_LOAN_PRODUCT_LINES_U1 UNIQUE APPS_TS_TX_IDX LOAN_PRODUCT_LINES_ID
LNS_LOAN_PRODUCT_LINES_N1 NONUNIQUE APPS_TS_TX_IDX LOAN_PRODUCT_ID
Columns
Name Datatype Length Mandatory Comments
LOAN_PRODUCT_LINES_ID NUMBER (15) Y Loan product line identifier
LOAN_PRODUCT_ID NUMBER (15) Y Loan product identifier (foreign key to LNS_LOAN_PRODUCTS_ALL.LOAN_PRODUCT_ID)
LOAN_PRODUCT_LINE_TYPE VARCHAR2 (30) Y The column to identifiy loan product line to be a Fee or Condition or Disbursement
LINE_REFERENCE_ID NUMBER (15)
Loan product line reference identifies (foreign ket to LNS_CONDITIONS.CONDITION_ID Or LNS_FEES.FEE_ID depending on LOAN_PRODUCT_LINE_TYPE)
ACTIVITY_CODE VARCHAR2 (30)
Activity Code
DISB_PERCENT NUMBER

Disbursement Percent
SEQUENCE_NUMBER NUMBER

Sequence Number
START_DATE_ACTIVE DATE

Start date for product line
END_DATE_ACTIVE DATE

End date for product line
MANDATORY_FLAG VARCHAR2 (1)
Flag for conditions to indicate if the condition must be met prior to submitting the loan for approval. Also mandatory condition cannot be updated/removed by loan agent
CREATED_BY NUMBER (15) Y Standard who column
CREATION_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
OBJECT_VERSION_NUMBER NUMBER (15) Y This column is used for locking purposes
PARENT_PRODUCT_LINES_ID NUMBER (15)
Self-referenced foreign key for disbursement fees and conditions

[top of page]

LNS.LNS_LOAN_PRODUCT_LINES does not reference any database object

LNS.LNS_LOAN_PRODUCT_LINES is referenced by following:

LNS
VIEW - LNS_LOAN_PRODUCT_LINES#

[top of page]

Table: LNS_LOAN_TYPES

Description: Loan Types Setup Table
Primary Key: LNS_LOAN_TYPES_PK
  1. LOAN_TYPE_ID
Primary Key: UNIQUE_TYPE_NAME
  1. LOAN_CLASS_CODE
  2. LOAN_TYPE_NAME
Comments

Loan Types Setup Table

Indexes
Index Type Tablespace Column
LNS_LOAN_TYPES_U1 UNIQUE APPS_TS_TX_IDX LOAN_TYPE_ID
Columns
Name Datatype Length Mandatory Comments
LOAN_TYPE_ID NUMBER (15) Y Loan type identifier. This column defaults the value for LNS_LOAN_HEADERS_ALL.LOAN_TYPE_ID
LOAN_CLASS_CODE VARCHAR2 (30) Y Loan class code. Lookup type is LOAN_CLASS. This column defaults the value for LNS_LOAN_HEADERS_ALL.LOAN_CLASS_CODE
LOAN_TYPE_NAME VARCHAR2 (80)
Loan type name
LOAN_TYPE_DESC VARCHAR2 (250)
Description of the loan type
START_DATE_ACTIVE DATE

Loan type start date
END_DATE_ACTIVE DATE

Loan type end date
STATUS VARCHAR2 (30)
Loan type setup status code. Lookup type is XXXXXXXX
CALCULATION_METHOD VARCHAR2 (30)
Loan calculation method code. Lookup type is INTEREST_CALCULATION_METHOD. This column defaults the value for LNS_TERMS.CALCULATION_METHOD
DAY_COUNT_METHOD VARCHAR2 (30)
Loan days formula code. Lookup type is DAY_COUNT_METHOD. This column defaults the value for LNS_TERMS.DAY_COUNT_METHOD
MULTIPLE_FUNDING_FLAG VARCHAR2 (1)
Flag to indicate if multiple disbursements are allowed. This column defaults the value for LNS_HEADERS_ALL.MULTIPLE_FUNDING_FLAG
OPEN_TO_TERM_FLAG VARCHAR2 (1)
Flag to indicate if conversion from construction phase to permanent phase is allowed. This column defaults the value for LNS_LOAN_HEADERS_ALL.OPEN_TO_TERM_FLAG
CREDIT_REVIEW_FLAG VARCHAR2 (1)
Flag to indicate if credit review is needed. This column defaults the value for LNS_LOAN_HEADERS_ALL.CREDIT_REVIEW_FLAG
CREATED_BY NUMBER (15) Y Standard who column
CREATION_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
OBJECT_VERSION_NUMBER NUMBER
Y This column is used for locking purposes
LOAN_TYPE_CODE VARCHAR2 (30)
This column is used for Data Migration from 11i to R12
PAYMENT_APPLICATION_ORDER VARCHAR2 (30)
Paymeny Application Order
PMT_APPL_ORDER_SCOPE VARCHAR2 (30)
Payment Application Order Scope

[top of page]

LNS.LNS_LOAN_TYPES does not reference any database object

LNS.LNS_LOAN_TYPES is referenced by following:

LNS
VIEW - LNS_LOAN_TYPES#

[top of page]

Table: LNS_PARTICIPANTS

Description: Loan Participants Table
Primary Key: LNS_PARTICIPANTS_PK
  1. PARTICIPANT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
LNS_PARTICIPANTS.LOAN_ID LNS_LOAN_HEADERS_ALL
LNS_PARTICIPANTS.HZ_PARTY_ID HZ_PARTIES
LNS_PARTICIPANTS.CUST_ACCOUNT_ID HZ_CUST_ACCOUNTS
LNS_PARTICIPANTS.BILL_TO_ACCT_SITE_ID HZ_CUST_ACCT_SITES_ALL
LNS_PARTICIPANTS.CONTACT_PERS_PARTY_ID HZ_PARTIES
LNS_PARTICIPANTS.CONTACT_REL_PARTY_ID HZ_PARTIES
LNS_PARTICIPANTS.CREDIT_REQUEST_ID AR_CMGT_CREDIT_REQUESTS
LNS_PARTICIPANTS.CASE_FOLDER_ID AR_CMGT_CASE_FOLDERS
Comments

Participants Table

Indexes
Index Type Tablespace Column
LNS_PARTICIPANTS_U1 UNIQUE APPS_TS_TX_IDX PARTICIPANT_ID
LNS_PARTICIPANTS_N1 NONUNIQUE APPS_TS_TX_IDX LOAN_ID
LNS_PARTICIPANTS_N2 NONUNIQUE APPS_TS_TX_IDX HZ_PARTY_ID
Columns
Name Datatype Length Mandatory Comments
PARTICIPANT_ID NUMBER (15) Y Loan Participant identifier
LOAN_ID NUMBER (15) Y Loan identifier (foreign key to LNS_LOAN_HEADERS_ALL.LOAN_ID)
HZ_PARTY_ID NUMBER (15) Y Party idenitifier (foreign key to HZ_PARTIES.PARTY_ID)
LOAN_PARTICIPANT_TYPE VARCHAR2 (30)
Participant type code to denote if the participant is the Primary Borrower, Co-Borrower or Guarantor for the loan. Lookup type is LNS_PARTICIPANT_TYPE
START_DATE_ACTIVE DATE

Start Date Active
END_DATE_ACTIVE DATE

End Date Active
CUST_ACCOUNT_ID NUMBER (15)
Customer account identifier for the participant (foreign key to HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID).
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID)
CREATION_DATE DATE
Y Standard who column - date when this row was created
LAST_UPDATED_BY NUMBER (15) Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID)
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID)
OBJECT_VERSION_NUMBER NUMBER
Y This column is used for locking purposes
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE16 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE17 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE18 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE19 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE20 VARCHAR2 (150)
Descriptive Flexfield segment
BILL_TO_ACCT_SITE_ID NUMBER (15)
Customer account billing site identifier for the participant (foreign key to HZ_CUST_ACCT_SITES_ALL.CUST_ACCT_SITE_ID).
CONTACT_PERS_PARTY_ID NUMBER (15)
Identifier for Loan Participant Contact Person Party. Foreign Key to HZ_PARTIES.PARTY_ID
CONTACT_REL_PARTY_ID NUMBER (15)
Identifier for Loan Participant Contact Relationship Party. Foreign Key to HZ_PARTIES.PARTY_ID
CREDIT_REQUEST_ID NUMBER (15)
Credit Request Identifier. Foreign Key to AR_CMGT_CREDIT_REQUESTS.CREDIT_REQUEST_ID
CASE_FOLDER_ID NUMBER (15)
Case Folder Identifier. Foreign Key to AR_CMGT_CASE_FOLDERS.CASE_FOLDER_ID
REVIEW_TYPE VARCHAR2 (30)
references AR_CMGT_CHECK_LISTS.REVIEW_TYPE
CREDIT_CLASSIFICATION VARCHAR2 (30)
references AR_CMGT_CHECK_LISTS.CREDIT_CLASSIFICATION
ACCESS_LEVEL VARCHAR2 (30)
Access level of a participant for a given loan

[top of page]

LNS.LNS_PARTICIPANTS does not reference any database object

LNS.LNS_PARTICIPANTS is referenced by following:

LNS
VIEW - LNS_PARTICIPANTS#

[top of page]

Table: LNS_RATE_SCHEDULES

Description: Loan Interest Rate Schedule Table
Primary Key: LNS_RATE_SCHEDULES_PK
  1. RATE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
LNS_RATE_SCHEDULES.TERM_ID %
Comments

Loan Interest Rate Schedule Table

Indexes
Index Type Tablespace Column
LNS_RATE_SCHEDULES_U1 UNIQUE APPS_TS_TX_IDX RATE_ID
LNS_RATE_SCHEDULES_U2 UNIQUE APPS_TS_TX_IDX TERM_ID
BEGIN_INSTALLMENT_NUMBER
START_DATE_ACTIVE
END_DATE_ACTIVE
PHASE
LNS_RATE_SCHEDULES_U3 UNIQUE APPS_TS_TX_IDX TERM_ID
END_INSTALLMENT_NUMBER
START_DATE_ACTIVE
END_DATE_ACTIVE
PHASE
Columns
Name Datatype Length Mandatory Comments
RATE_ID NUMBER (15) Y Rate identifier
TERM_ID NUMBER (15) Y Term identifier (foreign key to LNS_TERMS.TERM_ID)
INDEX_RATE NUMBER

Index rate percentage
SPREAD NUMBER

Spread rate percentage
CURRENT_INTEREST_RATE NUMBER

Current Interest Rate percentage
START_DATE_ACTIVE DATE
Y Start Date Active
END_DATE_ACTIVE DATE

End Date Active. This is the date upto which this rate is valid.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID)
CREATION_DATE DATE
Y Standard who column - date when this row was created
LAST_UPDATED_BY NUMBER (15) Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID)
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID)
OBJECT_VERSION_NUMBER NUMBER
Y This column is used for locking purposes
INDEX_DATE DATE

Index rate effective date
BEGIN_INSTALLMENT_NUMBER NUMBER

Beginning installment number from which this rate is valid
END_INSTALLMENT_NUMBER NUMBER

End installment number up to which this rate is valid
INTEREST_ONLY_FLAG VARCHAR2 (1)
Specifies whether the installment is an interest only installment
PHASE VARCHAR2 (30)
Phase interest applies to (OPEN, TERM)
FLOATING_FLAG VARCHAR2 (1)
Flag to denote whether rate is floating or not

[top of page]

LNS.LNS_RATE_SCHEDULES does not reference any database object

LNS.LNS_RATE_SCHEDULES is referenced by following:

LNS
VIEW - LNS_RATE_SCHEDULES#

[top of page]

Table: LNS_SYSTEM_OPTIONS_ALL

Description: Loans System Options Table
Foreign Keys from this table:
Foreign Key Column Foreign Table
LNS_SYSTEM_OPTIONS_ALL.TRX_TYPE_ID RA_CUST_TRX_TYPES_ALL
LNS_SYSTEM_OPTIONS_ALL.INTEREST_TRX_TYPE_ID RA_CUST_TRX_TYPES_ALL
LNS_SYSTEM_OPTIONS_ALL.FEE_TRX_TYPE_ID RA_CUST_TRX_TYPES_ALL
LNS_SYSTEM_OPTIONS_ALL.BATCH_SOURCE_ID RA_BATCH_SOURCES_ALL
LNS_SYSTEM_OPTIONS_ALL.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS_11I
LNS_SYSTEM_OPTIONS_ALL.ORG_ID HR_ALL_ORGANIZATION_UNITS
Comments

Loans System Options Table

Indexes
Index Type Tablespace Column
LNS_SYSTEM_OPTIONS_U1 UNIQUE APPS_TS_SEED SYSTEM_OPTION_ID
LNS_SYSTEM_OPTIONS_U2 UNIQUE APPS_TS_SEED ORG_ID
Columns
Name Datatype Length Mandatory Comments
SYSTEM_OPTION_ID NUMBER (15) Y System option identifier
ORG_ID NUMBER (15) Y Organization identifier
SET_OF_BOOKS_ID NUMBER (15) Y Set of books
COMBINE_INT_PRIN_FLAG VARCHAR2 (1) Y Identifies if billing engine should create either one invoice or multiple invoices
PAYMENT_APPLICATION_ORDER VARCHAR2 (30)
Default order in which invoices are created in AR
RATE_ROUNDING NUMBER

Default rounding rate used by financial calculation engine
PAYMENT_AMOUNT_ROUNDING NUMBER

Default payment amount rounding rules
PAYMENT_AMOUNT_ROUNDING_TYPE VARCHAR2 (10)
Default payment amount rounding type
GL_ACCT_REVENUE_INTEREST NUMBER

Default General Ledger account for interest revenue
GL_ACCT_REVENUE_PRINCIPAL NUMBER

Default General Ledger account for principal revenue
GL_ACCT_REVENUE_OTHER NUMBER

Default General Ledger account for other revenue
DAY_COUNT_METHOD VARCHAR2 (30)
Default days calculation method used by financial calculations engine
COMPOUNDING_FREQUENCY VARCHAR2 (30)
Default compounding frequency
LOAN_PAYMENT_FREQUENCY VARCHAR2 (30)
Default loan payment frequency
PAYMENT_IN_ARREARS_FLAG VARCHAR2 (1)
Indicates if payment is past due
PREPAY_PENALTY_FLAG VARCHAR2 (1)
Indicates default prepayment penalty
PREPAY_FEE_ID NUMBER (15)
Default prepayment fee identifier
LATE_FEE_ID NUMBER

Default late fee identifier
SERVICING_FEE_ID NUMBER (15)
Default servicing fee identifier
DELINQUENCY_THRESHOLD_NUMBER NUMBER

Default delinquency threshold number
DELINQUENCY_THRESHOLD_AMOUNT NUMBER

Default delinquency threshold amount
CALCULATION_METHOD VARCHAR2 (30)
Default calculation method
ORIGINAL_TERM NUMBER

Default term
ORIGINAL_TERM_TYPE VARCHAR2 (30)
Default term type
LOAN_CURRENCY VARCHAR2 (15)
Default loan currency
LOAN_CLASS_CODE VARCHAR2 (30)
Default loan class
LOAN_TYPE VARCHAR2 (30)
Default loan type
LOAN_SUBTYPE VARCHAR2 (30)
Default loan subtype
BATCH_SOURCE_ID NUMBER (15) Y Default batch source
DAYS_TOBILL_BEFORE_DUE_DATE NUMBER

Number of days before due date that billing engine will generate bill
DAYS_TOGL_AFTER_DUE_DATE NUMBER

Number of days added to bill due date to calculate General Ledger date
TRX_TYPE_ID NUMBER (15)
Default principal transaction type
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield structure definition
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE16 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE17 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE18 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE19 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE20 VARCHAR2 (150)
Descriptive Flexfield segment
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column. Foreign key to FND_USER.USER_ID
LAST_UPDATED_BY NUMBER (15) Y Standard Who column. Foreign key to FND_USER.USER_ID
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column. Foreign key to FND_LOGINS.LOGIN_ID
INTEREST_TRX_TYPE_ID NUMBER (15)
Default interest transaction type
FEE_TRX_TYPE_ID NUMBER (15)
Default fee transaction type
OBJECT_VERSION_NUMBER NUMBER
Y Object version number
BILL_STMT_TEMPLATE_CODE VARCHAR2 (80)
Default bill statement template code
RECEIVABLES_TRX_ID NUMBER (15)
Receivables activity ID
ADJUST_USSGL_TRX_CODE VARCHAR2 (30)
USSGL Transaction Code for Adjusting Original Receivables
FORGIVENESS_REC_TRX_ID NUMBER (15)
Transaction ID used to identity the forgiveness transactions in loans
CANCELLATION_REC_TRX_ID NUMBER (15)
Loan Cancellation Request Transaction Id
RA_TERM_ID NUMBER (15)
RA payment term id

[top of page]

LNS.LNS_SYSTEM_OPTIONS_ALL does not reference any database object

LNS.LNS_SYSTEM_OPTIONS_ALL is referenced by following:

LNS
VIEW - LNS_SYSTEM_OPTIONS_ALL#

[top of page]

Table: LNS_TERMS

Description: Loans Terms Table
Primary Key: LNS_TERMS_PK
  1. TERM_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
LNS_TERMS.LOAN_ID LNS_LOAN_HEADERS_ALL
Comments

Loans Terms Table

Indexes
Index Type Tablespace Column
LNS_TERMS_U1 UNIQUE APPS_TS_TX_IDX TERM_ID
LNS_TERMS_N1 NONUNIQUE APPS_TS_TX_IDX LOAN_ID
Columns
Name Datatype Length Mandatory Comments
TERM_ID NUMBER (15) Y Term identifier
LOAN_ID NUMBER (15) Y Loan identifier (foreign key to LNS_LOAN_HEADERS_ALL.LOAN_ID)
DAY_COUNT_METHOD VARCHAR2 (50) Y Day Count Method. Lookup type is DAY_COUNT_METHOD
BASED_ON_BALANCE VARCHAR2 (30) Y Based on Balance. Lookup type is BASED_ON_BALANCE
FIRST_RATE_CHANGE_DATE DATE

First Rate Change Date
NEXT_RATE_CHANGE_DATE DATE

Next Rate Change Date
PERCENT_INCREASE NUMBER

Maximum Rate Increase Percentage Term
PERCENT_INCREASE_TERM VARCHAR2 (30)
Maximum Rate Increase Percentage Term Period. Lookup type is FREQUENCY
PERCENT_INCREASE_LIFE NUMBER

Max / Min Percent Increase Life
FIRST_PERCENT_INCREASE NUMBER

First Max / Min Percent Increase
OPEN_PERCENT_INCREASE NUMBER

Open Max / Min Percent Increase
OPEN_PERCENT_INCREASE_LIFE NUMBER

Open Max / Min Percent Increase Life
OPEN_FIRST_PERCENT_INCREASE NUMBER

First Open Max / Min Percent Increase
PAYMENT_APPLICATION_ORDER VARCHAR2 (30)
Payment Application Order. This column stores the concatenation of the lookup codes from the lookup type PAYMENT_APPLICATION_TYPE . For example, if the payment application order is Interest first, then Principal and then Fees, this column will have the value INT_PRIN_FEE
PMT_APPL_ORDER_SCOPE VARCHAR2 (30)
Payment Application Order Scope
PREPAY_PENALTY_FLAG VARCHAR2 (1)
Prepayment Penalty Flag
PREPAY_PENALTY_DATE DATE

Prepayment Penalty Date
DELINQUENCY_THRESHOLD_NUMBER NUMBER

Delinquency Threshold Number. Denotes the limit on the Number of Consecutive Missed Payments before delinquency.
DELINQUENCY_THRESHOLD_AMOUNT NUMBER

Delinquency Threshold Amount. Denotes the limit on the Amount Past Due before delinquency.
CALCULATION_METHOD VARCHAR2 (30) Y Interest Calculation Method Code. Denotes Simple or Compound interest. Lookup type is INTEREST_CALCULATION_METHOD
REAMORTIZE_OVER_PAYMENT VARCHAR2 (1)
Flag to denote if overpayments result in reamortization of the loan
REAMORTIZE_UNDER_PAYMENT VARCHAR2 (1)
Flag to denote if underpayments result in reamortization of the loan
REAMORTIZE_WITH_INTEREST VARCHAR2 (1)
Flag to indicate if interest is included in reamortization
INTEREST_COMPOUNDING_FREQ VARCHAR2 (30) Y Interest Compunding Frequency. Lookup type is FREQUENCY
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID)
CREATION_DATE DATE
Y Standard who column - date when this row was created
LAST_UPDATED_BY NUMBER (15) Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID)
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID)
OBJECT_VERSION_NUMBER NUMBER
Y This column is used for locking purposes
AMORTIZATION_FREQUENCY VARCHAR2 (30) Y Amortization Frequency
NUMBER_GRACE_DAYS NUMBER

Number of Grace Days
RATE_TYPE VARCHAR2 (30)
Rate Type code. Denotes if Fixed or Variable. Lookup type is RATE_TYPE
CEILING_RATE NUMBER

Ceiling rate percentage
FLOOR_RATE NUMBER

Floor rate percentage
OPEN_CEILING_RATE NUMBER

Open Phase Ceiling Rate
OPEN_FLOOR_RATE NUMBER

Open Phase Floor Rate
INDEX_RATE_ID NUMBER (15)
FK to LNS_INT_RATE_HEADERS.INDEX_RATE_ID
INDEX_NAME VARCHAR2 (50)
Index Name code. Lookup type is INDEX_TYPE
LOAN_PAYMENT_FREQUENCY VARCHAR2 (30)
Loan Payment Frequency. Lookup type is FREQUENCY
ADJUSTMENT_FREQUENCY NUMBER

Adjustment Frequency.
ADJUSTMENT_FREQUENCY_TYPE VARCHAR2 (30)
Adjustment Frequency Period type code. Lookup type is PERIOD
FIXED_RATE_PERIOD NUMBER

Fixed Rate Period
FIXED_RATE_PERIOD_TYPE VARCHAR2 (30)
Fixed Rate Period type code. Lookup type is PERIOD
FIRST_PAYMENT_DATE DATE

First Payment Date
NEXT_PAYMENT_DUE_DATE DATE

Next Payment Due Date
OPEN_FIRST_PAYMENT_DATE DATE

First Payment Date of the open phase of the loan
OPEN_PAYMENT_FREQUENCY VARCHAR2 (30)
Payment Frequency of the open phase
OPEN_NEXT_PAYMENT_DATE DATE

Next payment date of the open phase
LOCK_IN_DATE DATE

Rate Lock In Date
LOCK_TO_DATE DATE

Rate Lock to Date
RATE_CHANGE_FREQUENCY VARCHAR2 (30)
Rate Change Frequency
OPEN_INDEX_DATE DATE

Open Phase Rate Index Date
TERM_INDEX_DATE DATE

Term Phase Rate Index Date
OPEN_PROJECTED_RATE NUMBER

Rate percentage used to calculate future interest for the Open phase of the loan
TERM_PROJECTED_RATE NUMBER

Rate percentage used to calculate future interest for the Term phase of the loan
PAYMENT_CALC_METHOD VARCHAR2 (30)
Payment Calculation Method used in calculation of the Amortization schedule
ORIG_PAY_CALC_METHOD VARCHAR2 (30)
This Calc method implies the last used paymentCalculationMethod for that loan before customized.
CUSTOM_CALC_METHOD VARCHAR2 (30)
This method is used to calculate the customized loans.
PRIN_FIRST_PAY_DATE DATE

For a Separate Schedule loan, this column holds the first Principal payment date.
PRIN_PAYMENT_FREQUENCY VARCHAR2 (30)
For a Separate schedule loan, this field holds the Principal payment frequency.
PENAL_INT_RATE NUMBER

Penal Interest Rate
PENAL_INT_GRACE_DAYS NUMBER

Penal Interest Grace Days
CALC_ADD_INT_UNPAID_PRIN VARCHAR2 (1)
Indicates whether interest should be calculated on unpaid principal
CALC_ADD_INT_UNPAID_INT VARCHAR2 (1)
Indicates whether interest be calculated on unpaid interest
REAMORTIZE_ON_FUNDING VARCHAR2 (30)
Reamortize on funding flag. Valid for both direct and ERS loans. Valid values: no, with rest, immediately.
DEFAULT_THRESHOLD_AMOUNT NUMBER

Threshold amount for loan to get Default status
CUSTOM_SCHED_DESC VARCHAR2 (100)
Custom schedule description
CAPITALIZE_INT VARCHAR2 (1)
Capitalize Interest
CALC_EARLY_PAY_CR VARCHAR2 (1)
Issue Interest Credit On Early Payments
FLUCTUATE_EQ_PAY_AMOUNT VARCHAR2 (1)
Fluctuate Payment Due to Additional Interest

[top of page]

LNS.LNS_TERMS does not reference any database object

LNS.LNS_TERMS is referenced by following:

LNS
VIEW - LNS_TERMS#

[top of page]

View: LNS_AEL_GL_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER

Application ID
JE_HEADER_ID NUMBER (15) Y Jornal entry header ID
JE_CATEGORY VARCHAR2 (25) Y Journal entry category 'Oracle Loans'
USER_JE_CATEGORY VARCHAR2 (0)
User journal entry category 'Oracle Loans'
JE_LINE_NUM NUMBER (15) Y Jounral Entry Line number
SET_OF_BOOKS_ID NUMBER (15) Y GL Set of books
ORG_ID NUMBER (15) Y Organization ID
TRX_CLASS VARCHAR2 (0)
Loan Class Code
TRX_CLASS_NAME VARCHAR2 (4000)
Loan Class code name
TRX_TYPE_NAME VARCHAR2 (4000)
Loan Type
TRX_NUMBER_DISPLAYED VARCHAR2 (60) Y Loan Number
TRX_NUMBER_C VARCHAR2 (0)
Loan Number
TRX_DATE VARCHAR2 (0)
Loan Start
COMMENTS VARCHAR2 (250)
loan description
DOC_SEQUENCE_ID VARCHAR2 (0)
LOAN_id
DOC_SEQUENCE_VALUE VARCHAR2 (0)
null
TRX_HDR_ID NUMBER (15) Y LOAN_id
ACCT_LINE_TYPE VARCHAR2 (0)
loan distribution account name
ACCT_LINE_TYPE_NAME VARCHAR2 (0)
loan distribution account name meaning
CODE_COMBINATION_ID VARCHAR2 (0)
GL Code combination ID
CURRENCY_CODE VARCHAR2 (15) Y Currency Code
ENTERED_DR NUMBER

Entered debit
ENTERED_CR NUMBER

Entered credit
ACCOUNTED_DR NUMBER

Accounted debit
ACCOUNTED_CR NUMBER

Accounted credit
CURRENCY_CONVERSION_DATE DATE

Currency conversion date
CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
Currency conversion type
CURRENCY_CONVERSION_RATE NUMBER

Currency conversion rate
CURRENCY_USER_CONVERSION_TYPE VARCHAR2 (0)
THIRD_PARTY_NUMBER VARCHAR2 (0)
null
THIRD_PARTY_NAME VARCHAR2 (360) Y null
THIRD_PARTY_SUB_ID VARCHAR2 (0)
Primary Borrower ID
ACCOUNTING_DATE DATE

Gl Date
TRX_LINE_NUMBER VARCHAR2 (0)
null
TRX_LINE_TYPE VARCHAR2 (0)
AE_LINE_TYPE_CODE
TRX_LINE_TYPE_NAME VARCHAR2 (0)
Transaction line type name
REQUEST_ID VARCHAR2 (0)
Request ID
PROGRAM_APPLICATION_ID VARCHAR2 (0)
Program application ID
PROGRAM_ID VARCHAR2 (0)
Program ID
PROGRAM_UPDATE_DATE VARCHAR2 (0)
Program update date

[top of page]

APPS.LNS_AEL_GL_V references the following:

APPS
SYNONYM - GL_IMPORT_REFERENCES
SYNONYM - GL_JE_HEADERS
SYNONYM - GL_JE_LINES
SYNONYM - HZ_PARTIES
SYNONYM - LNS_LOAN_HEADERS_ALL
PACKAGE - LNS_UTILITY_PUB
SYNONYM - XLA_AE_HEADERS
SYNONYM - XLA_AE_LINES
SYNONYM - XLA_EVENTS
SYNONYM - XLA_TRANSACTION_ENTITIES

APPS.LNS_AEL_GL_V is not referenced by any database object

[top of page]

View: LNS_AMORTIZATION_SCHEDULES_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
LOAN_ID NUMBER (15) Y
AMORTIZATION_SCHEDULE_ID NUMBER (15) Y
PAYMENT_NUMBER NUMBER

DUE_DATE DATE

PRINCIPAL_AMOUNT NUMBER

INTEREST_AMOUNT NUMBER

FEE_AMOUNT NUMBER

PRIN_CASH NUMBER

PRIN_LOAN_PMT_CREDIT NUMBER

PRIN_NET_CREDIT NUMBER

PRIN_OTHER_CREDIT NUMBER

PRIN_CREDIT NUMBER

PRIN_ADJ NUMBER

PRINCIPAL_PAID NUMBER

INT_CASH NUMBER

INT_LOAN_PMT_CREDIT NUMBER

INT_NET_CREDIT NUMBER

INT_OTHER_CREDIT NUMBER

INT_CREDIT NUMBER

INT_ADJ NUMBER

INTEREST_PAID NUMBER

FEE_CASH NUMBER

FEE_LOAN_PMT_CREDIT NUMBER

FEE_NET_CREDIT NUMBER

FEE_OTHER_CREDIT NUMBER

FEE_CREDIT NUMBER

FEE_ADJ NUMBER

FEE_PAID NUMBER

PRINCIPAL_BALANCE NUMBER

FUNDED_AMOUNT NUMBER

TOTAL_BILLED_AMOUNT NUMBER

TOTAL_AR_BILLED_AMOUNT NUMBER

TOTAL_REMAINING_AMOUNT NUMBER

LAST_APPLIED_DATE DATE

REVERSED_CODE VARCHAR2 (1)
REVERSED_DESC VARCHAR2 (80) Y
CREATION_DATE DATE
Y
PARENT_AMORTIZATION_ID NUMBER

BILL_TYPE_CODE VARCHAR2 (9)
BILL_TYPE_DESC VARCHAR2 (80) Y
CREDIT_ENABLED_CODE VARCHAR2 (15)
REBILL_ENABLED_CODE VARCHAR2 (15)
PRINCIPAL_REMAINING NUMBER

INTEREST_REMAINING NUMBER

FEE_REMAINING NUMBER

PRINCIPAL_TRX_ID NUMBER

INTEREST_TRX_ID NUMBER

FEE_TRX_ID NUMBER

STATEMENT_XML CLOB (4000)
LOAN_STATUS VARCHAR2 (30) Y
ORG_ID NUMBER (15) Y
CURRENCY VARCHAR2 (15) Y
LEGAL_ENTITY_ID NUMBER (15)
PHASE VARCHAR2 (30)

[top of page]

APPS.LNS_AMORTIZATION_SCHEDULES_V references the following:

APPS
SYNONYM - AR_PAYMENT_SCHEDULES_ALL
SYNONYM - AR_RECEIVABLE_APPLICATIONS_ALL
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS
SYNONYM - LNS_AMORTIZATION_SCHEDS
SYNONYM - LNS_LOAN_HEADERS_ALL
VIEW - LNS_LOOKUPS

APPS.LNS_AMORTIZATION_SCHEDULES_V is not referenced by any database object

[top of page]

View: LNS_AM_SCHEDS_DTL_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

Amortization Schedule Details View

Columns
Name Datatype Length Mandatory Comments
LOAN_ID NUMBER (15) Y Identifies the Loan
AMORTIZATION_SCHEDULE_ID NUMBER (15) Y Identifies the Amortization Schedule
PAYMENT_NUMBER NUMBER

Payment Number
DUE_DATE DATE

Due Date
PRINCIPAL_AMOUNT NUMBER

Billed Principal Amount
INTEREST_AMOUNT NUMBER

Billed Interest Amount
FEE_AMOUNT NUMBER

Billed Fee Amount
PRIN_CASH NUMBER

Principal Paid in Cash
PRIN_LOAN_PMT_CREDIT NUMBER

Principal Paid as Credit Memo
PRIN_NET_CREDIT NUMBER

Principal Paid as Netting Credit Memo
PRIN_OTHER_CREDIT NUMBER

Other Credit Memos on Principal
PRIN_CREDIT NUMBER

Credit Memos on Principal
PRIN_ADJ NUMBER

Adjustements on Principal
INT_CASH NUMBER

Interest Paid in Cash
INT_LOAN_PMT_CREDIT NUMBER

Interest Paid as Credit Memo
INT_NET_CREDIT NUMBER

Interest Paid as Netting Credit Memo
INT_OTHER_CREDIT NUMBER

Other Credit Memos on Interest
INT_CREDIT NUMBER

Credit Memos on Interest
INT_ADJ NUMBER

Adjustements on Interest
FEE_CASH NUMBER

Fee Paid in Cash
FEE_LOAN_PMT_CREDIT NUMBER

Fee Paid as Credit Memo
FEE_NET_CREDIT NUMBER

Fee Paid as Netting Credit Memo
FEE_OTHER_CREDIT NUMBER

Other Credit Memos on Fee
FEE_CREDIT NUMBER

Credit Memos on Fee
FEE_ADJ NUMBER

Adjustements on Fee
TOTAL_BILLED_AMOUNT NUMBER

Total Billed Amount
REVERSED_CODE VARCHAR2 (1)
Reversed Code
BILL_TYPE_CODE VARCHAR2 (9)
Bill Type Code
BILL_TYPE_DESC VARCHAR2 (80) Y Bill Type Description
PRINCIPAL_REMAINING NUMBER

Principal Remaining Amount
INTEREST_REMAINING NUMBER

Interest Remaining Amount
FEE_REMAINING NUMBER

Fee Remaining Amount
PHASE VARCHAR2 (30)
Phase

[top of page]

APPS.LNS_AM_SCHEDS_DTL_V references the following:

APPS
SYNONYM - AR_PAYMENT_SCHEDULES_ALL
PACKAGE - FND_GLOBAL
SYNONYM - LNS_AMORTIZATION_SCHEDS
SYNONYM - LNS_LOAN_HEADERS_ALL
VIEW - LNS_LOOKUPS

APPS.LNS_AM_SCHEDS_DTL_V is not referenced by any database object

[top of page]

View: LNS_AM_SCHEDS_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

Amortization Schedules View

Columns
Name Datatype Length Mandatory Comments
LOAN_ID NUMBER (15) Y Identifies the Loan
AMORTIZATION_SCHEDULE_ID NUMBER (15) Y Identifies the Amortization Schedule
PAYMENT_NUMBER NUMBER

Payment Number
DUE_DATE DATE

Due Date
PRINCIPAL_AMOUNT NUMBER

Billed Principal Amount
INTEREST_AMOUNT NUMBER

Billed Interest Amount
FEE_AMOUNT NUMBER

Billed Fee Amount
PRINCIPAL_PAID NUMBER

Principal Paid
INTEREST_PAID NUMBER

Interest Paid
FEE_PAID NUMBER

Fee Paid
PRINCIPAL_BALANCE NUMBER

Principal Balance
FUNDED_AMOUNT NUMBER

Loan Funded Amount
TOTAL_BILLED_AMOUNT NUMBER

Total Billed Amount
TOTAL_AR_BILLED_AMOUNT NUMBER

Total Billed Amount from AR
TOTAL_REMAINING_AMOUNT NUMBER

Total Remaining Amount
LAST_APPLIED_DATE DATE

Last Applied Date
REVERSED_CODE VARCHAR2 (1)
Reversed Code
REVERSED_DESC VARCHAR2 (80) Y Reversed Description
CREATION_DATE DATE
Y Amortization Creation Date
PARENT_AMORTIZATION_ID NUMBER

Identifies the Parent Amortization
BILL_TYPE_CODE VARCHAR2 (9)
Bill Type Code
BILL_TYPE_DESC VARCHAR2 (80) Y Bill Type Description
CREDIT_ENABLED_CODE VARCHAR2 (15)
Credit Enabled Code
REBILL_ENABLED_CODE VARCHAR2 (15)
Rebill Enabled Code
PRINCIPAL_REMAINING NUMBER

Remaining Principal Amount
INTEREST_REMAINING NUMBER

Remaining Interest Amount
FEE_REMAINING NUMBER

Remaining Fee Amount
PRINCIPAL_TRX_ID NUMBER

Identifies the Principal Transaction
INTEREST_TRX_ID NUMBER

Identifies the Interest Transaction
FEE_TRX_ID NUMBER

Identifies the Fee Transaction
STATEMENT_XML CLOB (4000)
Billing Statement
LOAN_STATUS VARCHAR2 (30) Y Loan Status
ORG_ID NUMBER (15) Y Identifies the Org
LOAN_CURRENCY VARCHAR2 (15) Y Loan Currency
LEGAL_ENTITY_ID NUMBER (15)
Identifies the Legal Entity
PHASE VARCHAR2 (30)
Phase
TRX_DATE DATE

Trx Date
GL_DATE DATE

Gl Date

[top of page]

APPS.LNS_AM_SCHEDS_V references the following:

APPS
SYNONYM - AR_ADJUSTMENTS_ALL
SYNONYM - AR_PAYMENT_SCHEDULES_ALL
SYNONYM - AR_RECEIVABLE_APPLICATIONS_ALL
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS
SYNONYM - LNS_AMORTIZATION_SCHEDS
SYNONYM - LNS_DISB_HEADERS
SYNONYM - LNS_DISB_LINES
SYNONYM - LNS_LOAN_AMOUNT_ADJS
SYNONYM - LNS_LOAN_HEADERS_ALL
SYNONYM - LNS_LOAN_LINES
VIEW - LNS_LOOKUPS

APPS.LNS_AM_SCHEDS_V is not referenced by any database object

[top of page]

View: LNS_AR_AMORTIZATIONS_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
LOAN_ID NUMBER

AMORTIZATION_SCHEDULE_ID NUMBER

PAYMENT_NUMBER NUMBER

DUE_DATE DATE

PRINCIPAL_AMOUNT NUMBER

INTEREST_AMOUNT NUMBER

FEE_AMOUNT NUMBER

PRIN_CASH NUMBER

PRIN_LOAN_PMT_CREDIT NUMBER

PRIN_NET_CREDIT NUMBER

PRIN_OTHER_CREDIT NUMBER

PRIN_NEG_ADJ NUMBER

PRIN_POS_ADJ NUMBER

INT_CASH NUMBER

INT_LOAN_PMT_CREDIT NUMBER

INT_NET_CREDIT NUMBER

INT_OTHER_CREDIT NUMBER

INT_NEG_ADJ NUMBER

INT_POS_ADJ NUMBER

FEE_CASH NUMBER

FEE_LOAN_PMT_CREDIT NUMBER

FEE_NET_CREDIT NUMBER

FEE_OTHER_CREDIT NUMBER

FEE_NEG_ADJ NUMBER

FEE_POS_ADJ NUMBER

PRIN_TD_CASH NUMBER

PRIN_TD_LOAN_PMT_CREDIT NUMBER

PRIN_TD_NET_CREDIT NUMBER

PRIN_TD_OTHER_CREDIT NUMBER

PRIN_TD_NEG_ADJ NUMBER

PRIN_TD_POS_ADJ NUMBER

INT_TD_CASH NUMBER

INT_TD_LOAN_PMT_CREDIT NUMBER

INT_TD_NET_CREDIT NUMBER

INT_TD_OTHER_CREDIT NUMBER

INT_TD_NEG_ADJ NUMBER

INT_TD_POS_ADJ NUMBER

FEE_TD_CASH NUMBER

FEE_TD_LOAN_PMT_CREDIT NUMBER

FEE_TD_NET_CREDIT NUMBER

FEE_TD_OTHER_CREDIT NUMBER

FEE_TD_NEG_ADJ NUMBER

FEE_TD_POS_ADJ NUMBER

TOTAL_PRIN_TD_CASH NUMBER

TOTAL_PRIN_TD_LOAN_PMT_CREDIT NUMBER

TOTAL_PRIN_TD_NET_CREDIT NUMBER

TOTAL_PRIN_TD_OTHER_CREDIT NUMBER

TOTAL_PRIN_TD_NEG_ADJ NUMBER

TOTAL_PRIN_TD_POS_ADJ NUMBER

FUNDED_AMOUNT NUMBER

TOTAL_BILLED_AMOUNT NUMBER

TOTAL_AR_BILLED_AMOUNT NUMBER

TOTAL_REMAINING_AMOUNT NUMBER

TOTAL_APPLIED_AMOUNT NUMBER

LAST_APPLIED_DATE DATE

REVERSED_CODE VARCHAR2 (0)
TOTAL_ADJUSTED_AMOUNT NUMBER

TOTAL_CREDITED_AMOUNT NUMBER

LAST_CREDITED_DATE DATE

CREATION_DATE DATE

PARENT_AMORTIZATION_ID NUMBER

BILL_TYPE_CODE VARCHAR2 (0)
PRINCIPAL_REMAINING NUMBER

INTEREST_REMAINING NUMBER

FEE_REMAINING NUMBER

PRINCIPAL_TRX_ID NUMBER

INTEREST_TRX_ID NUMBER

FEE_TRX_ID NUMBER

STATEMENT_XML VARCHAR2 (0)
LOAN_STATUS VARCHAR2 (0)
ORG_ID NUMBER

CURRENCY VARCHAR2 (0)
PRIN_USSGL_TRX_CODE VARCHAR2 (0)
INT_USSGL_TRX_CODE VARCHAR2 (0)
FEE_USSGL_TRX_CODE VARCHAR2 (0)
LEGAL_ENTITY_ID NUMBER

PHASE VARCHAR2 (0)

[top of page]

APPS.LNS_AR_AMORTIZATIONS_V references the following:

PUBLIC
SYNONYM - DUAL
- DUAL

APPS.LNS_AR_AMORTIZATIONS_V is not referenced by any database object

[top of page]

View: LNS_LOAN_DETAILS_EXT_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
EVENT_ID NUMBER (15) Y Event ID
LEDGER_ID NUMBER (15) Y Ledger ID
LINE_NUMBER NUMBER (15) Y Extract Line
DISTRIBUTION_ID NUMBER (15) Y Loans Distribution ID
LOAN_ID NUMBER (15) Y Loan ID
LINE_TYPE VARCHAR2 (30) Y Line Type
ACCOUNT_NAME VARCHAR2 (30) Y Account Name
CODE_COMBINATION_ID NUMBER (15) Y CC_ID
ACCOUNT_TYPE VARCHAR2 (30) Y Account Type
DISTRIBUTION_PERCENT NUMBER
Y Distribution Percent
DISTRIBUTION_AMOUNT NUMBER

Distribution Amount
START_DATE_ACTIVE DATE

Start Date
END_DATE_ACTIVE DATE

End Date
CREATED_BY NUMBER (15) Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
OBJECT_VERSION_NUMBER NUMBER
Y Standard Who Column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Flexfield
ATTRIBUTE1 VARCHAR2 (150)
Flexfield
ATTRIBUTE2 VARCHAR2 (150)
Flexfield
ATTRIBUTE3 VARCHAR2 (150)
Flexfield
ATTRIBUTE4 VARCHAR2 (150)
Flexfield
ATTRIBUTE5 VARCHAR2 (150)
Flexfield
ATTRIBUTE6 VARCHAR2 (150)
Flexfield
ATTRIBUTE7 VARCHAR2 (150)
Flexfield
ATTRIBUTE8 VARCHAR2 (150)
Flexfield
ATTRIBUTE9 VARCHAR2 (150)
Flexfield
ATTRIBUTE10 VARCHAR2 (150)
Flexfield
ATTRIBUTE11 VARCHAR2 (150)
Flexfield
ATTRIBUTE12 VARCHAR2 (150)
Flexfield
ATTRIBUTE13 VARCHAR2 (150)
Flexfield
ATTRIBUTE14 VARCHAR2 (150)
Flexfield
ATTRIBUTE15 VARCHAR2 (150)
Flexfield
ATTRIBUTE16 VARCHAR2 (150)
Flexfield
ATTRIBUTE17 VARCHAR2 (150)
Flexfield
ATTRIBUTE18 VARCHAR2 (150)
Flexfield
ATTRIBUTE19 VARCHAR2 (150)
Flexfield
ATTRIBUTE20 VARCHAR2 (150)
Flexfield
DISTRIBUTION_TYPE VARCHAR2 (30)
Distribution Type
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
USSGL_TRANSACTION_CODE VARCHAR2 (30)
Obsoleted
FEE_ID NUMBER (15)
Fee ID
DISB_HEADER_ID NUMBER

Disbursement Header ID
DISBURSEMENT_STATUS VARCHAR2 (30)
Disbursement Status
DISBURSEMENT_AMOUNT NUMBER

Disbursement Amount
DISBURSEMENT_NUMBER NUMBER

Disbursement NUmber
EVENT_TYPE VARCHAR2 (30) Y Event Type
BALANCING_SEGMENT_VALUE VARCHAR2 (25)
BSV
DERIVED_PROGRAM_ACCOUNT_BSV VARCHAR2 (25)
Derived BSV
LOAN_AMOUNT_ADJ_ID NUMBER

Loan Amount Adjustment Id
LOAN_ADJUSTMENT_DESCRIPTION VARCHAR2 (250)
Adjustment Description
LOAN_LINE_ID NUMBER

ERS Loan Additional Receivable Line Id
ORIG_ENCUM_DIST_ID NUMBER

Original Encumbrance Distribution Id used to refer the Loan Approval Distribution
ORIG_ENCUM_DIST_AMT NUMBER

Original Encumbrance Distribution Amount used to refer the Loan Approval Distribution Amount
ORIG_ENCUM_SYS_TRX_ID NUMBER

Original System Transaction Identifier whose value is -1

[top of page]

APPS.LNS_LOAN_DETAILS_EXT_V references the following:

APPS
SYNONYM - FV_FUND_PARAMETERS
SYNONYM - GL_CODE_COMBINATIONS
SYNONYM - LNS_DISB_HEADERS
SYNONYM - LNS_DISTRIBUTIONS
PACKAGE - LNS_DISTRIBUTIONS_PUB
SYNONYM - LNS_LOAN_AMOUNT_ADJS
SYNONYM - LNS_LOAN_HEADERS_ALL
PACKAGE - LNS_UTILITY_PUB
SYNONYM - XLA_EVENTS
SYNONYM - XLA_TRANSACTION_ENTITIES

APPS.LNS_LOAN_DETAILS_EXT_V is not referenced by any database object

[top of page]

View: LNS_LOAN_HEADERS_EXT_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
EVENT_ID NUMBER (15) Y Event ID
LEDGER_ID NUMBER (15) Y Ledger ID
LOAN_ID NUMBER (15) Y Loan ID
LAST_UPDATE_DATE DATE
Y Standard WHo Columns
LAST_UPDATED_BY NUMBER (15) Y Standard WHo Columns
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHo Columns
CREATION_DATE DATE
Y Standard WHo Columns
CREATED_BY NUMBER (15) Y Standard WHo Columns
PROGRAM_ID NUMBER (15)
Standard WHo Columns
OBJECT_VERSION_NUMBER NUMBER
Y Standard WHo Columns
REQUEST_ID NUMBER (15)
Standard WHo Columns
LOAN_NUMBER VARCHAR2 (60) Y Loan Number
LOAN_DESCRIPTION VARCHAR2 (250)
Loan Description
INITIAL_LOAN_BALANCE NUMBER
Y Loan Balance
LAST_PAYMENT_DATE DATE

Last Pay Date
LAST_PAYMENT_AMOUNT NUMBER

Last Pay Amount
LOAN_TERM NUMBER
Y Term
LOAN_TERM_PERIOD VARCHAR2 (30) Y Term Period
LOAN_CURRENCY VARCHAR2 (15) Y Currency
LOAN_CLASS_CODE VARCHAR2 (30)
Loan Class
LOAN_TYPE VARCHAR2 (80) Y Loan Type
LOAN_SUBTYPE VARCHAR2 (30)
Loan SubType
LOAN_PURPOSE_CODE VARCHAR2 (30)
Loan Purpose
AMORTIZED_TERM NUMBER

Amortized Term
AMORTIZED_TERM_PERIOD VARCHAR2 (30)
Term Period
LOAN_MATURITY_DATE DATE

Maturity Date
LOAN_START_DATE DATE
Y Loan Start Date
LOAN_APPLICATION_DATE DATE
Y Application Date
LOAN_CLOSING_DATE DATE

Closing Date
LAST_BILLED_DATE DATE

Last Billed Date
END_DATE DATE

End Date
PRODUCT_FLAG VARCHAR2 (1)
Product Flag
CUST_ACCOUNT_ID NUMBER (15)
Cust Account ID
PRIMARY_BORROWER_ID NUMBER (15)
Primary Borrower ID
PARTY_NAME VARCHAR2 (360) Y Party Type
PRODUCT_ID NUMBER (15)
Product ID
REQUESTED_AMOUNT NUMBER
Y Requested Amount
FUNDED_AMOUNT NUMBER

Funded Amount
REFERENCE_AMOUNT NUMBER

Reference Amount
REFERENCE_NUMBER VARCHAR2 (60)
Reference NUmber
REFERENCE_NAME VARCHAR2 (60)
Reference Number
REFERENCE_TYPE VARCHAR2 (30)
Reference Type
REFERENCE_DESCRIPTION VARCHAR2 (250)
Reference Description
LOAN_APPROVAL_DATE DATE

Loan Approval Date
LOAN_APPROVED_BY NUMBER

Loan Approved By
LOAN_STATUS VARCHAR2 (30) Y Loan Status
LOAN_ASSIGNED_TO NUMBER

Loan Assigned To
REFERENCE_ID NUMBER (15)
reference ID
CUSTOM_PAYMENTS_FLAG VARCHAR2 (1)
Custom Payments Flag
BILLED_FLAG VARCHAR2 (1)
Billed Flag
ORG_ID NUMBER (15) Y Organization ID
USSGL_TRANSACTION_CODE VARCHAR2 (30)
obsoleted
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Flexfield
ATTRIBUTE1 VARCHAR2 (150)
Flexfield
ATTRIBUTE2 VARCHAR2 (150)
Flexfield
ATTRIBUTE3 VARCHAR2 (150)
Flexfield
ATTRIBUTE4 VARCHAR2 (150)
Flexfield
ATTRIBUTE5 VARCHAR2 (150)
Flexfield
ATTRIBUTE6 VARCHAR2 (150)
Flexfield
ATTRIBUTE7 VARCHAR2 (150)
Flexfield
ATTRIBUTE8 VARCHAR2 (150)
Flexfield
ATTRIBUTE9 VARCHAR2 (150)
Flexfield
ATTRIBUTE10 VARCHAR2 (150)
Flexfield
ATTRIBUTE11 VARCHAR2 (150)
Flexfield
ATTRIBUTE12 VARCHAR2 (150)
Flexfield
ATTRIBUTE13 VARCHAR2 (150)
Flexfield
ATTRIBUTE14 VARCHAR2 (150)
Flexfield
ATTRIBUTE15 VARCHAR2 (150)
Flexfield
ATTRIBUTE16 VARCHAR2 (150)
Flexfield
ATTRIBUTE17 VARCHAR2 (150)
Flexfield
ATTRIBUTE18 VARCHAR2 (150)
Flexfield
ATTRIBUTE19 VARCHAR2 (150)
Flexfield
ATTRIBUTE20 VARCHAR2 (150)
Flexfield
GL_DATE DATE

GL Date
REFERENCE_TYPE_ID NUMBER (15)
reference Type ID
BILL_TO_ACCT_SITE_ID NUMBER (15)
Bill to Acct Site ID
REC_ADJUSTMENT_NUMBER VARCHAR2 (20)
Rec Adjustment NUmber
CONTACT_PERS_PARTY_ID NUMBER (15)
Conact Person Party ID
CONTACT_REL_PARTY_ID NUMBER (15)
Contact Relationship Party ID
EXCHANGE_RATE_TYPE VARCHAR2 (30)
Exchange Rate information
EXCHANGE_DATE DATE

Exchange Rate information
EXCHANGE_RATE NUMBER

Exchange Rate information
COLLATERAL_PERCENT NUMBER

Collateral PErcent
CREDIT_REVIEW_FLAG VARCHAR2 (1)
Credit Review Flag
LAST_PAYMENT_NUMBER NUMBER

Last Payment NUmber
LAST_AMORTIZATION_ID NUMBER

Last Amortization ID
LEGAL_ENTITY_ID NUMBER (15)
Legal Entity ID
OPEN_TO_TERM_FLAG VARCHAR2 (1)
Open To Term Flag
MULTIPLE_FUNDING_FLAG VARCHAR2 (1)
Multiple Funding Flag
LOAN_TYPE_ID NUMBER (15)
Loan Type ID
SECONDARY_STATUS VARCHAR2 (30)
Secondary Status
OPEN_TO_TERM_EVENT VARCHAR2 (30)
Open To Term Event
BALLOON_PAYMENT_TYPE VARCHAR2 (30)
Balloon Payment Type
CURRENT_PHASE VARCHAR2 (30)
Current Phase
OPEN_LOAN_START_DATE DATE

loan start date
OPEN_LOAN_TERM NUMBER

open loan term
OPEN_LOAN_TERM_PERIOD VARCHAR2 (30)
loan term period
OPEN_MATURITY_DATE DATE

maturity date
FUNDS_CHECK_DATE DATE

funds check date
FUNDS_RESERVED_FLAG VARCHAR2 (1)
funds reserved flag
SUBSIDY_RATE NUMBER

subsidy rate
SUBSIDY_COST NUMBER

subsidy cost
UNSUBSIDIZED_AMOUNT NUMBER

unsubsidized amount
APPLICATION_ID NUMBER

Application Id of the Loans
ENTITY_CODE VARCHAR2 (30) Y Entity Code representing Loans Application

[top of page]

APPS.LNS_LOAN_HEADERS_EXT_V references the following:

APPS
SYNONYM - HZ_PARTIES
SYNONYM - XLA_EVENTS
SYNONYM - XLA_TRANSACTION_ENTITIES
- LNS_LOAN_HEADERS_ALL_VL
- LNS_LOAN_TYPES_VL

APPS.LNS_LOAN_HEADERS_EXT_V is not referenced by any database object

[top of page]

View: LNS_LOAN_INFO

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
LOAN_ID NUMBER (15)
Loan identifier
CUSTOMER_NAME VARCHAR2 (360)
customer name
CUSTOMER_NUMBER VARCHAR2 (30)
customer number
LOAN_NUMBER VARCHAR2 (60)
loan number
LOAN_START_DATE DATE

start date
FUNDED_AMOUNT NUMBER

funded amount
LOAN_STATUS VARCHAR2 (4000)
loan status
LOAN_CLASS VARCHAR2 (4000)
loan class
LOAN_TYPE VARCHAR2 (80)
loan type
DISB_HEADER_ID NUMBER

Disbursement Header ID
DISBURSEMENT_STATUS VARCHAR2 (4000)
Disbursement Status
DISBURSEMENT_NUMBER NUMBER

Disbursement Number
DISBURSEMENT_REQUEST_DATE DATE

Disbursement Request Date
LOAN_AMOUNT_ADJ_ID NUMBER

Loan Amount Adjustment Id
LOAN_ADJUSTMENT_DESCRIPTION VARCHAR2 (250)
Loan Adjustment Description
LOAN_LINE_ID NUMBER

ERS Loan Additional Receivable Line Id
REFERENCE_DESCRIPTION VARCHAR2 (250)
ERS Loan Additional Receivable Line Description

[top of page]

APPS.LNS_LOAN_INFO references the following:

APPS
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_PARTIES
SYNONYM - LNS_DISB_HEADERS
SYNONYM - LNS_LOAN_AMOUNT_ADJS
SYNONYM - LNS_LOAN_HEADERS_ALL
SYNONYM - LNS_LOAN_LINES
PACKAGE - LNS_UTILITY_PUB
- LNS_LOAN_TYPES_VL

APPS.LNS_LOAN_INFO is not referenced by any database object

[top of page]

View: LNS_LOAN_PARTICIPANTS_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

View for Loan Participants Information

Columns
Name Datatype Length Mandatory Comments
LOAN_ID NUMBER (15) Y Loan identifier
PARTICIPANT_NAME VARCHAR2 (360) Y Participant Party Name
PARTICIPANT_TYPE VARCHAR2 (80) Y Participant Type code
PARTICIPANT_PARTY_TYPE VARCHAR2 (80) Y Participant Party Type code - ORGANIZATION or PERSON.
PARTICIPANT_ADDRESS VARCHAR2 (504)
Concatenation of the primary address fields for the participant
PARTICIPANT_CONTACT VARCHAR2 (360)
Primary contact person name
PARTICIPANT_CONTACT_PHONE VARCHAR2 (60)
Primary telephone number for the primary contact peson
HZ_PARTY_ID NUMBER (15) Y Party identifier for the participant (foreign key to HZ_PARTIES.PARTY_ID)
PARTICIPANT_ID NUMBER (15) Y Participant identifier
CUST_ACCOUNT_ID NUMBER (15)
Customer Account identifier for the participant (foreign key to HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID)
BILL_TO_ACCT_SITE_ID NUMBER (15)
Customer account billing site identifier for the participant (foreign key to HZ_CUST_ACCT_SITES_ALL.CUST_ACCT_SITE_ID).
START_DATE_ACTIVE DATE

Start Date Active
END_DATE_ACTIVE DATE

End Date Active. The date until which the participant is active on the loan.
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE16 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE17 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE18 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE19 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE20 VARCHAR2 (150)
Descriptive flexfield segment
PARTICIPANT_TYPE_CODE VARCHAR2 (30)
Participant Type code
PARTY_TYPE_CODE VARCHAR2 (30) Y Participant Party Type Code
CONTACT_PERSON_PARTY_ID NUMBER (15)
Contact Person Party identifier
CONTACT_PHONE_ID NUMBER (15)
Contact Person Phone identifier
CONTACT_RELATIONSHIP_PARTY_ID NUMBER (15)
Contact Relationship Party identifier
CREDIT_REQUEST_ID NUMBER (15)
Credit Request identifier

[top of page]

APPS.LNS_LOAN_PARTICIPANTS_V references the following:

APPS
VIEW - AR_LOOKUPS
PACKAGE - FND_GLOBAL
VIEW - FND_TERRITORIES_VL
SYNONYM - HZ_CONTACT_POINTS
SYNONYM - HZ_PARTIES
VIEW - LNS_LOOKUPS
SYNONYM - LNS_PARTICIPANTS

APPS.LNS_LOAN_PARTICIPANTS_V is not referenced by any database object

[top of page]

View: LNS_LOAN_PAYMENT_SUMMARY_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
LOAN_ID NUMBER (15) Y Loan identifier
TOTAL_PRINCIPAL_BALANCE NUMBER

Total remaining unpaid amount for this loan
NEXT_PAYMENT_DUE_DATE DATE

Due date of next due installment
NEXT_PAYMENT_TOTAL_DUE NUMBER

Due date of next due installment
TOTAL_OVERDUE NUMBER

Total amount overdue
LAST_OVERDUE_DATE DATE

Last date payment was missed
OLDEST_OVERDUE_DATE DATE

Oldest OVerdue Invoice
LAST_PAYMENT_AMOUNT NUMBER

Last payment amount on the loan
LAST_PAYMENT_DATE DATE

Last payment date on the loan
ORG_ID NUMBER (15) Y Organization ID
LEGAL_ENTITY_ID NUMBER (15)
Legal Entity ID
CURRENT_PHASE VARCHAR2 (30)
Current Phase

[top of page]

APPS.LNS_LOAN_PAYMENT_SUMMARY_V references the following:

APPS
SYNONYM - AR_PAYMENT_SCHEDULES_ALL
SYNONYM - AR_RECEIVABLE_APPLICATIONS_ALL
SYNONYM - LNS_AMORTIZATION_SCHEDS
SYNONYM - LNS_LOAN_HEADERS_ALL

APPS.LNS_LOAN_PAYMENT_SUMMARY_V is not referenced by any database object

[top of page]

View: LNS_LOAN_PRODUCTS_ALL_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

Loan Products Translation View for table LNS_LOAN_PRODUCTS_ALL

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row id of the table
LOAN_PRODUCT_ID NUMBER (15) Y Identifies the Loan Product
LOAN_CLASS_CODE VARCHAR2 (30)
Loan class code. Lookup type is LOAN_CLASS
LOAN_TYPE_ID NUMBER (15) Y FK to LNS_LOAN_TYPES
LOAN_PRODUCT_NAME VARCHAR2 (80) Y Loan product name
LOAN_PRODUCT_DESC VARCHAR2 (250)
Description of the loan product
START_DATE_ACTIVE DATE

Start date of loan product
END_DATE_ACTIVE DATE

End date of loan product
STATUS VARCHAR2 (30)
Loan product setup status code. Lookup type is LNS_SETUP_STATUS
LOAN_TERM NUMBER

Loan term range from. This column defaults the value for LNS_LOAN_HEADERS_ALL.LOAN_TERM
LOAN_TERM_PERIOD VARCHAR2 (30)
Period of loan term range from. This column defaults the value for LNS_LOAN_HEADERS_ALL.LOAN_TERM_PERIOD
MAX_LOAN_TERM NUMBER

Loan term range to. This column defaults the value for LNS_LOAN_HEADERS_ALL.LOAN_TERM
MAX_LOAN_TERM_PERIOD VARCHAR2 (30)
Period of loan term range to. This column defaults the value for LNS_LOAN_HEADERS_ALL.LOAN_TERM_PERIOD
OPEN_LOAN_TERM NUMBER

Open Loan Term
OPEN_LOAN_TERM_PERIOD VARCHAR2 (30)
Open Loan Term Period
OPEN_MAX_LOAN_TERM NUMBER

Open Max Loan Term
OPEN_MAX_LOAN_TERM_PERIOD VARCHAR2 (30)
Open Max Loan Term Period
LOAN_CURRENCY VARCHAR2 (30)
Loan currency code (foreign key to FND_CURRENCIES.CURRENCY_CODE). This column defaults the value for LNS_LOAN_HEADERS_ALL.LOAN_CURRENCY
REQUESTED_AMOUNT NUMBER

Requested amount range from. This column defaults the value for LNS_LOAN_HEADERS_ALL.REQUESTED_AMOUNT
MAX_REQUESTED_AMOUNT NUMBER

Requested amount range to. This column defaults the value for LNS_LOAN_HEADERS_ALL.REQUESTED_AMOUNT
INDEX_RATE_ID NUMBER (15)
Interest rate index (foreign key to LNS_INT_RATE_HEADERS.INTEREST_RATE_ID). This column defaults the value for is LNS_TERMS.INDEX_RATE_ID
RATE_TYPE VARCHAR2 (30)
Loan rate type code. Lookup type is RATE_TYPE. This column defaults the value for LNS_TERMS.RATE_TYPE
SPREAD NUMBER

Spread percentage rate. This column defaults the value for LNS_RATE_SCHEDULES.SPREAD
OPEN_SPREAD NUMBER

Spread during open phase of loan product
FLOOR_RATE NUMBER

Floor percentage rate. This column defaults the value for LNS_TERMS.FLOOR_RATE
CEILING_RATE NUMBER

Ceiling percentage rate. This column defaults the value for LNS_TERMS.CEILING_RATE
OPEN_FLOOR_RATE NUMBER

Open Phase Floor Rate
OPEN_CEILING_RATE NUMBER

Open Phase Ceiling Rate
INTEREST_COMPOUNDING_FREQ VARCHAR2 (30)
Interest accrual frequency code. Lookup type is XXXXXXXX. This column defaults the value for LNS_TERMS.INTEREST_COMPOUNDING_FREQ
LOAN_PAYMENT_FREQUENCY VARCHAR2 (30)
Loan payment frequency code. Lookup type is FREQUENCY. This column defaults the value for LNS_TERMS.LOAN_PAYMENT_FREQUENCY
AMORTIZATION_FREQUENCY VARCHAR2 (30)
Amortization Frequency
LOAN_SUBTYPE VARCHAR2 (30)
Loan subtype code. Lookup type is LOAN_SUBTYPE. This column defaults the value for LNS_LOAN_HEADERS_ALL.LOAN_SUBTYPE
COLLATERAL_PERCENT NUMBER

Loan to value ratio. This column defaults the value for LNS_LOAN_HEADERS_ALL.COLLATERAL_PERCENT
ALLOW_INTEREST_ONLY_FLAG VARCHAR2 (1)
Flag to indicate if interest only payments are allowed. This column defaults the value for LNS_RATE_SCHEDULES.INTEREST_ONLY_FLAG
REAMORTIZE_OVER_PAYMENT VARCHAR2 (1)
Flag to indicate if reamortize on overpayments. This column defaults the value for is LNS_TERMS.REAMORTIZE_OVER_PAYMENT
REAMORTIZE_UNDER_PAYMENT VARCHAR2 (30)
Reamortize on underpayment
ORG_ID NUMBER (15) Y Organization identifier (foreign key to HR_OPERATING_UNITS.ORGANIZATION_ID). This column defaults the value for LNS_LOAN_HEADERS_ALL.ORG_ID
CREATED_BY NUMBER (15) Y Standard who column
CREATION_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
OBJECT_VERSION_NUMBER NUMBER
Y This column is used for locking purposes
LEGAL_ENTITY_ID NUMBER (15)
Legal Entity ID
RATE_CHANGE_FREQUENCY VARCHAR2 (30)
Rate Change Frequency
BDGT_REQ_FOR_APPR_FLAG VARCHAR2 (1)
Budget Required for Loan Approval
LOAN_APPR_REQ_FLAG VARCHAR2 (1)
Loan Approval Required
APPR_REQ_FOR_CNCL_FLAG VARCHAR2 (1)
Approval Required for Cancellation
PERCENT_INCREASE NUMBER

Maximum Rate Percentage Increase
PERCENT_INCREASE_LIFE NUMBER

Maximum Rate Percentage Increase life
FIRST_PERCENT_INCREASE NUMBER

First Percentage Increase Max/Min
OPEN_PERCENT_INCREASE NUMBER

Percentage Increase Max/Min
OPEN_PERCENT_INCREASE_LIFE NUMBER

Open Percentage Increase Max/Min Life
OPEN_FIRST_PERCENT_INCREASE NUMBER

Open First Percentage Increase Max/Min
CREDIT_REVIEW_TYPE VARCHAR2 (30)
AR_CMGT_CHECK_LISTS.REVIEW_TYPE
GUARANTOR_REVIEW_TYPE VARCHAR2 (30)
AR_CMGT_CHECK_LISTS.REVIEW_TYPE
PARTY_TYPE VARCHAR2 (30)
This column will store either ORGANIZATION or PERSON and denotes whether its a Business or Consumer product.
INTEREST_CALCULATION_METHOD VARCHAR2 (30)
Loan interest calculation method code. Lookup type is INTEREST_CALCULATION_METHOD. This column defaults the value for LNS_TERMS.CALCULATION_METHODD
DAY_COUNT_METHOD VARCHAR2 (30)
Loan days formula code. Lookup type is DAY_COUNT_METHOD. This column defaults the value for LNS_TERMS.DAY_COUNT_METHOD
FORGIVENESS_FLAG VARCHAR2 (1)
Identifies whether the loan is enabled for forgiveness
FORGIVENESS_PERCENT NUMBER

This column defines the required forgiveness loanEMIPrincipal-to-value ratio for forgiveness enabled loan as a percentage of the loanEMI Principal
PAYMENT_CALC_METHOD VARCHAR2 (30)
Payment calculation method
PENAL_INT_RATE NUMBER

Penal Interest rate
PENAL_INT_GRACE_DAYS NUMBER

Penal interest grace days
CALC_ADD_INT_UNPAID_PRIN VARCHAR2 (1)
Calculate additional interest on unpaid principal
CALC_ADD_INT_UNPAID_INT VARCHAR2 (1)
Calculate additional interest on unpaid interest
PRINCIPAL_PAYMENT_FREQUENCY VARCHAR2 (30)
Principal payment frequency
REAMORTIZE_ON_FUNDING VARCHAR2 (30)
Reamortize On Funding
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE16 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE17 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE18 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE19 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE20 VARCHAR2 (150)
Descriptive flexfield segment
CUSTOM_SCHED_DATA CLOB (4000)
Custom Schedule Data
CUSTOM_CALC_METHOD VARCHAR2 (30)
Custom Calculation Method
CAPITALIZE_INT VARCHAR2 (1)
Capitalize Interest
BILL_ON_APPR_AMOUNT_FLAG VARCHAR2 (1)
Activate and Bill Based On Approved Amounts
CALC_EARLY_PAY_CR VARCHAR2 (1)
Issue Interest Credit On Early Payments
FLUCTUATE_EQ_PAY_AMOUNT VARCHAR2 (1)
Fluctuate Payment Due to Additional Interest

[top of page]

APPS.LNS_LOAN_PRODUCTS_ALL_VL references the following:

APPS
SYNONYM - LNS_LOAN_PRODUCTS_ALL
SYNONYM - LNS_LOAN_PRODUCTS_ALL_TL

APPS.LNS_LOAN_PRODUCTS_ALL_VL is not referenced by any database object

[top of page]

View: LNS_LOAN_PRODUCTS_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

Loan Products Translation View for table LNS_LOAN_PRODUCTS

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row id of the table
LOAN_PRODUCT_ID NUMBER (15) Y Identifies the Loan Product
LOAN_CLASS_CODE VARCHAR2 (30)
Loan class code. Lookup type is LOAN_CLASS
LOAN_TYPE_ID NUMBER (15) Y FK to LNS_LOAN_TYPES
LOAN_PRODUCT_NAME VARCHAR2 (80) Y Loan product name
LOAN_PRODUCT_DESC VARCHAR2 (250)
Description of the loan product
START_DATE_ACTIVE DATE

Start date of loan product
END_DATE_ACTIVE DATE

End date of loan product
STATUS VARCHAR2 (30)
Loan product setup status code. Lookup type is LNS_SETUP_STATUS
LOAN_TERM NUMBER

Loan term range from. This column defaults the value for LNS_LOAN_HEADERS_ALL.LOAN_TERM
LOAN_TERM_PERIOD VARCHAR2 (30)
Period of loan term range from. This column defaults the value for LNS_LOAN_HEADERS_ALL.LOAN_TERM_PERIOD
MAX_LOAN_TERM NUMBER

Loan term range to. This column defaults the value for LNS_LOAN_HEADERS_ALL.LOAN_TERM
MAX_LOAN_TERM_PERIOD VARCHAR2 (30)
Period of loan term range to. This column defaults the value for LNS_LOAN_HEADERS_ALL.LOAN_TERM_PERIOD
OPEN_LOAN_TERM NUMBER

Open Loan Term
OPEN_LOAN_TERM_PERIOD VARCHAR2 (30)
Open Loan Term Period
OPEN_MAX_LOAN_TERM NUMBER

Open Max Loan Term
OPEN_MAX_LOAN_TERM_PERIOD VARCHAR2 (30)
Open Max Loan Term Period
LOAN_CURRENCY VARCHAR2 (30)
Loan currency code (foreign key to FND_CURRENCIES.CURRENCY_CODE). This column defaults the value for LNS_LOAN_HEADERS_ALL.LOAN_CURRENCY
REQUESTED_AMOUNT NUMBER

Requested amount range from. This column defaults the value for LNS_LOAN_HEADERS_ALL.REQUESTED_AMOUNT
MAX_REQUESTED_AMOUNT NUMBER

Requested amount range to. This column defaults the value for LNS_LOAN_HEADERS_ALL.REQUESTED_AMOUNT
INDEX_RATE_ID NUMBER (15)
Interest rate index (foreign key to LNS_INT_RATE_HEADERS.INTEREST_RATE_ID). This column defaults the value for is LNS_TERMS.INDEX_RATE_ID
RATE_TYPE VARCHAR2 (30)
Loan rate type code. Lookup type is RATE_TYPE. This column defaults the value for LNS_TERMS.RATE_TYPE
SPREAD NUMBER

Spread percentage rate. This column defaults the value for LNS_RATE_SCHEDULES.SPREAD
OPEN_SPREAD NUMBER

Spread during open phase of loan product
FLOOR_RATE NUMBER

Floor percentage rate. This column defaults the value for LNS_TERMS.FLOOR_RATE
CEILING_RATE NUMBER

Ceiling percentage rate. This column defaults the value for LNS_TERMS.CEILING_RATE
OPEN_FLOOR_RATE NUMBER

Open Phase Floor Rate
OPEN_CEILING_RATE NUMBER

Open Phase Ceiling Rate
INTEREST_COMPOUNDING_FREQ VARCHAR2 (30)
Interest accrual frequency code. Lookup type is XXXXXXXX. This column defaults the value for LNS_TERMS.INTEREST_COMPOUNDING_FREQ
LOAN_PAYMENT_FREQUENCY VARCHAR2 (30)
Loan payment frequency code. Lookup type is FREQUENCY. This column defaults the value for LNS_TERMS.LOAN_PAYMENT_FREQUENCY
AMORTIZATION_FREQUENCY VARCHAR2 (30)
Amortization Frequency
LOAN_SUBTYPE VARCHAR2 (30)
Loan subtype code. Lookup type is LOAN_SUBTYPE. This column defaults the value for LNS_LOAN_HEADERS_ALL.LOAN_SUBTYPE
COLLATERAL_PERCENT NUMBER

Loan to value ratio. This column defaults the value for LNS_LOAN_HEADERS_ALL.COLLATERAL_PERCENT
ALLOW_INTEREST_ONLY_FLAG VARCHAR2 (1)
Flag to indicate if interest only payments are allowed. This column defaults the value for LNS_RATE_SCHEDULES.INTEREST_ONLY_FLAG
REAMORTIZE_OVER_PAYMENT VARCHAR2 (1)
Flag to indicate if reamortize on overpayments. This column defaults the value for is LNS_TERMS.REAMORTIZE_OVER_PAYMENT
REAMORTIZE_UNDER_PAYMENT VARCHAR2 (30)
Reamortize on underpayment
ORG_ID NUMBER (15) Y Organization identifier (foreign key to HR_OPERATING_UNITS.ORGANIZATION_ID). This column defaults the value for LNS_LOAN_HEADERS_ALL.ORG_ID
CREATED_BY NUMBER (15) Y Standard who column
CREATION_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
OBJECT_VERSION_NUMBER NUMBER
Y This column is used for locking purposes
LEGAL_ENTITY_ID NUMBER (15)
Legal Entity ID
RATE_CHANGE_FREQUENCY VARCHAR2 (30)
Rate Change Frequency
BDGT_REQ_FOR_APPR_FLAG VARCHAR2 (1)
Budget Required for Loan Approval
LOAN_APPR_REQ_FLAG VARCHAR2 (1)
Loan Approval Required
APPR_REQ_FOR_CNCL_FLAG VARCHAR2 (1)
Approval Required for Cancellation
PERCENT_INCREASE NUMBER

Maximum Rate Percentage Increase
PERCENT_INCREASE_LIFE NUMBER

Maximum Rate Percentage Increase life
FIRST_PERCENT_INCREASE NUMBER

First Percentage Increase Max/Min
OPEN_PERCENT_INCREASE NUMBER

Percentage Increase Max/Min
OPEN_PERCENT_INCREASE_LIFE NUMBER

Open Percentage Increase Max/Min Life
OPEN_FIRST_PERCENT_INCREASE NUMBER

Open First Percentage Increase Max/Min
CREDIT_REVIEW_TYPE VARCHAR2 (30)
AR_CMGT_CHECK_LISTS.REVIEW_TYPE
GUARANTOR_REVIEW_TYPE VARCHAR2 (30)
AR_CMGT_CHECK_LISTS.REVIEW_TYPE
PARTY_TYPE VARCHAR2 (30)
This column will store either ORGANIZATION or PERSON and denotes whether its a Business or Consumer product.
INTEREST_CALCULATION_METHOD VARCHAR2 (30)
Loan interest calculation method code. Lookup type is INTEREST_CALCULATION_METHOD. This column defaults the value for LNS_TERMS.CALCULATION_METHODD
DAY_COUNT_METHOD VARCHAR2 (30)
Loan days formula code. Lookup type is DAY_COUNT_METHOD. This column defaults the value for LNS_TERMS.DAY_COUNT_METHOD
FORGIVENESS_FLAG VARCHAR2 (1)
Identifies whether the loan is enabled for forgiveness
FORGIVENESS_PERCENT NUMBER

This column defines the required forgiveness loanEMIPrincipal-to-value ratio for forgiveness enabled loan as a percentage of the loanEMI Principal
PAYMENT_CALC_METHOD VARCHAR2 (30)
Payment calculation method
PENAL_INT_RATE NUMBER

Penal Interest rate
PENAL_INT_GRACE_DAYS NUMBER

Penal interest grace days
CALC_ADD_INT_UNPAID_PRIN VARCHAR2 (1)
Calculate additional interest on unpaid principal
CALC_ADD_INT_UNPAID_INT VARCHAR2 (1)
Calculate additional interest on unpaid interest
PRINCIPAL_PAYMENT_FREQUENCY VARCHAR2 (30)
Principal payment frequency
REAMORTIZE_ON_FUNDING VARCHAR2 (30)
Reamortize On Funding
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE16 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE17 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE18 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE19 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE20 VARCHAR2 (150)
Descriptive flexfield segment
CUSTOM_SCHED_DATA CLOB (4000)
Custom Schedule Data
CUSTOM_CALC_METHOD VARCHAR2 (30)
Custom Calculation Method
CAPITALIZE_INT VARCHAR2 (1)
Capitalize Interest
BILL_ON_APPR_AMOUNT_FLAG VARCHAR2 (1)
Activate and Bill Based On Approved Amounts
CALC_EARLY_PAY_CR VARCHAR2 (1)
Issue Interest Credit On Early Payments
FLUCTUATE_EQ_PAY_AMOUNT VARCHAR2 (1)
Fluctuate Payment Due to Additional Interest

[top of page]

APPS.LNS_LOAN_PRODUCTS_VL references the following:

APPS
SYNONYM - LNS_LOAN_PRODUCTS
SYNONYM - LNS_LOAN_PRODUCTS_ALL_TL

APPS.LNS_LOAN_PRODUCTS_VL is not referenced by any database object

[top of page]

View: LNS_LOAN_SUMMARY_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

View for Loan Summary Information

Columns
Name Datatype Length Mandatory Comments
LOAN_ID NUMBER (15) Y Loan identifier
ORG_ID NUMBER (15) Y Organization identifier (foreign key to HR_OPERATING_UNITS.ORGANIZATION_ID)
LOAN_NUMBER VARCHAR2 (60) Y Unique identification number for the loan
LOAN_STATUS VARCHAR2 (80) Y Loan Status
LOAN_CURRENCY_CODE VARCHAR2 (15) Y Loan Currency Code
LOAN_CURRENCY_MEANING VARCHAR2 (80) Y Loan Currency name
LOAN_TYPE VARCHAR2 (80)
Loan Type
LOAN_CLASS VARCHAR2 (80) Y Loan Class
LOAN_SUBTYPE VARCHAR2 (80) Y Loan Subtype
LOAN_PRODUCT VARCHAR2 (0)
Loan Product Name
LOAN_DESCRIPTION VARCHAR2 (250)
Description of the loan
LOAN_PURPOSE VARCHAR2 (80) Y Loan Purpose
REQUESTED_AMOUNT NUMBER
Y Requested Amount
FUNDED_AMOUNT NUMBER

Funded Amount
CREATION_DATE DATE
Y Creation Date
LOAN_APPLICATION_DATE DATE
Y Loan Application Date
LOAN_APPROVAL_DATE DATE

Loan Approval Date
LOAN_START_DATE DATE
Y Loan Start Date
LOAN_MATURITY_DATE DATE

Loan Maturity Date
LOAN_CLOSING_DATE DATE

Loan Closing Date
CURRENT_INTEREST_RATE NUMBER

Current Interest Rate Percentage
LOAN_TERM NUMBER
Y Loan Term - length of the loan
LOAN_TERM_PERIOD VARCHAR2 (80) Y Loan Term Period - Months, Years, etc.
LOAN_AMORTIZED_TERM NUMBER

Amortized Term - amortized length of the loan
LOAN_AMORTIZED_TERM_PERIOD VARCHAR2 (80) Y Amortized Term Period - Months, Years, etc.
REFERENCE_ID NUMBER (15)
When REFERENCE_TYPE='RECEIVABLE', this refers to the transaction identifier of the outstanding receivable that is used for creating this loan (foreign key to RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID).
REFERENCE_TYPE VARCHAR2 (30)
Reference type. If the values is 'RECEIVABLE', it indicates whether this loan is created from an outstanding receivable.
REFERENCE_NUMBER VARCHAR2 (60)
When REFERENCE_TYPE='RECEIVABLE', this refers to invoice number of the outstanding receivable that is used for creating this loan.
REFERENCE_DESCRIPTION VARCHAR2 (250)
User entered Reference/Cost Report FYE
REFERENCE_TYPE_ID NUMBER (15)
The transaction type identifier that will be used for billing the loan (foreign key to RA_CUST_TRX_TYPES.CUST_TRX_TYPE_ID).
PRIMARY_BORROWER_ID NUMBER (15)
Party identifier for the primary borrower of this loan (foreign key to HZ_PARTIES.PARTY_ID). This value is denormalized from LNS_PARTICIPANTS.HZ_PARTY_ID
CUST_ACCOUNT_ID NUMBER (15)
Customer account identifier for the primary borrower of this loan (foreign key to HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID). This value is denormalized from LNS_PARTICIPANTS.CUST_ACCOUNT_ID
BILL_TO_ACCT_SITE_ID NUMBER (15)
Customer account billing site identifier for the primary borrower of the loan (foreign key to HZ_CUST_ACCT_SITES_ALL.CUST_ACCT_SITE_ID). This value is denormalized from LNS_PARTICIPANTS.BILL_TO_ACCT_SITE_ID
GL_DATE DATE

GL Date
LOAN_AGENT_ID NUMBER

Identifier for the user who is assigned to this loan (foreign key to JTF_RS_RESOURCE_EXTNS.RESOURCE_ID)
LOAN_AGENT_FIRST_NAME VARCHAR2 (360)
Loan Assignee First Name
LOAN_AGENT_MIDDLE_NAME VARCHAR2 (360)
Loan Assignee Middle Name
LOAN_AGENT_LAST_NAME VARCHAR2 (360)
Loan Assignee Last Name
LOAN_AGENT_NAME VARCHAR2 (360)
Loan Assignee Name
LOAN_END_DATE DATE

Loan End Date
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE16 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE17 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE18 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE19 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE20 VARCHAR2 (150)
Descriptive flexfield segment
PRIMARY_CONTACT_REL_PARTY_ID NUMBER (15)
Primary Contact Relationship Party Identifier
PRIMARY_CONTACT_PERS_PARTY_ID NUMBER (15)
Primary Contact Person Party Identifier
PRIMARY_CONTACT_NAME VARCHAR2 (360)
Primary Contact Person Name
COLLATERAL_PERCENT NUMBER

Required Loan to Collateral Value ratio
CREDIT_REVIEW_FLAG VARCHAR2 (1)
Credit Review Flag - indicates if credit review required for the loan
EXCHANGE_RATE_TYPE VARCHAR2 (30)
Currency Exchange Rate Type
EXCHANGE_DATE DATE

Currency Exchange Date
EXCHANGE_RATE NUMBER

Currency Exchange Rate

[top of page]

APPS.LNS_LOAN_SUMMARY_V references the following:

APPS
VIEW - FND_CURRENCIES_VL
PACKAGE - FND_GLOBAL
SYNONYM - HZ_PARTIES
SYNONYM - JTF_RS_RESOURCE_EXTNS
PACKAGE - LNS_FIN_UTILS
SYNONYM - LNS_LOAN_HEADERS
SYNONYM - LNS_LOAN_TYPES
VIEW - LNS_LOOKUPS

APPS.LNS_LOAN_SUMMARY_V is not referenced by any database object

[top of page]

View: LNS_LOOKUPS

Comments
View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.

LNS_LOOKUPS is a view which has information about the Lookup values that you
define when setting up Oracle Loans.

Columns
Name Datatype Length Mandatory Comments
LOOKUP_TYPE VARCHAR2 (30) Y Lookup Type
LOOKUP_CODE VARCHAR2 (30) Y Lookup Code
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER (15) Y Standard Who Column
MEANING VARCHAR2 (80) Y Meaning of the lookup
ENABLED_FLAG VARCHAR2 (1) Y Indicates whether the lookup code is currently used
START_DATE_ACTIVE DATE

Date this record becomes active, if limited
END_DATE_ACTIVE DATE

Date this record becomes inactive, if limited
DESCRIPTION VARCHAR2 (240)
Description of the lookup
TAG VARCHAR2 (150)
Optional additional category for lookup values
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Attribute category
ATTRIBUTE1 VARCHAR2 (150)
Attribute1
ATTRIBUTE2 VARCHAR2 (150)
Attribute2
ATTRIBUTE3 VARCHAR2 (150)
Attribute3
ATTRIBUTE4 VARCHAR2 (150)
Attribute4
ATTRIBUTE5 VARCHAR2 (150)
Attribute5
ATTRIBUTE6 VARCHAR2 (150)
Attribute6
ATTRIBUTE7 VARCHAR2 (150)
Attribute7
ATTRIBUTE8 VARCHAR2 (150)
Attribute8
ATTRIBUTE9 VARCHAR2 (150)
Attribute9
ATTRIBUTE10 VARCHAR2 (150)
Attribute10
ATTRIBUTE11 VARCHAR2 (150)
Attribute11
ATTRIBUTE12 VARCHAR2 (150)
Attribute12
ATTRIBUTE13 VARCHAR2 (150)
Attribute13
ATTRIBUTE14 VARCHAR2 (150)
Attribute14
ATTRIBUTE15 VARCHAR2 (150)
Attribute15

[top of page]

APPS.LNS_LOOKUPS references the following:

APPS
PACKAGE - FND_GLOBAL
SYNONYM - FND_LOOKUP_VALUES
APPS.LNS_LOOKUPS is referenced by following:

APPS
VIEW - LNS_AMORTIZATION_SCHEDULES_V
VIEW - LNS_AM_SCHEDS_DTL_V
VIEW - LNS_AM_SCHEDS_V
VIEW - LNS_LOAN_PARTICIPANTS_V
VIEW - LNS_LOAN_SUMMARY_V
VIEW - LNS_RECEIVABLE_ACTIVITIES_V
VIEW - LNS_REC_ACT_ADJ_V
VIEW - LNS_REC_ACT_CASH_CM_V

[top of page]

View: LNS_OPEN_RECEIVABLES_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

Open Receivables View

Columns
Name Datatype Length Mandatory Comments
PAYMENT_SCHEDULE_ID NUMBER (15) Y Identifies the payment schedule
CUSTOMER_TRX_ID NUMBER (15)
Identifies the item itself (foreign key to RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID).
TRX_NUMBER VARCHAR2 (30)
The transaction number of the item
AMOUNT_DUE_ORIGINAL NUMBER
Y The original amount due
AMOUNT_DUE_REMAINING NUMBER
Y The current amount due remaining
DUE_DATE DATE
Y Due date of this installment
CUST_TRX_TYPE_ID NUMBER (15)
Identifies the transaction type of the item
CLASS VARCHAR2 (20) Y Lookup code for the class of the payment schedule
TRX_DATE DATE

The transaction date of the item
GL_DATE DATE
Y General Ledger date
NUMBER_OF_DUE_DATES NUMBER (15) Y The total number of installments for this invoice
TERM_ID NUMBER (15)
Identifies the terms used in calculating the payment schedule
TERMS_SEQUENCE_NUMBER NUMBER (15)
The sequence number given to each installment for multiple payment terms
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATED_BY NUMBER (15) Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
PARTY_ID NUMBER (15) Y Party identifier (foreign key to HZ_PARTIES.PARTY_ID).
INVOICE_CURRENCY_CODE VARCHAR2 (15) Y Lookup code for the currency of the invoice (foreign key to FND_CURRENCIES.CURRENCY_CODE).
ORG_ID NUMBER (15)
Organization identifier (foreign key to HR_OPERATING_UNITS.ORGANIZATION_ID).

[top of page]

APPS.LNS_OPEN_RECEIVABLES_V references the following:

APPS
SYNONYM - AR_PAYMENT_SCHEDULES_ALL
SYNONYM - HZ_CUST_ACCOUNTS

APPS.LNS_OPEN_RECEIVABLES_V is not referenced by any database object

[top of page]

View: LNS_PAYMENTS_SUMMARY_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
LOAN_ID NUMBER (15) Y Loan identifier
NEXT_PAYMENT_AMORTIZATION_ID NUMBER

Amortization schedule identifier for next loan payment
NEXT_PAYMENT_NUMBER NUMBER

Payment number of next loan payment
NEXT_PAYMENT_DUE_DATE DATE

Due date of next loan payment
NEXT_PAYMENT_PRINCIPAL_DUE NUMBER

Principal amount due for next loan payment
NEXT_PAYMENT_INTEREST_DUE NUMBER

Interest amount due for next loan payment
NEXT_PAYMENT_FEE_DUE NUMBER

Fee amount due for next loan payment
NEXT_PAYMENT_TOTAL_DUE NUMBER

Total amount due for next loan payment
PRINCIPAL_PAID_TODATE NUMBER

Total loan principal paid excluding manual bills
INTEREST_PAID_TODATE NUMBER

Total loan interest paid
FEE_PAID_TODATE NUMBER

Total loan fees paid
TOTAL_PRIN_PAID_TODATE NUMBER

Total loan principal paid to date
TOTAL_PRINCIPAL_BALANCE NUMBER

Total remaining unpaid loan amount
PRINCIPAL_BALANCE NUMBER

Total remaining unpaid loan amount excluding manual bills
FUNDED_AMOUNT NUMBER

Initial loan funded amount
PRINCIPAL_PAID_YTD NUMBER

Total principal paid year to date
INTEREST_PAID_YTD NUMBER

Total interest paid year to date
FEE_PAID_YTD NUMBER

PRINCIPAL_PAID_LAST_YEAR NUMBER

Total principal paid last year
INTEREST_PAID_LAST_YEAR NUMBER

Total interest paid last year
FEE_PAID_LAST_YEAR NUMBER

PRINCIPAL_OVERDUE NUMBER

Total principal amount overdue
INTEREST_OVERDUE NUMBER

Total interest amount overdue
FEE_OVERDUE NUMBER

Total fee amount overdue
TOTAL_OVERDUE NUMBER

Total amount overdue
NUMBER_OVERDUE_BILLS NUMBER

Number of overdue installments
LAST_OVERDUE_DATE DATE

Date of last missed payment
OLDEST_OVERDUE_DATE DATE

Date of oldest missed payment
LAST_PAYMENT_AMOUNT NUMBER

Last loan payment amount
LAST_PAYMENT_DATE DATE

Last loan payment date
ORG_ID NUMBER (15) Y
LEGAL_ENTITY_ID NUMBER (15)
CURRENT_PHASE VARCHAR2 (30)

[top of page]

APPS.LNS_PAYMENTS_SUMMARY_V references the following:

APPS
SYNONYM - AR_PAYMENT_SCHEDULES_ALL
SYNONYM - AR_RECEIVABLE_APPLICATIONS_ALL
SYNONYM - LNS_AMORTIZATION_SCHEDS
SYNONYM - LNS_LOAN_HEADERS_ALL

APPS.LNS_PAYMENTS_SUMMARY_V is not referenced by any database object

[top of page]

View: LNS_PAY_SUM_OVERDUE_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

This view contains payment overdue information for every loan in the system

Columns
Name Datatype Length Mandatory Comments
LOAN_ID NUMBER (15) Y Identifies the Loan
PRINCIPAL_OVERDUE NUMBER

Principal Overdue Amount
INTEREST_OVERDUE NUMBER

Interest Overdue Amount
FEE_OVERDUE NUMBER

Fee Overdue Amount
TOTAL_OVERDUE NUMBER

Total Overdue Amount
NUMBER_OVERDUE_BILLS NUMBER

Number Overdue Bills
LAST_OVERDUE_DATE DATE

Latest Overdue Date
OLDEST_OVERDUE_DATE DATE

Earliest Overdue Date
LAST_PAYMENT_AMOUNT NUMBER

Last Payment Amount
LAST_PAYMENT_DATE DATE

Last Payment Date

[top of page]

APPS.LNS_PAY_SUM_OVERDUE_V references the following:

APPS
SYNONYM - AR_PAYMENT_SCHEDULES_ALL
SYNONYM - AR_RECEIVABLE_APPLICATIONS_ALL
SYNONYM - LNS_AMORTIZATION_SCHEDS
SYNONYM - LNS_LOAN_HEADERS_ALL

APPS.LNS_PAY_SUM_OVERDUE_V is not referenced by any database object

[top of page]

View: LNS_PAY_SUM_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

This view contains payment summary information for every loan in the system

Columns
Name Datatype Length Mandatory Comments
LOAN_ID NUMBER (15) Y Identifies the Loan
NEXT_PAYMENT_AMORTIZATION_ID NUMBER

Identifies the Next Due Amortization
NEXT_PAYMENT_NUMBER NUMBER

Next Due Payment Number
NEXT_PAYMENT_DUE_DATE DATE

Next Due Date
NEXT_PAYMENT_PRINCIPAL_DUE NUMBER

Next Due Principal Amount
NEXT_PAYMENT_INTEREST_DUE NUMBER

Next Due Interest Amount
NEXT_PAYMENT_FEE_DUE NUMBER

Next Due Fee Amount
NEXT_PAYMENT_TOTAL_DUE NUMBER

Next Due Total Amount
PRINCIPAL_PAID_TODATE NUMBER

Principal Paid To Date
INTEREST_PAID_TODATE NUMBER

Interest Paid To Date
FEE_PAID_TODATE NUMBER

Fee Paid To Date
TOTAL_PRIN_PAID_TODATE NUMBER

Total Principal Paid To Date
TOTAL_PRINCIPAL_BALANCE NUMBER

Total Principal Balance
PRINCIPAL_BALANCE NUMBER

Principal Balance
FUNDED_AMOUNT NUMBER

Loan Funded Amount
CURRENT_PHASE VARCHAR2 (30)
Current Loan Phase

[top of page]

APPS.LNS_PAY_SUM_V references the following:

APPS
SYNONYM - AR_PAYMENT_SCHEDULES_ALL
SYNONYM - LNS_AMORTIZATION_SCHEDS
SYNONYM - LNS_LOAN_HEADERS_ALL

APPS.LNS_PAY_SUM_V is not referenced by any database object

[top of page]

View: LNS_PAY_SUM_YEARLY_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

This view contains year-to-date and last year payment summary information for every loan in the system

Columns
Name Datatype Length Mandatory Comments
LOAN_ID NUMBER (15) Y Identifies the Loan
PRINCIPAL_PAID_YTD NUMBER

Principal Paid YTD
INTEREST_PAID_YTD NUMBER

Interest Paid YTD
FEE_PAID_YTD NUMBER

Fee Paid YTD
PRINCIPAL_PAID_LAST_YEAR NUMBER

Principal Paid Last Year
INTEREST_PAID_LAST_YEAR NUMBER

Interest Paid Last Year
FEE_PAID_LAST_YEAR NUMBER

Fee Paid Last Year

[top of page]

APPS.LNS_PAY_SUM_YEARLY_V references the following:

APPS
SYNONYM - AR_ADJUSTMENTS_ALL
SYNONYM - AR_RECEIVABLE_APPLICATIONS_ALL
SYNONYM - LNS_AMORTIZATION_SCHEDS
SYNONYM - LNS_LOAN_HEADERS_ALL

APPS.LNS_PAY_SUM_YEARLY_V is not referenced by any database object

[top of page]

View: LNS_RECEIVABLE_ACTIVITIES_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

This view contains payment activities for all installments of all loans in the system

Columns
Name Datatype Length Mandatory Comments
LOAN_ID NUMBER (15)
Activity for loan identifier
LOAN_AMORTIZATION_ID NUMBER (15)
Activity for amortization schedule identifier
PAYMENT_NUMBER NUMBER

Activity for payment number
DUE_DATE DATE

Installment Due Date
BILLED_CUSTOMER_TRX_ID NUMBER (15)
Billed customer transaction identifier from Receivables
BILLED_PAYMENT_SCHEDULE_ID NUMBER (15)
Billed payment schedule identifier from Receivables
BILLED_CUSTOMER_TRX_LINE_ID NUMBER (15)
Billed CUSTOMER_TRX_LINE_ID from Receivables
LINE_TYPE_CODE VARCHAR2 (30)
Billed line type, such as PRIN, INT, FEE
LINE_TYPE_DESC VARCHAR2 (80)
Meaning of line type
LINE_DESC VARCHAR2 (240)
Billed line description
BILLED_TRX_NUMBER VARCHAR2 (20)
Billed transaction number from Receivables
ACTIVITY_CODE VARCHAR2 (30)
Payment activity code, such as PMT, CM, ADJ
ACTIVITY_DESC VARCHAR2 (163)
Meaning of activity code
ACTIVITY_AMOUNT NUMBER

Activity amount in original transaction currency
ACTIVITY_NUMBER VARCHAR2 (30)
Activity number from Receivables
ACTIVITY_DATE DATE

Activity date
BALANCE_BY_ACTIVITY_DATE NUMBER

Principal balance by activity date
RECEIVABLES_APPLICATION_ID NUMBER

Receivables identifier for payments and credit memos
CASH_RECEIPT_ID NUMBER

Cash receipt identifier for payments and credit memos
ADJUSTMENT_ID NUMBER

Adjustments identifier
CREATION_DATE DATE

Activity creation date
CREATED_BY NUMBER (15)
Activity created by user
LAST_UPDATE_LOGIN NUMBER (15)
Activity last updated by this login
LAST_UPDATE_DATE DATE

Activity last update date
LAST_UPDATED_BY NUMBER (15)
Activity last updated by user
TRX_CURRENCY VARCHAR2 (15)
Original transaction currency
RECEIPT_AMT_APPLIED_FROM NUMBER

Payment amount in original receipt currency. Set for payments only.
RECEIPT_CURRENCY VARCHAR2 (15)
Original receipt currency. Set for payments only.
TRX_TO_RECEIPT_RATE NUMBER

Transaction to receipt exchange rate. Set for payments only.
ORG_ID NUMBER (15)
Identifies the Org
LEGAL_ENTITY_ID NUMBER (15)
Identifies Legal Entity
PHASE VARCHAR2 (30)
Installment Phase

[top of page]

APPS.LNS_RECEIVABLE_ACTIVITIES_V references the following:

APPS
SYNONYM - AR_ADJUSTMENTS_ALL
VIEW - AR_LOOKUPS
SYNONYM - AR_PAYMENT_SCHEDULES_ALL
SYNONYM - AR_RECEIVABLES_TRX_ALL
SYNONYM - AR_RECEIVABLE_APPLICATIONS_ALL
PACKAGE - FND_GLOBAL
SYNONYM - LNS_AMORTIZATION_LINES
SYNONYM - LNS_AMORTIZATION_SCHEDS
SYNONYM - LNS_LOAN_HEADERS_ALL
VIEW - LNS_LOOKUPS
SYNONYM - RA_CUSTOMER_TRX_ALL
SYNONYM - RA_CUSTOMER_TRX_LINES_ALL

APPS.LNS_RECEIVABLE_ACTIVITIES_V is not referenced by any database object

[top of page]

View: LNS_REC_ACT_ADJ_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

This view contains adjustment activities for all installments of all loans in the system

Columns
Name Datatype Length Mandatory Comments
LOAN_ID NUMBER (15) Y Identifies the Loan
LOAN_AMORTIZATION_ID NUMBER (15) Y Identifies the Amortization Schedule
PAYMENT_NUMBER NUMBER

Payment Number
DUE_DATE DATE

Due Date
BILLED_CUSTOMER_TRX_ID NUMBER (15) Y Identifies the Transaction
BILLED_PAYMENT_SCHEDULE_ID NUMBER (15) Y Identifies the Payment Schedule
LINE_TYPE_CODE VARCHAR2 (30)
Bill Type: PRIN, INT, FEE
LINE_TYPE_DESC VARCHAR2 (80) Y Bill Type Description: Principal, Interest, Fee
LINE_DESC VARCHAR2 (240)
Description of the Line or Entire Transaction
BILLED_TRX_NUMBER VARCHAR2 (20) Y Transaction Number
ACTIVITY_CODE VARCHAR2 (30) Y Receivable Activity Code
ACTIVITY_DESC VARCHAR2 (133)
Receivable Activity Description
ACTIVITY_AMOUNT NUMBER
Y Receivable Activity Amount
ACTIVITY_NUMBER VARCHAR2 (20) Y Receivable Activity Number
ACTIVITY_DATE DATE

Receivable Activity Date
RECEIVABLES_APPLICATION_ID NUMBER

Identifies the Receivable Application
CASH_RECEIPT_ID NUMBER

Identifies the Cash Receipt
ADJUSTMENT_ID NUMBER (15) Y Identifies the Adjustment
CREATION_DATE DATE
Y Creation Date
CREATED_BY NUMBER (15) Y Created By
LAST_UPDATE_LOGIN NUMBER (15)
Last Update Login
LAST_UPDATE_DATE DATE
Y Last Update Date
LAST_UPDATED_BY NUMBER (15) Y Last Updated By
TRX_CURRENCY VARCHAR2 (15) Y Transaction Currency
RECEIPT_AMT_APPLIED_FROM NUMBER

Amount Applied In Receipt Currency
RECEIPT_CURRENCY VARCHAR2 (0)
Receipt Currency
TRX_TO_RECEIPT_RATE NUMBER

Transaction to Receipt Rate
ORG_ID NUMBER (15) Y Identifies the Org
LEGAL_ENTITY_ID NUMBER (15)
Identifies the Legal Entity
PHASE VARCHAR2 (30)
Phase

[top of page]

APPS.LNS_REC_ACT_ADJ_V references the following:

APPS
SYNONYM - AR_ADJUSTMENTS_ALL
VIEW - AR_LOOKUPS
SYNONYM - AR_PAYMENT_SCHEDULES_ALL
SYNONYM - AR_RECEIVABLES_TRX_ALL
PACKAGE - FND_GLOBAL
SYNONYM - LNS_AMORTIZATION_LINES
SYNONYM - LNS_AMORTIZATION_SCHEDS
SYNONYM - LNS_LOAN_HEADERS_ALL
VIEW - LNS_LOOKUPS
SYNONYM - RA_CUSTOMER_TRX_ALL
SYNONYM - RA_CUSTOMER_TRX_LINES_ALL

APPS.LNS_REC_ACT_ADJ_V is not referenced by any database object

[top of page]

View: LNS_REC_ACT_CASH_CM_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

This view contains cash and credit memo payment activities for all installments of all loans in the system

Columns
Name Datatype Length Mandatory Comments
LOAN_ID NUMBER (15) Y Identifies the Loan
LOAN_AMORTIZATION_ID NUMBER (15) Y Identifies the Amortization Schedule
PAYMENT_NUMBER NUMBER

Payment Number
DUE_DATE DATE

Due Date
BILLED_CUSTOMER_TRX_ID NUMBER (15)
Identifies the Transaction
BILLED_PAYMENT_SCHEDULE_ID NUMBER (15) Y Identifies the Payment Schedule
LINE_TYPE_CODE VARCHAR2 (30)
Bill Type: PRIN, INT, FEE
LINE_TYPE_DESC VARCHAR2 (80) Y Bill Type Description: Principal, Interest, Fee
LINE_DESC VARCHAR2 (240)
Description of the Line or Entire Transaction
BILLED_TRX_NUMBER VARCHAR2 (30)
Transaction Number
ACTIVITY_CODE VARCHAR2 (30) Y Receivable Activity Code
ACTIVITY_DESC VARCHAR2 (163)
Receivable Activity Description
ACTIVITY_AMOUNT NUMBER

Receivable Activity Amount
ACTIVITY_NUMBER VARCHAR2 (30)
Receivable Activity Number
ACTIVITY_DATE DATE
Y Receivable Activity Date
RECEIVABLES_APPLICATION_ID NUMBER (15) Y Identifies the Receivable Application
CASH_RECEIPT_ID NUMBER (15)
Identifies the Cash Receipt
ADJUSTMENT_ID NUMBER

Identifies the Adjustment
CREATION_DATE DATE
Y Creation Date
CREATED_BY NUMBER (15) Y Created By
LAST_UPDATE_LOGIN NUMBER (15)
Last Update Login
LAST_UPDATE_DATE DATE
Y Last Update Date
LAST_UPDATED_BY NUMBER (15) Y Last Updated By
TRX_CURRENCY VARCHAR2 (15) Y Transaction Currency
RECEIPT_AMT_APPLIED_FROM NUMBER

Amount Applied In Receipt Currency
RECEIPT_CURRENCY VARCHAR2 (15)
Receipt Currency
TRX_TO_RECEIPT_RATE NUMBER

Transaction to Receipt Rate
ORG_ID NUMBER (15) Y Identifies the Org
LEGAL_ENTITY_ID NUMBER (15)
Identifies the Legal Entity
PHASE VARCHAR2 (30)
Phase

[top of page]

APPS.LNS_REC_ACT_CASH_CM_V references the following:

APPS
VIEW - AR_LOOKUPS
SYNONYM - AR_PAYMENT_SCHEDULES_ALL
SYNONYM - AR_RECEIVABLE_APPLICATIONS_ALL
PACKAGE - FND_GLOBAL
SYNONYM - LNS_AMORTIZATION_LINES
SYNONYM - LNS_AMORTIZATION_SCHEDS
SYNONYM - LNS_LOAN_HEADERS_ALL
VIEW - LNS_LOOKUPS
SYNONYM - RA_CUSTOMER_TRX_ALL
SYNONYM - RA_CUSTOMER_TRX_LINES_ALL

APPS.LNS_REC_ACT_CASH_CM_V is not referenced by any database object

[top of page]

View: LNS_SL_GL_V2

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER

Application ID
JE_CATEGORY VARCHAR2 (0)
Journal entry category
USER_JE_CATEGORY VARCHAR2 (0)
User journal entry category
SET_OF_BOOKS_ID NUMBER (15) Y GL Set of books ID
ORG_ID VARCHAR2 (0)
Organization ID
TRX_CLASS VARCHAR2 (0)
Transaction or Loan class
TRX_CLASS_NAME VARCHAR2 (0)
Transaction or Loan class meaning
TRX_TYPE_NAME VARCHAR2 (0)
Loan Type
TRX_NUMBER_DISPLAYED VARCHAR2 (0)
Loan Number
TRX_NUMBER_C VARCHAR2 (0)
Loan number
TRX_DATE VARCHAR2 (0)
Transaction date
COMMENTS VARCHAR2 (0)
DOC_SEQUENCE_ID VARCHAR2 (0)
Loan ID
DOC_SEQUENCE_VALUE VARCHAR2 (60) Y Loan Number
TRX_HDR_ID NUMBER (15) Y Loan ID
ACCT_LINE_TYPE VARCHAR2 (0)
Account Name
ACCT_LINE_TYPE_NAME VARCHAR2 (4000)
Account name meaning
CODE_COMBINATION_ID NUMBER (15) Y GL Code combination ID
CURRENCY_CODE VARCHAR2 (15) Y Currency
ENTERED_DR NUMBER

Entered debit
ENTERED_CR NUMBER

Entered credit
ACCOUNTED_DR NUMBER

ACCOUNTED_CR NUMBER

CURRENCY_CONVERSION_DATE DATE

Currency conversion date
CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
Currency conversion type
CURRENCY_CONVERSION_RATE NUMBER

Currency conversion rate
THIRD_PARTY_NAME VARCHAR2 (0)
null
THIRD_PARTY_NUMBER VARCHAR2 (0)
null
THIRD_PARTY_SUB_ID VARCHAR2 (0)
null
ACCOUNTING_DATE VARCHAR2 (0)
GL Accounting date
TRX_LINE_NUMBER VARCHAR2 (0)
Transaction line number
TRX_LINE_TYPE VARCHAR2 (0)
Transaction line type
TRX_LINE_TYPE_NAME VARCHAR2 (0)
Transaction line type name
REQUEST_ID VARCHAR2 (0)
Request ID
PROGRAM_APPLICATION_ID VARCHAR2 (0)
Program application ID
PROGRAM_ID VARCHAR2 (0)
Program ID
PROGRAM_UPDATE_DATE VARCHAR2 (0)
Program update date
ACCOUNTING_EVENT_TYPE VARCHAR2 (4000)
Account Code Combination

[top of page]

APPS.LNS_SL_GL_V2 references the following:

APPS
PACKAGE - FND_FLEX_EXT
SYNONYM - GL_CODE_COMBINATIONS
SYNONYM - GL_IMPORT_REFERENCES
SYNONYM - GL_JE_HEADERS
SYNONYM - GL_JE_LINES
SYNONYM - LNS_DISB_HEADERS
SYNONYM - LNS_DISTRIBUTIONS
SYNONYM - LNS_LOAN_HEADERS_ALL
PACKAGE - LNS_UTILITY_PUB
SYNONYM - XLA_AE_HEADERS
SYNONYM - XLA_AE_LINES
SYNONYM - XLA_EVENTS
SYNONYM - XLA_TRANSACTION_ENTITIES

APPS.LNS_SL_GL_V2 is not referenced by any database object

[top of page]
Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract