TransactionLinesBulk: Exact Online Transaction Lines (Bulk)
read only per partition webhook REST
- Catalogue :
ExactOnlineREST - Schéma :
FinancialTransaction - Clés primaires :
ID - Label: Transaction Lines (Bulk)
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 FinancialTransactions le EntryID.
Source de l'API
- Point de terminaison :
/api/v1/{division}/bulk/financial/TransactionLines - Métadonnées :
/api/v1/{division}/bulk/financial/$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 TransactionLinesBulk 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 |
|---|---|---|---|---|---|
Account |
guid |
Account | filters on the platform, writable | Reference to account. | |
Account |
varchar2 |
Code du compte | writable | Code of the Account. | |
Account |
varchar2 |
Nom du compte | writable | Name of account. | |
Amount |
double |
Montant Division Devise | writable | Amount in the default currency of the company. | |
Amount |
double |
Montant en devise étrangère | writable | Amount in the currency of the transaction. | |
Amount |
double |
Montant Base de TVA Devise étrangère | writable | Vat base amount in the currency of the transaction. | |
Amount |
double |
Montant TVA Devise étrangère | writable | Vat amount in the currency of the transaction. | |
Asset |
guid |
Asset | writable | Reference to asset. | |
Asset |
varchar2 |
Code d'actif | writable | Code of Asset. | |
Asset |
varchar2 |
Description de l'actif | 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 | 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 | writable | Description of CostUnit. | |
Created |
datetime |
Created | writable | Creation date. | |
Created |
datetime |
Créé | writable | Creation date in UTC. | |
Creator |
guid |
Creator | writable | User ID of creator. | |
Creator |
varchar2 |
Nom complet de l'auteur | writable | Name of creator. | |
Currency |
varchar2 |
Currency | writable | Currency. | |
Custom |
varchar2 |
Champ personnalisé | writable | ||
Date |
datetime |
Date | filters on the platform, writable | Date. | |
Description |
varchar2 |
Description | writable | Description. | |
Display |
varchar2 |
Afficher les documents (URL) | writable | URL to display documents attached to this transaction using Get My Report. | |
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. | |
Document |
guid |
Document | filters on the platform, writable | Reference to document. | |
Document |
int32 |
Numéro de document | writable | Number of the document. | |
Document |
varchar2 |
Objet du document | writable | Subject of the document. | |
Due |
datetime |
Date d'Échéance | writable | Date that payment should be done. | |
Entry |
guid |
Identifiant de l'entrée | filters on the platform, writable | The transaction lines that make up a financial entry share the same EntryID. | |
Entry |
int32 |
Numéro d'inscription | filters on the platform, writable | Entry number of the header. | |
Exchange |
double |
Taux de Change | writable | Exchange rate. | |
External |
varchar2 |
Description du lien externe | |||
External |
varchar2 |
Référence à un lien externe | |||
Extra |
double |
Montant de la surtaxe en devise étrangère | writable | Extra duty amount. | |
Extra |
double |
Supplément (%) | writable | Extra duty percentage. | |
Financial |
int16 |
Période Financière | filters on the platform, writable | Financial period. | |
Financial |
int16 |
Exercice Financier | filters on the platform, writable | Financial year. | |
GL |
guid |
Compte du grand livre | filters on the platform, writable | General ledger account. | |
GL |
varchar2 |
Côté « Solde du compte GL » | writable | Balance side of transactions on this GL account. | |
GL |
varchar2 |
Type de solde du compte GL | writable | Balance type of transactions on this GL account, being either 'B' for Balance or 'W' for Profit and Loss. | |
GL |
varchar2 |
Code comptable GL | writable | Code of the G/L account. | |
GL |
varchar2 |
Description du compte GL | writable | Description of the G/L account. | |
GL |
char |
Compte GL : réévaluation de la Devise | writable | Whether to revalue amounts posted on this GL account. | |
GL |
varchar2 |
Code de recherche de compte GL | writable | User-friendly search code for the GL account. | |
GL |
int32 |
Type de compte du GL | writable | Type of GL account.See view GLAccountTypes. | |
GL |
varchar2 |
Description du type de compte du GL | writable | Description of the GL account type. | |
GL |
char |
Utiliser le Centre de coûts | writable | Indicator whether to use cost centers for transaction lines on the GL account. | |
GL |
char |
Unité de coût d'utilisation | writable | Indicator whether to use cost units for transaction lines on the GL account. | |
GL |
varchar2 |
Code TVA du compte général | writable | Associated VAT code of the GL account. | |
ID |
guid |
ID | filters on the platform, writable | Primary key. | |
Invoice |
int32 |
Numéro de facture | filters on the platform, writable | Invoice number. | |
Item |
guid |
Item | writable | Reference to item. | |
Item |
varchar2 |
Code de l'article | writable | Code of Item. | |
Item |
varchar2 |
Description de l’article | writable | Description of Item. | |
Journal |
varchar2 |
Code du journal | filters on the platform, writable | The journal code. | |
Journal |
varchar2 |
Description de la revue | writable | The journal description. | |
Line |
int32 |
Numéro de ligne | writable | Line number. | |
Line |
int16 |
Type de ligne | writable | Line type. | |
Modified |
datetime |
Modified | filters on the platform, writable | Last modified date. | |
Modified |
datetime |
Modifié (UTC) | writable | Last modified date in UTC. | |
Modifier |
guid |
Modifier | writable | User ID of modifier. | |
Modifier |
varchar2 |
Nom complet modifié | writable | Name of modifier. | |
Notes |
varchar2 |
Notes | writable | Extra remarks. | |
Offset |
guid |
ID du compte général de contrepartie | writable | OffsetID. | |
Order |
int32 |
Numéro de Commande | filters on the platform, writable | Order number. | |
Payment |
double |
Montant de la remise sur paiement | writable | Discount amount when paid in time. | |
Payment |
varchar2 |
Référence de réglement | writable | Payment reference. | |
Project |
guid |
Project | filters on the platform, writable | Reference to project. | |
Project |
varchar2 |
Code de projet | writable | Code of Project. | |
Project |
varchar2 |
Description du projet | 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 | writable | Quantity. | |
Serial |
varchar2 |
Numéro de Série | writable | Serial number of item. | |
Shop |
guid |
Commande d'atelier | Reference to shop order. | ||
Status |
int16 |
Status | filters on the platform, writable | 20 = Open, 50 = Processed. | |
Subscription |
guid |
Subscription | writable | Reference to subscription line. | |
Subscription |
varchar2 |
Description de l'abonnement | writable | Description of subscription line. | |
Tracking |
varchar2 |
Numéro de suivi | writable | Tracking number of item. | |
Tracking |
varchar2 |
Description du numéro de suivi | writable | Tracking number description. | |
Type |
int32 |
Type | filters on the platform, writable | The transaction type.Possible values: see TransactionLineTypes. | |
VAT |
varchar2 |
Code TVA | filters on the platform, writable | VAT code. | |
VAT |
varchar2 |
Code TVA Description | writable | Description of VAT code. | |
VAT |
double |
Pourcentage de TVA | writable | Vat percentage. | |
VAT |
varchar2 |
Type de TVA | filters on the platform, writable | VAT type. | |
Your |
varchar2 |
Votre référence | filters on the platform, writable | Your reference (of customer). |
Clés
| Key | Column | Se réfère à | Kind | Description |
|---|---|---|---|---|
Transaction |
Account |
Accounts.ID |
Key | |
Transaction |
Asset |
Assets.ID |
Key | |
Transaction |
Cost |
Costcenters.Code |
Key | |
Transaction |
Cost |
Costunits.Code |
Key | |
Transaction |
Creator |
Users. |
Key | |
Transaction |
Currency |
Currencies.Code |
Key | |
Transaction |
Document |
Documents.ID |
Key | |
Transaction |
GL |
GLAccounts.ID |
Key | |
Transaction |
Item |
Items.ID |
Key | |
Transaction |
Journal |
Journals.Code |
Key | |
Transaction |
Modifier |
Users. |
Key | |
Transaction |
Project |
ProjectWBS.ID |
Key | |
Transaction |
Project |
Projects.ID |
Key | |
Transaction |
Shop |
ShopOrders.ID |
Key | |
Transaction |
Subscription |
Subscriptions. |
Key | |
Transaction |
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 :