FCT_BNK_RECONCILIATION_REPORT_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 TRANSACTION_DATE DATE 4
2 NO_OF_ACCOUNTS BIGINT 8
3 PRODUCT_GROUP_CODE CHARACTER VARYING(30) 30
4 PRODUCT_GROUP_DESCRIPTION CHARACTER VARYING(120) 120
5 PRODUCT_ID CHARACTER VARYING(30) 30
6 PRODUCT_DESCRIPTION CHARACTER VARYING(120) 120
7 OFFER_CODE CHARACTER VARYING(30) 30
8 PRODUCT_OFFER_DESCRIPTION CHARACTER VARYING(120) 120
9 LOAN_PURPOSE_CODE CHARACTER VARYING(100) 100
10 LOAN_PURPOSE_DESCIPTION CHARACTER VARYING(400) 400
11 BALANCE DOUBLE PRECISION 8
12 UNCOLLECTED_BALANCE DOUBLE PRECISION 8