project
Represents projects used to track work, billing, and costs, including budget details, billing type, customer and department assignments, grant information, and schedule and scope details.
Columns
| Name | Type | ReadOnly | Description |
| actualAmount | Decimal | False |
The actual amount incurred for this project. |
| attachment_Href | String | True |
The URL of the attachment associated with this project. |
| attachment_Id | String | False |
The Id of the attachment associated with this project. |
| attachment_Key | String | False |
The system-assigned key of the attachment associated with this project. |
| auditCreatedBy | String | True |
The user who created the project. |
| auditCreatedDateTime | Datetime | True |
The date and time when the project was created. |
| auditModifiedBy | String | True |
The user who last modified the project. |
| auditModifiedDateTime | Datetime | True |
The date and time when the project was last modified. |
| billingOverMax | String | False |
The rule applied when billing exceeds the maximum contract amount for this project. |
| billingType | String | False |
The billing type for this project, such as fixed fee or time and materials. |
| budgetBillingAmount | Decimal | False |
The budgeted billing amount for this project. |
| budgetBudgetedCost | Decimal | False |
The total budgeted cost for this project. |
| budgetBudgetedDuration | Decimal | False |
The total budgeted duration for this project. |
| category | String | False |
The category assigned to this project for classification purposes. |
| cipAsset_Href | String | True |
The URL of the construction-in-progress asset associated with this project. |
| cipAsset_Id | String | False |
The Id of the construction-in-progress asset associated with this project. |
| cipAsset_Key | String | False |
The system-assigned key of the construction-in-progress asset associated with this project. |
| cipAsset_Name | String | True |
The name of the construction-in-progress asset associated with this project. |
| class_Href | String | True |
The URL of the class associated with this project. |
| class_Id | String | False |
The Id of the class associated with this project. |
| class_Key | String | False |
The system-assigned key of the class associated with this project. |
| class_Name | String | True |
The name of the class associated with this project. |
| contractAmount | Decimal | False |
The total contract amount for this project. |
| contract_Href | String | True |
The URL of the contract associated with this project. |
| contract_Id | String | True |
The Id of the contract associated with this project. |
| contract_Key | String | True |
The system-assigned key of the contract associated with this project. |
| customerUser_Href | String | True |
The URL of the customer user associated with this project. |
| customerUser_Id | String | False |
The Id of the customer user associated with this project. |
| customerUser_Key | String | False |
The system-assigned key of the customer user associated with this project. |
| customer_Href | String | True |
The URL of the customer associated with this project. |
| customer_Id | String | False |
The Id of the customer associated with this project. |
| customer_Key | String | False |
The system-assigned key of the customer associated with this project. |
| customer_Name | String | True |
The name of the customer associated with this project. |
| department_Href | String | True |
The URL of the department associated with this project. |
| department_Id | String | False |
The Id of the department associated with this project. |
| department_Key | String | False |
The system-assigned key of the department associated with this project. |
| department_Name | String | True |
The name of the department associated with this project. |
| description | String | False |
The description of this project. |
| documentNumber | String | False |
The document number assigned to this project. |
| endDate | Date | False |
The date on which this project ends. |
| entity_Href | String | True |
The URL of the entity associated with this project. |
| entity_Id | String | True |
The Id of the entity associated with this project. |
| entity_Key | String | True |
The system-assigned key of the entity associated with this project. |
| entity_Name | String | True |
The name of the entity associated with this project. |
| excludeExpenses | Bool | False |
Indicates whether expenses are excluded from billing for this project. |
| excludeFromWIPSchedule | Bool | False |
Indicates whether this project is excluded from the WIP schedule. |
| glBudget_Href | String | True |
The URL of the GL budget associated with this project. |
| glBudget_Id | String | False |
The Id of the GL budget associated with this project. |
| glBudget_Key | String | False |
The system-assigned key of the GL budget associated with this project. |
| grantAgency | String | False |
The name of the agency that awarded the grant associated with this project. |
| grantAln | String | False |
The Assistance Listing Number (ALN) of the grant associated with this project. |
| grantAssistanceType | String | False |
The type of federal assistance for the grant associated with this project. |
| grantFundedProjectName | String | False |
The official funded project name for the grant associated with this project. |
| grantIsTimeSatisfactionScheduled | Bool | False |
Indicates whether time satisfaction is scheduled for the grant associated with this project. |
| grantOtherId | String | False |
An alternate or supplemental identifier for the grant associated with this project. |
| grantPayer | String | False |
The name of the payer for the grant associated with this project. |
| grantRestrictionExpirationDate | Date | False |
The date on which grant revenue restrictions expire for this project. |
| grantRestrictionExpiry | String | False |
The method used to determine the expiry of grant revenue restrictions for this project. |
| grantRevenueRestriction | String | False |
The type of revenue restriction applied to the grant associated with this project. |
| id | String | False |
The unique identifier of the project record. |
| invoiceCurrency | String | False |
The currency used for invoicing on this project. |
| invoiceMessage | String | False |
The message printed on invoices generated for this project. |
| invoiceWithParent | Bool | False |
Indicates whether this project is invoiced together with its parent project. |
| isBillableEmployeeExpense | Bool | False |
Indicates whether employee expenses are billable for this project. |
| isBillablePurchasingAPExpense | Bool | False |
Indicates whether purchasing and AP expenses are billable for this project. |
| key [KEY] | String | True |
The system-assigned key that uniquely identifies the project record. |
| location_Href | String | True |
The URL of the location associated with this project. |
| location_Id | String | False |
The Id of the location associated with this project. |
| location_Key | String | False |
The system-assigned key of the location associated with this project. |
| location_Name | String | True |
The name of the location associated with this project. |
| manager_Href | String | True |
The URL of the project manager associated with this project. |
| manager_Id | String | False |
The Id of the project manager associated with this project. |
| manager_Key | String | False |
The system-assigned key of the project manager associated with this project. |
| manager_Name | String | True |
The name of the project manager associated with this project. |
| multiEntityLocation_Href | String | True |
The URL of the multi-entity location associated with this project. |
| multiEntityLocation_Id | String | False |
The Id of the multi-entity location associated with this project. |
| multiEntityLocation_Key | String | False |
The system-assigned key of the multi-entity location associated with this project. |
| multiEntityLocation_Name | String | True |
The name of the multi-entity location associated with this project. |
| name | String | False |
The name of the project. |
| parent_Href | String | True |
The URL of the parent project associated with this project. |
| parent_Id | String | False |
The Id of the parent project associated with this project. |
| parent_Key | String | False |
The system-assigned key of the parent project associated with this project. |
| parent_Name | String | True |
The name of the parent project associated with this project. |
| paymentTerm_Href | String | True |
The URL of the payment term associated with this project. |
| paymentTerm_Id | String | False |
The Id of the payment term associated with this project. |
| paymentTerm_Key | String | False |
The system-assigned key of the payment term associated with this project. |
| progressActualDuration | String | True |
The actual duration logged against this project. |
| progressApprovedDuration | String | True |
The approved duration for this project. |
| progressEstimatedDuration | String | True |
The estimated total duration for this project. |
| progressObservedPercentComplete | String | True |
The observed percentage of completion for this project. |
| progressPercentComplete | String | True |
The calculated percentage of completion for this project. |
| progressRemainingDuration | String | True |
The remaining duration for this project. |
| projectCurrency | String | False |
The currency used for project cost and billing amounts. |
| projectStatus_DisableExpenseEntry | Bool | True |
Indicates whether expense entry is disabled for this project based on its status. |
| projectStatus_DisableGenerateInvoice | Bool | True |
Indicates whether invoice generation is disabled for this project based on its status. |
| projectStatus_DisablePurchasingAPEntry | Bool | True |
Indicates whether purchasing and AP entry is disabled for this project based on its status. |
| projectStatus_DisableTimesheetEntry | Bool | True |
Indicates whether timesheet entry is disabled for this project based on its status. |
| projectStatus_Href | String | True |
The URL of the project status associated with this project. |
| projectStatus_Id | String | False |
The Id of the project status associated with this project. |
| projectStatus_Key | String | False |
The system-assigned key of the project status associated with this project. |
| projectType_Href | String | True |
The URL of the project type associated with this project. |
| projectType_Id | String | False |
The Id of the project type associated with this project. |
| projectType_Key | String | False |
The system-assigned key of the project type associated with this project. |
| purchaseOrderAmount | Decimal | False |
The purchase order amount associated with this project. |
| purchaseOrderNumber | String | False |
The purchase order number associated with this project. |
| purchaseQuoteNumber | String | False |
The purchase quote number associated with this project. |
| ratesAndPricingDefaultRate | Decimal | False |
The default billing rate used for this project. |
| ratesAndPricingExpenseMarkup | Decimal | False |
The markup percentage applied to expenses for billing on this project. |
| ratesAndPricingExpensePricing | String | False |
The pricing method used for expenses on this project, such as cost plus markup or fixed rate. |
| ratesAndPricingLaborMarkup | Decimal | False |
The markup percentage applied to labor for billing on this project. |
| ratesAndPricingLaborPricing | String | False |
The pricing method used for labor on this project, such as cost plus markup or billing rate. |
| ratesAndPricingPurchasingAPPricing | String | True |
The pricing method used for purchasing and AP expenses on this project. |
| rootProject_Href | String | True |
The URL of the root project in the project hierarchy. |
| rootProject_Id | String | True |
The Id of the root project in the project hierarchy. |
| rootProject_Key | String | True |
The system-assigned key of the root project in the project hierarchy. |
| rootProject_Name | String | True |
The name of the root project in the project hierarchy. |
| salesContact_Href | String | True |
The URL of the sales contact associated with this project. |
| salesContact_Id | String | False |
The Id of the sales contact associated with this project. |
| salesContact_Key | String | False |
The system-assigned key of the sales contact associated with this project. |
| salesContact_Name | String | True |
The name of the sales contact associated with this project. |
| salesOrderNumber | String | False |
The sales order number associated with this project. |
| salesforceKey | String | True |
The key used to identify this project in Salesforce. |
| scheduleDetailsActualCompletionDate | Date | False |
The actual completion date for this project. |
| scheduleDetailsActualStartDate | Date | False |
The actual start date for this project. |
| scheduleDetailsExecutedOnDate | Date | False |
The date on which this project was formally executed or signed. |
| scheduleDetailsNoticeToProceedDate | Date | False |
The date on which notice to proceed was issued for this project. |
| scheduleDetailsResponseDueDate | Date | False |
The date by which a response is due for this project. |
| scheduleDetailsRevisedCompletionDate | Date | False |
The revised completion date for this project. |
| scheduleDetailsScheduleImpactNotes | String | False |
Notes describing the impact of schedule changes on this project. |
| scheduleDetailsScheduledCompletionDate | Date | False |
The originally scheduled completion date for this project. |
| scheduleDetailsScheduledStartDate | Date | False |
The originally scheduled start date for this project. |
| scheduleDetailsSubstantialCompletionDate | Date | False |
The date on which substantial completion was achieved for this project. |
| scopeDetailsExclusions | String | False |
A description of work or items explicitly excluded from this project's scope. |
| scopeDetailsInclusions | String | False |
A description of work or items included in this project's scope. |
| scopeDetailsScope | String | False |
The overall scope statement for this project. |
| scopeDetailsTerms | String | False |
The terms and conditions associated with this project's scope. |
| startDate | Date | False |
The date on which this project begins. |
| status | String | False |
The current status of the project, such as in progress or closed. |
| taxSchedule_Href | String | True |
The URL of the tax schedule associated with this project. |
| taxSchedule_Id | String | False |
The Id of the tax schedule associated with this project. |
| taxSchedule_Key | String | False |
The system-assigned key of the tax schedule associated with this project. |
| taxSolution_Href | String | True |
The URL of the tax solution associated with this project. |
| taxSolution_Id | String | False |
The Id of the tax solution associated with this project. |
| taxSolution_Key | String | False |
The system-assigned key of the tax solution associated with this project. |
| userRestrictions | String | False |
The user restriction settings controlling who can enter time and expenses against this project. |
| wipScheduleProject_Href | String | True |
The URL of the WIP schedule project associated with this project. |
| wipScheduleProject_Id | String | False |
The Id of the WIP schedule project associated with this project. |
| wipScheduleProject_Key | String | False |
The system-assigned key of the WIP schedule project associated with this project. |
| wipScheduleProject_Name | String | True |
The name of the WIP schedule project associated with this project. |