---
title: "Projects_ItemsUserDefinedFields (Autotask)"
description: "itgen_autotask_projects_itemsuserdefinedfields_plural"
language: en
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/de/datamodels/autotask/Autotask.Projects.Projects_ItemsUserDefinedFields
original: https://documentation.invantive.eu/en/datamodels/autotask/Autotask.Projects.Projects_ItemsUserDefinedFields
updated: 2024-06-10T18:39:25Z
license: https://documentation.invantive.eu/de/
---

# Projects_ItemsUserDefinedFields: Autotask itgen_autotask_projects_itemsuserdefinedfields_plural

`read only` `REST`

- Catalog: `Autotask`
- Schema: `Projects`
- Label: itgen_autotask_projects_itemsuserdefinedfields_plural

Can only retrieve data.

## API Source

- Endpoint: `/V1.0/Projects/query`
- Operation: `get /V1.0/Projects/query`

## Table Columns

The columns of the table `Projects_ItemsUserDefinedFields` 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 | Marks | Documentation |
|---|---|---|:---:|---|---|
| `actualBilledHours` | `double` | Actual Billed Hours | [ ] |  |  |
| `actualHours` | `double` | Actual Hours | [ ] |  |  |
| `changeOrdersBudget` | `double` | Change Orders Budget | [ ] |  |  |
| `changeOrdersRevenue` | `double` | Change Orders Revenue | [ ] |  |  |
| `companyID` | `int32` | Company ID | [ ] |  |  |
| `companyOwnerResourceID` | `int32` | Company-owner Resource ID | [ ] |  |  |
| `completedDateTime` | `datetime` | Completed | [ ] |  |  |
| `completedPercentage` | `int32` | Completed Percentage | [ ] |  |  |
| `contractID` | `int32` | Contract ID | [ ] |  |  |
| `createDateTime` | `datetime` | Created | [ ] |  |  |
| `creatorResourceID` | `int32` | Creator Resource ID | [ ] |  |  |
| `department` | `int32` | Department | [ ] |  |  |
| `description` | `varchar2` | Description | [ ] |  |  |
| `duration` | `int32` | Duration | [ ] |  |  |
| `endDateTime` | `datetime` | End Date/Time | [ ] |  |  |
| `estimatedSalesCost` | `double` | Estimated Sales Cost | [ ] |  |  |
| `estimatedTime` | `double` | Estimated Time | [ ] |  |  |
| `extProjectNumber` | `varchar2` | External Project Number | [ ] |  |  |
| `extProjectType` | `int32` | External Project Type | [ ] |  |  |
| `id` | `int64` | ID | [ ] |  |  |
| `impersonatorCreatorResourceID` | `int32` | Imperonsator Creator Resource ID | [ ] |  |  |
| `laborEstimatedCosts` | `double` | Labor Estimated Costs | [ ] |  |  |
| `laborEstimatedMarginPercentage` | `double` | Labor Estimated Margin Percentage | [ ] |  |  |
| `laborEstimatedRevenue` | `double` | Labor Estimated Revenue | [ ] |  |  |
| `lastActivityDateTime` | `datetime` | Last Activity Date/Time | [ ] |  |  |
| `lastActivityPersonType` | `int32` | Last Acitvity Person Type | [ ] |  |  |
| `lastActivityResourceID` | `int32` | Last Activity Resource ID | [ ] |  |  |
| `name` | `varchar2` | Name | [ ] |  |  |
| `opportunityID` | `int32` | Opportunity ID | [ ] |  |  |
| `organizationalLevelAssociationID` | `int32` | Organisational Level Association ID | [ ] |  |  |
| `originalEstimatedRevenue` | `double` | Original Estimated Revenue | [ ] |  |  |
| `projectCostEstimatedMarginPercentage` | `double` | Project Cost Estimated Margin Percentage | [ ] |  |  |
| `projectCostsBudget` | `double` | Project Costs Budget | [ ] |  |  |
| `projectCostsRevenue` | `double` | Project Costs Revenue | [ ] |  |  |
| `projectLeadResourceID` | `int32` | Project Lead Resource ID | [ ] |  |  |
| `projectName` | `varchar2` | Project Name | [ ] |  |  |
| `projectNumber` | `varchar2` | Project Number | [ ] |  |  |
| `projectType` | `int32` | Project Type | [ ] |  |  |
| `purchaseOrderNumber` | `varchar2` | Purchase Order Number | [ ] |  |  |
| `sgda` | `double` | SGDA | [ ] |  |  |
| `startDateTime` | `datetime` | Start Date/Time | [ ] |  |  |
| `status` | `int32` | Status | [ ] |  |  |
| `statusDateTime` | `datetime` | Status Date/Time | [ ] |  |  |
| `statusDetail` | `varchar2` | Status Detail | [ ] |  |  |
| `value` | `varchar2` | Value | [ ] |  |  |



## Anmerkungen zu dieser Version

Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert:

- [Autotask](/de/release-notes/drivers?driver=autotask)
