Exact Online API Data Model
ProjectWBSIncremental: Exact Online Project WBS |
Catalog: ExactOnlineREST
Schema: Incremental
Primary Keys: ID
Label: Project WBS
The data in this table is partitioned per value of the Division column.
This is a read-only view. The Exact Online API may not support changing the data or the Invantive SQL driver for Exact Online does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Exact Online API.
Field Selection Method: NotRequired
View Columns
The columns of the view ProjectWBSIncremental are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
|---|---|---|---|---|
BlockEntry |
int16 |
Block Entry of Time and Cost |
☑ |
|
BlockRebilling |
int16 |
Block Rebilling |
☑ |
|
BudgetedCost |
double |
Budgeted Cost |
☐ |
|
BudgetedHours |
double |
Budgeted Hours |
☐ |
|
BudgetedRevenue |
double |
Budgeted Revenue |
☐ |
|
BudgetOverrunHours |
int16 |
Budget Overrun Hours Status |
☐ |
|
Completed |
int16 |
Completed |
☑ |
|
Created |
datetime |
Created |
☑ |
|
Creator |
guid |
Creator |
☐ |
|
DefaultItem |
guid |
Default Item |
☐ |
|
DefaultItemIsMandatory |
int16 |
Default Item is Mandatory |
☑ |
|
Description |
string |
Description |
☐ |
|
Division |
int32 |
Division |
☑ |
|
EndDate |
datetime |
End Date |
☐ |
|
ID |
guid |
ID |
☑ |
|
InvoiceSeparately |
int16 |
Invoice Separately |
☑ |
|
MarkupPercentage |
double |
Mark-up Percentage |
☐ |
|
Milestone |
int16 |
Milestone |
☐ |
|
Modified |
datetime |
Modified |
☑ |
|
Modifier |
guid |
Modifier |
☐ |
|
Notes |
string |
Notes |
☐ |
|
PartOf |
guid |
Part of |
☐ |
|
Project |
guid |
Project |
☑ |
|
ProjectTerm |
guid |
Project Term ID |
☐ |
|
SequenceNumber |
int32 |
Sequence Number |
☑ |
|
StartDate |
datetime |
Start Date |
☐ |
|
TimeQuantityToAlert |
double |
Time Quantity to Alert |
☐ |
|
Timestamp |
int64 |
Timestamp |
☑ |
|
Type |
int16 |
Type |
☑ |
|
15-06-2022 19:32 Version 22.0.232-PROD+3445
