PjtTimeTransactions: Exact Online Project Time Transactions
popular insert update delete per partition webhook REST
- Catalogue :
ExactOnlineREST - Schéma :
Project - Clés primaires :
ID - Label: Project Time Transactions
Time transactions registered on persons.
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 TimeTransactions.
Source de l'API
- Point de terminaison :
/api/v1/{division}/project/TimeTransactions - Métadonnées :
/api/v1/{division}/project/$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 PjtTimeTransactions 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 | Account linked to the transaction. | |
Account |
varchar2 |
Nom du compte | filters on the platform, writable | Name of Account. | |
Activity |
guid |
Activity | filters on the platform, writable | Reference to ProjectWBS (work breakdown structure). | |
Activity |
varchar2 |
Description d'activité | filters on the platform, writable | Description of ProjectWBS. | |
Amount |
double |
Amount | writable | This property is obsolete.Use property 'AmountFC' instead. | |
Amount |
double |
Montant en devise étrangère | filters on the platform, writable | Amount in the currency of the transaction of the transaction. | |
Attachment |
guid |
Attachment | filters on the platform, writable | Attachment linked to the transaction. | |
Created |
datetime |
Created | filters on the platform, writable | Creation date. | |
Created |
datetime |
Créé | writable | Creation date in UTC. | |
Creator |
guid |
Creator | filters on the platform, writable | User ID of creator. | |
Creator |
varchar2 |
Nom complet de l'auteur | filters on the platform, writable | Name of creator. | |
Currency |
varchar2 |
Currency | filters on the platform, writable | Currency of the amount. | |
Custom |
varchar2 |
Champ personnalisé | filtres disponibles sur la plateforme | ||
Date |
datetime |
Date | filters on the platform, writable | Date. | |
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 |
Description de la division | filters on the platform, writable | Description of 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 | filters on the platform, writable | Employee linked to the transaction. | |
End |
datetime |
Heure de fin | filters on the platform, writable | End time of the transaction. | |
Entry |
int32 |
Numéro d'inscription | filters on the platform, writable | Entrynumber. | |
Error |
varchar2 |
Texte d'erreur | filters on the platform, writable | Errortext, used for the backgroundjobs. | |
Hour |
int16 |
État de l'heure | filters on the platform, writable | Status of the transaction. | |
ID |
guid |
ID | filters on the platform, writable | Primary key. | |
Item |
guid |
Item | filters on the platform, writable | Item linked to the transaction.Items of type 'time' are linked to time transactions.Items of other types are linked to cost transactions. | |
Item |
varchar2 |
Description de l’article | filters on the platform, writable | Description of Item. | |
Item |
char |
Article divisible | filters on the platform, writable | True if you can use decimals for item quantity. | |
Modified |
datetime |
Modified | filters on the platform, writable | Last modified date. | |
Modified |
datetime |
Modifié (UTC) | writable | Last modified date in UTC. | |
Modifier |
guid |
Modifier | filters on the platform, writable | User ID of modifier. | |
Modifier |
varchar2 |
Nom complet modifié | filters on the platform, writable | Name of modifier. | |
Notes |
varchar2 |
Notes | filters on the platform, writable | Notes linked to the transaction. | |
Price |
double |
Price | writable | This property is obsolete.Use property 'PriceFC' instead. | |
Price |
double |
Prix en devises étrangères | filters on the platform, writable | PriceFC (AmountFC = Quantity * PriceFC). | |
Project |
guid |
Project | filters on the platform, writable | Project linked to the transaction. | |
Project |
guid |
Compte de projet | filters on the platform, writable | Reference to project account. | |
Project |
varchar2 |
Code comptable du projet | filters on the platform, writable | Project account code. | |
Project |
varchar2 |
Nom du compte du projet | filters on the platform, writable | Project account name. | |
Project |
varchar2 |
Code de projet | filters on the platform, writable | Code of Project. | |
Project |
varchar2 |
Description du projet | filters on the platform, writable | Description of Project. | |
Quantity |
double |
Quantité (h) | filters on the platform, writable | Number of hours. | |
Skip |
char |
Ignorer la validation | writable | ||
Start |
datetime |
Heure de début | filters on the platform, writable | Start time of the transaction. | |
Subscription |
guid |
Subscription | filters on the platform, writable | Subscription linked to the transaction. | |
Subscription |
guid |
Compte d'abonnement | filters on the platform, writable | Account linked to the subscription. | |
Subscription |
varchar2 |
Code du compte d'abonnement | filters on the platform, writable | Subscription account code. | |
Subscription |
varchar2 |
Nom du compte d'abonnement | filters on the platform, writable | Subscription account name. | |
Subscription |
varchar2 |
Description de l'abonnement | filters on the platform, writable | Description of the subscription. | |
Subscription |
int32 |
Numéro d'abonnement | filters on the platform, writable | Subscription number. | |
Type |
int16 |
Type | filters on the platform, writable | Type of the transaction. |
Clés
| Key | Column | Se réfère à | Kind | Description |
|---|---|---|---|---|
Pjt |
Account |
Accounts.ID |
Key | |
Pjt |
Creator |
Users. |
Key | |
Pjt |
Currency |
Currencies.Code |
Key | |
Pjt |
Employee |
Employees.ID |
Key | |
Pjt |
Item |
Items.ID |
Key | |
Pjt |
Modifier |
Users. |
Key | |
Pjt |
Project |
Accounts.ID |
Key | |
Pjt |
Project |
Projects.ID |
Key | |
Pjt |
Subscription |
Accounts.ID |
Key | |
Pjt |
Subscription |
Subscriptions. |
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 :