SalesInvoiceLinesBulk: Exact Online Sales Invoice Lines
read only per partition webhook REST
- Catalogue :
ExactOnlineREST - Schéma :
SalesInvoice - Clés primaires :
ID - Label: Sales Invoice Lines
Les données de cette table sont partitionnées en fonction de la valeur de la colonne Division.
Permet uniquement de récupérer des données.
Les modifications sont transmises via le sujet de webhook SalesInvoices le InvoiceID.
Source de l'API
- Point de terminaison :
/api/v1/{division}/bulk/SalesInvoice/SalesInvoiceLines - Métadonnées :
/api/v1/{division}/bulk/SalesInvoice/$metadata
Caractéristiques de performance
| Characteristic | Value |
|---|---|
| Latence moyenne d'accès (ms) | 5 |
| Nombre de lignes par minute en mode de balayage complet | 20,000 |
| 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 SalesInvoiceLinesBulk 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 | 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 | For normal lines it's the amount excluding VAT. | ||
Cost |
varchar2 |
Centre de coûts | filtres disponibles sur la plateforme | Reference to Cost center. | |
Cost |
varchar2 |
Description du centre de coûts | Description of CostCenter. | ||
Cost |
varchar2 |
Unité de coût | filtres disponibles sur la plateforme | Reference to Cost unit. | |
Cost |
varchar2 |
Description des unités de coût | Description of CostUnit. | ||
Custom |
varchar2 |
Champ personnalisé | writable | ||
Customer |
varchar2 |
Code article client | Code the customer uses for this item. | ||
Delivery |
datetime |
Date de livraison | Delivery date of an item in a sales invoice.This is used for VAT on prepayments, only if sales order is not used in the license. | ||
Description |
varchar2 |
Description | Description.Can be different for header and lines. | ||
Discount |
double |
Discount | Discount given on the default price.Discount = (DefaultPrice of Item - PriceItem in line) / DefaultPrice of Item. | ||
Division |
int32 |
ID de l'entreprise | Unique number of the Exact Online division. | ||
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. | |
Employee |
guid |
Employee | filtres disponibles sur la plateforme | Link to Employee originating from time and cost transactions. | |
Employee |
varchar2 |
Nom complet de l’employé | Name of employee. | ||
End |
datetime |
Heure de fin | EndTime is used to store the last date of a period.EndTime is used in combination with StartTime. | ||
Extra |
double |
Montant de la surtaxe en devise étrangère | 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 (%) | Extra duty percentage. | ||
GL |
guid |
Compte du grand livre | filtres disponibles sur la plateforme | The GL Account of the sales invoice line.This field is mandatory.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 |
Description du compte GL | Description of GLAccount. | ||
ID |
guid |
ID | filtres disponibles sur la plateforme | Primary key. | |
Invoice |
guid |
ID Facture | filtres disponibles sur la plateforme | The InvoiceID identifies the sales invoice.All the lines of a sales invoice have the same InvoiceID. | |
Item |
guid |
Item | filtres disponibles sur la plateforme | Reference to the item that is sold in this sales invoice line. | |
Item |
varchar2 |
Code de l'article | Item code. | ||
Item |
varchar2 |
Description de l’article | Description of Item. | ||
Line |
int32 |
Numéro de ligne | filtres disponibles sur la plateforme | Indicates the sequence of the lines within one invoice. | |
Net |
double |
Montant net Division Devise | writable | Net amount in division currency of sales invoice line. | |
Net |
double |
Montant net en devise étrangère | writable | Net amount in foreign currency of sales invoice line. | |
Net |
double |
Prix net | Net price of the sales invoice line. | ||
Notes |
varchar2 |
Notes | Extra notes. | ||
Pricelist |
guid |
Tarif | filtres disponibles sur la plateforme | Price list. | |
Pricelist |
varchar2 |
Description de la liste des prix | Description of Pricelist. | ||
Project |
guid |
Project | filtres disponibles sur la plateforme | 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 | Description of Project. | ||
Project |
guid |
Structure de répartition du travail (WBS) du projet | WBS linked to the sales invoice. | ||
Project |
varchar2 |
Description de la structure de répartition du travail (WBS) du projet | Description of WBS. | ||
Quantity |
double |
Quantity | The number of items sold in default units.The quantity shown in the entry screen is Quantity * UnitFactor. | ||
Sales |
guid |
Commande Client | Identifies the sales order this invoice line is based on. | ||
Sales |
guid |
Ligne de commande client | Identifies the sales order line this sales invoice line is based on. | ||
Sales |
int32 |
Numéro de ligne de commande client | Then line number of the sales order line on which this invoice line is based on. | ||
Sales |
int32 |
Numéro de commande client | The order number of the sales order on which this invoice line is based on. | ||
Start |
datetime |
Heure de début | StartTime is used to store the first date of a period.StartTime is used in combination with EndTime. | ||
Subscription |
guid |
Subscription | filtres disponibles sur la plateforme | When generating invoices from subscriptions, this field records the link between invoice lines and subscription lines. | |
Subscription |
varchar2 |
Description de l'abonnement | Description of subscription line. | ||
Tax |
guid |
Barème fiscal | filtres disponibles sur la plateforme | Obsolete. | |
Tax |
varchar2 |
Code de barème fiscal | Obsolete. | ||
Tax |
varchar2 |
Description des barèmes fiscaux | Obsolete. | ||
Unit |
varchar2 |
Code de l'unité | Code of Unit. | ||
Unit |
varchar2 |
Description d'unité | Description of Unit. | ||
Unit |
double |
Prix unitaire | Price per unit. | ||
VAT |
double |
Montant de la TVA / Division / Devise | VAT amount in the default currency of the company. | ||
VAT |
double |
Montant de la TVA en devise étrangère | VAT amount in the currency of the transaction. | ||
VAT |
varchar2 |
Code TVA | filtres disponibles sur la plateforme | The VAT code that is used when the invoice is registered. | |
VAT |
varchar2 |
Code TVA Description | Description of VATCode. | ||
VAT |
double |
Pourcentage de TVA | The vat percentage of the VAT code.This is the percentage at the moment the invoice is created.It's also used for the default calculation of VAT amounts and VAT base amounts. |
Clés
| Key | Column | Se réfère à | Kind | Description |
|---|---|---|---|---|
Sales |
Cost |
Costcenters.Code |
Key | |
Sales |
Cost |
Costunits.Code |
Key | |
Sales |
Employee |
Employees.ID |
Key | |
Sales |
GL |
GLAccounts.ID |
Key | |
Sales |
Invoice |
SalesInvoices. |
Key | |
Sales |
Item |
Items.ID |
Key | |
Sales |
Pricelist |
SalesPriceLists.ID |
Key | |
Sales |
Project |
ProjectWBS.ID |
Key | |
Sales |
Project |
Projects.ID |
Key | |
Sales |
Sales |
SalesOrderLines.ID |
Key | |
Sales |
Sales |
SalesOrders. |
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 :