Home

ANIE – FNGDME - ARAME

1. Example ordering 2000 metres of cable with number A1 and order number 11 120 the following will occur Order linel item number Al quantity 2000 LIN LIN PIA PIA QTY QT 1082 C829 1082 C212 1 7140 C212 2 7140 6060 Y 6411 RA 000001 Al BRAND CODE 2000 LM Confirmation linel item number Al quantity 2000 LIN LIN PIA PIA QTY QT 1082 C829 1082 C212 1 7140 C212 2 7140 6060 Y 6411 RA 000001 Al BRAND CODE 2000 LM Manuale Operativo delle Definizioni V1 1R14 Pagina 115 Metel S r l ESTE L Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 DESPATCH NOTE For each item line for which a partial or complete delivery is made it is obligatory to indicate the package reference used for each item line in order to connect the purchased cable and packaging spool diameter Example In order 138 11 on line 26 item Al qty 2000 metres is ordered It is all delivered with despatch note 14 2011 on 3 spools which contain 500 metres 498 metres and 1002 metres respectively On the EDIFACT FORMAT Metel DDT there should be sg25 LIN and QTY Al ordered qty 2000 sent qty 2000 ref Ord 138 11 line 26 sg25 SGP and QTY spool code 1 quantity 500 sg25 SGP and QTY spool code 1 quantity 498 sg25 SGP and QTY spool code 1 quantity 1002 LIN PIA PIA QTY QTY QT QV RFF RFF RFF RFF 1082 7140 714
2. ESTE L Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 2 Introduction and Corrections This manual is protected by copyright under Italian delegated law No 169 dated 6 May 1999 Directive 96 9 EC Any and all use must be expressly authorized by Metel S r l Specifically All rights are reserved No part of this manual can be reproduced stored or sent in any way electronically mechanically copied or other without prior authorization by Metel S r l This manual contains the operative definitions regarding the Metel price list These definitions have been prepared by the Metel S r l Technical Committee and approved by the Metel S r l Board of Directors Metel informs its customers that the previous version of the price list document version 010 occurred on 31 12 99 effective 1 1 2000 On that same date the price list described in this document version 020 became effective To clarify it is intended that the production of the first price list with effective date 1 1 2000 must be created according to the structure described in this manual version 020 The Metel price list is one of the documents included in the Metel certification process which calls for the general and analytical control of the data it contains in the structure described in this manual The layout and format described in this manual Rel 1 1 rev 14 February 2014 have changed in comparison t
3. ESTE L Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 ANIE FME ARAME METEL PRICE LIST Version 020 021 METEL BARCODE Version 020 021 Rel 1 1 rev 14 January 2014 USER MANUAL DEFINITIONS Promoted the Member Companies of ANIE FME ARAME Developed by METEL S r l Metel S r l Via Govone 66 20155 Milan Italy Tel 39 02 34536118 Fax 39 02 34934145 Manuale Operativo delle Definizioni V1 1R14 Pagina 1 Metel S r l Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 2 INTRODUCTION AND CORRECTIONS 3 TECHNICAL CONVENTIONS FOR USE 4 THE PRICE LIST 4 1 The Rules 4 1 1 Formal and relevant controls on the price list 4 1 2 Metel Price List and Metel Barcode Certification 4 1 3 Correspondence of the Computer Based Price List to the Paper Based Price List 4 1 4 Distribution of the price list 4 1 5 New Metel abbreviations 4 1 6 Uniqueness of codes 4 1 7 Item Recodification 4 1 8 Discount and Statistics Ranges 4 2 Structure of the Price List Header ver 020 and ver 021 4 2 1 STRUCTURE IDENTIFICATION Ver 020 from position 1 a 20 A 20 M Ver 021 from position 1 a 20 A 20 M 4 2 2 COMPANY ID Ver 020 from position 21 a 23 An 03 M Ver 021 from position 21 a 23 An 03 M 4 2 3 VAT No Ver 020 from position 24 a 34 N 11 M Ver 021 from position 24 a 34
4. All of the fields are associated to an additional code that indicates if the field is mandatory optional or conditional Conditional means that it will be present as a function of the presence of another field In the sections inherent to the price lists all of the mandatory and optional fields are dealt with simply For simplicity and ease of understanding we will use the same abbreviations used in the EDIFACT Standard Mandatory M Mandatory Optional O Optional Conditional C Conditional Manuale Operativo delle Definizioni V1 1R14 Pagina 13 Metel S r l UT LI Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 4 The Price List This user manual provides the definitions of the rules to follow for the creation and correct use of the Metel price list by manufacturers and distributors The rules listed in the manual are defined in the following areas Formal and relevant controls on the price list Correspondence of the computer based price list to the paper based price list Distribution of the price list Names of the Metel files New Metel abbreviations Uniqueness of codes Item Recodification Discount and Statistic Ranges Metel Price List and Metel Barcode Certification Manuale Operativo delle Definizioni V1 1R14 Pagina 14 Metel S r 1 UT LI Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 4 1 The Rules
5. Form the next issue of the price list the reference date for the last change addition must be entered in the header and then repeated on all of the line details involved If there are no changes or addition of items the date of change will always have the same value as the effective date Example 20040301 20000101 20000101 20000101 20040301 20000101 20000101 20040301 Manuale Operativo delle Definizioni V1 1R14 Pagina 65 Metel S r 1 UT LI Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 4 3 18 DISCOUNT RANGE Ver 020 from position 142 to 159 An 18 O Ver 021 from position 142 to 159 An 18 O 4 3 19 STATISTICS RANGE Ver 020 from position 160 to 177 An 18 O Ver 021 from position 160 to 177 An 18 O Description The discount and statistics ranges respectively represent Sets of product for discounts on the list price including all codes that benefit from a specific discount range Set of products for statistical purposes including all products that have the same uniform statistical criteria for the seller Sets for discount do not explicitly express the discount values applied rather they refer to a code to be interpreted using a special decodification table supplied by the seller The seller will adopt criteria for sets that he retains most suitable with only restriction in the length of the fields It is obvious that fi
6. space c period Manuale Operativo delle Definizioni V1 1R14 Pagina 48 Metel S r l ESTE L Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 4 3 3 EAN CODE Ver 020 from position 20 to 32 N 13 O Ver 021 from position 20 to 32 N 13 O Description This field contains the EAN 13 code for the product The product is that defined by UNIT OF MEASURE for ex piece switch PRICE which refers to the abovementioned unit of measure The EAN code therefore uniquely identifies the product and the QUANTITY For example a carton and a package containing different quantities of the same product must have DIFFERENT EAN 13 codes For this reason the Barcode structure which is an integral part of this manual completes the information on the product providing for each type of packaging the respective EAN code Example Pallet alle 80 12345 88888x pcs 4000 canon 4p 80 12345 66666x pcs 200 Package 80 12345 33333x pcs 10 Piece DI 80 12345 11111x pes 1 Manuale Operativo delle Definizioni V1 1R14 Pagina 49 Metel S r 1 UT LI Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 Technical Information It is mandatory for companies who are not registered with INDICOD to enter the EAN code or if they are not to provide information as to when they will insert it The EAN code must corres
7. 4 1 1 Formal and relevant controls on the price list Each time a new price list is generated new or change a series of checks must be performed by the sender issuer These controls must be performed On a formal level All fields must be correctly filled in according to the specifications contained in the attached manual price list recodification template discount statistics range table and barcode layout On a content level Transcription errors prices packaging contents etc And finally To best facilitate certification by Metel S r l for each new price list or change To minimize the activities for control that the receiver must perform except for exceptional checks and the consequent rectification and correction of the data and information sent To allow the receiver to best use of all the information contained therein It is expected that all companies that subscribe to METEL have price list control software capable of Performing all of the necessary controls on the price list Generating a report of the syntax and detail errors found to facilitate correction operations by the seller and reading by the receiver Manuale Operativo delle Definizioni V1 1R14 Pagina 15 Metel S r 1 UT LI Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 4 1 2 Metel Price List and Metel Barcode Certification With the certification process Metel in
8. Jamaican Dollar KES Kenyan Shilling KPW North Korean Won KYD Cayman Islands Dollar LKR Sri Lanka Rupee LUF Luxembourg Franc MGF Malagasy Franc MRO Ouguiya MVR Maldives Rupee MYR Malaysian Ringgit NIC Cordoba NPR Nepalese Rupee PAB Balboa PHP Philippine Peso PTE Portuguese Escudo ROL Leu SBD Solomon Islands Dollar SEK Swedish Kroner SLL Leone STD Dobra SYP Syrian Pound TND Tunisian Dinar TRL Turkish Lira TZS Tanzanian Shilling UYP Uruguayan New Peso VUV Vatu XCD East Caribbean Dollar YDD Yemeni Dinar ZAR Rand ZWD Zimbabwe Dollar Pagina 61 ALL Lek ARP Austral AWG Aruban Guilder BEF Belgian Franc BIF Burundi Franc BOB Bolivian Peso BTN Ngultrum BZD Belize Dollar CLP Chilean Peso CRC Costa Rican Colon CVE Cape Verde Escudo DJF Djibouti Franc DZD Algerian Dinar ESP Spanish Peseta FIM Markka FRF French Franc GIP Gibraltar Pound GQE Ekwele GWP Guinea Bissau Peso HNL Lempira IDR Rupiah INR Indian Rupee ISK Iceland Kroner JOD Jordanian Dinar KHR Riel KRW Won LAK Kip LRD Liberian Dollar LYD Libyan Dinar MNT Tugrik MTP Maltese Pound MWK Kwacha MZM Metical NLG Netherlands Guilder NZD New Zealand Dollar PES Inti PKR Pakistan Rupee PYG Guarani RWF Rwanda Franc SCR Seychelles Rupee SGD Singapore Dollar SOS Somali Shilling SUR Rouble SZL
9. January 2014 4 2 10 WHOLESALE PRICE LIST EFFECTIVE DATE Ver 020 from position 129 a 136 Dt C Ver 021 from position 129 a 136 Dt C Description This field contains the effective date of the wholesale price list in the YYYYMMDD year month day format The effective date is understood to be the date the wholesale price list will start to be valid that is the prices shown in the wholesale price column Should the retail and wholesale price lists have the same effective date this field must be filled with spaces This date is not mandatory and should only be indicated if it is necessary to specify a different effective date for the retail and wholesale prices Technical Information Dates earlier than 01 January 2000 are not permitted Manuale Operativo delle Definizioni V1 1R14 Pagina 40 Metel S r l UT LI Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 4 2 11 ISO VAT NO Ver 020 from position 137 a 152 An C Ver 021 from position 137 a 152 An C This field identifies the VAT number for the companies with operating and legal headquarters outside Italy For sales made to taxable persons located in other European Community member countries VAT is not applied For this reason it is necessary to show the exact VAT number of the European Community assignee on the invoice because should any irregularities emerge regarding this number during an audit
10. Rel 1 1 rev 10 March 2011 have changed in comparison to Rel 1 1 rev 9 January 2011 The changes or additions refer to the additional elements that do not prevent compatibility with the previous version Specifically the copper change calculation method has been eliminated indications related to conventional copper weight have been added an annex has been added Treatment specification for Cable Sector on Metel price list order confirmation and despatch note a field has been added containing the Intrastat code after the Barcode layout The layout and format described in this manual Rel 1 1 rev 9 January 2011 have changed in comparison to Rel 1 1 rev 8 May 2010 The changes or additions refer to the additional elements that do not prevent compatibility with the previous version Specifically the Weight Unit of Measurement field has been added after the Barcode layout with relative description and use and correct length of the remaining filler the HEIGHT and MAXIMUM HEIGHT field description has been changed Annex_A has been added for specific uses of the cable sector the page index has been corrected in the Barcode layout the Ean13 Code and Package barcode fields have been made mandatory The layout and format described in this manual Rel 1 1 rev 8 May 2010 have changed in comparison to Rel 1 1 rev 7 January 2010 The changes or additions refer to the additional elements that
11. see the section on rules Technical Information This field is alphanumerical When it contains less than 16 characters it must be left aligned and filled with spaces to the right Should the code used by the seller have more than 16 characters the same criteria of compression of the codes to the new format must be used on all of the above listed documents also in this case to guarantee uniform reading The characters allowed in the Item Number are From A to Z From a to z From 0 to 9 minus period slash space asterisk The use of other characters can cause the item numbers to be recorded incorrectly as a function of the receiver s IT system It is important to maintain the alphanumerical character format uniform The item number field must contain all capital letters or all small letters We recommend 1 Always using capital letters A to Z 2 Using numbers 0 to 9 Manuale Operativo delle Definizioni V1 1R14 Pagina 47 Metel S r l ESTE L 3 Eliminating progressively any other characters not allowed that might still be present in the Price List structure Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 4 For new item numbers we recommend not using characters other than those listed above in points 1 and 2 5 For separator characters within the item number the technical committee recommends the use of only a minus b
12. 000 8 5 0 0010000 3 100 10008360 gt 83 6 Manuale Operativo delle Definizioni V1 1R14 Pagina 82 Metel S r 1 UT LI Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 5 2 7 RECIPROCAL Ver 020 from position 55 to 55 N 01 M Ver 021 from position 98 to 98 N 01 M Description This field is used to describe all the types of packaging for a product Taking the carton quantity indicated in the price list as a refrence it is possible recognize and distinguish in this field the packages of an order greater RECIPROCAL 2 equal RECIPROCAL 0 lower RECIPROCAL 1 Example Price list Unit of measure PCE unit of reference for price EAN 13 EAN code for the item Carton Quantity 240 normally handled for shipment by the seller Barcode structure Ist line package of 10 pieces EAN 13 EAN code for the item refers to price list Package barcode EAN code of the package of 10 pieces Package quantity 10 Unit of Measure PCE as per the price list Reciprocal 1 package quantity less than carton quantity Package Type BX carton 2nd line package of 240 pieces EAN 13 EAN code for the item refers to price list Package barcode EAN code of the package of 240 pieces Package quantity 240 Unit of Measure PCE as per the price list Reciprocal 0 package quantity equal to carton quantity P
13. 1 UT LI Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 MANDATORY METEL PRICE LIST FIELDS FOR THE PURPOSES OF ASSOCIATION WITH THE TECHNICAL DESIGNATION Introduction In addition to all the fields required for certification of Metel price lists Manufacturers need to carefully fill in the following information The construction of a common language which digitally aligns the manufacturers and distributors databases allows maximum efficiency along the entire chain and complete compliance with the introduction of the copper incidence Otherwise monthly price list updating will be a difficult job for wholesalers in economic terms and with regards to operating efficiency for copper changes since they are the ones who must perform a monthly manual update of all cable manufacturers Manuale Operativo delle Definizioni V1 1R14 Pagina 107 Metel S r 1 UT LI Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 1 METEL PRICE LIST FIELDS 1 1 MULTIPLE ORDER QUANTITY Description This field must contain the multiple order quantity expressed in the unit of measurement spools coils drums and boxes that the company will accept to process an order Together with the Minimum Order Quantity field this is the basis for calculation of the order quantity Specifically Order Quantity minimum order quantity n multiple order quantity
14. 2 Company ID 21 M An 03 3 Company VAT No 24 M An 11 4 Barcode structure number 35 O An 06 5 Issue date 41 M Dt 6 Date of last change addition 49 M Dt 7 Filler 57 M An 69 8 Barcode structure version 126 M N 03 9 Filler 129 M An 43 Record length 171 bytes CR LF Manuale Operativo delle Definizioni V1 1R14 Pagina 72 Metel S r l ESTE L Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 The fields below are the same found in the header of the price list For a detailed description please see the previous sections that refer to the price list header 5 1 Structure of the Header Version 021 Seq Field Description Start of Field Mandatory Field Type and Position M Length Optional O 1 Structure ID 1 M A 20 2 Company ID 21 M An 03 3 Company VAT No 24 M An 11 4 Barcode structure number 35 O An 06 5 Issue date 41 M Dt 6 Date of last change addition 49 M Dt 7 Filler 57 M An 69 8 Barcode structure version 126 M N 03 9 Filler 129 M An 21 Record length 149 bytes CR LF The fields below are the same found in the header of the price list For a detailed description please see the previous sections that refer to the price list header Price list structure Barcode structure Date of last change addition Date of last change addition Issue date Effective date Barcode structure version structure version Structure ID
15. 2014 Example 95 Euro 000009500 85 45 Euro 000008545 CAUTION Should the unit of measure and or unit of sale be changed the product must be recodified Example Product A one box of 100 wall anchors unit of measure PCE minimum order quantity 1 piece 1 box list price 10 Euro WHEN RECODIFICATION IS NECESSARY see the recodification structure for details Product A no longer contains 100 wall anchors If the price refers to the content of the box 1 wall anchor If the unit of measure changes PCE Manuale Operativo delle Definizioni V1 1R14 Pagina 59 Metel S r 1 ESTE L Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 4 3 12 PRICE MULTIPLIER Ver 020 from position 120 a 125 N 06 M Ver 021 from position 120 a 125 N 06 M Description This field DOES NOT refer in any way to the package quantity More specifically It must be a numerical value The value expressed represents the whole number by which the unit price must be multiplied to reach the price shown in the price list wholesale or retail price Technical Information The multiplier cannot have a value less than 1 This multiplier must be shown on the lines of the invoices regarding the item therefore there is a version of the invoice that includes this field The multiplier can take on a range of values 1 10 100 1000 10000 100000 Example Below we have the case in which
16. 33 Metel S r 1 ESTE L Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 Price List Number varied between effective dates AZIENDA NUMERO DT DEC DT VAR METEL METI 20130101 20130101 METEL METI 20130101 20130415 METEL MET2 20130701 20130701 METEL MMTI 20130101 20130101 METEL MMTI 20130101 20130415 METEL MMT2 20130701 20130701 Technical Information The price list number can have up to six characters It is also used on the Order Order Confirmation Despatch Note and Invoice documents Example K 8 0 Price list No K80 Manuale Operativo delle Definizioni V1 1R14 Pagina 34 Metel S r 1 UT LI Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 4 2 5 PRICE LIST EFFECTIVE DATE Ver 020 from position 41 a 48 Dt M Ver 021 from position 41 a 48 Dt M Description This field contains the effective date of the price list in the YYYYMMDD year month day format This format is useful for ordering the dates The effective date is understood to be the date that the price list issued will start to be valid Technical Information Dates earlier than 01 January 2000 are not permitted Manuale Operativo delle Definizioni V1 1R14 Pagina 35 Metel S r 1 UT LI Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 4 2 6 LAST CHANGE
17. ADDITION DATE Ver 020 from position 49 a 56 Dt M Ver 021 from position 49 a 56 Dt M Description The date is expressed in the YYYYMMDD year month day format The field contains the date of the last change addition for reference to identify the items that have been changed or added to the price list This date is shown on the detail row corresponding to the item that has been changed added Technical Information This field is mandatory If the price list is sent with an effective date of 01 January 2000 the last change date in the header will have the same value as the issue date as will all of the detail dates The date of change of the price list can never be later than the effective date of the Metel price list The date of change always refers to the issue date of the price list Each time a new price list is issued the date of change must be identical to the effective date of the price list Head Detail 20000210 20000101 20000101 20000101 20000210 Example 20000101 20000101 20000210 The only dates allowed are the effective date and the last date of change Values other than these are not allowed Manuale Operativo delle Definizioni V1 1R14 Pagina 36 Metel S r 1 UT LI Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 4 2 7 PRICE LIST DESCRIPTION Ver 020 from position 57 a 86 An 30 M Ver 021 from position 57 a 86 An 30 M
18. Description This field must contain the description of the price list relative to the products contained therein The description can be general or specific ex residential light fixtures etc based on the needs Manuale Operativo delle Definizioni V1 1R14 Pagina 37 Metel S r l UT LI Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 4 2 8 FILLER Ver 020 from position 87 a 125 An 39 M Ver 021 from position 87 a 125 An 39 M Description This field does not contain any information In order to facilitate future extensions with the addition of new fields this field must not be used in any manner Technical Information This field must be filled with spaces Manuale Operativo delle Definizioni V1 1R14 Pagina 38 Metel S r 1 UT LI Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 4 2 9 PRICE LIST STRUCTURE VERSION Ver 020 from position 126 a 128 N 03 M Ver 021 from position 126 a 128 N 03 M Description If the structure is revised a period of transition is inevitable during which price lists on both the old and new structures will coexist Technical Information The version of this structure is 020 thus this field must be Manuale Operativo delle Definizioni V1 1R14 Pagina 39 Metel S r l UT LI Listino Prezzi Metel Barcode Metel Version 020 021 rev 14
19. Field This field must contain the value METEL BARCODE The field must be left aligned and small letters are not allowed example B JIA IR IC JO JD JE M IE JT JE L Each cell corresponds to one character Manuale Operativo delle Definizioni V1 1R14 Pagina 73 Metel S r l ESTE L Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 5 2 Structure of the Lines Barcode Version 020 and 021 Ver 020 Seq Field Description Start of Mandatory Field Type and Field M Length Position Optional O 1 Company Item Number 1 M An 16 2 EAN 13 Code 17 M N 13 3 Barcode Qualifier 30 O An 01 4 Package Barcode 31 M An 14 5 Unit of Measure 45 M An 03 6 Package Quantity 48 M N7 2 7 Reciprocal 55 M NI 8 Maximum dimension base diameter 56 M N 5 3 9 Minimum dimensions base 61 M N 5 3 10 Maximum height dimension 66 M N 5 3 11 Can be overturned 71 O NI 12 Gross Weight 712 M N 8 3 13 Date Introduced 80 O Dt 14 Date of last change addition 88 M Dt 15 Net product weight 96 O N5 3 16 Package Type 101 M An 3 17 Conventional copper weight 104 O N8 4 18 Weight Unit of Measurement 112 O An 19 Intrastat Code 113 O An 8 20 Filler 121 M An 8 Record length 128 bytes CR LF Manuale Operativo delle Definizioni V1 1R14 Pagina 74 M
20. Information in the Price List Barcode The structure of the price list in terms of the whole structure of the price list and barcode contains three different types of information Details on parties Commercial Logistical For each type of information following tables include the Definitions Principles used Manuale Operativo delle Definizioni V1 1R14 Pagina 100 Metel S r 1 ESTE L Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 5 5 1 Details on parties Company ID Price header Company Number EAN 13 code Price list line Barcode Barcode Qualifier E Item Price list line Barcode Composite Product Price list line Product status Price list line Manuale Operativo delle Definizioni V1 1R14 list Using a 3 character code it identifies the seller to which the price list refers Using a series of letters and numbers it identifies a product Using a sequence of numbers it identifies the item number Identifies the type of barcode used EAN 13 ITF 14 or DUN 14 for the different types of packaging of the product Describes the product to which the code refers Indicates if the company item number identifies a single product or a set of different products This field contains qualitative information on the mode for handling item number Pagina 101 Allows price lists for different suppliers to
21. Lilangeni TOP Palanga TTD Trinidad amp Tobago UGS Uganda Shilling VEB Bolivar WST Tala XOF CFA Franc BCEAO YER Yemeni Rial ZMK Kwacha Metel S r l UT LI Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 4 3 14 UNIT OF MEASURE Ver 020 from position 129 to 131 An 03 M Ver 021 from position 129 to 131 An 03 M Description This field contains the unit of measure that all the quantities are expressed in PCE Piece BLI Blister BRD Carton KGM Kilograms LE Litres LM Lineal meters PL Pallet Technical Information The character codes must be left aligned Caution We do not recommend using the units of measure of PL BRD or BLI in the price list as the Metel Order document does not permit them The Barcode list is the document that will allow you to identify all possible packaging for the products entered in the Metel price list Manuale Operativo delle Definizioni V1 1R14 Pagina 62 Metel S r l UT LI Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 4 3 15 COMPOSITE ITEM Ver 020 from position 132 to 132 N 01 M Ver 021 from position 132 to 132 N 01 M Description This field provides information as to if the product is a kit or a set of a number of elementary items This information has been moved below the product status in order to allow you to provide i
22. Manuale Operativo delle Definizioni V1 1R14 Pagina 55 Metel S r l UT LI Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 4 3 8 MAXIMUM QUANTITY Ver 020 from position 91 to 96 N 06 M Ver 021 from position 91 to 96 N 06 M Description This field must contain the maximum quantity of the product expressed in the UNIT of MEASURE that the company is able to delivery within the time defined in the lead time field This amount defines at the same time the limit above which the reference delivery terms must be agreed to with the seller Technical Information This field is numerical If the data is not available the field must be filled in with the value 999999 Manuale Operativo delle Definizioni V1 1R14 Pagina 56 Metel S r 1 UT LI Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 4 3 9 LEAD TIME Ver 020 from position 97 to 97 An 01 M Ver 021 from position 97 to 97 An 01 M Description This field indicates the time interval lead time expressed in working days between the date of receipt of order and consignment to the carrier for orders that are not greater than the amount listed in the field maximum quantity The field is described using alphanumeric characters The attached table lists the corresponding value of lead time for each value of the field and vice versa Technical In
23. Metel Version 020 021 rev 14 January 2014 on recodification layout addition of field New Brand and changing of record length both in header and detail section from 59 to 62 characters Modification of indications on Product Status in case of item recoding The layout and format described in this manual Rel 1 1 rev 13 February 2012 have changed in comparison to Rel 1 1 rev 12 January 2012 The changes or additions refer to the additional elements that do not prevent compatibility with the previous version With regard to the 021 version of the barcode the changes relate to the length of the PACKAGE BARCODE and the resulting position of the following fields on the detail records as well as the maximum length of the record that change the compatibility with the previous version 020 Specifically on Price List indications updated on Price List Number on Price List addition on Product Status of value 4 new service non physical goods and 5 Deleted service in the Price List addition of sample for ISO VAT NO addition of Barcode version 021 for handling of EAN128 in Package Barcode on Barcode version 021 added value 5 EAN128 for BARCODE QUALIFIER on Barcode version 021 modified Package Barcode from 14 chrs to 35 chrs on Barcode version 021 modified fixed record length from 128 chrs a 149 chrs on Barcode version 021 in the header addition of a terminal field FILLER of 21 chrs to reach
24. Netherlands Antillean Guilder ATS Schilling BBD Barbados Dollar BGL Lev BMD Bermudian Dollar BRC Cruzado B C AD Canadian Dollar CNY Yuan Renminbi CSK Koruna CYP Cyprus Pound DKK Danish Kroner ECS Sucre ETB Fthiopian Birr FJD Fiji Dollar GBP Pound Sterling GMD Dalasi GRD Drachma GYD Guyana Dollar HTG Gourde IEP Irish Pound IQD Iraqi Dinar ITL Italian Lira JPY Yen KMF Comorian Franc KWD Kuwaiti Dinar LBP Lebanese Pound LSM Maloti MAD Morocco Dirham MOP Pataca MUR Mauritius Rupee MXP Mexican Peso NGN Naira NOK Norwegian Kroner OMR Rial Omani PGK Kina PLZ Zloty QAR Qatari Riyal SAR Saudi Riyal SDP Sudanese Pound SHP St Helena Pound SRG Suriname Guilder SVC El Salvador Colon THB Baht TPE Timor Escudo TWD New Taiwan Dollar USD US Dollar VND Dong XAF CFA Franc BEAC XPF CFP Franc YUD New Yugoslavian Dinar ZRZ Zaire Manuale Operativo delle Definizioni V1 1R14 AFA Afghani AOK Kwanza AUD Australian Dollar BDT Taka BHD Bahraini Dinar BND Brunei Dollar BSD Bahamian Dollar BWP Pula CHF Swiss Franc COP Columbian Peso CUP Cuban Peso DEM Deutsche Mark DOP Dominican Peso EGP Egyptian Pound EUR EURO FKP Falkland Islands Pound GHC Cedi GNF Guinean Franc GTQ Quetzal HKD Hong Kong Dollar HUF Forint ILS Shekel IRR Iranian Rial JMD
25. Price List and Barcode Each field defined as mandatory by the Technical Commettee represents a weight value that will compose a calculation Manuale Operativo delle Definizioni V1 1R14 Pagina 117 Metel S r l UT LI Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 Characters Allowed Introduction The MetelDataPool introduces the theme of characters allowed in the roadmap for the exchange of information between companies Scenario It s known that information systems of distributors may have problems in correctly read some special characters The first evaluation was to deal with the EDI system that is homogeneous in nature to the type of data exchanged item description The world EDI Metel uses the alphabet Edifact UNOB ABCDEFGHIJKLMNOPQRSTUVWXY Zabcdefghijklmnopqrstuvwxyz0123456789 Q amp lt gt AOCUIC 1 This alphabet excludes certain special characters and is very limited The choice made is based on the encoding used for writing ISO 8859 15 Characters allowed The MetelDataPool allows the use of the characters of ISO 8859 15 This will also be utilized for the proper generation of the input file Special Characters iso8859 15 Latin 9 see ISO 8859 15 Latin Alphabet 9 Characters NOT allowed Any other character not surveyed in this list will be converted into space as are the 3 dots used by Windows FLAT GENERATED FROM Mete
26. Where n is a whole number 0 1 2 3 etc 1 2 MINIMUM ORDER QUANTITY Description The minimum order quantity is the minimum quantity expressed in the unit of measurement which the company will accept to process an order The unit of measurement piece blister etc to be used for the calculation of the quantity is listed in the UNIT OF MEASUREMENT field The minimum order quantity usually equals a physical packaging unit even if not necessarily with the minimum package even a single physical piece can be ordered where the seller will allow partial packages 1 3 WHOLESALE PRICE 1 4 RETAIL PRICE Description These fields contain the seller s base price to the wholesaler to which discounts are then applied and the retail price can be listed if desired As defined by market agreements they differ basically due to the value of the copper incidence depending on the receivers Discounts are never included in the prices The procedures for filling in the price depends on the receiver of the price list which is demonstrated in the following table Situation Wholesale Price on the Price List Retail Price on the Price List A Retail price identical to wholesale Mandatory Mandatory price sent to retailer and wholesaler B Retail price different from Fill the price with zeros Mandatory wholesale price and price list sent to retailer C Retail price different from Mandatory Mandatory wholesale price and price li
27. field nine characters long and we had to fill it with the string 852 we would have 0 0 0 0 0 0 8 5 2 Each cell corresponds to one byte The definition of the field is N 09 N 99 9 Numbers with Decimals alphabetic characters are not allowed The field must be right aligned The string 99 is the number of the whole numbers plus the decimals that corresponds to the length of the field The decimal point is used to separate the length of the decimal number numerical field The non significant bytes must be filled with zeros The separation of decimals and whole numbers is expressed implicitly In other words the decimal point DOES NOT need to be represented Example If we had a whole number field nine characters long and we had to fill it with the string 852 67 we would have 0 0 0 0 8 5 2 6 7 Each cell corresponds to one byte The definition of the field is N 09 2 The length is 9 bytes of which two 2 are decimal places Dt Date Format the length of this field is always 8 bytes and alphabetical characters are not allowed By definition the date format is always ordered from left to right Year Year Month Day Each data listed must be contained in two bytes The non significant bytes must be filled with Zeros Example If we have a date field and we must fill it with the date 28 February 2001 we have 2 0 0 1 0 2 2 8
28. for tax reasons and for statistics When the operations are summarized only for tax reason the weight field is not required For more information please refer to pages 26 29 32 33 37 46 47 49 II and V of the Official Gazette No 261 dated 8 11 2000 annex 7 section 1 27 October 2000 The net product weight is the mass in kilograms without packaging This field contains the weight in kilograms for the single product identified in the field company item number For cables this field indicates the net weight of a cable in kilograms per linear meters Technical Information This field has three decimal places and is expressed in kilograms If the seller is not able to provide this information the field must be filled with zeros 0 232 kilograms gt 0 0 2 3 2 0 1 5 0 0 gt 1 5 kilograms Manuale Operativo delle Definizioni V1 1R14 Pagina 91 Metel S r l ESTE L Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 5 2 16 PACKAGE TYPE IMBALLO Ver 020 from position 101 to 103 An 3 M Ver 021 from position 144 to 146 An 3 M Description This field indicates the type of packaging associated with the EAN code specified in the field Package EAN code If the seller is not able to provide this information the field must be filled with spaces Only in case of bulk is allowed using code NE Technical Information Following is a table of the abbreviations p
29. length 94 bytes followed by Carriage Return and Line Feed The Structure ID field must include the value FAMIGLIE DI SCONTO left aligned and filled with spaces Only capital letters are accepted Example F JIA M I G IL I JE D II S C JO IN IT O Each cell corresponds to one character The Version field must include the value 020 and spaces are not accepted Example 0 2 0 Each cell corresponds to one character The filler field must only contain spaces Manuale Operativo delle Definizioni V1 1R14 Pagina 26 Metel S r l ESTE L Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 Record Structure Discount Range Metel Lines Seq Description Mandatory M Start of Field Field Type and i Optional O Position Length 1 Company ID M 1 An 3 2 Brand ID M 4 An 3 3 Discount Range M 7 An 18 4 Range Description M 25 An 70 Record length 94 bytes followed by Carriage Return and Line Feed Record Structure Statistics Range Metel Header Seq Description Mandatory M Start of Field Field Type and Optional O Position Length 1 Structure ID M 1 A 20 2 Version M 21 N3 3 Filler M 24 An 71 Record length 94 bytes followed by Carriage Return and Line Feed The Structure ID field must include the value FAMIGLIE STATISTIC
30. list on diskette CD or by E mail The Barcode structure on diskette CD or by E mail Additionally for any recodified item numbers or if a descriptive table of the discount statistics range is sent the sender must send an electronic file on floppy CD or by E mail following the same rules In order to minimize copy costs the sender can use commercially available file compression programs to reduce the size of the files The Metel portal is available as a parallel tool for distribution as an alternative to all of the other tools the sender may wish to make available to the receivers File Names CAUTION The nomenclature for the files is MANDATORY and must be the following Company ID 3 char 3 char CURRENCY if not with a TXT extension LSP retail price list LSG wholesale price list FST Statistics Range FSC Discount Range RIC Recodification BAR Barcode Manuale Operativo delle Definizioni V1 1R14 Pagina 20 Metel S r 1 Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 Example If Metel was a company with the ID MET METLSP TXT is the EURO retail price list METLSG TXT is the wholesale price list METFST TXT is the statistics range file METFSC TXT is the discount range file METRIC TXT is the file for recodified items METBAR TXT is the Metel Barcode file Uniqueness of the Metel Price List Layout UT LI Metel does not reco
31. not binding for management of the seller s packages but it can represent a service level for the retailer It is due to its dynamics that the Barcode list must be updated separately from the Metel price list Should the parties find the logistic code useful in managing orders it can be specified in each line detail of the order in the notes section In particular for the Flat File Type of Record M IRB operative detail notes for each individual line PART PARTNER code Generated by the application RB1004A Anl6 Number of the document N6 i RB1082A _Rownumbr N6 Number of the row in the order n3 Logistic Code In particular for the EDIFACT File SG25 M200000 LIN PIA IMD QTY DTM FTX SG28 SG29 SG30 SG33 SG34 SG35 SG39 SG45 FTX O99 OPERATIVE NOTES FOR LINE ITEMS Function Use to provide notes for handling the order Segment No 48 NIT 4451 Text object qualifier KG notes for handling packaging Purpose of codified text Text References Free notes codified Code List Qualifier Company responsible for codes Note Text Note No 1 Note No 2 Note No 3 Note No 4 Note No 5 Language codified Logistic Code DOC OOS SOC aU fe Zooocoogazzaaz Manuale Operativo delle Definizioni V1 1R14 Pagina 80 Metel S r l UT LI Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 5 2 5 UNIT OF MEASURE Ver 020 from position 45 to 47 An 03 M Ver
32. per linear meters Manuale Operativo delle Definizioni V1 1R14 Pagina 109 Metel S r 1 UT LI Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 2 3 PACKAGE TYPE Description This field indicates the type of packaging associated with the EAN code specified in the field Package EAN code Technical References A summary of the abbreviations enabled for cables is shown below BOB Spool BX Drum CT Box or Carton MAT Coil 2 4 CONVENTIONAL COPPER WEIGHT Description The field indicates the quantity of copper present in the product expressed in kilograms kilometre The value is mandatory for all manufacturers who use the copper adjustment in the order cycle and must be that reported in the AICE code published on the website Manuale Operativo delle Definizioni V1 1R14 Pagina 110 Metel S r l ESTE L Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 Treatment specifications for Cable Sector on Metel price list bill of materials order confirmation and despatch note FLATFILE PRICE LIST For a correct application management of all the documents from the order to the invoice it is opportune that each enters the code of the spools based on their diameter in the Metel price list Metel will be able to combine a table in the cable technical designation system with the code of the spool types identified to date BILL OF MAT
33. position 129 to 131 An 03 M Ver 021 from position 129 to 131 An 03 M 4 3 15 COMPOSITE ITEM Ver 020 from position 132 to 132 N 01 M Ver 021 from position 132 to 132 N 01 M 4 3 16 PRODUCT STATUS Ver 020 from position 133 to 133 An 01 M Ver 021 from position 133 to 133 An 01 M 4 3 17 LAST CHANGE ADDITION DATE Ver 020 from position 134 to 141 Dt M Ver 021 from position 134 to 141 Dt M 4 3 18 DISCOUNT RANGE Ver 020 from position 142 to 159 An 18 O Ver 021 from position 142 to 159 An 18 O 4 3 19 STATISTICS RANGE Ver 020 from position 160 to 177 An 18 O Ver 021 from position 160 to 177 An 18 O 4 3 20 CODICE ELECTROCOD Ver 021 from position 178 to 197 An 20 M Manuale Operativo delle Definizioni V1 1R14 Pagina 3 UST LI Metel S r 1 Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 4 3 21 CODICE BARCODE Ver 021 from position 198 to 232 An 35 O 4 3 22 BARCODE QUALIFIER Ver 021 from position 233 to 233 An 1 O 5 BARCODE 5 1 Structure of the Header Version 020 and 021 5 2 Structure of the Lines Barcode Version 020 and 021 5 2 1 COMPANY ITEM NUMBER ver 020 from position 1 to 16 An 16 M ver 021 from position 1 to 16 An 16 M 5 2 2 EAN CODE BARCODE Ver 020 from position 17 to 29 N 13 M Ver 021 from positio
34. the Italian seller is the responsible party for the lack of debit for this duty For this reason it is necessary to identify the definitive European Community ID code in the Metel price list The ISO VAT Number contains two pieces of information the ISO code and the national VAT number Sample In case of a Metel User with a location in other European Community member countries withot any office in Italy Metel Price List is referred to the main office that sends all the documents invoic included If the VAT Code Italian format is not compatible with the Field VAT No of Price List Header is mandatory to fill in the ISO VAT NO and insert a recognazible value in VAT No Italian format that allows to understand that the ISO VAT NO contains the element to consider for each administrative operation For this reason we council to fill VAT No Italian format with 9999999999999 to respect the situation just described ISO code As one of the largest problems faced by workers in the European Community as has been seen is that of getting the VAT number of their customers and foreign suppliers we consider it suitable to provide a table of the ISO codes according to the Italian Ministerial Decree of 15 April 2004 ISO Codes of European Community Member Countries Number of Characters of VAT Numbers AT Austria 9 LT Lithuania 9 or 12 BE Belgium 9 LU Luxemburg 8 CY Cyprus 9 LV Latvia 9 or 11 CZ Czech Republic 8 or 9 10 MT Malta 8 DE G
35. the fixed lenght of 149 chrs as in the detail section Addition of annex B on Completeness Index The layout and format described in this manual Rel 1 1 rev 12 January 2012 have changed in comparison to Rel 1 1 rev 11 November 2011 The changes or additions refer to the additional elements that do not prevent compatibility with the previous version Specifically on Price List addition on Product Status of value 8 non physical goods services in the Barcode modified usages on samples for Unit of Measure and Reciprocal fields in the Barcode modified notes on Gross Weight in the Barcode on Package type updated usage for value NE no package and addition of value RL PVC Reel Manuale Operativo delle Definizioni V1 1R14 Pagina 8 Metel S r l UT LI The layout and format described in this manual Rel 1 1 rev 11 November 2011 have changed in comparison to Rel 1 1 rev 10 March 2011 The changes or additions refer to the additional elements that do not prevent compatibility with the previous version Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 Specifically In Treatment specifications for Cable Sector addition of information for Bill of Materials in the Barcode layout the Package Type Field have been made mandatory in the Barcode layout values and samples for Reciprocal field have been modified The layout and format described in this manual
36. to the additional elements that do not prevent compatibility with the previous version Clarification about the significance of the fields has been added Specifically Detailed information has been added for managing the item recodification section Detailed information has been added regarding the format of the characters for the item number field in the price list The VAT number field has been made alphanumerical instead of numerical The field for ISO VAT No has been added to the price list header The structure and format described in this manual Rel 1 1 rev 4 April 2006 have not changed in comparison to Rel 1 1 rev 3 January 2005 The changes or additions refer to the additional elements that do not prevent compatibility with the previous version Clarifications have been added for the significance of the fields Specifically The effective date of the wholesale price list Clarification was added regarding the uniqueness of the price list structure in the Price List Sending paragraph Clarification was added regarding the Barcode structure when the package information changes Clarification was added regarding the effective date of the lines in the Barcode structure Manuale Operativo delle Definizioni V1 1R14 Pagina 10 Metel S r l UT LI The structure for WEEE and ROHS handling was added This document is independent from the price list manual and has only been issued to Metel S r l s
37. 0 coils 1000 meters Unit normally handled in processing in the warehouse Single coil Minimum order quantity Single coil Unit of measure Coil Carton quantity 10 Fifth Case Hose 100 mm master of 10 coils 1000 meters Unit normally handled in processing in the warehouse 100 meters Minimum order quantity 100 meters Unit of measure Meters Carton quantity 1000 meters Technical Information This field is numerical it is right aligned and must be filled with zeros Manuale Operativo delle Definizioni V1 1R14 Pagina 52 Metel S r 1 UT LI Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 4 3 6 MULTIPLE ORDER QUANTITY Ver 020 from position 81 to 85 N 05 M Ver 021 from position 81 to 85 N 05 M Description This field must contain the multiple order quantity expressed in the unit of measure piece blister etc that the company will accept to process an order Together with the Minimum Order Quantity field this is the basis for calculation of the order quantity In particular Order Quantity minimum order quantity n multiple order quantity Where n is a whole number 0 1 2 3 etc Technical Information This field is numerical It must be right aligned and it can only contain numbers Correct Incorrect Spaces are not allowed Manuale Operativo delle Definizioni V1 1R14 Pagina 53 Metel S r 1 UT L
38. 021 from position 88 to 90 An 03 M This field contains The unit of measure listed on the price list row in all cases in which the package described in the individual line of the barcode structure is an order of magnitude greater than the type of packaging that the line on the price list refers to Otherwise the unit of measure an order of magnitude less Taken as reference the Carton Quantity on Price List is possible to attribute the unit of measure of packaging Example Price list Unit of measure PCE unit of reference for price EAN 13 EAN code for the item Carton Quantity 240 normally handled for shipment by the seller Barcode structure Ist line package of 10 pieces EAN 13 EAN code for the item refers to price list Package barcode EAN code of the package of 10 pieces Package quantity 10 Unit of Measure PCE as per the price list Reciprocal 1 package quantity less than carton quantity Package Type BX carton 2nd line package of 240 pieces EAN 13 EAN code for the item refers to price list Package barcode EAN code of the package of 240 pieces Package quantity 240 Unit of Measure PCE as per the price list Reciprocal 0 package quantity equal to carton quantity Package Type BX carton 3rd line package of 500 pieces EAN 13 EAN code for the item refers to price list Package barcode EAN code of the package of 500 p
39. 021 rev 14 January 2014 4 2 Structure of the Price List Header ver 020 and ver 021 Ver 020 Seq Description Start of Field Mandatory M Field Type and Position Optional O Length 1 Structure ID 1 M A 20 2 _ Company ID 21 M An 03 3 VAT No 24 M An 11 4 Price list number 35 O An 06 5 _ Price list effective date 41 M Dt 6 Date of last change addition 49 M Dt 7 Price list description 57 M An 30 8 Filler spaces 87 M An 39 9 Price list structure version 126 M N 03 10 Wholesale price list effective date 129 C Dt 11 ISO VAT NO 137 C An 16 12 Filler spaces 153 M An 25 Record length 177 bytes followed by Carriage Return and Line Feed The length of the header record must be identical to that of the detail line It is important once the file has been generated that the spaces included in position 153 to 177 are effectively there Ver 021 Seq Description Start of Field Mandatory M Field Type and Position Optional O Length 1 Structure ID 1 M A 20 2 _ Company ID 21 M An 03 3 VAT No 24 M An 11 4 Price list number 35 O An 06 5 Price list effective date 41 M Dt 6 Date of last change addition 49 M Dt 7 _ Price list description 57 M An 30 8 Filler spaces 87 M An 39 9 Price list structure version 126 M N 03 10 Wholesale price list effective date 129 C Dt 11 ISO VAT NO 137 C An 1
40. 1 from position 131 to 138 Dt O 5 2 15 NET PRODUCT WEIGHT Ver 020 from position 96 to 100 N 5 3 O Ver 021 from position 139 to 143 N 5 3 O 5 2 16 PACKAGE TYPE IMBALLO Ver 020 from position 101 to 103 An 3 M Ver 021 from position 144 to 146 An3 M 5 2 17 CONVENTIONAL COPPER WEIGHT Manuale Operativo delle Definizioni V1 1R14 Pagina 4 UST LI Metel S r 1 ESTE L Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 Ver 020 from position 104 to 111 N 8 4 C 93 Ver 021 from position 147 to 154 N 8 4 C 93 5 2 18 WEIGHT UNIT OF MEASUREMENT 94 Ver 020 from position 112 to 112 An 1 C 94 Ver 021 from position 155 to 155 An 1 C 94 5 2 19 INTRASTAT CODE 95 Ver 020 from position 113 to 120 An 8 C 95 Ver 021 from position 156 to 163 An 8 C 95 5 2 20 FILLER 96 Ver 020 from position 121 to 128 AN 8 O 96 Ver 021 from position 164 to 171 AN 8 O 96 5 3 Note on how to connect the Price List to the Barcode 97 5 4 Note on the Barcode Type 98 5 5 Overall Table of Information in the Price List Barcode 100 5 5 1 Details on parties 101 5 5 2 Commercial Information 102 5 5 3 Logistical Information 103 ANNEX A 106 MANDATORY METEL PRICE LIST FIELDS FOR THE PURPOSES OF ASSOCIATION WITH THE TECHNICAL DESIGNATION 107 Introduction 107 1 METEL PRICE LIST FIELDS 108 1 1 MULTIPLE ORDER QUANT
41. 20 021 rev 14 January 2014 5 2 18 WEIGHT UNIT OF MEASUREMENT Ver 020 from position 112 to 112 An1 C Ver 021 from position 155 to 155 An 1 C Description The field indicates the unit of measurement of weights both gross and net when it is necessary to provide a value greater than 99 999 Kg The field is optional and should be left blank of a reference in m kg is maintained otherwise for greater values use a value with Q Quintal Manuale Operativo delle Definizioni V1 1R14 Pagina 94 Metel S r l UT LI Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 5 2 19 INTRASTAT CODE Ver 020 from position 113 to 120 An 8 C Ver 021 from position 156 to 163 An 8 C Description The code contains the Intrastat code linked to the Net Weight of product assigned by the foreign country in case of selling between intra communitary exchange of goods The field is optional and is recomended its filling in case of Intrastat fluxes Manuale Operativo delle Definizioni V1 1R14 Pagina 95 Metel S r l UT LI Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 5 2 20 FILLER Ver 020 from position 121 to 128 AN 8 O Ver 021 from position 164 to 171 AN 8 O Description This field does not contain any information In order to facilitate future extensions with the addition of new fields this
42. 3 6063 6060 Y R 1153 1154 1153 1154 6411 6064 1 Al SA 21 2000 LM 2000 ON 138 11 LI 26 SGP QT QTY 8260 Y 6060 6063 BOB 52 500 1 BOB 52 498 1 BOB 52 1002 1 Manuale Operativo delle Definizioni V1 1R14 Pagina 116 Metel S r l m chee Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 ANNEX B Metel Completeness Index Metel iC INTRODUCTION The Metel Completeness Index provide a correct and accurate of the real completeness of data for each single item given by Manufacturer CALCULATION OF COMPLETENESS INDEX The calculation is thought on 3 levels of projection 1 ABSOLUTE DATUM price list 2 DISTRIBUTED DATUM on each layout 3 MAXIMUM DETAIL on barcode package LEVEL 1 absolut datum on completeness index It gives an absolut datum referred to the presence or not of the different layouts defined by Technical Committee LEVEL 2 datum distributed on single layout It includes the Level 1 and the correspondence between articles code that are on Metel Price List and the other Layouts of the first level The article with more than one barcode package acquires the completeness of Barcode layout based on the weighted average of barcodes packages inserted on layout LEVEL 3 completeness detail based on fields of Price List and Barcode layouts It is based on the article present on
43. 5 a 40 An 6 O Description This field must contain the price list ID alphanumerical for modifications and new releases In a new way of exchange and traceability of data the price list number must allow easy reconciliation with the previously issued so it is advisable to define a unique value that does not vary over time Will be the starting dates and the change to determine the temporal scope of validity There are two scenarios Manufacturer issuing a single list containing products with one or more brands To ensure reconciliation with the previous prist list in this case it is advisable to define a unique value that does not vary over time regardless of the number list that can be empty Manufacturer issuing multiple lists for different brand or product line In order to reconcile the previous it is advisable have a price list number unique for each price list and unchanged over time In case of operational requirements the number may vary but only at the change of effective date the number list must remain the same in the variations of the same effective date Unique Price List Number that doesn t vary over time AZIENDA NUMERO DT DEC DT VAR METEL MET 20130101 20130101 METEL MET 20130101 20130415 METEL MET 20130701 20130701 METEL MMT 20130101 20130101 METEL MMT 20130101 20130415 METEL MMT 20130701 20130701 Manuale Operativo delle Definizioni V1 1R14 Pagina
44. 6 12 Filler spaces 153 M An 81 Record length 233 bytes followed by Carriage Return and Line Feed The length of the header record must be identical to that of the detail line It is important once the file has been generated that the spaces included in position 153 to 233 are effectively there Manuale Operativo delle Definizioni V1 1R14 Pagina 29 Metel S r l ESTE L Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 4 2 1 STRUCTURE IDENTIFICATION Ver 020 from position 1 a 20 A 20 M Ver 021 from position 1 a 20 A 20 M Description This field must contain the value LISTINO METEL The field must be left aligned and small letters are not allowed For example L I S JT JI N O M IE JT E L Each cell corresponds to one character Manuale Operativo delle Definizioni V1 1R14 Pagina 30 Metel S r 1 ESTE L Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 4 2 2 COMPANY ID Ver 020 from position 21 a 23 An 03 M Ver 021 from position 21 a 23 An 03 M Description This field must contain the three characters of the company s ID code For reasons of uniqueness each Company ID must correspond to one and only one company identified by the VAT No The codes may only be assigned by the sole organisation responsible for this
45. D Ver 020 from position 71 to 71 N1 0O Ver 021 from position 114 to 114 N1 0 Description This field can have one of two values 1 YES 0 NO The information effectively related more to the type of product than to the type of packaging indicates to whoever receives the goods if it is possible to overturn the package or not When the products are cables as the coils are transported and handled with pallets and therefore cannot be overturned it is determined that 0 is equivalent to coils and 1 to spools Manuale Operativo delle Definizioni V1 1R14 Pagina 87 Metel S r l UT LI Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 5 2 12 GROSS WEIGHT Ver 020 from position 72 to 79 N 8 3 M Ver 021 from position 115 to 122 N 8 3 M Description This field contains the value of the gross weight expressed in kilograms of the package full of the product It is mandatory for companies who are registered with INDICOD to enter the gross weight or if they are not equipped to do so to provide information as to when they will insert it If the seller is not able to provide this information the field must be filled with zeros Manuale Operativo delle Definizioni V1 1R14 Pagina 88 Metel S r l UT LI Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 5 2 13 DATE INTRODUCED Ver 020 from position 80 to 87 Dt
46. DE Ver 021 from position 198 to 232 An 33 O Description This field contains the Barcode whose type is defined in the field BARCODE QUALIFIER Technical Information This field is filled in alternatively to EAN CODE only if the EAN13 CODE is not available This field is optional and alphanumerical and it can be decoded through the following field BARCODE QUALIFIER Manuale Operativo delle Definizioni V1 1R14 Pagina 68 Metel S r 1 UT LI Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 4 3 22 BARCODE QUALIFIER Ver 021 from position 233 to 233 An1 O Description This field allows the correct interpretation of the previous BARCODE code field and must be filled in only in its presence It s possible to use the following values 2 ITF 14 a DUN 14 S EAN 128 Technical Information This field alphanumerical This field can only be filled in in presence of BARCODE field Manuale Operativo delle Definizioni V1 1R14 Pagina 69 Metel S r 1 UT LI Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 5 Barcode The Barcode structure given its dynamics changes in packaging and the configurations is independent from the Metel price list structure prices It is necessary to update and send Metel the Barcode list with the changes in the physical characteristics of the item for each change in the items
47. ERIALS Used in the cable sector the structure of the document can be used to associate the cable parent line to the spool child line whose codes have already been supplied through the Metel Price List ORDER AND CONFIRMATION For the cable sector the item number will be able to be connected to the technical destination code which will have a value assigned in the field RA7008A item not present on metel price list If the Bill of Materials is not managed which automatically associates the cable to a spool type in the Cable sector order it is possible to specify for each line of ordered item also an order line for the spool on which you want to receive the cable via the parent and child technique described below Manuale Operativo delle Definizioni V1 1R14 Pagina 111 Metel S r 1 ESTE L Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 Example ordering 2000 metres of cable with number Al and order number 11 120 accompanied by the technical designation which identifies the spool package of 1000 metres the following will occur item number Al Order parent linel quantity 2000 child line2 spool code 6 quantity 2 1004A 1082A_ 7140B 7140C 6060A 6411A 1082B Parent 11 120 000001 Al BRAND 2000 LM 000001 RA CODE Child 11 120 000002 SPOOL A6 BRAND 2 PCE 000001 RA CODE The manufacturer can confirm the item number and relativ
48. HE left aligned and filled with spaces Only capital letters are accepted Example F IA M I G IL I JE S T JA T JI S IT JI JC JH JE Each cell corresponds to one character The Version field must include the value 020 and spaces are not accepted Example 0 2 0 Each cell corresponds to one character The filler field must only contain spaces Manuale Operativo delle Definizioni V1 1R14 Pagina 27 Metel S r l ESTE L Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 Record Structure Statistics Range Metel Lines Seq Description pere a ss ae a E and 1 Company ID M 1 An 3 2 Brand ID M 4 An 3 3 Statistics Range M 7 An 18 4 Range Description M 25 An 70 Record length 94 bytes followed by Carriage Return and Line Feed In reference to the Discount Range the companies using more traditional sales channels provide the key for calculating the value of the discounts starting from this information In the formulation of both sets discount and statistics there are no restrictions for the sender only that of the space available in the fields in the codification of the different groups of products Manuale Operativo delle Definizioni V1 1R14 Pagina 28 Metel S r 1 ESTE L Listino Prezzi Metel Barcode Metel Version 020
49. I Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 Examples Case a By the package purchase for ex packages of 10 pieces without further restrictions Minimum order quantity package Unit of Measure Piece MINIMUM ORDER QUANTITY 10 MULTIPLE ORDER QUANTITY 10 The acceptable values for order are 10 20 etc pieces Case b By the Package purchase ex 10 pieces with minimum order quantity equal to the carton for ex 100 pieces Unit of Measure Piece MINIMUM ORDER QUANTITY 100 MULTIPLE ORDER QUANTITY 10 The acceptable values for order are 100 110 120 Case c By the Carton purchase for example 100 pieces without other restrictions minimum order quantity carton Unit of Measure Piece MINIMUM ORDER QUANTITY 100 MULTIPLE ORDER QUANTITY 100 The acceptable values for order are 100 200 Cased To order purchase with a restriction on the minimum order quantity for ex 1 000 pieces Unit of Measure Piece MINIMUM ORDER QUANTITY 1000 MULTIPLE ORDER QUANTITY 1 The acceptable values for order are 1000 1001 1002 Case e To order purchase without other restrictions Unit of Measure Piece MINIMUM ORDER QUANTITY 1 MULTIPLE ORDER QUANTITY 1 The acceptable values for order are 1 2 3 Manuale Operativo delle Definizioni V1 1R14 Pagina 54 Metel S r 1 UT LI Listino Prezzi M
50. ITY 108 1 2 MINIMUM ORDER QUANTITY 108 1 3 WHOLESALE PRICE 108 1 4 RETAIL PRICE 108 2 BARCODE LAYOUT FIELDS 109 2 1 PACKAGE QUANTITY 109 2 2 NET PRODUCT WEIGHT 109 2 3 PACKAGE TYPE 110 2 4 CONVENTIONAL COPPER WEIGHT 110 TREATMENT SPECIFICATIONS FOR CABLE SECTOR ON METEL PRICE LIST BILL OF MATERIALS ORDER CONFIRMATION AND DESPATCH NOTE 111 FLATFILE 111 EDIFACT 114 Manuale Operativo delle Definizioni V1 1R14 Pagina 5 Metel S r l Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 ANNEX B Metel Completeness Index Metel iC Characters Allowed 1 THANKS UT LI We must thank the people who at different times from 1999 onwards have been part of the Technical Committee Organization a working group that has achieved the goal to refine and complete with the arguments that the third millennium offers us the work previously played with the project logistics Andreella Anna Maria Brenna Tina Centemeri Ercole Cottica Daniela Cairati Massimo Cirillo Andrea Dottini Emauele Ghinzani Gianluigi Gariazzo Paolo Invernizzi Paolo Lanfranchi Daniele Leidi Marco Molta Stefano Matteuzzi Claudio Meneghin Gianni Murgia Concetta Nodari Paolo Panzeri Ivana Rabinelli Paolo Redaelli Angelo Sturla Fausto Villa Andrea Viscardi Enrico Verzaro Dario Manuale Operativo delle Definizioni V1 1R14 Metel S r l General Manager Giorgio Casanova Metel S r 1 117 117 118
51. N 11 M 4 2 4 PRICE LIST NUMBER Ver 020 from position 35 a 40 An6 O Ver 021 from position 35 a 40 An6 O 4 2 5 PRICE LIST EFFECTIVE DATE Ver 020 from position 41 a 48 Dt M Ver 021 from position 41 a 48 Dt M 4 2 6 LAST CHANGE ADDITION DATE Ver 020 from position 49 a 56 Dt M Ver 021 from position 49 a 56 Dt M 4 2 7 PRICE LIST DESCRIPTION Ver 020 from position 57 a 86 An 30 M Ver 021 from position 57 a 86 An 30 M 4 2 8 FILLER Ver 020 from position 87 a 125 An 39 M Ver 021 from position 87 a 125 An 39 M 4 2 9 PRICE LIST STRUCTURE VERSION Ver 020 from position 126 a 128 N 03 M Ver 021 from position 126 a 128 N 03 M 4 2 10 WHOLESALE PRICE LIST EFFECTIVE DATE Ver 020 from position 129 a 136 Dt C Ver 021 from position 129 a 136 Dt C 4 2 11 ISO VAT NO Ver 020 from position 137 a 152 An C Ver 021 from position 137 a 152 An C 4 2 12 FILLER Ver 020 from position 153 a 177 An 25 M Ver 021 from position 153 a 233 An 81 M Manuale Operativo delle Definizioni V1 1R14 Pagina 2 UT LI Metel S r 1 Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 4 3 Structure of the Price List Line ver 020 and ver 021 4 3 1 BRAND ID Ver 020 from position to 3 An 03 M Ver 021 from position 1 to 3 An 03 M 4 3 2 COMPANY ITEM NUMBER
52. O Ver 021 from position 123 to 130 Dt O Description Only for new products status 1 on price list line this field indicates the date of first availability The date introduced can be prior to the date of change addition shown in the barcode header Technical Information This field is numerical the date must be expressed in the YYYYMMDD format ex 27 September 1996 19960927 If not available fill with zeros Manuale Operativo delle Definizioni V1 1R14 Pagina 89 Metel S r l UT LI Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 5 2 14 DATE OF LAST CHANGE ADDITION Ver 020 from position 88 to 95 Dt O Ver 021 from position 131 to 138 Dt O See the information regarding the date of last change addition under the price list Manuale Operativo delle Definizioni V1 1R14 Pagina 90 Metel S r 1 ESTE L Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 5 2 15 NET PRODUCT WEIGHT Ver 020 from position 96 to 100 N 5 3 O Ver 021 from position 139 to 143 N 5 3 O Description Taken from the Official Gazette No 261 dated 8 11 2000 The weight mass in kg without packaging is required for Annexes Intra 1 bis and Intra 2 bis It is required when The parties involved present monthly summary lists All columns of the module are mandatory if the operations are summarized
53. T LI Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 5 2 4 PACKAGE BARCODE Ver 020 from position 31 to 44 An 14 M Ver 021 from position 53 to 87 An 35 M Description This field contains the barcode for each product on each package of the product If the LOGISTIC CODE is used we recommend that it be included on the product packaging Example Pallet 80 12345 88888x pcs 4000 aa 4p 80 12345 66666x pcs 200 Package 80 12345 33333x pcs 10 Piece 80 12345 11111x pes 1 Technical Information As the barcode identified in this field can be either EAN 13 or a barcode 14 characters long the length of the field must be 14 When using an EAN 13 code the missing character is to be filled with a space instead of a zero to avoid confusion Same indication is valid for the other kinds of code included EAN 128 valid only for version 21 Therefore the field is considered alphanumeric but it must be right aligned If the LOGISTIC CODE is used this field can be used an alphanumeric field left aligned filling it with spaces to the right Manuale Operativo delle Definizioni V1 1R14 Pagina 79 Metel S r l ESTE L The use of this code must be agreed between the parties and the barcode reading program of the Barcode list recipient must be adapted Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 The use of this code is
54. V1 1R14 Pagina 76 Metel S r 1 UT LI Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 5 2 2 EAN CODE BARCODE Ver 020 from position 17 to 29 N 13 M Ver 021 from position 17 to 51 AN 35 M This field contains the EAN 13 of the item or EAN 128 ITF14 or DUN 14 only if EAN 13 is not available and only on 021 version 021 See the information regarding the EAN 13 code and Barcode under the price list Manuale Operativo delle Definizioni V1 1R14 Pagina 77 Metel S r l UT LI Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 5 2 3 PACKAGE BARCODE QUALIFIER Ver 020 from position 30 to 30 AN 01 O Ver 021 from position 52 to 52 AN 01 O Description As different types of barcodes or proprietary codes can be used on the packages the type must be specified from among the following EAN 13 ITF 14 DUN 14 LOGISTIC CODE WITHOUT BARCODE EAN128 only for version 021 For the definitions of each of these codes please see the last annex on barcodes Below is the key to the classification e I EAN 13 e 2 ITF 14 e 3 DUN 14 e 4 LOGISTIC CODE WITHOUT BARCODE e 5 EAN 128 only for version 021 Technical Information This field is numerical and only values 1 2 3 4 5 only for version 021 are allowed Manuale Operativo delle Definizioni V1 1R14 Pagina 78 Metel S r l U
55. Ver 020 from position 4 to 19 An16 M Ver 021 from position 4 to 19 An16 M 4 3 3 EAN CODE Ver 020 from position 20 to 32 N 13 O Ver 021 from position 20 to 32 N 13 O 4 3 4 PRODUCT DESCRIPTION Ver 020 from position 33 to 75 An 43 M Ver 021 from position 33 to 75 An 43 M 4 3 5 CARTON QUANTITY Ver 020 from position 76 to 80 N 05 M Ver 021 from position 76 to 80 N 05 M 4 3 6 MULTIPLE ORDER QUANTITY Ver 020 from position 81 to 85 N 05 M Ver 021 from position 81 to 85 N 05 M 4 3 7 MINIMUM ORDER QUANTITY Ver 020 from position 86 to 90 N 05 M Ver 021 from position 86 to 90 N 05 M 4 3 8 MAXIMUM QUANTITY Ver 020 from position 91 to 96 N 06 M Ver 021 from position 91 to 96 N 06 M 4 3 9 LEAD TIME Ver 020 from position 97 to 97 An 01 M Ver 021 from position 97 to 97 An 01 M 4 3 10 WHOLESALE PRICE Ver 020 from position 98 to 108 N 11 2 M Ver 021 from position 98 to 108 N 11 2 M 4 3 11 RETAIL PRICE Ver 020 from position 109 to 119 Nn 11 2 M Ver 021 from position 109 to 119 N 11 2 M 4 3 12 PRICE MULTIPLIER Ver 020 from position 120 a 125 N 06 M Ver 021 from position 120 a 125 N 06 M 4 3 13 CURRENCY CODE Ver 020 from position 126 to 128 A 03 M Ver 021 from position 126 to 128 A 03 M 4 3 14 UNIT OF MEASURE Ver 020 from
56. ab issues the supper ID who is then Metel certified in all effects The name of the company will be entered in the list of certified companies for the price list document Metel portal special printout Companies that do not have EDP support benefit from Metel consultancy even on site excluding travel expenses as well as analytical and programming support This allows these companies to reduce their start up times We must emphasize that the sender issuer must provide Metel a copy of each new price list for release using the price list distribution portal Certification is required for every price list new or modified in order to avoid incongruities in the information for the items previously entered Upon certification Metel will provide a PDF file containing the following information Data the price list file was received by Metel Date of certification by Metel S r l Size of the certified file Name of the certified file Price List number Effective date of the price list Date of the last change If this is a new price list the date of change and the effective date are the same Each price list distributed will be accompanied by a copy of its certification Manuale Operativo delle Definizioni V1 1R14 Pagina 17 Metel S r l ESTE L Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 Price List Certification Procedure The sender is registered with
57. ackage Type BX carton 3rd line package of 500 pieces EAN 13 EAN code for the item refers to price list Package barcode EAN code of the package of 500 pieces Package quantity 500 Unit of Measure PCE as per the price list Reciprocal 2 package quantity greater than carton quantity Package Type PL pallet Manuale Operativo delle Definizioni V1 1R14 Pagina 83 Metel S r 1 UT LI Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 5 2 8 MAXIMUM DIMENSIONS BASE DIAMETER Ver 020 from position 56 to 60 N 5 3 M Ver 021 from position 99 to 103 N 5 3 M Description The field indicates the length expressed in meters with three decimal points of the maximum dimension of the base of for cylindrical containers the diameter In other words if the package is a drum or roll this field indicates the diameter If it is a carton the greater of the two lengths of the base must be indicated If the seller is not able to provide this information the field must be filled with zeros Technical Information This field has three decimal places and is expressed in meters 1 5 metres gt 0O 1 50 0 0 1 80 0 gt 1 8 metres Manuale Operativo delle Definizioni V1 1R14 Pagina 84 Metel S r l UT LI Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 5 2 9 MINIMUM DIMENSIONS BASE Ver 020
58. action METEL Any company that needs to give a single price list an ID must contact Metel for its issue No price list in Metel format may be sent prior issue of the ID Metel identifies the release of the company ID with the certification process If the ID that appears on the price list is not listed on the Metel site associated with the company name then the price list has NOT been certified by METEL Technical Information The three characters of the company ID must be written in capital letters and must always be present Example Correct Incorrect X y z All capital letters Manuale Operativo delle Definizioni V1 1R14 Pagina 31 Metel S r l UT LI Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 4 2 3 VAT No Ver 020 from position 24 a 34 N 11 M Ver 021 from position 24 a 34 N 11 M Description This field must contain the VAT number of the company that will issue the invoice There are no particular restrictions for this field except to note that it is the only real identifying field for tax reasons of the company Technical Information The field must NOT contain spaces Manuale Operativo delle Definizioni V1 1R14 Pagina 32 Metel S r l ESTE L Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 4 2 4 PRICE LIST NUMBER Ver 020 from position 35 a 40 An 6 O Ver 021 from position 3
59. ale Operativo delle Definizioni V1 1R14 Pagina 51 Metel S r 1 UT LI Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 4 3 5 CARTON QUANTITY Ver 020 from position 76 to 80 N 05 M Ver 021 from position 76 to 80 N 05 M Description The carton quantity represents the quantity expressed in the unit of measure contained in the package normally handled for shipment by the seller In this sense it is not binding for the buyer when setting up the order Rather it serves as a reference for optimizing management of the entering physical flows evaluation of the convenience of loading bulk pieces or whole packages Examples First Case Light bulbs packaged individually 1 bulb 20 light bulbs per box Unit normally handled Box Minimum order quantity Single light bulb package Unit of measure Piece Carton Quantity 20 Second Case Residential switches packages of 10 switches boxes with 6 packages Unit normally handled in processing in the warehouse Single package Minimum order quantity Even a single switch Unit of measure Piece Carton quantity 10 Third Case Rigid tube 120 meter bundle master of 25 bundles 3000 meters Unit normally handled in processing in the warehouse Single bundle Minimum order quantity Single bundle Unit of measure Bundle Carton quantity 25 Fourth Case Hose 100 mm coils master of 1
60. and subscribes to Metel The sender has received his user ID and password to access the price list distribution portal Generation and upload on Metel certification portal The Metel laboratory receives the price lists verifies the syntax of the document received and checks its correspondence with the previous price list The Metel Laboratory initiates the distribution of the price list to the community The sender s Metel Manager checks the content of the certification checks the prices and packaging The sender s Metel Manager enables receivers to receive the Metel Price List The receivers receive the Metel price list manually or automatically Manuale Operativo delle Definizioni V1 1R14 Pagina 18 Metel S r l UT LI Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 4 1 3 Correspondence of the Computer Based Price List to the Paper Based Price List For each release of a new price list new or change each company must guarantee the correspondence of the format between the computer based price list file and the paper based price list It is understood that the information presented in the computer based price list has the primary scope of supplying the database system with data Any time differences arise between the two versions electronic and paper for example the item number or the content of the individual rows an errata corrige must be sent initially on paper
61. applied It is used for statistics purposes It is used to coordinate the preparation of orders with the date of effective availability for the new product Metel S r l ESTE L Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 5 5 3 Logistical Information Unit of Measure Price list line Barcode Minimum Quantity Order Price list line Multiple Quantity Order Price list line Maximum Quantity Price list line Lead Time Price list line Package quantity Barcode Carton Quantity Price list line Reciprocal Manuale Operativo delle Definizioni V1 1R14 This is the unit of measure for the value listed in the price field This represent the minimum amount of product that can be ordered for purchase expressed in the unit of measure This represents the quantity in multiples that can be purchased by the wholesaler once the minimum order quantity is exceeded This represents the maximum order quantity the seller will commit to within the time defined in the lead time see below This is the response time of the seller starting from receipt of order to delivery to the carrier under the assumption that the quantity ordered is not greater than the maximum quantity This identifies the number of units contained in each type of packaging distributed This identifies the unit of logistic handling for the
62. are numerical and include two decimal places Right aligned No spaces or commas are permitted in the field The price must always refer to the unit of measure expressed in the Metel price list When packages represent a unit of sale should the quantity of product in the package or the unit of measure be varied a new company item number must be generated Items that do NOT have a base price for example items made to order must NOT be included in the Metel price list For those items that benefit from discounts that vary based on the quantity ordered it is only possible to enter the base price in the Metel price list Sales information discounts as a function of the quantities ordered must be communicated separately The procedure for filling in the price depends on the receiver of the price list which is demonstrated in the following table Situation Wholesale Price on the Price Retail Price on the Price List List Retail price identical to wholesale Mandatory Mandatory price sent to retailer and wholesaler Retail price different from wholesale Fill the price with zeros Mandatory price and price list sent to retailer Retail price different from wholesale Mandatory Mandatory price and price list sent to wholesaler Manuale Operativo delle Definizioni V1 1R14 Pagina 58 Metel S r 1 UT LI Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January
63. be distinguished for each other It is the key used to read all other information regarding the product listed in both the price list and other files barcode invoice delivery note etc Allows the retailer to automate Loading in the warehouse z Discharge upon sale The inventory of the item number using a barcode reader Allows the barcode to be recognized Describes the product clearly 3 On delivery notes upon receipt and shipment On quotations prepared by the retailers to their customers On the terminal during searches performed by the retailers employees purchasing sales floor etc Allows the goods to be recognized upon receipt and allows them many items packages to be loaded under a single item number Analysis of the codes included on the price list in terms of handling mode used by the wholesaler and status Metel S r l ESTE L Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 5 5 2 Commercial Information INFORMATION POSITION DEFINITION USE VAT No Price list Identifies the seller for tax header reasons to which the price list refers Price list ID Price list Identifies the year which header the price list is valid and the progressive number it is the first or the fourth price list from 1996 Effective date Price list This is the date that the header price list becomes effective Wholesale pri
64. ce Price list line This is the price for reference for the wholesalers on which they can calculate their purchase discounts Retail price Price list line This is the retail sale price on which customer installer discounts are calculated Discount Range Price list line This identifies the sales range for discount and premiums that the item number belongs to Statistics Range Price list line This identifies the statistic range to which the product belongs Date introduced Barcode lines This is the date a new product was introduced for reference in order preparation Manuale Operativo delle Definizioni V1 1R14 Pagina 102 Evaluation and checking of invoices delivery notes Allows the wholesaler to reconstruct the sequence of the price lists received to perform checks inspections and to replace partially or totally a few items values of the modified fields It is a reference for the wholesaler for updating their price lists It is used by the wholesalers to Totalize purchase orders Check suppliers invoices Check any extra discount conditions applied starting from the base price Check any conditions for the net price It is used by the wholesalers to Totalize purchase orders when wholesale price not available Check sales invoices and supplier invoices if the wholesale price is not available Draft quotations It is used to reconstruct the discount conditions
65. do not prevent compatibility with the previous version Specifically the Conventional copper weight layout has been added after the Barcode layout with relative description and final price calculation method with copper adjustment The remaining filler length has been corrected Manuale Operativo delle Definizioni V1 1R14 Pagina 9 Metel S r l UT LI Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 The layout and format described in this manual Rel 1 1 rev 9 January 2010 have changed in comparison to Rel 1 1 rev 6 March 2008 The changes or additions refer to the additional elements that do not prevent compatibility with the previous version Specifically the PA Package and PK Pack codes have been added to the Type of packaging field of the Barcode layout The structure and format described in this manual Rel 1 1 rev 6 March 2008 have not changed in comparison to Rel 1 1 rev 5 January 2007 The changes or additions refer to the additional elements that do not prevent compatibility with the previous version The Filler fields spaces position in the header has been corrected Recommendations have been added for the characters used for the item number and the product description The structure and format described in this manual Rel 1 1 rev 5 January 2007 have not changed in comparison to Rel 1 1 rev 4 April 2006 The changes or additions refer
66. e spool in the order confirmation Confirmation parent linel item number Al quantity 2000 child line2 spool code 6 quantity 2 1004A 1082A_ 7140B 7140C 6060A 6411A Parent 11 120 000001 Al BRAND 2000 LM RA CODE Child 11 120 000002 SPOOL A6 BRAND 2 PCE RA CODE If the spool is not specified in the order Example ordering 2000 metres of cable with number Al and order number 11 120 the following will occur Order linel item number Al quantity 2000 1004A 1082A_ 7140B 7140C 6060A 6411A 1082B RA 11 120 000001 Al BRAND 2000 LM CODE Confirmation linel item number Al quantity 2000 1004A 1082A 7140B 7140C 6060A 6411A RA 11 120 000001 Al BRAND 2000 LM CODE DESPATCH NOTE For each item line for which a partial or complete delivery is made it is obligatory to indicate the package reference used for each item line in order to connect the purchased cable and packaging spool diameter Example Manuale Operativo delle Definizioni V1 1R14 Pagina 112 Metel S r l m sae In order 138 11 on line 26 item Al qty 2000 metres is ordered It is all delivered with despatch note 14 2011 on 3 spools which contain 500 metres 498 metres and 1002 metres respectively Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 On the Metel despatch note th
67. ed printing specifications regarding the dimensions and succession of the bards The second Interleaved Two of Five is nothing but an EAN 13 that has a 0 added in front 0 XX Y Y Y Y Y Z Z Z Z Z c ITF14 EAN 13 But it does have a significant difference in terms of the printing specification for the bars The bars are thicker and have only two sizes Overall the symbol is larger and is lends itself to being printed and read on cardboard The third Despatch Unit Number is a barcode printed according to ITF specifications in terms of thickness and type of bar In terms of the content it there are two options Manuale Operativo delle Definizioni V1 1R14 Pagina 98 Metel S r l Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 The prefix is a number from 1 to 8 1 8 X X YYY Y Y Z 2 2 2 2 c DUN14 EAN 13 and has a specific meaning defined by the seller For ex carton of 10 packs or produced in the Dutch plant The prefix is 9 9 xXx xX YYYYY Z Z ZZZ c DUN14 ia EAN 13 UT LI The 9 indicates that after the DUN 14 barcode there is another 6 character barcode that indicates the quantity in the unit of measure determined by the seller contained in the package Manuale Operativo delle Definizioni V1 1R14 Pagina 99 Metel S r 1 UT LI Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 5 5 Overall Table of
68. el Manager within the company is not defined by a specific sector or department as the knowledge required is not the sole responsibility of the computer system the administration or the sales department The Metel Manager must be the person who best knows the flow of information within the company and who is responsible for it From a technical point of view the Metel Manager must be in contact with the data processing centre for the reference and technical support required when necessary This person must also be familiar with the operative phases and times that are respected by the other managers who issue and collect the information available in the IT system This knowledge permits the Metel Standard to be implemented in the most correct and least invasive manner within the company 4 1 2 3 METEL PRICE LIST and BARCODE Document Certification Using the portal provided by Metel S r l see the manual Price List Communication the Metel Manager must supply Metel with the Metel price list as described in the User Manual Definitions The Metel lab is responsible for checking the syntax of the information following a specific procedure The lab sends the results of the procedure to the party that issued the price list Manuale Operativo delle Definizioni V1 1R14 Pagina 16 Metel S r 1 UT LI Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 At this point the Metel L
69. ere should be RA 14 2011 Al ordered qty 2000 sent qty 2000 ref Ord 138 11 line 26 RCbob 1 code quantity 500 RCbob 1 code quantity 498 RCbob 1 code quantity 1002 1004A 1082A 7140B 6060 6411 6064 1154A 1154D RA 14 2011 000001 Al 2000 LM 2000 138 11 26 1004A 1082A 8260A 6060 A RC 14 2011 000001 BOB 1 500 RC 14 2011 000001 BOB 1 498 RC 14 2011 000001 BOB 1 1002 Manuale Operativo delle Definizioni V1 1R14 Pagina 113 Metel S r 1 UT LI Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 EDIFACT PRICE LIST For a correct application management of all the documents from the order to the invoice it is opportune that each enters the code of the spools based on their diameter in the Metel price list Metel will be able to combine a table in the cable technical designation system with the code of the spool types identified to date BILL OF MATERIALS Used in the cable sector the structure of the document can be used to associate the cable parent line to the spool child line whose codes have already been supplied through the Metel Price List ORDER AND CONFIRMATION For the cable sector the product number will be able to be connected to the technical designation code which will have a value assigned in sg25IMD 7008 first occurrence with 7077 C If the Bil
70. ermany 9 NL The Netherlands 12 DK Denmark 8 PL Poland 10 EE Estonia 9 PT Portugal 9 EL Greece 9 SE Sweden 12 ES Spain 9 SK Slovak Republic 9 or 10 FI Finland 8 SI Slovenia 8 FR France 11 SM San Marino GB Great Britain 5 or 9 12 CH Switzerland HU Hungary 8 IT Italy 11 IE Ireland 8 Manuale Operativo delle Definizioni V1 1R14 Pagina 41 Metel S r 1 UT LI Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 Thus the header of the price list will include the European VAT number field starting from position 126 to position 141 16 characters alphanumeric left aligned and optional This change has no impact on the programmes functioning now Example I T 1 2 3 4 5 6 7 8 9 0 1 Manuale Operativo delle Definizioni V1 1R14 Pagina 42 Metel S r l UT LI Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 4 2 12 FILLER Ver 020 from position 153 a 177 An 25 M Ver 021 from position 153 a 233 An 81 M Description This field does not contain any information In order to facilitate future extensions with the addition of new fields this field must not be used in any manner These spaces are included in the header in order to reach the same length as the line records Technical Information This field must be filled with spaces Manuale Operativo delle Def
71. ermitted for this field AE Cylinder DJ Unprotected demijohn AST Holder DP Protected demijohn BAS Tub DPE Display stand packaging BE Tape EN Envelope BG _ Bag FP Heat shrink film BME Blister GAB Crates BO _ Bottle HAN Hanging BOB Coil JR Sar BRI Brick MAT Hank BX Box NE No package CA Can rectangular tin PAE Wrapper CBL Small bottle PL Pallet CG _ Metal container PU Tray CON Container PUE Film Tray CR _ Case STL Stick CT Carton TU Tube CX Can cylindrical tin UUE Net PA PacchettoPackage PK Pack RL PVC reel Manuale Operativo delle Definizioni V1 1R14 Pagina 92 Metel S r l UT LI Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 5 2 17 CONVENTIONAL COPPER WEIGHT Ver 020 from position 104 to 111 N 8 4 C Ver 021 from position 147 to 154 N 8 4 C Description The field indicates the quantity of copper present in the product expressed in kilograms kilometer If the seller is not able to provide this information the field must be filled with spaces The value is mandatory for all manufacturers who use the copper adjustment in the order cycle and must be that reported in the AICE code published on the website Manuale Operativo delle Definizioni V1 1R14 Pagina 93 Metel S r 1 UT LI Listino Prezzi Metel Barcode Metel Version 0
72. etel Barcode Metel Version 020 021 rev 14 January 2014 4 3 7 MINIMUM ORDER QUANTITY Ver 020 from position 86 to 90 N 05 M Ver 021 from position 86 to 90 N 05 M Description The minimum order quantity is the minimum quantity expressed in the unit of measure which the company will accept to process an order The unit of measure piece blister etc to be used for the calculation of the quantity is listed in the UNIT OF MEASURE field The minimum order quantity usually equals a physical packaging unit even if not necessarily with the minimum package even a single physical piece can be order where the seller will allow partial packages Examples First Case Residential switches packages in boxes of 10 pieces Unit of measure piece Minimum order quantity 10 The seller allows minimum order quantities of 10 pieces In this case the internal quantity coincides with the minimum packaging and the seller does not allow partial packages Second Case Light bulbs packaged in boxes of 10 blisters Unit of measure blister Minimum order quantity 1 The seller allows minimum order quantities of one blister the number of lamps per blister in this is not determined In this case the seller allows partializing selling even a single blister Technical Information The filed must be right aligned and filled with zeros to the left 0 0 0 0 5 Minimum Order Quantity 5
73. etel S r l ESTE L Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 Ver 021 Seq Field Description Start of Mandatory Field Type and Field M Length Position Optional O 1 Company Item Number 1 M An 16 2 EAN Code Barcode 17 M An 35 3 Package Barcode Qualifier 52 O An 01 4 Package Barcode 53 M An 35 5 Unit of Measure 88 M An 03 6 Package Quantity 91 M N 7 2 7 Reciprocal 98 M NI 8 Maximum dimension base diameter 99 M N 5 3 9 Minimum dimensions base 104 M N 5 3 10 Maximum height dimension 109 M N 5 3 11 Canbeoverturned 114 O NI 12 Gross Weight 115 M N 8 3 13 Date Introduced 123 O Dt 14 Date of last change addition 131 M Dt 15 Net product weight 139 O N 5 3 16 Package Type 144 M An 3 17 Conventional copper weight 147 O N8 4 18 Weight Unit of Measurement 155 O An 1 19 Intrastat Code 156 O An 8 20 Filler 164 M An 8 Record length 171 bytes CR LF Manuale Operativo delle Definizioni V1 1R14 Pagina 75 Metel S r l UT LI Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 5 2 1 COMPANY ITEM NUMBER ver 020 from position 1 to 16 An 16 M ver 021 from position 1 to 16 An 16 M See the information regarding the company item number under the price list Manuale Operativo delle Definizioni
74. field must not be used in any manner Technical Information This field must be filled with spaces Manuale Operativo delle Definizioni V1 1R14 Pagina 96 Metel S r 1 ESTE L Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 5 3 Note on how to connect the Price List to the Barcode PRICE LIST BARCOD PRODUCT 10 Pallet Carton Carton PRODUCT 11 Carton Package Piece PRODUCT 12 Package Carton A product registered on the price list can have numerous packaging line on barcode structure The relation of a line of the price list and one or more lines in the barcode structure can be constructed in two different ways PRICE LIST BARCOD EAN 13 code EAN 13 code Company Item Number Company Item Number Company ID Company ID We recommend using the first method for relation Manuale Operativo delle Definizioni V1 1R14 Pagina 97 Metel S r l UT LI Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 5 4 Note on the Barcode Type Three types of barcode are discussed below EAN 13 ITF 14 DUN 14 The format of the first has 13 characters with the following meaning Assigned by the International Article Number assigned in Italy by Assigned by the manufacturer Control Number xX xX YYYYY Z ZZZZ C COUNTRY MANUFACTURER PRODUCT ID ID ID Italy 80 Including Plant Furthermore it follows defin
75. formation This field is alphanumerical If this data is not available the seller must enter a value in any case that is indicative and absolutely not binding for the seller Only capital letters are allowed To express days it is possible to use numbers from 1 to 9 To identify 2 weeks 10 working days letters of the alphabet are used in increasing order see the table on the last page Examples Code 1 Consignment to carrier within 3 working days from receipt of order Table reference Lead time column 3 days corresponding field value 3 Lead time 3 Code 2 Consignment to carrier within 5 weeks from receipt of order Table reference Lead time column 5 weeks corresponding field value D Lead time D Manuale Operativo delle Definizioni V1 1R14 Pagina 57 Metel S r l UT LI Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 4 3 10 WHOLESALE PRICE Ver 020 from position 98 to 108 N 11 2 M Ver 021 from position 98 to 108 N 11 2 M 4 3 11 RETAIL PRICE Ver 020 from position 109 to 119 Nn 11 2 M Ver 021 from position 109 to 119 N 11 2 M Description These fields contain the seller s base price to the wholesaler to which discounts are then applied and the retail price can be listed if desired Both values refer to the unit of measure and the code expressed in the previous fields Technical Information The fields
76. from position 61 to 65 N 5 3 M Ver 021 from position 104 to 108 N 5 3 M Description This field indicates the length expressed in meters with three decimal points of the minimum dimension of the base If the container is cylindrical this value is zero In other words if the package is a drum or roll coil this field will be filled with zeros If it is a carton the smaller of the two lengths of the base must be indicated If the seller is not able to provide this information the field must be filled with zeros Technical Information This field has three decimal places and is expressed in meters 1 2 metres gt Oy 1 2 0 0 0 i 0 0 0 0 The max base dimension represents a diameter The package is a cylinder Manuale Operativo delle Definizioni V1 1R14 Pagina 85 Metel S r l UT LI Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 5 2 10 MAXIMUM HEIGHT DIMENSION Ver 020 from position 66 to 70 N 5 3 M Ver 021 from position 109 to 113 N 5 3 M Description This field indicates the height of the package expressed in meters with three decimal points If the seller is not able to provide this information the field must be filled with zeros Manuale Operativo delle Definizioni V1 1R14 Pagina 86 Metel S r l UT LI Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 5 2 11 CAN BE OVERTURNE
77. fy a item number this change must be guaranteed on all documents exchanged When it is necessary to contain item numbers with more than 16 characters in the Metel structure 16 characters the containment criteria must be the same for all of the documentation exchanged Manuale Operativo delle Definizioni V1 1R14 Pagina 23 Metel S r 1 ESTE L Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 4 1 7 Item Recodification The item recodification template is used by companies when they must change the code for the item number This is not a frequent requirement but it is important that this template be provided to the customer along with the new Metel price list which will only contain the new item numbers and their associated characteristics The company must also guarantee that this change is extended to all documents exchanged delivery notes order confirmations invoices etc The recodification template must be forwarded using the tools identified for sending the price list structure Metel Recodification Template Header Seq Description Mandatory M Start of Field Field Type and Optional O Position Length 1 Structure ID M 1 A 20 2 Version M 21 N3 3 Filler M 24 An 36 Record length 59 bytes followed by Carriage Return and Line Feed The Structure ID field must include the value RICODIFICA left aligned and filled with spaces O
78. ieces Package quantity 500 Unit of Measure PCE as per the price list Reciprocal 2 package quantity greater than carton quantity Package Type PL pallet Manuale Operativo delle Definizioni V1 1R14 Pagina 81 Metel S r 1 UT LI Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 5 2 6 PACKAGE QUANTITY CONFEZIONE Ver 020 from position 48 to 54 N 7 2 M Ver 021 from position 91 to 97 N 7 2 M Description This field contains the quantity expressed in the unit of measure of product contained in the package that the line refers to Thus it expresses The quantity of EAN 13 codes that are included in the package barcode package in the hypothesis that the package described is of an order of magnitude greater than the type described of the unit of measure in the price list line If not then it represents how many barcodes are included in the EAN 13 code In the first case The EAN code indicates the product involved ex switches The package barcode identifies which package is involved ex box of switches The package quantity associated with that package is the number contained therein ex 200 switches per carton See point No 7 Reciprocal for the case that the package level is of a lower level than the EAN 13 Technical Information This field calls for two decimals 0 0 0 1 5 0 0 v 15 8 5 gt 0
79. in the price list packaging according to the fields required This structure permits the communication of information regarding the product packaging physical dimensions of the packages height length and depth weight contained product quantity and JD code for the package In particular in terms of the ID code for the package that is the barcode please refer to the INDICOD EANCOD standards for complete information on this topic We limit ourselves to highlighting that The barcode identifies a specific product and a specific package Therefore if two packages are different for the number of items it contains or only for their shape they must have different barcodes even if they contain the same product Regarding the identification of the package the wholesaler is required to codify precisely the possible packages packaging for specific items on the Metel price list The packages from the smallest to the largest and all intermediate ones are expressed by the BARCODE LIST document The Barcode list by nature requires the presence of a packaging code barcode that expresses all of the possible packaging solutions for the products Updates of the packages and associated barcodes have operative times that at times do not coincide with the needs for distribution to manage the packages in the warehouse correctly Therefore it is necessary to resolve a few situations that occur in the logistic management EAN code
80. inizioni V1 1R14 Pagina 43 Metel S r 1 ESTE L Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 4 3 Structure of the Price List Line ver 020 and ver 021 Ver 020 Seq Field Description Start of Field Mandatory Field Type and Position M Length Optional O 1 Brand ID 1 M An 03 2 Company Item Number 4 M An 16 3 EAN code 20 O N 13 4 Product Description 33 M An 43 5 Carton Quantity 76 M N 05 6 Multiple Order Quantity 81 M N 05 7 Minimum Order Quantity 86 M N 05 8 Maximum Order Quantity 91 M N 06 9 Lead Time 97 M An 1 10 Wholesale price 98 M N 11 2 11 Retail price 109 M N 11 2 12 Price Multiplier 120 M N 06 13 Currency code 126 M A 03 14 Unitof Measure 129 M An 03 15 Composite Item 132 M NOI 16 Product Status 133 M An 01 17 Date of last change 134 M Dt 18 _ Discount Range 142 O An 18 19 _ Statistics Range 160 O An 18 Record length 177 bytes followed by Carriage Return and Line Feed The unique access key for the lines of the price list consists of a combination of the following fields Brand ID Company Item Number Currency code Manuale Operativo delle Definizioni V1 1R14 Pagina 44 Metel S r 1 ESTE L Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 Januar
81. l of Materials is not managed which automatically associates the cable to a spool type in the Cable sector order it is possible to specify for each line of ordered item also an order line for the spool on which you want to receive the cable via the parent and child technique described below Example ordering 2000 metres of cable with number Al and order number 11 120 accompanied by the technical designation which identifies the spool package of 1000 metres the following will occur Order parent linel item number Al quantity 2000 child line2 spool code 6 quantity 2 LIN LIN PIA PIA QTY QT 1082 829 1082 C212 1 7140 C212 2 7140 6060 Y 6411 Parent 000001 000001 Al BRAND CODE 2000 LM RA Child 000002 000001 SPOOL A6 BRAND CODE 2 PCE RA Manuale Operativo delle Definizioni V1 1R14 Pagina 114 Metel S r l ESTE L The manufacturer can confirm the item number and relative spool in the order confirmation Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 Confirmation parent linel item number Al quantity 2000 child line2 spool code 6 quantity 2 LIN LIN PIA PIA QTY QT 1082 C829 1082 C212 1 7140 C212 2 7140 6060 Y 6411 Parent 000001 000001 AI BRAND CODE 2000 LM RA Child 000002 000001 SPOOL A6 BRAND CODE 2 PCE RA If the spool is not specified in the order
82. lDataPool the OUTPUT generated by MetelDataPool in case of special characters will be different from the input loaded were character are not recognized VALIDATION OF CONTENTS It will be delegated to MetelDataPool any alert of incorrect use of certain characters based on the specification of individual fields Manuale Operativo delle Definizioni V1 1R14 Pagina 118 Metel S r 1 ie Te L Version 020 021 rev 14 January 2014 Listino Prezzi Metel Barcode Metel ISO 8859 15 Latin Alphabet 9 OD OE OF OD na re ani co m w Lo m N n OOFF E ire 00FE OOF A o o o o o o wu o o fa oO WM Zon Fla S S S H as sa o o o nm nm rm nm rm m ws 2 9 x Sl vi amp o o o wW wo wo wo wo pa Sle fa log afl og wo wo o o HS a Bla Sho Sa o o o oO a CEREREREEE ce Metel S r 1 Pagina 119 Manuale Operativo delle Definizioni V1 1R14
83. lling in the fields makes it necessary and mandatory for the company that produces the Metel price list when they refer to a sales policy that groups products according to the statistic range and discount range definitions defined above Example The product belongs in the seller s range 3311231 and will have the right to the appropriate discount for the seller s products A2 The effective value of the discount for products A2 will be communicated separately through traditional commercial channels see the rules NOTE If it is necessary to enter the discount and or statistics range in the Metel price list structure they must be reported for each item present in the Metel price list Manuale Operativo delle Definizioni V1 1R14 Pagina 66 Metel S r 1 UT LI Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 4 3 20 CODICE ELECTROCOD Ver 021 from position 178 to 197 An 20 M Description This field allows the associacion of item to the code of Electrocod Family Technical Information This field is mandatory and alphanumerical The ElectroCod code is defined by Metel thoughout a specifical Technical Commettee and it represents a commodity classification shared by the Metel CDA Members Manuale Operativo delle Definizioni V1 1R14 Pagina 67 Metel S r 1 UT LI Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 4 3 21 CODICE BARCO
84. lume sale This identifies the height of Volume occupied calculation the packages Sizing of the position occupied on the shelving Calculation of the order volume sale Can be overturned Barcode This indicates if the Volume occupied calculation package can be overturned Sizing of the position occupied or not on the shelving Weight of the package Wight calculation Package barcode Barcode This identifies the package It allows automatic inventory loading in which the item number and discharge of the package by the of the seller is packaged wholesaler Manuale Operativo delle Definizioni V1 1R14 Pagina 104 Metel S r 1 ESTE L Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 LEAD DELIVERY TRANSPORTE FIELD VALUE a 1 2 Manuale Operativo delle Definizioni V1 1R14 Pagina 105 Metel S r l ESTE L Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 ANNEX A MANDATORY METEL PRICE LIST FIELDS FOR THE PURPOSES OF ASSOCIATION WITH THE TECHNICAL DESIGNATION 107 Introduction 107 1 METEL PRICE LIST FIELDS 108 1 1 MULTIPLE ORDER QUANTITY 108 1 2 MINIMUM ORDER QUANTITY 108 1 3 WHOLESALE PRICE 108 1 4 RETAIL PRICE 108 2 BARCODE LAYOUT FIELDS 109 2 1 PACKAGE QUANTITY 109 2 2 NET PRODUCT WEIGHT 109 2 3 PACKAGE TYPE 110 2 4 CONVENTIONAL COPPER WEIGHT 110 Manuale Operativo delle Definizioni V1 1R14 Pagina 106 Metel S r
85. mmend the use of more than one price list for the same target retail or wholesale with the same company brand ID We highly recommend using a single price list per type If this is not possible the impact on the customers IT systems must be carefully evaluated should a customer use more than one of the same type of price list Manuale Operativo delle Definizioni V1 1R14 Pagina 21 Metel S r l UT LI Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 4 1 5 New Metel abbreviations The METEL organization is the only party responsible for issuing new Company IDs The procedure to issue a new METEL ID is described in this manual in Section 4 1 2 The issue of a brand ID is also guaranteed by Metel once certification is complete All new METEL subscribers must guarantee the use of the new ID and brand for all price lists issued after the date Metel communicates them Manuale Operativo delle Definizioni V1 1R14 Pagina 22 Metel S r l UT LI Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 4 1 6 Uniqueness of codes In reference to the uniqueness of codes each company subscribing to Metel R must guarantee that the following rules are respected AII documents used for exchange price lists delivery notes invoices etc must include the company item number listed in the price list Whenever it is necessary to modi
86. must be indicated with the status 2 phase out in the price list previous to the one in which it is deleted When articles are deleted product status 9 the wholesale and retail price fields must contain a price that is significant for the reference market For example value of the price in the previous price list Product status 8 is for those codes on price list that indicate services and non hysical goods where is not possible give indications related to measurements or packages In this case is not given an information on existence new modified cancelled of service but the status allows to avoid checking that may concern the quality Barcode and the completeness on barcode and packaging index Manuale Operativo delle Definizioni V1 1R14 Pagina 64 Metel S r l UT LI Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 4 3 17 LAST CHANGE ADDITION DATE Ver 020 from position 134 to 141 Dt M Ver 021 from position 134 to 141 Dt M Description The date is expressed in the YYYYMMDD year month day format The field contains the date of the last change addition for reference to identify the items that have been changed or added to the price list Technical Information This field is mandatory If the price list is sent with an effective date of 03 January 2004 the last change date in the header will have the same value as the issue date as will all of the detail dates
87. n 17 to 51 AN 35 M 5 2 3 PACKAGE BARCODE QUALIFIER Ver 020 from position 30 to 30 AN 01 O Ver 021 from position 52 to 52 AN 01 O 5 2 4 PACKAGE BARCODE Ver 020 from position 31 to 44 An 14 M Ver 021 from position 53 to 87 An 35 M 5 2 5 UNIT OF MEASURE Ver 020 from position 45 to 47 An 03 M Ver 021 from position 88 to 90 An 03 M 5 2 6 PACKAGE QUANTITY CONFEZIONE Ver 020 from position 48 to 54 N 7 2 M Ver 021 from position 91 to 97 N 7 2 M 5 2 7 RECIPROCAL Ver 020 from position 55 to 55 N 01 M Ver 021 from position 98 to 98 N 01 M 5 2 8 MAXIMUM DIMENSIONS BASE DIAMETER Ver 020 from position 56 to 60 N 5 3 M Ver 021 from position 99 to 103 N 5 3 M 5 2 9 MINIMUM DIMENSIONS BASE Ver 020 from position 61 to 65 N 5 3 M Ver 021 from position 104 to 108 N 5 3 M 5 2 10 MAXIMUM HEIGHT DIMENSION Ver 020 from position 66 to 70 N 5 3 M Ver 021 from position 109 to 113 N 5 3 M 5 2 11 CAN BE OVERTURNED Ver 020 from position 71 to 71 N1 O Ver 021 from position 114 to 114 N 1 0 5 2 12 GROSS WEIGHT Ver 020 from position 72 to 79 N 8 3 M Ver 021 from position 115 to 122 N 8 3 M 5 2 13 DATE INTRODUCED Ver 020 from position 80 to 87 Dt O Ver 021 from position 123 to 130 Dt O 5 2 14 DATE OF LAST CHANGE ADDITION Ver 020 from position 88 to 95 Dt O Ver 02
88. nformation as to if it is a kit set of items as well as status information product status field Technical Information This field is numerical and can have one of two values 1 YES itisa kit 0 NO itis nota kit Taking the first case field 1 all of the codes that represent A set or group of different products identified themselves with their own item number A set or group of different products not identified with their own item number Manuale Operativo delle Definizioni V1 1R14 Pagina 63 Metel S r l UT LI Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 4 3 16 PRODUCT STATUS Ver 020 from position 133 to 133 An 01 M Ver 021 from position 133 to 133 An 01 M Description This field contains qualitative information on the status and handling of the product 1 New product 2 Product being phased out and to be deleted 3 Product managed by the warehouse 4 New service 5 Deleted service 6 Product made to order 7 Product made to order being phased out and to be deleted 8 Services non physical goods 9 Deleted product The following rules apply Each product introduced to the price list and classified as new 1 must have the date of introduction in its barcode structure record see the line structure This date represents the reference for formulation of purchase orders for this item number Each product deleted from the sellers offering
89. nly capital letters are accepted Example R II C O D JI JF JI C A Each cell corresponds to one character The Version field must include the value 020 and spaces are not accepted Example 0 2 0 Each cell corresponds to one character The filler field must only contain spaces Manuale Operativo delle Definizioni V1 1R14 Pagina 24 Metel S r l ESTE L Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 Metel Recodification Template Lines Seq Description Mandatory M Start of Field Field Type and Optional O Position Length 1 Company ID M 1 An 3 2 Brand ID 4 An 3 3 Company VAT No M 7 An ll 4 Effective date M 18 Dt 5 Original code M 26 An 16 6 New code O 42 An 16 7 Comment for deletion change M 58 An 2 8 New Brand O 60 An 3 Record length 59 bytes followed by Carriage Return and Line Feed In all cases in which a number of codes replace the original code the code record parent must be the same for all of those that replace it children or vice versa Legend for Comment for Deletion Change 01 Registry change type of code 02 Type of packaging 03 Technical characteristics of the product 04 Replacement 05 Deleted NOTE The Company item number field of the Metel Price List must contain only the i
90. not yet adopted by the seller Impossible to read the EAN code on the packages Changes in the packaging quantities and misalignment with the already existing packages Preventative information for special handling for the type of packaging specified The identification of all possible packaging has the scope of facilitating the logistics management of the packaging for orders of magnitude greater than the sales unit specified in the Metel price list field with the carton quantity label At the same time it can temporarily resolve the lack of the use of the EAN code by the seller When the EAN code cannot be used it is necessary to be able to associate each combination with its own logistic code that identifies the quantity of product specified for the type of packaging Manuale Operativo delle Definizioni V1 1R14 Pagina 70 Metel S r l UT LI Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 The data necessary for the identification of all the logistic combinations for handling are 1 The item number for the product this is the Company item number in the Metel price list 2 Type of packaging This is the packaging considered for the logistic combination to be identified It corresponds to the type of packaging field in the Barcode list 3 Item Quantity This is the quantity contained in the type of packaging specified 4 Logistic Code This is the combination of data previou
91. o Rel 1 1 rev 13 February 2014 The changes or additions on Version 020 of Price List and Barcode refer to the additional elements that do not prevent compatibility with the previous version With regard to the 021 version of the Price List and Barcode the changes are related to the introduction of new fields at the end of detail record So it is varied the structure of detail record and the maximum record length included the one of header that modify the compatibility with the previous version of this two layouts As for recodification layout version 020 the changes refers to the introduction of a new field at the end of detail record So it is varied the structure of detail record and the maximum record length included the one of header that modify the compatibility with the previous version of this layout Specifically addition of Price List version 021 on Price List version 021 modified maximum record length both on header and in detail on Price List version 021 addition of ELECTROCOD CODE field BARCODE AND BARCODE QUALIFIER on Barcode version 021 modified EAN CODE fields from 13 numerical characters to 35 alphanumerical characters on Barcode version 021 modified positions of detail record and maximum record length both on header and in detail added annex Characters Allowed Manuale Operativo delle Definizioni V1 1R14 Pagina 7 Metel S r l UT LI Listino Prezzi Metel Barcode
92. pond to the company item number When a product does not have an EAN 13 code only zeros must be entered in this field in order to not cause any ambiguities for the receiver of the structure in terms of inadmissibility of the code Manuale Operativo delle Definizioni V1 1R14 Pagina 50 Metel S r 1 UT LI Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 4 3 4 PRODUCT DESCRIPTION Ver 020 from position 33 to 75 An 43 M Ver 021 from position 33 to 75 An 43 M Description This field must contain a description of the complete product exhaustive yet clear For completeness and exhaustively of the description refer to the technical specifications Clarity refers to the need to make the description easy to understand even by unskilled personnel ex shop assistant tax inspector etc Technical Information This field is alphanumeric and therefore must be left aligned and filled in with spaces to the right the field can contain both capital and small letters Set Up Criteria The definition of unique uniform criteria for reference for all companies subscribing to METEL is described separately We recommend always using capital letters A to Z We recommend using numbers 0 to 9 We recommend progressively eliminating all other characters where possible especially semi colon comma percentage sign asterisk cos Manu
93. product This provides and indication of the existing relation multiple or sub multiple between the type of packaging that the sales price refers to and all other forms of packaging shown in the barcode structure Pagina 103 Check for the content of different packages for which the code is distributed It is used for the reorder calculations of the wholesaler as a filter for rounding the quantities of specific orders It is used in the reorder calculations of the wholesaler for the order multiples starting from the minimum order quantity first restriction It is used by the wholesalers in their reorder calculations This is used in the wholesalers reorder calculations for their needs and safety stocks This is a check of the content of the various types of packaging used It supports the identification of the best packaging for handling This is a check of the content of the various types of packaging used Metel S r l Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 Maximum based Barcode This identifies the Volume occupied calculation dimension maximum dimension of the Sizing of the position occupied package on the shelving Calculation of the order volume sale Minimum This identifies the Volume occupied calculation dimensions base minimum dimension of the Sizing of the position occupied package on the shelving Calculation of the order vo
94. rtification phase Technical Information If the seller with the Metel ID XXX also distributes the prices list for brands YYY and ZZZ the header must include the ID XXX and in the detail IDs YYY and ZZZ If the company ID corresponds to the brand ID both must be listed in the header and in the detail Example of company ID equal to brand ID Brand ID XXX Brand ID XXX Brand ID XXX Brand ID XXX Example of company ID with different brands listed on the price list Header Company ID XXX Brand ID XXX Brand ID XXX Brand ID YYY Brand ID YYY Brand ID ZZZ Brand ID ZZZ Manuale Operativo delle Definizioni V1 1R14 Pagina 46 Metel S r 1 UT LI Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 4 3 2 COMPANY ITEM NUMBER Ver 020 from position 4 to 19 An16 M Ver 021 from position 4 to 19 An16 M Description This field must contain the item number that the company assigns to the product One and only one code must be used in all documents exchanged price list orders order confirmation delivery notes and invoices to guarantee that it is read in a uniform manner at all levels of communication Should the company decide to recodify its products it must inform its customers and provide two lists of the old and new codes on the recodification structure that must be attached to the Metel price list Code Y replaces Code X Code X is replaced by Code Y
95. sly described In particular the code represents The company item number The quantity handled The type of packaging to the company item number specified Example Item Number Type of Item Q ty Logistic Code Packaging AAAA CARTON 100 aXX BBBB PALLET 1000 bYY CCCC CARTON 50 cXX DDDD PALLET 10000 dZZ DDDD PALLET 1000 dYY The information provided in the logistic code can be used by the sender and receiver to configure the handling information for the specified product in their IT system The EAN code for the package can be replaced by the logistic code Manuale Operativo delle Definizioni V1 1R14 Pagina 71 Metel S r l ESTE L Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 5 1 Structure of the Header Version 020 and 021 Ver 020 Seq Field Description Start of Field Mandatory Field Type and Position M Length Optional O 1 Structure ID 1 M A 20 2 Company ID 21 M An 03 3 Company VAT No 24 M An 11 4 Barcode structure number 35 O An 06 5 Issue date 41 M Dt 6 Date of last change addition 49 M Dt 7 Filler 57 M An 69 8 Barcode structure version 126 M N 03 Record length 128 bytes CR LF Ver 021 Seq Field Description Start of Field Mandatory Field Type and Position M Length Optional O 1 Structure ID 1 M A 20
96. st sent to wholesaler In order to obtain maximum efficiency manufacturers are recommended to use case C in this start up phase Manuale Operativo delle Definizioni V1 1R14 Pagina 108 Metel S r l UT LI Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 2 BARCODE LAYOUT FIELDS 2 1 PACKAGE QUANTITY Description This field contains the quantity expressed in the unit of measurement of product contained in the package that the line refers to Therefore the quantity indicates which product is being discussed e g coil The package quantity associated with that package is the number contained therein e g 200 metres 500 metres etc for the same product For each Metel price list line various Barcode price list lines can be entered based on the type of packaging the manufacturer is proposing to the market if the cable with manufacturer code xyz present on the metel price list has different packaging types the included sizes are detailed on the barcode Metel price list product xyz corresponds to price list barcode xyz quantity 200 metre coil price list barcode xyz quantity 300 metre spool price list barcode xyz quantity 1000 metre spool With this connection the wholesaler knows the possible packaging for product xyz during the order phase 2 2 NET PRODUCT WEIGHT For cables this field indicates the net weight of a cable in kilograms
97. system capable of reading files in a MS DOS ASCII format For indications on Characters Allowed to identify article codes or descriprions please refer to annex Characters Allowed at the end of the manual The following table shows the methods for interpretation of the syntax of the fields An 99 Alphanumeric the field must be left aligned and its exact length is expressed by the numerical value 99 Example If we had an alphanumeric field nine characters long and we had to fill it with the string METELO we would have M E T E L 0 Each cell corresponds to one byte The definition of the field is An 09 A 99 Alphabetical numbers are not permitted The field must be left aligned and its exact length is expressed by the numerical value 99 Example If we had an alphabetical field nine characters long and we had to fill it with the string METEL we would have M E T E L Each cell corresponds to one byte The definition of the field is A 09 N99 Whole Numbers alphabetic characters are not allowed The field must be right aligned and its exact length is expressed by the numerical value 99 The non significant bytes must be filled with zeros Manuale Operativo delle Definizioni V1 1R14 Pagina 12 Metel S r l UT LI Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 Example If we had a whole number
98. tems listed in the recodification template structure in the new code field If the old codes are required for data management these must be accompanied by the correct product status 9 deleted or 2 Product being phased out and to be deleted We recommend that items be recodified when there are changes to the technical characteristics of the product especially when these characteristics are present and highlighted on the product itself even if they are compatible with the product identified previously Manuale Operativo delle Definizioni V1 1R14 Pagina 25 Metel S r l ESTE L Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 4 1 8 Discount and Statistics Ranges Should the sender Refer to discounts on the price list for product ranges Define groups of uniform products for statistical purposes It is important that these two types of information be communicated using the fields Discount Range and Statistic Range which are included on the Metel price list To this end tables for the discount range and the statistic range have been added These tables can be sent in the same manner identified for sending the Metel price list Record Structure Discount Range Metel Header Seq Description Mandatory M Start of Field Field Type and Optional O Position Length 1 Structure ID M 1 A 20 2 Version M 21 N3 Filler M 24 An 71 Record
99. tends to involve the entire realm of businesses in the industry providing a decisive contribution to the quality of the exchange of information in electronic format This manual describes a standard of rules to be followed when implementing the Metel Standard within the company The User Manual Definitions on its own is not sufficient to guarantee that the rules are respected For this reason there is a specific point at which analysis and certification of the company procedures and the information provided is necessary Certification depends on the documents and the company that creates them First of all the rules of syntax must be guaranteed Secondly the content must be correct This means that the analytical value of the information must be evaluated objectively This defines Metel s role during this phase It is a laboratory that guarantees and performs all of the phases of the certification process for each documented identified in the User Manual Definitions 4 1 2 1 The METEL Manager The assignment of a Metel Manager within the company is of specific interest This person becomes the point of reference for all developments in later phases It is important to emphasize that the Metel Manager is mainly an organizer This is the person who decides what individuals within the company will be involved based on the type of certification desired 4 1 2 2 Characteristics of the Company Metel Manager The position of the Met
100. the price 11 characters of which 2 are decimals that must be expressed in EURO If an item costs 0 00025 EURO the price cannot be entered in the Metel price list for fiscal reasons only 2 decimals are valid Therefore the multiplier will have a value of 1000 and the price will be shown as 0 25 Multiplier Value 0 0 1 0 0 0 Position 1 2 3 4 5 6 Price in Euro per 1000 items Value 0 0 0 0 0 0 0 0 0 2 5 Position 1 2 3 4 5 6 7 8 9 10 11 Price for 1 item 0 00025 x Multiplier 1000 Price per 1000 items 0 25 We emphasize that the price multiplier does NOT refer to any package quantities listed in the price list Manuale Operativo delle Definizioni V1 1R14 Pagina 60 Metel S r l UT LI Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 4 3 13 CURRENCY CODE Ver 020 from position 126 to 128 A 03 M Ver 021 from position 126 to 128 A 03 M Description This field must have an alphabetic value The value expressed represents the reference currency for the prices shown in the price list Technical Information This field cannot contain spaces and its content is defined by the ISO codes If there is more than once currency the line item can be repeated The default value is EUR For other currencies please refer to the following table AED UAE Dirham ANG
101. to all of the recipients who receive both versions of the price lists This document must contain all of the changes that have been made Each paper price list has the following basic information in the header or footer indicated in the template Metel logo Price list description Price list number Effective date When a new price list is issued all of the item numbers must be included in the both the electronic and paper based price list Manufacturers are responsible for sending the changes to all of the parties involved Manuale Operativo delle Definizioni V1 1R14 Pagina 19 Metel S r l UT LI Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 4 1 4 Distribution of the price list The price list can be distributed in the following formats Magnetic Paper based E MAIL Sender s web page Metel price list distribution portal opos Distribution can occur at two times In terms of magnetic optical support 3 2 floppy discs or CDs are acceptable For distribution by E mail or on a web page the data must be compressed into a self extracting file The exact correspondence of the extracted file to the original file must be guaranteed by the sender The following procedure is valid for price lists sent either on magnetic support or by Email The price list must be distributed at least 20 days prior to its effective date Distribution must include The METEL price
102. ubscribers Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 The structure and format described in this manual Rel 1 1 rev 3 January 2005 have not changed in comparison to Rel 1 1 rev 2 January 2003 The changes or additions refer to clarifications to the meanings of the fields Specifically The possibility of generating price lists by parties other than manufacturers of electrical materials has been integrated Update of the certification system with the adoption of the Metel portal The logistic code on the barcode list has been implemented The net product weight field on the barcode list has been implemented Additional detailed information has been added regarding the discount range statistical range and the section on item recodification Manuale Operativo delle Definizioni V1 1R14 Pagina 11 Metel S r 1 UT LI Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 3 Technical Conventions for Use The structure of the documents described herein refers to Price list structure Recodification structure Descriptive table for the discount and statistical ranges Barcode structure noe The above listed structures describe ASCII files The lengths of the records are fixed and each record must end with the carriage return and line feed characters These last two characters allow the data to be interpreted correctly by any
103. y 2014 Ver 021 Seq Field Description Start of Field Mandatory Field Type and Position M Length Optional O 1 Brand ID 1 M An 03 2 Company Item Number 4 M An 16 3 EAN code 20 O N 13 4 Product Description 33 M An 43 5 Carton Quantity 76 M N 05 6 Multiple Order Quantity 81 M N 05 7 Minimum Order Quantity 86 M N 05 8 Maximum Order Quantity 91 M N 06 9 Lead Time 97 M An 10 __ Wholesale price 98 M N 11 2 11 Retail price 109 M N 11 2 12 Price Multiplier 120 M N 06 13 Currency code 126 M A 03 14 _ Unit of Measure 129 M An 03 15 Composite Item 132 M NOI 16 Product Status 133 M An 01 17 Date of last change 134 M Dt 18 _ Discount Range 142 O An 18 19 _ Statistics Range 160 O An 18 20 Electrocod Code 178 M An 20 21 Barcode 198 O An 35 22 Barcode Qualifier 233 O An 1 Record length 233 bytes followed by Carriage Return and Line Feed The unique access key for the lines of the price list consists of a combination of the following fields Brand ID Company Item Number Currency code Manuale Operativo delle Definizioni V1 1R14 Pagina 45 Metel S r l UT LI Listino Prezzi Metel Barcode Metel Version 020 021 rev 14 January 2014 4 3 1 BRAND ID Ver 020 from position 1 to 3 An 03 M Ver 021 from position 1 to 3 An 03 M Description Identifies the brand with respect to the ID assigned to the company The Brand ID is issued by Metel during the price list ce

ANIE – FNGDME - ARAME

Contents

Download Pdf Manuals

Related Search

Related Contents

ANIE &ndash; FNGDME - ARAME

Contents

Download Pdf Manuals

Related Search

Related Contents

ANIE – FNGDME - ARAME