PayrollTransactionsAll: Exact Online Payroll Transactions
read only
- Catalogue :
ExactOnlineREST - Schéma :
Payroll - Label: Payroll Transactions
Payroll transactions across all payroll years.
Permet uniquement de récupérer des données.
Caractéristiques de performance
| Characteristic | Value |
|---|---|
| Latence moyenne d'accès (ms) | 432 |
| Nombre de lignes par minute en mode de balayage complet | 50,300 |
| Nombre de lignes de requêtes ponctuelles par minute | 138 |
Le résultat peut être mis en cache côté client.
Colonnes de table
Les colonnes de la table PayrollTransactionsAll 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 |
|---|---|---|---|---|---|
Calculated |
double |
Montant calculé | writable | Calculated amount. | |
Calculated |
double |
Valeur de base calculée | writable | Calculated base value. | |
Calculated |
double |
Franchise calculée | writable | Calculated franchise. | |
Calculated |
double |
Maximum calculé | writable | Calculated maximum. | |
Calculated |
double |
Nombre calculé | writable | Calculated number. | |
Cost |
varchar2 |
Centre de coûts | writable | Cost center. | |
Cost |
varchar2 |
Coût Code Center | writable | Cost center code. | |
Cost |
varchar2 |
Description du centre de coûts | writable | Cost center description. | |
Cost |
varchar2 |
Unité de coût | writable | Cost unit. | |
Cost |
varchar2 |
Code d'unité de coût | writable | Cost unit code. | |
Cost |
varchar2 |
Description des unités de coût | writable | Cost unit description. | |
Created |
datetime |
Created | writable | Creation date. | |
Created |
datetime |
Créé | writable | Creation date in UTC. | |
Creator |
guid |
Creator | writable | Creator. | |
Creator |
varchar2 |
Nom complet de l'auteur | writable | Creator full name. | |
Date |
datetime |
Date | writable | Date. | |
Department |
guid |
Department | writable | Department. | |
Department |
varchar2 |
Code du service | writable | Department code. | |
Department |
varchar2 |
Description du département | writable | Department description. | |
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. | |
Employee |
guid |
Employee | writable | Employee. | |
Employee |
int32 |
HID (l’employé) | writable | Employee number. | |
Employment |
guid |
Employment | filters on the platform, writable | Employment. | |
Employment |
guid |
Groupe de conditions d'emploi | writable | Employment condition group. | |
Employment |
varchar2 |
Code du groupe de conditions d'emploi | writable | Employment condition group code. | |
Employment |
varchar2 |
Description du groupe de conditions d'emploi | writable | Employment condition group description. | |
Entry |
double |
Montant de la cotisation | writable | Entry amount. | |
Entry |
double |
Base d'entrée | writable | Entry base. | |
Entry |
double |
Numéro d'inscription | writable | Entry number. | |
Entry |
double |
Pourcentage d’entrée | writable | Entry percentage. | |
Entry |
double |
Pourcentage d'inscription 2 | filtres disponibles sur la plateforme | Second entry percentage. | |
Entry |
int16 |
Type d'entrée | writable | Entry type. | |
Entry |
varchar2 |
Type d'entrée Description | writable | Entry type description. | |
Frequency |
int32 |
Frequency | filters on the platform, writable | Frequency: 1 - Yearly, 2 - Quarterly, 3 - Monthly, 4 - 4-weekly, 5 - Weekly, 11 - Yearly (Pro forma), 12 - Quarterly (Pro forma), 13 - Monthly (Pro forma), 14 - 4-Weekly (Pro forma), 15 - Weekly (Pro forma). | |
Full |
varchar2 |
Nom complet pour utilisation dans les listes | writable | Name of employee. | |
ID |
guid |
ID | writable | Transaction. | |
Modified |
datetime |
Modified | writable | Last modified date. | |
Modifier |
guid |
Modifier | writable | Modifier. | |
Modifier |
varchar2 |
Nom complet modifié | writable | Modifier full name. | |
Payroll |
guid |
Élément de paie | filters on the platform, writable | Payroll component. | |
Payroll |
varchar2 |
Code de composante de paie | writable | Payroll component code. | |
Payroll |
varchar2 |
Description des éléments de paie | writable | Payroll component description. | |
Payroll |
int32 |
Type de composante de paie | writable | Payroll component type. | |
Payroll |
varchar2 |
Type de composante de paie - Description | writable | Payroll component type description. | |
Payroll |
guid |
Traitement de la paie | writable | Payroll run. | |
Payroll |
varchar2 |
Code de traitement de la paie | writable | Payroll run code. | |
Payroll |
int16 |
Année fiscale (paie) | filters on the platform, writable | Payroll year. | |
Period |
int16 |
Period | filters on the platform, writable | Payroll period. | |
Status |
int16 |
Status | filters on the platform, writable | Transaction status: 1 - Not entered, 2 - Entered, 3 - Open, 4 - Calculated, 5 - Approved, 6 - Finalized, 7 - Deleted. | |
Type |
int16 |
Type | writable | Transaction type. | |
Type |
varchar2 |
Description du type | writable | Transaction type description. |
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 :