Field Name

Data  Type

Max  Length

Mandatory

Description

Supplier ID

Text

255

ü

Your Honda supplier ID

Supplier Part ID

Text

255

ü

Your product code of the catalogue item.

Manufacturer Part ID

Text

255

ü

The manufacturers product code for the catalogue item

Item Description

Text

255

ü

The description of the catalogue item. These descriptions should be formatted with initial capitals only.

UNSPSC Code

Text

40

ü

A valid UNSPSC code. See section UNSPSC Coding within this manual.

Unit Price

Numeric

n/a

ü

The price of the catalogue item for Honda. 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

ü

A name of the manufacturer of the catalogue item

Supplier URL

Text

255

The internet address of your web site, or the page of your web site where the catalogue item is displayed

Manufacturer URL

Text

255

The internet address from the manufacturers web site where the catalogue item is displayed

Market Price

Numeric

n/a

ü

The RRP or standard selling price for the catalogue item

Short Name

Text

50

A shortened version of the description of the catalogue item (up to a maximum of 50 characters)

Currency

Text

32

ü

The currency for the catalogue item. Only a value of GBP can be entered.

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

Minimum Order Quantity

Numeric

5

The minimum order quantity value for the catalogue item

Lotsize

Numeric

5

The minimum increment value that the catalogue item can be ordered in, e.g. if an item has a minimum order quantity of 100, but can then be ordered in quantities of 50 this field will have a value of 50

Honda Part Number

Text

50

The Honda Part Number for the catalogue item (if known)

Supplier Part Aux ID

Text

255

If a catalogue item has multiple prices based on order quantities, this field is used to define the order quantity value e.g. if a catalogue item has a price of 10.00 for order quantities of 1this would be added as a line within the catalogue. If the price reduced down to 8.00 when the order quantity was 100 to 200, this would need to be added as a new catalogue line with exactly the same records in all field except a reduction in the Unit Price field and a value of 100 entered into this field.