FCT_BNK_UPFRONT_ADD_LOANS_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 ACCOUNT_NUMBER CHARACTER VARYING(128) 128
2 BRANCH CHARACTER VARYING(10) 10
3 APPLICANT_NAME CHARACTER VARYING(250) 250
4 PRODUCT_CODE CHARACTER VARYING(30) 30
5 LOAN_TYPE_CODE CHARACTER VARYING(30) 30
6 LOAN_AMOUNT INTEGER 4
7 BROKER_CODE CHARACTER VARYING(20) 20
8 ACCRED_BROKER_CODE CHARACTER VARYING(20) 20
9 SALES_OFFICER_CODE CHARACTER VARYING(120) 120
10 SET_DATE TIMESTAMP 8
11 SUNLOANS CHARACTER VARYING(1) 1
12 SUBMISSION_ID CHARACTER VARYING(50) 50
13 CAPTURE_DATE TIMESTAMP 8
14 ELECTRONIC_LODGEMENT_ID CHARACTER VARYING(50) 50
15 PURPOSE_DESC CHARACTER VARYING(200) 200
16 PURPOSE_CODE CHARACTER VARYING(40) 40
17 RNK BIGINT 8