QuotationsBulk: Exact Online Quotations
read only per partition webhook REST
- Catalogue :
ExactOnlineREST - Schéma :
CRM - Clés primaires :
QuotationID - Label: Quotations
Les données de cette table sont partitionnées en fonction de la valeur de la colonne Division.
Permet uniquement de récupérer des données.
Les modifications sont transmises via le sujet de webhook Quotations.
Source de l'API
- Point de terminaison :
/api/v1/{division}/bulk/CRM/Quotations - Métadonnées :
/api/v1/{division}/bulk/CRM/$metadata
Caractéristiques de performance
| Characteristic | Value |
|---|---|
| Latence moyenne d'accès (ms) | 5 |
| Nombre de lignes par minute en mode de balayage complet | 20,000 |
| Nombre de lignes de requêtes ponctuelles par minute | 300 |
| Nombre d'enregistrements écrits par minute | 300 |
Le résultat peut être mis en cache côté client.
Colonnes de table
Les colonnes de la table QuotationsBulk sont présentées ci-dessous. Chaque colonne possède un type de données SQL. Une nouvelle valeur non nulle doit être fournie pour chaque colonne requise à tout moment lors de l'insertion et de la mise à jour.
| Name | Type de données | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
Amount |
double |
Montant Division Devise | Amount in the default currency of the company. | ||
Amount |
double |
Montant de la remise | writable | ||
Amount |
double |
Montant de la remise hors TVA | writable | ||
Amount |
double |
Montant en devise étrangère | Amount in the currency of the transaction. | ||
Close |
datetime |
Date de clôture | Date on which the customer accepted or rejected the quotation version. | ||
Closing |
datetime |
Date de clôture | Date on which you expect to close/win the deal. | ||
Created |
datetime |
Created | Date and time on which the quotation was created. | ||
Created |
datetime |
Créé | writable | Creation date in UTC. | |
Creator |
guid |
Creator | User ID of the creator. | ||
Creator |
varchar2 |
Nom complet de l'auteur | Name of the creator. | ||
Currency |
varchar2 |
Currency | The currency of the quotation. | ||
Delivery |
guid |
Compte de livraison | filtres disponibles sur la plateforme | The account where the items should delivered. | |
Delivery |
varchar2 |
Code de compte de livraison | The code of the delivery account. | ||
Delivery |
guid |
Compte de livraison - Contact | filtres disponibles sur la plateforme | The contact person of the delivery account. | |
Delivery |
varchar2 |
Compte de livraison - Nom complet de la personne à contacter | Full name of the delivery account contact person. | ||
Delivery |
varchar2 |
Nom du compte de livraison | The name of the delivery account. | ||
Delivery |
guid |
Adresse de livraison | filtres disponibles sur la plateforme | The id of the delivery address. | |
Delivery |
datetime |
Date de livraison | |||
Description |
varchar2 |
Description | The description of the quotation. | ||
Division |
int32 |
ID de l'entreprise | Unique number of the Exact Online division. | ||
Division |
varchar2 |
Numéro d'enregistrement à la Chambre de commerce de la division | writable | Chamber of commerce number of the Exact Online division. | |
Division |
varchar2 |
Numéro IBAN de la division | writable | IBAN number of the Exact Online division. | |
Division |
varchar2 |
Division - Nom de l'entreprise | writable | Company name of the Exact Online division. | |
Division |
varchar2 |
Numéro de division RSIN | writable | RSIN number of the Exact Online division. | |
Division |
varchar2 |
Numéro de TVA de la division | writable | VAT number of the Exact Online division. | |
Division |
varchar2 |
Numéro d'identification fiscale de la division | writable | Wage tax number of the Exact Online division. | |
Division |
varchar2 |
Étiquette de division | writable | Label of the Exact Online division. | |
Division |
varchar2 |
Nom de l'administration | writable | Name of the Exact Online division. | |
Division |
varchar2 |
Nom du titulaire de l'abonnement | writable | Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
varchar2 |
Numéro d'abonné | writable | Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
int64 |
Nom abrégé de la division | writable | Short name of the Exact Online division. | |
Document |
guid |
Document | filtres disponibles sur la plateforme | Document linked to the quotation. | |
Document |
varchar2 |
Objet du document | The subject of the document. | ||
Due |
datetime |
Date d'Échéance | Date after which the quotation is no longer valid. | ||
Incoterm |
varchar2 |
Adresse selon les Incoterms | |||
Incoterm |
varchar2 |
Code Incoterm | |||
Incoterm |
int16 |
Version des Incoterms | |||
Invoice |
guid |
Compte de facturation | filtres disponibles sur la plateforme | The account to which the invoice is sent. | |
Invoice |
varchar2 |
Code de compte de facturation | The code of the invoice account. | ||
Invoice |
guid |
Facture, Compte, Contact | filtres disponibles sur la plateforme | The contact person of the invoice account. | |
Invoice |
varchar2 |
Facture Compte Nom complet du contact | Full name of the invoice account contact person. | ||
Invoice |
varchar2 |
Nom du compte de facturation | The name of the invoice account. | ||
Modified |
datetime |
Modified | Date and time on which the quotation was last modified. | ||
Modified |
datetime |
Modifié (UTC) | writable | Last modified date in UTC. | |
Modifier |
guid |
Modifier | User ID of the modifier. | ||
Modifier |
varchar2 |
Nom complet modifié | Name of the modifier. | ||
Opportunity |
guid |
Opportunity | filtres disponibles sur la plateforme | Opportunity linked to the quotation. | |
Opportunity |
varchar2 |
Nom de l'opportunité | The name of the opportunity. | ||
Order |
guid |
Compte de commande | filtres disponibles sur la plateforme | The account that requested the quotation. | |
Order |
varchar2 |
Code de compte de commande | The code of the order account. | ||
Order |
guid |
Commande Compte Contact | filtres disponibles sur la plateforme | The contact person of the order account. | |
Order |
varchar2 |
itgen_eol_orderaccountcontactfullname | Full name of the order account contact person. | ||
Order |
varchar2 |
Nom du compte de commande | The name of the order account. | ||
Payment |
varchar2 |
Condition de paiement | writable | ||
Payment |
varchar2 |
Description des conditions de paiement | |||
Project |
guid |
Project | filtres disponibles sur la plateforme | The project linked to the quotation. | |
Project |
varchar2 |
Code de projet | The code of the project. | ||
Project |
varchar2 |
Description du projet | The description of the project. | ||
Quotation |
datetime |
Date de cotation | filtres disponibles sur la plateforme | Date on which the quotation version is entered or printed.Both during entering and printing this date can be adjusted. | |
Quotation |
guid |
Référence du devis | filtres disponibles sur la plateforme | Identifier of the quotation. | |
Quotation |
int32 |
Numéro de devis | filtres disponibles sur la plateforme | Unique number to indentify the quotation.By default this number is based on the setting for first available number. | |
Remarks |
varchar2 |
Remarks | Extra text that can be added to the quotation. | ||
Sales |
guid |
Le canal de vente | |||
Sales |
varchar2 |
Code du canal de vente | |||
Sales |
varchar2 |
Description du canal de vente | |||
Sales |
guid |
Vendeur | The user that is responsible for the quotation version. | ||
Sales |
varchar2 |
Nom complet du commercial | Full name of the sales person. | ||
Selection |
guid |
Code de sélection | filtres disponibles sur la plateforme | ID of selection code.Only supported by the Advanced and Premium editions for Wholesale & Distribution and Manufacturing. | |
Selection |
varchar2 |
Code de sélection | Code of selection code. | ||
Selection |
varchar2 |
itgen_eol_selectioncodedescription | Description of selection code. | ||
Shipping |
guid |
Mode d'expédition | writable | ||
Shipping |
varchar2 |
Description du mode de livraison | |||
Status |
int16 |
Status | filtres disponibles sur la plateforme | 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 |
Description de l'état | The description of the status. | ||
VAT |
double |
Montant de la TVA en devise étrangère | Total VAT amount in the currency of the transaction. | ||
Version |
int32 |
Numéro de version | filtres disponibles sur la plateforme | Number indicating the different reviews which are made for the quotation. | |
Your |
varchar2 |
Votre référence | The number by which this quotation is identified by the order account. |
Clés
| Key | Column | Se réfère à | 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 |
Notes de Version
Quels ont été les changements apportés à chaque version au niveau des tables, des colonnes, des attributs et des fonctionnalités du chauffeur :