Subscriptions_ItemsUserDefinedFields |
Catalog: Autotask
Schema: Subscriptions
This is a read-only table. The Autotask API may not support changing the data or the Invantive UniversalSQL driver for Autotask does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Autotask API.
Table Columns
The columns of the table Subscriptions_ItemsUserDefinedFields are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
configurationItemID |
int32 |
Configuration Item ID |
☐ |
|
description |
string |
Description |
☐ |
|
effectiveDate |
datetime |
Effective Date |
☐ |
|
expirationDate |
datetime |
Expiration Date |
☐ |
|
id |
int64 |
ID |
☐ |
|
impersonatorCreatorResourceID |
int32 |
Imperonsator Creator Resource ID |
☐ |
|
materialCodeID |
int32 |
Material Code ID |
☐ |
|
name |
string |
Name |
☐ |
|
organizationalLevelAssociationID |
int32 |
Organizational Level Association ID |
☐ |
|
periodCost |
double |
Period Cost |
☐ |
|
periodPrice |
double |
Period Price |
☐ |
|
periodType |
int32 |
Period Type |
☐ |
|
purchaseOrderNumber |
string |
Purchase Order Number |
☐ |
|
status |
int32 |
Status |
☐ |
|
subscriptionName |
string |
Subscription Name |
☐ |
|
totalCost |
double |
Total Cost |
☐ |
|
totalPrice |
double |
Total Price |
☐ |
|
value |
string |
Value |
☐ |
|
vendorID |
int32 |
Vendor ID |
☐ |
|
10-06-2024 18:39 Version 24.1.3-BETA+4689