MERCHANT_TBL_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SF_MERCHANT_ID	Character(12)	VARCHAR2(12) NOT NULL	SF Merchant ID
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
3	SF_MERCHANT_PROC	Character(1)	VARCHAR2(1) NOT NULL	Process Option C=Credit Card E=Electronic Check
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_CHECK_DIGT	Character(1)	VARCHAR2(1) NOT NULL	Check Digit Edit Y/N Table Edit Default Value: Y
16	SF_GET_BILL_ADDR	Character(1)	VARCHAR2(1) NOT NULL	Get Billing Address Y/N Table Edit Default Value: Y
17	ADDR_USAGE	Character(10)	VARCHAR2(10) NOT NULL	Address Usage Prompt Table: ADDR_USAGE_TBL
18	SF_GET_BILL_PHONE	Character(1)	VARCHAR2(1) NOT NULL	Get Telephone Y/N Table Edit Default Value: Y
19	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
20	NAME_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Type of Name Prompt Table: NAME_TYPE_TBL
21	LS_CONTACT_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Contact Type
22	SF_GET_EMAIL_ADDR	Character(1)	VARCHAR2(1) NOT NULL	Get Email Address Y/N Table Edit Default Value: Y
23	EMAILID	Character(70)	VARCHAR2(70) NOT NULL	A user's E-mail address
24	CR_CARD_TRANS_ERR	Number(3,0)	SMALLINT NOT NULL	Batch Transmission Error
25	SF_DEFAULT_EMAIL	Character(1)	VARCHAR2(1) NOT NULL	Default Email Y/N Table Edit Default Value: N
26	CR_CARD_PROD_CD	Character(20)	VARCHAR2(20) NOT NULL	Credit Card Product Code
27	CR_CARD_PROD_NAME	Character(30)	VARCHAR2(30) NOT NULL	Credit Card Product Name
28	CR_CARD_SKU	Character(15)	VARCHAR2(15) NOT NULL	Credit Card Product SKU
29	CR_CARD_SCHRG_AMT	Number(18,2)	DECIMAL(17,2) NOT NULL	Surcharge Amount
30	CR_CARD_SCHRG_OPT	Character(1)	VARCHAR2(1) NOT NULL	Credit Card Surcharge Option F=Fixed Amount P=Percentage
31	CR_CARD_SCHRG_PCT	Number(12,8)	DECIMAL(11,8) NOT NULL	Surcharge Percentage
32	PAYMENT_AMT_MIN	Number(19,3)	DECIMAL(18,3) NOT NULL	Minimum Payment Amount
33	PAYMENT_AMT_MAX	Number(19,3)	DECIMAL(18,3) NOT NULL	Maximum Payment Amount
34	EC_SETTLE_METHOD	Character(1)	VARCHAR2(1) NOT NULL	Settlement Method A=Automated Clearing House B=Best possible F=Facsimile draft Default Value: B
35	EC_VERIFICATION	Character(1)	VARCHAR2(1) NOT NULL	Verification Level 1=Validation 2=Verification Default Value: 1
36	EC_DEBIT	Character(1)	VARCHAR2(1) NOT NULL	eCheck Debit Y/N Table Edit Default Value: N
37	EC_CREDIT	Character(1)	VARCHAR2(1) NOT NULL	eCheck Credit Y/N Table Edit Default Value: N
38	EC_AUTH_METHOD	Character(3)	VARCHAR2(3) NOT NULL	Authentication Method BDT=Birthdate NID=National ID Number NOA=No Authentication PIN=PIN Default Value: PIN