Customer

    API Details

    Property Value
    Endpoint /tablesGeneral/customers
    Table name Customer
    Table id 18
    Table caption Customer
    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 *
    name Name Text 100
    searchName Search Name Code 100
    name2 Name 2 Text 50
    address Address Text 100
    address2 Address 2 Text 50
    city City Text 30
    contact Contact Text 100
    phoneNo Phone No. Text 30
    telexNo Telex No. Text 20
    documentSendingProfile Document Sending Profile Code 20 Document Sending Profile
    shiptoCode Ship-to Code Code 10
    ourAccountNo Our Account No. Text 20
    territoryCode Territory Code Code 10 Territory
    globalDimension1Code Global Dimension 1 Code Code 20
    globalDimension2Code Global Dimension 2 Code Code 20
    chainName Chain Name Code 10
    budgetedAmount Budgeted Amount Decimal 12
    creditLimitLCY Credit Limit (LCY) Decimal 12
    customerPostingGroup Customer Posting Group Code 20 Customer Posting Group
    currencyCode Currency Code Code 10 Currency
    customerPriceGroup Customer Price Group Code 10 Customer Price Group
    languageCode Language Code Code 10 Language
    registrationNumber Registration No. Text 50
    statisticsGroup Statistics Group Integer 4
    paymentTermsCode Payment Terms Code Code 10 Payment Terms
    finChargeTermsCode Fin. Charge Terms Code Code 10 Finance Charge Terms
    salespersonCode Salesperson Code Code 20
    shipmentMethodCode Shipment Method Code Code 10 Shipment Method
    shippingAgentCode Shipping Agent Code Code 10 Shipping Agent
    placeOfExport Place of Export Code 20
    invoiceDiscCode Invoice Disc. Code Code 20 Customer
    customerDiscGroup Customer Disc. Group Code 20 Customer Discount Group
    countryRegionCode Country/Region Code Code 10 Country/Region
    collectionMethod Collection Method Code 20
    amount Amount Decimal 12
    blocked Blocked Option 4 , Ship, Invoice, All
    invoiceCopies Invoice Copies Integer 4
    lastStatementNo Last Statement No. Integer 4
    printStatements Print Statements Boolean 4
    billtoCustomerNo Bill-to Customer No. Code 20 Customer
    priority Priority Integer 4
    paymentMethodCode Payment Method Code Code 10 Payment Method
    formatRegion Format Region Text 80 Language Selection
    lastModifiedDateTime Last Modified Date Time DateTime 8
    lastDateModified Last Date Modified Date 4
    applicationMethod Application Method Option 4 Manual, Apply to Oldest
    pricesIncludingVAT Prices Including VAT Boolean 4
    locationCode Location Code Code 10
    faxNo Fax No. Text 30
    telexAnswerBack Telex Answer Back Text 20
    vatRegistrationNo VAT Registration No. Text 20
    combineShipments Combine Shipments Boolean 4
    genBusPostingGroup Gen. Bus. Posting Group Code 20 Gen. Business Posting Group
    gln GLN Code 13
    postCode Post Code Code 20
    county County Text 30
    eoriNumber EORI Number Text 40
    useGLNInElectronicDocument Use GLN in Electronic Documents Boolean 4
    eMail Email Text 80
    homePage Home Page Text 80
    reminderTermsCode Reminder Terms Code Code 10 Reminder Terms
    noSeries No. Series Code 20 No. Series
    taxAreaCode Tax Area Code Code 20 Tax Area
    taxLiable Tax Liable Boolean 4
    vatBusPostingGroup VAT Bus. Posting Group Code 20 VAT Business Posting Group
    reserve Reserve Option 4 Never, Optional, Always
    blockPaymentTolerance Block Payment Tolerance Boolean 4
    icPartnerCode IC Partner Code Code 20 IC Partner
    prepaymentPct Prepayment % Decimal 12
    partnerType Partner Type Option 4 , Company, Person
    intrastatPartnerType Intrastat Partner Type Option 4 , Company, Person
    excludeFromPmtPractices Exclude from Payment Practices Boolean 4
    image Image Media 16
    privacyBlocked Privacy Blocked Boolean 4
    disableSearchByName Disable Search by Name Boolean 4
    allowMultiplePostingGroups Allow Multiple Posting Groups Boolean 4
    preferredBankAccountCode Preferred Bank Account Code Code 20
    cashFlowPaymentTermsCode Cash Flow Payment Terms Code Code 10 Payment Terms
    primaryContactNo Primary Contact No. Code 20 Contact
    contactType Contact Type Option 4 Company, Person
    mobilePhoneNo Mobile Phone No. Text 30
    responsibilityCenter Responsibility Center Code 10 Responsibility Center
    shippingAdvice Shipping Advice Option 4 Partial, Complete
    shippingTime Shipping Time DateFormula 32
    shippingAgentServiceCode Shipping Agent Service Code Code 10
    serviceZoneCode Service Zone Code Code 10 Service Zone
    priceCalculationMethod Price Calculation Method Option 4 , Lowest Price, Test Price, Test Price (not Implemented)
    allowLineDisc Allow Line Disc. Boolean 4
    baseCalendarCode Base Calendar Code Code 10 Base Calendar
    copySelltoAddrToQteFrom Copy Sell-to Addr. to Qte From Option 4 Company, Person
    validateEUVatRegNo Validate EU VAT Reg. No. Boolean 4
    currencyId Currency Id GUID 16 Currency
    paymentTermsId Payment Terms Id GUID 16 Payment Terms
    shipmentMethodId Shipment Method Id GUID 16 Shipment Method
    paymentMethodId Payment Method Id GUID 16 Payment Method
    taxAreaID Tax Area ID GUID 16
    contactID Contact ID GUID 16
    contactGraphId Contact Graph Id Text 250
    oudNummer Old Number Code 20
    factuurtype Invoice Type Option 4 Geen, Factuur, Factuur + OLA, OLA
    telefoonOverdag Phone During Office Hours Text 30
    paymentSchemeCode Payment Scheme Code Code 20
    naam3 Name 3 Text 30
    naam4 Name 4 Text 30
    telefoon3 Phone No. 3 Text 30
    telefoon4 Phone No. 4 Text 30
    telefoon5 Phone No. 5 Text 30
    mobiel Mobile Phone No. Text 30
    mobiel2 Mobile Phone No. 2 Text 30
    mobiel3 Mobile Phone No. 3 Text 30
    mobiel4 Mobile Phone No. 4 Text 30
    mobiel5 Mobile Phone No. 5 Text 30
    email2 Email 2 Text 80
    email3 Email 3 Text 80
    email4 Email 4 Text 80
    email5 Email 5 Text 80
    transactiewijzeExcasso Transaction Mode Code Payment Code 20
    telefoon2 Phone 2 Text 30
    woningzoekende House Seeker Boolean 4
    geslacht Gender Option 4 , Man, Vrouw
    burgerlijkeStaat Marital Status Code 20 Marital Status
    soFinummer BSN No. Code 10
    woonbonnr Housing Coupon No. Code 10
    ihsGeblokkeerd IHS Blocked Boolean 4
    datumBlokkade Date Blocked Date 4
    buurt District Code 20 Neighbourhood
    handelsregisternr Trade Register No Text 20
    vatObligation VAT Obligation Boolean 4
    huurdersverklaring Tenant Statement Boolean 4
    contactNo Contact No. Code 20 Contact
    transactionModeCode Transaction Mode Code Code 20
    aanmaningsniveau Reminder Level Text 30
    customerType Customer Type Option 4 , Tenant, Resident/Owner, Financier
    sortingID Sorting ID Code 20
    combineInvoicesBy Combine Invoices by Option 4 Customer No., Contract No.
    automaticPosting Automatic Posting Boolean 4
    automaticAcceptRequests Automatic Accept Requests Boolean 4
    takeAwayMaterialChrgPercRC Take Away Material Charge % (RC) Decimal 12
    vendorChargePctRC Vendor Charge % (RC) Decimal 12
    vendorDiscountPctRC Vendor Discount % (RC) Decimal 12
    excludeFromMunicipalDebtAct Exclude From Export Municipal Debt Assistance Act Boolean 4
    customerPortalAccountStatus Customer Portal Account Status Option 4 AccountNotCreated, AccountCreatedNotActivated, AccountActivated, AccountBlocked
    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