NotificationHistory_ItemsUserDefinedFields |
Catalog: Autotask
Schema: NotificationHistory
This is a read-only table. The Autotask API may not support changing the data or the Invantive SQL driver for Autotask does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Autotask API.
Select Autotask API URL: /V1.0/NotificationHistory/query
Insert Autotask API URL: /V1.0/NotificationHistory/query
Update Autotask API URL: /V1.0/NotificationHistory/query
Delete Autotask API URL: /V1.0/NotificationHistory/query
Field Selection Method: NotRequired
Base Path: items[*].userDefinedFields[*]
Select Autotask API Operation: get /V1.0/NotificationHistory/query
Table Columns
The columns of the table NotificationHistory_ItemsUserDefinedFields are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
companyID |
int64 |
Company ID |
☐ |
|
entityNumber |
string |
Entity Number |
☐ |
|
entityTitle |
string |
Entity Title |
☐ |
|
id |
int64 |
ID |
☐ |
|
initiatingContactID |
int64 |
Initiating Contact ID |
☐ |
|
initiatingResourceID |
int64 |
Initiating Resource ID |
☐ |
|
isActive |
boolean |
Is Active |
☐ |
|
isDeleted |
boolean |
Is Deleted |
☐ |
|
isTemplateJob |
boolean |
Is Template Job |
☐ |
|
name |
string |
Name |
☐ |
|
notificationHistoryTypeID |
int32 |
Notification History Type ID |
☐ |
|
notificationSentTime |
datetime |
Notification Sent Time |
☐ |
|
opportunityID |
int64 |
Opportunity ID |
☐ |
|
projectID |
int64 |
Project ID |
☐ |
|
quoteID |
int64 |
Quote ID |
☐ |
|
recipientDisplayName |
string |
Recipient Display Name |
☐ |
|
recipientEmailAddress |
string |
Recipient Email Address |
☐ |
|
taskID |
int64 |
Task ID |
☐ |
|
templateName |
string |
Template Name |
☐ |
|
ticketID |
int64 |
Ticket ID |
☐ |
|
timeEntryID |
int64 |
Time Entry ID |
☐ |
|
value |
string |
Value |
☐ |
|
19-03-2022 11:56 Version 22.0.85-PROD+3263