invantive documentation
Invantive Support ForumsLog In / Sign Up

ProjectWBSBulk: Exact Online Project WBS

read only per partition REST

  • Catalog: ExactOnlineREST
  • Schema: Project
  • Primary Keys: ID
  • Label: Project WBS

The data in this table is partitioned per value of the Division column.

Can only retrieve data.

API Source

  • Endpoint: /api/v1/{division}/bulk/Project/ProjectWBS
  • Metadata: /api/v1/{division}/bulk/Project/$metadata

Performance Characteristics

Characteristic Value
Average access latency (ms) 5
Full scan rows per minute 20,000
Point query rows per minute 300
Write rows per minute 300

The result can be cached on the client.

Table Columns

The columns of the table ProjectWBSBulk 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
AdditionalInvoicing int16 Additional Invoicing writable A boolean field to indicated if additional invoice is allowed on this WBS.
BaselineDate datetime Baseline Date writable Baseline date of this deliverable.
BlockEntry char Block Entry of Time and Cost writable A boolean field to indicated if time and cost entries is blocked.
BlockRebilling char Block Rebilling writable A boolean field to indicated if rebilling is blocked.
BudgetOverrunHours int16 Budget Overrun Hours Status writable BudgetOverrunHours: 10-Allowed, 20-Not Allowed.
Completed int16 Completed writable A boolean field to indicated if the project WBS is completed.
Cost double Cost writable Budget cost of the WBS.
Created datetime Created writable Date and time the project was created.
CreatedUtc datetime Created (UTC) writable Creation date in UTC.
Creator guid Creator writable The Guid ID of user that created the project.
CustomField varchar2 Custom Field
DefaultItem guid Default Item filters on the platform, writable Default Item to used for timecost entry.
DefaultItemIsMandatory int16 Default Item is Mandatory
Description varchar2 Description writable Description of the project WBS.
Division int32 Division ID Unique number of the Exact Online division.
DivisionCompanyCoCNumber varchar2(60) Division Chamber of Commerce Number writable Chamber of commerce number of the Exact Online division.
DivisionCompanyIBANNumber varchar2(50) Division IBAN Number writable IBAN number of the Exact Online division.
DivisionCompanyName varchar2(50) Division Company Name writable Company name of the Exact Online division.
DivisionCompanyRSINNumber varchar2(9) Division RSIN Number writable RSIN number of the Exact Online division.
DivisionCompanyVATNumber varchar2(35) Division VAT Number writable VAT number of the Exact Online division.
DivisionCompanyWageTaxNumber varchar2(60) Division Wage Tax Number writable Wage tax number of the Exact Online division.
DivisionLabel varchar2(128) Division Label writable Label of the Exact Online division.
DivisionName varchar2(50) Administration Name writable Name of the Exact Online division.
DivisionOwnerCompanyName varchar2(50) Subscription Holder Name writable Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs.
DivisionOwnerCompanyNumber varchar2(18) Subscription Holder Number writable Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs.
DivisionShortName int64 Division Short Name writable Short name of the Exact Online division.
EndDate datetime End Date writable EndDate of the WBS. If it is a deliverable then EndDate is the lastest EndDate of its children.
Hours double Hours writable Budget quantity of the WBS.
ID guid ID filters on the platform, writable Primary key.
InvoiceMethod int16 Invoice Method writable
IsBaseline int16 Is Baseline writable A boolean field to indicated if this is a baseline.
Milestone int16 Milestone writable A boolean field to indicated if this is a milestone.
Modified datetime Modified filters on the platform, writable Last modified date and time.
ModifiedUtc datetime Modified (UTC) writable Last modified date in UTC.
Modifier guid Modifier writable The Guid ID of the user that modified the records.
Notes varchar2 Notes writable For additional information about wbs.
Parent guid Parent filters on the platform, writable ID of the parent WBS.
Project guid Project filters on the platform, writable ID of the project that linked to WBS.
ProjectTerm guid Project Term ID filters on the platform, writable ID of invoice planning.
PurchaseMarkupPercentage double Purchase Markup (%) writable Markup percentage.
PurchasePrice double Purchase Price
Quantity double Quantity
Revenue double Revenue writable Revenue of the WBS.
SequenceNumber int32 Sequence Number writable
StartDate datetime Start Date writable Startdate of the WBS. If it is a deliverable then StartDate is the earliest StartDate of its children.
Supplier guid Supplier
TimeQuantityToAlert double Time Quantity to Alert writable Alert when exceeding this time quantity.
Type int16 Type filters on the platform, writable The type of project WBS. E.g: 1 = Deliverable, 2 = Activity, 3 = Expense.

Keys

Key Column Refers to Kind Description
ProjectWBSBulk_Creator_Users_fk Creator Users.UserID Key
ProjectWBSBulk_DefaultItem_Items_fk DefaultItem Items.ID Key
ProjectWBSBulk_Modifier_Users_fk Modifier Users.UserID Key
ProjectWBSBulk_Parent_ProjectWBS_fk Parent ProjectWBS.ID Key
ProjectWBSBulk_ProjectTerm_InvoiceTerms_fk ProjectTerm InvoiceTerms.ID Key
ProjectWBSBulk_Project_Projects_fk Project Projects.ID Key

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: