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.
Description: | Amortization Lines reprensents the details of any give Amortization represented on the Amortization Schedules 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 |
Amortization Lines reprensents the details of any give Amortization represented on the Amortization Schedules table
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 |
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 |
LNS.LNS_AMORTIZATION_LINES does not reference any database object
LNS.LNS_AMORTIZATION_LINES is referenced by following:
Description: | Amortizations Table - Records installments due for a loan as billing generates them. Also stores any reversal and re-amortization information |
---|
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 | % |
Amortizations Table - Records installments due for a loan as billing generates them. Also stores any reversal and re-amortization information
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 |
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 |
LNS.LNS_AMORTIZATION_SCHEDS does not reference any database object
LNS.LNS_AMORTIZATION_SCHEDS is referenced by following:
Description: | Loans Approval Actions Table |
---|
Foreign Key Column | Foreign Table |
---|---|
LNS_APPROVAL_ACTIONS.LOAN_ID | % |
LNS_APPROVAL_ACTIONS logs all the actions taken on the loan throughout the approval process.
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 |
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 |
LNS.LNS_APPROVAL_ACTIONS does not reference any database object
LNS.LNS_APPROVAL_ACTIONS is referenced by following:
Description: | LNS_ASSETS is used to store the assets of a loan participant. |
---|
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 Key Column | Foreign Table |
---|---|
LNS_ASSET_ASSIGNMENTS.ASSET_ID | LNS_ASSETS |
LNS_ASSETS is used to store the assets of a loan participant.
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 |
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 |
LNS.LNS_ASSETS does not reference any database object
LNS.LNS_ASSETS is referenced by following:
Description: | LNS_ASSET_ASSIGNMENTS stores the assignment of assets to a loan as collateral. |
---|
Foreign Key Column | Foreign Table |
---|---|
LNS_ASSET_ASSIGNMENTS.ASSET_ID | LNS_ASSETS |
LNS_ASSET_ASSIGNMENTS stores the assignment of assets to a loan as collateral
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 |
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 |
LNS.LNS_ASSET_ASSIGNMENTS does not reference any database object
LNS.LNS_ASSET_ASSIGNMENTS is referenced by following:
Description: | Borrower Summary Table |
---|
Borrower Summary Table
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 |
LNS.LNS_BORROWER_SUMMARIES does not reference any database object
LNS.LNS_BORROWER_SUMMARIES is referenced by following:
Description: | Loan Conditions Table |
---|
Foreign Key Column | Foreign Table |
---|---|
LNS_COND_ASSIGNMENTS.CONDITION_ID | LNS_CONDITIONS |
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.
Index | Type | Tablespace | Column |
---|---|---|---|
LNS_CONDITIONS_U1 | UNIQUE | APPS_TS_SEED | CONDITION_ID |
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 |
LNS.LNS_CONDITIONS does not reference any database object
LNS.LNS_CONDITIONS is referenced by following:
Description: | Loan Condition Assignment 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 |
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.
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 |
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 |
LNS.LNS_COND_ASSIGNMENTS does not reference any database object
LNS.LNS_COND_ASSIGNMENTS is referenced by following:
Description: | Loans Custom Schedule Table |
---|
Foreign Key Column | Foreign Table |
---|---|
LNS_CUSTOM_PAYMNT_SCHEDS.LOAN_ID | % |
Loans Custom Schedule Table
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 |
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. |
LNS.LNS_CUSTOM_PAYMNT_SCHEDS does not reference any database object
LNS.LNS_CUSTOM_PAYMNT_SCHEDS is referenced by following:
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 Key Column | Foreign Table |
---|---|
LNS_DEFAULT_DISTRIBS_ALL.CODE_COMBINATION_ID | GL_CODE_COMBINATIONS |
LNS_DEFAULT_DISTRIBS_ALL.ORG_ID | HR_ALL_ORGANIZATION_UNITS |
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.
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 |
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 |
LNS.LNS_DEFAULT_DISTRIBS_ALL does not reference any database object
LNS.LNS_DEFAULT_DISTRIBS_ALL is referenced by following:
Description: | This table stores header level disbursement information |
---|
Disbursement Headers Table
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 |
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 |
LNS.LNS_DISB_HEADERS does not reference any database object
LNS.LNS_DISB_HEADERS is referenced by following:
Description: | This table stores disbursement changes |
---|
Disbursement History
Index | Type | Tablespace | Column |
---|---|---|---|
LNS_DISB_HISTORIES_H_U1 | UNIQUE | APPS_TS_TX_IDX | DISB_HISTORY_ID |
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 |
LNS.LNS_DISB_HISTORIES_H does not reference any database object
LNS.LNS_DISB_HISTORIES_H is referenced by following:
Description: | Stores line level disbursement information |
---|
Disbursement Lines
Index | Type | Tablespace | Column |
---|---|---|---|
LNS_DISB_LINES_U1 | UNIQUE | APPS_TS_TX_IDX | DISB_LINE_ID |
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 |
LNS.LNS_DISB_LINES does not reference any database object
LNS.LNS_DISB_LINES is referenced by following:
Description: | Loans Distributions Table - stores actual accounting distributions for a give loan_id |
---|
Foreign Key Column | Foreign Table |
---|---|
LNS_DISTRIBUTIONS.LOAN_ID | % |
Loans Distributions Table - stores actual accounting distributions for a give loan_id
Index | Type | Tablespace | Column |
---|---|---|---|
LNS_DISTRIBUTIONS_U1 | UNIQUE | APPS_TS_TX_IDX | DISTRIBUTION_ID |
LNS_DISTRIBUTIONS_N1 | NONUNIQUE | APPS_TS_TX_IDX | LOAN_ID |
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 |
LNS.LNS_DISTRIBUTIONS does not reference any database object
LNS.LNS_DISTRIBUTIONS is referenced by following:
Description: | This table stores actionable events for a loan class |
---|
Foreign Key Column | Foreign Table |
---|---|
LNS_EVENT_ACTIONS.EVENT_ID | LNS_EVENTS |
Actionable Events
Index | Type | Tablespace | Column |
---|---|---|---|
LNS_EVENTS_U1 | UNIQUE | APPS_TS_SEED | EVENT_ID |
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 |
LNS.LNS_EVENTS does not reference any database object
LNS.LNS_EVENTS is referenced by following:
Description: | This table stores actionable events for a Loan type and loan class |
---|
Foreign Key Column | Foreign Table |
---|---|
LNS_EVENT_ACTIONS.EVENT_ID | LNS_EVENTS |
Foreign Key Column | Foreign Table |
---|---|
LNS_EVT_ACTION_HISTORY_H.EVENT_ACTION_ID | LNS_EVENT_ACTIONS |
This table stores actionable events for a Loan type and loan class
Index | Type | Tablespace | Column |
---|---|---|---|
LNS_EVENT_ACTIONS_U1 | UNIQUE | APPS_TS_SEED | EVENT_ACTION_ID |
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 |
LNS.LNS_EVENT_ACTIONS does not reference any database object
LNS.LNS_EVENT_ACTIONS is referenced by following:
Description: | This table stores the information about workflow actions performed for a Loan event |
---|
Foreign Key Column | Foreign Table |
---|---|
LNS_EVT_ACTION_HISTORY_H.EVENT_ACTION_ID | LNS_EVENT_ACTIONS |
LNS_EVT_ACTION_HISTORY_H.LOAN_ID | % |
This table stores the information about workflow actions performed for a Loan event
Index | Type | Tablespace | Column |
---|---|---|---|
LNS_EVT_ACTION_HISTORY_U1 | UNIQUE | APPS_TS_TX_IDX | EVENT_ACTION_HISTORY_ID |
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 |
LNS.LNS_EVT_ACTION_HISTORY_H does not reference any database object
LNS.LNS_EVT_ACTION_HISTORY_H is referenced by following:
Description: | Loan Fees Setup Table |
---|
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.
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 |
LNS.LNS_FEES_ALL does not reference any database object
LNS.LNS_FEES_ALL is referenced by following:
Description: | Loan Fees Assignment Table |
---|
Foreign Key Column | Foreign Table |
---|---|
LNS_FEE_ASSIGNMENTS.LOAN_ID | % |
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'.
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 |
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 |
LNS.LNS_FEE_ASSIGNMENTS does not reference any database object
LNS.LNS_FEE_ASSIGNMENTS is referenced by following:
Description: | Loans Fees Schedules Table |
---|
Fees calculated and scheduled to be billed
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 |
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 |
LNS.LNS_FEE_SCHEDULES does not reference any database object
LNS.LNS_FEE_SCHEDULES is referenced by following:
Description: | Interest Rate Headers table |
---|
Interest Rate Headers table
Index | Type | Tablespace | Column |
---|---|---|---|
LNS_INT_RATE_HEADERS_U1 | UNIQUE | APPS_TS_SEED | INTEREST_RATE_ID |
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 |
LNS.LNS_INT_RATE_HEADERS does not reference any database object
LNS.LNS_INT_RATE_HEADERS is referenced by following:
Description: | Interest Rate Lines Table |
---|
Interest Rate Lines Table
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 |
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 |
LNS.LNS_INT_RATE_LINES does not reference any database object
LNS.LNS_INT_RATE_LINES is referenced by following:
Description: |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ERROR_NUMBER | NUMBER | (15) | Y | |
LINE_NUMBER | NUMBER | (15) | ||
MESSAGE_NAME | VARCHAR2 | (30) | Y | |
MESSAGE_TEXT | VARCHAR2 | (2000) | Y |
LNS.LNS_LOAN_API_ERRORS_GT does not reference any database object
LNS.LNS_LOAN_API_ERRORS_GT is referenced by following:
Description: |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ERROR_NUMBER | NUMBER | (15) | Y | |
LINE_NUMBER | NUMBER | (15) | ||
MESSAGE_NAME | VARCHAR2 | (30) | Y | |
MESSAGE_TEXT | VARCHAR2 | (2000) | Y |
LNS.LNS_LOAN_CREATE_ERRORS_GT does not reference any database object
LNS.LNS_LOAN_CREATE_ERRORS_GT is referenced by following:
Description: | This table stores all the documents related to a Source Object |
---|
Loan Documents
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 |
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 |
LNS.LNS_LOAN_DOCUMENTS does not reference any database object
LNS.LNS_LOAN_DOCUMENTS is referenced by following:
Description: |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
LNS_LOAN_DTLS_ALL_MV_N1 | NONUNIQUE | APPS_TS_SUMMARY | LOAN_ID |
LNS_LOAN_DTLS_ALL_MV_N10 | NONUNIQUE | APPS_TS_SUMMARY | SYS_NC00053$ |
LNS_LOAN_DTLS_ALL_MV_N2 | NONUNIQUE | APPS_TS_SUMMARY | ORG_ID |
LNS_LOAN_DTLS_ALL_MV_N3 | NONUNIQUE | APPS_TS_SUMMARY | LOAN_CURRENCY |
LNS_LOAN_DTLS_ALL_MV_N4 | NONUNIQUE | APPS_TS_SUMMARY | PRIMARY_STATUS_MEANING |
LNS_LOAN_DTLS_ALL_MV_N5 | NONUNIQUE | APPS_TS_SUMMARY | LOAN_STATUS |
LNS_LOAN_DTLS_ALL_MV_N6 | NONUNIQUE | APPS_TS_SUMMARY | LOAN_TYPE_ID |
LNS_LOAN_DTLS_ALL_MV_N7 | NONUNIQUE | APPS_TS_SUMMARY | PRODUCT_ID |
LNS_LOAN_DTLS_ALL_MV_N8 | NONUNIQUE | APPS_TS_SUMMARY | LEGAL_ENTITY_ID |
LNS_LOAN_DTLS_ALL_MV_N9 | NONUNIQUE | APPS_TS_SUMMARY | SYS_NC00054$ |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LOAN_ID | NUMBER | (15) | Y | |
LOAN_NUMBER | VARCHAR2 | (60) | Y | |
LOAN_DESCRIPTION | VARCHAR2 | (250) | ||
TOTAL_PRINCIPAL_BALANCE | NUMBER | |||
PRIMARY_BORROWER_ID | NUMBER | (15) | ||
PARTY_NAME | VARCHAR2 | (360) | Y | |
LOAN_STATUS_MEANING | VARCHAR2 | (162) | ||
DETAIL_VIEW_FLAG | CHAR | (1) | ||
INITIAL_LOAN_BALANCE | NUMBER | Y | ||
TERM_PERIOD | VARCHAR2 | (121) | ||
ADDRESS | VARCHAR2 | (963) | ||
CITY_COUNTY | VARCHAR2 | (121) | ||
STATE | VARCHAR2 | (60) | ||
POSTAL_CODE | VARCHAR2 | (60) | ||
TAX_REFERENCE | VARCHAR2 | (20) | ||
PRODUCT_ID | NUMBER | (15) | ||
RATE | VARCHAR2 | (41) | ||
RATE_TYPE | VARCHAR2 | (80) | Y | |
CONTACT_PHONE_NUMBER | VARCHAR2 | (60) | ||
SELECT_LOAN_ROW | CHAR | (1) | ||
CONTACT_PERSON_NAME | VARCHAR2 | (360) | ||
LOAN_TYPE | VARCHAR2 | (30) | ||
LOAN_CLASS_CODE | VARCHAR2 | (30) | ||
CREATION_DATE | DATE | Y | ||
LOAN_MATURITY_DATE | DATE | |||
LOAN_START_DATE | DATE | Y | ||
LOAN_CURRENCY | VARCHAR2 | (15) | Y | |
REQUESTED_AMOUNT | NUMBER | Y | ||
LAST_UPDATE_DATE | DATE | Y | ||
END_DATE | DATE | |||
DELETE_SWITCHER | VARCHAR2 | (14) | ||
LOAN_STATUS | VARCHAR2 | (30) | Y | |
TERM_ID | NUMBER | (15) | Y | |
LOAN_APPROVAL_DATE | DATE | |||
LOAN_CLASS_MEANING | VARCHAR2 | (80) | Y | |
LOAN_TYPE_MEANING | VARCHAR2 | (80) | Y | |
UPDATE_SWITCHER | VARCHAR2 | (14) | ||
LOAN_AGENT_ID | NUMBER | Y | ||
LOAN_AGENT_NAME | VARCHAR2 | (360) | ||
LOAN_AGENT_USER_ID | NUMBER | |||
LOAN_MAX_LAST_UPDATE_DATE | DATE | Y | ||
FUNDING_ADVICE_SUBMITTED_DATE | DATE | |||
LEGAL_ENTITY_ID | NUMBER | (15) | ||
LEGAL_ENTITY_NAME | VARCHAR2 | (240) | Y | |
OPERATING_UNIT_NAME | VARCHAR2 | (240) | Y | |
LOAN_TYPE_ID | NUMBER | (15) | ||
SECONDARY_STATUS | VARCHAR2 | (30) | ||
LOAN_PRODUCT_NAME | VARCHAR2 | (80) | ||
PRIMARY_STATUS_MEANING | VARCHAR2 | (80) | Y | |
SECONDARY_STATUS_MEANING | VARCHAR2 | (80) | ||
ORG_ID | NUMBER | (15) | Y | |
LOAN_PRODUCT_ID | NUMBER | (15) |
APPS.LNS_LOAN_DTLS_ALL_MV does not reference any database object
APPS.LNS_LOAN_DTLS_ALL_MV is referenced by following:
Description: | Loans Header 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 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 |
Loans Header Table
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 |
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 |
LNS.LNS_LOAN_HEADERS_ALL does not reference any database object
LNS.LNS_LOAN_HEADERS_ALL is referenced by following:
Description: | Loan History Table |
---|
Foreign Key Column | Foreign Table |
---|---|
LNS_LOAN_HISTORIES_H.LOAN_ID | LNS_LOAN_HEADERS_ALL |
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.
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 |
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 |
LNS.LNS_LOAN_HISTORIES_H does not reference any database object
LNS.LNS_LOAN_HISTORIES_H is referenced by following:
Description: | Loan Lines Table |
---|
Loan Lines Table
Index | Type | Tablespace | Column |
---|---|---|---|
LNS_LOAN_LINES_U1 | UNIQUE | APPS_TS_TX_IDX | LOAN_LINE_ID |
LNS_LOAN_LINES_U2 | UNIQUE | APPS_TS_TX_IDX |
LOAN_ID
REFERENCE_TYPE REFERENCE_ID PAYMENT_SCHEDULE_ID INSTALLMENT_NUMBER END_DATE |
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. |
LNS.LNS_LOAN_LINES does not reference any database object
LNS.LNS_LOAN_LINES is referenced by following:
Description: | Loan Product Setup 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 |
Loan Product Setup Table
Index | Type | Tablespace | Column |
---|---|---|---|
LNS_LOAN_PRODUCTS_ALL_U1 | UNIQUE | APPS_TS_TX_IDX | LOAN_PRODUCT_ID |
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 |
LNS.LNS_LOAN_PRODUCTS_ALL does not reference any database object
LNS.LNS_LOAN_PRODUCTS_ALL is referenced by following:
Description: | Loan Product Setup Read-Only Column Names Table |
---|
Foreign Key Column | Foreign Table |
---|---|
LNS_LOAN_PRODUCT_FLAGS.LOAN_PRODUCT_ID | LNS_LOAN_PRODUCTS_ALL |
Loan Product Setup Read-Only Column Names Table
Index | Type | Tablespace | Column |
---|---|---|---|
LNS_LOAN_PRODUCT_FLAGS_U1 | UNIQUE | APPS_TS_TX_IDX |
LOAN_PRODUCT_ID
READONLY_COLUMN_NAME |
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 |
LNS.LNS_LOAN_PRODUCT_FLAGS does not reference any database object
LNS.LNS_LOAN_PRODUCT_FLAGS is referenced by following:
Description: | Loan Product Setup Lines 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 Key Column | Foreign Table |
---|---|
LNS_LOAN_PRODUCT_LINES.PARENT_PRODUCT_LINES_ID | LNS_LOAN_PRODUCT_LINES |
Loan Product Setup Lines Table
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 |
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 |
LNS.LNS_LOAN_PRODUCT_LINES does not reference any database object
LNS.LNS_LOAN_PRODUCT_LINES is referenced by following:
Description: | Loan Types Setup Table |
---|
Loan Types Setup Table
Index | Type | Tablespace | Column |
---|---|---|---|
LNS_LOAN_TYPES_U1 | UNIQUE | APPS_TS_TX_IDX | LOAN_TYPE_ID |
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 |
LNS.LNS_LOAN_TYPES does not reference any database object
LNS.LNS_LOAN_TYPES is referenced by following:
Description: | Loan Participants 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 |
Participants Table
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 |
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 |
LNS.LNS_PARTICIPANTS does not reference any database object
LNS.LNS_PARTICIPANTS is referenced by following:
Description: | Loan Interest Rate Schedule Table |
---|
Foreign Key Column | Foreign Table |
---|---|
LNS_RATE_SCHEDULES.TERM_ID | % |
Loan Interest Rate Schedule Table
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 |
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 |
LNS.LNS_RATE_SCHEDULES does not reference any database object
LNS.LNS_RATE_SCHEDULES is referenced by following:
Description: | Loans System Options 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 |
Loans System Options Table
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 |
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 |
LNS.LNS_SYSTEM_OPTIONS_ALL does not reference any database object
LNS.LNS_SYSTEM_OPTIONS_ALL is referenced by following:
Description: | Loans Terms Table |
---|
Foreign Key Column | Foreign Table |
---|---|
LNS_TERMS.LOAN_ID | LNS_LOAN_HEADERS_ALL |
Loans Terms Table
Index | Type | Tablespace | Column |
---|---|---|---|
LNS_TERMS_U1 | UNIQUE | APPS_TS_TX_IDX | TERM_ID |
LNS_TERMS_N1 | NONUNIQUE | APPS_TS_TX_IDX | LOAN_ID |
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 |
LNS.LNS_TERMS does not reference any database object
LNS.LNS_TERMS is referenced by following:
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
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 |
APPS.LNS_AEL_GL_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
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) |
APPS.LNS_AMORTIZATION_SCHEDULES_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
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 |
APPS.LNS_AM_SCHEDS_DTL_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
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 |
CURRENCY | VARCHAR2 | (15) | Y | Loan Currency |
LEGAL_ENTITY_ID | NUMBER | (15) | Identifies the Legal Entity | |
PHASE | VARCHAR2 | (30) | Phase |
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
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) |
APPS.LNS_AR_AMORTIZATIONS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
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) | 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 | (15) | 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 |
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
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) | 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 |
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LOAN_ID | NUMBER | (15) | Y | Loan identifier |
CUSTOMER_NAME | VARCHAR2 | (360) | Y | customer name |
CUSTOMER_NUMBER | VARCHAR2 | (30) | Y | customer number |
LOAN_NUMBER | VARCHAR2 | (60) | Y | loan number |
LOAN_START_DATE | DATE | Y | 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 |
APPS.LNS_LOAN_INFO is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
View for Loan Participants Information
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 |
A public view which may be useful for custom reporting or other data requirements.
This view contains basic billing and payment summary information for every loan in the system. This is public view for other applications.
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 |
APPS.LNS_LOAN_PAYMENT_SUMMARY_V is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
View for Loan Summary Information
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 |
APPS.LNS_LOAN_SUMMARY_V is not referenced by any database object
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.
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 |
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
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). |
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
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) |
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
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 |
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
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 |
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
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 |
APPS.LNS_PAY_SUM_YEARLY_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
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 | |||
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) | ||
LEGAL_ENTITY_ID | NUMBER | (15) | ||
PHASE | VARCHAR2 | (30) |
APPS.LNS_RECEIVABLE_ACTIVITIES_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
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 |
APPS.LNS_REC_ACT_ADJ_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
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 |
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
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 |
APPS.LNS_SL_GL_V2 is not referenced by any database object
|
|
Copyright (c) 2001 - 2005, Oracle | - Use Restricted by Contract |