CFD_TCFDD_SMS_GATEWAY_RETURN

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 DIALLER_RTRN_INFO_ID BIGINT 8
2 MAIN_EVENT_ID BIGINT 8
3 MAIN_APPL_ID BIGINT 8
4 MAIN_SEND_OR_RECEIVE_IND CHARACTER VARYING(1) 1
5 MAIN_DATETIME_RCVD_FROM_APPL CHARACTER VARYING(40) 40
6 MAIN_SQL_RECORD_CREATED_DATE TIMESTAMP 8
7 MAIN_PROD_SERVER_DETL CHARACTER VARYING(30) 30
8 MAIN_PROC_STATE BIGINT 8
9 MAIN_PRTY_IND CHARACTER VARYING(1) 1
10 MAIN_DO_NOT_SEND_BEFORE_TME CHARACTER VARYING(4) 4
11 MAIN_DO_NOT_SEND_AFTER_TME CHARACTER VARYING(4) 4
12 MAIN_BROADCAST_REF CHARACTER VARYING(20) 20
13 MAIN_CMPY_CODE CHARACTER VARYING(30) 30
14 MAIN_DEPT_CODE CHARACTER VARYING(30) 30
15 MAIN_APPL_CUSTOM1 CHARACTER VARYING(100) 100
16 MAIN_APPL_CUSTOM2 CHARACTER VARYING(100) 100
17 MAIN_APPL_CUSTOM3 CHARACTER VARYING(100) 100
18 MAIN_APPL_CUSTOM4 CHARACTER VARYING(100) 100
19 MAIN_APPL_CUSTOM5 CHARACTER VARYING(100) 100
20 MAIN_APPL_CUSTOM6 CHARACTER VARYING(100) 100
21 MAIN_APPL_CUSTOM7 CHARACTER VARYING(100) 100
22 MAIN_APPL_CUSTOM8 CHARACTER VARYING(100) 100
23 MAIN_APPL_CUSTOM9 CHARACTER VARYING(100) 100
24 MAIN_APPL_CUSTOM10 CHARACTER VARYING(100) 100
25 MAIN_APPL_REF CHARACTER VARYING(150) 150
26 MAIN_EPM_HDR CHARACTER VARYING(20) 20
27 MAIN_SUBJECT_NAM CHARACTER VARYING(320) 320
28 MAIN_COMPILED_SMS_MSG CHARACTER VARYING(320) 320
29 MAIN_SENDER_EMAIL_ADDR CHARACTER VARYING(100) 100
30 MAIN_INBOUND_ROUTED_EMAIL CHARACTER VARYING(100) 100
31 MAIN_SMSC_RECEIVER_SMS_NUM CHARACTER VARYING(20) 20
32 MAIN_SMSC_SENDER_SMS_NUM CHARACTER VARYING(20) 20
33 MAIN_SMSC_SENDER_FB_SMS_NUM CHARACTER VARYING(20) 20
34 MAIN_SMSC_FB_ROUTE_TAKEN CHARACTER VARYING(1) 1
35 MAIN_PARTA_COMPILED_SMS_MSG CHARACTER VARYING(160) 160
36 MAIN_PARTA_SMSC_RTRN_ID BIGINT 8
37 MAIN_PARTA_SMSC_RTRN_CODE CHARACTER VARYING(100) 100
38 MAIN_PARTA_SMSC_RTRN_CODE_DESC CHARACTER VARYING(100) 100
39 MAIN_PARTA_SMSC_MSG_ID CHARACTER VARYING(100) 100
40 MAIN_PARTA_SMSC_MSG_ACCEPT_DT TIMESTAMP 8
41 MAIN_PARTA_SMSC_DLVRY_DATE TIMESTAMP 8
42 MAIN_PARTB_COPILED_SMS_MSG CHARACTER VARYING(160) 160
43 MAIN_PARTB_SMSC_RTRN_CODE CHARACTER VARYING(100) 100
44 MAIN_PARTB_SMSC_RTRN_CODE_DESC CHARACTER VARYING(100) 100
45 MAIN_PARTB_SMSC_MSG_ID_DESC CHARACTER VARYING(100) 100
46 MAIN_PARTB_SMSC_MSG_ACCEPT_DT TIMESTAMP 8
47 MAIN_PARTB_SMSC_DLVRY_DATE TIMESTAMP 8
48 MAIN_GEN_ERR_DESC CHARACTER VARYING(200) 200
49 MAIN_REPLY_EMAIL_FOR_FAIL_MSG CHARACTER VARYING(100) 100
50 MAIN_REPLY_EMAIL_FOR_SENT_MSG CHARACTER VARYING(100) 100
51 MAIN_APPL_OR_USER_RECORD_IND CHARACTER VARYING(1) 1
52 MAIN_RCVD_DUP_FLG CHARACTER VARYING(1) 1
53 MAIN_DUP_CNT BIGINT 8
54 MAIN_ADT_NOTE CHARACTER VARYING(500) 500
55 MAIN_DUP_ALLOW_COUNTER BIGINT 8
56 EFF_STRT_DATE TIMESTAMP 8
57 EFF_END_DATE TIMESTAMP 8
58 DATA_LOAD_DATE TIMESTAMP 8
59 SNPSHT_DATE TIMESTAMP 8
60 SRC_SYS_ID CHARACTER VARYING(5) 5
61 LOAD_ID BIGINT 8
62 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
63 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
64 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
65 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8