PSMERCHANTID

(SQL Table)
Index Back

  • Related Language Record: PSMERCHANTIDLNG
  • Parent Record Of PSMERCHBI
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 MERCHANTID Character(30) VARCHAR2(30) NOT NULL Merchant ID
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    5 MERCHINSTALLED Character(1) VARCHAR2(1) NOT NULL Merchant Enabled

    Y/N Table Edit

    Default Value: N

    6 MRCHUIDTYPE Character(3) VARCHAR2(3) NOT NULL Merchant User ID Type
    CID=Company Identifier
    EID=Employee ID + Company ID
    EML=EMail Address
    OID=Operator ID + Company ID
    7 COMPANYID Character(15) VARCHAR2(15) NOT NULL Company ID
    8 CMPAUTHNTCTNTOKEN Character(64) VARCHAR2(64) NOT NULL Company Authentication Token
    9 RELATIONSHIPMNGR Character(50) VARCHAR2(50) NOT NULL Relationship Manager
    10 RELMNGREMAIL Character(70) VARCHAR2(70) NOT NULL Relationship Manager Email
    11 RELMNGRPHONENBR Character(24) VARCHAR2(24) NOT NULL Relationship Manager Phone
    12 MERCHWSITEURL Character(254) VARCHAR2(254) NOT NULL Merchant Website URL
    13 MRCHIMAGENAME Character(30) VARCHAR2(30) NOT NULL Merchant Logo
    14 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier