AV_MERCHANT_TBL

(SQL Table)
Index Back

Contrib Rel Merchant Table

Contributor Relations Merchant Table

# 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

Prompt Table: AV_MERCH_NH_VW

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
4 CR_CARD_MERCHANT Character(16) VARCHAR2(16) NOT NULL Credit Card Merchant ID
5 CR_CARD_SRVC_PROV Character(2) VARCHAR2(2) NOT NULL Credit Card Service Provider
01=Cybersource
02=TouchNet
99=Unsupported
6 CR_CARD_SERVER Character(28) VARCHAR2(28) NOT NULL Credit Card Processing Server
7 CR_CARD_IP Character(15) VARCHAR2(15) NOT NULL Credit Card IP Override
8 CR_CARD_AUTH Character(1) VARCHAR2(1) NOT NULL Credit Card Authorization

Y/N Table Edit

Default Value: N

9 CR_CARD_BILL Character(1) VARCHAR2(1) NOT NULL Credit Card Settlement

Y/N Table Edit

Default Value: N

10 CR_CARD_CREDIT Character(1) VARCHAR2(1) NOT NULL Credit Card Credit

Y/N Table Edit

Default Value: N

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 CR_CARD_TRAN_RETRY Number(3,0) SMALLINT NOT NULL Transaction Transmission Retry
15 CR_CARD_TRACE Character(1) VARCHAR2(1) NOT NULL A
C=Vendor Trace
N=Production
P=Connect with Trace
T=No Connect with Trace
16 NAME_TYPE Character(3) VARCHAR2(3) NOT NULL Type of Name

Prompt Table: NAME_TYPE_TBL

17 ADDRESS_TYPE Character(4) VARCHAR2(4) NOT NULL Address Type

Prompt Table: ADDRESS_TYP_TBL

18 PHONE_TYPE Character(4) VARCHAR2(4) NOT NULL Phone Type
BUSN=Business
CAMP=Campus
CELL=Mobile
DORM=Dormitory
FAX=FAX
HOME=Home
MAIN=Main
OTR=Other
PGR1=Pager 1
PGR2=Pager 2
TELX=Telex
WORK=Work
19 E_ADDR_TYPE Character(4) VARCHAR2(4) NOT NULL Email Address Type. Note: Dorm long name has been updated as Dormitory as part of PI26 updates. And, the owner id of the field is updated to CC from HR.
BUSN=Business
CAMP=Campus
DORM=Dormitory
HOME=Home
OTHR=Other
20 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email Address
21 AV_COLLECT_CVV_BAT Character(1) VARCHAR2(1) NOT NULL Security Code - Batch
N=No
Y=Yes

Default Value: N

22 AV_COLLECT_CVV_SS Character(1) VARCHAR2(1) NOT NULL Security Code - Self Service
N=No
Y=Yes

Default Value: N