PECOS Format

Previous  Top  Next

Overview

 

Each product or service contained within a PECOS catalogue will require certain mandatory data values, and certain optional data values. The table below defines each field within the PECOS catalogue format, and also highlights those fields that are mandatory.

 

Field Name

Data  Type

Max  Length

Mandatory

Description

Supplier Number

Text

20

ü

An alpha numeric code assigned by the buying organisation to identify the supplier.

Catalogue Keyword

Text

30

ü

The name of the catalogue (this should be defined by the buying organisation if this is not available request this information from the buying organisation prior to creating a catalogue)

Level 1 Code

Numeric

4

 

A bespoke commodity code defined by the buying organisation. If the buying organisation has requested that you use bespoke commodity codes please leave the UNSPSC field blank.

Level 1 Description

Text

30

 

The description of the bespoke commodity code defined in the previous field.

Level 2 Code

Numeric

4

 

A bespoke commodity code defined by the buying organisation. If the buying organisation has requested that you use bespoke commodity codes please leave the UNSPSC field blank.

Level 2 Description

Text

30

 

The description of the bespoke commodity code defined in the previous field.

Level 3 Code

Numeric

4

 

A bespoke commodity code defined by the buying organisation. If the buying organisation has requested that you use bespoke commodity codes please leave the UNSPSC field blank.

Level 3 Description

Text

30

 

The description of the bespoke commodity code defined in the previous field.

Level 4 Code

Numeric

4

 

A bespoke commodity code defined by the buying organisation. If the buying organisation has requested that you use bespoke commodity codes please leave the UNSPSC field blank.

Level 4 Description

Text

30

 

The description of the bespoke commodity code defined in the previous field.

Level 5 Code

Numeric

4

 

A bespoke commodity code defined by the buying organisation. If the buying organisation has requested that you use bespoke commodity codes please leave the UNSPSC field blank.

Level 5 Description

Text

30

 

The description of the bespoke commodity code defined in the previous field.

UNSPSC Code

Text

10

ü

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

Manufacturer

Text

30

 

The name of the manufacturer of the catalogue item.

Item Number

Text

20

ü

The product code of the catalogue item.

Item Description

Text

255

ü

The description of the catalogue item.

List Price

Money

12

ü

The current list price or suggested selling price of the catalogue item.

Customer Price

Money

12

ü

The price of the catalogue item for the buying organisation.

Discount

Numeric

12

 

The discount (expressed as a percentage value) that the buying organisation qualify for.

Unit of Measure

Text

6

ü

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

Minimum Quantity

Numeric

12

 

The minimum order quantity, expressed as a numeric value, for the catalogue item.

Page Number

Text

4

 

If the catalogue item is listed on a paper based catalogue, the relevant page number where the item is listed can be entered in this field.

Date Effective Start

Date

n/a

 

The start date that the contract pricing for this catalogue item is valid from.

Date Effective End

Date

n/a

 

The end date that the contract pricing for this catalogue item becomes invalid.

Item Substitute

Text

20

 

If a catalogue item alternative / supersession is available, the Item Number of the alternative catalogue item can be entered into this field.

Manufacturer Number

Text

50

 

The manufacturer's product code of the catalogue item. This field is useful as it can provide another level of search criteria for buyers when looking for products to purchase.

Image 1

Text

255

 

If an image exists for the catalogue item enter the image filename (pdf, gif, jpg or bmp formats) or a valid URL if the image is available on the internet. (If a file name is entered a CD / DVD  containing all image files will need to be sent to the buying  organisation with the catalogue)

Image 2

Text

255

 

Not required

Text 1

Text

255

 

Not required

Text 2

Text

255

 

Not required

Audio

Text

255

 

Not required

Video

Text

255

 

Not required

URL

Text

255

 

URL for your companies web site. Must begin with http://

Item Type

Text

20

ü

Select from:-

"regular" for catalogue items

"config" for configuration

"consolidate" for consolidated items

"ddoc" for dynamic documents

"eform" for electronic forms

The default value is regular

Receipt Required

Text

1

 

Y for Yes, N for No (Default is N)