INT_ATOCRS_OCH_CUSTOMER

Database

SDSNZP02_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Source Object (CTAS)

SDSNZP02_BANK..INT_ATOCRS_OCH_CUSTOMER_V

Columns
# Name Data Type Length
1 GCIS_CUSTOMER_NUMBER CHARACTER VARYING(400) 400
2 BRAND_CODE CHARACTER VARYING(3) 3
3 PRODUCT_SYSTEM_COMPANY_CODE CHARACTER VARYING(3) 3
4 PRODUCT_SYSTEM_CUSTOMER_NUMBER CHARACTER VARYING(50) 50
5 CUSTOMER_TYPE CHARACTER(3) 3
6 ENTITY_NAME CHARACTER VARYING(250) 250
7 TITLE CHARACTER VARYING(120) 120
8 FIRST_NAME CHARACTER VARYING(50) 50
9 MIDDLE_NAME CHARACTER VARYING(101) 101
10 SURNAME CHARACTER VARYING(50) 50
11 SUFFIX CHARACTER VARYING(30) 30
12 ABN CHARACTER VARYING(30) 30
13 ACN CHARACTER VARYING(30) 30
14 DATE_OF_BIRTH TIMESTAMP 8
15 DECEASED_IND TIMESTAMP 8
16 ANZSIC_CODE CHARACTER VARYING(5) 5
17 ANZSIC_DESCRIPTION CHARACTER VARYING(200) 200
18 GENDER_CODE CHARACTER VARYING(1) 1
19 RES_ADDRESS_LINE1 CHARACTER VARYING(120) 120
20 RES_ADDRESS_LINE2 CHARACTER VARYING(120) 120
21 RES_ADDRESS_LINE3 CHARACTER VARYING(120) 120
22 RES_CITY_TWN_SUBURB CHARACTER VARYING(50) 50
23 RES_POSTCODE CHARACTER VARYING(30) 30
24 RES_STATE CHARACTER VARYING(30) 30
25 RES_COUNTRY_CODE CHARACTER VARYING(2) 2
26 MAIL_ADDRESS_LINE1 CHARACTER VARYING(120) 120
27 MAIL_ADDRESS_LINE2 CHARACTER VARYING(120) 120
28 MAIL_ADDRESS_LINE3 CHARACTER VARYING(120) 120
29 MAIL_CITY_TWN_SUBURB CHARACTER VARYING(50) 50
30 MAIL_POST_CODE CHARACTER VARYING(30) 30
31 MAIL_STATE CHARACTER VARYING(30) 30
32 MAIL_COUNTRY CHARACTER VARYING(2) 2
33 MAIL_POSTAL_ADDRESS_TYPE CHARACTER VARYING(10) 10
34 PHONE_NUMBER CHARACTER VARYING(20) 20
35 WORK_PHONE_NUMBER CHARACTER VARYING(45) 45
36 MOBILE_NUMBER CHARACTER VARYING(45) 45
37 BROKER_PHONE_NUMBER CHARACTER VARYING(20) 20
38 EMAIL_ADDRESS CHARACTER VARYING(120) 120
39 EMAIL_ADDR_TYPE CHARACTER VARYING(2) 2