Projects: Exact Online Projecten |
Catalogus: ExactOnlineREST
Schema: Project
Primaire Sleutels: ID
Label: Projecten
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 Projects 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 |
☐ |
The account for this project. |
AccountCode |
string(18) |
Account Code |
☐ |
Code of Account. |
AccountContact |
guid |
Account Contact |
☐ |
Contact person of Account. |
AccountName |
string(50) |
Accountnaam |
☐ |
Name of account. |
AllowAdditionalInvoicing |
boolean |
Sta Aanvullende Facturering Toe |
☐ |
Is additional invoice is allowed for project. |
AllowMemberEntryOnly |
boolean |
{res:itgen_eol_allowmemberentryonly} |
☐ |
|
BlockEntry |
boolean |
Blokkeer Invoer van Tijd en Kosten |
☐ |
Block time and cost entries. |
BlockInvoicing |
boolean |
{res:itgen_eol_blockinvoicing} |
☐ |
|
BlockPlanning |
boolean |
Blokkeer Planning |
☐ |
|
BlockPurchasing |
boolean |
Blokkeer Aankopen |
☐ |
|
BlockRebilling |
boolean |
Blokkeer Herhaald Factureren |
☐ |
Block rebilling. |
BudgetedAmount |
double |
Gebudgetteerd Bedrag |
☐ |
Budgeted amount of sales in the default currency of the company. |
BudgetedCosts |
double |
Gebudgetteerde Kosten |
☐ |
Budgeted amount of costs in the default currency of the company. |
BudgetedRevenue |
double |
Gebudgetteerde Opbrengst |
☐ |
Budgeted amount of revenue in the default currency of the company. |
BudgetOverrunHours |
int16 |
Budgetoverschrijding Urenstatus |
☐ |
10-Allowed, 20-Not Allowed. |
BudgetType |
int16 |
Budgetsoort |
☐ |
Budget type. |
BudgetTypeDescription |
string(240) |
{res:itgen_eol_budgettypedescription} |
☐ |
Budget type description. |
Classification |
guid |
Classificatie |
☐ |
Used only for PSA to link a project classification to the project. |
ClassificationDescription |
string(60) |
Classificatie Omschrijving |
☐ |
Description of Classification. |
Code |
string |
Code |
☑ |
Code. |
CostsAmountFC |
double |
{res:itgen_eol_costsamountfc} |
☐ |
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 |
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. |
CustomerPOnumber |
string |
Klant Inkoopnummer |
☐ |
Used only for PSA to store the customer's PO number. |
CustomField |
string |
{res:itgen_eol_customfield} |
☐ |
|
Description |
string |
Omschrijving |
☐ |
Description of the project. |
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) |
Divisie Naam |
☐ |
Name of 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. |
EnableWorkInProgress |
boolean |
{res:itgen_eol_enableworkinprogress} |
☐ |
Whether Work In Progress can be used. |
EndDate |
datetime |
Einddatum |
☐ |
End date of the project. In combination with the start date the status is determined. |
FixedPriceItem |
guid |
Vaste Prijs Artikel |
☐ |
Item used for fixed price invoicing. To be defined per project. If empty the functionality relies on the setting. |
FixedPriceItemDescription |
string(255) |
{res:itgen_eol_fixedpriceitemdescription} |
☐ |
Description of FixedPriceItem. |
HasWBSLines |
boolean |
Heeft WBS-Regels |
☑ |
Indicates if whether the Project has WBS. |
ID |
guid |
ID |
☑ |
Primary key. |
IncludeInvoiceSpecification |
int16 |
{res:itgen_eol_includeinvoicespecification} |
☑ |
|
IncludeSpecificationInInvoicePdf |
boolean |
{res:itgen_eol_includespecificationininvoicepdf} |
☑ |
|
InternalNotes |
string |
Interne Notities |
☐ |
Internal notes not to be printed in invoice. |
InvoiceAddress |
guid |
Factuuradres |
☐ |
Invoice address. |
InvoiceAsQuoted |
boolean |
Factuur zoals Geoffreerd |
☑ |
Is invoice as quoted. |
InvoiceDescription |
string |
{res:itgen_eol_invoicedescription} |
☐ |
Description for invoice. |
IsWBSRequiredForEntry |
int16 |
{res:itgen_eol_iswbsrequiredforentry} |
☐ |
|
Manager |
guid |
Manager |
☐ |
Responsible person for this project. |
ManagerFullname |
string(240) |
Manager Volledige naam |
☐ |
Name of Manager. |
MarkupPercentage |
double |
Toeslagpercentage |
☐ |
Purchase markup percentage. |
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. |
Notes |
string |
Notities |
☐ |
For additional information about projects. |
PaymentCondition |
string |
Betalingsvoorwaarde |
☐ |
|
PrepaidItem |
guid |
Voorafbetaald Item |
☐ |
Used only for PSA. This item is used for prepaid invoicing. If left empty, the functionality relies on a setting. |
PrepaidItemDescription |
string(255) |
{res:itgen_eol_prepaiditemdescription} |
☐ |
Description of PrepaidItem. |
PrepaidType |
int16 |
Voorafbetaalde Soort |
☐ |
PrepaidType: 1-Retainer, 2-Hour type bundle. |
PrepaidTypeDescription |
string(240) |
{res:itgen_eol_prepaidtypedescription} |
☐ |
Description of PrepaidType. |
SalesTimeQuantity |
double |
Verkooptijd Hoeveelheid |
☐ |
Budgeted time. Total number of hours estimated for the fixed price project. |
SourceQuotation |
guid |
Bron Offerte |
☐ |
Source quotation. |
StartDate |
datetime |
Startdatum |
☐ |
Start date of a project. In combination with the end date the status is determined. |
TimeQuantityToAlert |
double |
Waarschuwingstijdhoeveelheid |
☐ |
Alert when exceeding (Hours). |
Type |
int32 |
Soort |
☐ |
Reference to ProjectTypes. |
TypeDescription |
string(240) |
Soort Omschrijving |
☐ |
Description of Type. |
UseBillingMilestones |
boolean |
{res:itgen_eol_usebillingmilestones} |
☐ |
Using billing milestones. |
24-06-2025 18:54 Versie 24.1.116-BETA+5455