PurchaseEntryLines: Exact Online Purchase Entry Lines
insert update delete per partition webhook REST
- Catalogue :
ExactOnlineREST - Schéma :
PurchaseEntry - Clés primaires :
ID - Label: Purchase Entry 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 PurchaseEntries le EntryID.
Source de l'API
- Point de terminaison :
/api/v1/{division}/purchaseentry/PurchaseEntryLines - Métadonnées :
/api/v1/{division}/purchaseentry/$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 PurchaseEntryLines 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. | |
Asset |
guid |
Asset | filters on the platform, writable | Reference to asset. | |
Asset |
varchar2 |
Description de l'actif | filters on the platform, writable | Asset description. | |
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. | |
Custom |
varchar2 |
Champ personnalisé | writable | ||
Description |
varchar2 |
Description | filters on the platform, writable | Description. | |
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. | |
Entry |
guid |
Identifiant de l'entrée | filters on the platform, writable | Reference to header of the purchase entry. | |
Expense |
guid |
Expense | filtres disponibles sur la plateforme | ||
Expense |
varchar2 |
Description des dépenses | filtres disponibles sur la plateforme | ||
From |
datetime |
From | writable | From date for deferred revenue. | |
GL |
guid |
Compte du grand livre | filters on the platform, writable | General ledger account. | |
GL |
varchar2 |
Code comptable GL | filters on the platform, writable | Code of the G/L account. | |
GL |
varchar2 |
Description du compte GL | filters on the platform, writable | Description of the G/L account. | |
ID |
guid |
ID | filters on the platform, writable | Primary key. | |
Intra |
varchar2 |
Zone Intrastat | filters on the platform, writable | IntraStat area. | |
Intra |
varchar2 |
Pays Intrastat | filters on the platform, writable | IntraStatCountry. | |
Intra |
varchar2 |
Délai de transmission des données Intrastat | filters on the platform, writable | IntraStat delivery term. | |
Intra |
varchar2 |
Transaction Intrastat A | filters on the platform, writable | IntraStat transaction a. | |
Intra |
varchar2 |
Transaction Intrastat B | filtres disponibles sur la plateforme | ||
Intra |
varchar2 |
Mode de transport Intrastat | filters on the platform, writable | IntraStat transport method. | |
Line |
int32 |
Numéro de ligne | filters on the platform, writable | Line number. | |
Net |
double |
Montant net Division Devise | writable | Net amount in division currency of purchase entry line. | |
Net |
double |
Montant net en devise étrangère | writable | Net amount in foreign currency of purchase entry line. | |
Notes |
varchar2 |
Notes | filters on the platform, writable | Extra remarks. | |
Private |
double |
itgen_eol_privateusepercentage | filters on the platform, writable | Percentage of re-invoice part of a cost to the GlobalState of the company. | |
Project |
guid |
Project | filters on the platform, writable | Reference to project. | |
Project |
varchar2 |
Description du projet | filters on the platform, writable | Description of Project. | |
Quantity |
double |
Quantity | filters on the platform, writable | Quantity. | |
Serial |
varchar2 |
Numéro de Série | filters on the platform, writable | Serial number. | |
Statistical |
double |
Poids net statistique | filters on the platform, writable | Statistical NetWeight. | |
Statistical |
varchar2 |
Chiffre statistique | filters on the platform, writable | Statistical Number (also known as 'Goederencode'). | |
Statistical |
double |
Grandeur statistique | filters on the platform, writable | Statistical Quantity. | |
Statistical |
double |
Valeur statistique | filters on the platform, writable | Statistical Value. | |
Subscription |
guid |
Subscription | filters on the platform, writable | Reference to subscription. | |
Subscription |
varchar2 |
Description de l'abonnement | filters on the platform, writable | Description of Subscription. | |
To |
datetime |
To | filters on the platform, writable | To date for deferred revenue. | |
Tracking |
guid |
Numéro de suivi | filters on the platform, writable | Reference to tracking number. | |
Tracking |
varchar2 |
Description du numéro de suivi | filters on the platform, writable | Description of TrackingNumber. | |
Type |
int32 |
Type | filters on the platform, writable | Type: 30 = Purchase entry, 31 = Purchase credit note. | |
VAT |
double |
Montant de la TVA / Division / Devise | writable | VAT amount in the default currency of the company. | |
VAT |
double |
Montant de la TVA en devise étrangère | filters on the platform, writable | VAT amount in the currency of the transaction.Use this property to specify a VAT amount that differs from the VAT amount that is automatically calculated. | |
VAT |
double |
Montant de base de la TVA / Devise de division | filters on the platform, writable | VAT base amount in the default currency of the company. | |
VAT |
double |
Montant de base de la TVA en devise étrangère | filters on the platform, writable | VAT base amount in the currency of the transaction. | |
VAT |
varchar2 |
Code TVA | filters on the platform, writable | VAT code. | |
VAT |
varchar2 |
Code TVA Description | filters on the platform, writable | Description of VAT code. | |
VAT |
double |
itgen_eol_vatnondeductiblepercentage | filters on the platform, writable | If not the full amount of the VAT is deductible, you can indicate a percentage for the non decuctible part.This is used during the entry of purchase invoices. | |
VAT |
double |
Pourcentage de TVA | filters on the platform, writable | VAT percentage. | |
Withholding |
double |
Montant de la retenue à la source / Division / Devise | filters on the platform, writable | Withholding tax amount for spanish legislation. | |
Withholding |
varchar2 |
Retenue à la source | filters on the platform, writable | Withholding tax key for spanish legislation. |
Clés
| Key | Column | Se réfère à | Kind | Description |
|---|---|---|---|---|
Purchase |
Asset |
Assets.ID |
Key | |
Purchase |
Cost |
Costcenters.Code |
Key | |
Purchase |
Cost |
Costunits.Code |
Key | |
Purchase |
GL |
GLAccounts.ID |
Key | |
Purchase |
Project |
Projects.ID |
Key | |
Purchase |
Subscription |
Subscriptions. |
Key | |
Purchase |
VAT |
VATCodes.Code |
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 :