HMMS_TTCSR_MRCH_MASTER
Description
Synonyms
SDSNZP02_BANK..BTTPS_HMMS_TTCSR_MRCH_MASTER
SDSNZP02_BANK..NROD_HMMS_TTCSR_MRCH_MASTER
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | MRCH_COID | INTEGER | 4 |
| 2 | MRCH_PROD | CHARACTER(3) | 3 |
| 3 | MRCH_NBR | CHARACTER(23) | 23 |
| 4 | MRCH_REL_TYP_IND | CHARACTER(1) | 1 |
| 5 | FIID | CHARACTER(10) | 10 |
| 6 | PRIN_BK | CHARACTER(4) | 4 |
| 7 | ASSOC_BK | CHARACTER(4) | 4 |
| 8 | RGN_NBR | CHARACTER(4) | 4 |
| 9 | CTL_ACCT | CHARACTER(23) | 23 |
| 10 | CTL_ACCT_TYP | CHARACTER(1) | 1 |
| 11 | CHN_CTL_ACCT | CHARACTER(23) | 23 |
| 12 | AGT_CTL_ACCT | CHARACTER(23) | 23 |
| 13 | MRCH_DESC_NM | CHARACTER(25) | 25 |
| 14 | MRCH_DESC_CTY | CHARACTER(13) | 13 |
| 15 | MRCH_DESC_ST | CHARACTER(3) | 3 |
| 16 | ST_SLS_TAX_CD | CHARACTER(3) | 3 |
| 17 | CNTY_SLS_TAX_CD | CHARACTER(3) | 3 |
| 18 | CTY_SLS_TAX_CD | CHARACTER(3) | 3 |
| 19 | CONTACT_NM | CHARACTER(25) | 25 |
| 20 | CONTACT_PH_NBR | CHARACTER(15) | 15 |
| 21 | CONTACT_PH_EXT | NUMERIC(5,0) | 19 |
| 22 | DDA_COID | INTEGER | 4 |
| 23 | DDA_PROD_CD | CHARACTER(3) | 3 |
| 24 | DDA_ACCT_NBR | CHARACTER(23) | 23 |
| 25 | DDA_TR_NBR | CHARACTER(10) | 10 |
| 26 | COST_CTR | NUMERIC(15,0) | 19 |
| 27 | OFF | CHARACTER(5) | 5 |
| 28 | CLASS | CHARACTER(15) | 15 |
| 29 | BLLNG_CYC | NUMERIC(3,0) | 19 |
| 30 | BLLNG_MET | CHARACTER(3) | 3 |
| 31 | CURR_STAT | CHARACTER(3) | 3 |
| 32 | PREV_STAT | CHARACTER(3) | 3 |
| 33 | MRCH_CATG_CD | CHARACTER(4) | 4 |
| 34 | MAIL_CD | CHARACTER(3) | 3 |
| 35 | LANG | CHARACTER(3) | 3 |
| 36 | SENS_CD | CHARACTER(1) | 1 |
| 37 | CNTRY_CD | CHARACTER(3) | 3 |
| 38 | MC_TXN_TYP | CHARACTER(1) | 1 |
| 39 | MC_CUR_CD | CHARACTER(3) | 3 |
| 40 | MC_CUR_EXPON | SMALLINT | 2 |
| 41 | AGT_REL_IND | CHARACTER(1) | 1 |
| 42 | SNL_MRCH_IND | CHARACTER(1) | 1 |
| 43 | ACTIVE_MRCH_IND | CHARACTER(1) | 1 |
| 44 | RPM_INTFCE_IND | CHARACTER(1) | 1 |
| 45 | EMP_IND | CHARACTER(1) | 1 |
| 46 | DISC_WAVD_IND | CHARACTER(1) | 1 |
| 47 | V_WB_SNL_ML_IND | CHARACTER(1) | 1 |
| 48 | IMPR_WAVD_IND | CHARACTER(1) | 1 |
| 49 | PLAS_REQ_IND | CHARACTER(1) | 1 |
| 50 | PLAT_REQ_IND | CHARACTER(1) | 1 |
| 51 | REPRT_STMT_IND | CHARACTER(1) | 1 |
| 52 | SNAP_IND | CHARACTER(1) | 1 |
| 53 | LTR_REQ_IND | CHARACTER(1) | 1 |
| 54 | INCM_EXP_IND | CHARACTER(1) | 1 |
| 55 | FGN_MRCH_IND | CHARACTER(1) | 1 |
| 56 | PERM_CMNT_IND | CHARACTER(1) | 1 |
| 57 | DTL_RPT_REQ_IND | CHARACTER(1) | 1 |
| 58 | MRCH_TYP_IND | CHARACTER(1) | 1 |
| 59 | OWN_TYPE_IND | CHARACTER(1) | 1 |
| 60 | DR_CONS_CD | CHARACTER(1) | 1 |
| 61 | STMT_CONS_CD | CHARACTER(1) | 1 |
| 62 | CSH_PRCH | CHARACTER(1) | 1 |
| 63 | DFT_SUBM_MET | CHARACTER(1) | 1 |
| 64 | MTD_UNUSUAL_ACTY | CHARACTER(1) | 1 |
| 65 | LTR_IND | CHARACTER(1) | 1 |
| 66 | ADVC_IND | CHARACTER(1) | 1 |
| 67 | STMT_IND | CHARACTER(1) | 1 |
| 68 | LST_MAINT_DT | CHARACTER(10) | 10 |
| 69 | LST_MAINT_TM | CHARACTER(8) | 8 |
| 70 | LST_MAINT_OPER | CHARACTER(8) | 8 |
| 71 | LST_MAINT_TERM | CHARACTER(8) | 8 |
| 72 | LST_NON_FIN_CHNG | CHARACTER(10) | 10 |
| 73 | LST_FIN_ACTY_DT | CHARACTER(10) | 10 |
| 74 | LST_FIN_ACTY_TYP | CHARACTER(3) | 3 |
| 75 | LST_ACTY_AMT | NUMERIC(13,2) | 19 |
| 76 | LST_STAT_CHNG_DT | CHARACTER VARYING(30) | 30 |
| 77 | OP_DT | CHARACTER VARYING(30) | 30 |
| 78 | CLS_DT | CHARACTER VARYING(30) | 30 |
| 79 | CLS_RSN_CD | CHARACTER(3) | 3 |
| 80 | INACT_DT | CHARACTER VARYING(30) | 30 |
| 81 | LST_STMT_DT | CHARACTER VARYING(30) | 30 |
| 82 | FIRST_DEP_DT | CHARACTER VARYING(30) | 30 |
| 83 | PRIOR_DEP_DT | CHARACTER VARYING(30) | 30 |
| 84 | PRIOR_DEP_AMT | NUMERIC(13,2) | 19 |
| 85 | LST_DEP_DT | CHARACTER VARYING(30) | 30 |
| 86 | LST_DEP_AMT | NUMERIC(13,2) | 19 |
| 87 | DEP_01_IND | CHARACTER(1) | 1 |
| 88 | DEP_02_IND | CHARACTER(1) | 1 |
| 89 | DEP_03_IND | CHARACTER(1) | 1 |
| 90 | DEP_04_IND | CHARACTER(1) | 1 |
| 91 | DEP_05_IND | CHARACTER(1) | 1 |
| 92 | DEP_06_IND | CHARACTER(1) | 1 |
| 93 | DEP_07_IND | CHARACTER(1) | 1 |
| 94 | DEP_08_IND | CHARACTER(1) | 1 |
| 95 | DEP_09_IND | CHARACTER(1) | 1 |
| 96 | DEP_10_IND | CHARACTER(1) | 1 |
| 97 | DEP_11_IND | CHARACTER(1) | 1 |
| 98 | DEP_12_IND | CHARACTER(1) | 1 |
| 99 | LST_TERM_CHRG_DT | CHARACTER VARYING(30) | 30 |
| 100 | LST_IMPR_CHRG_DT | CHARACTER VARYING(30) | 30 |
| 101 | LST_TOT_UPDT_DT | CHARACTER VARYING(30) | 30 |
| 102 | LST_DISC_CHNG_DT | CHARACTER VARYING(30) | 30 |
| 103 | LST_CMNT_DT | CHARACTER VARYING(30) | 30 |
| 104 | MIN_DISC_CHRG | NUMERIC(9,2) | 19 |
| 105 | COST_FACTOR | CHARACTER(3) | 3 |
| 106 | LST_FRD_DT | CHARACTER VARYING(30) | 30 |
| 107 | ICHG_ZIP_CODE | CHARACTER(9) | 9 |
| 108 | EFF_DISC_RT | NUMERIC(7,4) | 19 |
| 109 | VISA_RIS_COND | CHARACTER(1) | 1 |
| 110 | VISA_MRCH_IND | CHARACTER(1) | 1 |
| 111 | LST_BAL_AMT | NUMERIC(13,2) | 19 |
| 112 | VISA_MAIL_PHONE | CHARACTER(1) | 1 |
| 113 | APPLY_MIN_DISC | CHARACTER(1) | 1 |
| 114 | LST_CHRGBK_DT | CHARACTER VARYING(30) | 30 |
| 115 | LST_CHRGBK_AMT | NUMERIC(13,2) | 19 |
| 116 | LST_ADJ_DT | CHARACTER VARYING(30) | 30 |
| 117 | LST_ADJ_AMT | NUMERIC(13,2) | 19 |
| 118 | ACCT_CNVTD_DT | CHARACTER VARYING(30) | 30 |
| 119 | REMIT_MRCH_IND | CHARACTER(1) | 1 |
| 120 | SLIP_CPTR_IND | CHARACTER(1) | 1 |
| 121 | NPF_FREQ_IND | CHARACTER(1) | 1 |
| 122 | VISA_REPS_IND | CHARACTER(1) | 1 |
| 123 | CAID_NBR | NUMERIC(15,0) | 19 |
| 124 | ADMIN_FEE | NUMERIC(5,2) | 19 |
| 125 | PCT_RT | NUMERIC(7,4) | 19 |
| 126 | ITM_FEE | CHARACTER(1) | 1 |
| 127 | ITM_FEE_TBL | CHARACTER(5) | 5 |
| 128 | PLAS_PLAT_ITD | NUMERIC(5,0) | 19 |
| 129 | PLAS_PLAT_MTD | NUMERIC(5,0) | 19 |
| 130 | FRAUD_TXNS_ITD | NUMERIC(5,0) | 19 |
| 131 | FRAUD_TXNS_MTD | NUMERIC(5,0) | 19 |
| 132 | TERMINALS_ITD | NUMERIC(5,0) | 19 |
| 133 | TERMINALS_MTD | NUMERIC(5,0) | 19 |
| 134 | IMPRINTERS_ITD | NUMERIC(5,0) | 19 |
| 135 | IMPRINTERS_MTD | NUMERIC(5,0) | 19 |
| 136 | CHARGEBACKS_ITD | NUMERIC(5,0) | 19 |
| 137 | CHARGEBACKS_CTD | NUMERIC(5,0) | 19 |
| 138 | OL_LTRS_ITD | NUMERIC(5,0) | 19 |
| 139 | OL_LTRS_MTD | NUMERIC(5,0) | 19 |
| 140 | INCOME | NUMERIC(13,2) | 19 |
| 141 | EXPENSE | NUMERIC(13,2) | 19 |
| 142 | MARGIN | NUMERIC(7,4) | 19 |
| 143 | AVG_MTD_VOL | NUMERIC(11,0) | 19 |
| 144 | BTCH_LTRS_ITD | NUMERIC(5,0) | 19 |
| 145 | BTCH_LTRS_MTD | NUMERIC(5,0) | 19 |
| 146 | AVG_CALC_DT | CHARACTER VARYING(30) | 30 |
| 147 | AVG_GRS_CNT | NUMERIC(7,0) | 19 |
| 148 | AVG_GRS_AMT | NUMERIC(13,2) | 19 |
| 149 | AVG_TKT | NUMERIC(13,2) | 19 |
| 150 | AVG_ELPS_TM | NUMERIC(3,0) | 19 |
| 151 | AVG_CHRBK_CNT | NUMERIC(7,0) | 19 |
| 152 | RMK_CD | CHARACTER(1) | 1 |
| 153 | CUR_GRS_CNT | NUMERIC(7,0) | 19 |
| 154 | CUR_GRS_AMT | NUMERIC(13,2) | 19 |
| 155 | CUR_AGGR_DYS | NUMERIC(9,0) | 19 |
| 156 | CUR_CHRBK_CNT | NUMERIC(7,0) | 19 |
| 157 | GRS_CNT2 | NUMERIC(7,0) | 19 |
| 158 | GRS_AMT2 | NUMERIC(13,2) | 19 |
| 159 | AGGR_DYS2 | NUMERIC(9,0) | 19 |
| 160 | CHRBK_CNT2 | NUMERIC(7,0) | 19 |
| 161 | GRS_CNT3 | NUMERIC(7,0) | 19 |
| 162 | GRS_AMT3 | NUMERIC(13,2) | 19 |
| 163 | AGGR_DYS3 | NUMERIC(9,0) | 19 |
| 164 | CHRBK_CNT3 | NUMERIC(7,0) | 19 |
| 165 | GRS_CNT4 | NUMERIC(7,0) | 19 |
| 166 | GRS_AMT4 | NUMERIC(13,2) | 19 |
| 167 | AGGR_DYS4 | NUMERIC(9,0) | 19 |
| 168 | CHRBK_CNT4 | NUMERIC(7,0) | 19 |
| 169 | GRS_CNT5 | NUMERIC(7,0) | 19 |
| 170 | GRS_AMT5 | NUMERIC(13,2) | 19 |
| 171 | AGGR_DYS5 | NUMERIC(9,0) | 19 |
| 172 | CHRBK_CNT5 | NUMERIC(7,0) | 19 |
| 173 | GRS_CNT6 | NUMERIC(7,0) | 19 |
| 174 | GRS_AMT6 | NUMERIC(13,2) | 19 |
| 175 | AGGR_DYS6 | NUMERIC(9,0) | 19 |
| 176 | CHRBK_CNT6 | NUMERIC(7,0) | 19 |
| 177 | CHRGBK_REV_ITD | NUMERIC(7,0) | 19 |
| 178 | CHRGBK_REV_CTD | NUMERIC(7,0) | 19 |
| 179 | SEND_WB_IND | CHARACTER(1) | 1 |
| 180 | MEDIA | CHARACTER(1) | 1 |
| 181 | REGION | CHARACTER(1) | 1 |
| 182 | QUANTITY | NUMERIC(5,0) | 19 |
| 183 | DIST_FREQUENCY | CHARACTER(1) | 1 |
| 184 | DIST_METHOD | CHARACTER(2) | 2 |
| 185 | SUSP_REASON | CHARACTER(2) | 2 |
| 186 | START_DATE | CHARACTER VARYING(30) | 30 |
| 187 | LAST_TXN_DATE | CHARACTER VARYING(30) | 30 |
| 188 | LAST_TXN_ACTION | CHARACTER(1) | 1 |
| 189 | ATTN_OF | CHARACTER(20) | 20 |
| 190 | MEDIA_M | CHARACTER(1) | 1 |
| 191 | REGION_M | CHARACTER(2) | 2 |
| 192 | DIST_FREQ_M | CHARACTER(1) | 1 |
| 193 | DIST_METH_M | CHARACTER(2) | 2 |
| 194 | SUSP_RSN_M | CHARACTER(2) | 2 |
| 195 | QUANTITY_M | NUMERIC(5,0) | 19 |
| 196 | AMEX_JCB | CHARACTER(10) | 10 |
| 197 | DINERS | CHARACTER(10) | 10 |
| 198 | MOBILE_NBR | CHARACTER(15) | 15 |
| 199 | FAX_NBR | CHARACTER(15) | 15 |
| 200 | EMAIL_ADDR | CHARACTER(60) | 60 |
| 201 | SALES_AGENT_CD | CHARACTER(7) | 7 |
| 202 | SITE_ADDR0 | CHARACTER(40) | 40 |
| 203 | SITE_ADDR1 | CHARACTER(40) | 40 |
| 204 | SITE_ADDR2 | CHARACTER(40) | 40 |
| 205 | SITE_CITY | CHARACTER(25) | 25 |
| 206 | SITE_STATE | CHARACTER(3) | 3 |
| 207 | SITE_PCODE | CHARACTER(4) | 4 |
| 208 | HOME_PHN_NBR | CHARACTER(15) | 15 |
| 209 | ABN_NBR | NUMERIC(11,0) | 19 |
| 210 | PRIORITY_MEMO | CHARACTER(60) | 60 |
| 211 | CT_START | CHARACTER VARYING(30) | 30 |
| 212 | CT_TERM | NUMERIC(3,0) | 19 |
| 213 | REFUND_LIMIT | NUMERIC(9,2) | 19 |
| 214 | VAS_CODE1 | CHARACTER(3) | 3 |
| 215 | VAS_DATE1 | CHARACTER VARYING(30) | 30 |
| 216 | VAS_CODE2 | CHARACTER(3) | 3 |
| 217 | VAS_DATE2 | CHARACTER VARYING(30) | 30 |
| 218 | VAS_CODE3 | CHARACTER(3) | 3 |
| 219 | VAS_DATE3 | CHARACTER VARYING(30) | 30 |
| 220 | VAS_CODE4 | CHARACTER(3) | 3 |
| 221 | VAS_DATE4 | CHARACTER VARYING(30) | 30 |
| 222 | VAS_CODE5 | CHARACTER(3) | 3 |
| 223 | VAS_DATE5 | CHARACTER VARYING(30) | 30 |
| 224 | VAS_CODE6 | CHARACTER(3) | 3 |
| 225 | VAS_DATE6 | CHARACTER VARYING(30) | 30 |
| 226 | VAS_CODE7 | CHARACTER(3) | 3 |
| 227 | VAS_DATE7 | CHARACTER VARYING(30) | 30 |
| 228 | VAS_CODE8 | CHARACTER(3) | 3 |
| 229 | VAS_DATE8 | CHARACTER VARYING(30) | 30 |
| 230 | VAS_CODE9 | CHARACTER(3) | 3 |
| 231 | VAS_DATE9 | CHARACTER VARYING(30) | 30 |
| 232 | VAS_CODE10 | CHARACTER(3) | 3 |
| 233 | VAS_DATE10 | CHARACTER VARYING(30) | 30 |
| 234 | VAS_CODE11 | CHARACTER(3) | 3 |
| 235 | VAS_DATE11 | CHARACTER VARYING(30) | 30 |
| 236 | VAS_CODE12 | CHARACTER(3) | 3 |
| 237 | VAS_DATE12 | CHARACTER VARYING(30) | 30 |
| 238 | VAS_CONTACT_FL | CHARACTER(1) | 1 |
| 239 | PROMOTION_CODE | CHARACTER(6) | 6 |
| 240 | SETTLE_IND | CHARACTER(1) | 1 |
| 241 | MRCH_CATG_CD_DESC | CHARACTER(40) | 40 |
| 242 | MRCH_MINOR_ID | CHARACTER(8) | 8 |
| 243 | MRCH_INDUSTRY_RATE | CHARACTER(20) | 20 |
| 244 | MRCH_BATCH | CHARACTER(1) | 1 |
| 245 | MRCH_TXN_SRC | CHARACTER(2) | 2 |
| 246 | MRCH_AUTH_CAP | CHARACTER(10) | 10 |
| 247 | MRCH_URL | CHARACTER(40) | 40 |
| 248 | SPECIAL_INSTR | CHARACTER(200) | 200 |
| 249 | USERNAME | CHARACTER(15) | 15 |
| 250 | PASSWORD | CHARACTER(15) | 15 |
| 251 | TRADE_OPEN | CHARACTER(5) | 5 |
| 252 | TRADE_CLOSE | CHARACTER(5) | 5 |
| 253 | COMPLIANCE_START_DATE | CHARACTER VARYING(30) | 30 |
| 254 | COMPLIANCE_END_DATE | CHARACTER VARYING(30) | 30 |
| 255 | CNP_FLAG | CHARACTER(1) | 1 |
| 256 | MAIL_DATE | CHARACTER VARYING(30) | 30 |
| 257 | CDC_SOURCE_SYSTEM_CODE | CHARACTER VARYING(4) | 4 |
| 258 | CDC_RECORD_TYPE | CHARACTER VARYING(16) | 16 |
| 259 | CDC_COMMIT_TIMESTAMP | TIMESTAMP | 8 |
| 260 | CDC_EXTRACT_TIMESTAMP | TIMESTAMP | 8 |