PSMERCHANTID

index back

  • Related language record: PSMERCHANTIDLNG
  • Parent record of PSMERCHBI
  • PeopleSoft Field NameField TypeColumn TypeDescription
    MERCHANTIDCharacter(30)VARCHAR2(30) NOT NULLMerchant ID
    EFFDTDate(10)DATE NOT NULLEffective Date

    Default: %date

    DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
    DESCRSHORTCharacter(10)VARCHAR2(10) NOT NULLShort Description
    MERCHINSTALLEDCharacter(1)VARCHAR2(1) NOT NULLMerchant Enabled

    Y/N Table Edit

    Default: N

    MRCHUIDTYPECharacter(3)VARCHAR2(3) NOT NULLMerchant User ID Type
    CID=Company Identifier
    EID=Employee ID + Company ID
    EML=EMail Address
    OID=Operator ID + Company ID
    COMPANYIDCharacter(15)VARCHAR2(15) NOT NULLCompany ID
    CMPAUTHNTCTNTOKENCharacter(64)VARCHAR2(64) NOT NULLCompany Authentication Token
    RELATIONSHIPMNGRCharacter(50)VARCHAR2(50) NOT NULLRelationship Manager
    RELMNGREMAILCharacter(70)VARCHAR2(70) NOT NULLRelationship Manager Email
    RELMNGRPHONENBRCharacter(24)VARCHAR2(24) NOT NULLRelationship Manager Phone
    MERCHWSITEURLCharacter(254)VARCHAR2(254) NOT NULLMerchant Website URL
    MRCHIMAGENAMECharacter(30)VARCHAR2(30) NOT NULLMerchant Logo
    OBJECTOWNERIDCharacter(4)VARCHAR2(4) NOT NULLObject owner identifier translate values
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19