Vendor

    API Details

    Property Value
    Endpoint /tablesFinance/vendors
    Table name Vendor
    Table id 23
    Table caption Vendor
    Data per company True
    Group Finance

    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
    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
    budgetedAmount Budgeted Amount Decimal 12
    vendorPostingGroup Vendor Posting Group Code 20 Vendor Posting Group
    currencyCode Currency Code Code 10 Currency
    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
    purchaserCode Purchaser Code Code 20
    shipmentMethodCode Shipment Method Code Code 10 Shipment Method
    shippingAgentCode Shipping Agent Code Code 10 Shipping Agent
    invoiceDiscCode Invoice Disc. Code Code 20 Vendor
    countryRegionCode Country/Region Code Code 10 Country/Region
    blocked Blocked Option 4 , Payment, All
    paytoVendorNo Pay-to Vendor No. Code 20 Vendor
    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
    faxNo Fax No. Text 30
    telexAnswerBack Telex Answer Back Text 20
    vatRegistrationNo VAT Registration No. Text 20
    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
    eMail Email Text 80
    homePage Home Page Text 80
    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
    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
    companySizeCode Company Size Code Code 20 Company Size
    image Image Media 16
    privacyBlocked Privacy Blocked Boolean 4
    disableSearchByName Disable Search by Name Boolean 4
    creditorNo Creditor No. Code 20
    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
    mobilePhoneNo Mobile Phone No. Text 30
    responsibilityCenter Responsibility Center Code 10 Responsibility Center
    locationCode Location Code Code 10
    leadTimeCalculation Lead Time Calculation DateFormula 32
    priceCalculationMethod Price Calculation Method Option 4 , Lowest Price, Test Price, Test Price (not Implemented)
    baseCalendarCode Base Calendar Code Code 10 Base Calendar
    documentSendingProfile Document Sending Profile Code 20 Document Sending Profile
    validateEUVatRegNo Validate EU VAT Reg. No. Boolean 4
    currencyId Currency Id GUID 16 Currency
    paymentTermsId Payment Terms Id GUID 16 Payment Terms
    paymentMethodId Payment Method Id GUID 16 Payment Method
    overReceiptCode Over-Receipt Code Code 20 Over-Receipt Code
    oudNummer Old number Code 20
    soort Type Option 4 Beheergever, VvE-
    telefoonOverdag Daytime Telephone Text 30
    naam3 Name 3 Text 30
    naam4 Name 4 Text 30
    telefoon3 Telephone 3 Text 30
    telefoon4 Telephone 4 Text 30
    telefoon5 Telephone 5 Text 30
    mobiel Mobile telephone Text 30
    mobiel2 Mobile Telephone 2 Text 30
    mobiel3 Mobile Telephone 3 Text 30
    mobiel4 Mobile Telephone 4 Text 30
    mobiel5 Mobile Telephone 5 Text 30
    emailAdresTbvOrders Email address for orders Text 80
    email3 Email 3 (notification quotes) Text 80
    email4 Email 4 (notification orders) Text 80
    email5 Email 5 (notification notes) Text 80
    handelsregisternr Registration No. Text 20
    contactNo Contact No. Code 20 Contact
    bedrijfsvereniging Business Association Code 20 Contact
    aansluitingsnrBedrijfsver Registration No. Business Association. Text 30
    loonbelastingnr Income Tax No. Text 30
    verklaringBelastingdienstDD Tax Declaration dd. Date 4
    verklaringBedrijfsverDd Declaration Company Insurance d.d. Date 4
    zzPverklaringDd Freelance Declaration d.d. Date 4
    transactionModeCode Transaction Mode Code Code 20
    vendorType Vendor Type Option 4 , Owner, Association Of Owners, Bailiff
    showOrdersPendingApproval Orders Pending Approval Boolean 4
    finishTasksFromPortal Finished Tasks From Portal Boolean 4
    showPurchaseOrders Purchase Boolean 4
    showDailyMaintOrders Daily Maintenance Boolean 4
    showPlannedMaintOrders Planned Maintenance Boolean 4
    showJobOrders Jobs Boolean 4
    purchaseMethodCode Purchase Method Code Code 20 Purchase Method
    allowChangingBAccountPortal Allow Changing B-Account % on Vendor Portal Boolean 4
    orderMatchApprTolerancePct Order Match Approval Tolerance Pct. Decimal 12
    orderMatchApprToleranceAmt Order Match Approval Tolerance Amount Decimal 12
    automaticPosting Automatic Posting Boolean 4
    numberOfPlanningOptions Number of Planning Options Integer 4
    rsinNo RSIN No. Text 20
    takeAwayMaterials Take Away Materials 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