SalesOrders: Exact Online Sales Orders
insert update delete per partition webhook REST
- Catalogue :
ExactOnlineREST - Schéma :
SalesOrder - Clés primaires :
OrderID - Label: Sales Orders
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 SalesOrders.
Source de l'API
- Point de terminaison :
/api/v1/{division}/salesorder/SalesOrders - Métadonnées :
/api/v1/{division}/salesorder/$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 SalesOrders 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 | writable | Amount in the default currency of the company. | |
Amount |
double |
Montant de la remise | writable | Discount amount in the default currency of the company. | |
Amount |
double |
Montant de la remise hors TVA | writable | Discount amount exclude VAT in the default currency of the company. | |
Amount |
double |
Montant en devise étrangère | writable | Amount in the currency of the transaction. | |
Amount |
double |
Montant en devise étrangère hors TVA | writable | Amount exclude VAT in the currency of the transaction. | |
Approval |
int16 |
Statut Approuvé | filters on the platform, writable | Shows if this sales order is approved. | |
Approval |
varchar2 |
Description du statut d'approbation | 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 |
Nom complet du responsable de la validation | writable | Name of approver. | |
Created |
datetime |
Created | filters on the platform, writable | Creation date. | |
Created |
datetime |
Créé | writable | Creation date in UTC. | |
Creator |
guid |
Creator | writable | User ID of creator. | |
Creator |
varchar2 |
Nom complet de l'auteur | writable | Name of creator. | |
Currency |
varchar2 |
Currency | writable | Currency code. | |
Deliver |
guid |
Livrer à | filters on the platform, writable | Reference to delivery customer. | |
Deliver |
guid |
Livrer à la personne de contact | filters on the platform, writable | Reference to contact person of delivery customer. | |
Deliver |
varchar2 |
Nom complet de la personne à contacter pour la livraison | writable | Name of contact person of delivery customer. | |
Deliver |
varchar2 |
Livrer à Nom | writable | Name of delivery customer. | |
Delivery |
guid |
Adresse de livraison | filters on the platform, writable | Delivery address. | |
Delivery |
datetime |
Date de livraison | filters on the platform, writable | Delivery date. | |
Delivery |
int16 |
État de la livraison | filters on the platform, writable | Delivery status; 12=Open, 20=Partial, 21=Complete, 45=Canceled. | |
Delivery |
varchar2 |
Description de l'état de la livraison | 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 |
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 | filters on the platform, writable | Document that is manually linked to the sales order. | |
Document |
int32 |
Numéro de document | writable | Number of the document. | |
Document |
varchar2 |
Objet du document | writable | Subject of the document. | |
Incoterm |
varchar2 |
Adresse selon les Incoterms | filters on the platform, writable | ||
Incoterm |
varchar2 |
Code Incoterm | filters on the platform, writable | ||
Incoterm |
int16 |
Version des Incoterms | filters on the platform, writable | ||
Invoice |
int16 |
Statut de la facture | filters on the platform, writable | Invoice status; 10=draft, 20=open, 50=processed. | |
Invoice |
varchar2 |
Description du statut de la facture | writable | Description of InvoiceStatus. | |
Invoice |
guid |
Facturer à | filters on the platform, writable | Reference to the Customer who will receive the invoice. | |
Invoice |
guid |
Facture à l'attention de la personne de contact | filters on the platform, writable | Reference to the Contact person of the customer who will receive the invoice. | |
Invoice |
varchar2 |
Nom complet de la personne à contacter pour la facturation | writable | Name of the contact person of the customer who will receive the invoice. | |
Invoice |
varchar2 |
Facture à l'attention de Nom | writable | Name of the customer who will receive the invoice. | |
Modified |
datetime |
Modified | filters on the platform, writable | Last modified date. | |
Modified |
datetime |
Modifié (UTC) | writable | Last modified date in UTC. | |
Modifier |
guid |
Modifier | writable | User ID of modifier. | |
Modifier |
varchar2 |
Nom complet modifié | writable | Name of modifier. | |
Order |
datetime |
Date de la commande | filters on the platform, writable | Order date. | |
Order |
guid |
ID de l'ordre | filters on the platform, writable | Primary key. | |
Order |
int32 |
Numéro de Commande | filters on the platform, writable | Number of sales order. | |
Ordered |
guid |
Commandé par | filters on the platform, writable | Customer who ordered the sales order. | |
Ordered |
guid |
Trié par personne de contact | filters on the platform, writable | Contact person of the customer who ordered the sales order. | |
Ordered |
varchar2 |
Trié par nom complet de la personne de contact | writable | Name of contact person of the customer who ordered the sales order. | |
Ordered |
varchar2 |
Classés par nom | writable | Name of the customer who ordered the sales order. | |
Payment |
varchar2 |
Condition de paiement | writable | The payment condition used for due date and discount calculation. | |
Payment |
varchar2 |
Description des conditions de paiement | writable | Description of PaymentCondition. | |
Payment |
varchar2 |
Référence de réglement | filters on the platform, writable | Payment reference for sales order. | |
Remarks |
varchar2 |
Remarks | writable | Extra remarks. | |
Sales |
guid |
Le canal de vente | filtres disponibles sur la plateforme | ||
Sales |
varchar2 |
Code du canal de vente | filtres disponibles sur la plateforme | ||
Sales |
varchar2 |
Description du canal de vente | filtres disponibles sur la plateforme | ||
Salesperson |
guid |
Vendeur | filters on the platform, writable | Sales representative. | |
Salesperson |
varchar2 |
Nom complet du commercial | writable | Name of sales representative. | |
Selection |
guid |
Code de sélection | filtres disponibles sur la plateforme | ID of selection code. | |
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 | filters on the platform, writable | ShippingMethod. | |
Shipping |
varchar2 |
Description du mode de livraison | 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 |
Description de l'état | writable | Description of Status. | |
Tax |
guid |
Barème fiscal | filters on the platform, writable | Obsolete. | |
Tax |
varchar2 |
Code de barème fiscal | writable | Obsolete. | |
Tax |
varchar2 |
Description des barèmes fiscaux | writable | Obsolete. | |
Warehouse |
varchar2 |
Code d'entrepôt | writable | Code of Warehouse. | |
Warehouse |
varchar2 |
Description de l'entrepôt | writable | Description of Warehouse. | |
Warehouse |
guid |
Référence de l'entrepôt | filters on the platform, writable | Warehouse. | |
Your |
varchar2 |
Votre référence | filters on the platform, writable | The reference number of the customer. |
Clés
| Key | Column | Se réfère à | 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 |
Référencée
- PurchaseOrderLines
SalesOrder(Key) - PurchaseOrders
SalesOrder(Key) - SalesInvoiceLines
SalesOrder(Key) - SalesInvoiceLinesBulk
SalesOrder(Key) - SalesOrderLines
OrderID(Key) - SalesOrderLinesBulk
OrderID(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 :