Reqio eProcurement Scotland Format

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)
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
Item SKU No	Text	20	ü	The product code of the catalogue item.
Item SKU Description	Text	255	ü	The description of the catalogue item.
Customer Price	Money	12	ü	The price of the catalogue item for the buying organisation.
Unit of Measure	Text	6	ü	A valid Unit of Measure code. See section Unit of Measure Coding within this manual.
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.
MPC	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 valid URL for the image.
URL	Text	255		URL for your companies web site. Must begin http://
List Price	Money	12	ü	The current list price or suggested selling price of the catalogue item.
Minimum Quantity	Numeric	12		The minimum order quantity, expressed as a numeric value, for the catalogue item.
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.
Discount	Numeric	12		The discount (expressed as a percentage value) that the buying organisation qualify for.
Page Number	Text	255		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.
Item Substitute	Text	255		If a catalogue item alternative / supersession is available, the Item Number of the alternative catalogue item can be entered into this field.
Receipt Required	Text	1		Y for Yes, N for No (Default is N)