PSMERCHANTID

index back

  • Related language record: PSMERCHANTIDLNG
  • Parent record of PSMERCHBI
  • PeopleSoft Field Name Field Type Column Type Description
    MERCHANTID Character(30) VARCHAR2(30) NOT NULL Merchant ID
    EFFDT Date(10) DATE NOT NULL Effective Date

    Default: %date

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

    Y/N Table Edit

    Default: N

    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
    COMPANYID Character(15) VARCHAR2(15) NOT NULL Company ID
    CMPAUTHNTCTNTOKEN Character(64) VARCHAR2(64) NOT NULL Company Authentication Token
    RELATIONSHIPMNGR Character(50) VARCHAR2(50) NOT NULL Relationship Manager
    RELMNGREMAIL Character(70) VARCHAR2(70) NOT NULL Relationship Manager Email
    RELMNGRPHONENBR Character(24) VARCHAR2(24) NOT NULL Relationship Manager Phone
    MERCHWSITEURL Character(254) VARCHAR2(254) NOT NULL Merchant Website URL
    MRCHIMAGENAME Character(30) VARCHAR2(30) NOT NULL Merchant Logo
    OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier translate values
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19