CAD_HST_CARD

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP05_BANK..CBP_CAD_HST_CARD

Columns
# Name Data Type Length
1 ACCOUNT BIGINT 8
2 ACTIONCODE CHARACTER VARYING(12) 12
3 ACTION_DAY INTEGER 4
4 AUTHS_AMT NUMERIC(15,2) 19
5 AUTH_OFLAG CHARACTER VARYING(4) 4
6 AUTH_ORIDE BIGINT 8
7 AUTH_PDAY INTEGER 4
8 AUTH_PTIME INTEGER 4
9 BALINQ_YN CHARACTER VARYING(4) 4
10 BANK SMALLINT 2
11 BASEI_DAY INTEGER 4
12 BASEI_SRCE CHARACTER VARYING(24) 24
13 BASEI_TIME INTEGER 4
14 CANCL_BRCH SMALLINT 2
15 CANCL_CODE CHARACTER VARYING(4) 4
16 CANCL_DAY INTEGER 4
17 CANCL_EMPL INTEGER 4
18 CANCL_NEW CHARACTER VARYING(4) 4
19 CANCL_NOTES CHARACTER VARYING(1400) 1400
20 CANCL_TIME INTEGER 4
21 CARDHOLDER SMALLINT 2
22 CARDPRS_YN CHARACTER VARYING(4) 4
23 CARD_NBR CHARACTER VARYING(76) 76
24 CASHAM_TDY NUMERIC(15,2) 19
25 CASHBCK_YN CHARACTER VARYING(4) 4
26 CASHNO_TDY SMALLINT 2
27 CHECK_DIG SMALLINT 2
28 CHQ_BNKCDE CHARACTER VARYING(8) 8
29 COURIERFEE SMALLINT 2
30 CRB_REGION CHARACTER VARYING(52) 52
31 CREATE_DAY INTEGER 4
32 CURR_NUM SMALLINT 2
33 CUSTR_NBR CHARACTER VARYING(48) 48
34 CVC2 CHARACTER VARYING(12) 12
35 CVC3 CHARACTER VARYING(12) 12
36 CVV CHARACTER VARYING(12) 12
37 DATE_LAST_SEEN INTEGER 4
38 DAY_NEW_CRD_USED INTEGER 4
39 DBC4 CHARACTER VARYING(16) 16
40 DEF_BNKCDE CHARACTER VARYING(8) 8
41 DEF_DSPCH CHARACTER VARYING(16) 16
42 DEF_LOCN SMALLINT 2
43 DEPAM_TDY NUMERIC(15,2) 19
44 DEPNO_TDY SMALLINT 2
45 DEPOSIT_YN CHARACTER VARYING(4) 4
46 DESPATCH CHARACTER VARYING(16) 16
47 DSPCH_LOCN SMALLINT 2
48 ECOMM_LMT_FR BIGINT 8
49 ECOMM_LMT_TO BIGINT 8
50 ECOMM_YN CHARACTER VARYING(4) 4
51 ELIG_LOYAL CHARACTER VARYING(4) 4
52 EMBOSS_CRD CHARACTER VARYING(4) 4
53 EMBOSS_LN2 CHARACTER VARYING(104) 104
54 EMBOSS_NME CHARACTER VARYING(104) 104
55 EMBOSS_SUL SMALLINT 2
56 EMBOSS_SUR SMALLINT 2
57 EMB_ONL_YN CHARACTER VARYING(4) 4
58 EMV_EFFDAY INTEGER 4
59 EMV_EF_NEW INTEGER 4
60 EMV_EF_PRV INTEGER 4
61 EMV_PROF CHARACTER VARYING(64) 64
62 EMV_PR_NEW CHARACTER VARYING(64) 64
63 EMV_PR_PRV CHARACTER VARYING(64) 64
64 ENCR_PIN CHARACTER VARYING(64) 64
65 EXPIRY_DTE SMALLINT 2
66 EXPIRY_NEW SMALLINT 2
67 EXPIRY_PRV SMALLINT 2
68 FEE_CODE CHARACTER VARYING(16) 16
69 FEE_MONTH SMALLINT 2
70 FEE_PROF CHARACTER VARYING(40) 40
71 HOLD_ORIG CHARACTER VARYING(8) 8
72 HOLD_REAS CHARACTER VARYING(8) 8
73 HRCAMT_TDY NUMERIC(15,2) 19
74 HRCNO_TDY SMALLINT 2
75 ISSUE_DAY INTEGER 4
76 ISSUE_NBR SMALLINT 2
77 ISSUE_REAS CHARACTER VARYING(4) 4
78 ISSUE_STS SMALLINT 2
79 ISS_SERIAL INTEGER 4
80 ISS_STS_PR SMALLINT 2
81 LASTAUTHDY INTEGER 4
82 LASTPIN_DY INTEGER 4
83 LASTREV_DY INTEGER 4
84 LIMIT_CODE SMALLINT 2
85 LIMIT_CODE_RVT_DAY INTEGER 4
86 LIMIT_CODE_RVT_TO SMALLINT 2
87 LOSS_AMPM CHARACTER VARYING(8) 8
88 LOSS_DAY INTEGER 4
89 LOSS_LOCN INTEGER 4
90 LOSS_REPRT CHARACTER VARYING(12) 12
91 LOSS_TIME SMALLINT 2
92 MAILER_1ST INTEGER 4
93 MAX_PINTRY SMALLINT 2
94 MCC102 CHARACTER VARYING(4) 4
95 MCC103 CHARACTER VARYING(4) 4
96 MCGALLOWED CHARACTER VARYING(32) 32
97 MCGRESTRI CHARACTER VARYING(32) 32
98 MEMBER SMALLINT 2
99 MONTH_NBR SMALLINT 2
100 OCT_YN CHARACTER VARYING(4) 4
101 OTH_BNKCDE CHARACTER VARYING(8) 8
102 PAN_SEQNO CHARACTER VARYING(12) 12
103 PAN_SEQNO_NEW CHARACTER VARYING(12) 12
104 PAN_SEQNO_PRV CHARACTER VARYING(12) 12
105 PHOTO_FLG SMALLINT 2
106 PINCHG_FAILS SMALLINT 2
107 PIN_BRNCH SMALLINT 2
108 PIN_DATE CHARACTER VARYING(28) 28
109 PIN_DESPATCH CHARACTER VARYING(16) 16
110 PIN_FAILS SMALLINT 2
111 PIN_OFF CHARACTER VARYING(48) 48
112 PIN_OFF_PRV CHARACTER VARYING(48) 48
113 PIN_REQD CHARACTER VARYING(4) 4
114 PIN_TIME INTEGER 4
115 PLACE_LAST_SEEN CHARACTER VARYING(2000) 2000
116 PLSTIC_NEW CHARACTER VARYING(8) 8
117 PLSTIC_PRV CHARACTER VARYING(8) 8
118 POST_AMT NUMERIC(15,2) 19
119 PRCOL_NEW CHARACTER VARYING(64) 64
120 PRCOL_PREV CHARACTER VARYING(64) 64
121 PREV_CANC CHARACTER VARYING(4) 4
122 PREV_DAY INTEGER 4
123 PREV_TIME INTEGER 4
124 PROFIL SMALLINT 2
125 PURCAM_TDY NUMERIC(15,2) 19
126 PURCH_YN CHARACTER VARYING(4) 4
127 PURCNO_TDY SMALLINT 2
128 PURGE_DATE SMALLINT 2
129 PVV INTEGER 4
130 PVV_PREV INTEGER 4
131 REFAD_PER NUMERIC(4,2) 19
132 REFER_DAY INTEGER 4
133 REFER_PER NUMERIC(4,2) 19
134 REF_ID CHARACTER VARYING(80) 80
135 REF_NBR INTEGER 4
136 REISSUE CHARACTER VARYING(4) 4
137 REISS_DTE CHARACTER VARYING(28) 28
138 REPLACEFEE SMALLINT 2
139 REPORTED_BY CHARACTER VARYING(400) 400
140 REPRNT_PIN CHARACTER VARYING(4) 4
141 REVTDY_NO SMALLINT 2
142 SAV_BNKCDE CHARACTER VARYING(8) 8
143 SCHD_DSPCH CHARACTER VARYING(16) 16
144 SCHD_LOCN SMALLINT 2
145 SCHEME_OPT_OUT_FLG CHARACTER VARYING(4) 4
146 SERV_CODE CHARACTER VARYING(12) 12
147 SERV_CODE_NEW CHARACTER VARYING(12) 12
148 SERV_CODE_PREV CHARACTER VARYING(12) 12
149 SIGN_FLG SMALLINT 2
150 SPEC_INSTR CHARACTER VARYING(48) 48
151 STIPYN CHARACTER VARYING(4) 4
152 SUP_LIMIT BIGINT 8
153 TFR_AMT_TDY NUMERIC(15,2) 19
154 TFR_NBR_TDY SMALLINT 2
155 UDI_YN CHARACTER VARYING(4) 4
156 URGENTFEE CHARACTER VARYING(4) 4
157 VALID_FROM SMALLINT 2
158 VALID_NEW SMALLINT 2
159 VIP_CNT SMALLINT 2
160 VIP_LIM INTEGER 4
161 W2W_YN CHARACTER VARYING(4) 4
162 WITHDRW_YN CHARACTER VARYING(4) 4
163 XFRFROM_YN CHARACTER VARYING(4) 4
164 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
165 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
166 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
167 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8