ItemsRead: Exact Online Items
read only per partition REST
- Katalog:
ExactOnlineREST - Schema:
Logistics - Primärschlüssel:
ID - Label: 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/Items - 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.
Tabellenspalten
Die Spalten der Tabelle ItemsRead 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 | ||
Barcode |
varchar2 |
Barcode | filters on the platform, writable | Barcode of the item (numeric string). | |
Code |
varchar2 |
Code | filters on the platform, writable | Item code. | |
Cost |
varchar2 |
Einkaufspreis-Währung | filters on the platform, writable | The currency of the current and proposed cost price. | |
Cost |
double |
Neupreis | filters on the platform, writable | Proposed cost price. | |
Cost |
double |
Selbstkostenpreis-Standard | filters on the platform, writable | The current 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 | writable | ||
Description |
varchar2 |
Description | filters on the platform, writable | Description of the item. | |
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 | Together with StartDate this determines if the item is active. | |
ID |
guid |
ID | filters on the platform, writable | Primary key. | |
Is |
char |
Sind Brüche bei diesem Artikel zulässig? | filters on the platform, writable | Indicates if fractions (for example 0.35) are allowed for quantities of this item. | |
Is |
char |
Ist ein Verkaufsartikel? | filters on the platform, writable | Indicates if the item can be sold. | |
Is |
char |
Ist Lagerware? | filters on the platform, writable | If you have the Trade or Manufacturing license and you check this property the item will be shown in the stock positions overview, stock counts and transaction lists.If you have the Invoice module and you check this property you will get a general journal entry based on the Stock and Costs G/L accounts of the item group.If you don't want the general journal entry to be created you should change the Stock/Costs G/L account on the Item group page to the type Costs instead of Inventory. | |
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 the item can be exported to a web shop. | |
Item |
guid |
Ist Artikelgruppe | filters on the platform, writable | GUID of Item group of the item. | |
Item |
varchar2 |
Artikel Gruppencode | filters on the platform, writable | Code of ItemGroup. | |
Item |
varchar2 |
Artikel Gruppenbeschreibung | filters on the platform, writable | Description of ItemGroup. | |
Margin |
double |
Margin | writable | ||
Markup |
double |
Mark-up | writable | ||
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 | Notes. | |
Picture |
varchar2 |
Bildname | filters on the platform, writable | File name of picture. | |
Picture |
varchar2 |
Bild-Miniaturansicht (URL) | writable | Url where thumbnail picture can be retrieved. | |
Picture |
varchar2 |
Bild (URL) | 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 | ||
Quantity |
double |
itgen_eol_quantitytobeconsumed | filters on the platform, writable | ||
Quantity |
double |
itgen_eol_quantitytobedelivered | filters on the platform, writable | ||
Quantity |
double |
itgen_eol_quantitytobeproduced | filters on the platform, writable | ||
Quantity |
double |
itgen_eol_quantitytobereceived | filters on the platform, writable | ||
Reserved |
double |
Reservierter Bestand | filters on the platform, writable | ||
Sales |
varchar2 |
Verkaufswährung | writable | Currency of sales price. | |
Sales |
double |
Salesprice | writable | ||
Sales |
varchar2 |
Verkauf USt.-Code | filters on the platform, writable | Code of SalesVat. | |
Sales |
varchar2 |
Vertrieb USt. Code Beschreibung | filters on the platform, writable | Description of Sales VAT code. | |
Start |
datetime |
Anfangsdatum | filters on the platform, writable | Together with EndDate this determines if the item is active. | |
Stock |
double |
Stock | filters on the platform, writable | Quantity that is in stock. | |
Unit |
guid |
Unit | filters on the platform, writable | The standard unit of this item. | |
Unit |
varchar2 |
Einheit Code | filters on the platform, writable | ||
Unit |
varchar2 |
Maßeinheit Beschreibung | 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. |
Tasten
| Key | Column | Bezieht sich auf | Kind | Description |
|---|---|---|---|---|
Items |
Creator |
Users. |
Key | |
Items |
Item |
ItemGroups.ID |
Key | |
Items |
Modifier |
Users. |
Key |
Anmerkungen zu dieser Version
Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: