MERCHANT_IDN=No
Y=Yes
N=No
Y=Yes
AV_EP_MERCVV_VW(SQL View) |
Index Back |
|---|
| SELECT b.merchant_id , a.scc_merchant_id , a.scc_cvv_supported , b.av_collect_cvv_ss , av_collect_cvv_bat FROM ps_scc_merchant a , PS_AV_MERCHANT_TBL b WHERE a.scc_merchant_id = b.scc_merchant_id |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | MERCHANT_ID |
Character(12) | VARCHAR2(12) NOT NULL | Merchant ID |
| 2 | SCC_MERCHANT_ID | Character(16) | VARCHAR2(16) NOT NULL | Payment Merchant ID |
| 3 | SCC_CVV_SUPPORTED | Character(1) | VARCHAR2(1) NOT NULL | CVV Required Field |
| 4 | AV_COLLECT_CVV_SS | Character(1) | VARCHAR2(1) NOT NULL |
Security Code - Self Service
N=No Y=Yes |
| 5 | AV_COLLECT_CVV_BAT | Character(1) | VARCHAR2(1) NOT NULL |
Security Code - Batch
N=No Y=Yes |