invantive documentation
Invantive SupportforenAnmelden / Eintragen

AccountsFullTextSearch: Exact Online Accounts Full-Text Search

read only per partition REST

  • Katalog: ExactOnlineREST
  • Schema: CRM
  • Primärschlüssel: ID
  • Label: Accounts Full-Text Search

Search for legal counter parties using a text query.

Die Daten in dieser Tabelle sind nach dem Wert der Spalte Division aufgeteilt.

Es können nur Daten abgerufen werden.

API-Quelle

  • Endpunkt: /api/v1/{division}/read/crm/AccountsFullTextSearch
  • Metadaten: /api/v1/{division}/read/crm/$metadata

Leistungsmerkmale

Characteristic Value
Durchschnittliche Zugriffsverzögerung (ms) 5
Anzahl der Vollscan-Zeilen pro Minute 7,200
Anzahl der Query-Zeilen pro Minute 300
Zeilen pro Minute schreiben 300

Das Ergebnis kann auf dem Client im Cache zwischengespeichert werden.

Parameter

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

Tabellenspalten

Die Spalten der Tabelle AccountsFullTextSearch sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.

Name Datentyp Label Required Marks Documentation
AccountManager guid Kundenbetreuer filters on the platform, writable
AccountManagerFullName varchar2(240) Vollständiger Name des Kundenbetreuers filters on the platform, writable
AccountManagerHID int32 Konto Manager HID filters on the platform, writable
Accountant guid Accountant filters on the platform, writable
ActivitySector guid Aktivitäten Sektor filters on the platform, writable
ActivitySubSector guid Teilsektor nach Wirtschaftszweig filters on the platform, writable
AddressLine1 varchar2(80) Adresszeile 1 filters on the platform, writable Visit address first line.
AddressLine2 varchar2(80) Adresszeile 2 filters on the platform, writable Second address line.
AddressLine3 varchar2(80) Adresszeile 3 filters on the platform, writable Third address line.
AddressSource int16 Adresse Quelle filters on the platform, writable
AutomaticProcessProposedEntry int16 Automatischer Prozess – Vorgeschlagener Eintrag Filter auf der Plattform
BRIN guid BRIN filters on the platform, writable
BSN varchar2 Sozialversicherungsnummer filters on the platform, writable Citizen Service Number for the Netherlands.
Blocked char Blocked filters on the platform, writable
BusinessType guid Unternehmensart filters on the platform, writable
CanDropShip char Direktlieferung möglich filters on the platform, writable
ChamberOfCommerce varchar2(60) Wirtschaftskammer 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 Klassifikation 1 filters on the platform, writable
Classification2 guid Klassifikation 2 filters on the platform, writable
Classification3 guid Klassifikation 3 filters on the platform, writable
Classification4 guid Klassifikation 4 filters on the platform, writable
Classification5 guid Klassifikation 5 filters on the platform, writable
Classification6 guid Klassifikation 6 filters on the platform, writable
Classification7 guid Klassifikation 7 filters on the platform, writable
Classification8 guid Klassifikation 8 filters on the platform, writable
ClassificationDescription varchar2 Klassifikation Beschreibung filters on the platform, writable
Code varchar2 Code filters on the platform, writable
CodeAtSupplier varchar2(20) Code bei Lieferant filters on the platform, writable Code under which your own company is known at the account.
CompanySize guid Unternehmensgröße filters on the platform, writable
ConsolidationScenario int16 Konsolidation Szenario filters on the platform, writable
ControlledDate datetime Datum Geprüft filters on the platform, writable
CostPaid int16 Kosten bezahlt filters on the platform, writable
Costcenter varchar2(8) Kostenstelle filters on the platform, writable
CostcenterDescription varchar2(60) Kostenstelle Beschreibung filters on the platform, writable
Country varchar2(30) Country filters on the platform, writable Country code.
CountryName varchar2 Landesname filters on the platform, writable Country name.
Created datetime Created filters on the platform, writable Creation date.
CreatedUtc datetime Angelegt writable Creation date in UTC.
Creator guid Creator filters on the platform, writable User ID of creator.
CreatorFullName varchar2(240) Ersteller vollständiger Name filters on the platform, writable Name of creator.
CreditLinePurchase double Kreditlinie für den Einkauf filters on the platform, writable
CreditLineSales double Kreditlinie für den Vertrieb filters on the platform, writable
Currency varchar2(30) Currency filters on the platform, writable Code of Currency.
CustomField varchar2 Benutzerdefiniertes Feld filters on the platform, writable
CustomerSince datetime Kunde seit filters on the platform, writable
DatevCreditorCode varchar2(30) DATEV-Gläubigercode filters on the platform, writable
DatevDebtorCode varchar2(30) DATEV-Debitorencode filters on the platform, writable
DeliveryAdvice int16 Lieferhinweise Filter auf der Plattform
DiscountPurchase double Rabatt beim Kauf filters on the platform, writable
DiscountSales double Rabatt auf den Verkaufspreis filters on the platform, writable
Division int32 Division writable
DivisionCompanyCoCNumber varchar2(60) Nummer der Handelskammer des Bezirks writable Chamber of commerce number of the Exact Online division.
DivisionCompanyIBANNumber varchar2(50) Abteilung IBAN-Nummer writable IBAN number of the Exact Online division.
DivisionCompanyName varchar2(50) Geschäftsbereich Firmenname writable Company name of the Exact Online division.
DivisionCompanyRSINNumber varchar2(9) Abteilung RSIN-Nummer writable RSIN number of the Exact Online division.
DivisionCompanyVATNumber varchar2(35) Umsatzsteuer-Identifikationsnummer der Abteilung writable VAT number of the Exact Online division.
DivisionCompanyWageTaxNumber varchar2(60) Nummer der Lohnsteuerabteilung writable Wage tax number of the Exact Online division.
DivisionLabel varchar2(128) Abteilungsbezeichnung writable Label of the Exact Online division.
DivisionName varchar2(50) Verwaltung Name writable Name of the Exact Online division.
DivisionOwnerCompanyName varchar2(50) Name des Abonnenten writable Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs.
DivisionOwnerCompanyNumber varchar2(18) Abonnentennummer writable Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs.
DivisionShortName int64 Kurzbezeichnung der Abteilung 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 Zahlungslink für den Vertrieb aktivieren Filter auf der Plattform
EndDate datetime Enddatum filters on the platform, writable
EstablishedDate datetime Gründungsdatum filters on the platform, writable
Fax varchar2(25) Fax filters on the platform, writable Fax number.
GLAP guid Kreditoren Hauptbuch filters on the platform, writable
GLAR guid Debitoren Hauptbuch filters on the platform, writable
GLAccountPurchase guid GL-Konto für den Einkauf filters on the platform, writable
GLAccountSales guid GL-Konto für den Umsatz 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 Verkaufserlöse mit Quellensteuer filters on the platform, writable
ID guid ID filters on the platform, writable
IgnoreDatevWarningMessage char DATEV-Warnmeldung ignorieren filters on the platform, writable
IncotermAddressPurchase varchar2 Incoterm-Adresse kaufen filters on the platform, writable
IncotermAddressSales varchar2 Incoterm-Adresse Vertrieb filters on the platform, writable
IncotermCodePurchase varchar2 Incoterm-Code kaufen filters on the platform, writable
IncotermCodeSales varchar2 Incoterm-Code-Verkäufe filters on the platform, writable
IncotermVersionPurchase int16 Incoterm-Version kaufen filters on the platform, writable
IncotermVersionSales int16 Incoterm-Version „Verkauf“ filters on the platform, writable
IntraStatArea varchar2 Intrastat-Bereich filters on the platform, writable
IntraStatDeliveryTerm varchar2 Intrastat Lieferbedingung filters on the platform, writable
IntraStatSystem varchar2(5) Intrastat-System filters on the platform, writable
IntraStatTransactionA varchar2(1) Intrastat Transaktion A filters on the platform, writable
IntraStatTransactionB varchar2(1) Intrastat Transaktion B filters on the platform, writable
IntraStatTransportMethod varchar2(1) Intrastat-Transportmethode filters on the platform, writable
InvoiceAccount guid Rechnungskonto filters on the platform, writable
InvoiceAccountCode varchar2(18) Rechnungskonto Code filters on the platform, writable
InvoiceAccountName varchar2(50) Rechnungskonto Name filters on the platform, writable Name of account.
InvoiceAttachmentType int32 Rechnungsanhang Typ filters on the platform, writable
InvoicingMethod int32 Fakturierungsmethode filters on the platform, writable
IsAccountant int16 Ist Buchhalter filters on the platform, writable
IsAgency int16 Is Agentur filters on the platform, writable
IsAnonymised int16 Ist anonymisiert filters on the platform, writable Indicates whether the account is anonymised.
IsBank char Ist Bank filters on the platform, writable
IsCompetitor int16 Ist Wettbewerber filters on the platform, writable
IsExtraDuty char Ist Überstundenarbeit filters on the platform, writable
IsMailing int16 Ist Mailing filters on the platform, writable
IsMember char Ist Mitglied filters on the platform, writable
IsPilot char Ist Pilot filters on the platform, writable
IsPurchase char Ist der Kauf filters on the platform, writable
IsReseller char Ist Wiederverkäufer filters on the platform, writable
IsSales char Ist Vertrieb filters on the platform, writable
IsSupplier char Ist Lieferant filters on the platform, writable
Language varchar2(30) Language filters on the platform, writable Sprachcode.
LanguageDescription varchar2(60) Sprache Beschreibung filters on the platform, writable Language description.
Latitude double Latitude filters on the platform, writable
LeadPurpose guid Leitgedanke filters on the platform, writable Reference to Lead Purpose of an account.
LeadSource guid Lead-Quelle filters on the platform, writable
Logo blob Logo filters on the platform, writable
LogoFileName varchar2 Logo Dateiname filters on the platform, writable
LogoThumbnailUrl varchar2 Logo-Miniaturansicht (URL) writable
LogoUrl varchar2 Firmenzeichen (URL) filters on the platform, writable
Longitude double Longitude filters on the platform, writable
MainContact guid Hauptkontakt filters on the platform, writable
Modified datetime Modified filters on the platform, writable Last modified date.
ModifiedUtc datetime Geändert (UTC) writable Last modified date in UTC.
Modifier guid Modifier filters on the platform, writable User ID of modifier.
ModifierFullName varchar2(240) Geänderter vollständiger Name 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) Zahlungsbedingung Einkauf filters on the platform, writable
PaymentConditionPurchaseDescription varchar2(60) Zahlungsbedingung Einkauf Beschreibung filters on the platform, writable
PaymentConditionSales varchar2(2) Zahlungsbedingung Vertrieb filters on the platform, writable
PaymentConditionSalesDescription varchar2(60) Zahlungsbedingung Vertrieb Beschreibung filters on the platform, writable
PeppolIdentifier varchar2 Peppol-Bezeichnung Filter auf der Plattform
PeppolIdentifierType int32 Peppol-Bezeichnung-Typ Filter auf der Plattform
Phone varchar2(25) Phone filters on the platform, writable Telefonnummer.
PhoneExtension varchar2(15) Telefon-Durchwahl filters on the platform, writable Phone number extension.
Postcode varchar2(20) Postleitzahl filters on the platform, writable Postcode.
PriceList guid Preisliste filters on the platform, writable
PurchaseCurrency varchar2(30) Kaufwährung filters on the platform, writable Currency of purchase.
PurchaseCurrencyDescription varchar2(60) Einkauf Währung Beschreibung filters on the platform, writable Description of purchase currency.
PurchaseLeadDays int32 Einkauf Lead Tage filters on the platform, writable
PurchaseVATCode varchar2(3) Einkauf USt.-Code filters on the platform, writable Purchase VAT code.
PurchaseVATCodeDescription varchar2(60) Bestellung USt. Code Beschreibung 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 Provisionsempfänger filters on the platform, writable
Remarks varchar2 Remarks filters on the platform, writable
Reseller guid Reseller filters on the platform, writable
ResellerCode varchar2(18) Wiederverkäufer Code filters on the platform, writable Code of Reseller.
ResellerName varchar2(50) Wiederverkäufer Name filters on the platform, writable Name of reseller.
SalesCurrency varchar2(30) Verkaufswährung filters on the platform, writable Currency of sales price.
SalesCurrencyDescription varchar2(60) Vertrieb Währung Beschreibung filters on the platform, writable Description of sales currency.
SalesTaxSchedule guid Vertrieb Steuertarif filters on the platform, writable
SalesTaxScheduleCode varchar2 Mehrwertsteuercode filters on the platform, writable
SalesTaxScheduleDescription varchar2 Mehrwertsteuer Beschreibung filters on the platform, writable
SalesVATCode varchar2(3) Verkauf USt.-Code filters on the platform, writable Sales VAT code.
SalesVATCodeDescription varchar2(60) Vertrieb USt. Code Beschreibung filters on the platform, writable Description of Sales VAT code.
SearchCode varchar2(15) Suche Code filters on the platform, writable Search code.
SecurityLevel int32 Sicherheitsstufe filters on the platform, writable
SeparateInvPerProject int16 Separate Rechnung per Projekt filters on the platform, writable
SeparateInvPerSubscription int16 Separate Rechnung per Abonnement filters on the platform, writable
ShippingLeadDays int32 Versand Lead Tage filters on the platform, writable
ShippingMethod guid Versandart filters on the platform, writable
ShowRemarkForSales char Anmerkung zum Verkauf anzeigen filters on the platform, writable
Source int16 Source Filter auf der Plattform
StartDate datetime Anfangsdatum filters on the platform, writable
State varchar2(30) State filters on the platform, writable State/Province code.
StateName varchar2(60) Bundesland 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 seit 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 Einzigartige Steuerzahler-Referenz filters on the platform, writable
VATLiability varchar2 USt. Verbindlichkeiten filters on the platform, writable
VATNumber varchar2(35) Umsatzsteuer-Nummer filters on the platform, writable VAT number.
Website varchar2(128) Website filters on the platform, writable Website of the account.

Anmerkungen zu dieser Version

Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: