SalesOrders: Exact Online Sales Orders
insert update delete per partition webhook REST
- Catalogo:
ExactOnlineREST - Schema:
SalesOrder - Chiavi primarie:
OrderID - Label: Sales Orders
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 SalesOrders.
Codice sorgente dell'API
- Punto finale:
/api/v1/{division}/salesorder/SalesOrders - Metadati:
/api/v1/{division}/salesorder/$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 SalesOrders. 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 |
|---|---|---|---|---|---|
Amount |
double |
Valuta della divisione degli importi | writable | Amount in the default currency of the company. | |
Amount |
double |
Importo Sconto | writable | Discount amount in the default currency of the company. | |
Amount |
double |
Importo Sconto IVA esclusa | writable | Discount amount exclude VAT in the default currency of the company. | |
Amount |
double |
Importo in valuta estera | writable | Amount in the currency of the transaction. | |
Amount |
double |
Importo in valuta estera, IVA esclusa | writable | Amount exclude VAT in the currency of the transaction. | |
Approval |
int16 |
Stato di approvazione | filters on the platform, writable | Shows if this sales order is approved. | |
Approval |
varchar2 |
Descrizione dello stato di approvazione | writable | Description of ApprovalStatus. | |
Approved |
datetime |
Approved | writable | Approval datetime. | |
Approver |
guid |
Approver | filters on the platform, writable | User who approved the sales order. | |
Approver |
varchar2 |
Nome completo dell'approvatore | writable | Name of approver. | |
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. | |
Currency |
varchar2 |
Currency | writable | Currency code. | |
Deliver |
guid |
Consegna a | filters on the platform, writable | Reference to delivery customer. | |
Deliver |
guid |
Consegna al referente | filters on the platform, writable | Reference to contact person of delivery customer. | |
Deliver |
varchar2 |
Consegna a nome completo del referente | writable | Name of contact person of delivery customer. | |
Deliver |
varchar2 |
Consegna a nome di | writable | Name of delivery customer. | |
Delivery |
guid |
Indirizzo di consegna | filters on the platform, writable | Delivery address. | |
Delivery |
datetime |
Data di consegna | filters on the platform, writable | Delivery date. | |
Delivery |
int16 |
Stato della spedizione | filters on the platform, writable | Delivery status; 12=Open, 20=Partial, 21=Complete, 45=Canceled. | |
Delivery |
varchar2 |
Descrizione dello stato della consegna | writable | Description of DeliveryStatus. | |
Description |
varchar2 |
Description | filters on the platform, writable | Description. | |
Discount |
double |
Discount | writable | Discount percentage. | |
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. | |
Document |
guid |
Document | filters on the platform, writable | Document that is manually linked to the sales order. | |
Document |
int32 |
Numero del documento | writable | Number of the document. | |
Document |
varchar2 |
Oggetto del documento | writable | Subject of the document. | |
Incoterm |
varchar2 |
Indirizzo Incoterm | filters on the platform, writable | ||
Incoterm |
varchar2 |
Codice Incoterm | filters on the platform, writable | ||
Incoterm |
int16 |
Versione dell'Incoterm | filters on the platform, writable | ||
Invoice |
int16 |
Stato della fattura | filters on the platform, writable | Invoice status; 10=draft, 20=open, 50=processed. | |
Invoice |
varchar2 |
Descrizione dello stato della fattura | writable | Description of InvoiceStatus. | |
Invoice |
guid |
Fattura a | filters on the platform, writable | Reference to the Customer who will receive the invoice. | |
Invoice |
guid |
Fattura a nome del referente | filters on the platform, writable | Reference to the Contact person of the customer who will receive the invoice. | |
Invoice |
varchar2 |
Fattura intestata a: Nome e cognome del referente | writable | Name of the contact person of the customer who will receive the invoice. | |
Invoice |
varchar2 |
Fattura intestata a Nome | writable | Name of the customer who will receive the invoice. | |
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. | |
Order |
datetime |
Data dell'ordine | filters on the platform, writable | Order date. | |
Order |
guid |
ID dell'ordine | filters on the platform, writable | Primary key. | |
Order |
int32 |
Numero dell'ordine | filters on the platform, writable | Number of sales order. | |
Ordered |
guid |
Ordinato da | filters on the platform, writable | Customer who ordered the sales order. | |
Ordered |
guid |
Ordinati per persona di contatto | filters on the platform, writable | Contact person of the customer who ordered the sales order. | |
Ordered |
varchar2 |
Ordinati per nome e cognome della persona di contatto | writable | Name of contact person of the customer who ordered the sales order. | |
Ordered |
varchar2 |
Ordinati per nome | writable | Name of the customer who ordered the sales order. | |
Payment |
varchar2 |
Condizione di pagamento | writable | The payment condition used for due date and discount calculation. | |
Payment |
varchar2 |
Descrizione delle condizioni di pagamento | writable | Description of PaymentCondition. | |
Payment |
varchar2 |
Riferimento di pagamento | filters on the platform, writable | Payment reference for sales order. | |
Remarks |
varchar2 |
Remarks | writable | Extra remarks. | |
Sales |
guid |
Canale di vendita | filtri sulla piattaforma | ||
Sales |
varchar2 |
Codice del canale di vendita | filtri sulla piattaforma | ||
Sales |
varchar2 |
Descrizione del canale di vendita | filtri sulla piattaforma | ||
Salesperson |
guid |
proprietario | filters on the platform, writable | Sales representative. | |
Salesperson |
varchar2 |
Nome completo del venditore | writable | Name of sales representative. | |
Selection |
guid |
Codice di selezione | filtri sulla piattaforma | ID of selection code. | |
Selection |
varchar2 |
Codice di selezione | Code of selection code. | ||
Selection |
varchar2 |
itgen_eol_selectioncodedescription | Description of selection code. | ||
Shipping |
guid |
Metodo di spedizione | filters on the platform, writable | ShippingMethod. | |
Shipping |
varchar2 |
Descrizione del metodo di spedizione | writable | Description of ShippingMethod. | |
Status |
int16 |
Status | filters on the platform, writable | The status of the sales order.12 = Open, 20 = Partial, 21 = Complete, 45 = Cancelled. | |
Status |
varchar2 |
Descrizione dello stato | writable | Description of Status. | |
Tax |
guid |
Calendario fiscale | filters on the platform, writable | Obsolete. | |
Tax |
varchar2 |
Codice della tabella fiscale | writable | Obsolete. | |
Tax |
varchar2 |
Descrizione delle fasce fiscali | writable | Obsolete. | |
Warehouse |
varchar2 |
Codice del magazzino | writable | Code of Warehouse. | |
Warehouse |
varchar2 |
Descrizione del magazzino | writable | Description of Warehouse. | |
Warehouse |
guid |
ID magazzino | filters on the platform, writable | Warehouse. | |
Your |
varchar2 |
Il tuo Riferimento | filters on the platform, writable | The reference number of the customer. |
Chiavi
| Key | Column | Si riferisce a | Kind | Description |
|---|---|---|---|---|
Sales |
Approver |
Users. |
Key | |
Sales |
Creator |
Users. |
Key | |
Sales |
Currency |
Currencies.Code |
Key | |
Sales |
Deliver |
Contacts.ID |
Key | |
Sales |
Deliver |
Accounts.ID |
Key | |
Sales |
Delivery |
Addresses.ID |
Key | |
Sales |
Document |
Documents.ID |
Key | |
Sales |
Invoice |
Contacts.ID |
Key | |
Sales |
Invoice |
Accounts.ID |
Key | |
Sales |
Modifier |
Users. |
Key | |
Sales |
Ordered |
Contacts.ID |
Key | |
Sales |
Ordered |
Accounts.ID |
Key | |
Sales |
Salesperson |
Users. |
Key | |
Sales |
Selection |
SelectionCodes.ID |
Key | |
Sales |
Shipping |
ShippingMethods.ID |
Key | |
Sales |
Warehouse |
Warehouses.ID |
Key |
Riferito da
- PurchaseOrderLines
SalesOrder(Key) - PurchaseOrders
SalesOrder(Key) - SalesInvoiceLines
SalesOrder(Key) - SalesInvoiceLinesBulk
SalesOrder(Key) - SalesOrderLines
OrderID(Key) - SalesOrderLinesBulk
OrderID(Key)
Note di rilascio
Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: