FCM_CREDIT_CARD_PROFILE

Database

SDSNZS01_R12

Schema

CDCPADM_R12

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 COMPANY_CODE CHARACTER VARYING(10) 10
2 COMPANY_NAME CHARACTER VARYING(60) 60
3 PROFILE_UNIQUE INTEGER 4
4 MASKED_PAN CHARACTER VARYING(30) 30
5 CARD_EXPIRY CHARACTER VARYING(7) 7
6 CREDIT_NAME CHARACTER VARYING(30) 30
7 STATUS CHARACTER(1) 1
8 STORE_CARD_FLAG CHARACTER(1) 1
9 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
10 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
11 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
12 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8