WBSActivities: Exact Online WBS-activiteiten |
Catalogus: ExactOnlineREST
Schema: Project
Primaire Sleutels: ID
Label: WBS-activiteiten
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 WBSActivities 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 |
---|---|---|---|---|
AutoCreateInvoiceTerm |
boolean |
{res:itgen_eol_autocreateinvoiceterm} |
☐ |
|
BlockEntry |
boolean |
Blokkeer Invoer van Tijd en Kosten |
☐ |
To indicated if time and cost entries is blocked. |
BudgetedCost |
double |
Gebudgetteerde Kosten |
☐ |
Budget cost of the WBS activity. |
BudgetedHours |
double |
Begrote Uren |
☐ |
Budget hours of the WBS. |
BudgetedRevenue |
double |
Gebudgetteerde Opbrengst |
☐ |
Revenue of the WBS activity. |
BudgetOverrunHours |
int16 |
Budgetoverschrijding Urenstatus |
☐ |
BudgetOverrunHours: 10-Allowed, 20-Not Allowed. |
Completed |
boolean |
Opgeleverd |
☐ |
To indicated if the WBS activity is completed. |
Created |
datetime |
Gemaakt |
☐ |
The date and time when the WBS activity was created. |
CreatedUtc |
datetime |
Aangemaakt (UTC) |
☐ |
Creation date in UTC. |
Creator |
guid |
Aanmaker |
☐ |
The ID of the user that created the WBS activity. |
CreatorFullName |
string |
Aanmaker Volledige Naam |
☐ |
The full name of the user that created the WBS activity. |
CustomField |
string |
{res:itgen_eol_customfield} |
☐ |
|
DefaultItem |
guid |
Standaard Artikel |
☐ |
Default Item to used for time entry. |
DefaultItemIsMandatory |
boolean |
Standaarditem is verplicht |
☐ |
|
Description |
string |
Omschrijving |
☐ |
Description of the WBS activity. |
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. |
EndDate |
datetime |
Einddatum |
☐ |
End date of the WBS activity. |
ID |
guid |
ID |
☑ |
Primary key. |
InvoiceDate |
datetime |
Factuurdatum |
☐ |
|
InvoiceMethod |
int16 |
Factuurmethode: |
☐ |
|
InvoiceSeparately |
boolean |
Factureer Afzonderlijk |
☐ |
To indicated if additional invoice is allowed on this WBS expense. Additional invoice can only be set when the project type is fixed price or prepaid and the project allow additional invoices. |
InvoiceTerm |
guid |
Factuurtermijn |
☐ |
|
Modified |
datetime |
Gewijzigd |
☐ |
The date when the WBS activity was modified. |
ModifiedUtc |
datetime |
Gewijzigd (UTC) |
☐ |
Last modified date in UTC. |
Modifier |
guid |
Wijziger |
☐ |
The ID of the user that modified the WBS activity. |
ModifierFullName |
string |
Gewijzigd Volledige Naam |
☐ |
The full name of the user that modified the WBS activity. |
Notes |
string |
Notities |
☐ |
For additional information. |
PartOf |
guid |
Deel van |
☐ |
ID of the WBS activity part of. |
PartOfDescription |
string |
Deel van Omschrijving |
☐ |
Description of part of. |
Project |
guid |
Project |
☑ |
ID of the project that linked to WBS activity. |
ProjectDescription |
string |
Projectomschrijving |
☐ |
Project description that is linked to WBS activity. |
ProjectTermAction |
int16 |
Projecttermijnactie |
☐ |
|
ReleaseInvoiceTerm |
boolean |
Vrijgave Factuurtermijn |
☐ |
|
ReleaseInvoiceTermDate |
datetime |
{res:itgen_eol_releaseinvoicetermdate} |
☐ |
|
ReleaseInvoiceTermHasSpecifyDate |
boolean |
{res:itgen_eol_releaseinvoicetermhasspecifydate} |
☐ |
|
SequenceNumber |
int32 |
Volgnummer |
☐ |
Sequence number of the WBS activity. Last sequence will be selected if not specified. |
StartDate |
datetime |
Startdatum |
☐ |
Start date of the WBS activity. |
TimeQuantityToAlert |
double |
Waarschuwingstijdhoeveelheid |
☐ |
Alert when exceeding this time quantity. |
Type |
int16 |
Soort |
☐ |
The type of project WBS. E.g: 1 = Deliverable, 2 = Activity, 3 = Expense. |
UpdateAction |
int16 |
Bijwerkactie |
☐ |
Update action. |
24-06-2025 18:54 Versie 24.1.116-BETA+5455