AV_EP_TRNSRQ_VW(SQL View) |
Index Back |
|---|
| SELECT b.institution , b.business_unit , a.merchant_id , a.scc_merchant_id , %TrimSubstr(c.fieldvalue,1,2) , d.xlatlongname FROM %Table(AV_MERCHANT_TBL) a , %Table(AV_BUS_UNIT_TBL) b , %Table(SCC_EP_PTRANS) c , PSXLATITEM d WHERE a.merchant_id = b.merchant_id AND a.scc_merchant_id = c.scc_merchant_id AND d.fieldname = 'CR_CARD_TRANS_LAST' AND d.fieldvalue = c.fieldvalue AND %TrimSubstr(c.fieldvalue,1,2) IN ('1','2','3','4') AND %EffdtCheck(PSXLATITEM, d, %CurrentDateIn) AND d.EFF_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | MERCHANT_ID | Character(12) | VARCHAR2(12) NOT NULL | Merchant ID |
| 4 | SCC_MERCHANT_ID | Character(16) | VARCHAR2(16) NOT NULL | Payment Merchant ID |
| 5 | CR_CARD_TRANS_LAST | Character(2) | VARCHAR2(2) NOT NULL |
Transaction Requested
1=Authorize 2=Authorize and Capture 3=Capture 4=Credit 5=eCheck Debit 6=eCheck Credit 91=Request Token 92=Authorize and Capture 93=Hosted Payment Credit |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |