JDBC Driver for Exact Online

Build 22.0.8462

Projects

Usage information for the operation Projects.rsd.

Columns

Name Type ReadOnly Description
ID [KEY] String True

The ID column for the table Projects.

Account String False

The Account column for the table Projects.

AccountCode String False

The AccountCode column for the table Projects.

AccountContact String False

The AccountContact column for the table Projects.

AccountName String False

The AccountName column for the table Projects.

AllowAdditionalInvoicing Bool False

The AllowAdditionalInvoicing column for the table Projects.

BlockEntry Bool False

The BlockEntry column for the table Projects.

BlockRebilling Bool False

The BlockRebilling column for the table Projects.

BudgetedAmount Double False

The BudgetedAmount column for the table Projects.

BudgetedCosts Double False

The BudgetedCosts column for the table Projects.

BudgetedRevenue Double False

The BudgetedRevenue column for the table Projects.

BudgetOverrunHours Int False

The BudgetOverrunHours column for the table Projects.

BudgetType Int False

The BudgetType column for the table Projects.

BudgetTypeDescription String False

The BudgetTypeDescription column for the table Projects.

Classification String False

The Classification column for the table Projects.

ClassificationDescription String False

The ClassificationDescription column for the table Projects.

Code String False

The Code column for the table Projects.

CostsAmountFC Double False

The CostsAmountFC column for the table Projects.

Created Datetime False

The Created column for the table Projects.

Creator String False

The Creator column for the table Projects.

CreatorFullName String False

The CreatorFullName column for the table Projects.

CustomerPOnumber String False

The CustomerPOnumber column for the table Projects.

Description String False

The Description column for the table Projects.

Division Int False

The Division column for the table Projects.

DivisionName String False

The DivisionName column for the table Projects.

EndDate Datetime False

The EndDate column for the table Projects.

FixedPriceItem String False

The FixedPriceItem column for the table Projects.

FixedPriceItemDescription String False

The FixedPriceItemDescription column for the table Projects.

InternalNotes String False

The InternalNotes column for the table Projects.

InvoiceAsQuoted Bool False

The InvoiceAsQuoted column for the table Projects.

Manager String False

The Manager column for the table Projects.

ManagerFullname String False

The ManagerFullname column for the table Projects.

MarkupPercentage Double False

The MarkupPercentage column for the table Projects.

Modified Datetime False

The Modified column for the table Projects.

Modifier String False

The Modifier column for the table Projects.

ModifierFullName String False

The ModifierFullName column for the table Projects.

Notes String False

The Notes column for the table Projects.

PrepaidItem String False

The PrepaidItem column for the table Projects.

PrepaidItemDescription String False

The PrepaidItemDescription column for the table Projects.

PrepaidType Int False

The PrepaidType column for the table Projects.

PrepaidTypeDescription String False

The PrepaidTypeDescription column for the table Projects.

SalesTimeQuantity Double False

The SalesTimeQuantity column for the table Projects.

SourceQuotation String False

The SourceQuotation column for the table Projects.

StartDate Datetime False

The StartDate column for the table Projects.

TimeQuantityToAlert Double False

The TimeQuantityToAlert column for the table Projects.

Type Int False

The Type column for the table Projects.

TypeDescription String False

The TypeDescription column for the table Projects.

UseBillingMilestones Bool False

The UseBillingMilestones column for the table Projects.

LinkedBudgetedHoursPerHourType String False

The LinkedBudgetedHoursPerHourType column for the table Projects.

LinkedInvoiceTerms String False

The LinkedInvoiceTerms column for the table Projects.

LinkedProjectRestrictionEmployees String False

The LinkedProjectRestrictionEmployees column for the table Projects.

LinkedProjectRestrictionItems String False

The LinkedProjectRestrictionItems column for the table Projects.

LinkedProjectRestrictionRebillings String False

The LinkedProjectRestrictionRebillings column for the table Projects.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462