FCT_OBP_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 INTEGER 4
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(1) 1
12 AUSTRALIAN_COMPANY_NUMBER CHARACTER VARYING(1) 1
13 COUNTERPARTY_TYPE CHARACTER VARYING(10) 10
14 CUST_BNK_RLTNP_CODE CHARACTER VARYING(3) 3