AccountItems: Exact Online Account Items
read only per partition REST
- Katalog:
ExactOnlineREST - Schema:
Logistics - Primärschlüssel:
ID - Label: Account Items
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/logistics/AccountItems - Metadaten:
/api/v1/{division}/read/logistics/$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 |
|---|---|---|---|---|
account |
guid |
|||
division |
int32 |
ID of the division to retrieve data for. |
Tabellenspalten
Die Spalten der Tabelle AccountItems 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 |
Account | filters on the platform, writable | Account. | |
Barcode |
varchar2 |
Barcode | filters on the platform, writable | Barcode. | |
Code |
varchar2 |
Code | filters on the platform, writable | Item code. | |
Cost |
varchar2 |
Einkaufspreis-Währung | filters on the platform, writable | Currency of cost price. | |
Cost |
double |
Neupreis | filters on the platform, writable | New cost price. | |
Cost |
double |
Selbstkostenpreis-Standard | filters on the platform, writable | Standard cost price. | |
Created |
datetime |
Created | filters on the platform, writable | Creation date. | |
Created |
datetime |
Angelegt | writable | Creation date in UTC. | |
Creator |
guid |
Creator | filters on the platform, writable | User ID of creator. | |
Creator |
varchar2 |
Ersteller vollständiger Name | filters on the platform, writable | Name of creator. | |
Default |
double |
Standardverkaufspreis | filters on the platform, writable | Default sales price. | |
Description |
varchar2 |
Description | filters on the platform, writable | Item Description. | |
Division |
int32 |
Division | Division code. | ||
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. | |
End |
datetime |
Enddatum | filters on the platform, writable | End date. | |
ID |
guid |
ID | filters on the platform, writable | Item. | |
Is |
char |
Sind Brüche bei diesem Artikel zulässig? | filters on the platform, writable | Indicates if decimals are allowed in quantities. | |
Is |
char |
Ist ein Verkaufsartikel? | filters on the platform, writable | Indicates if this is a sales item. | |
Is |
char |
Ist Lagerware? | filters on the platform, writable | Indicates if this is a stock item. | |
Is |
int16 |
Ist steuerpflichtig | filters on the platform, writable | Indicates if tax needs to be calculated for this item. | |
Is |
int16 |
Ist ein Artikel im Webshop? | filters on the platform, writable | Indicates if this is a webshop item. | |
Item |
guid |
Ist Artikelgruppe | filters on the platform, writable | Item group. | |
Item |
varchar2 |
Artikel Gruppencode | filters on the platform, writable | Code of Item group. | |
Item |
varchar2 |
Artikel Gruppenbeschreibung | filters on the platform, writable | Description of Item group. | |
Margin |
double |
Margin | filters on the platform, writable | Margin. | |
Markup |
double |
Mark-up | filters on the platform, writable | Markup. | |
Modified |
datetime |
Modified | filters on the platform, writable | Last modified date. | |
Modified |
datetime |
Geändert (UTC) | writable | Last modified date in UTC. | |
Modifier |
guid |
Modifier | filters on the platform, writable | User ID of modifier. | |
Modifier |
varchar2 |
Geänderter vollständiger Name | filters on the platform, writable | Name of modifier. | |
Notes |
varchar2 |
Notes | filters on the platform, writable | Extra remarks. | |
Picture |
varchar2 |
Bildname | filters on the platform, writable | File name of picture. | |
Picture |
varchar2 |
Bild-Miniaturansicht (URL) | filters on the platform, writable | Url where thumbnail picture can be retrieved. | |
Picture |
varchar2 |
Bild (URL) | filters on the platform, writable | Url where picture can be retrieved. | |
Projected |
double |
Prognostizierter Lagerbestand | filters on the platform, writable | ||
Purchase |
int32 |
Einkauf Lead Tage | filters on the platform, writable | Number of days before purchase arrives. | |
Quantity |
double |
itgen_eol_quantitytobeconsumed | filters on the platform, writable | Quantity to be consumed. | |
Quantity |
double |
itgen_eol_quantitytobedelivered | filters on the platform, writable | Quantity to be delivered. | |
Quantity |
double |
itgen_eol_quantitytobeproduced | filters on the platform, writable | Quantity to be produced. | |
Quantity |
double |
itgen_eol_quantitytobereceived | filters on the platform, writable | Quantity to be received. | |
Reserved |
double |
Reservierter Bestand | filters on the platform, writable | Quantity in stock that is reserved. | |
Sales |
varchar2 |
Verkaufswährung | filters on the platform, writable | Currency of sales price. | |
Sales |
double |
Salesprice | filters on the platform, writable | Sales price. | |
Sales |
varchar2 |
Verkauf USt.-Code | filters on the platform, writable | Sales vat code. | |
Sales |
varchar2 |
Vertrieb USt. Code Beschreibung | filters on the platform, writable | Description of Sales VAT code. | |
Start |
datetime |
Anfangsdatum | filters on the platform, writable | Start date. | |
Stock |
double |
Stock | filters on the platform, writable | Quantity that is in stock. | |
Unit |
guid |
Unit | filters on the platform, writable | Unit. | |
Unit |
varchar2 |
Einheit Code | filters on the platform, writable | Code of unit. | |
Unit |
varchar2 |
Maßeinheit Beschreibung | filters on the platform, writable | Description of unit. | |
Unit |
varchar2 |
Einheitstyp | filters on the platform, writable | Type of unit: A=Area, L=Length, O=Other, T=Time, V=Volume, W=Weight. |
Anmerkungen zu dieser Version
Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: