AV_MERCH_NH_VW

(SQL View)
 Index Back

Campus Merchant Table

This table contains all the information related to a merchant.

SELECT SCC_MERCHANT_ID , DESCR , EFF_STATUS , CR_CARD_MERCHANT , CR_CARD_SERVER , CR_CARD_IP , SCC_EPAY_KEY_ID , SCC_EPAY_KEY_EXPDT , EC_VERIFICATION , EC_SETTLE_METHOD , CR_CARD_RISK , CR_CARD_RISK_THRES , CR_CARD_AVS , SCC_CVV_SUPPORTED , SCC_EPAY_INTG_ID , SCC_HPAY_INTG_ID , IB_OPERATIONNAME , SCC_EPAY_ACH_CLASS , SCC_EPAY_KEY_REQ , SCC_EPAY_HOSTEDPAY , CR_CARD_SRVC_PROV , SCC_EPAY_SEC_KEY FROM %Table(SCC_MERCHANT)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SCC_MERCHANT_ID Character(16) VARCHAR2(16) NOT NULL Payment Merchant ID
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

Default Value: A

4 CR_CARD_MERCHANT Character(16) VARCHAR2(16) NOT NULL Credit Card Merchant ID
5 CR_CARD_SERVER Character(28) VARCHAR2(28) NOT NULL Credit Card Processing Server
6 CR_CARD_IP Character(15) VARCHAR2(15) NOT NULL Credit Card IP Override
7 SCC_EPAY_KEY_ID Character(30) VARCHAR2(30) NOT NULL Security Key ID
8 SCC_EPAY_KEY_EXPDT Date(10) DATE Security Key Expiration Date
9 EC_VERIFICATION Character(1) VARCHAR2(1) NOT NULL Verification Level
1=Validation
2=Verification
10 EC_SETTLE_METHOD Character(1) VARCHAR2(1) NOT NULL Settlement Method
A=Automated Clearing House
B=Best possible
F=Facsimile draft
11 CR_CARD_RISK Character(1) VARCHAR2(1) NOT NULL Perform Check Risk Service

Y/N Table Edit

Default Value: N

12 CR_CARD_RISK_THRES Number(3,0) SMALLINT NOT NULL Check Risk Threshold
13 CR_CARD_AVS Character(1) VARCHAR2(1) NOT NULL Address Verification Flag
N=Address Verification Off
Y=Address Verification On

Default Value: N

14 SCC_CVV_SUPPORTED Character(1) VARCHAR2(1) NOT NULL CVV Required Field

Y/N Table Edit

15 SCC_EPAY_INTG_ID Character(20) VARCHAR2(20) NOT NULL Payment Integration ID (points to a payment adapter/application class)

Prompt Table: SCC_EP_EPAY_ADP

16 SCC_HPAY_INTG_ID Character(20) VARCHAR2(20) NOT NULL Payment Adapter for Hosted Payment and Electronic Payment Integration

Prompt Table: SCC_EP_HPAY_ADP

17 IB_OPERATIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation (see PSOPERATION).

Prompt Table: PSOPERATION

18 SCC_EPAY_ACH_CLASS Character(3) VARCHAR2(3) NOT NULL ACH Class
ARC=ARC
POP=POP
TEL=TEL
WEB=WEB

Default Value: POP

19 SCC_EPAY_KEY_REQ Character(1) VARCHAR2(1) NOT NULL Security Key Required

Y/N Table Edit

Default Value: N

20 SCC_EPAY_HOSTEDPAY Character(1) VARCHAR2(1) NOT NULL Security Key Required

Y/N Table Edit

Default Value: N

21 CR_CARD_SRVC_PROV Character(2) VARCHAR2(2) NOT NULL Credit Card Service Provider
01=Cybersource
02=TouchNet
99=Unsupported
22 SCC_EPAY_SEC_KEY Long Character CLOB Security Key