invantive documentation
Invantive Support ForumsLog In / Sign Up

Opportunities_ItemsUserDefinedFields: Autotask itgen_autotask_opportunities_itemsuserdefinedfields_plural

read only REST

  • Catalog: Autotask
  • Schema: Opportunities
  • Label: itgen_autotask_opportunities_itemsuserdefinedfields_plural

Can only retrieve data.

API Source

  • Endpoint: /V1.0/Opportunities/query
  • Operation: get /V1.0/Opportunities/query

Table Columns

The columns of the table Opportunities_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
advancedField1 double Advanced Field 1
advancedField2 double Advanced Field 2
advancedField3 double Advanced Field 3
advancedField4 double Advanced Field 4
advancedField5 double Advanced Field 5
amount double Amount
assessmentScore double Assessment Score
barriers varchar2 Barriers
closedDate datetime Closed Date
companyID int32 Company ID
contactID int32 Contact ID
cost double Cost
createDate datetime Created
creatorResourceID int32 Creator Resource ID
description varchar2 Description
helpNeeded varchar2 Help Needed
id int64 ID
impersonatorCreatorResourceID int32 Imperonsator Creator Resource ID
lastActivity datetime Last Activity
leadSource int32 Lead Source
lossReason int32 Loss Reason
lossReasonDetail varchar2 Loss Reason Detail
lostDate datetime Lost Date
market varchar2 Market
monthlyCost double Monthly Cost
monthlyRevenue double Monthly Revenue
name varchar2 Name
nextStep varchar2 Next Step
onetimeCost double One-time Cost
onetimeRevenue double One-time Revenue
opportunityCategoryID int32 Opportunity Category ID
organizationalLevelAssociationID int32 Organisational Level Association ID
ownerResourceID int32 Owner Resource ID
primaryCompetitor int32 Primary Competitor
probability int32 Probability
productID int32 Product ID
projectedCloseDate datetime Projected Close Date
promisedFulfillmentDate datetime Promised Fulfillment Date
promotionName varchar2 Promotion Name
quarterlyCost double Quarterly Cost
quarterlyRevenue double Quarterly Revenue
rating int32 Rating
relationshipAssessmentScore double Relationship Assessment Score
revenueSpread int32 Revenue Spread
revenueSpreadUnit varchar2 Revenue Spread Unit
salesOrderID int32 Sales Order ID
salesProcessPercentComplete double Sales Process Percent Complete
semiannualCost double Semi-annual Cost
semiannualRevenue double Semi-annual Revenue
stage int32 Stage
startDate datetime Start Date
status int32 Status
technicalAssessmentScore double Technical Assessment Score
throughDate datetime Through Date
title varchar2 Title
totalAmountMonths int32 Total Amount Months
useQuoteTotals char Use Quote Totals
value varchar2 Value
winReason int32 Win Reason
winReasonDetail varchar2 Win Reason Detail
yearlyCost double Yearly Cost
yearlyRevenue double Yearly Revenue

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: