AccountsBulk: Exact Online Accounts
read only per partition webhook REST
- Katalog:
ExactOnlineREST - Schema:
CRM - Primärschlüssel:
ID - Label: Accounts
Rechtliche Vertragspartner wie Kunden, Lieferanten und Interessenten.
Die Daten in dieser Tabelle sind nach dem Wert der Spalte Division aufgeteilt.
Es können nur Daten abgerufen werden.
Zusammenfassung
Jede Gegenpartei ist höchstens einmal als Konto registriert. Ihr Typ lässt sich auf verschiedene Weise bestimmen:
- Customer: the column 'Status' has the value 'C' when the account is a customer. The meaning of the status codes is described in the table 'AccountCustomerStatuses'.
- Prospect: the column 'Status' has the value 'P' when the account is a prospect.
- Suspect: the column 'Status' has the value 'S' when the account is a suspect.
- Reseller: the column 'IsReseller' has the boolean value 'true'.
- Supplier: the column 'IsSupplier' has the boolean value 'true'.
- Accountant: the column 'IsAccountant' has the boolean value 'true'.
- Competitor: the column 'IsCompetitor' has the boolean value 'true'.
Änderungen werden über das Webhook-Thema Accounts übermittelt.
API-Quelle
- Endpunkt:
/api/v1/{division}/bulk/CRM/Accounts - Metadaten:
/api/v1/{division}/bulk/CRM/$metadata
Leistungsmerkmale
| Characteristic | Value |
|---|---|
| Durchschnittliche Zugriffsverzögerung (ms) | 5 |
| Anzahl der Vollscan-Zeilen pro Minute | 20,000 |
| Anzahl der Query-Zeilen pro Minute | 300 |
| Zeilen pro Minute schreiben | 300 |
Das Ergebnis kann auf dem Client im Cache zwischengespeichert werden.
Tabellenspalten
Die Spalten der Tabelle AccountsBulk 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 |
|---|---|---|---|---|---|
Account |
guid |
Kundenbetreuer | ID of the account manager. | ||
Account |
varchar2 |
Vollständiger Name des Kundenbetreuers | Name of the account manager. | ||
Account |
int32 |
Konto Manager HID | Number of the account manager. | ||
Accountant |
guid |
Accountant | Filter auf der Plattform | Reference to the accountant of the customer.Conditions: The referred accountant must have value > 0 in the field IsAccountant. | |
Activity |
guid |
Aktivitäten Sektor | Reference to Activity sector of the account. | ||
Activity |
guid |
Teilsektor nach Wirtschaftszweig | Reference to Activity sub-sector of the account. | ||
Address |
varchar2 |
Adresszeile 1 | Visit address first line. | ||
Address |
varchar2 |
Adresszeile 2 | Visit address second line. | ||
Address |
varchar2 |
Adresszeile 3 | Visit address third line. | ||
Address |
int16 |
Adresse Quelle | filters on the platform, writable | ||
Automatic |
int16 |
Automatischer Prozess – Vorgeschlagener Eintrag | Filter auf der Plattform | ||
BRIN |
guid |
BRIN | Filter auf der Plattform | Obsolete. | |
BSN |
varchar2 |
Sozialversicherungsnummer | writable | Citizen Service Number for the Netherlands. | |
Blocked |
char |
Blocked | Indicates if the account is blocked. | ||
Business |
guid |
Unternehmensart | Reference to the business type of the account. | ||
Can |
char |
Direktlieferung möglich | Indicates the default for the possibility to drop ship when an item is linked to a supplier. | ||
Chamber |
varchar2 |
Wirtschaftskammer | Chamber of commerce number. | ||
City |
varchar2 |
City | Visit address City. | ||
Classification |
varchar2 |
Classification | Filter auf der Plattform | Obsolete. | |
Classification1 |
guid |
Klassifikation 1 | Filter auf der Plattform | Account classification 1. | |
Classification1 |
varchar2 |
Klassifizierung 1 – Code | writable | Code of classification 1.See view Classifications. | |
Classification1 |
varchar2 |
Klassifizierung 1 – Beschreibung | writable | Description of classification 1.See view Classifications. | |
Classification2 |
guid |
Klassifikation 2 | Filter auf der Plattform | Account classification 2. | |
Classification2 |
varchar2 |
Klassifizierung 2 – Code | writable | Code of classification 2.See view Classifications. | |
Classification2 |
varchar2 |
Klassifizierung 2 – Beschreibung | writable | Description of classification 2.See view Classifications. | |
Classification3 |
guid |
Klassifikation 3 | Filter auf der Plattform | Account classification 3. | |
Classification3 |
varchar2 |
Klassifizierung 3 – Code | writable | Code of classification 3.See view Classifications. | |
Classification3 |
varchar2 |
Klassifizierung 3 – Beschreibung | writable | Description of classification 3.See view Classifications. | |
Classification4 |
guid |
Klassifikation 4 | Filter auf der Plattform | Account classification 4. | |
Classification4 |
varchar2 |
Klassifizierung 4 – Code | writable | Code of classification 4.See view Classifications. | |
Classification4 |
varchar2 |
Klassifizierung 4 – Beschreibung | writable | Description of classification 4.See view Classifications. | |
Classification5 |
guid |
Klassifikation 5 | Filter auf der Plattform | Account classification 5. | |
Classification5 |
varchar2 |
Klassifizierung 5 – Code | writable | Code of classification 5.See view Classifications. | |
Classification5 |
varchar2 |
Klassifizierung 5 – Beschreibung | writable | Description of classification 5.See view Classifications. | |
Classification6 |
guid |
Klassifikation 6 | Filter auf der Plattform | Account classification 6. | |
Classification6 |
varchar2 |
Klassifizierung 6 – Code | writable | Code of classification 6.See view Classifications. | |
Classification6 |
varchar2 |
Klassifizierung 6 – Beschreibung | writable | Description of classification 6.See view Classifications. | |
Classification7 |
guid |
Klassifikation 7 | Filter auf der Plattform | Account classification 7. | |
Classification7 |
varchar2 |
Klassifizierung 7 – Code | writable | Code of classification 7.See view Classifications. | |
Classification7 |
varchar2 |
Klassifizierung 7 – Beschreibung | writable | Description of classification 7.See view Classifications. | |
Classification8 |
guid |
Klassifikation 8 | Filter auf der Plattform | Account classification 8. | |
Classification8 |
varchar2 |
Klassifizierung 8 – Code | writable | Code of classification 8.See view Classifications. | |
Classification8 |
varchar2 |
Klassifizierung 8 – Beschreibung | writable | Description of classification 8.See view Classifications. | |
Classification |
varchar2 |
Klassifikation Beschreibung | Obsolete. | ||
Code |
varchar2 |
Code | Filter auf der Plattform | Unique key, fixed length numeric string with leading spaces, length 18.IMPORTANT: When you use OData $filter on this field you have to make sure the filter parameter contains the leading spaces. | |
Code |
varchar2 |
Code bei Lieferant | Code under which your own company is known at the account. | ||
Company |
guid |
Unternehmensgröße | Reference to Company size of the account. | ||
Consolidation |
int16 |
Konsolidation Szenario | Consolidation scenario (Time & Billing).Values: 0 = No consolidation, 1 = Item, 2 = Item + Project, 3 = Item + Employee, 4 = Item + Employee + Project, 5 = Project + WBS + Item, 6 = Project + WBS + Item + Employee.Item means in this case including Unit and Price, these also have to be the same to consolidate. | ||
Controlled |
datetime |
Datum Geprüft | Date of the latest control of account data with external web service. | ||
Cost |
int16 |
Kosten bezahlt | Obsolete. | ||
Costcenter |
varchar2 |
Kostenstelle | Obsolete. | ||
Costcenter |
varchar2 |
Kostenstelle Beschreibung | Obsolete. | ||
Country |
varchar2 |
Country | Filter auf der Plattform | Country code. | |
Country |
varchar2 |
Landesname | Country name. | ||
Created |
datetime |
Created | Creation date. | ||
Created |
datetime |
Angelegt | writable | Creation date in UTC. | |
Creator |
guid |
Creator | User ID of creator. | ||
Creator |
varchar2 |
Ersteller vollständiger Name | Name of creator. | ||
Credit |
double |
Kreditlinie für den Einkauf | Maximum amount of credit for Purchase.If no value has been defined, there is no credit limit. | ||
Credit |
double |
Kreditlinie für den Vertrieb | Maximum amount of credit for sales.If no value has been defined, there is no credit limit. | ||
Currency |
varchar2 |
Currency | Obsolete. | ||
Custom |
varchar2 |
Benutzerdefiniertes Feld | |||
Customer |
datetime |
Kunde seit | Obsolete. | ||
Datev |
varchar2 |
DATEV-Gläubigercode | DATEV creditor code for Germany legislation. | ||
Datev |
varchar2 |
DATEV-Debitorencode | DATEV debtor code for Germany legislation. | ||
Delivery |
int16 |
Lieferhinweise | |||
Discount |
double |
Rabatt beim Kauf | Default discount percentage for purchase.This is stored as a fraction. ie 5.5% is stored as .055. | ||
Discount |
double |
Rabatt auf den Verkaufspreis | Default discount percentage for sales.This is stored as a fraction. ie 5.5% is stored as .055. | ||
Division |
int32 |
Abteilung ID | Unique number of the Exact Online division. | ||
Division |
varchar2 |
Nummer der Handelskammer des Bezirks | writable | Chamber of commerce number of the Exact Online division. | |
Division |
varchar2 |
Abteilung IBAN-Nummer | writable | IBAN number of the Exact Online division. | |
Division |
varchar2 |
Geschäftsbereich Firmenname | writable | Company name of the Exact Online division. | |
Division |
varchar2 |
Abteilung RSIN-Nummer | writable | RSIN number of the Exact Online division. | |
Division |
varchar2 |
Umsatzsteuer-Identifikationsnummer der Abteilung | writable | VAT number of the Exact Online division. | |
Division |
varchar2 |
Nummer der Lohnsteuerabteilung | writable | Wage tax number of the Exact Online division. | |
Division |
varchar2 |
Abteilungsbezeichnung | writable | Label of the Exact Online division. | |
Division |
varchar2 |
Verwaltung Name | writable | Name of the Exact Online division. | |
Division |
varchar2 |
Name des Abonnenten | writable | Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
varchar2 |
Abonnentennummer | writable | Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
int64 |
Kurzbezeichnung der Abteilung | writable | Short name of the Exact Online division. | |
Document |
guid |
Document | Obsolete. | ||
Duns |
varchar2 |
DUNS Nummer | Obsolete. | ||
EORI |
varchar2 |
EORI-Nummer | writable | EORI number (United Kingdom). | |
Email |
varchar2 |
E-Mail address of the account. | |||
Enable |
char |
Zahlungslink für den Vertrieb aktivieren | Filter auf der Plattform | ||
End |
datetime |
Enddatum | Filter auf der Plattform | Determines in combination with the start date if the account is active.If the current date is > end date the account is inactive. | |
Established |
datetime |
Gründungsdatum | RegistrationDate. | ||
Fax |
varchar2 |
Fax | Fax number. | ||
GLAP |
guid |
Kreditoren Hauptbuch | Default GL account for Accounts Payable. | ||
GLAR |
guid |
Debitoren Hauptbuch | Default GL account for Accounts Receivable. | ||
GL |
guid |
GL-Konto für den Einkauf | Default (corporate) GL offset account for purchase (cost). | ||
GL |
guid |
GL-Konto für den Umsatz | Default (corporate) GL offset account for sales (revenue). | ||
Gln |
varchar2 |
GLN-Nummer | 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. | ||
Has |
char |
Verkaufserlöse mit Quellensteuer | Indicates whether a customer has withholding tax on sales. | ||
ID |
guid |
ID | Filter auf der Plattform | Primary key. | |
Ignore |
char |
DATEV-Warnmeldung ignorieren | Suppressed warning message when there is duplication on the DATEV code. | ||
Incoterm |
varchar2 |
Incoterm-Adresse kaufen | |||
Incoterm |
varchar2 |
Incoterm-Adresse Vertrieb | |||
Incoterm |
varchar2 |
Incoterm-Code kaufen | |||
Incoterm |
varchar2 |
Incoterm-Code-Verkäufe | |||
Incoterm |
int16 |
Incoterm-Version kaufen | |||
Incoterm |
int16 |
Incoterm-Version „Verkauf“ | |||
Intra |
varchar2 |
Intrastat-Bereich | Intrastat Area. | ||
Intra |
varchar2 |
Intrastat Lieferbedingung | Intrastat delivery method. | ||
Intra |
varchar2 |
Intrastat-System | System for Intrastat. | ||
Intra |
varchar2 |
Intrastat Transaktion A | Transaction type A for Intrastat. | ||
Intra |
varchar2 |
Intrastat Transaktion B | Transaction type B for Intrastat. | ||
Intra |
varchar2 |
Intrastat-Transportmethode | Transport method for Intrastat. | ||
Invoice |
guid |
Rechnungskonto | Filter auf der Plattform | ID of account to be invoiced instead of this account. | |
Invoice |
varchar2 |
Rechnungskonto Code | Code of InvoiceAccount. | ||
Invoice |
varchar2 |
Rechnungskonto Name | Name of InvoiceAccount. | ||
Invoice |
int32 |
Rechnungsanhang Typ | Indicates which attachment types should be sent when a sales invoice is printed.Only values in related table with Invoice=1 are allowed. | ||
Invoicing |
int32 |
Fakturierungsmethode | Method of sending for sales invoices.Values: 1: Paper, 2: EMail, 4: Mailbox (electronic exchange). | ||
Is |
int16 |
Ist Buchhalter | Filter auf der Plattform | Indicates whether the account is an accountant.Values: 0 = No accountant, 1 = True, but accountant doesn't want his name to be published in the list of accountants, 2 = True, and accountant is published in the list of accountants. | |
Is |
int16 |
Is Agentur | Indicates whether the accounti is an agency. | ||
Is |
int16 |
Ist anonymisiert | Indicates whtether the account is anonymised. | ||
IsBank |
char |
Ist Bank | Obsolete. | ||
Is |
int16 |
Ist Wettbewerber | Indicates whether the account is a competitor. | ||
Is |
char |
Ist Überstundenarbeit | Indicates whether a customer is eligible for extra duty. | ||
Is |
int16 |
Ist Mailing | Indicates if the account is excluded from mailing marketing information. | ||
Is |
char |
Ist Mitglied | Obsolete. | ||
Is |
char |
Ist Pilot | Indicates whether the account is a pilot account. | ||
Is |
char |
Ist der Kauf | Obsolete. | ||
Is |
char |
Ist Wiederverkäufer | Filter auf der Plattform | Indicates whether the account is a reseller. | |
Is |
char |
Ist Vertrieb | Filter auf der Plattform | Indicates whether the account is allowed for sales. | |
Is |
char |
Ist Lieferant | Filter auf der Plattform | Indicates whether the account is a supplier. | |
Language |
varchar2 |
Language | Sprachcode. | ||
Language |
varchar2 |
Sprache Beschreibung | Language description. | ||
Latitude |
double |
Latitude | Latitude (used by Google maps). | ||
Lead |
guid |
Leitgedanke | Reference to Lead purpose of an account. | ||
Lead |
guid |
Lead-Quelle | Reference to Lead source of an account. | ||
Logo |
blob |
Logo | Bytes of the logo image. | ||
Logo |
varchar2 |
Logo Dateiname | The file name (without path, but with extension) of the image. | ||
Logo |
varchar2 |
Logo-Miniaturansicht (URL) | Thumbnail url of the logo. | ||
Logo |
varchar2 |
Firmenzeichen (URL) | Url to retrieve the logo. | ||
Longitude |
double |
Longitude | Longitude (used by Google maps). | ||
Main |
guid |
Hauptkontakt | Filter auf der Plattform | Reference to main contact person. | |
Modified |
datetime |
Modified | Filter auf der Plattform | Last modified date. | |
Modified |
datetime |
Geändert (UTC) | writable | Last modified date in UTC. | |
Modifier |
guid |
Modifier | User ID of modifier. | ||
Modifier |
varchar2 |
Geänderter vollständiger Name | Name of modifier. | ||
Name |
varchar2 |
Name | Filter auf der Plattform | Account name. | |
OIN |
varchar2 |
OIN-Nummer | Dutch government identification number. | ||
Parent |
guid |
Parent | Filter auf der Plattform | ID of the parent account. | |
Pay |
varchar2 |
Pay-as-you-Earn | Indicates the loan repayment plan for UK legislation. | ||
Payment |
varchar2 |
Zahlungsbedingung Einkauf | Code of default payment condition for purchase. | ||
Payment |
varchar2 |
Zahlungsbedingung Einkauf Beschreibung | Description of PaymentConditionPurchase. | ||
Payment |
varchar2 |
Zahlungsbedingung Vertrieb | Code of default payment condition for sales. | ||
Payment |
varchar2 |
Zahlungsbedingung Vertrieb Beschreibung | Description of PaymentConditionSales. | ||
Peppol |
varchar2 |
Peppol-Bezeichnung | Filter auf der Plattform | ||
Peppol |
int32 |
Peppol-Bezeichnung-Typ | Filter auf der Plattform | ||
Phone |
varchar2 |
Phone | Telefonnummer. | ||
Phone |
varchar2 |
Telefon-Durchwahl | Phone number extention. | ||
Postcode |
varchar2 |
Postleitzahl | Visit address postcode. | ||
Price |
guid |
Preisliste | Filter auf der Plattform | Default sales price list for account. | |
Purchase |
varchar2 |
Kaufwährung | Currency of purchase. | ||
Purchase |
varchar2 |
Einkauf Währung Beschreibung | Description of PurchaseCurrency. | ||
Purchase |
int32 |
Einkauf Lead Tage | Indicates number of days required to receive a purchase.Acts as a default. | ||
Purchase |
varchar2 |
Einkauf USt.-Code | Default VAT code used for purchase entries. | ||
Purchase |
varchar2 |
Bestellung USt. Code Beschreibung | Description of PurchaseVATCode. | ||
RSIN |
varchar2 |
RSIN Nummer | Fiscal number for NL legislation. | ||
Recepient |
char |
Provisionsempfänger | Define the relation that should be taken in the official document of the rewarding fiscal fiches Belcotax. | ||
Remarks |
varchar2 |
Remarks | Remarks. | ||
Reseller |
guid |
Reseller | ID of the reseller account.Conditions: the target account must have the property IsReseller turned on. | ||
Reseller |
varchar2 |
Wiederverkäufer Code | Code of Reseller. | ||
Reseller |
varchar2 |
Wiederverkäufer Name | Name of Reseller. | ||
Sales |
varchar2 |
Verkaufswährung | Currency of Sales used for Time & Billing. | ||
Sales |
varchar2 |
Vertrieb Währung Beschreibung | Description of SalesCurrency. | ||
Sales |
guid |
Vertrieb Steuertarif | Obsolete. | ||
Sales |
varchar2 |
Mehrwertsteuercode | Obsolete. | ||
Sales |
varchar2 |
Mehrwertsteuer Beschreibung | Obsolete. | ||
Sales |
varchar2 |
Verkauf USt.-Code | Default VAT code for a sales entry. | ||
Sales |
varchar2 |
Vertrieb USt. Code Beschreibung | Description of SalesVATCode. | ||
Search |
varchar2 |
Suche Code | Filter auf der Plattform | Search code. | |
Security |
int32 |
Sicherheitsstufe | Security level (0 - 100). | ||
Separate |
int16 |
Separate Rechnung per Projekt | Separate invoice per project (Time & Billing). | ||
Separate |
int16 |
Separate Rechnung per Abonnement | Indicates how invoices are generated from subscriptions.0 = subscriptions belonging to the same customer are combined in a single invoice.1 = each subscription results in one invoice.In both cases, each individual subscription line results in one invoice line. | ||
Shipping |
int32 |
Versand Lead Tage | Indicates the number of days it takes to send goods to the customer.Acts as a default. | ||
Shipping |
guid |
Versandart | Default shipping method. | ||
Show |
char |
Anmerkung zum Verkauf anzeigen | writable | Indicates whether to display Ordered by account's remarks when creating a new sales order. | |
Source |
int16 |
Source | Filter auf der Plattform | ||
Start |
datetime |
Anfangsdatum | Filter auf der Plattform | Indicates in combination with the end date if the account is active. | |
State |
varchar2 |
State | State/Province/County code When changing the Country and the State is filled, the State must be assigned with a valid value from the selected country or set to empty. | ||
State |
varchar2 |
Bundesland | Name of State. | ||
Status |
varchar2 |
Status | Filter auf der Plattform | 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. | |
Status |
datetime |
Status seit | Obsolete. | ||
Trade |
varchar2 |
Tradename | Trade name can be registered and shown with the client (for all legislations). | ||
Type |
varchar2 |
Type | Filter auf der Plattform | Account type: Values: A = Relation, D = Division. | |
Unique |
varchar2 |
Einzigartige Steuerzahler-Referenz | Unique taxpayer reference for UK legislation. | ||
VAT |
varchar2 |
USt. Verbindlichkeiten | Indicates the VAT status of an account to be able to identify the relation that should be selected in the VAT debtor listing in Belgium. | ||
VAT |
varchar2 |
Umsatzsteuer-Nummer | The number under which the account is known at the Value Added Tax collection agency. | ||
Website |
varchar2 |
Website | Website of the account. |
Tasten
| Key | Column | Bezieht sich auf | Kind | Description |
|---|---|---|---|---|
Accounts |
Accountant |
Accounts.ID |
Key | |
Accounts |
Business |
BusinessTypes.ID |
Key | |
Accounts |
Creator |
Users. |
Key | |
Accounts |
GLAP |
GLAccounts.ID |
Key | |
Accounts |
GLAR |
GLAccounts.ID |
Key | |
Accounts |
GL |
GLAccounts.ID |
Key | |
Accounts |
GL |
GLAccounts.ID |
Key | |
Accounts |
Invoice |
Accounts.ID |
Key | |
Accounts |
Lead |
LeadPurposes.ID |
Key | |
Accounts |
Lead |
LeadSources.ID |
Key | |
Accounts |
Main |
Contacts.ID |
Key | |
Accounts |
Modifier |
Users. |
Key | |
Accounts |
Parent |
Accounts.ID |
Key | |
Accounts |
Price |
SalesPriceLists.ID |
Key | |
Accounts |
Reseller |
Accounts.ID |
Key | |
Accounts |
Shipping |
ShippingMethods.ID |
Key |
Anmerkungen zu dieser Version
Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: