CFD_TCFDD_RESPONSYS_TXN_DATA

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 DIALLER_RTRN_INFO_ID BIGINT 8
2 CUST_NUM CHARACTER VARYING(20) 20
3 DATE_TME_PRCHD TIMESTAMP 8
4 EVENT_ID BIGINT 8
5 EVENT_CODE CHARACTER VARYING(100) 100
6 PRCHD_VAL NUMERIC(18,6) 19
7 NUM_OF_TICKETS BIGINT 8
8 EFF_STRT_DATE TIMESTAMP 8
9 EFF_END_DATE TIMESTAMP 8
10 DATA_LOAD_DATE TIMESTAMP 8
11 SNPSHT_DATE TIMESTAMP 8
12 SRC_SYS_ID CHARACTER VARYING(5) 5
13 LOAD_ID BIGINT 8
14 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
15 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
16 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
17 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8