ProjectPlanning: Exact Online Project Planning
insert update delete per partition webhook REST
- Catalogus:
ExactOnlineREST - Schema:
Project - Primaire sleutels:
ID - Label: Project Planning
De gegevens in deze tabel zijn gepartitioneerd per waarde van de kolom Division.
Je kunt gegevens ophalen en wijzigen met insert, update en delete.
Wijzigingen worden doorgegeven via het webhook-onderwerp ProjectPlanning.
API-bron
- Eindpunt:
/api/v1/{division}/project/ProjectPlanning - Metagegevens:
/api/v1/{division}/project/$metadata
Prestatiekenmerken
| Characteristic | Value |
|---|---|
| Gemiddelde toegangsvertraging (ms) | 5 |
| Aantal rijen per minuut bij volledige scan | 7,200 |
| Aantal rijen per minuut in een Query | 300 |
| Aantal rijen per minuut schrijven | 300 |
Het resultaat kan op de client in de Cache worden opgeslagen.
Tabelkolommen
De kolommen van de tabel ProjectPlanning worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.
| Name | Datatype | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
Account |
guid |
Account | filters on the platform, writable | Account linked to the project planning. | |
Account |
varchar2 |
Account Code | filters on the platform, writable | Code of Account. | |
Account |
varchar2 |
Accountnaam | filters on the platform, writable | Name of account. | |
BGT |
int16 |
BGT Status | filters on the platform, writable | Status of the project planning process, 1 = To be processed, 2 = Processed, 3 = Failed. | |
Communication |
int16 |
Communicatiefoutstatus | filters on the platform, writable | Status of the external calendar, 0 = No error, 1 = Credentials error, 2 = Technical error, 3 = Both credentials & technical errors, 4 = In progress. | |
Created |
datetime |
Created | filters on the platform, writable | Creation date. | |
Created |
datetime |
Aangemaakt (UTC) | writable | Creation date in UTC. | |
Creator |
guid |
Creator | filters on the platform, writable | User ID of creator. | |
Creator |
varchar2 |
Aanmaker Volledige Naam | filters on the platform, writable | Name of creator. | |
Custom |
varchar2 |
Aangepast Veld | filters op het platform | ||
Description |
varchar2 |
Description | filters on the platform, writable | Description of project planning. | |
Division |
int32 |
Division | Division code. | ||
Division |
varchar2 |
Divisie Kamer van Koophandel Nummer | writable | Chamber of commerce number of the Exact Online division. | |
Division |
varchar2 |
Divisie IBAN Nummer | writable | IBAN number of the Exact Online division. | |
Division |
varchar2 |
Divisie Bedrijfsnaam | writable | Company name of the Exact Online division. | |
Division |
varchar2 |
Divisie RSIN Nummer | writable | RSIN number of the Exact Online division. | |
Division |
varchar2 |
Divisie BTW Nummer | writable | VAT number of the Exact Online division. | |
Division |
varchar2 |
Divisie Loonbelastingnummer | writable | Wage tax number of the Exact Online division. | |
Division |
varchar2 |
Divisie Label | writable | Label of the Exact Online division. | |
Division |
varchar2 |
Administratie Naam | writable | Name of the Exact Online division. | |
Division |
varchar2 |
Naam Abonnementhouder | writable | Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
varchar2 |
Abonnementhoudernummer | writable | Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
int64 |
Divisie Korte Naam | writable | Short name of the Exact Online division. | |
Employee |
guid |
Employee | filters on the platform, writable | Employee linked to the project planning. | |
Employee |
varchar2 |
Werknemer Code | filters on the platform, writable | Code of employee. | |
Employee |
int32 |
Medewerker HID | filters on the platform, writable | Numeric ID of the employee. | |
End |
datetime |
Einddatum | filters on the platform, writable | End date of the project planning. | |
Hour |
guid |
Uursoort | filters on the platform, writable | The type of hour for the project planning, item with 'Time' type. | |
Hour |
varchar2 |
Uurtype Code | filters on the platform, writable | Code of the hour type. | |
Hour |
varchar2 |
Uursoortomschrijving | filters on the platform, writable | Description of the hour type. | |
Hours |
double |
Hours | filters on the platform, writable | Hours of the project planning. | |
ID |
guid |
ID | filters on the platform, writable | Primary key. | |
Is |
char |
Is Gebroken Herhaling | filters on the platform, writable | Indicates whether the project planning is separated from the recurring planning. | |
Modified |
datetime |
Modified | filters on the platform, writable | Last modified date. | |
Modified |
datetime |
Gewijzigd (UTC) | writable | Last modified date in UTC. | |
Modifier |
guid |
Modifier | filters on the platform, writable | User ID of modifier. | |
Modifier |
varchar2 |
Gewijzigd Volledige Naam | filters on the platform, writable | Name of modifier. | |
Notes |
varchar2 |
Notes | filters on the platform, writable | For additional information about project planning. | |
Over |
char |
Over-allocate | filters on the platform, writable | Indicates whether the entries can have over allocated planning hours. | |
Project |
guid |
Project | filters on the platform, writable | Project linked to the planning. | |
Project |
varchar2 |
Projectcode | filters on the platform, writable | Code of project. | |
Project |
varchar2 |
Projectomschrijving | filters on the platform, writable | Description of project. | |
Project |
guid |
Terugkerende Projectplanning | filters on the platform, writable | Recurring planning linked to the project planning. | |
Project |
guid |
Project WBS | filters on the platform, writable | WBS linked to the project planning. | |
Project |
varchar2 |
Project WBS Omschrijving | filters on the platform, writable | Description of WBS. | |
Start |
datetime |
Startdatum | filters on the platform, writable | Start date of the project planning. | |
Status |
int16 |
Status | filters on the platform, writable | Status of the project planning, 1 = Reserved, 2 = Planned. | |
Type |
int16 |
Type | filters on the platform, writable | Type of the project planning, it will always is 4 (employee). |
Toetsen
| Key | Column | Verwijst naar | Kind | Description |
|---|---|---|---|---|
Project |
Account |
Accounts.ID |
Key | |
Project |
Creator |
Users. |
Key | |
Project |
Employee |
Employees.ID |
Key | |
Project |
Modifier |
Users. |
Key | |
Project |
Project |
ProjectPlanningRecurring.ID |
Key | |
Project |
Project |
ProjectWBS.ID |
Key | |
Project |
Project |
Projects.ID |
Key |
Release Notes
Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: