---
title: "Products_ItemsUserDefinedFields (Autotask)"
description: "itgen_autotask_products_itemsuserdefinedfields_plural"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/autotask/Autotask.Products.Products_ItemsUserDefinedFields
original: https://documentation.invantive.eu/en/datamodels/autotask/Autotask.Products.Products_ItemsUserDefinedFields
updated: 2024-06-10T18:39:25Z
license: https://documentation.invantive.eu/en/
---

# Products_ItemsUserDefinedFields: Autotask itgen_autotask_products_itemsuserdefinedfields_plural

`read only` `REST`

- Catalog: `Autotask`
- Schema: `Products`
- Label: itgen_autotask_products_itemsuserdefinedfields_plural

Can only retrieve data.

## API Source

- Endpoint: `/V1.0/Products/query`
- Operation: `get /V1.0/Products/query`

## Table Columns

The columns of the table `Products_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 |
|---|---|---|:---:|---|---|
| `billingType` | `int32` | Billing Type | [ ] |  |  |
| `chargeBillingCodeID` | `int32` | Charge Billing Code ID | [ ] |  |  |
| `defaultInstalledProductCategoryID` | `int32` | Defaul Iinstalled Product Category ID | [ ] |  |  |
| `defaultVendorID` | `int32` | Default Vendor ID | [ ] |  |  |
| `description` | `varchar2` | Description | [ ] |  |  |
| `doesNotRequireProcurement` | `char` | Does not require Procurement | [ ] |  |  |
| `externalProductID` | `varchar2` | External Product ID | [ ] |  |  |
| `id` | `int64` | ID | [ ] |  |  |
| `impersonatorCreatorResourceID` | `int32` | Imperonsator Creator Resource ID | [ ] |  |  |
| `internalProductID` | `varchar2` | Internal Product ID | [ ] |  |  |
| `isActive` | `char` | Is Active | [ ] |  |  |
| `isEligibleForRma` | `char` | Is Eligible for RMA | [ ] |  |  |
| `isSerialized` | `char` | Is Serialized | [ ] |  |  |
| `link` | `varchar2` | Link | [ ] |  |  |
| `manufacturerName` | `varchar2` | Manufacturer Name | [ ] |  |  |
| `manufacturerProductName` | `varchar2` | Manufacturer Product Name | [ ] |  |  |
| `markupRate` | `double` | Mark-up Rate | [ ] |  |  |
| `msrp` | `double` | MSRP | [ ] |  |  |
| `name` | `varchar2` | Name | [ ] |  |  |
| `name_1` | `varchar2` | Name | [ ] |  |  |
| `periodType` | `int32` | Period Type | [ ] |  |  |
| `priceCostMethod` | `int32` | Price Cost Method | [ ] |  |  |
| `productBillingCodeID` | `int32` | Product Billing Code ID | [ ] |  |  |
| `productCategory` | `int32` | Product Category | [ ] |  |  |
| `sku` | `varchar2` | SKU | [ ] |  |  |
| `unitCost` | `double` | Unit Cost | [ ] |  |  |
| `unitPrice` | `double` | Unit Price | [ ] |  |  |
| `value` | `varchar2` | Value | [ ] |  |  |
| `vendorProductNumber` | `varchar2` | Vendor Product Number | [ ] |  |  |



## Release Notes

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

- [Autotask](/en/release-notes/drivers?driver=autotask)

