Please enable JavaScript to view this site.

Error itgendoc001X

xMsg javascript has not been loaded.

Exact Online API Data Model

Navigation: Catalog: ExactOnlineREST > Schemas > Schema: CRM > Tables

AccountsFullTextSearch: Exact Online Accounts Full-Text Search

Contents Previous Home Next More

Search for legal counter parties using a text query.

Catalog: ExactOnlineREST

Schema: CRM

Primary Keys: ID

Label: Accounts Full-Text Search

The data in this table is partitioned per value of the Division column.

This is a read-only table function. The Exact Online API may not support changing the data or the Invantive SQL driver for Exact Online does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Exact Online API.

Select Exact Online API URL: /api/v1/{division}/read/crm/AccountsFullTextSearch

Insert Exact Online API URL: /api/v1/{division}/read/crm/AccountsFullTextSearch

Update Exact Online API URL: /api/v1/{division}/read/crm/AccountsFullTextSearch

Delete Exact Online API URL: /api/v1/{division}/read/crm/AccountsFullTextSearch

Exact Online API Metadata URL: /api/v1/{division}/read/crm/$metadata

Field Selection Method: Required

Table Function Parameters

The following parameters can be used to control the behaviour of the table function AccountsFullTextSearch. A value must be provided at all times for required parameters, but optional parameters in general do not need to have a value and the execution will default to a pre-defined behaviour. Values can be specified by position and by name. In both cases, all parameters not specified will be treated using their default values.

Value specification by position is done by listing all values from the first to the last needed value. For example with `select * from table(value1, value2, value3)` on a table with four parameters will use the default value for the fourth parameter and the specified values for the first three.

Value specification by name is done by listing all values that require a value. For example with `select * from table(name1 => value1, name3 => value3)` on the same table will use the default values for the second and fourth parameters and the specified values for the first and third.

Name

Data Type

Required

Default Value

Documentation

division

int32

 

ID of the division to retrieve data for.

searchText

string

 

 

 

Table Function Columns

The columns of the table function AccountsFullTextSearch are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

Accountant

guid

Accountant

 

AccountManager

guid

Account Manager

 

AccountManagerFullName

string(240)

Account Manager Full Name

 

AccountManagerHID

int32

Account Manager HID

 

ActivitySector

guid

Activity Sector

 

ActivitySubSector

guid

Activity Subsector

 

AddressLine1

string(80)

Address Line 1

Visit address first line.

AddressLine2

string(80)

Address Line 2

Second address line.

AddressLine3

string(80)

Address Line 3

Third address line.

Blocked

boolean

Blocked

 

BRIN

guid

BRIN

 

BSN

string

Social Security Number

Citizen Service Number for the Netherlands.

BusinessType

guid

Business Type

 

CanDropShip

boolean

Can Drop Ship

 

ChamberOfCommerce

string(20)

Chamber of Commerce

Chamber of commerce number.

City

string(30)

City

City.

Classification

string

Classification

 

Classification1

guid

Classification 1

 

Classification2

guid

Classification 2

 

Classification3

guid

Classification 3

 

Classification4

guid

Classification 4

 

Classification5

guid

Classification 5

 

Classification6

guid

Classification 6

 

Classification7

guid

Classification 7

 

Classification8

guid

Classification 8

 

ClassificationDescription

string

Classification Description

 

Code

string

Code

 

CodeAtSupplier

string(20)

Code at Supplier

Code under which your own company is known at the account.

CompanySize

guid

Company Size

 

ConsolidationScenario

int16

Consolidation Scenario

 

ControlledDate

datetime

Date Checked

 

Costcenter

string(8)

Cost Center

 

CostcenterDescription

string(60)

Cost Center Description

 

CostPaid

int16

Cost Paid

 

Country

string(30)

Country

Country code.

CountryName

string

Country Name

Country name.

Created

datetime

Created

Creation date.

CreatedUtc

datetime

Created (UTC)

Creation date in UTC.

Creator

guid

Creator

User ID of creator.

