ProjectPlanningRecurring: Exact Online Terugkerende Projectplanning |
Catalogus: ExactOnlineREST
Schema: Project
Primaire Sleutels: ID
Label: Terugkerende Projectplanning
De gegevens in deze tabel zijn gepartitioneerd per waarde van de kolom Division.
Kan gegevens ophalen en wijzigen met behulp van toevoegen, bijwerken en verwijderen.
Tabelkolommen
De kolommen van de tabel ProjectPlanningRecurring 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.
Naam |
Datatype |
Label |
Verplicht |
Documentatie |
---|---|---|---|---|
Account |
guid |
Account |
☐ |
Account linked to the recurring planning. |
AccountCode |
string(18) |
Account Code |
☐ |
Code of Account. |
AccountName |
string(50) |
Accountnaam |
☐ |
Name of account. |
BGTStatus |
int16 |
BGT Status |
☐ |
Status of the project planning process, 1 = To be processed, 2 = Processed, 3 = Failed. |
Created |
datetime |
Gemaakt |
☐ |
Creation date. |
CreatedUtc |
datetime |
Aangemaakt (UTC) |
☐ |
Creation date in UTC. |
Creator |
guid |
Aanmaker |
☐ |
User ID of creator. |
CreatorFullName |
string(240) |
Aanmaker Volledige Naam |
☐ |
Name of creator. |
CustomField |
string |
{res:itgen_eol_customfield} |
☐ |
|
DayOrThe |
int32 |
{res:itgen_eol_dayorthe} |
☐ |
Indicates whether the recurring planning is day of the month or weekday of the month. |
Description |
string |
Omschrijving |
☐ |
Description of recurring planning. |
Division |
int32 |
Divisie |
☐ |
Division code. |
DivisionCompanyCoCNumber |
string(60) |
Divisie Kamer van Koophandel Nummer |
☐ |
Chamber of commerce number of the Exact Online division. |
DivisionCompanyIBANNumber |
string(50) |
Divisie IBAN Nummer |
☐ |
IBAN number of the Exact Online division. |
DivisionCompanyName |
string(50) |
Divisie Bedrijfsnaam |
☑ |
Company name of the Exact Online division. |
DivisionCompanyRSINNumber |
string(9) |
Divisie RSIN Nummer |
☐ |
RSIN number of the Exact Online division. |
DivisionCompanyVATNumber |
string(35) |
Divisie BTW Nummer |
☐ |
VAT number of the Exact Online division. |
DivisionCompanyWageTaxNumber |
string(60) |
Divisie Loonbelastingnummer |
☐ |
Wage tax number of the Exact Online division. |
DivisionLabel |
string(128) |
Divisie Label |
☑ |
Label of the Exact Online division. |
DivisionName |
string(50) |
Administratie Naam |
☑ |
Name of the Exact Online division. |
DivisionOwnerCompanyName |
string(50) |
Naam Abonnementhouder |
☑ |
Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. |
DivisionOwnerCompanyNumber |
string(18) |
Abonnementhoudernummer |
☑ |
Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. |
DivisionShortName |
int64 |
Divisie Korte Naam |
☑ |
Short name of the Exact Online division. |
Employee |
guid |
Medewerker |
☐ |
Employee linked to the recurring planning. |
EmployeeCode |
string |
Werknemer Code |
☐ |
Code of employee. |
EmployeeHID |
int32 |
Medewerker HID |
☐ |
Numeric ID of the employee. |
EndDate |
datetime |
Einddatum |
☐ |
End date of the recurring planning. |
EndDateOrAfter |
int32 |
Einddatum of Na |
☐ |
Indicates whether the recurring planning is end on end date or end after number of times. |
EndTime |
datetime |
Eindtijd |
☐ |
End time for the recurring planning to be active. |
Hours |
double |
Uren |
☐ |
Number of hours for the recurring planning. |
HourType |
guid |
Uursoort |
☐ |
Hour type of the recurring planning, item with 'Time' type. |
HourTypeCode |
string(30) |
Uurtype Code |
☐ |
Code of the hour type. |
HourTypeDescription |
string(240) |
Uursoortomschrijving |
☐ |
Description of the hour type. |
ID |
guid |
ID |
☑ |
Primary key. |
Modified |
datetime |
Gewijzigd |
☐ |
Last modified date. |
ModifiedUtc |
datetime |
Gewijzigd (UTC) |
☐ |
Last modified date in UTC. |
Modifier |
guid |
Wijziger |
☐ |
User ID of modifier. |
ModifierFullName |
string(240) |
Gewijzigd Volledige Naam |
☐ |
Name of modifier. |
MonthPatternDay |
int16 |
Maand: Patroondag |
☐ |
Day of the monthly recurring. |
MonthPatternOrdinalDay |
int16 |
{res:itgen_eol_monthpatternordinalday} |
☐ |
Ordinal number of week day for the monthly recurring planning, 1 = first, 2 = second, 3 = third, 4 = fourth, 31 = last. |
MonthPatternOrdinalWeek |
int16 |
{res:itgen_eol_monthpatternordinalweek} |
☐ |
Ordinal week day of the monthly recurring planning, 1 = Monday, 2 = Tuesday, 3 = Wednesday, 4 = Thursday, 5 = Friday, 6 = Saturday, 7 = Sunday. |
Notes |
string |
Notities |
☐ |
For additional information about recurring planning. |
NumberOfRecurrences |
int16 |
Aantal Herhalingen |
☐ |
Number of times the planning recurs. |
OverAllocate |
boolean |
Te veel toewijzen |
☐ |
Indicates whether the entries can have over allocated planning hours. |
PatternFrequency |
int16 |
Patroonfrequentie |
☐ |
Number of planning times for weekly or monthly recurring planning. |
Project |
guid |
Project |
☐ |
Project linked to the recurring planning. |
ProjectCode |
string(20) |
Projectcode |
☐ |
Code of project. |
ProjectDescription |
string(60) |
Projectomschrijving |
☐ |
Description of project. |
ProjectPlanningRecurringType |
int16 |
{res:itgen_eol_projectplanningrecurringtype} |
☐ |
Type of the recurring planning, 1 = weekly, 2 = monthly. |
ProjectWBS |
guid |
Project WBS |
☐ |
WBS linked to the recurring planning. |
ProjectWBSDescription |
string |
Project WBS Omschrijving |
☐ |
Description of WBS. |
StartDate |
datetime |
Startdatum |
☐ |
Start date of the recurring planning. |
StartTime |
datetime |
Starttijd |
☐ |
Start time for the recurring planning to be active. |
Status |
int16 |
Status |
☐ |
Status of the project planning, 1 = Reserved, 2 = Planned. |
WeekPatternDay |
int16 |
Weekpatroondag |
☐ |
Week day for the weekly recurring planning. |
WeekPatternFriday |
boolean |
Weekpatroon Vrijdag |
☐ |
Create planning on Friday, apply to weekly pattern recurring planning only. |
WeekPatternMonday |
boolean |
Weekpatroon Maandag |
☐ |
Create planning on Monday, apply to weekly pattern recurring planning only. |
WeekPatternSaturday |
boolean |
Weekpatroon Zaterdag |
☐ |
Create planning on Saturday, apply to weekly pattern recurring planning only. |
WeekPatternSunday |
boolean |
Weekpatroon Zondag |
☐ |
Create planning on Sunday, apply to weekly pattern recurring planning only. |
WeekPatternThursday |
boolean |
Weekpatroon Donderdag |
☐ |
Create planning on Thursday, apply to weekly pattern recurring planning only. |
WeekPatternTuesday |
boolean |
Weekpatroon Dinsdag |
☐ |
Create planning on Tuesday, apply to weekly pattern recurring planning only. |
WeekPatternWednesday |
boolean |
{res:itgen_eol_weekpatternwednesday} |
☐ |
Create planning on Wednesday, apply to weekly pattern recurring planning only. |
24-06-2025 18:54 Versie 24.1.116-BETA+5455