CAD_PRMCD

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP05_BANK..CBP_CAD_PRMCD

Columns
# Name Data Type Length
1 ACCT_YN CHARACTER VARYING(4) 4
2 AEVV_YN CHARACTER VARYING(4) 4
3 ATC_CHECK CHARACTER VARYING(4) 4
4 ATC_RANGE SMALLINT 2
5 BALINQ_MSG SMALLINT 2
6 BALINQ_RSP SMALLINT 2
7 BALINQ_YN CHARACTER VARYING(4) 4
8 BANK SMALLINT 2
9 BANK_INT CHARACTER VARYING(16) 16
10 BIN_LENGTH SMALLINT 2
11 BKAC_MTD CHARACTER VARYING(4) 4
12 BLOCK_OLD_CRD CHARACTER VARYING(4) 4
13 CARDLENGTH SMALLINT 2
14 CARDPRS_MSG SMALLINT 2
15 CARDPRS_RSP SMALLINT 2
16 CARDPRS_YN CHARACTER VARYING(4) 4
17 CARD_PLAN CHARACTER VARYING(4) 4
18 CASHBCK_YN CHARACTER VARYING(4) 4
19 CASHBK_MSG SMALLINT 2
20 CASHBK_RSP SMALLINT 2
21 CASHBK_TYP CHARACTER VARYING(4) 4
22 CAVV_YN CHARACTER VARYING(4) 4
23 CHKDGT_ROU CHARACTER VARYING(8) 8
24 CORP_TYPE CHARACTER VARYING(4) 4
25 CRD_PLSTIC CHARACTER VARYING(8) 8
26 CSC3_YN CHARACTER VARYING(4) 4
27 CSC4_YN CHARACTER VARYING(4) 4
28 CSC5_YN CHARACTER VARYING(4) 4
29 CVC2_YN CHARACTER VARYING(4) 4
30 CVC3_YN CHARACTER VARYING(4) 4
31 CVV_KEY CHARACTER VARYING(8) 8
32 CVV_YN CHARACTER VARYING(4) 4
33 DBC4_YN CHARACTER VARYING(4) 4
34 DEPOSIT_YN CHARACTER VARYING(4) 4
35 DEP_MSG SMALLINT 2
36 DEP_RSP SMALLINT 2
37 DESP_MTHD CHARACTER VARYING(16) 16
38 ECOMM_MSG SMALLINT 2
39 ECOMM_RSP SMALLINT 2
40 ECOMM_YN CHARACTER VARYING(4) 4
41 EMBOSS_LEN SMALLINT 2
42 EXSERV_CDE CHARACTER VARYING(12) 12
43 EXT_LIMIT_CD CHARACTER VARYING(40) 40
44 FEE_PROF CHARACTER VARYING(40) 40
45 FF_TYP CHARACTER VARYING(4) 4
46 FRI_YN CHARACTER VARYING(4) 4
47 GEN_CRDNBR CHARACTER VARYING(4) 4
48 HCARDPRE BIGINT 8
49 ID_NUMBER CHARACTER VARYING(64) 64
50 IN_EMBOSS CHARACTER VARYING(4) 4
51 ISSUECODE CHARACTER VARYING(4) 4
52 KEYSET CHARACTER VARYING(16) 16
53 LCARDPRE BIGINT 8
54 LIMIT_CODE SMALLINT 2
55 MAGSTRIPE_TRK1 CHARACTER VARYING(40) 40
56 MAGSTRIPE_TRK2 CHARACTER VARYING(40) 40
57 MAGSTRIPE_TRK3 CHARACTER VARYING(40) 40
58 MAINT CHARACTER VARYING(4) 4
59 MAX_PINCHG SMALLINT 2
60 MAX_PINTRY SMALLINT 2
61 MCCCNTL_YN CHARACTER VARYING(4) 4
62 MINREPL_MM SMALLINT 2
63 MON_YN CHARACTER VARYING(4) 4
64 MTH_RANGE_FROM SMALLINT 2
65 MTH_RANGE_TO SMALLINT 2
66 NBR_METHOD CHARACTER VARYING(16) 16
67 NET_SERVS CHARACTER VARYING(24) 24
68 OCT_MSG SMALLINT 2
69 OCT_RSP SMALLINT 2
70 OCT_YN CHARACTER VARYING(4) 4
71 OFFSET_YN CHARACTER VARYING(4) 4
72 PINMAILER_CD CHARACTER VARYING(16) 16
73 PIN_CHANGE CHARACTER VARYING(4) 4
74 PIN_EXT CHARACTER VARYING(4) 4
75 PIN_KEY CHARACTER VARYING(8) 8
76 PIN_LENGTH SMALLINT 2
77 PIN_REQD CHARACTER VARYING(4) 4
78 PIN_RESP SMALLINT 2
79 PLASTIC CHARACTER VARYING(4) 4
80 PRODUCT_TY CHARACTER VARYING(4) 4
81 PROFIL SMALLINT 2
82 PROF_DESC CHARACTER VARYING(80) 80
83 PURCH_MSG SMALLINT 2
84 PURCH_RSP SMALLINT 2
85 PURCH_YN CHARACTER VARYING(4) 4
86 PVKI SMALLINT 2
87 PVV_YN CHARACTER VARYING(4) 4
88 RANGE_ID INTEGER 4
89 REISS_ACTV CHARACTER VARYING(4) 4
90 REISS_VAL SMALLINT 2
91 RETRY_RNW CHARACTER VARYING(4) 4
92 RND_EXP_DTE CHARACTER VARYING(4) 4
93 SAT_YN CHARACTER VARYING(4) 4
94 SERV_CODE CHARACTER VARYING(12) 12
95 SISSUECDE CHARACTER VARYING(4) 4
96 STIPYN CHARACTER VARYING(4) 4
97 SUN_YN CHARACTER VARYING(4) 4
98 THU_YN CHARACTER VARYING(4) 4
99 TRANS_ONLY CHARACTER VARYING(4) 4
100 TUE_YN CHARACTER VARYING(4) 4
101 VALID_EMB CHARACTER VARYING(4) 4
102 W2W_MSG SMALLINT 2
103 W2W_RSP SMALLINT 2
104 W2W_YN CHARACTER VARYING(4) 4
105 WED_YN CHARACTER VARYING(4) 4
106 WITHDRW_YN CHARACTER VARYING(4) 4
107 WITHDR_MSG SMALLINT 2
108 WITHDR_RSP SMALLINT 2
109 XFRFRM_MSG SMALLINT 2
110 XFRFRM_RSP SMALLINT 2
111 XFRFROM_YN CHARACTER VARYING(4) 4
112 YR_1ST_ISS SMALLINT 2
113 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
114 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
115 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
116 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8