Quotations: Exact Online Quotations
insert update delete per partition webhook REST
- Catalogo:
ExactOnlineREST - Schema:
CRM - Chiavi primarie:
QuotationID - Label: Quotations
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 Quotations.
Codice sorgente dell'API
- Punto finale:
/api/v1/{division}/crm/Quotations - Metadati:
/api/v1/{division}/crm/$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 Quotations. 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 | filters on the platform, writable | Amount in the default currency of the company. | |
Amount |
double |
Importo Sconto | filters on the platform, writable | ||
Amount |
double |
Importo Sconto IVA esclusa | filters on the platform, writable | ||
Amount |
double |
Importo in valuta estera | filters on the platform, writable | Amount in the currency of the transaction. | |
Close |
datetime |
Data chiusa | filters on the platform, writable | Date on which the customer accepted or rejected the quotation version. | |
Closing |
datetime |
Data di chiusura | filters on the platform, writable | Date on which you expect to close/win the deal. | |
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. | |
Currency |
varchar2 |
Currency | filters on the platform, writable | The currency of the quotation. | |
Delivery |
guid |
Account di consegna | filters on the platform, writable | The account where the items should delivered. | |
Delivery |
varchar2 |
Codice conto di consegna | filters on the platform, writable | The code of the delivery account. | |
Delivery |
guid |
Consegna - Account - Contatti | filters on the platform, writable | The contact person of the delivery account. | |
Delivery |
varchar2 |
Consegna Account Contatto Nome e cognome | filters on the platform, writable | Full name of the delivery account contact person. | |
Delivery |
varchar2 |
Nome dell'account di consegna | filters on the platform, writable | The name of the delivery account. | |
Delivery |
guid |
Indirizzo di consegna | filters on the platform, writable | The id of the delivery address. | |
Delivery |
datetime |
Data di consegna | filters on the platform, writable | ||
Description |
varchar2 |
Description | filters on the platform, writable | The description of the quotation. | |
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 linked to the quotation. | |
Document |
varchar2 |
Oggetto del documento | filters on the platform, writable | The subject of the document. | |
Due |
datetime |
Scadenza | filters on the platform, writable | Date after which the quotation is no longer valid. | |
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 |
guid |
Account di fatturazione | filters on the platform, writable | The account to which the invoice is sent. | |
Invoice |
varchar2 |
Codice del conto della fattura | filters on the platform, writable | The code of the invoice account. | |
Invoice |
guid |
Fattura, Conto, Contatto | filters on the platform, writable | The contact person of the invoice account. | |
Invoice |
varchar2 |
Fattura Conto Nome e cognome del referente | filters on the platform, writable | Full name of the invoice account contact person. | |
Invoice |
varchar2 |
Nome dell'account di fatturazione | filters on the platform, writable | The name of the invoice account. | |
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. | |
Opportunity |
guid |
Opportunity | filters on the platform, writable | Opportunity linked to the quotation. | |
Opportunity |
varchar2 |
Nome dell'opportunità | filters on the platform, writable | The name of the opportunity. | |
Order |
guid |
Account ordini | filters on the platform, writable | The account that requested the quotation. | |
Order |
varchar2 |
Codice conto ordine | filters on the platform, writable | The code of the order account. | |
Order |
guid |
Ordine Account Contatti | filters on the platform, writable | The contact person of the order account. | |
Order |
varchar2 |
itgen_eol_orderaccountcontactfullname | filters on the platform, writable | Full name of the order account contact person. | |
Order |
varchar2 |
Nome dell'account dell'ordine | filters on the platform, writable | The name of the order account. | |
Payment |
varchar2 |
Condizione di pagamento | filters on the platform, writable | ||
Payment |
varchar2 |
Descrizione delle condizioni di pagamento | filtri sulla piattaforma | ||
Project |
guid |
Project | filters on the platform, writable | The project linked to the quotation. | |
Project |
varchar2 |
Codice del progetto | filters on the platform, writable | The code of the project. | |
Project |
varchar2 |
Descrizione del progetto | filters on the platform, writable | The description of the project. | |
Quotation |
datetime |
Data di quotazione | filters on the platform, writable | Date on which the quotation version is entered or printed.Both during entering and printing this date can be adjusted. | |
Quotation |
guid |
ID preventivo | filters on the platform, writable | Identifier of the quotation. | |
Quotation |
int32 |
Numero di quotazione | filters on the platform, writable | Unique number to indentify the quotation.By default this number is based on the setting for first available number. | |
Remarks |
varchar2 |
Remarks | filters on the platform, writable | Extra text that can be added to the quotation. | |
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 | ||
Sales |
guid |
proprietario | filters on the platform, writable | The user that is responsible for the quotation version. | |
Sales |
varchar2 |
Nome completo del venditore | filters on the platform, writable | Full name of the sales person. | |
Selection |
guid |
Codice di selezione | filters on the platform, writable | ID of selection code.Only supported by the Advanced and Premium editions for Wholesale & Distribution and Manufacturing. | |
Selection |
varchar2 |
Codice di selezione | filters on the platform, writable | Code of selection code. | |
Selection |
varchar2 |
itgen_eol_selectioncodedescription | filtri sulla piattaforma | Description of selection code. | |
Shipping |
guid |
Metodo di spedizione | filters on the platform, writable | ||
Shipping |
varchar2 |
Descrizione del metodo di spedizione | filtri sulla piattaforma | ||
Status |
int16 |
Status | filters on the platform, writable | The status of the quotation version.5 = Rejected, 6 = Reviewed and closed, 10 = Recovery, 20 = Draft, 25 = Open, 35 = Processing... , 40 = Printed, 50 = Accepted. | |
Status |
varchar2 |
Descrizione dello stato | writable | The description of the status. | |
VAT |
double |
Importo IVA in valuta estera | filters on the platform, writable | Total VAT amount in the currency of the transaction. | |
Version |
int32 |
Numero della versione | filters on the platform, writable | Number indicating the different reviews which are made for the quotation. | |
Warehouse |
varchar2 |
Codice del magazzino | filtri sulla piattaforma | ||
Warehouse |
varchar2 |
Descrizione del magazzino | filtri sulla piattaforma | ||
Warehouse |
guid |
ID magazzino | filters on the platform, writable | ||
Your |
varchar2 |
Il tuo Riferimento | filters on the platform, writable | The number by which this quotation is identified by the order account. |
Chiavi
| Key | Column | Si riferisce a | Kind | Description |
|---|---|---|---|---|
Quotations_ |
Creator |
Users. |
Key | |
Quotations_ |
Currency |
Currencies.Code |
Key | |
Quotations_ |
Delivery |
Contacts.ID |
Key | |
Quotations_ |
Delivery |
Accounts.ID |
Key | |
Quotations_ |
Delivery |
Addresses.ID |
Key | |
Quotations_ |
Document |
Documents.ID |
Key | |
Quotations_ |
Invoice |
Contacts.ID |
Key | |
Quotations_ |
Invoice |
Accounts.ID |
Key | |
Quotations_ |
Modifier |
Users. |
Key | |
Quotations_ |
Opportunity |
Opportunities.ID |
Key | |
Quotations_ |
Order |
Contacts.ID |
Key | |
Quotations_ |
Order |
Accounts.ID |
Key | |
Quotations_ |
Project |
Projects.ID |
Key | |
Quotations_ |
Sales |
Users. |
Key | |
Quotations_ |
Selection |
SelectionCodes.ID |
Key |
Riferito da
- QuotationLines
QuotationID(Key) - QuotationLinesBulk
QuotationID(Key) - Projects
SourceQuotation(Key)
Note di rilascio
Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: