Items: Exact Online Items
insert update delete per partition webhook REST
- Katalog:
ExactOnlineREST - Schema:
Logistics - Primärschlüssel:
ID - Label: Items
Die Daten in dieser Tabelle sind nach dem Wert der Spalte Division aufgeteilt.
Mit insert, update und delete können Daten abgerufen und geändert werden.
Änderungen werden über das Webhook-Thema Items übermittelt.
API-Quelle
- Endpunkt:
/api/v1/{division}/logistics/Items - Metadaten:
/api/v1/{division}/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 Items 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 |
|---|---|---|---|---|---|
Assembled |
int32 |
itgen_eol_assembledleaddays | filters on the platform, writable | ||
Average |
double |
Durchschnittskosten | writable | The current average cost price. | |
Barcode |
varchar2 |
Barcode | filters on the platform, writable | Barcode of the item (numeric string). | |
Batch |
double |
Chargenmenge | filters on the platform, writable | ||
Class_ |
varchar2 |
Klassifikation 1 | filters on the platform, writable | Item class code referring to ItemClasses with ClassID 1. | |
Class_ |
varchar2 |
Klassifikation 2 | filters on the platform, writable | Item class code referring to ItemClasses with ClassID 2. | |
Class_ |
varchar2 |
Klassifikation 3 | filters on the platform, writable | Item class code referring to ItemClasses with ClassID 3. | |
Class_ |
varchar2 |
Klassifikation 4 | filters on the platform, writable | Item class code referring to ItemClasses with ClassID 4. | |
Class_ |
varchar2 |
Klassifikation 5 | filters on the platform, writable | Item class code referring to ItemClasses with ClassID 5. | |
Class_ |
varchar2 |
Klassifikation 6 | filters on the platform, writable | Item class code referring to ItemClasses with ClassID 6. | |
Class_ |
varchar2 |
Klassifikation 7 | filters on the platform, writable | Item class code referring to ItemClasses with ClassID 7. | |
Class_ |
varchar2 |
Klassifikation 8 | filters on the platform, writable | Item class code referring to ItemClasses with ClassID 8. | |
Class_ |
varchar2 |
Klassifikation 9 | filters on the platform, writable | Item class code referring to ItemClasses with ClassID 9. | |
Class_ |
varchar2 |
Klassifikation 10 | filters on the platform, writable | Item class code referring to ItemClasses with ClassID 10. | |
Code |
varchar2 |
Code | filters on the platform, writable | Item code. | |
Copy |
int16 |
Bemerkungen kopieren | writable | Copy sales remarks to sales lines. | |
Cost |
varchar2 |
Einkaufspreis-Währung | 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 | 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 | writable | User ID of creator. | |
Creator |
varchar2 |
Ersteller vollständiger Name | writable | Name of creator. | |
Custom |
varchar2 |
Benutzerdefiniertes Feld | filters on the platform, 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. | |
Extra |
varchar2 |
Extra Beschreibung | filters on the platform, writable | Extra description text, slightly longer than the regular description (255 instead of 60). | |
Free |
char |
Freies Boolesches Feld Nr. 1 | filters on the platform, writable | Free boolean field 1. | |
Free |
char |
Freies Boolesches Feld Nr. 2 | filters on the platform, writable | Free boolean field 2. | |
Free |
char |
Freies Boolesches Feld Nr. 3 | filters on the platform, writable | Free boolean field 3. | |
Free |
char |
Freies Boolesches Feld Nr. 4 | filters on the platform, writable | Free boolean field 4. | |
Free |
char |
Freies Boolesches Feld Nr. 5 | filters on the platform, writable | Free boolean field 5. | |
Free |
datetime |
Freies Datumsfeld Nr. 1 | filters on the platform, writable | Free date field 1. | |
Free |
datetime |
Freies Datumsfeld Nr. 2 | filters on the platform, writable | Free date field 2. | |
Free |
datetime |
Freies Datumsfeld Nr. 3 | filters on the platform, writable | Free date field 3. | |
Free |
datetime |
Freies Datumsfeld Nr. 4 | filters on the platform, writable | Free date field 4. | |
Free |
datetime |
Freies Datumsfeld Nr. 5 | filters on the platform, writable | Free date field 5. | |
Free |
double |
Freies Zahlenfeld Nr. 1 | filters on the platform, writable | Free numeric field 1. | |
Free |
double |
Freies Zahlenfeld Nr. 2 | filters on the platform, writable | Free numeric field 2. | |
Free |
double |
Freies Zahlenfeld Nr. 3 | filters on the platform, writable | Free numeric field 3. | |
Free |
double |
Freies Zahlenfeld Nr. 4 | filters on the platform, writable | Free numeric field 4. | |
Free |
double |
Freies Zahlenfeld Nr. 5 | filters on the platform, writable | Free numeric field 5. | |
Free |
double |
Freies Zahlenfeld Nr. 6 | filters on the platform, writable | Free numeric field 6. | |
Free |
double |
Freies Zahlenfeld Nr. 7 | filters on the platform, writable | Free numeric field 7. | |
Free |
double |
Freies Zahlenfeld Nr. 8 | filters on the platform, writable | Free numeric field 8. | |
Free |
varchar2 |
Freitextfeld Nr. 1 | filters on the platform, writable | Free text field 1. | |
Free |
varchar2 |
Freitextfeld Nr. 2 | filters on the platform, writable | Free text field 2. | |
Free |
varchar2 |
Freitextfeld Nr. 3 | filters on the platform, writable | Free text field 3. | |
Free |
varchar2 |
Freitextfeld Nr. 4 | filters on the platform, writable | Free text field 4. | |
Free |
varchar2 |
Freitextfeld Nr. 5 | filters on the platform, writable | Free text field 5. | |
Free |
varchar2 |
Freitextfeld Nr. 6 | filters on the platform, writable | Free text field 6. | |
Free |
varchar2 |
Freitextfeld Nr. 7 | filters on the platform, writable | Free text field 7. | |
Free |
varchar2 |
Freitextfeld Nr. 8 | filters on the platform, writable | Free text field 8. | |
Free |
varchar2 |
Freitextfeld Nr. 9 | filters on the platform, writable | Free text field 9. | |
Free |
varchar2 |
Freitextfeld Nr. 10 | filters on the platform, writable | Free text field 10. | |
GL |
guid |
Hauptbuch Kosten | filters on the platform, writable | GL account the cost entries will be booked on.This overrules the GL account from the item group.If the license contains 'Intuit integration' this property overrides the value in Settings, not the item group. | |
GL |
varchar2 |
Kosten nach GL-Kontencode | writable | Code of GL account for costs. | |
GL |
varchar2 |
GL-Kontobezeichnung Kosten | writable | Description of GLCosts. | |
GL |
guid |
itgen_eol_glcostsworkinprogress | Filter auf der Plattform | ||
GL |
varchar2 |
itgen_eol_glcostsworkinprogresscode | Filter auf der Plattform | ||
GL |
varchar2 |
itgen_eol_glcostsworkinprogressdescription | Filter auf der Plattform | ||
GL |
guid |
Hauptbuch Einnahmen | filters on the platform, writable | GL account the revenue will be booked on.This overrules the GL account from the item group.If the license contains 'Intuit integration' this property overrides the value in Settings, not the item group. | |
GL |
varchar2 |
GL-Kontocode: Umsatz | writable | Code of GLRevenue. | |
GL |
varchar2 |
GL-Kontobezeichnung: Umsatz | writable | Description of GLRevenue. | |
GL |
guid |
itgen_eol_glrevenueworkinprogress | Filter auf der Plattform | ||
GL |
varchar2 |
itgen_eol_glrevenueworkinprogresscode | Filter auf der Plattform | ||
GL |
varchar2 |
itgen_eol_glrevenueworkinprogressdescription | Filter auf der Plattform | ||
GL |
guid |
GL-Kontobestand | filters on the platform, writable | GL account the stock entries will be booked on.This overrules the GL account from the item group.If the license contains 'Intuit integration' this property overrides the value in Settings, not the item group. | |
GL |
varchar2 |
GL-Kontencode Bestand | writable | Code of GL account for stock. | |
GL |
varchar2 |
GL-Kontobezeichnung: Lagerbestand | writable | Description of GLStock. | |
Gross |
double |
Bruttogewicht | writable | Gross weight for international goods shipments. | |
ID |
guid |
ID | filters on the platform, writable | Primary key. | |
Is |
int16 |
Ist es ein Chargenartikel? | filters on the platform, writable | Indicates if batches are used for this item. | |
Is |
int16 |
Ist die Chargennummer vorhanden? | filters on the platform, writable | This property is obsolete.Use property 'IsBatchItem' instead. | |
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 |
int16 |
Ist „Make Item“ | filters on the platform, writable | Indicates that an Item is produced to Inventory, not purchased. | |
Is |
int16 |
Ist neuer Vertrag | writable | Only used for packages (IsPackageItem=1).To indicate if this package is a new contract type package. | |
Is |
int16 |
Ist ein Artikel auf Anfrage | writable | Is On demand Item. | |
Is |
char |
Ist Paketartikel | writable | Indicates if the item is a package item.Can only be created in the hosting administration. | |
Is |
char |
Ist es ein Kaufartikel? | filters on the platform, writable | Indicates if the item can be purchased. | |
Is |
int16 |
Ist ein Registrierungscode-Element | filters on the platform, writable | Indicated if the item is used in voucher functionality. | |
Is |
char |
Ist ein Verkaufsartikel? | filters on the platform, writable | Indicates if the item can be sold. | |
Is |
char |
Ist Serienartikel | filters on the platform, writable | Indicates that serial numbers are used for this item. | |
Is |
char |
Ist die Seriennummer vorhanden? | writable | This property is obsolete.Use property 'IsSerialItem' instead. | |
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 |
char |
Ist es ein untervergebenes Produkt? | filters on the platform, writable | Indicates if the item is provided by an outside supplier. | |
Is |
int16 |
Ist steuerpflichtig | writable | Indicates if tax needs to be calculated for this item. | |
IsTime |
int16 |
Ist Zeit | filters on the platform, writable | Indicates if the item is a time unit item (for example a labor hour 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 | writable | Description of ItemGroup. | |
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 | writable | User ID of modifier. | |
Modifier |
varchar2 |
Geänderter vollständiger Name | writable | Name of modifier. | |
Net |
double |
Nettogewicht | writable | Net weight for international goods shipments. | |
Net |
varchar2 |
Nettogewichtseinheit | filters on the platform, writable | Net Weight unit for international goods shipment, only available in manufacturing packages. | |
Notes |
varchar2 |
Notes | writable | Notes. | |
Picture |
blob |
Picture | filters on the platform, writable | ||
Picture |
varchar2 |
Bildname | 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. | |
Sales |
varchar2 |
Verkauf USt.-Code | filters on the platform, writable | Code of SalesVat. | |
Sales |
varchar2 |
Vertrieb USt. Code Beschreibung | writable | Description of Sales VAT code. | |
Search |
varchar2 |
Suche Code | filters on the platform, writable | Search code of the item. | |
Security |
int32 |
Sicherheitsstufe | writable | Security level (0 - 100). | |
Standard |
double |
Standardverkaufspreis | filters on the platform, writable | ||
Start |
datetime |
Anfangsdatum | filters on the platform, writable | Together with EndDate this determines if the item is active. | |
Statistical |
varchar2 |
Statistischer Code | Filter auf der Plattform | ||
Statistical |
double |
Statistisches Nettogewicht | Filter auf der Plattform | ||
Statistical |
double |
Statistische Einheiten | Filter auf der Plattform | ||
Statistical |
double |
Statistischer Wert | Filter auf der Plattform | ||
Stock |
double |
Stock | writable | Quantity that is in stock. | |
Unit |
varchar2 |
Unit | filters on the platform, writable | The standard unit of this item. | |
Unit |
varchar2 |
Maßeinheit Beschreibung | writable | Description of Unit. | |
Unit |
varchar2 |
Einheitstyp | writable | Type of unit: A=Area, L=Length, O=Other, T=Time, V=Volume, W=Weight. | |
Use |
int16 |
itgen_eol_useexplosion | filters on the platform, writable |
Tasten
| Key | Column | Bezieht sich auf | Kind | Description |
|---|---|---|---|---|
Items_ |
Creator |
Users. |
Key | |
Items_ |
GL |
GLAccounts.ID |
Key | |
Items_ |
GL |
GLAccounts.ID |
Key | |
Items_ |
GL |
GLAccounts.ID |
Key | |
Items_ |
Item |
ItemGroups.ID |
Key | |
Items_ |
Modifier |
Users. |
Key | |
Items_ |
Unit |
Units.Code |
Key |
Verwiesen von
- Budgets
Item(Key) - QuotationLines
Item(Key) - QuotationLinesBulk
Item(Key) - TransactionLines
Item(Key) - TransactionLinesBulk
Item(Key) - AssemblyOrders
Item(Key) - BatchNumbers
Item(Key) - ItemWarehousePlanningDetails
Item(Key) - ItemWarehouseStorageLocations
Item(Key) - ItemWarehouses
Item(Key) - SerialNumbers
Item(Key) - StockBatchNumbers
Item(Key) - StockCountLines
Item(Key) - StockSerialNumbers
Item(Key) - WarehouseTransferLines
Item(Key) - CustomerItems
Item(Key) - ItemVersions
Item(Key) - SalesItemPrices
Item(Key) - SalesItemPricesBulk
Item(Key) - SupplierItems
Item(Key) - BillOfMaterialMaterials
PartItem(Key) - BillOfMaterialVersions
Item(Key) - ByProductReceipts
Item(Key) - ByProductReversals
Item(Key) - MaterialIssues
Item(Key) - MaterialReversals
Item(Key) - MfgItemWarehouseStorageLocations
Item(Key) - Operations
Item(Key) - ShopOrderMaterialPlans
Item(Key) - ShopOrderReceipts
Item(Key) - ShopOrderReversals
Item(Key) - ShopOrders
Item(Key) - StageForDeliveryReceipts
Item(Key) - StageForDeliveryReversals
Item(Key) - SubOrderReceipts
Item(Key) - SubOrderReversals
Item(Key) - CostTransactions
Item(Key) - EmployeeRestrictionItems
Item(Key) - InvoiceTerms
Item(Key) - PjtTimeTransactions
Item(Key) - ProjectHourBudgets
Item(Key) - ProjectRestrictionEmployeeItems
Item(Key) - ProjectRestrictionItems
Item(Key) - ProjectWBS
DefaultItem(Key) - ProjectWBSBulk
DefaultItem(Key) - Projects
FixedPriceItem(Key) - Projects
PrepaidItem(Key) - RecentCosts
ItemId(Key) - RecentHours
ItemId(Key) - WBSActivities
DefaultItem(Key) - PurchaseInvoiceLines
Item(Key) - GoodsReceiptLines
Item(Key) - PurchaseOrderLines
Item(Key) - PurchaseOrderStockBatchNumbers
Item(Key) - PurchaseOrderStockSerialNumbers
Item(Key) - SalesPriceListVolumeDiscounts
Item(Key) - SalesInvoiceLines
Item(Key) - SalesInvoiceLinesBulk
Item(Key) - DigitalOrderPickingLines
Item(Key) - GoodsDeliveryLines
Item(Key) - GoodsDeliveryLinesBulk
Item(Key) - PlannedSalesReturnLines
Item(Key) - SalesOrderLines
Item(Key) - SalesOrderLinesBulk
Item(Key) - SalesOrderStockBatchNumbers
Item(Key) - SalesOrderStockBatchNumbersBulk
Item(Key) - SalesOrderStockSerialNumbersBulk
Item(Key) - SubscriptionLines
Item(Key) - SubscriptionRestrictionItems
Item(Key)
Anmerkungen zu dieser Version
Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: