Normalize: IT Procurement

Field

Description

INV Date

Inventory Date

INV Group

Inventory Group

INV ID

Inventory ID

INV Name

Inventory Name

INV Status

Inventory Status

INV Is Latest?

Is this the latest Inventory within its Inventory Group?

Field

Description

PO Manufacturer Part Number

Purchase Order Manufacturer Part Number

PO Manufacturer

Purchase Order Manufacturer

PO Product Description

Purchase Order Product description

PO Unit of Measure

Purchase Order Unit of Measure

PO Other Information

Purchase Order Other Information

PO Reseller

Purchase Order Reseller Name

PO SKU Number

Purchase Order SKU Number

PO Quantity

Purchase Order Quantity

PO Unit Price

Purchase Order Unit Price

PO Total Price

Purchase Order Total Price

PO Start Date

Purchase Order Start Date

Field

Description

Ent Class

Entitlement Class

Ent Manufacturer

Entitlement Manufacturer

Ent Description

Entitlement Description

Ent Type

Entitlement Type

Ent Metric

Entitlement Metric

Ent Pack Count

Entitlement Pack Count

Ent Term

Entitlement Term

Ent Start Year

Entitlement Start Year

Ent Start Quarter

Entitlement Start Quarter

Ent Start Month

Entitlement Start Month

Ent Start Date

Entitlement Start Date

Ent End Year

Entitlement End Year

Ent End Quarter

Entitlement End Quarter

Ent End Month

Entitlement End Month

Ent End Date

Entitlement End Date

Field

Description

HW Category

Hardware Category (Taxonomy)

HW Subcategory

Hardware Subcategory (Taxonomy)

HW Vendor Category

Product category per vendor

HW Manufacturer

Hardware Manufacturer

HW Manufacturer ID

Hardware manufacturer identification number

HW Product

Hardware product name

HW Product ID

Hardware product identification number

HW Model

Device model name/number

HW Model ID

Hardware model identification number

HW Supported OS

List of supported operating systems that can be run on the device

HW Max CPU sockets

Maximum number of CPU sockets available in the machine

Field

Description

HW Is Supported? (calc.)

BDNA guideline to customers, as to the support status for a product

HW Supported Reason (calc.)

Reason determining the product support status. I.e. published date, calculated date

HW EOL Year (calc.)

Calculated hardware end-of-life year. Calculated date is based on Technopedia hardware product published dates

HW EOL Quarter (calc.)

Calculated hardware end-of-life quarter-in-year. Calculated date is based on Technopedia hardware product published dates

HW EOL Month (calc.)

Calculated hardware end-of-life month-in-year. Calculated date is based on Technopedia hardware product published dates

HW EOL Date (calc.)

Calculated hardware end-of-life date. Calculated date is based on Technopedia hardware product published dates

Field

Description

HW Mfr Part Number

A combination of numbers, letters, and symbols assigned by a designer, a manufacturer, or vendor to identify a specific part or item of materiel

HW Mfr Currency Code

Currency code as defined in ISO 4217, which is a standard published by the International Organization for Standardization, which delineates currency designators, country codes (alpha and numeric), and references to minor units

HW Mfr List Price

The price of an article as shown in a list issued by the manufacturer or by the general body of manufacturers of the particular class of goods, Manufacturer Suggested Retail Price (MSRP)

HW Mfr Actual Price

The actual price of an article that is available to general public, market price, retail price, street price

Field

Description

HW Lic Type

Type of license as indicated in the hardware license

HW Lic Metrics

License metric(s) for the device, as specified in the hardware license

HW Lic Unit Pack

Unit of devices included in the hardware license

HW Lic Unit Count (Min)

Minimum count of devices included in the hardware license

HW Lic Unit Count (Max)

Maximum count of devices included in the hardware license

HW Lic Term

Term of the hardware license

HW Lic Other Terms

Other terms/conditions or additional information indicated in the hardware license

HW Lic Period Unit

Unit of period value column

HW Lic Period Value

License period of the device as indicated in the hardware license

HW Lic Maintenance Period Unit

Unit of maintenance period value column

HW Lic Maintenance Period Value

Maintenance period that comes with the device as indicated in the hardware license

HW Lic Vendor Product Name

Complete name of the product as presented by the vendor in the hardware license as well as other official documentation and/or website

HW Lic Vendor Unit Measure

Unit of measure of the product as indicated in the hardware license

Field

Description

HW Lic Installed RAM

Value of RAM installed in the device as indicated in the hardware license

HW Lic Installed RAM Unit

Unit of RAM value as indicated in Installed RAM column

HW Lic Maximum RAM

"Maximum RAM supported by the device as indicated in the hardware license"

HW Lic Maximum RAM Unit

Unit of maximum RAM value in the memory maximum column

HW Lic RAM Specification

Specification of RAM that comes with the device as indicated in the hardware license

HW Lic RAM Technology

Technology of RAM that comes with the device as indicated in the hardware license

HW Lic RAM Speed

Speed of RAM (in MHz) that comes with the device as indicated in the hardware license

HW Lic Storage Capacity

Storage capacity that comes with the device as indicated in the hardware license

HW Lic Storage Unit

Unit of storage capacity value in the storage capacity column

HW Lic Hard Drive Interface

Hard drive interface supported by the device as indicated in the hardware license

HW Lic Network Type

Network type(s) available on the device as indicated in the hardware license

HW Lic Data Link Protocol

Data link protocol(s) supported by the device as indicated in the hardware license

HW Lic Optical Drive

Optical drive(s) installed in the device as indicated in the hardware license

HW Lic Graphics Card

Graphics card(s) installed in the device as indicated in the hardware license

HW Lic Interface Ports

Interface ports available on the device as indicated in the hardware license

HW Lic Monitor Resolution Length

Length of the monitor (in inches) included in the device, if applicable, as indicated in the hardware license

HW Lic Monitor Resolution Width

Width of the monitor (in inches) included in the device if applicable as indicated in the hardware license

HW Lic Processor Type

Type of processor(s) installed in the device as indicated in the hardware license

HW Lic Processor Speed

Clock speed (in GHz) of processor(s) installed in the device as indicated in the hardware license

HW Lic Processor Installed Quantity

Quantity of processors installed in the device as indicated in the hardware license

HW Lic Processor Max Supported

Maximum quantity of processors supported by the device as indicated in the hardware license

Field

Description

HW Lic CPU Manufacturer

CPU Manufacturer

HW Lic CPU Model

CPU Model

Field

Description

HW Lic Input Voltage

Electrical input voltage of the UPS device as indicated in the hardware license

HW Lic Input Voltage Unit

Unit of the value in input voltage column

HW Lic Input Voltage Range

Range of electrical input voltage of the UPS device as mentioned in the hardware license

HW Lic Input Frequency

Frequency of electrical input of the device as mentioned in the hardware license

HW Lic Output Voltage

Electrical output voltage of the UPS device as mentioned in the hardware license

HW Lic Output Voltage Unit

Unit of the value in output voltage column

HW Lic Outlets

Number of outlets available in the UPS device as mentioned in the hardware license

HW Lic Power Provided

Amount of power (in Volt-Amps) provided by the UPS device as mentioned in the hardware license

Field

Description

HW Lic Addl HW Manufacturer

Hardware License additional Hardware Manufacture

HW Lic Addl HW Product

Hardware License additional Hardware Product

Field

Description

HW Lic Addl SW Manufacturer

Hardware License additional Software Manufacturer

HW Lic Addl SW Product

Hardware License additional Software Product

Field

Description

SW Category

Software category (first level of taxonomy)

SW Subcategory

Software subcategory (second level of taxonomy)

SW Vendor Category

Product category per vendor

SW Manufacturer

Software manufacturer name

SW Manufacturer ID

Software manufacturer identification number

SW Family

Brand/family the software product belongs to, if applicable

SW Name

Name of the software product

SW Name ID

Software name identification number

SW Component

Component of the software product, if applicable

SW Market Version

Software market version (version group)

SW Market Version ID

Software market version identification number

SW Version

Software version number/name associated with the release

SW Version ID

Software version identification number

SW Service Pack

Software patch, update, or service pack level, if applicable

SW Edition

Software product edition name

SW Edition ID

Software edition identification number

SW Release ID

Softwarfe release identification number

SW Is Licensable?

Indicates whether the software release is licensable or not

SW Is Suite?

Indicates whether the software product is a suite

SW Suite

Software suite

SW Is Suite Component?

Indicates whether the software product is a component of a suite

SW Suite Component

Software suite component

SW Cloud or On-Premise?

Identifies whether the product is 'Cloud Only', 'On-Premise-Only', or 'Cloud and On-Premise'

SW On-premise equivalent

Equivalent on-premise product for cloud product

SW Cloud equivalent

Equivalent cloud product for on-premise product

Field

Description

SW Is Supported? (calc.)

BDNA guideline to customers, as to the support status for a product

SW Supported Reason (calc.)

Reason determining the product support status. I.e. published date, calculated date, version sequence

SW EOL Year (calc.)

Calculated software version end-of-life date. Calculated year is based on Technopedia software product published dates

SW EOL Quarter (calc.)

Calculated software version end-of-life date. Calculated quarter-in-year is based on Technopedia software product published dates

SW EOL Month (calc.)

Calculated software version end-of-life date. Calculated month-in-year is based on Technopedia software product published dates

SW EOL Date (calc.)

Calculated software version end-of-life date. Calculated date is based on Technopedia software product published dates

SW Desupported? (calc.)

A flag that indicates whether the version has been discontinued/desupported

SW Version Order (calc.)

Number that indicates the sequential order by which this particular version was released during the history of the product

SW Max Versions (calc.)

The highest version order of all the versions that were released during the history of the product

SW Versions (calc.)

Number of versions between the particular version and the highest version of the product

Field

Description

SW Mfr Part Number

A combination of numbers, letters, and symbols assigned by a designer, a manufacturer, or vendor to identify a specific part or item of materiel

SW Mfr Currency Code

Currency code as defined in ISO 4217, which is a standard published by the International Organization for Standardization, which delineates currency designators, country codes (alpha and numeric), and references to minor units

SW Mfr List Price

The price of an article as shown in a list issued by the manufacturer or by the general body of manufacturers of the particular class of goods, Manufacturer Suggested Retail Price (MSRP)

SW Mfr Actual Price

The actual price of an article that is available to general public, market price, retail price, street price

Field

Description

SW Lic Types

Software License License Types

SW Lic Type

Software License License Type

Field

Description

SW Lic Metrics

Software License License Metrics

SW Lic Metric 1

Software License License Metric 1

SW Lic Metric 2

Software License License Metric 2

SW Lic Metric Max Value

Software License License Metric Max Value

SW Lic Metric Min Value

Software License License Metric Min Value

Field

Description

SW Lic Price Levels

Software License Price Levels

SW Lic Price Level

Software License Price Level

SW Lic Price Level Definition

Software License Price Level Definition

SW Lic Price Level URL

Software License Price Level URL

Field

Description

SW Lic Pricing

Software License Pricing

SW Lic Pricing Definition

Software License Pricing Definition

SW Lic Pricing URL

Software License Pricing URL

Field

Description

SW Lic Programs

Software License Programs

SW Lic Program

Software License Program

SW Lic Program Definition

Software License Program Definition

SW Lic Program URL

Software License Program URL

Field

Description

SW Lic Distribution Medias

Software License Distribution Medias

SW Lic Distribution Media

Software License Distribution Media

SW Lic Distribution Quantity

Software License Distribution Quantity

Field

Description

SW Lic Environments

Software License Environments

SW Lic Environment

Software License Environment

Field

Description

SW Lic Languages

Software License Languages

SW Lic Language

Software License Language

Field

Description

SW Lic Maintenance Grades

Software License Maintenance Grades

SW Lic Maintenance Grade

Software License Maintenance Grade

SW Lic Maintenance Grade Definition

Software License Maintenance Grade Definition

SW Lic Maintenance Grade URL

Software License Maintenance Grade URL

Field

Description

SW Lic Upg from SW Manufacturer

Software License Upgrade from Software Manufacture

SW Lic Upg from SW Product

Software License Upgrade from Software Product

Field

Description

SW Lic Addl SW Manufacturer

Software License additional Software Manufacture

SW Lic Addl SW Product

Software License additional Software Product

Field

Description

PRI Is Private?

Indicates whether the data being analyzed is private or not

PRI Type

Indicates the type of private data, options are: Proprietary item or Modified item

PRI Object

Name of the object that has private data. Hardware or Software

PRI Table

Name of the table that has private data.

PRI Attribute

Name of the attribute that has been edited.

Field

Description

Ent Count

Entitlement Total Count

Ent Min Unit Price

Entitlement Minimum Unit Price

Ent Max Unit Price

Entitlement Maximum Unit Price

Ent Avg Unit Price

Entitlement Average Unit Price

Ent Total Price

Entitlement Total Price

HW Mfr Min List Price

The minimum price of an article as shown in a list issued by the manufacturer or by the general body of manufacturers of the particular class of goods, Manufacturer Suggested Retail Price (MSRP)

HW Mfr Max List Price

The maximum price of an article as shown in a list issued by the manufacturer or by the general body of manufacturers of the particular class of goods, Manufacturer Suggested Retail Price (MSRP)

HW Mfr Min Actual Price

The minimum actual price of an article that is available to general public, market price, retail price, street price

HW Mfr Max Actual Price

The maximum actual price of an article that is available to general public, market price, retail price, street price

SW Mfr Min List Price

The minimum price of an article as shown in a list issued by the manufacturer or by the general body of manufacturers of the particular class of goods, Manufacturer Suggested Retail Price (MSRP)

SW Mfr Max List Price

The maximum price of an article as shown in a list issued by the manufacturer or by the general body of manufacturers of the particular class of goods, Manufacturer Suggested Retail Price (MSRP)

SW Mfr Min Actual Price

The minimum actual price of an article that is available to general public, market price, retail price, street price

SW Mfr Max Actual Price

The maximum actual price of an article that is available to general public, market price, retail price, street price