AV_MERCHANT_TBL(SQL Table) |
Index Back |
---|---|
Contrib Rel Merchant TableContributor 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 |