Definition of NEPC Database

Consumer and Logistic Unit

Data Fields	Format	M/C	Description	Example /Tips
EAN Code	N..13	M	This refers to the EAN-13 bar code on consumer products. The 4 different types of EAN barcode format accepted by the NEPC system are : EAN-13 EAN-8 UPC-A or (UPC-12) UPC-E or (UPC-6) *Note: Please refer to appended document on Understanding EAN Code for further details on the respective barcodes and its conversion algorithm*	Eg : EAN-13 will be stored in NEPC as 8888295200273 Eg : EAN-8 will be stored in NEPC as 0000050285549 Eg : UPC-A (UPC-12) will be stored in NEPC as 0073390000165 Eg : UPC-E (UPC-6) will be stored in NEPC as 0019100008793
Brand	AN..20	M	Brand of the product.	Eg : Tiger, Yeo’s, Cock Brand, Kiwi, Gillette, Colgate, Kao, Nestle
Product Description	AN..70	M	This caters for consumer products and industrial spare parts. For consumer products, the long description can be the same as the short description of these products for point-of-sales scanning. In the case of industrial products, the product description may also include where the products are to be attached and the various functions of the products. The product description should include brand name, product description and size	Eg : Cadbury Dairy Milk Chocolate Hazel Nut 250gm (Brand + Product Description + Size) *Note: Please include the net weight or size of the product in this field*
POS Description	AN..18	M	This is a short description of the product for printing on the point-of-sales receipts produced by the cash register. The purpose of point-of-sales (POS) description is an attempt by SANC to standardise all the product description to be listed at the point-of-sales checked-out by all retailers in Singapore. It is limited to 18 characters only. The product description should include brand, product description and size	Eg : Cadbury Haznut 250 (Brand + Product Description (shortened) + size) Note: As this is limited to only 18 characters, the product description has to be shortened in such a way that it remains meaningful. The brand and size are compulsory. We recommend brand in full and to omit the unit of measurement eg. kg, gm in this field.
Category	AN..5	M	This refers to the classification of the product. A set of category listings has been drawn up by SANC consisting of various categories and its corresponding code. The purpose of having category is to facilitate the search engine in the data acquisition software & NEPC to group all similar items to facilitate easy selection of product.	Eg : Instant Coffee - B0401 Coffee Beans - B0402 Carbonated Beverages - B0101 Canned Vegetables - F3805 Laundry Soap - H0302 Note: All these categories are already built in to the data acquisition software & NEPC. Please select the most appropriate category for your product and enter the category code attached to it when entering data. In cases whereby you are not able to find a suitable category for your product, please send a fax to SANC.
Size	N..10	M	This refers to the net weight or net volume of the product without any packaging. Only the numeric value is recorded.	Eg : Net weight of the product is 50gm *50 is then entered as size of the product. Eg : Size of a pair of socks is S/M/L or 10-12 cm. As this data field only accepts numeric* characters, please enter a 0 (zero) for size and enter the size of socks in this case in the product description
Unit of Size Measurement	A..5	M	This refers to the unit of measurement or the measure unit qualifier for size. Please refer to the appended list of EANCOM published standards for the measure unit qualifier. Note: All these unit of measurements are already built in to the data acquisition software & NEPC	Eg : millilitre – mlt gram - grm kilogram - kgm Size of the product is 50gm *grm is then entered as the unit of size measurement* Please select the most appropriate unit of measurement code for size of product
Material	A..15	O	This refers to the packaging material of the product	Eg : glass, plastic, paper, tin
Type of Packaging	AN..15	O	This is the type of packaging of the product	Eg : bottles, cans, boxes, bags
Height	N..14	O	Dimension of the product This refers to the height of the product and only the numeric value is recorded.	Eg : Height, width, depth of the product is 20 x 10 x 50 cm *20 is then entered as value for height* If you are not able to supply us with this measurement, you may leave this blank.
Width	N..14	O	Dimension of the product This refers to the width of the product and only the numeric value is recorded.	Eg : Height, width, depth of the product is 20 x 10 x 50 cm *10 is then entered as value for width* If you are not able to supply us with this measurement, you may leave this blank.
Depth	N..14	O	Dimension of the product This refers to the depth of the product and only the numeric value is recorded	Eg : Height, width, depth of the product is 20 x 10 x 50 cm *50 is then entered as value for depth* If you are not able to supply us with this measurement, you may leave this blank.
Unit of Dimension Measurement	A..5	O	This refers to the unit of measurement or the measure unit qualifier for dimension measurement Please refer to the appended list of EANCOM published standards for the measure unit qualifier	Eg : centimetre - cmt millimetre - mmt metre - mtr As above, height, width & depth are measured in cm, *cmt is entered as the unit of weight measurement. Note: All these unit of measurements are already built in to the data acquisition software & NEPC Please select the most appropriate unit of measurement code for size of product*
Gross Weight	N..14	O	This is the gross weight of the product including packaging and only the numeric value is recorded.	Eg : Gross weight of product is 55gm *55 is then entered as the value for gross weight.*
Unit of Weight Measurement	A..5	O	This refers to the unit of measurement or the measure unit qualifier for weight. Please refer to the appended list of EANCOM published standards for the measure unit qualifier.	Eg : kilogram - kgm milligram - mmg Gross weight of product is 55grm, then *grm is entered as the unit of weight measurement* Note: All these unit of measurements are already built in to the data acquisition software & NEPC Please select the most appropriate unit of measurement code for size of product
Country of origin	AN..2	M	Country where the item was manufactured. Please refer to the appended list of ISO-3166 two alpha code for country codes.	Eg : Singapore - SG Note: All these categories are already built in to the data acquisition software & NEPC. Please select the most appropriate country code for country of origin of product.
Product Availability Date	N..8	O	This is the date where the item is available for despatch. It refers to the first date of delivery from supplier.	Eg : 22021999
End availability date	N..8	O	This is the date where the item is not available for despatch anymore. It refers to the last date of delivery from supplier.	Eg : 02031999
Returnable/ Recyclable Product information	AN..3	O	This is the coded information about the handling of the container of the product.	Eg : Returnable container - PRM Recyclable container - RCM
Minimum Order Quantity	N..6	O	This is the minimum quantity to be ordered at any time.	Eg : 10
Recommended Retail Price	N..17	O	This is the selling price provided by the supplier and it does not include any tax. Only the numeric value is entered in this field	Eg : S$15.50 *15.50 is then entered as the recommended retail price*
Currency	AN..3	O	This is the coded identification of the monetary unit involved in the transaction. Please refer to ISO 4217 three alpha code/EDIFACT codelist of DE6345	Eg : S$ - SGD M$ - MYR Note: All these currencies are already built in to the data acquisition software & NEPC. Please select the most appropriate currency for your product.

