Interaction Log Entry

    API Details

    Property Value
    Endpoint /tablesGeneral/interactionLogEntries
    Table name Interaction Log Entry
    Table id 5065
    Table caption Interaction Log Entry
    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
    entryNo Entry No. Integer 4 *
    contactNo Contact No. Code 20 Contact
    contactCompanyNo Contact Company No. Code 20
    date Date Date 4
    description Description Text 100
    informationFlow Information Flow Option 4 , Outbound, Inbound
    initiatedBy Initiated By Option 4 , Us, Them
    attachmentNo Attachment No. Integer 4 Attachment
    costLCY Cost (LCY) Decimal 12
    durationMin Duration (Min.) Decimal 12
    userID User ID Code 50 User
    interactionGroupCode Interaction Group Code Code 10 Interaction Group
    interactionTemplateCode Interaction Template Code Code 10 Interaction Template
    campaignNo Campaign No. Code 20 Campaign
    campaignEntryNo Campaign Entry No. Integer 4
    campaignResponse Campaign Response Boolean 4
    campaignTarget Campaign Target Boolean 4
    segmentNo Segment No. Code 20
    evaluation Evaluation Option 4 , Very Positive, Positive, Neutral, Negative, Very Negative
    timeOfInteraction Time of Interaction Time 4
    attemptFailed Attempt Failed Boolean 4
    todoNo Task No. Code 20 To-do
    salespersonCode Associate Code 20 Salesperson/Purchaser
    deliveryStatus Delivery Status Option 4 , In Progress, Error
    canceled Canceled Boolean 4
    correspondenceType Correspondence Type Option 4 , Hard Copy, Email, Fax
    contactAltAddressCode Contact Alt. Address Code Code 10
    loggedSegmentEntryNo Logged Segment Entry No. Integer 4 Logged Segment
    documentType Document Type Option 4 , Sales Qte., Sales Blnkt. Ord, Sales Ord. Cnfrmn., Sales Inv., Sales Shpt. Note, Sales Cr. Memo, Sales Stmnt., Sales Rmdr., Serv. Ord. Create, Serv. Ord. Post, Purch.Qte., Purch. Blnkt. Ord., Purch. Ord., Purch. Inv., Purch. Rcpt., Purch. Cr. Memo, Cover Sheet, Sales Return Order, Sales Finance Charge Memo, Sales Return Receipt, Purch. Return Shipment, Purch. Return Ord. Cnfrmn., Service Contract, Service Contract Quote, Service Quote, Sales Draft Invoice, VerhFactDiv, VerhFactBeh, LenFactUG, VerhFactS&V, 1eVerhNota, VerhCrNotaDiv, VerhCrNotaBeh, VerhCrNotaS&V, LenCrNotaUG, VerkFact, TerugkoopFact, VerhAanm, SlepBrief, BetalReg, Deurw, HuurVerh, RapBrief, OpdrBon, OpdrBonE-Mail, OnderhOff, VerhOff, Ond.Ord, VerhOrdBev, OnderhFact, OnderhCrNota, W1, HC, Eind, Contr, W2, W3, W4, W5, NormalProlongationInvoice, PostPurchInvoices, PostPurchCrMemos
    documentNo Document No. Code 20
    versionNo Version No. Integer 4
    docNoOccurrence Doc. No. Occurrence Integer 4
    contactVia Contact Via Text 80
    sendWordDocsAsAttmt Send Word Docs. as Attmt. Boolean 4
    interactionLanguageCode Interaction Language Code Code 10 Language
    eMailLogged Email Logged Boolean 4
    subject Subject Text 100
    opportunityNo Opportunity No. Code 20 Opportunity
    postponed Postponed Boolean 4
    wordTemplateCode Word Template Code Code 30
    merged Merged Boolean 4
    modifiedWordTemplate Modified Word Template Integer 4
    communicatiewijze Communication Method Code 30
    reminderNo Reminder No. Code 20
    tableID Table ID Integer 4
    reportID Report ID Integer 4
    position Position Text 250
    ogeNo OGE No. Code 20 OGE
    clusterNo Cluster No. Code 20 Cluster
    projectNo Project No. Code 20 Empire Project
    livabilityDossierNo Livability Dossier No. Code 20 Livability Dossier
    livDossierActionLineNo Liv. Dossier Action Line No. Integer 4
    creationDate Creation Date Date 4
    creationTime Creation Time Time 4
    defaultTeamCode Default Team Code Code 10 Team
    livDossierContactType Livability Dossier Contact Type Option 4 Involved Person, Caller, Initiator
    foundAggressive Found Aggressive Boolean 4
    aggresisonTypeCode Aggression Type Code Code 10 Agression Type
    aggressionExpDate Aggression Exp. Date Date 4
    createToDo Create Task Boolean 4
    createLivDossier Create Liv. Dossier Boolean 4
    createLivDossierAction Create Liv. Dossier Action Boolean 4
    exportedToEWorx Exported to eWorx Integer 4
    externalDocID External Document ID Integer 4
    showInCustomerPortal Show in Customer Portal Boolean 4
    templateDefaultValues Template Default Values Code 20 Template Default Values
    kbAnswerLogSetID KB Answer Log Set ID GUID 16
    veraContactMomentTypeCode VERA Contact Moment Type Code Code 10 VeraContactMomentTypeFDN
    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