invantive documentation
Foros de Soporte de InvantiveIniciar Sesión / Registrarse

Tickets_ItemsUserDefinedFields: Autotask itgen_autotask_tickets_itemsuserdefinedfields_plural

Esta página aún no está disponible en tu idioma; se muestra la versión original.

read only REST

  • Catalog: Autotask
  • Schema: Tickets
  • Label: itgen_autotask_tickets_itemsuserdefinedfields_plural

Can only retrieve data.

API Source

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

Table Columns

The columns of the table Tickets_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
apiVendorID int32 API Vendor ID
assignedResourceID int32 Assigned Resource ID
assignedResourceRoleID int32 Assigned Resource Role ID
billingCodeID int32 Billing Code ID
changeApprovalBoard int32 Change Approval Board
changeApprovalStatus int32 Change Approval Status
changeApprovalType int32 Change Approval Type
changeInfoField1 varchar2 Change Information Field 1
changeInfoField2 varchar2 Change Information Field 2
changeInfoField3 varchar2 Change Information Field 3
changeInfoField4 varchar2 Change Information Field 4
changeInfoField5 varchar2 Change Information Field 5
companyID int32 Company ID
companyLocationID int32 Company Location ID
completedByResourceID int32 Completed by Resource ID
completedDate datetime Completion Date
configurationItemID int32 Configuration Item ID
contactID int32 Contact ID
contractID int32 Contract ID
contractServiceBundleID int64 Contract Service Bundle ID
contractServiceID int64 Contract Service ID
createDate datetime Created
createdByContactID int32 Created by Contact ID
creatorResourceID int32 Creator Resource ID
creatorType int32 Creator Type
currentServiceThermometerRating int32 Current Service Thermometer Rating
description varchar2 Description
dueDateTime datetime Due Date/Time
estimatedHours double Estimated Hours
externalID varchar2 External ID
firstResponseAssignedResourceID int32 First Response Assigned Resource ID
firstResponseDateTime datetime First Response Date/Time
firstResponseDueDateTime datetime First Response Due Date/Time
firstResponseInitiatingResourceID int32 First Response Initiating Resource ID
hoursToBeScheduled double Hours to be Scheduled
id int64 ID
impersonatorCreatorResourceID int32 Imperonsator Creator Resource ID
isAssignedToComanaged char Is Assigned to Co-managed
issueType int32 Issue Type
isVisibleToComanaged char Is Visible to Co-managed
lastActivityDate datetime Last Activity Date
lastActivityPersonType int32 Last Acitvity Person Type
lastActivityResourceID int32 Last Activity Resource ID
lastCustomerNotificationDateTime datetime Last Customer Notification Date/Time
lastCustomerVisibleActivityDateTime datetime Last Customer Visible Activity Date/Time
lastTrackedModificationDateTime datetime Last Tracked Modification Date/Time
monitorID int64 Monitor ID
monitorTypeID int32 Monitor Type ID
name varchar2 Name
opportunityID int32 Opportunity ID
organizationalLevelAssociationID int32 Organisational Level Association ID
previousServiceThermometerRating int32 Previous Service Thermometer Rating
priority int32 Priority
problemTicketId int32 Problem Ticket ID
projectID int32 Project ID
purchaseOrderNumber varchar2 Purchase Order Number
queueID int32 Queue ID
resolution varchar2 Resolution
resolutionPlanDateTime datetime Resolution Plan Date/Time
resolutionPlanDueDateTime datetime Resolution Plan Due Date/Time
resolvedDateTime datetime Resolved Date/Time
resolvedDueDateTime datetime Resolved Due Date/Time
rmaStatus int32 RMA status
rmaType int32 RMA Type
rmmAlertID varchar2 Alert ID
serviceLevelAgreementHasBeenMet char Service Level Agreement has been Met
serviceLevelAgreementID int32 Service Level Agreement ID
serviceLevelAgreementPausedNextEventHours double Service Level Agreement Paused next Event Hours
serviceThermometerTemperature int32 Service Thermometer Temperature
source int32 Source
status int32 Status
subIssueType int32 Sub-issue Type
ticketCategory int32 Ticket Category
ticketNumber varchar2 Ticket Number
ticketType int32 Ticket Type
title varchar2 Title
value varchar2 Value

Notas de la Versión

Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: