invantive documentation
Invantive SupportforenAnmelden / Eintragen

Projects_ItemsUserDefinedFields: Autotask itgen_autotask_projects_itemsuserdefinedfields_plural

Diese Seite ist in Ihrer Sprache noch nicht verfügbar; es wird die Originalversion angezeigt.

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: