Vendor CSV

The Vendor table is used to store both the publishers of software and the resellers. You may use the same sample CSV file in both cases. Limited information about vendors is available in the web interface for IT Asset Management, but additional columns are available in the database, and are available for reports and other purposes.

Table 1. Spreadsheet columns for Vendor DDI

Column

Details

Address_City

Type: String. Optional. Maximum: 200

The city of the vendor.

Address_Country

Type: String. Optional. Maximum: 100

The country of the vendor.

Address_State

Type: String. Optional. Maximum: 200

The state of the vendor.

Address_Street

Type: String. Optional. Maximum: 200

The street of the vendor.

Address_ZIP

Type: String. Optional. Maximum: 20

The zip of the vendor.

Email

Type: String. Optional. Maximum: 200

The email address of the vendor.

FaxNo

Type: String. Optional. Maximum: 30

The fax number of the vendor.

ParentName

Type: String. Optional. Maximum: 64

The name of the vendor’s parent. The parent vendor must already exist in the database; if not, the value is discarded.

PhoneNo

Type: String. Optional. Maximum: 30

The phone number of the vendor.

VendorName

Type: String. Key. Mandatory. Maximum: 64

The name of the vendor.

Web_Site

Type: String. Optional. Maximum: 200

The web site of the vendor.

IT Asset Management (Cloud)

Current