Segment Line

    API Details

    Property Value
    Endpoint /tablesGeneral/segmentLines
    Table name Segment Line
    Table id 5077
    Table caption Segment Line
    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
    segmentNo Segment No. Code 20 * Segment Header
    lineNo Line No. Integer 4 *
    contactNo Contact No. Code 20 Contact
    campaignNo Campaign No. Code 20 Campaign
    salespersonCode Salesperson Code Code 20
    correspondenceType Correspondence Type Option 4 , Hard Copy, Email, Fax
    interactionTemplateCode Interaction Template Code Code 10 Interaction Template
    costLCY Cost (LCY) Decimal 12
    durationMin Duration (Min.) Decimal 12
    attachmentNo Attachment No. Integer 4 Attachment
    campaignResponse Campaign Response Boolean 4
    informationFlow Information Flow Option 4 , Outbound, Inbound
    initiatedBy Initiated By Option 4 , Us, Them
    contactAltAddressCode Contact Alt. Address Code Code 10
    evaluation Evaluation Option 4 , Very Positive, Positive, Neutral, Negative, Very Negative
    campaignTarget Campaign Target Boolean 4
    languageCode Language Code Code 10 Language
    description Description Text 100
    date Date Date 4
    timeOfInteraction Time of Interaction Time 4
    attemptFailed Attempt Failed Boolean 4
    todoNo Task No. Code 20 To-do
    contactCompanyNo Contact Company No. Code 20
    campaignEntryNo Campaign Entry No. Integer 4 Campaign Entry
    interactionGroupCode Interaction Group Code Code 10 Interaction Group
    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
    sendWordDocAsAttmt Send Word Doc. As Attmt. Boolean 4
    contactVia Contact Via Text 80
    versionNo Version No. Integer 4
    docNoOccurrence Doc. No. Occurrence Integer 4
    subject Subject Text 100
    opportunityNo Opportunity No. Code 20 Opportunity
    wordTemplateCode Word Template Code Code 30
    merged Merged Boolean 4
    wizardStep Wizard Step Option 4 , 1, 2, 3, 4, 5, 6
    wizardContactName Wizard Contact Name Text 100
    opportunityDescription Opportunity Description Text 100
    campaignDescription Campaign Description Text 100
    interactionSuccessful Interaction Successful Boolean 4
    dialContact Dial Contact Boolean 4
    mailContact Mail Contact Boolean 4
    communicationType Communication Type Code 30
    docTemplateCode Document Template Code Code 20 Doc Template
    tableID Table ID Integer 4
    reportID Report ID Integer 4
    position Position Text 250
    ogeNo Realty Object No. Code 20 OGE
    clusterNo Cluster No. Code 20 Cluster
    projectNo Project No. Code 20 Empire Project
    createToDo Create Task Boolean 4
    createLivDossier Create Liv. Dossier Boolean 4
    livabilityDossierNo Livability Dossier No. Code 20 Livability Dossier
    livDossierActionLineNo Liv. Dossier Action Line No. Integer 4
    createLivDossierAction Create Liv. Dossier Action Boolean 4
    livDossierContactType Liv. Dossier Contact Type Option 4 Involved Person, Caller, Initiator
    livDossierType Liv. Dossier Type Code 10 Liv. Dossier Type
    defaultTeamCode Default Team Code Code 10 Team
    reportParameters Report Parameters Text 2048
    foundAggressive Found Aggressive Boolean 4
    aggresisonTypeCode Aggression Type Code Code 10 Agression Type
    aggressionExpDate Aggression Exp. Date Date 4
    reminderNo Reminder No. Code 20
    linkID Link ID Integer 4
    addDocuments Add Documents Boolean 4
    externalDocID External Document ID Integer 4
    showInCustomerPortal Show in Customer Portal Boolean 4
    templateDefaultValues Template Default Values Code 20
    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