invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

AccountsFullTextSearch: Exact Online Accounts Full-Text Search

read only per partition REST

  • Catalogus: ExactOnlineREST
  • Schema: CRM
  • Primaire sleutels: ID
  • Label: Accounts Full-Text Search

Search for legal counter parties using a text query.

De gegevens in deze tabel zijn gepartitioneerd per waarde van de kolom Division.

Kan alleen gegevens ophalen.

API-bron

  • Eindpunt: /api/v1/{division}/read/crm/AccountsFullTextSearch
  • Metagegevens: /api/v1/{division}/read/crm/$metadata

Prestatiekenmerken

Characteristic Value
Gemiddelde toegangsvertraging (ms) 5
Aantal rijen per minuut bij volledige scan 7,200
Aantal rijen per minuut in een Query 300
Aantal rijen per minuut schrijven 300

Het resultaat kan op de client in de Cache worden opgeslagen.

Parameters

Name Datatype Required Default Documentation
division int32 ID of the division to retrieve data for.
searchText varchar2

Tabelkolommen

De kolommen van de tabel AccountsFullTextSearch worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.

Name Datatype Label Required Marks Documentation
AccountManager guid Verkoper filters on the platform, writable
AccountManagerFullName varchar2(240) Accountmanager Volledige Naam filters on the platform, writable
AccountManagerHID int32 Verkoper HID filters on the platform, writable
Accountant guid Accountant filters on the platform, writable
ActivitySector guid Sector filters on the platform, writable
ActivitySubSector guid Activiteit Subsector filters on the platform, writable
AddressLine1 varchar2(80) Adresregel 1 filters on the platform, writable Visit address first line.
AddressLine2 varchar2(80) Adresregel 2 filters on the platform, writable Second address line.
AddressLine3 varchar2(80) Adresregel 3 filters on the platform, writable Third address line.
AddressSource int16 Adresbron filters on the platform, writable
AutomaticProcessProposedEntry int16 Automatisch Verwerken Voorgestelde Boeking filters op het platform
BRIN guid BRIN filters on the platform, writable
BSN varchar2 Burgerservicenummer filters on the platform, writable Citizen Service Number for the Netherlands.
Blocked char Blocked filters on the platform, writable
BusinessType guid Bedrijfstype filters on the platform, writable
CanDropShip char Kan Drop Shipment filters on the platform, writable
ChamberOfCommerce varchar2(60) Kamer van Koophandel filters on the platform, writable Chamber of commerce number.
City varchar2(30) City filters on the platform, writable City.
Classification varchar2 Classification filters on the platform, writable
Classification1 guid Classificatie 1 filters on the platform, writable
Classification2 guid Classificatie 2 filters on the platform, writable
Classification3 guid Classificatie 3 filters on the platform, writable
Classification4 guid Classificatie 4 filters on the platform, writable
Classification5 guid Classificatie 5 filters on the platform, writable
Classification6 guid Classificatie 6 filters on the platform, writable
Classification7 guid Classificatie 7 filters on the platform, writable
Classification8 guid Classificatie 8 filters on the platform, writable
ClassificationDescription varchar2 Classificatie Omschrijving filters on the platform, writable
Code varchar2 Code filters on the platform, writable
CodeAtSupplier varchar2(20) Code bij Leverancier filters on the platform, writable Code under which your own company is known at the account.
CompanySize guid Bedrijfsomvang filters on the platform, writable
ConsolidationScenario int16 Consolidatie Scenario filters on the platform, writable
ControlledDate datetime Datum Gecontroleerd filters on the platform, writable
CostPaid int16 Kosten Betaald filters on the platform, writable
Costcenter varchar2(8) Kostenplaats filters on the platform, writable
CostcenterDescription varchar2(60) Kostenplaats Omschrijving filters on the platform, writable
Country varchar2(30) Country filters on the platform, writable Country code.
CountryName varchar2 Landsnaam filters on the platform, writable Country name.
Created datetime Created filters on the platform, writable Creation date.
CreatedUtc datetime Aangemaakt (UTC) writable Creation date in UTC.
Creator guid Creator filters on the platform, writable User ID of creator.
CreatorFullName varchar2(240) Aanmaker Volledige Naam filters on the platform, writable Name of creator.
CreditLinePurchase double Kredietlijn voor Inkoop filters on the platform, writable
CreditLineSales double Kredietlijn voor Verkoop filters on the platform, writable
Currency varchar2(30) Currency filters on the platform, writable Code of Currency.
CustomField varchar2 Aangepast Veld filters on the platform, writable
CustomerSince datetime Klant Sinds filters on the platform, writable
DatevCreditorCode varchar2(30) DATEV Crediteurcode filters on the platform, writable
DatevDebtorCode varchar2(30) DATEV Debiteurencode filters on the platform, writable
DeliveryAdvice int16 Leveringsadvies filters op het platform
DiscountPurchase double Korting voor Aankoop filters on the platform, writable
DiscountSales double Korting voor Verkoop filters on the platform, writable
Division int32 Division writable
DivisionCompanyCoCNumber varchar2(60) Divisie Kamer van Koophandel Nummer writable Chamber of commerce number of the Exact Online division.
DivisionCompanyIBANNumber varchar2(50) Divisie IBAN Nummer writable IBAN number of the Exact Online division.
DivisionCompanyName varchar2(50) Divisie Bedrijfsnaam writable Company name of the Exact Online division.
DivisionCompanyRSINNumber varchar2(9) Divisie RSIN Nummer writable RSIN number of the Exact Online division.
DivisionCompanyVATNumber varchar2(35) Divisie BTW Nummer writable VAT number of the Exact Online division.
DivisionCompanyWageTaxNumber varchar2(60) Divisie Loonbelastingnummer writable Wage tax number of the Exact Online division.
DivisionLabel varchar2(128) Divisie Label writable Label of the Exact Online division.
DivisionName varchar2(50) Administratie Naam writable Name of the Exact Online division.
DivisionOwnerCompanyName varchar2(50) Naam Abonnementhouder writable Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs.
DivisionOwnerCompanyNumber varchar2(18) Abonnementhoudernummer writable Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs.
DivisionShortName int64 Divisie Korte Naam writable Short name of the Exact Online division.
Document guid Document filters on the platform, writable
DunsNumber varchar2(9) DUNS Nummer filters on the platform, writable
EORINumber varchar2 EORI-nummer writable EORI number (United Kingdom).
Email varchar2(128) Email filters on the platform, writable
EnableSalesPaymentLink char Schakel Verkoopbetalingslink in filters op het platform
EndDate datetime Einddatum filters on the platform, writable
EstablishedDate datetime Datum Opgericht filters on the platform, writable
Fax varchar2(25) Fax filters on the platform, writable Fax number.
GLAP guid Crediteuren Grootboek filters on the platform, writable
GLAR guid Debiteuren Grootboek filters on the platform, writable
GLAccountPurchase guid Grootboekrekening voor Inkoop filters on the platform, writable
GLAccountSales guid Grootboekrekeing voor Verkoop filters on the platform, writable
GlnNumber varchar2(13) GLN Nummer filters on the platform, writable 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 char Heeft Bronbelasting Verkoop filters on the platform, writable
ID guid ID filters on the platform, writable
IgnoreDatevWarningMessage char Negeer DATEV Waarschuwingsbericht filters on the platform, writable
IncotermAddressPurchase varchar2 Incoterm-adres Inkoop filters on the platform, writable
IncotermAddressSales varchar2 Incoterm-adres Verkoop filters on the platform, writable
IncotermCodePurchase varchar2 Incoterm-code Inkoop filters on the platform, writable
IncotermCodeSales varchar2 Incoterm Verkoopcode filters on the platform, writable
IncotermVersionPurchase int16 Incoterm-versie Inkoop filters on the platform, writable
IncotermVersionSales int16 Incoterm-versie Verkoop filters on the platform, writable
IntraStatArea varchar2 Intrastat Gebied filters on the platform, writable
IntraStatDeliveryTerm varchar2 Intrastat Afleverconditie filters on the platform, writable
IntraStatSystem varchar2(5) Intrastat Systeem filters on the platform, writable
IntraStatTransactionA varchar2(1) Intrastat Transactie A filters on the platform, writable
IntraStatTransactionB varchar2(1) Intrastat Transactie B filters on the platform, writable
IntraStatTransportMethod varchar2(1) Intrastat Transportmethode filters on the platform, writable
InvoiceAccount guid Factuurrekening filters on the platform, writable
InvoiceAccountCode varchar2(18) Factuur Account Code filters on the platform, writable
InvoiceAccountName varchar2(50) Factuur Accountnaam filters on the platform, writable Name of account.
InvoiceAttachmentType int32 Factuur Bijlagesoort filters on the platform, writable
InvoicingMethod int32 Facturatiemethode filters on the platform, writable
IsAccountant int16 Is Accountant filters on the platform, writable
IsAgency int16 Is Instantie filters on the platform, writable
IsAnonymised int16 Is Geanonimiseerd filters on the platform, writable Indicates whether the account is anonymised.
IsBank char Is Bank filters on the platform, writable
IsCompetitor int16 Is Concurrent filters on the platform, writable
IsExtraDuty char Is Extra Belasting filters on the platform, writable
IsMailing int16 Is Mailing filters on the platform, writable
IsMember char Is Lid filters on the platform, writable
IsPilot char Is Pilot filters on the platform, writable
IsPurchase char Is Aankoop filters on the platform, writable
IsReseller char Is Wederverkoper filters on the platform, writable
IsSales char Is Verkoop filters on the platform, writable
IsSupplier char Is Leverancier filters on the platform, writable
Language varchar2(30) Language filters on the platform, writable Taalcode.
LanguageDescription varchar2(60) Taal Omschrijving filters on the platform, writable Language description.
Latitude double Latitude filters on the platform, writable
LeadPurpose guid Lead Doel filters on the platform, writable Reference to Lead Purpose of an account.
LeadSource guid Lead Bron filters on the platform, writable
Logo blob Logo filters on the platform, writable
LogoFileName varchar2 Logo Bestandsnaam filters on the platform, writable
LogoThumbnailUrl varchar2 Logo Thumbnail (URL) writable
LogoUrl varchar2 Logo (URL) filters on the platform, writable
Longitude double Longitude filters on the platform, writable
MainContact guid Hoofdcontact filters on the platform, writable
Modified datetime Modified filters on the platform, writable Last modified date.
ModifiedUtc datetime Gewijzigd (UTC) writable Last modified date in UTC.
Modifier guid Modifier filters on the platform, writable User ID of modifier.
ModifierFullName varchar2(240) Gewijzigd Volledige Naam filters on the platform, writable Name of modifier.
Name varchar2(50) Name filters on the platform, writable Name of account.
OINNumber varchar2(20) OIN Nummer filters on the platform, writable Dutch government identification number.
Parent guid Parent filters on the platform, writable
PayAsYouEarn varchar2 Pay-as-you-Earn filters on the platform, writable
PaymentConditionPurchase varchar2(2) Betalingsvoorwaarde Inkoop filters on the platform, writable
PaymentConditionPurchaseDescription varchar2(60) Betalingsvoorwaarde Inkoop Omschrijving filters on the platform, writable
PaymentConditionSales varchar2(2) Betalingsvoorwaarde Verkoop filters on the platform, writable
PaymentConditionSalesDescription varchar2(60) Betalingsvoorwaarde Verkoop Omschrijving filters on the platform, writable
PeppolIdentifier varchar2 Peppol-identificatie filters op het platform
PeppolIdentifierType int32 Peppol-identificatiesoort filters op het platform
Phone varchar2(25) Phone filters on the platform, writable Telefoonnummer.
PhoneExtension varchar2(15) Telefoontoestel filters on the platform, writable Phone number extension.
Postcode varchar2(20) Postcode filters on the platform, writable Postcode.
PriceList guid Prijslijst filters on the platform, writable
PurchaseCurrency varchar2(30) Inkoop Munteenheid filters on the platform, writable Currency of purchase.
PurchaseCurrencyDescription varchar2(60) Inkoop Valuta Omschrijving filters on the platform, writable Description of purchase currency.
PurchaseLeadDays int32 Inkoop Aanloopdagen filters on the platform, writable
PurchaseVATCode varchar2(3) Aankoop BTW Code filters on the platform, writable Purchase VAT code.
PurchaseVATCodeDescription varchar2(60) Inkoop BTW Code Omschrijving filters on the platform, writable Description of Purchase VAT code.
RSIN varchar2 RSIN Nummer filters on the platform, writable Fiscal number for NL legislation.
RecepientOfCommissions char Ontvanger van de Commissies filters on the platform, writable
Remarks varchar2 Remarks filters on the platform, writable
Reseller guid Reseller filters on the platform, writable
ResellerCode varchar2(18) Wederverkoper Code filters on the platform, writable Code of Reseller.
ResellerName varchar2(50) Wederverkoper Naam filters on the platform, writable Name of reseller.
SalesCurrency varchar2(30) Verkoop Munteenheid filters on the platform, writable Currency of sales price.
SalesCurrencyDescription varchar2(60) Verkoopvaluta Omschrijving filters on the platform, writable Description of sales currency.
SalesTaxSchedule guid Verkoopbelastingschema filters on the platform, writable
SalesTaxScheduleCode varchar2 Verkoop BTW Schema Code filters on the platform, writable
SalesTaxScheduleDescription varchar2 Verkoopbelastingschema Omschrijving filters on the platform, writable
SalesVATCode varchar2(3) Verkoop BTW Code filters on the platform, writable Sales VAT code.
SalesVATCodeDescription varchar2(60) Verkoop BTW Code Omschrijving filters on the platform, writable Description of Sales VAT code.
SearchCode varchar2(15) Zoekcode filters on the platform, writable Search code.
SecurityLevel int32 Beveiligingsniveau filters on the platform, writable
SeparateInvPerProject int16 Aparte Factuur per Project filters on the platform, writable
SeparateInvPerSubscription int16 Aparte Factuur per Abonnement filters on the platform, writable
ShippingLeadDays int32 Verschepen Aanloopdagen filters on the platform, writable
ShippingMethod guid Verzendwijze filters on the platform, writable
ShowRemarkForSales char Toon opmerking voor verkoop filters on the platform, writable
Source int16 Source filters op het platform
StartDate datetime Startdatum filters on the platform, writable
State varchar2(30) State filters on the platform, writable State/Province code.
StateName varchar2(60) Provincie filters on the platform, writable Name of state/province.
Status varchar2(1) Status filters on the platform, writable 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 sinds filters on the platform, writable
TradeName varchar2(50) Tradename filters on the platform, writable
Type varchar2(1) Type filters on the platform, writable Account type: Values: A = Relation, D = Division.
UniqueTaxpayerReference varchar2 Unieke Referentie Belastingplichtige filters on the platform, writable
VATLiability varchar2 BTW Passiva filters on the platform, writable
VATNumber varchar2(35) BTW-nummer filters on the platform, writable VAT number.
Website varchar2(128) Website filters on the platform, writable Website of the account.

Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: