SalesInvoicesBulk: Exact Online Sales Invoices
read only per partition webhook REST
- Catalogue :
ExactOnlineREST - Schéma :
SalesInvoice - Clés primaires :
InvoiceID - Label: Sales Invoices
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.
Source de l'API
- Point de terminaison :
/api/v1/{division}/bulk/SalesInvoice/SalesInvoices - 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 SalesInvoicesBulk 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 | For the header lines (LineNumber = 0) of an entry this is the SUM(AmountDC) of all lines. | ||
Amount |
double |
Montant de la remise | Discount amount in the default currency of the company. | ||
Amount |
double |
Montant de la remise hors TVA | Discount amount exclude VAT in the default currency of the company. | ||
Amount |
double |
Montant en devise étrangère | For the header this is the sum of all lines, including VAT. | ||
Amount |
double |
Montant en devise étrangère hors TVA | For the header this is the sum of all lines, excluding VAT. | ||
Created |
datetime |
Created | filtres disponibles sur la plateforme | Creation date. | |
Created |
datetime |
Créé | writable | Creation date in UTC. | |
Creator |
guid |
Creator | User ID of creator. | ||
Creator |
varchar2 |
Nom complet de l'auteur | Name of creator. | ||
Currency |
varchar2 |
Currency | Currency for the invoice.Default this is the currency of the administration. | ||
Deliver |
guid |
Livrer à | filtres disponibles sur la plateforme | Delivery account for invoice. | |
Deliver |
guid |
Livrer à l'adresse suivante | filtres disponibles sur la plateforme | Address of delivery as per invoice delivery account. | |
Deliver |
guid |
Livrer à la personne de contact | filtres disponibles sur la plateforme | Delivery account person for invoice. | |
Deliver |
varchar2 |
Nom complet de la personne à contacter pour la livraison | Name of delivery account's contact person as per invoice. | ||
Deliver |
varchar2 |
Livrer à Nom | Name of the delivery account's customer as per invoice. | ||
Description |
varchar2 |
Description | Description.Can be different for header and lines. | ||
Discount |
double |
Discount | Discount percentage. | ||
Discount |
int16 |
Type de réduction | Discount Type. | ||
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. | |
Document |
guid |
Document | filtres disponibles sur la plateforme | Document that is manually linked to the invoice. | |
Document |
int32 |
Numéro de document | Number of the document. | ||
Document |
varchar2 |
Objet du document | Subject of the document. | ||
Due |
datetime |
Date d'Échéance | The due date for payments.This date is calculated based on the EntryDate and the Paymentcondition. | ||
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. | ||
G |
double |
Compte G Montant Devise étrangère | A positive value of the amount indicates that the amount is to be paid by the customer to your G bank account.In case of a credit invoice the amount should have negative value when retrieved or posted to Exact. | ||
Incoterm |
varchar2 |
Adresse selon les Incoterms | |||
Incoterm |
varchar2 |
Code Incoterm | |||
Incoterm |
int16 |
Version des Incoterms | |||
Invoice |
datetime |
Date de facture | filtres disponibles sur la plateforme | Official date for the invoice.When the invoice is entered it's equal to the field 'EntryDate'.During the printing process the invoice date can be entered. | |
Invoice |
guid |
ID Facture | filtres disponibles sur la plateforme | Primary key. | |
Invoice |
int32 |
Numéro de facture | filtres disponibles sur la plateforme | Assigned at entry or at printing depending on setting.The number assigned is based on the freenumbers as defined for the Journal.When printing the field InvoiceNumber is copied to the fields EntryNumber and InvoiceNumber of the sales entry. | |
Invoice |
guid |
Facturer à | filtres disponibles sur la plateforme | Reference to the Customer who will receive the invoice. | |
Invoice |
guid |
Facture à l'attention de la personne de contact | filtres disponibles sur la plateforme | Reference to the Contact person of the customer who will receive the invoice. | |
Invoice |
varchar2 |
Nom complet de la personne à contacter pour la facturation | Name of the contact person of the customer who will receive the invoice. | ||
Invoice |
varchar2 |
Facture à l'attention de Nom | Name of the customer who will receive the invoice. | ||
Is |
char |
S'agit-il d'heures supplémentaires ? | Indicates whether the invoice has extra duty. | ||
Journal |
varchar2 |
Journal | filtres disponibles sur la plateforme | The journal code.Every invoice should be linked to a sales journal. | |
Journal |
varchar2 |
Description de la revue | Description of Journal. | ||
Modified |
datetime |
Modified | Last modified date. | ||
Modified |
datetime |
Modifié (UTC) | writable | Last modified date in UTC. | |
Modifier |
guid |
Modifier | User ID of modifier. | ||
Modifier |
varchar2 |
Nom complet modifié | Name of modifier. | ||
Net |
double |
Montant net Division Devise | writable | Net amount in division currency of sales invoice. | |
Net |
double |
Montant net en devise étrangère | writable | Net amount in foreign currency of sales invoice. | |
Order |
datetime |
Date de la commande | Order date. | ||
Order |
int32 |
Numéro de Commande | filtres disponibles sur la plateforme | Number to identify the order.By default the number is based on a setting for the first free number, but you can post your own number. | |
Ordered |
guid |
Commandé par | filtres disponibles sur la plateforme | Customer who ordered the invoice. | |
Ordered |
guid |
Trié par personne de contact | filtres disponibles sur la plateforme | Contact person of customer who ordered the invoice. | |
Ordered |
varchar2 |
Trié par nom complet de la personne de contact | Name of contact person of customer who ordered the invoice. | ||
Ordered |
varchar2 |
Classés par nom | Name of customer who ordered the invoice. | ||
Payment |
varchar2 |
Condition de paiement | The payment condition used for due date and discount calculation. | ||
Payment |
varchar2 |
Description des conditions de paiement | Description of PaymentCondition. | ||
Payment |
varchar2 |
Référence de réglement | Payment reference for sales invoice. | ||
Remarks |
varchar2 |
Remarks | Extra remarks. | ||
Sales |
guid |
Le canal de vente | |||
Sales |
varchar2 |
Code du canal de vente | |||
Sales |
varchar2 |
Description du canal de vente | |||
Salesperson |
guid |
Vendeur | filtres disponibles sur la plateforme | Sales representative. | |
Salesperson |
varchar2 |
Nom complet du commercial | Name of sales representative. | ||
Selection |
guid |
Code de sélection | filters on the platform, writable | ID of selection code.Only supported by the Advanced and Premium editions for Wholesale & Distribution and Manufacturing. | |
Selection |
varchar2 |
Code de sélection | writable | Code of selection code. | |
Selection |
varchar2 |
itgen_eol_selectioncodedescription | writable | Description of selection code. | |
Shipping |
guid |
Mode d'expédition | |||
Shipping |
varchar2 |
Code du mode de livraison | |||
Shipping |
varchar2 |
Description du mode de livraison | |||
Starter |
int16 |
Statut des factures de vente (version d'essai) | Starter Sales invoice status (for starter functionality). | ||
Starter |
varchar2 |
itgen_eol_startersalesinvoicestatusdescription | Description of StarterSalesInvoiceStatus. | ||
Status |
int16 |
Status | filtres disponibles sur la plateforme | The status of the entry.10 = draft.During the creation of an invoice draft records occur in the draft modus if during an invoice a new page with lines is triggered.If the user leaves the invoice in an abnormal way the draft invoices can be recovered.Draft invoices are not included in financial reports, balances etc. 20 = open.Open invoices can be changed.New invoices get the status open by default.50 = processed.Processed invoices can't be changed anymore.Processing is done via printing.Processed invoices can't be reopened. | |
Status |
varchar2 |
Description de l'état | Description of Status. | ||
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. | ||
Type |
int32 |
Type | filtres disponibles sur la plateforme | Indicates the type of invoice Values: 8020 - Sales invoices, 8021 - Sales credit note, 8023 - Direct sales invoice, 8024 - Direct credit note. | |
Type |
varchar2 |
Description du type | Description of the type. | ||
VAT |
double |
Montant de la TVA / Division / Devise | Total VAT amount in the default currency of the company. | ||
VAT |
double |
Montant de la TVA en devise étrangère | Total VAT amount in the currency of the transaction. | ||
Warehouse |
guid |
Warehouse | filtres disponibles sur la plateforme | Mandatory for direct sales invoice/credit note, cannot be set for normal sales invoice/credit note. | |
Withholding |
double |
Montant de la retenue à la source (devise étrangère) | Withholding tax amount applied to sales invoice. | ||
Withholding |
double |
Montant de base de la retenue à la source | Withholding tax base amount to calculate withholding amount. | ||
Withholding |
double |
Retenue à la source (%) | Withholding tax percentage applied to sales invoice. | ||
Your |
varchar2 |
Votre référence | The invoice number of the customer. |
Clés
| Key | Column | Se réfère à | Kind | Description |
|---|---|---|---|---|
Sales |
Creator |
Users. |
Key | |
Sales |
Currency |
Currencies.Code |
Key | |
Sales |
Deliver |
Addresses.ID |
Key | |
Sales |
Deliver |
Contacts.ID |
Key | |
Sales |
Deliver |
Accounts.ID |
Key | |
Sales |
Document |
Documents.ID |
Key | |
Sales |
Invoice |
Contacts.ID |
Key | |
Sales |
Invoice |
Accounts.ID |
Key | |
Sales |
Journal |
Journals.Code |
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 |
Warehouse |
Warehouses.ID |
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 :