CreatorFullName

string(240)

Creator Full Name

Name of creator.

CreditLinePurchase

double

Credit Line for Purchase

 

CreditLineSales

double

Credit Line for Sales

 

Currency

string(30)

Currency

Code of Currency.

CustomerSince

datetime

Customer Since

 

DatevCreditorCode

string(30)

DATEV Creditor Code

 

DatevDebtorCode

string(30)

DATEV Debtor Code

 

DeliveryAdvice

int16

 

 

DiscountPurchase

double

Discount for Purchase

 

DiscountSales

double

Discount for Sales

 

Division

int32

Division

 

DivisionCompanyCoCNumber

string(20)

Division Chamber of Commerce Number

Chamber of commerce number of the Exact Online division.

DivisionCompanyIBANNumber

string(50)

Division IBAN Number

IBAN number of the Exact Online division.

DivisionCompanyName

string(50)

Division Company Name

Company name of the Exact Online division.

DivisionCompanyRSINNumber

string(9)

Division RSIN Number

RSIN number of the Exact Online division.

DivisionCompanyVATNumber

string(35)

Division VAT Number

VAT number of the Exact Online division.

DivisionCompanyWageTaxNumber

string(60)

Division Wage Tax Number

Wage tax number of the Exact Online division.

DivisionLabel

string(128)

Division Label

Label of the Exact Online division.

DivisionName

string(50)

Administration Name

Name of the Exact Online division.

DivisionOwnerCompanyName

string(50)

Subscription Holder Name

Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs.

DivisionOwnerCompanyNumber

string(18)

Subscription Holder Number

Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs.

DivisionShortName

int64

Division Short Name

Short name of the Exact Online division.

Document

guid

Document

 

DunsNumber

string(9)

DUNS Number

 

Email

string(128)

Email

 

EndDate

datetime

End Date

 

EstablishedDate

datetime

Established Date

 

Fax

string(25)

Fax

Fax number.

GLAccountPurchase

guid

GL Account for Purchase

 

GLAccountSales

guid

GL Account for Sales

 

GLAP

guid

Accounts Payables General Ledger

 

GLAR

guid

Accounts Receivables General Ledger

 

GlnNumber

string(13)

GLN Number

Global Location Number can be used by companies to identify their locations, giving them complete flexibility to identify any type or level of location required.

HasWithholdingTaxSales

boolean

Has Withholding Tax Sales

 

ID

guid

ID

 

IgnoreDatevWarningMessage

boolean

Ignore DATEV Warning Message

 

IntraStatArea

string

Intrastat Area

 

IntraStatDeliveryTerm

string

Intrastat Delivery Term

 

IntraStatSystem

string(5)

Intrastat System

 

IntraStatTransactionA

string(1)

Intrastat Transaction A

 

IntraStatTransactionB

string(1)

Intrastat Transaction B

 

IntraStatTransportMethod

string(1)

Intrastat Transport Method

 

InvoiceAccount

guid

Invoice Account

 

InvoiceAccountCode

string(18)

Invoice Account Code

 

InvoiceAccountName

string(50)

Invoice Account Name

Name of account.

InvoiceAttachmentType

int32

Invoice Attachment Type

 

InvoicingMethod

int32

Invoicing Method

 

IsAccountant

int16

Is Accountant

 

IsAgency

int16

Is Agency

 

IsAnonymised

int16

Is Anonymised

Indicates whether the account is anonymised.

IsBank

boolean

Is Bank

 

IsCompetitor

int16

Is Competitor

 

IsExtraDuty

boolean

Is Extra Duty

 

IsMailing

int16

Is Mailing

 

IsMember

boolean

Is Member

 

IsPilot

boolean

Is Pilot

 

IsPurchase

boolean

Is Purchase

 

IsReseller

boolean

Is Reseller

 

IsSales

boolean

Is Sales

 

IsSupplier

boolean

Is Supplier

 

Language

string(30)

Language

Language code.

LanguageDescription

string(60)

Language Description

Language description.

Latitude

double

Latitude

 

LeadPurpose

guid

Lead Purpose

Reference to Lead Purpose of an account.

LeadSource

guid

Lead Source

 

Logo

byte[]

Logo

 

LogoFileName

string

Logo File Name

 

LogoThumbnailUrl

string

Logo Thumbnail (URL)

 

LogoUrl

string

Logo (URL)

 

Longitude

double

Longitude

 

MainContact

guid

Main Contact

 

Modified

datetime

Modified

Last modified date.

ModifiedUtc

datetime

Modified (UTC)

Last modified date in UTC.

Modifier

guid

Modifier

User ID of modifier.

ModifierFullName

string(240)

Modified Full Name

Name of modifier.

Name

string(50)

Name

Name of account.

OINNumber

string(20)

OIN Number

Dutch government identification number.

Parent

guid

Parent

 

PayAsYouEarn

string

Pay-as-you-Earn

 

PaymentConditionPurchase

string(2)

Payment Condition Purchase

 

PaymentConditionPurchaseDescription

string(60)

Payment Condition Purchase Description

 

PaymentConditionSales

string(2)

Payment Condition Sales

 

PaymentConditionSalesDescription

string(60)

Payment Condition Sales Description

 

Phone

string(25)

Phone

Phone number.

PhoneExtension

string(15)

Phone Extension

Phone number extension.

Postcode

string(20)

Postal Code

Postcode.

PriceList

guid

Price List

 

PurchaseCurrency

string(30)

Purchase Currency

Currency of purchase.

PurchaseCurrencyDescription

string(60)

Purchase Currency Description

Description of purchase currency.

PurchaseLeadDays

int32

Purchase Lead Days

 

PurchaseVATCode

string(3)

Purchase VAT Code

Purchase VAT code.

PurchaseVATCodeDescription

string(60)

Purchase VAT Code Description

Description of Purchase VAT code.

RecepientOfCommissions

boolean

Recipient of Commissions

 

Remarks

string

Remarks

 

Reseller

guid

Reseller

 

ResellerCode

string(18)

Reseller Code

Code of Reseller.

ResellerName

string(50)

Reseller Name

Name of reseller.

RSIN

string

RSIN Number

Fiscal number for NL legislation.

SalesCurrency

string(30)

Sales Currency

Currency of sales price.

SalesCurrencyDescription

string(60)

Sales Currency Description

Description of sales currency.

SalesTaxSchedule

guid

Sales Tax Schedule

 

SalesTaxScheduleCode

string

Sales Tax Schedule Code

 

SalesTaxScheduleDescription

string

Sales Tax Schedule Description

 

SalesVATCode

string(3)

Sales VAT Code

Sales VAT code.

SalesVATCodeDescription

string(60)

Sales VAT Code Description

Description of Sales VAT code.

SearchCode

string(15)

Search Code

Search code.

SecurityLevel

int32

Security Level

 

SeparateInvPerProject

int16

Separate Invoice per Project

 

SeparateInvPerSubscription

int16

Separate Invoice per Subscription

 

ShippingLeadDays

int32

Shipping Lead Days

 

ShippingMethod

guid

Shipping Method

 

ShowRemarkForSales

boolean

Show Remark for Sales

 

StartDate

datetime

Start Date

 

State

string(30)

State

State/Province code.

StateName

string(60)

State

Name of state/province.

Status

string(1)

Status

If the status field is filled this means the account is a customer. The value indicates the customer status. Possible values: A=None, S=Suspect, P=Prospect, C=Customer.

StatusSince

datetime

Status Since

 

TradeName

string(50)

Tradename

 

Type

string(1)

Type

Account type: Values: A = Relation, D = Division.

UniqueTaxpayerReference

string

Unique Taxpayer Reference

 

VATLiability

string

VAT Liability

 

VATNumber

string(35)

VAT Number

VAT number.

Website

string(128)

Website

Website of the account.

 

07-11-2021 09:07 Version 20.2.94-PROD+3513