DIM_CUST_REWARD_REGISTRATION

Database

INSNZP01_CL

Schema

CLPADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 LC_ACC_NUMBER CHARACTER VARYING(250) 250
2 OCID CHARACTER VARYING(250) 250
4 CMPY_CUST_NUM INTEGER 4
5 CUST_NUM NUMERIC(18,0) 19
6 DATE_REGISTERED DATE 4
7 FIRST_NAME CHARACTER VARYING(100) 100
9 EMAIL_ADDRESS_1 CHARACTER VARYING(100) 100
10 PHONE_NUMBER CHARACTER VARYING(20) 20
11 STATUS CHARACTER VARYING(10) 10
12 STATUS_REASON CHARACTER VARYING(256) 256