invantive documentation
Forums d'Invantive SupportConnectez-vous/inscrivez-vous

Quotations: Exact Online Quotations

insert update delete 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 de récupérer et de modifier des données à l'aide de insert, update et delete.

Les modifications sont transmises via le sujet de webhook Quotations.

Source de l'API

  • Point de terminaison : /api/v1/{division}/crm/Quotations
  • Métadonnées : /api/v1/{division}/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 7,200
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 Quotations 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
AmountDC double Montant Division Devise filters on the platform, writable Amount in the default currency of the company.
AmountDiscount double Montant de la remise filters on the platform, writable
AmountDiscountExclVat double Montant de la remise hors TVA filters on the platform, writable
AmountFC double Montant en devise étrangère filters on the platform, writable Amount in the currency of the transaction.
CloseDate datetime Date de clôture filters on the platform, writable Date on which the customer accepted or rejected the quotation version.
ClosingDate datetime Date de clôture 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.
CreatedUtc datetime Créé writable Creation date in UTC.
Creator guid Creator filters on the platform, writable User ID of creator.
CreatorFullName varchar2(240) Nom complet de l'auteur filters on the platform, writable Name of creator.
Currency varchar2(30) Currency filters on the platform, writable The currency of the quotation.
DeliveryAccount guid Compte de livraison filters on the platform, writable The account where the items should delivered.
DeliveryAccountCode varchar2(18) Code de compte de livraison filters on the platform, writable The code of the delivery account.
DeliveryAccountContact guid Compte de livraison - Contact filters on the platform, writable The contact person of the delivery account.
DeliveryAccountContactFullName varchar2(240) Compte de livraison - Nom complet de la personne à contacter filters on the platform, writable Full name of the delivery account contact person.
DeliveryAccountName varchar2(50) Nom du compte de livraison filters on the platform, writable The name of the delivery account.
DeliveryAddress guid Adresse de livraison filters on the platform, writable The id of the delivery address.
DeliveryDate datetime Date de livraison filters on the platform, writable
Description varchar2 Description filters on the platform, writable The description of the quotation.
Division int32 Division Division code.
DivisionCompanyCoCNumber varchar2(60) Numéro d'enregistrement à la Chambre de commerce de la division writable Chamber of commerce number of the Exact Online division.
DivisionCompanyIBANNumber varchar2(50) Numéro IBAN de la division writable IBAN number of the Exact Online division.
DivisionCompanyName varchar2(50) Division - Nom de l'entreprise writable Company name of the Exact Online division.
DivisionCompanyRSINNumber varchar2(9) Numéro de division RSIN writable RSIN number of the Exact Online division.
DivisionCompanyVATNumber varchar2(35) Numéro de TVA de la division writable VAT number of the Exact Online division.
DivisionCompanyWageTaxNumber varchar2(60) Numéro d'identification fiscale de la division writable Wage tax number of the Exact Online division.
DivisionLabel varchar2(128) Étiquette de division writable Label of the Exact Online division.
DivisionName varchar2(50) Nom de l'administration writable Name of the Exact Online division.
DivisionOwnerCompanyName varchar2(50) 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.
DivisionOwnerCompanyNumber varchar2(18) Numéro d'abonné writable Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs.
DivisionShortName int64 Nom abrégé de la division writable Short name of the Exact Online division.
Document guid Document filters on the platform, writable Document linked to the quotation.
DocumentSubject varchar2(256) Objet du document filters on the platform, writable The subject of the document.
DueDate datetime Date d'Échéance filters on the platform, writable Date after which the quotation is no longer valid.
IncotermAddress varchar2 Adresse selon les Incoterms filters on the platform, writable
IncotermCode varchar2 Code Incoterm filters on the platform, writable
IncotermVersion int16 Version des Incoterms filters on the platform, writable
InvoiceAccount guid Compte de facturation filters on the platform, writable The account to which the invoice is sent.
InvoiceAccountCode varchar2(18) Code de compte de facturation filters on the platform, writable The code of the invoice account.
InvoiceAccountContact guid Facture, Compte, Contact filters on the platform, writable The contact person of the invoice account.
InvoiceAccountContactFullName varchar2(240) Facture Compte Nom complet du contact filters on the platform, writable Full name of the invoice account contact person.
InvoiceAccountName varchar2(50) Nom du compte de facturation filters on the platform, writable The name of the invoice account.
Modified datetime Modified filters on the platform, writable Last modified date.
ModifiedUtc datetime Modifié (UTC) writable Last modified date in UTC.
Modifier guid Modifier filters on the platform, writable User ID of modifier.
ModifierFullName varchar2(240) Nom complet modifié filters on the platform, writable Name of modifier.
Opportunity guid Opportunity filters on the platform, writable Opportunity linked to the quotation.
OpportunityName varchar2 Nom de l'opportunité filters on the platform, writable The name of the opportunity.
OrderAccount guid Compte de commande filters on the platform, writable The account that requested the quotation.
OrderAccountCode varchar2(18) Code de compte de commande filters on the platform, writable The code of the order account.
OrderAccountContact guid Commande Compte Contact filters on the platform, writable The contact person of the order account.
OrderAccountContactFullName varchar2(240) itgen_eol_orderaccountcontactfullname filters on the platform, writable Full name of the order account contact person.
OrderAccountName varchar2(50) Nom du compte de commande filters on the platform, writable The name of the order account.
PaymentCondition varchar2 Condition de paiement filters on the platform, writable
PaymentConditionDescription varchar2 Description des conditions de paiement filtres disponibles sur la plateforme
Project guid Project filters on the platform, writable The project linked to the quotation.
ProjectCode varchar2(20) Code de projet filters on the platform, writable The code of the project.
ProjectDescription varchar2(60) Description du projet filters on the platform, writable The description of the project.
QuotationDate datetime Date de cotation 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.
QuotationID guid Référence du devis filters on the platform, writable Identifier of the quotation.
QuotationNumber int32 Numéro de devis 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.
SalesChannel guid Le canal de vente filtres disponibles sur la plateforme
SalesChannelCode varchar2 Code du canal de vente filtres disponibles sur la plateforme
SalesChannelDescription varchar2 Description du canal de vente filtres disponibles sur la plateforme
SalesPerson guid Vendeur filters on the platform, writable The user that is responsible for the quotation version.
SalesPersonFullName varchar2(240) Nom complet du commercial filters on the platform, writable Full name of the sales person.
SelectionCode guid Code de sélection filters on the platform, writable ID of selection code.Only supported by the Advanced and Premium editions for Wholesale & Distribution and Manufacturing.
SelectionCodeCode varchar2 Code de sélection filters on the platform, writable Code of selection code.
SelectionCodeDescription varchar2 itgen_eol_selectioncodedescription filtres disponibles sur la plateforme Description of selection code.
ShippingMethod guid Mode d'expédition filters on the platform, writable
ShippingMethodDescription varchar2 Description du mode de livraison filtres disponibles sur la plateforme
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.
StatusDescription varchar2 Description de l'état writable The description of the status.
VATAmountFC double Montant de la TVA en devise étrangère filters on the platform, writable Total VAT amount in the currency of the transaction.
VersionNumber int32 Numéro de version filters on the platform, writable Number indicating the different reviews which are made for the quotation.
WarehouseCode varchar2 Code d'entrepôt filtres disponibles sur la plateforme
WarehouseDescription varchar2 Description de l'entrepôt filtres disponibles sur la plateforme
WarehouseID guid Référence de l'entrepôt filters on the platform, writable
YourRef varchar2(60) Votre référence filters on the platform, writable 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_fk Creator Users.UserID Key
Quotations_Currency_Currencies_fk Currency Currencies.Code Key
Quotations_DeliveryAccountContact_Contacts_fk DeliveryAccountContact Contacts.ID Key
Quotations_DeliveryAccount_Accounts_fk DeliveryAccount Accounts.ID Key
Quotations_DeliveryAddress_Addresses_fk DeliveryAddress Addresses.ID Key
Quotations_Document_Documents_fk Document Documents.ID Key
Quotations_InvoiceAccountContact_Contacts_fk InvoiceAccountContact Contacts.ID Key
Quotations_InvoiceAccount_Accounts_fk InvoiceAccount Accounts.ID Key
Quotations_Modifier_Users_fk Modifier Users.UserID Key
Quotations_Opportunity_Opportunities_fk Opportunity Opportunities.ID Key
Quotations_OrderAccountContact_Contacts_fk OrderAccountContact Contacts.ID Key
Quotations_OrderAccount_Accounts_fk OrderAccount Accounts.ID Key
Quotations_Project_Projects_fk Project Projects.ID Key
Quotations_SalesPerson_Users_fk SalesPerson Users.UserID Key
Quotations_SelectionCode_SelectionCodes_fk SelectionCode SelectionCodes.ID Key

Référencée

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 :