User

    API Details

    Property Value
    Endpoint /tablesGeneral/users
    Table name User
    Table id 2000000120
    Table caption User
    Data per company False
    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
    userSecurityID User Security ID GUID 16 *
    userName User Name Code 50
    fullName Full Name Text 80
    state State Option 4 Enabled, Disabled
    expiryDate Expiry Date DateTime 8
    windowsSecurityID Windows Security ID Text 119
    changePassword Change Password Boolean 4
    licenseType License Type Option 4 Full User, Limited User, Device Only User, Windows Group, External User, External Administrator, External Accountant, Application, AAD Group
    authenticationEmail Authentication Email Text 250
    contactEmail Contact Email Text 250
    exchangeIdentifier Exchange Identifier Text 250
    applicationID Application ID GUID 16
    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