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) |