Carton Information

Data Fields	Format	M/C	Description	Example /Tips
Carton Number	N..14	M	This is the bar code symbol on the shipping carton. It is recommended to use ITF-14. However, EAN-13, UPC-12 codes are also acceptable. Note: The DOS-acquisition software will automatically generate an ITF-14 carton number. This is done by taking out the check digit of the EAN-13 of the product, add a logistical variant (a number from zero to nine) in front and the check digit will be calculated including the logistical variant according to the check digit algorithm. Logistical variants are allocated at the discretion of the company. They are used to create an unique ITF-14 number which distinguishes between different packaging levels of the same item. This option is only available when the items within the non-retail item are carrying the same EAN-13 number. For instance, if a company has different levels of packaging or different pack size in a shipping carton, A carton of 12 pcs A carton of 24 pcs A carton of 24 pcs A carton of 36 pcs In this case, the 1^st digit of the ITF-14 carton code will be represented by 1 for carton with 12 pcs, 2 for carton with 24 pcs and 3 for carton with 36 pcs. In cases where an EAN-13 or UPC-12 barcode is used for carton, upon entering the EAN-13 barcode, additional zero are automatically appended in front of the EAN-13 or UPC-12 barcode to reflect a 14-digit carton barcode. In the event where your company have already created an ITF-14 digit carton code, please overwrite the ITF-14 carton code generated by the software by entering your existing carton code.	Eg : Product with EAN-13 barcode 888 8247 13411 3 ITF-14 carton code for the above will be stored in NEPC as a) Carton with 12 pcs 1 888 8247 13411 0 b) Carton with 24 pcs 2 888 8247 13411 7 c) Carton with 36 pcs 3 888 8247 13411 4 EAN-13 carton code for the above will be stored in NEPC as 0 888 8247 13411 3 If you have any queries, please contact SANC at Tel: 3311535. Note: Please refer to the appended document on Understanding EAN Code for details on how to compute the carton code based on the availability of EAN Code
Brand	AN..20	M	Brand of the product in the carton.	Eg : Tiger, Yeo’s, Cock Brand, Kiwi, Gillette, Colgate, Kao, Nestle
Carton Description	AN..70	M	In the case of electronic procurement via internet using EDI, buyers will order goods in carton. It is therefore necessary to have a bar code symbol and product description on the outside of the cartons. The carton description should include brand name, product description, size of the product x No. of units per carton and the type of packaging	Eg : Cock Brand - Pure Groundnut oil - 2kg x 6 bottles Tiger - Tiger Beer - 330ml x 24 cans (Brand + Product Description + Sizes x No. of units per carton and type of packaging)
POS Description	AN..18	M	This is a short description of the product for printing on the point-of-sales receipts generated by the cash register. The purpose of point-of-sales (POS) description is an attempt by SANC to standardise all the product description to be listed at the point-of-sales checked-out by all retailers in Singapore. It is limited to 18 characters only. The product description should include Brand name, product description and size	Eg : Cadbury