SalesEntryLines: Exact Online Sales Entry Lines
insert update delete per partition webhook REST
- Catalogue :
ExactOnlineREST - Schéma :
SalesEntry - Clés primaires :
ID - Label: Sales 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 SalesEntries le EntryID.
Source de l'API
- Point de terminaison :
/api/v1/{division}/salesentry/SalesEntryLines - Métadonnées :
/api/v1/{division}/salesentry/$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 SalesEntryLines 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.For almost all lines this can be calculated like: AmountDC = AmountFC * RateFC. | |
Amount |
double |
Montant en devise étrangère | filters on the platform, writable | For normal lines it's the amount excluding VAT. | |
Asset |
guid |
Asset | filters on the platform, writable | Reference to Asset. | |
Asset |
varchar2 |
Description de l'actif | filters on the platform, writable | Description of Asset. | |
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.Can be different for header and lines. | |
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 | The unique ID of the entry.Via this ID all transaction lines of a single entry can be retrieved. | |
Extra |
double |
Montant de la surtaxe en devise étrangère | filters on the platform, writable | Extra duty amount in the currency of the transaction.Both extra duty amount and VAT amount need to be specified in order to differ this property from automatically calculated. | |
Extra |
double |
Supplément (%) | filters on the platform, writable | Extra duty percentage for the item. | |
From |
datetime |
From | writable | From date for deferred revenue. | |
GL |
guid |
Compte du grand livre | filters on the platform, writable | The GL Account of the invoice line.This field is generated based on the revenue account of the item (or the related item group).G/L Account is also used to determine whether the costcenter / costunit is mandatory. | |
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 | Indicates the sequence of the lines within one entry. | |
Net |
double |
Montant net Division Devise | writable | Net amount in division currency of sales entry line. | |
Net |
double |
Montant net en devise étrangère | writable | Net amount in foreign currency of sales entry line. | |
Notes |
varchar2 |
Notes | filters on the platform, writable | Extra notes. | |
Project |
guid |
Project | filters on the platform, writable | The project to which the sales transaction line is linked.The project can be different per line.Sometimes also the project in the header is filled although this is not really used. | |
Project |
varchar2 |
Description du projet | filters on the platform, writable | Description of Project. | |
Project |
guid |
Structure de répartition du travail (WBS) du projet | writable | Project WBS ID. | |
Project |
varchar2 |
Description de la structure de répartition du travail (WBS) du projet | writable | Project WBS description. | |
Quantity |
double |
Quantity | filters on the platform, writable | The number of items sold in default units.The quantity shown in the entry screen is Quantity * UnitFactor. | |
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 | When generating invoices from subscriptions, this field records the link between invoice lines and subscription lines. | |
Subscription |
varchar2 |
Description de l'abonnement | filters on the platform, writable | Description of Subscription. | |
Tax |
guid |
Barème fiscal | filters on the platform, writable | Obsolete. | |
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 TrackingNumber. | |
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: 20 = Sales entry, 21 = Sales 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.However if the transaction uses extra duty, extra duty amount also needs to be specified. | |
VAT |
double |
Montant de base de la TVA / Devise de division | filters on the platform, writable | The VAT base amount in the default currency of the company.This is calculated based on the VATBaseAmountFC. | |
VAT |
double |
Montant de base de la TVA en devise étrangère | filters on the platform, writable | The VAT base amount in invoice currency.This is calculated with the use of VAT codes.It's an internal value. | |
VAT |
varchar2 |
Code TVA | filters on the platform, writable | The VAT code used when the invoice was registered. | |
VAT |
varchar2 |
Code TVA Description | filters on the platform, writable | Description of 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 |
|---|---|---|---|---|
Sales |
Asset |
Assets.ID |
Key | |
Sales |
Cost |
Costcenters.Code |
Key | |
Sales |
Cost |
Costunits.Code |
Key | |
Sales |
GL |
GLAccounts.ID |
Key | |
Sales |
Project |
ProjectWBS.ID |
Key | |
Sales |
Project |
Projects.ID |
Key | |
Sales |
Subscription |
Subscriptions. |
Key | |
Sales |
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 :