PurchaseOrderLines: Exact Online Purchase Order Lines
insert update delete per partition webhook REST
- Catalogue :
ExactOnlineREST - Schéma :
PurchaseOrder - Clés primaires :
ID - Label: Purchase Order Lines
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 PurchaseOrders le PurchaseOrderID.
Source de l'API
- Point de terminaison :
/api/v1/{division}/purchaseorder/PurchaseOrderLines - Métadonnées :
/api/v1/{division}/purchaseorder/$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 PurchaseOrderLines 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 | filters on the platform, writable | Amount in the default currency of the company. | |
Amount |
double |
Montant en devise étrangère | filters on the platform, writable | Amount in the currency of the transaction. | |
Cost |
varchar2 |
Centre de coûts | filters on the platform, writable | Reference to Cost center. | |
Cost |
varchar2 |
Description du centre de coûts | filters on the platform, writable | Description of CostCenter. | |
Cost |
varchar2 |
Unité de coût | filters on the platform, writable | Reference to Cost unit. | |
Cost |
varchar2 |
Description des unités de coût | filters on the platform, writable | Description of CostUnit. | |
Created |
datetime |
Created | filters on the platform, writable | Creation date. | |
Created |
datetime |
Créé | writable | Creation date in UTC. | |
Creator |
guid |
Creator | filters on the platform, writable | User ID of creator. | |
Creator |
varchar2 |
Nom complet de l'auteur | filters on the platform, writable | Name of creator. | |
Custom |
varchar2 |
Champ personnalisé | writable | ||
Description |
varchar2 |
Description | filters on the platform, writable | Description of the purchase order line. | |
Discount |
double |
Discount | filters on the platform, writable | Discount in percentage for item. | |
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. | |
Expense |
guid |
Expense | filters on the platform, writable | Expense related to the Work Breakdown Structure of the selected project.Only available with a professional service license. | |
Expense |
varchar2 |
Description des dépenses | filters on the platform, writable | Description of expense.Only available with a professional service license. | |
ID |
guid |
ID | filters on the platform, writable | Primary key. | |
In |
double |
En stock | writable | The current stock level of items shown in stock unit.The information is displayed only for items with the stock property selected. | |
Invoiced |
double |
Quantité facturée | writable | Quantity of item that has been invoiced. | |
Is |
int16 |
Le numéro de lot correspond-il à l'article ? | filtres disponibles sur la plateforme | ||
Is |
int16 |
S'agit-il d'un article avec numéro de série ? | filtres disponibles sur la plateforme | ||
Item |
guid |
Item | filters on the platform, writable | Reference to the item for purchase order. | |
Item |
varchar2 |
Code-barres de l'article | filtres disponibles sur la plateforme | ||
Item |
varchar2 |
itgen_eol_itembarcodeadditional | filters on the platform, writable | ||
Item |
varchar2 |
Code de l'article | filters on the platform, writable | Item code. | |
Item |
varchar2 |
Description de l’article | filters on the platform, writable | Description of item. | |
Item |
char |
Article divisible | filters on the platform, writable | Indicates if fractional quantities of the item can be used, for example quantity = 0.4. | |
Line |
int32 |
Numéro de ligne | filters on the platform, writable | Line number. | |
Modified |
datetime |
Modified | filters on the platform, writable | Last modified date. | |
Modified |
datetime |
Modifié (UTC) | writable | Last modified date in UTC. | |
Modifier |
guid |
Modifier | filters on the platform, writable | User ID of modifier. | |
Modifier |
varchar2 |
Nom complet modifié | filters on the platform, writable | Name of modifier. | |
Net |
double |
Prix net | filters on the platform, writable | The net price is the unit price (VAT code taken into account) with any discount applied. | |
Notes |
varchar2 |
Notes | filters on the platform, writable | Notes. | |
Project |
guid |
Project | filters on the platform, writable | Reference to project.Only available with a professional service license. | |
Project |
varchar2 |
Code de projet | filters on the platform, writable | Project code.Only available with a professional service license. | |
Project |
varchar2 |
Description du projet | filters on the platform, writable | Description of the project.Only available with a professional service license. | |
Projected |
double |
Stock prévu | writable | The current stock level + the planned quantity to be received - the planned quantity to deliver shown in stock unit. | |
Purchase |
guid |
ID de bon de commande | filters on the platform, writable | Identifies the purchase order.All the lines of a purchase order have the same PurchaseOrderID. | |
Quantity |
double |
Quantity | filters on the platform, writable | Quantity in item units. | |
Quantity |
double |
Quantité en unités d'achat | writable | Quantity in purchase units.Use this field when creating a purchase order. | |
Rebill |
char |
Rebill | filters on the platform, writable | Indicates whether the purchase order line needs to be rebilled.Only available with a professional service license. | |
Receipt |
datetime |
Date de réception | filters on the platform, writable | Date the goods are expected to be received. | |
Received |
double |
Quantité réceptionnée | writable | Quantity of goods received. | |
Sales |
guid |
Commande Client | filters on the platform, writable | Sales order that is linked to a back to back sales order in purchase order. | |
Sales |
guid |
Ligne de commande client | filters on the platform, writable | Sales order line of the sales order that is linked to a back to back sales order in purchase order. | |
Sales |
int32 |
Numéro de ligne de commande client | filters on the platform, writable | Number of the sales order line. | |
Sales |
int32 |
Numéro de commande client | filters on the platform, writable | Number of the sales order. | |
Shop |
guid |
Commande d'atelier | filters on the platform, writable | ||
Shop |
guid |
itgen_eol_shopordermaterialplan | filters on the platform, writable | ||
Shop |
int32 |
itgen_eol_shopordermaterialplanlinenumber | filtres disponibles sur la plateforme | ||
Shop |
int32 |
Numéro de commande | filtres disponibles sur la plateforme | ||
Shop |
guid |
itgen_eol_shoporderroutingstepplan | filters on the platform, writable | ||
Shop |
int32 |
itgen_eol_shoporderroutingstepplanlinenumber | filtres disponibles sur la plateforme | ||
Supplier |
varchar2 |
Code article du fournisseur | writable | Code the supplier uses for this item. | |
Supplier |
int16 |
itgen_eol_supplieritemcopyremarks | writable | Indicate if the notes content should be copied from SupplierItem's remarks.The default follows the CopyRemarks value from SupplierItem.Values: 0 = Do not copy remark, 1 = Copy remark. | |
Unit |
varchar2 |
Unit | filters on the platform, writable | Code of item unit. | |
Unit |
varchar2 |
Description d'unité | filters on the platform, writable | Description of unit. | |
Unit |
double |
Prix unitaire | writable | Item price per purchase unit. | |
VAT |
double |
Montant TVA | filters on the platform, writable | Amount of VAT charges calculated from total amount and vat percentage. | |
VAT |
varchar2 |
Code TVA | filters on the platform, writable | The VAT code used when the invoice was registered. | |
VAT |
varchar2 |
Description de la TVA | filters on the platform, writable | Description of the VAT code. | |
VAT |
double |
Pourcentage de TVA | filters on the platform, writable | The VAT percentage of the VAT code.This is the percentage at the moment the invoice is created.It's also used by the default calculation of VAT amounts and VAT base amounts. |
Clés
| Key | Column | Se réfère à | Kind | Description |
|---|---|---|---|---|
Purchase |
Cost |
Costcenters.Code |
Key | |
Purchase |
Cost |
Costunits.Code |
Key | |
Purchase |
Creator |
Users. |
Key | |
Purchase |
Item |
Items.ID |
Key | |
Purchase |
Modifier |
Users. |
Key | |
Purchase |
Project |
Projects.ID |
Key | |
Purchase |
Purchase |
PurchaseOrders. |
Key | |
Purchase |
Sales |
SalesOrderLines.ID |
Key | |
Purchase |
Sales |
SalesOrders. |
Key | |
Purchase |
Unit |
Units.Code |
Key | |
Purchase |
VAT |
VATCodes.Code |
Key |
Référencée
- PurchaseInvoiceLines
PurchaseOrderLine(Key) - GoodsReceiptLines
PurchaseOrderLineID(Key) - SalesOrderLines
PurchaseOrderLine(Key) - SalesOrderLinesBulk
PurchaseOrderLine(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 :