# Projects: Exact Online Projects - Catalog: `ExactOnlineREST` - Schema: `Project` - Primary Keys: `ID` - Label: Projects The data in this table is partitioned per value of the `Division` column. Can retrieve data and change data using insert, update and delete. ## Table Columns The columns of the table `Projects` 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 | Documentation | |---|:---:|---|:---:|---| | `Account` | `guid` | Account | ☐ | The account for this project. | | `AccountCode` | `varchar2`(18) | Account Code | ☐ | Code of Account. | | `AccountContact` | `guid` | Account Contact | ☐ | Contact person of Account. | | `AccountName` | `varchar2`(50) | Account Name | ☐ | Name of account. | | `AllowAdditionalInvoicing` | `char` | Allow Additional Invoicing | ☐ | Is additional invoice is allowed for project. | | `AllowMemberEntryOnly` | `char` | | ☐ | | | `BlockEntry` | `char` | Block Entry of Time and Cost | ☐ | Block time and cost entries. | | `BlockInvoicing` | `char` | | ☐ | | | `BlockPlanning` | `char` | Block Planning | ☐ | | | `BlockPurchasing` | `char` | Block Purchasing | ☐ | | | `BlockRebilling` | `char` | Block Rebilling | ☐ | Block rebilling. | | `BudgetedAmount` | `double` | Budgeted Amount | ☐ | Budgeted amount of sales in the default currency of the company. | | `BudgetedCosts` | `double` | Budgeted Costs | ☐ | Budgeted amount of costs in the default currency of the company. | | `BudgetedRevenue` | `double` | Budgeted Revenue | ☐ | Budgeted amount of revenue in the default currency of the company. | | `BudgetOverrunHours` | `int16` | Budget Overrun Hours Status | ☐ | 10-Allowed, 20-Not Allowed. | | `BudgetType` | `int16` | Budget Type | ☐ | Budget type. | | `BudgetTypeDescription` | `varchar2`(240) | | ☐ | Budget type description. | | `Classification` | `guid` | Classification | ☐ | Used only for PSA to link a project classification to the project. | | `ClassificationDescription` | `varchar2`(60) | Classification Description | ☐ | Description of Classification. | | `Code` | `varchar2` | Code | ☑ | Code. | | `CostsAmountFC` | `double` | | ☐ | Used only for PSA to store the budgetted costs of a project (except for project type Campaign and Non-billable). Positive quantities only. | | `Created` | `datetime` | Created | ☐ | Creation date. | | `CreatedUtc` | `datetime` | Created (UTC) | ☐ | Creation date in UTC. | | `Creator` | `guid` | Creator | ☐ | User ID of creator. | | `CreatorFullName` | `varchar2`(240) | Creator Full Name | ☐ | Name of creator. | | `CustomerPOnumber` | `varchar2` | Customer PO Number | ☐ | Used only for PSA to store the customer's PO number. | | `CustomField` | `varchar2` | Custom Field | ☐ | | | `Description` | `varchar2` | Description | ☐ | Description of the project. | | `Division` | `int32` | Division | ☐ | Division code. | | `DivisionCompanyCoCNumber` | `varchar2`(60) | Division Chamber of Commerce Number | ☐ | Chamber of commerce number of the Exact Online division. | | `DivisionCompanyIBANNumber` | `varchar2`(50) | Division IBAN Number | ☐ | IBAN number of the Exact Online division. | | `DivisionCompanyName` | `varchar2`(50) | Division Company Name | ☑ | Company name of the Exact Online division. | | `DivisionCompanyRSINNumber` | `varchar2`(9) | Division RSIN Number | ☐ | RSIN number of the Exact Online division. | | `DivisionCompanyVATNumber` | `varchar2`(35) | Division VAT Number | ☐ | VAT number of the Exact Online division. | | `DivisionCompanyWageTaxNumber` | `varchar2`(60) | Division Wage Tax Number | ☐ | Wage tax number of the Exact Online division. | | `DivisionLabel` | `varchar2`(128) | Division Label | ☑ | Label of the Exact Online division. | | `DivisionName` | `varchar2`(50) | Division Name | ☐ | Name of Division. | | `DivisionOwnerCompanyName` | `varchar2`(50) | Subscription Holder Name | ☑ | Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | | `DivisionOwnerCompanyNumber` | `varchar2`(18) | Subscription Holder Number | ☑ | Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | | `DivisionShortName` | `int64` | Division Short Name | ☑ | Short name of the Exact Online division. | | `EnableWorkInProgress` | `char` | | ☐ | Whether Work In Progress can be used. | | `EndDate` | `datetime` | End Date | ☐ | End date of the project. In combination with the start date the status is determined. | | `FixedPriceItem` | `guid` | Fixed Price Item | ☐ | Item used for fixed price invoicing. To be defined per project. If empty the functionality relies on the setting. | | `FixedPriceItemDescription` | `varchar2`(255) | | ☐ | Description of FixedPriceItem. | | `HasWBSLines` | `char` | Has WBS Lines | ☑ | Indicates if whether the Project has WBS. | | `ID` | `guid` | ID | ☑ | Primary key. | | `IncludeInvoiceSpecification` | `int16` | | ☑ | | | `IncludeSpecificationInInvoicePdf` | `char` | | ☑ | | | `InternalNotes` | `varchar2` | Internal Notes | ☐ | Internal notes not to be printed in invoice. | | `InvoiceAddress` | `guid` | Invoice Address | ☐ | Invoice address. | | `InvoiceAsQuoted` | `char` | Invoice as Quoted | ☑ | Is invoice as quoted. | | `InvoiceDescription` | `varchar2` | | ☐ | Description for invoice. | | `IsWBSRequiredForEntry` | `int16` | | ☐ | | | `Manager` | `guid` | Manager | ☐ | Responsible person for this project. | | `ManagerFullname` | `varchar2`(240) | Manager Full Name | ☐ | Name of Manager. | | `MarkupPercentage` | `double` | Mark-up Percentage | ☐ | Purchase markup percentage. | | `Modified` | `datetime` | Modified | ☐ | Last modified date. | | `ModifiedUtc` | `datetime` | Modified (UTC) | ☐ | Last modified date in UTC. | | `Modifier` | `guid` | Modifier | ☐ | User ID of modifier. | | `ModifierFullName` | `varchar2`(240) | Modified Full Name | ☐ | Name of modifier. | | `Notes` | `varchar2` | Notes | ☐ | For additional information about projects. | | `PaymentCondition` | `varchar2` | Payment Condition | ☐ | | | `PrepaidItem` | `guid` | Prepaid Item | ☐ | Used only for PSA. This item is used for prepaid invoicing. If left empty, the functionality relies on a setting. | | `PrepaidItemDescription` | `varchar2`(255) | | ☐ | Description of PrepaidItem. | | `PrepaidType` | `int16` | Prepaid Type | ☐ | PrepaidType: 1-Retainer, 2-Hour type bundle. | | `PrepaidTypeDescription` | `varchar2`(240) | | ☐ | Description of PrepaidType. | | `SalesTimeQuantity` | `double` | Sales Time Quantity | ☐ | Budgeted time. Total number of hours estimated for the fixed price project. | | `SourceQuotation` | `guid` | Source Quotation | ☐ | Source quotation. | | `StartDate` | `datetime` | Start Date | ☐ | Start date of a project. In combination with the end date the status is determined. | | `TimeQuantityToAlert` | `double` | Time Quantity to Alert | ☐ | Alert when exceeding (Hours). | | `Type` | `int32` | Type | ☐ | Reference to ProjectTypes. | | `TypeDescription` | `varchar2`(240) | Type Description | ☐ | Description of Type. | | `UseBillingMilestones` | `char` | | ☐ | Using billing milestones. |