StockCountLines: Exact Online Stock Count Lines
insert update delete per partition REST
- Catalogo:
ExactOnlineREST - Schema:
Inventory - Chiavi primarie:
ID - Label: Stock Count Lines
I dati in questa tabella sono partizionati per valore della colonna Division.
È possibile recuperare e modificare i dati utilizzando insert, update e delete.
Codice sorgente dell'API
- Punto finale:
/api/v1/{division}/inventory/StockCountLines - Metadati:
/api/v1/{division}/inventory/$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 StockCountLines. 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 |
|---|---|---|---|---|---|
Cost |
double |
Costi | filters on the platform, writable | Cost price of the item that is used to create the stock count. | |
Counted |
guid |
itgen_eol_countedby | filters on the platform, writable | Counted by. | |
Created |
datetime |
Created | filters on the platform, writable | Creation date. | |
Created |
datetime |
Creato | writable | Creation date in UTC. | |
Creator |
guid |
Creator | filters on the platform, writable | User ID of creator. | |
Creator |
varchar2 |
Nome completo del creatore | filters on the platform, writable | Name of creator. | |
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. | |
ID |
guid |
ID | filters on the platform, writable | Primary key. | |
Item |
guid |
Item | filters on the platform, writable | Reference to the item for which the stock is counted. | |
Item |
varchar2 |
Codice a barre dell'articolo | filters on the platform, writable | Item Barcode. | |
Item |
varchar2 |
Codice articolo | filters on the platform, writable | Item code. | |
Item |
double |
Articolo Prezzo di costo | filters on the platform, writable | Current standard/actual item cost price. | |
Item |
varchar2 |
Descrizione dell'articolo | filters on the platform, writable | Description of item. | |
Item |
char |
Articolo divisibile | filters on the platform, writable | Indicates if fractional quantities of the item can be used, for example quantity = 0.4. | |
Line |
int32 |
Numero della linea | filters on the platform, writable | Line number. | |
Modified |
datetime |
Modified | filters on the platform, writable | Last modified date. | |
Modified |
datetime |
Modificato (UTC) | writable | Last modified date in UTC. | |
Modifier |
guid |
Modifier | filters on the platform, writable | User ID of modifier. | |
Modifier |
varchar2 |
Nome completo modificato | filters on the platform, writable | Name of modifier. | |
Quantity |
double |
Differenza di quantità | filters on the platform, writable | The difference between the current quantity in stock and the new quantity in stock.For example specify -1 for this field to correct the quantity if one item in stock is broken. | |
Quantity |
double |
Quantità disponibile | filters on the platform, writable | The current quantity available in stock. | |
Quantity |
double |
Quantità Nuovo | filters on the platform, writable | The new quantity in stock.Use this field to correct the quantity when the items in stock are physically counted. | |
Reason |
varchar2 |
Codice motivo | filtri sulla piattaforma | ||
Reason |
varchar2 |
Codice motivo Descrizione | filtri sulla piattaforma | ||
Reason |
guid |
ID codice motivo | filters on the platform, writable | ||
Source |
int16 |
Source | filters on the platform, writable | Source of stock count entry: 1-Manual entry, 2-Import, 3-Stock count, 4-Web service. | |
Status |
int16 |
Status | filters on the platform, writable | Stock count status: 12-Draft, 21-Processed. | |
Stock |
guid |
ID numero di scorte | filters on the platform, writable | Identifies the stock count.All the lines of a stock count have the same StockCountID. | |
Stock |
varchar2 |
Unità di stoccaggio | filters on the platform, writable | Stock item's unit description. | |
Storage |
guid |
Luogo di archiviazione | filters on the platform, writable | This property is package specific (Stock count can have multiple lines for the same item only if it is for multiple storage locations). | |
Storage |
varchar2 |
Codice del luogo di stoccaggio | filters on the platform, writable | Storage location code. | |
Storage |
varchar2 |
Descrizione del luogo di stoccaggio | filters on the platform, writable | Storage location description. | |
Storage |
int32 |
itgen_eol_storagelocationsequencenumber | filters on the platform, writable | ||
Warehouse |
guid |
Warehouse | filters on the platform, writable | Warehouse. |
Chiavi
| Key | Column | Si riferisce a | Kind | Description |
|---|---|---|---|---|
Stock |
Counted |
Users. |
Key | |
Stock |
Creator |
Users. |
Key | |
Stock |
Item |
Items.ID |
Key | |
Stock |
Modifier |
Users. |
Key | |
Stock |
Stock |
StockCounts. |
Key | |
Stock |
Storage |
StorageLocations.ID |
Key | |
Stock |
Warehouse |
Warehouses.ID |
Key |
Riferito da
- StockBatchNumbers
StockCountLine(Key) - StockSerialNumbers
StockCountLine(Key) - PurchaseOrderStockBatchNumbers
StockCountLine(Key) - PurchaseOrderStockSerialNumbers
StockCountLine(Key) - SalesOrderStockBatchNumbers
StockCountLine(Key) - SalesOrderStockBatchNumbersBulk
StockCountLine(Key) - SalesOrderStockSerialNumbersBulk
StockCountLine(Key)
Note di rilascio
Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: