Field Name

Data  Type

Max  Length

Mandatory

Description

Supplier ID

Text

255

ü

Typically a D-U-N-S or NetworkID number. This string is case sensitive.

Supplier Part ID

Text

255

ü

The part Identifier used by the supplier. This string is case sensitive.

Manufacturer Part ID

Text

255

ü

The part identifier used by the manufacturer. This string is case sensitive.

Item Description

Text

255

ü

The description of the product or service.

UNSPSC Code

Text

40

ü

The product classification code, usually a UNSPSC standard code (see section UNSPSC Coding within this manual).

Unit Price

Numeric

n/a

ü

The customer's price without the currency symbol. Up to 4 decimal places can be specified with the decimal place marker being a '.'

Unit of Measure

Text

62

ü

A valid Unit of Measure code. See section Unit of Measure Coding within this manual.

Lead Time

Numeric

n/a

ü

The number of business days between the order being received and the delivery date

Manufacturer Name

Text

255

ü

The name of the products manufacturer

Supplier URL

Text

255

The web address of the supplier's data sheet.

Manufacturer URL

Text

255

The web address of the manufacturer's data sheet.

Market Price

Numeric

n/a

ü

The list price or suggested retail price without the currency symbol. Up to 4 decimal places can be specified with the decimal place marker being a '.'

Short Name

Text

50

The short title for the catalogue item, to be used in lists when the Item Description is too long.

Language

Text

255

The language used for the catalogue

Currency

Text

32

ü

The ISO currency code e.g. GBP, USD. This string is case sensitive.

Expiration Date

Date

n/a/

ü

The date that the catalogue item becomes no longer valid

Effective Date

Date

n/a

ü

The date that the catalogue item becomes valid

Classification Codes

Text

5

If a buying organisation wishes to utilise an additional classification code in addition to the UNSPSC set, this field can be used to store the additional code.

Parametric Data

Text

255

Parametric data provides enhanced search functions for the catalogue item, e.g. sample parametric data would include size, colour, weight etc.

Parametric Name

Text

26

The textual labels for the parametric data provided in the Parametric Data field.

Punchout Enabled

Boolean

n/a

This field specifies a Punchout catalogue item. Valid entries to this field are True, true, False, false, f, f, 0, 1.

Territory Available

Text

255

A list of one or more ISO country or region codes indicating the geographical areas that the catalogue item will be supplied in.

Supplier Part Auxiliary ID

Text

255

An optional auxiliary string. This can be used in conjunction with the Supplier Part ID to define a unique catalogue item

Delete

Boolean

n/a

An optional key to indicate whether the catalogue item is to be deleted. Valid entries to this field are True, true, False, false, f, f, 0, 1 and the default value is False.