The Vendor Object

This item maps to the Vendor object in the IT Asset Management compliance database. It supports the addition of custom properties through the Business Importer.

Properties

The Vendor object exposes the following properties in the data model for the Business Importer and the Business Adapter Studio.

Table 1. Data model properties for Vendor object (alphabetical listing)

Property

Details

Address - City

Type: nvarchar. Maximum: 200.

Maps to Vendor.Address_City in the compliance database.

Address - Country

Type: nvarchar. Maximum: 100.

Maps to Vendor.Address_Country in the compliance database.

Address - State

Type: nvarchar. Maximum: 200.

Maps to Vendor.Address_State in the compliance database.

Address - Street

Type: nvarchar. Maximum: 200.

Maps to Vendor.Address_Street in the compliance database.

Address - Zip

Type: nvarchar. Maximum: 20.

Maps to Vendor.Address_ZIP in the compliance database.

Email

Type: nvarchar. Maximum: 200.

Maps to Vendor.Email in the compliance database.

Fax Number

Type: nvarchar. Maximum: 30.

Maps to Vendor.FaxPhoneNumber in the compliance database.

Name

Type: nvarchar. Maximum: 64. Mandatory: adapters must provide values for this column.

Maps to Vendor.VendorName in the compliance database.

Parent Vendor ID

Type: int.

Stores the ParentVendorID as a foreign key to the Vendor table in the compliance database.

Phone Number

Type: nvarchar. Maximum: 30.

Maps to Vendor.BusinessPhoneNumber in the compliance database.

Website

Type: nvarchar. Maximum: 200.

Maps to Vendor.WebSite in the compliance database.

Data model version 13.2

IT Asset Management (Cloud)

Current