FCT_BNK_QRM_ACCOUNT_X_PRIMARY_CUSTOMER_MASTER

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 PERIOD_DATE DATE 4
2 ACCOUNT_NUMBER CHARACTER VARYING(40) 40
3 SOURCE_SYSTEM CHARACTER VARYING(3) 3
4 GCIS_CUSTOMER_NUMBER CHARACTER VARYING(100) 100
5 SOURCE_CUSTOMER_NUMBER CHARACTER VARYING(40) 40
6 PST_CODE CHARACTER VARYING(30) 30
7 STE CHARACTER VARYING(30) 30
8 CUSTOMER_COUNTRY_CODE CHARACTER VARYING(2) 2
9 CUSTOMER_COUNTRY_DESCRIPTION CHARACTER VARYING(105) 105
10 RESIDENT_FLAG CHARACTER VARYING(30) 30
11 AUSTRALIAN_BUSINESS_NUMBER CHARACTER VARYING(30) 30
12 AUSTRALIAN_COMPANY_NUMBER CHARACTER VARYING(30) 30
13 COUNTERPARTY_TYPE CHARACTER VARYING(12) 12
14 CUST_BNK_RLTNP_CODE CHARACTER VARYING(3) 3