Task

    API Details

    Property Value
    Endpoint /tablesGeneral/todos
    Table name To-do
    Table id 5080
    Table caption Task
    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 *
    teamCode Team Code Code 10 Team
    salespersonCode Employee Code Code 20
    campaignNo Campaign No. Code 20 Campaign
    contactNo Contact No. Code 20 Contact
    opportunityNo Opportunity No. Code 20 Opportunity
    segmentNo Segment No. Code 20 Segment Header
    type Type Option 4 , Meeting, Phone Call, Judge, Call-back, Judge and Call-back, Digest, Team Task for One
    date Starting Date Date 4
    status Status Option 4 Not Started, In Progress, Completed, Waiting, Postponed
    priority Priority Option 4 Low, Normal, High
    description Description Text 100
    closed Closed Boolean 4
    dateClosed Closing Date Date 4
    noSeries No. Series Code 20 No. Series
    canceled Canceled Boolean 4
    contactCompanyNo Contact Company No. Code 20
    recurring Recurring Boolean 4
    recurringDateInterval Recurring Date Interval DateFormula 32
    calcDueDateFrom Calc. Due Date From Option 4 , Due Date, Closing Date
    startTime Starting Time Time 4
    duration Duration Duration 8
    opportunityEntryNo Opportunity Entry No. Integer 4 Opportunity Entry
    lastDateModified Last Date Modified Date 4
    lastTimeModified Last Time Modified Time 4
    allDayEvent All Day Event Boolean 4
    location Location Text 100
    organizerTodoNo Organizer Task No. Code 20 To-do
    interactionTemplateCode Interaction Template Code Code 10 Interaction Template
    languageCode Language Code Code 10 Language
    attachmentNo Attachment No. Integer 4
    subject Subject Text 100
    unitCostLCY Unit Cost (LCY) Decimal 12
    unitDurationMin Unit Duration (Min.) Decimal 12
    systemTodoType System Task Type Option 4 Organizer, Salesperson Attendee, Contact Attendee, Team
    completedBy Completed By Code 20 Salesperson/Purchaser
    endingDate Ending Date Date 4
    endingTime Ending Time Time 4
    wizardStep Wizard Step Option 4 , 1, 2, 3, 4, 5, 6
    teamTodo Team Task Boolean 4
    sendOnFinish Send on finish Boolean 4
    segmentDescription Segment Description Text 100
    teamMeetingOrganizer Team Meeting Organizer Code 20
    activityCode Activity Code Code 10 Activity
    wizardContactName Wizard Contact Name Text 100
    wizardCampaignDescription Wizard Campaign Description Text 100
    wizardOpportunityDescription Wizard Opportunity Description Text 100
    livabilityDossierNo Livability Dossier No. Code 20 Livability Dossier
    interactionLogEntryNo Interaction Log Entry Integer 4
    livDossierActionLineNo Livability Dossier Action Line No. Integer 4
    createdBy Created by (ID) Code 50 User
    creationDate Creation Date Date 4
    creationTime Creation Time Time 4
    contactAsOriginator Contact as Originator Boolean 4
    reparatieverzoeknr Maintenance Request No. Code 20
    eenheidnr Realty Object No. Code 20 OGE
    contractvolgnr Contract Entry No. Integer 4
    tableID Table No. Integer 4
    closedBy Closed by (ID) Code 50 User
    modifiedBy Modified By (ID) Code 50 User
    defaultTeamCode Default Team Code Code 10 Team
    externalDocID External Document No. Integer 4
    maintContractNo Maintenance Contract No. Code 20
    maintenanceTaskNo Maintenance Task No. Code 20 DM - Maintenance Task
    organizerTodo Organizer Task 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