MERCHANT_TBL

(SQL Table)
Index Back

Merchant Table

This table contains all the information related to an SF merchant.

  • Related Language Record: MERCHANT_TBLLNG
  • # 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

    Default Value: C

    4 CR_CARD_MERCHANT Character(16) VARCHAR2(16) NOT NULL Credit Card Merchant ID

    Prompt Table: SCC_MERCHANT

    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

    Prompt Table: ORG_CNT_TYP_TBL

    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

    39 SCC_MERCHANT_ID Character(16) VARCHAR2(16) NOT NULL Payment Merchant ID

    Prompt Table: SCC_MERCHANT

    40 SSF_COLLECT_CVV Character(1) VARCHAR2(1) NOT NULL Collect CVV

    Y/N Table Edit

    Default Value: N

    41 SSF_SHARED_SECRET Character(20) VARCHAR2(20) NOT NULL Shared Secret

    Prompt Table: SSF_SH_SECR_ADP