[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | LNS_BORROWER_SUMMARIES |
|---|---|
| Object Type: | TABLE |
| Owner: | LNS |
| FND Design Data: |  LNS.LNS_BORROWER_SUMMARIES
|
| Subobject Name: | |
| Status: | VALID |
Borrower Summary Table
| Tablespace: |  APPS_TS_SUMMARY |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| BORROWER_PARTY_ID | NUMBER | (15) | Yes | 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 | Yes | Standard Who column - date when a user last updated this row | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | 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 | Yes | Standard who column - date when this row was created | |
| CREATED_BY | NUMBER | (15) | Yes | 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 | Yes | Object Version Number | |
| ORG_ID | NUMBER | (15) | Yes | 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 |
Cut, paste (and edit) the following text to query this object:
SELECT BORROWER_PARTY_ID
, BORROWER_NAME
, TAX_PAYER_CODE
, CUSTOMER_CLASSIFICATION
, INDUSTRIAL_CLASSIFICATION
, YEAR_ESTABLISHED
, COUNTRY
, ADDRESS1
, ADDRESS2
, ADDRESS3
, ADDRESS4
, CITY
, POSTAL_CODE
, STATE
, PRIMARY_CONTACT_NAME
, PRIMARY_PHONE_COUNTRY_CODE
, PRIMARY_PHONE_AREA_CODE
, PRIMARY_PHONE_NUMBER
, PRIMARY_PHONE_EXTENSION
, ANNUAL_REVENUE
, CUSTOMER_SINCE
, NUM_ACTIVE_LOANS
, TOTAL_REMAINING_PRINCIPAL
, TOTAL_PRINCIPAL_PAID_YTD
, TOTAL_INTEREST_PAID_YTD
, TOTAL_FEE_PAID_YTD
, TOTAL_REQUESTED_LOAN_AMOUNT
, TOTAL_APPROVED_LOAN_AMOUNT
, PLEDGED_COLL_AMOUNT
, LAST_COLL_VALUATION_DATE
, CREDIT_CLASSIFICATION
, REVIEW_CYCLE
, LAST_CREDIT_REVIEW_DATE
, CREDIT_RATING
, CREDIT_HOLD
, CREDIT_CHECKING
, TOLERANCE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE
, OBJECT_VERSION_NUMBER
, ORG_ID
, ORG_NAME
, LEGAL_ENTITY_ID
, LEGAL_ENTITY_NAME
, FUNCTIONAL_CURRENCY
FROM LNS.LNS_BORROWER_SUMMARIES;
LNS.LNS_BORROWER_SUMMARIES does not reference any database object
LNS.LNS_BORROWER_SUMMARIES is referenced by following:
APPS
LNS_BORROWER_SUMMARIES
|
|
|
|