Associate

    API Details

    Property Value
    Endpoint /tablesGeneral/salespersonPurchasers
    Table name Salesperson/Purchaser
    Table id 13
    Table caption Associate
    Data per company True
    Group General

    Schema

    erd

    Properties

    Property Table Fieldname Type Max.Length Key Options Table relation Version introduced Version removed Obsolete state Obsolete reason
    id System Id GUID 16
    code Code Code 20 *
    name Name Text 50
    commissionPct Commission % Decimal 12
    image Image Media 16
    privacyBlocked Privacy Blocked Boolean 4
    globalDimension1Code Global Dimension 1 Code Code 20
    globalDimension2Code Global Dimension 2 Code Code 20
    eMail Email Text 80
    phoneNo Phone No. Text 30
    jobTitle Job Title Text 30
    searchEMail Search Email Code 80
    eMail2 Email 2 Text 80
    blocked Blocked Boolean 4
    firstName First Name Text 30
    middleName Middle Name Text 30
    surname Last Name Text 30
    initials Initials Text 30
    salutationCode Salutation Code Code 10 Salutation
    name2 Name 2 Text 30
    name3 Name 3 Text 30
    name4 Name 4 Text 30
    extension Extension Text 30
    responsibilityCenter Responsibility Center Code 10 Responsibility Center
    mobilePhoneNo Mobile Phone No. Text 30
    defaultTeamCode Default Team Code Code 10
    livDossierModification Liv. Dossier Modification Option 4 All, Team, Own
    dmsUser DMS User Boolean 4
    systemId System ID GUID 16
    systemCreatedAt Created At DateTime 8
    systemCreatedBy Created By GUID 16 User
    systemModifiedAt Modified At DateTime 8
    systemModifiedBy Modified By GUID 16 User
    lastModifiedDateTime Last Modified Date Time DateTime 8