Items: Exact Online Items
insert update delete per partition webhook REST
- Catalogo:
ExactOnlineREST - Schema:
Logistics - Chiavi primarie:
ID - Label: Items
I dati in questa tabella sono partizionati per valore della colonna Division.
È possibile recuperare e modificare i dati utilizzando insert, update e delete.
Le modifiche vengono inviate tramite il topic del webhook Items.
Codice sorgente dell'API
- Punto finale:
/api/v1/{division}/logistics/Items - Metadati:
/api/v1/{division}/logistics/$metadata
Caratteristiche prestazionali
| Characteristic | Value |
|---|---|
| Latenza media di accesso (ms) | 5 |
| Righe di scansione completa al minuto | 7,200 |
| Numero di righe di Query al minuto | 300 |
| Scrittura di righe al minuto | 300 |
Il risultato può essere memorizzato nella memoria cache sul client.
Colonne della tabella
Di seguito sono riportate le colonne della tabella Items. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.
| Name | Tipo di dati | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
Assembled |
int32 |
itgen_eol_assembledleaddays | filters on the platform, writable | ||
Average |
double |
Costo medio | writable | The current average cost price. | |
Barcode |
varchar2 |
Barcode | filters on the platform, writable | Barcode of the item (numeric string). | |
Batch |
double |
Quantità del lotto | filters on the platform, writable | ||
Class_ |
varchar2 |
Classificazione 1 | filters on the platform, writable | Item class code referring to ItemClasses with ClassID 1. | |
Class_ |
varchar2 |
Classificazione 2 | filters on the platform, writable | Item class code referring to ItemClasses with ClassID 2. | |
Class_ |
varchar2 |
Classificazione 3 | filters on the platform, writable | Item class code referring to ItemClasses with ClassID 3. | |
Class_ |
varchar2 |
Classificazione 4 | filters on the platform, writable | Item class code referring to ItemClasses with ClassID 4. | |
Class_ |
varchar2 |
Classificazione 5 | filters on the platform, writable | Item class code referring to ItemClasses with ClassID 5. | |
Class_ |
varchar2 |
Classificazione 6 | filters on the platform, writable | Item class code referring to ItemClasses with ClassID 6. | |
Class_ |
varchar2 |
Classificazione 7 | filters on the platform, writable | Item class code referring to ItemClasses with ClassID 7. | |
Class_ |
varchar2 |
Classificazione 8 | filters on the platform, writable | Item class code referring to ItemClasses with ClassID 8. | |
Class_ |
varchar2 |
Classificazione 9 | filters on the platform, writable | Item class code referring to ItemClasses with ClassID 9. | |
Class_ |
varchar2 |
Classificazione 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 |
Copiare i commenti | writable | Copy sales remarks to sales lines. | |
Cost |
varchar2 |
Valuta del prezzo di costo | writable | The currency of the current and proposed cost price. | |
Cost |
double |
Prezzo di costo nuovo | filters on the platform, writable | Proposed cost price. | |
Cost |
double |
Prezzo di costo standard | writable | The current standard cost price. | |
Created |
datetime |
Created | filters on the platform, writable | Creation date. | |
Created |
datetime |
Creato | writable | Creation date in UTC. | |
Creator |
guid |
Creator | writable | User ID of creator. | |
Creator |
varchar2 |
Nome completo del creatore | writable | Name of creator. | |
Custom |
varchar2 |
Campo personalizzato | filters on the platform, writable | ||
Description |
varchar2 |
Description | filters on the platform, writable | Description of the item. | |
Division |
int32 |
Division | Division code. | ||
Division |
varchar2 |
Numero di iscrizione alla Camera di Commercio della Divisione | writable | Chamber of commerce number of the Exact Online division. | |
Division |
varchar2 |
Codice IBAN della divisione | writable | IBAN number of the Exact Online division. | |
Division |
varchar2 |
Divisione - Nome dell'azienda | writable | Company name of the Exact Online division. | |
Division |
varchar2 |
Numero di divisione RSIN | writable | RSIN number of the Exact Online division. | |
Division |
varchar2 |
Partita IVA della divisione | writable | VAT number of the Exact Online division. | |
Division |
varchar2 |
Codice fiscale salariale della divisione | writable | Wage tax number of the Exact Online division. | |
Division |
varchar2 |
Etichetta della divisione | writable | Label of the Exact Online division. | |
Division |
varchar2 |
Nome dell'amministrazione | writable | Name of the Exact Online division. | |
Division |
varchar2 |
Nome del titolare dell'abbonamento | writable | Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
varchar2 |
Numero di abbonato | writable | Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
int64 |
Nome abbreviato della divisione | writable | Short name of the Exact Online division. | |
End |
datetime |
Data di fine | filters on the platform, writable | Together with StartDate this determines if the item is active. | |
Extra |
varchar2 |
Descrizione extra | filters on the platform, writable | Extra description text, slightly longer than the regular description (255 instead of 60). | |
Free |
char |
Campo booleano libero n. 1 | filters on the platform, writable | Free boolean field 1. | |
Free |
char |
Campo booleano libero n. 2 | filters on the platform, writable | Free boolean field 2. | |
Free |
char |
Campo booleano libero n. 3 | filters on the platform, writable | Free boolean field 3. | |
Free |
char |
Campo booleano libero n. 4 | filters on the platform, writable | Free boolean field 4. | |
Free |
char |
Campo booleano libero n. 5 | filters on the platform, writable | Free boolean field 5. | |
Free |
datetime |
Campo data libero n. 1 | filters on the platform, writable | Free date field 1. | |
Free |
datetime |
Campo data libero n. 2 | filters on the platform, writable | Free date field 2. | |
Free |
datetime |
Campo data libero n. 3 | filters on the platform, writable | Free date field 3. | |
Free |
datetime |
Campo data libero n. 4 | filters on the platform, writable | Free date field 4. | |
Free |
datetime |
Campo data libero n. 5 | filters on the platform, writable | Free date field 5. | |
Free |
double |
Campo numero libero n. 1 | filters on the platform, writable | Free numeric field 1. | |
Free |
double |
Campo numero libero n. 2 | filters on the platform, writable | Free numeric field 2. | |
Free |
double |
Campo numero libero n. 3 | filters on the platform, writable | Free numeric field 3. | |
Free |
double |
Campo numero libero n. 4 | filters on the platform, writable | Free numeric field 4. | |
Free |
double |
Campo numero libero n. 5 | filters on the platform, writable | Free numeric field 5. | |
Free |
double |
Campo numero libero n. 6 | filters on the platform, writable | Free numeric field 6. | |
Free |
double |
Campo numero libero n. 7 | filters on the platform, writable | Free numeric field 7. | |
Free |
double |
Campo numero libero n. 8 | filters on the platform, writable | Free numeric field 8. | |
Free |
varchar2 |
Campo di testo libero n. 1 | filters on the platform, writable | Free text field 1. | |
Free |
varchar2 |
Campo di testo libero n. 2 | filters on the platform, writable | Free text field 2. | |
Free |
varchar2 |
Campo di testo libero n. 3 | filters on the platform, writable | Free text field 3. | |
Free |
varchar2 |
Campo di testo libero n. 4 | filters on the platform, writable | Free text field 4. | |
Free |
varchar2 |
Campo di testo libero n. 5 | filters on the platform, writable | Free text field 5. | |
Free |
varchar2 |
Campo di testo libero n. 6 | filters on the platform, writable | Free text field 6. | |
Free |
varchar2 |
Campo di testo libero n. 7 | filters on the platform, writable | Free text field 7. | |
Free |
varchar2 |
Campo di testo libero n. 8 | filters on the platform, writable | Free text field 8. | |
Free |
varchar2 |
Campo di testo libero n. 9 | filters on the platform, writable | Free text field 9. | |
Free |
varchar2 |
Campo di testo libero n. 10 | filters on the platform, writable | Free text field 10. | |
GL |
guid |
Costi GL | 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 |
Costi relativi ai codici contabili GL | writable | Code of GL account for costs. | |
GL |
varchar2 |
Descrizione del conto GL - Costi | writable | Description of GLCosts. | |
GL |
guid |
itgen_eol_glcostsworkinprogress | filtri sulla piattaforma | ||
GL |
varchar2 |
itgen_eol_glcostsworkinprogresscode | filtri sulla piattaforma | ||
GL |
varchar2 |
itgen_eol_glcostsworkinprogressdescription | filtri sulla piattaforma | ||
GL |
guid |
Ricavi GL | 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 |
Codice contabile GL: Ricavi | writable | Code of GLRevenue. | |
GL |
varchar2 |
Descrizione del conto GL: Ricavi | writable | Description of GLRevenue. | |
GL |
guid |
itgen_eol_glrevenueworkinprogress | filtri sulla piattaforma | ||
GL |
varchar2 |
itgen_eol_glrevenueworkinprogresscode | filtri sulla piattaforma | ||
GL |
varchar2 |
itgen_eol_glrevenueworkinprogressdescription | filtri sulla piattaforma | ||
GL |
guid |
Stock del conto GL | 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 |
Codice contabile GL - Scorte | writable | Code of GL account for stock. | |
GL |
varchar2 |
Descrizione conto GL: Scorte | writable | Description of GLStock. | |
Gross |
double |
Peso lordo | writable | Gross weight for international goods shipments. | |
ID |
guid |
ID | filters on the platform, writable | Primary key. | |
Is |
int16 |
È un articolo in lotto | filters on the platform, writable | Indicates if batches are used for this item. | |
Is |
int16 |
È un articolo con numero di lotto | filters on the platform, writable | This property is obsolete.Use property 'IsBatchItem' instead. | |
Is |
char |
È consentita l'indicazione di una frazione sull'articolo? | filters on the platform, writable | Indicates if fractions (for example 0.35) are allowed for quantities of this item. | |
Is |
int16 |
È "Crea oggetto" | filters on the platform, writable | Indicates that an Item is produced to Inventory, not purchased. | |
Is |
int16 |
È un nuovo contratto | writable | Only used for packages (IsPackageItem=1).To indicate if this package is a new contract type package. | |
Is |
int16 |
È un articolo disponibile su richiesta | writable | Is On demand Item. | |
Is |
char |
È un articolo del pacchetto | writable | Indicates if the item is a package item.Can only be created in the hosting administration. | |
Is |
char |
È un articolo acquistato | filters on the platform, writable | Indicates if the item can be purchased. | |
Is |
int16 |
È un elemento del codice di registrazione | filters on the platform, writable | Indicated if the item is used in voucher functionality. | |
Is |
char |
È un articolo in promozione | filters on the platform, writable | Indicates if the item can be sold. | |
Is |
char |
È un articolo seriale | filters on the platform, writable | Indicates that serial numbers are used for this item. | |
Is |
char |
È un articolo con numero di serie | writable | This property is obsolete.Use property 'IsSerialItem' instead. | |
Is |
char |
È un articolo a magazzino | 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 |
È un articolo subappaltato | filters on the platform, writable | Indicates if the item is provided by an outside supplier. | |
Is |
int16 |
È un elemento imponibile | writable | Indicates if tax needs to be calculated for this item. | |
IsTime |
int16 |
È il tempo | filters on the platform, writable | Indicates if the item is a time unit item (for example a labor hour item). | |
Is |
int16 |
È un articolo del negozio online | filters on the platform, writable | Indicates if the item can be exported to a web shop. | |
Item |
guid |
È un gruppo di articoli | filters on the platform, writable | GUID of Item group of the item. | |
Item |
varchar2 |
Codice del gruppo di articoli | filters on the platform, writable | Code of ItemGroup. | |
Item |
varchar2 |
Descrizione del gruppo di articoli | writable | Description of ItemGroup. | |
Modified |
datetime |
Modified | filters on the platform, writable | Last modified date. | |
Modified |
datetime |
Modificato (UTC) | writable | Last modified date in UTC. | |
Modifier |
guid |
Modifier | writable | User ID of modifier. | |
Modifier |
varchar2 |
Nome completo modificato | writable | Name of modifier. | |
Net |
double |
Peso netto | writable | Net weight for international goods shipments. | |
Net |
varchar2 |
Unità di peso netto | 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 |
Nome immagine | writable | File name of picture. | |
Picture |
varchar2 |
Miniatura dell'immagine (URL) | writable | Url where thumbnail picture can be retrieved. | |
Picture |
varchar2 |
Immagine (URL) | writable | Url where picture can be retrieved. | |
Sales |
varchar2 |
Codice IVA di vendita | filters on the platform, writable | Code of SalesVat. | |
Sales |
varchar2 |
Codice IVA vendite Descrizione | writable | Description of Sales VAT code. | |
Search |
varchar2 |
Codice di ricerca | filters on the platform, writable | Search code of the item. | |
Security |
int32 |
Livello di sicurezza | writable | Security level (0 - 100). | |
Standard |
double |
Prezzo di vendita standard | filters on the platform, writable | ||
Start |
datetime |
Data di inizio | filters on the platform, writable | Together with EndDate this determines if the item is active. | |
Statistical |
varchar2 |
Codice statistico | filtri sulla piattaforma | ||
Statistical |
double |
Peso netto statistico | filtri sulla piattaforma | ||
Statistical |
double |
Unità statistiche | filtri sulla piattaforma | ||
Statistical |
double |
Valore statistico | filtri sulla piattaforma | ||
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 |
Descrizione dell'unità | writable | Description of Unit. | |
Unit |
varchar2 |
Tipo di unità | 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 |
Chiavi
| Key | Column | Si riferisce a | 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 |
Riferito da
- 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)
Note di rilascio
Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: