VIEW: LNS.LNS_BORROWER_SUMMARIES#

Source

View Text - Preformatted

select BORROWER_PARTY_ID BORROWER_PARTY_ID, BORROWER_NAME BORROWER_NAME, TAX_PAYER_CODE TAX_PAYER_CODE, CUSTOMER_CLASSIFICATION CUSTOMER_CLASSIFICATION, INDUSTRIAL_CLASSIFICATION INDUSTRIAL_CLASSIFICATION, YEAR_ESTABLISHED YEAR_ESTABLISHED, COUNTRY COUNTRY, ADDRESS1 ADDRESS1, ADDRESS2 ADDRESS2, ADDRESS3 ADDRESS3, ADDRESS4 ADDRESS4, CITY CITY, POSTAL_CODE POSTAL_CODE, STATE STATE, PRIMARY_CONTACT_NAME PRIMARY_CONTACT_NAME, PRIMARY_PHONE_COUNTRY_CODE PRIMARY_PHONE_COUNTRY_CODE, PRIMARY_PHONE_AREA_CODE PRIMARY_PHONE_AREA_CODE, PRIMARY_PHONE_NUMBER PRIMARY_PHONE_NUMBER, PRIMARY_PHONE_EXTENSION PRIMARY_PHONE_EXTENSION, ANNUAL_REVENUE ANNUAL_REVENUE, CUSTOMER_SINCE CUSTOMER_SINCE, NUM_ACTIVE_LOANS NUM_ACTIVE_LOANS, TOTAL_REMAINING_PRINCIPAL TOTAL_REMAINING_PRINCIPAL, TOTAL_PRINCIPAL_PAID_YTD TOTAL_PRINCIPAL_PAID_YTD, TOTAL_INTEREST_PAID_YTD TOTAL_INTEREST_PAID_YTD, TOTAL_FEE_PAID_YTD TOTAL_FEE_PAID_YTD, TOTAL_REQUESTED_LOAN_AMOUNT TOTAL_REQUESTED_LOAN_AMOUNT, TOTAL_APPROVED_LOAN_AMOUNT TOTAL_APPROVED_LOAN_AMOUNT, PLEDGED_COLL_AMOUNT PLEDGED_COLL_AMOUNT, LAST_COLL_VALUATION_DATE LAST_COLL_VALUATION_DATE, CREDIT_CLASSIFICATION CREDIT_CLASSIFICATION, REVIEW_CYCLE REVIEW_CYCLE, LAST_CREDIT_REVIEW_DATE LAST_CREDIT_REVIEW_DATE, CREDIT_RATING CREDIT_RATING, CREDIT_HOLD CREDIT_HOLD, CREDIT_CHECKING CREDIT_CHECKING, TOLERANCE TOLERANCE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, ORG_ID ORG_ID, ORG_NAME ORG_NAME, LEGAL_ENTITY_ID LEGAL_ENTITY_ID, LEGAL_ENTITY_NAME LEGAL_ENTITY_NAME, FUNCTIONAL_CURRENCY FUNCTIONAL_CURRENCY from "LNS"."LNS_BORROWER_SUMMARIES"

View Text - HTML Formatted

SELECT BORROWER_PARTY_ID BORROWER_PARTY_ID
, BORROWER_NAME BORROWER_NAME
, TAX_PAYER_CODE TAX_PAYER_CODE
, CUSTOMER_CLASSIFICATION CUSTOMER_CLASSIFICATION
, INDUSTRIAL_CLASSIFICATION INDUSTRIAL_CLASSIFICATION
, YEAR_ESTABLISHED YEAR_ESTABLISHED
, COUNTRY COUNTRY
, ADDRESS1 ADDRESS1
, ADDRESS2 ADDRESS2
, ADDRESS3 ADDRESS3
, ADDRESS4 ADDRESS4
, CITY CITY
, POSTAL_CODE POSTAL_CODE
, STATE STATE
, PRIMARY_CONTACT_NAME PRIMARY_CONTACT_NAME
, PRIMARY_PHONE_COUNTRY_CODE PRIMARY_PHONE_COUNTRY_CODE
, PRIMARY_PHONE_AREA_CODE PRIMARY_PHONE_AREA_CODE
, PRIMARY_PHONE_NUMBER PRIMARY_PHONE_NUMBER
, PRIMARY_PHONE_EXTENSION PRIMARY_PHONE_EXTENSION
, ANNUAL_REVENUE ANNUAL_REVENUE
, CUSTOMER_SINCE CUSTOMER_SINCE
, NUM_ACTIVE_LOANS NUM_ACTIVE_LOANS
, TOTAL_REMAINING_PRINCIPAL TOTAL_REMAINING_PRINCIPAL
, TOTAL_PRINCIPAL_PAID_YTD TOTAL_PRINCIPAL_PAID_YTD
, TOTAL_INTEREST_PAID_YTD TOTAL_INTEREST_PAID_YTD
, TOTAL_FEE_PAID_YTD TOTAL_FEE_PAID_YTD
, TOTAL_REQUESTED_LOAN_AMOUNT TOTAL_REQUESTED_LOAN_AMOUNT
, TOTAL_APPROVED_LOAN_AMOUNT TOTAL_APPROVED_LOAN_AMOUNT
, PLEDGED_COLL_AMOUNT PLEDGED_COLL_AMOUNT
, LAST_COLL_VALUATION_DATE LAST_COLL_VALUATION_DATE
, CREDIT_CLASSIFICATION CREDIT_CLASSIFICATION
, REVIEW_CYCLE REVIEW_CYCLE
, LAST_CREDIT_REVIEW_DATE LAST_CREDIT_REVIEW_DATE
, CREDIT_RATING CREDIT_RATING
, CREDIT_HOLD CREDIT_HOLD
, CREDIT_CHECKING CREDIT_CHECKING
, TOLERANCE TOLERANCE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, ORG_ID ORG_ID
, ORG_NAME ORG_NAME
, LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, LEGAL_ENTITY_NAME LEGAL_ENTITY_NAME
, FUNCTIONAL_CURRENCY FUNCTIONAL_CURRENCY
FROM "LNS"."LNS_BORROWER_SUMMARIES"