Employee

    API Details

    Property Value
    Endpoint /tablesGeneral/employees
    Table name Employee
    Table id 5200
    Table caption Employee
    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
    no No. Code 20 *
    firstName First Name Text 30
    middleName Middle Name Text 30
    lastName Last Name Text 30
    initials Initials Text 30
    jobTitle Job Title Text 30
    searchName Search Name Code 250
    address Address Text 100
    address2 Address 2 Text 50
    city City Text 30
    postCode Post Code Code 20
    county County Text 30
    phoneNo Phone No. Text 30
    mobilePhoneNo Mobile Phone No. Text 30
    eMail Email Text 80
    altAddressCode Alt. Address Code Code 10
    altAddressStartDate Alt. Address Start Date Date 4
    altAddressEndDate Alt. Address End Date Date 4
    birthDate Birth Date Date 4
    socialSecurityNo Social Security No. Text 30
    unionCode Union Code Code 10 Union
    unionMembershipNo Union Membership No. Text 30
    gender Gender Option 4 , Female, Male, Non-binary, Self-Described, I don’t wish to answer
    countryRegionCode Country/Region Code Code 10 Country/Region
    managerNo Manager No. Code 20 Employee
    emplymtContractCode Emplymt. Contract Code Code 10 Employment Contract
    statisticsGroupCode Statistics Group Code Code 10 Employee Statistics Group
    employmentDate Employment Date Date 4
    status Status Option 4 Active, Inactive, Terminated
    inactiveDate Inactive Date Date 4
    causeOfInactivityCode Cause of Inactivity Code Code 10 Cause of Inactivity
    terminationDate Termination Date Date 4
    groundsForTermCode Grounds for Term. Code Code 10 Grounds for Termination
    globalDimension1Code Global Dimension 1 Code Code 20
    globalDimension2Code Global Dimension 2 Code Code 20
    resourceNo Resource No. Code 20
    lastDateModified Last Date Modified Date 4
    extension Extension Text 30
    pager Pager Text 30
    faxNo Fax No. Text 30
    companyEMail Company Email Text 80
    title Title Text 30
    salespersPurchCode Salespers./Purch. Code Code 20
    noSeries No. Series Code 20 No. Series
    lastModifiedDateTime Last Modified Date Time DateTime 8
    employeePostingGroup Employee Posting Group Code 20 Employee Posting Group
    bankBranchNo Bank Branch No. Text 20
    bankAccountNo Bank Account No. Text 30
    iban IBAN Code 50
    swiftCode SWIFT Code Code 20 SWIFT Code
    applicationMethod Application Method Option 4 Manual, Apply to Oldest
    image Image Media 16
    privacyBlocked Privacy Blocked Boolean 4
    costCenterCode Cost Center Code Code 20 Cost Center
    costObjectCode Cost Object Code Code 20 Cost Object
    oudNummer Oud nummer Code 20
    contactNo Contact No. Code 20 Contact
    overlijdensdatum Date of Death Date 4
    transactionModeCode Transaction Mode Code Code 20
    bankName Bank Name Text 100
    bankCity Bank City Text 30
    postCodeHouseNo Post Code + House No. Code 20
    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