CRMD_PERSONAL_CUSTOMER

Database

SDSNZS01_CRMD

Schema

CDCPADM_CRMD

Type

TABLE

Description

 

Columns
# Name Data Type Length
2 GCIS_ID INTEGER 4
3 FIRST_NAME CHARACTER VARYING(255) 255
4 LAST_NAME CHARACTER VARYING(255) 255
5 DATE_OF_BIRTH DATE 4
6 NUMBER_OR_STREET CHARACTER VARYING(255) 255
7 CITY CHARACTER VARYING(255) 255
8 STATE CHARACTER VARYING(40) 40
9 COUNTRY CHARACTER VARYING(40) 40
10 POSTCODE CHARACTER VARYING(40) 40
11 TAX_LIABLE_STATUS CHARACTER VARYING(40) 40
12 TAX_LIABLE_COUNTRY CHARACTER VARYING(40) 40
13 TAX_LIABLE_STATUS_DATE DATE 4
14 TIN_SSN CHARACTER VARYING(40) 40