PayrollComponentsByEmploymentConditionGroupCode: Exact Online Payroll Components by Employment Condition Group Code
insert per partition REST
- Catalog:
ExactOnlineREST - Schema:
Payroll - Primary Keys:
ID - Label: Payroll Components by Employment Condition Group Code
The data in this table is partitioned per value of the Division column.
Can retrieve data and change data using insert.
API Source
- Endpoint:
/api/v1/beta/{division}/payroll/PayrollComponents - Metadata:
/api/v1/beta/{division}/payroll/$metadata
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 5 |
| Full scan rows per minute | 7,200 |
| Point query rows per minute | 300 |
| Write rows per minute | 300 |
The result can be cached on the client.
Parameters
| Name | Data Type | Required | Default | Documentation |
|---|---|---|---|---|
division |
int32 |
ID of the division to retrieve data for. | ||
employment |
varchar2 |
Table Columns
The columns of the table PayrollComponentsByEmploymentConditionGroupCode are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
Calculate |
int16 |
Calculate | filters on the platform, writable | Calculate. | |
Category |
varchar2 |
Category | filters on the platform, writable | Category. | |
Category |
varchar2 |
Category Description | filters on the platform | Category description. | |
Code |
varchar2 |
Code | filters on the platform, writable | Code. | |
Created |
datetime |
Created | filters on the platform | Created. | |
Created |
datetime |
Created (UTC) | writable | Creation date in UTC. | |
Creator |
guid |
Creator | filters on the platform | Creator. | |
Creator |
varchar2 |
Creator Full Name | filters on the platform | Creator full name. | |
Description |
varchar2 |
Description | filters on the platform, writable | Description. | |
Division |
int32 |
Division ID | Unique number of the Exact Online division. | ||
Division |
varchar2 |
Division Chamber of Commerce Number | writable | Chamber of commerce number of the Exact Online division. | |
Division |
varchar2 |
Division IBAN Number | writable | IBAN number of the Exact Online division. | |
Division |
varchar2 |
Division Company Name | writable | Company name of the Exact Online division. | |
Division |
varchar2 |
Division RSIN Number | writable | RSIN number of the Exact Online division. | |
Division |
varchar2 |
Division VAT Number | writable | VAT number of the Exact Online division. | |
Division |
varchar2 |
Division Wage Tax Number | writable | Wage tax number of the Exact Online division. | |
Division |
varchar2 |
Division Label | writable | Label of the Exact Online division. | |
Division |
varchar2 |
Administration Name | writable | Name of the Exact Online division. | |
Division |
varchar2 |
Subscription Holder Name | writable | Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
varchar2 |
Subscription Holder Number | writable | Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
int64 |
Division Short Name | writable | Short name of the Exact Online division. | |
Employment |
varchar2 |
Employment Condition Group Code | filters on the platform, writable | Employment condition group code. | |
Employment |
varchar2 |
Employment Condition Group Description | filters on the platform | Employment condition group description. | |
End |
datetime |
End Date | filters on the platform, writable | End date. | |
GL |
varchar2 |
General Ledger Classification | writable | GL classification. | |
GL |
varchar2 |
GL Classification Description | filters on the platform | GL classification description. | |
ID |
guid |
ID | filters on the platform | ID. | |
Modified |
datetime |
Modified | filters on the platform | Modified. | |
Modified |
datetime |
Modified (UTC) | writable | Last modified date in UTC. | |
Modifier |
guid |
Modifier | filters on the platform | Modifier. | |
Modifier |
varchar2 |
Modified Full Name | filters on the platform | Modifier full name. | |
Pension |
varchar2 |
itgen_eol_pensiondeclarationclassification | filters on the platform, writable | Pension declaration classification. | |
Pension |
varchar2 |
itgen_eol_pensiondeclarationclassificationdescription | filters on the platform, writable | Pension declaration classification description. | |
Pension |
varchar2 |
itgen_eol_pensiondeclarationsubclassification | filters on the platform, writable | Pension declaration subclassification. | |
Pension |
varchar2 |
itgen_eol_pensiondeclarationsubclassificationdescription | filters on the platform, writable | Pension declaration subclassification description. | |
Search |
varchar2 |
Search Code | filters on the platform, writable | Search code. | |
Start |
datetime |
Start Date | filters on the platform, writable | Start date. | |
Subcategory |
varchar2 |
Subcategory | filters on the platform, writable | Subcategory. | |
Subcategory |
varchar2 |
Subcategory Description | filters on the platform, writable | Subcategory description. | |
Tax |
varchar2 |
itgen_eol_taxdeclarationclassification | filters on the platform, writable | Tax declaration classification. | |
Tax |
varchar2 |
itgen_eol_taxdeclarationclassificationdescription | filters on the platform, writable | Tax declaration classification description. | |
Transaction |
int16 |
Transaction Type | filters on the platform, writable | Transaction type: 1 - Normal, 2- Special, 3 - Normal and special. | |
Type |
int32 |
Type | filters on the platform, writable | Type: 1 - Allowance, 2- Deduction, 3 - Subtotal. | |
Wage |
varchar2 |
Wage List Classification | filters on the platform, writable | Wage list classification. | |
Wage |
varchar2 |
Wage List Classification Description | filters on the platform | Wage list classification description. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: