FCT_BNK_CASA_ACCOUNT_HOLD_REPORT_INSIGHT

Database

INSNZP05_BANK

Schema

BANKPADM

Type

TABLE

Description

Cheque and Savings accounts and dated put on or off hold with reasons

Columns
# Name Data Type Length
1 BRANCH_NAME CHARACTER VARYING(105) 105
2 USER_ID CHARACTER VARYING(254) 254
3 CUSTOMER_NAME CHARACTER VARYING(250) 250
4 ACCOUNT_NUMBER CHARACTER VARYING(40) 40
5 HOLD_TYPE_PRIMARY_REASON CHARACTER VARYING(120) 120
6 SECONDARY_REASON_DESCRIPTION CHARACTER VARYING(120) 120
7 HOLD_ADDED TIMESTAMP 8
8 HOLD_REMOVED TIMESTAMP 8
9 HOLD_DESCRIPTION CHARACTER VARYING(120) 120
10 HOLD_TYPE CHARACTER VARYING(36) 36