Franchise Guide
I0449 and I0545 Interface

Version: 0.4
Issue Date: 12-Nov-14

Author: Antony Neal	Document Class: External
 
Approvals
Name	Role	Approval Email	Date
Approvers	Document must be signed-off by all approvers before the next stages of work can progress
Gurdeep Panesar	Project Manager		
Sam Sibbert	Solution Designer		
Gavin Mapley	Architect		
Reviewers	Response is not essential for work to progress. All comments should be passed to project BA and will be included in considerations for final version. Any subsequent changes to this document will be subject to change control procedures
Richard Croft	Business Solutions Manager		
Aware	Document has been provided for information purposes only at this stage, response is not essential for work to progress. All comments should be passed to project BA and will be included in considerations for final version
			
			

 
Document History
The following versions of the document have been produced:
Vers.	Status	Issue Date	Author	Reason for Issue
0.1	Draft	02/10/2014	Antony Neal	First Draft created
0.2	Draft	28/10/2014	Antony Neal	Published for Internal Review
0.3	Draft	05/11/2014	Antony Neal	Updates with comments from Architect
0.4	Draft	12/11/2014	Antony Neal	Updated with comments from PM on Franchise Projects






 
Contents
1	DOCUMENT PURPOSE	5
2	OVERVIEW	6
2.1	List of Values	7
3	XML STRUCTURE	8
3.1	XSD	8
3.2	Header	8
3.3	ArticleHeader	8
3.4	Article	9
3.5	ArticleDescription	15
3.6	UOM	15
3.7	EAN	17
3.8	VendorEAN	17
3.9	HierarchyLevel	17
3.10	ReferencePrices	17
4	TEST DATA	19
5	DATA QUALITY	20
6	APPENDIX A - GLOSSARY	21










	
1	Document Purpose
This document is a user guide for the new I0449 and I0554 Interfaces provided by M&S Plc to Franchisees. This document is not intend to replace any interface specifications but rather give an overview of the interface, the data elements within it, what the data might be used for and examples of what the data might look like. 
This document assumes no knowledge of the franchise and does not replace any discussions that are had with the franchisee around I0449 and I0554. This document does not act as any form of testing. Assumptions around what systems and processes might be in place are based around the franchisee not taking the full list of article interfaces that are provided by M&S. 
This document assumes that the franchise has a minimal understanding of M&S’ Purchasing Hierarchy, Range setup (i.e. dept/stroke/colour/size) as well as article hierarchy and types. If the Franchise does not have an understanding of this then should refer to the relevant documentation before reading this document.
This document also refers to a list of values held in M&S’ core ERP system, SAP. Any list of values is initially provided as a reference – other values may have been added since this document was written.
2	Overview
The I0449 Interface is intended to reduce the amount of interfaces that a franchise needs to subscribe to in order to become a partner with M&S. Previously a franchise would have to subscribe to multiple interfaces (I0016 – Near Real Time Article Master Data, I0020 – Article Data, I0022 – Characteristics Reference Data and I0160 – Article Hierarchy Data) in order to work with M&S.
The I0449 Interface works by combining the structure of these interfaces (since I0016 uses the same structure). An overview diagram of the xml structure is below: 

 
The interface will work by only sending article deltas to the franchise; if an article has changed in anyway then all information about the article will be sent.
 ArticleHeader and Article will always be populated but other elements may not be populated if the details are currently available e.g. the article may not have been assigned a hierarchy if it is at status 3. 
Interface I0545 is the same XSD as I0449 but rather than sending deltas will send all information available about the articles selected. It is also worth noting that I0554 is manually triggered and will send all information about the articles selected (i.e. regardless of the state of the article).
Once a franchise has received I0545 they can then begin receiving I0449. 



2.1	List of Values
A spreadsheet has been provided containing what are considered “static” values by M&S (as of 28/10/14).  Whilst these values do not change often they are subject to change. The following values have been provided:
•	Departments
•	Primary Sizes
•	Secondary Sizes
•	Brands
•	Core/Newness
•	Price Band
•	Material Type
•	EAN Type
•	Article Category
•	Article Status 
•	Order Type
•	Units of Measure
•	Units of Measure (ISO standard)
•	Country of Origin
•	Currency
•	Assortment Grade


 


3	XML Structure
3.1	XSD
 
3.2	Header
There will always be a Header element. The header element contains information about the message that is being sent i.e. when it was sent, what type of message and number of records within the message. 
XML Element	Interface Header
Attribute	Description	Data Type 	Field Length	Optional/
Mandatory	List of Values / Comments
MessageID	Message ID	INT	X	M	Sequential message ID. Applies to all interfaces and partners i.e. it can go forward x number of times but can’t be the same message and can’t go backwards.
CorrelationID	Correlation ID	CHAR	18	O	Same as MessageID
CreatedTimestamp	Defines the type of article.	CHAR	4	M	yyyy-MM-dd'T'HH:mm:ss'.0Z'
SourceApplication	M&S Source System	CHAR	x	M	Should always be DS_DATAHUB
InterfaceID	Interface ID	CHAR	6	M	Will be either I0449 or I0545.
InterfaceName	Description of Interface.	CHAR	X	M	“I0449 - Intl Delta Article Master” or “I0545 - Intl Full Article Master”
PayloadName		CHAR	X	M	Intl ArticleMaster
BatchMessageCount	Message Count in Xml	INT	X	M	Number of messages
BatchRecordCount	Record Count in Xml	INT	X	M	Number of Records (i.e. different Payloads – ArticleHeaders) within the message. 
BatchRecordSum	Sumcheck.	DEC	X	M	Not used in this interface

3.3	ArticleHeader
There will always be an ArticleHeader element. This contains information about which (generic) article information is being sent, what change is happening to the article information and what type of article it is.  
XML	Article Header
Attribute	Description	Data Type 	Field Length	Optional/
Mandatory	List of Values / Comments
Function	Used to describe what activity is taking place in the article message	CHAR	3	O	003 – Message contains objects to be deleted
004- Message contains changes
005 – This message replaces previous messages
009 – First message for processing
023 - Wait/Adjust – this value should not be imported
018 – Resend
Updates/changes usually come as 005 and will be the most common message type followed by 009 and 003. 
ParentArticleNo	Article number	CHAR	18	M	If the article number is not 18 digits it is padded with leading 0s e.g. 000000060001585002.
ArticleType	Defines the type of article.	CHAR	4	M	Values will usually start with Z – please refer to the “Material Types” in the LOV Spreadsheet. 
MerchandiseCat	The Merchandise Category held in M&S SAP system.	CHAR	9	O	Usually starts with an A followed by an 8 digit code. This is set at a more detailed level than Dept (currently over 400 combinations). Please see list of values for an example set.
ArticleCategory	Defines what the article is used for.	CHAR	2	O	For a full list please look at the Article Categories Tab in the list of values. The 3 common ones are:

00 – Single Article (one of its type)
01 – Generic Article (Stroke/Colour)
02 – Variant Article (Stroke/Colour/Size)
RefArticle	Reference Article	CHAR	18	O	M&S uses reference articles internally for the creation of our master data, assortments and listings. This field refers to the reference article. 

3.4	Article
The Article element will be main content of each message and will always be sent. This will contain attribute information about the article at its selling (i.e. could be generic or variant) level e.g. the status of the article, it’s dimensions, brand, descriptions, CoO, Price Bands etc. It is worth noting that the information here and it HierarchyLevel and Reference prices will evolve over time as the article changes status – please see Section 4 for more information.
XML	Article
Attribute	Description	Data Type 	Field Length	Mandatory/
Optional	List of Values / Comments
Function				O	As Article Header
ArticleNo		CHAR	18	O	The article here may be a generic or variant. E.g. it may be the same as ParentArticle in ArticleHeader such as 12345678 (usually for food articles) or it may go down to the variant (size) level for an Article such as 12345678001. For more information on article please see the M&S Franchise Guide. 
ArticleCategory				O	As Article Header
LastChange	When the article was last altered.	DATE	8	O	Format is in YYYY-MM-DD. 
DeleteFlag	Deletion Flag Indicator	CHAR	1	O	Is either X or blank. X indicates the article needs to be deleted. Will usually coinside with Function.
OldArticleNo	Old Article Number	CHAR	18	O	Information used by our legacy systems. Can be blank and can contain decimal point.
BaseUoM	Unit of Measure – How the article can be disturbed or sold	CHAR	3	O	This usually refers to the UoM of which the product is sold. Therefore this is mostly EA (each). Other UOM such as Carton packs etc are contained in either the POUoM or PackVolUnit.  All denominatiors ( i.e. the Quantity within UoM) UoMs for the product will be contained in a separate Article.ArticleHeader.UOM.  For all UoM values please see the list of values spreadsheet.
BaseUoMISO	Unit of Measure – How the article is distributed/sold in ISO Format	CHAR	3	O	Usually the same as above but may change to comply with ISO format e.g. KG becomes KGM. For a full list see UoM list of values speadsheet.
POUoM	Purchase Order Unit of Measure	CHAR	3	O	Usually how the product is distributed. So this could be O01 = Outer Pack Size 1 for Foods or blank for GM. Full details of the size of the Outer pack would be in  Article.ArticleHeader.UOM.  
POUoMISO	Purchase Order Unit of Measure to ISO Standard.	CHAR	3	O	Conversion to ISO standard.
SizeDimensions	Freetext method of entering size dimensions	CHAR	32	O	Can be blank.
BasicArticle	Constituent components of the article.	CHAR	14	O	Used to be measure parts of an article. Not used.
NetWeight	Net Weight	DEC	15	O	Value related to PackVolUnit. 
Container	Container Type	CHAR	2	O	Governs which type of container the material must be stored and shipped in. Can be 01 or 02 but not used.
StorageConditions	Storage Conditions	CHAR	2	O	A 	Ambient             
B 	Binstock            
C 	Chilled             
D 	Direct Via Depot 2  
F 	Frozen              
G 	Hort. Ambient       
H 	Direct Via Depot 1  
L 	Long Life Ambient   
R 	Replenishment       
S 	Pick and Pack       
T 	UPT Trial           
W 	Wine                
X 	Ambient Ordering    
Y 	Cold Chain Ordering
TempCondInd	Indicator as to whether the stock needs to be temperature controlled.	CHAR	2	O	A   	AMBIENT             
F   	FROZEN              
R   	RED DISK            
Y   	YELLOW DISK 
Food only characteristic.    
TransportationGroup	How the stock is transported	CHAR	4	O	Z001  Boxed               
Z002  Hanging             
Z003  Freight Box-Standard Hanging
Z004  Standard Box-Display Hanging
Season	What season the product is in (GM)	CHAR	4	O	Season/Year e.g. AU08, will always start with either AU or SP. (AU will also include Winter and SP will also include Summer. 
AllowedPackWeight	Allowed packaging weight
 	DEC	15	O	Maximum weight of other materials that are packed in this packaging material.
PackWeightUnit	Packed weight 	CHAR	3	O	e.g. KG, GM see Units of Measure tab in spreadsheet.
PackWeightUnitISO	Packed weight (ISO Format)	CHAR	3	O	e.g. KGM, GM see Units of Measure tab in spreadsheet.
AllowedPackVol	Allowed Packaging Volume	DEC	15	O	Maximum volume of other materials that are packed in this packaging material.
PackVolUnit	Packing Volume Unit of Measure	CHAR	3	O	e.g. Pallet etc, see Units of Measures tab in spreadsheet.
PackVolUnitISO	Packaging Volume Unit of Measusure (ISO Format)	CHAR	3	O	e.g. Pallet etc, see Units of Measures tab in spreadsheet.
HUExWgtTolLimit	Excess Weight Tolerance for Handling unit	DEC	5	O	Specifies the tolerance limit for exceeding the maximum weight allowed for a particular packaging material during packing. 
HUExVolTolLimit	Excess Volume Tolerance of the Handling Unit	DEC	5	O	Specifies the tolerance limit for the maximum packing volume allowed for a particular packaging material. 
Notes 
The maximum packing volume allowed by the system is the maximum packing volume plus the tolerance.
AuthGroup		CHAR	4	O	Same as Purchasing Group. Used in M&S to say who is responsible for authorising. 
MinRemainShelfLife	Minimum Remaining Shelf Life	DEC	6	O	Usually blank. For ambient and frozen this is measured in months e.g. 12 = 12 months.
TotalShelfLife	Total Shelf Life	DEC	6	O	As above. Can be different to the above if the sell by date / best before dates are different.
StoragePercent	Storage Percent	DEC	4	O	Not used. Usually 0.
ValidFrom	Valid from date.	DATE	8	O	Format is in YYYY-MM-DD
DeletionDate	Deletion Date.	DATE	8	O	When the article is set for deletion.  Format is in YYYY-MM-DD. Usually set for 9999-12-31.
SeasonYear	Season Year	CHAR	4	O	Relates to the SEASON value. E.g. AU12 will be 2012. In YYYY format.
PriceBandCat	Price Band Category	CHAR	2	O	Good, Better, Best – please see values in list of values spreadsheet. 
PricingRefArticle	The article pricing the product.	CHAR	18	O	The price of a product may not be held by the article itself e.g. it may be held by the generic.
CrossSiteArtStatus	Cross-distribution-chain article status	CHAR	2	O	Used for magazines. Usually Blank. 
Y0REPL = Yes               
Y1REPL = No                
Z1Marked for markdown      
Z2Temporary discontiuation 
Z3Permanent discontiuation 
Z4Initial purch block-Food 
Z5MAS range 98             
Z6Pricing Block            
Z7Food Activate fr Ordering
Z8FoodDeactivate frOrdering
CrossSiteArtStatusValidFrom	Date in which the cross-site article is valid from.	DATE	8	O	YYYY-MM-DD
TaxClassification		CHAR	3	O	Can be blank and does not have to 3 characters. See list of values.
GrossContents	Gross Weight	DEC	15	O	Uses Base UOM.
DangerousGoodsIndProf	Dangerous Goods Indicator	CHAR	3	O	Can be blank. Indicates if any checks or documentation needs to be carried out.
001 = Relevant for dangerous goods, checks and documents
G00 = Relevant for dangerous goods
G0P = Relevant for dangerous goods and documents
GP0 = Relevant for dangerous goods and checks
GPP = Relevant for dangerous goods, checks and documents
HighlyViscousInd	Highly Viscous Indicator	CHAR	1	O	X = Yes, Blank is No
BulkLiquidInd	Bulk Liquid Indicator	CHAR	1	O	X = Yes, Blank is No
AssortmentListType	Assortment List Type	CHAR	1	O	Defines how the article was listed on SAP. Can be A or B.  
PurchasingGroup	M&S Buying Hierarchy (and reporting hierarchy)	CHAR	3	O	This is the Marks and Spencer department code that the product belongs to.  Will start with either a T (GM) or an F (Foods). A full list can be found it in the list of values tab.
SalesUoM	Unit of measure in which the product is sold to the customer.	CHAR	3	O	Usually EA – a full list of values can be found in the UOM tab.
SalesUoMISO	ISO Unit of measure in which the product is sold to the customer.	CHAR	3	O	Usually EA – a full list of values can be found in the UOM tab.
IssueUoM	Unit of Issue	CHAR	3	O	Usually EA – a full list of values can be found in the UOM tab.
IssueUoMISO	Unit of Issue	CHAR	3	O	Usually EA – a full list of values can be found in the UOM tab.
CountryofOrigin	Country of Origin	CHAR	3	O	Please see Country tab in the list of values spreadsheet. Please note that a product can come from different vendors and when the vendor of choice changes the Origin will also change. 
CountryofOriginISO	Country of Origin to ISO standard.	CHAR	2	O	Please see Country tab in the list of values spreadsheet.
RegionOrigin	Region of Origin for article (non-preferential) 	CHAR	3	O	
LoadingGroup	Loading Group	CHAR	4	O	Usually 0001
AssortmentGrade	Assortment Grade	CHAR	2	O	Can be blank. Defines the grade that the article should be in. 
AssortmentPriority	Assortment Priority	CHAR	1	O	Can be blank or 0 – 9.
ListingProcStore	Listing Procedure for Store	CHAR	2	O	Defines the Store Listing procedure. Usually defaulted to 02. Can be blank.
ListingProcDC	Listing Procedure for DC	CHAR	2	O	Defines DC Listing Procedure. Usually defaulted to 02. Can be blank.
ListedFromDateStore	When the article was first listed for a store.	DATE	8	O	YYYY-MM-DD
ListedToDateStore	When the listing for the article ends for a store.	DATE	8	O	YYYY-MM-DD
ListedFromDateDC	When the article was first listed for a DC.	DATE	8	O	YYYY-MM-DD
ListedToDateDC	When the listing for the article ends for a DC.	DATE	8	O	YYYY-MM-DD
SellFromDateStore	When the article was to being sent to stores.	DATE	8	O	YYYY-MM-DD
SellToDateStore	When the article will stop being to stores	DATE	8	O	YYYY-MM-DD
SellFromDateDC	When the article was to being sent to DCs.	DATE	8	O	YYYY-MM-DD
SellToDateDC	When the article will stop being to DCs.	DATE	8	O	YYYY-MM-DD
CommodityCode	Commodity Code	CHAR	17	O	Commodity Code from EU EBTI database. Example 6201121090
CreationStatus	 Status of the article.
	CHAR	2	O	Values are usually sent from 03 onwards (unless triggered as part of I0545).
00 – Pre-Planned
01 – Planned
02 – Developed
03 – Design Approved
04 – Final Approval
05 – Live
06 – Suspended
07 – Discontinued
08 – Archived
BrandId	Brand	CHAR	4	O	Please see Brands tab in list of values. 
FashionGrade	Fashion Grade	CHAR	4	O	Used in standard SAP to apply fast/slow rules. Not used.
StdHUType	Standard Handling Unit Type	CHAR	4	O	Can be blank.
HandlingInd	Handling Indicator	CHAR	4	O	Usually blank.
0001 = Handle with Care
0002 = Handle in the upright position
CountryOfOrigin2	Second Country of Origin	CHAR	3	O	Please see Country list of values.
CountryOfOrigin2ISO	Second Country of Origin (ISO Format)	CHAR	2	O	Please see Country list of values.
FreightGroup	Article Freight Group	CHAR	8	O	SAP field used for freight groupings. Usually blank.
AlcoholPercentage	Alcohol %	CHAR	4	O	In value 0,00. (usually 0,00).
Facing	Minimum Number of Display Facings	CHAR	2	O	Usually 00
Front	Maximum Display Height	CHAR	1	O	Usually 0
DisplayMethod	Display Method	CHAR	2	O	S        	STRAIGHT ON TRAY              
U        	SINGLES                   
Foods only characteristic.    
DisplayOrientation	Delivery Orientation	CHAR	2	O	Which way the product is displayed.
H    Horizontal
V    Vertical
DeliveryMethod	Delivery Method	CHAR	2	O	SAP field.  Usually blank.
DeliveryMethodStartDate		DATE	8	O	YYYY-MM-DD
Stroke	Stroke Number	CHAR	5	O	Part of the M&S reporting hierarchy, usually 4 digits but can be 4 digits and a character.
ColourCode	Colour Code	CHAR	6	O	A list of the values for both has been assigned. This only applies to GM product.
ColourCodeDescription	Colour Code Description	CHAR	30		
PrimSizeIndex	Primary Size Code	CHAR	2	O	Indicates the code in the primary size index that is being used by that generic article e.g. an article might be using custom field MO, primary size code 08 in that instance would then be XL as indicated in the description. Please see the list of values for more details. It is worth noting that if an article uses primary sizes only the index number should not be repeated.
SecSizeIndex	Secondary Size Code	CHAR	2	O	Similarly to the above, indicates a code within the index which denotes the specific secondary size value for that article. 
CoreNewness	Core or Newness Indicator	CHAR	2	O	Please see list of values in the list of values spreadsheet. Not usually needed by an International Franchise but can indicate trials.
LicensedCharacter	Licensed Character Number	CHAR	2	O	Alphanumeric to indicate licensed character product to M&S. 95 is Angry birds for example. An example list is included in the list of values.
FlowLineInd	Flow Line Indicator	CHAR	1	O	Either X or blank. X indicates flow line. A flow line is product that sits within the catalogue for more than one season. 
LaunchPackId	Launch Pack ID	CHAR	8	O	A group of similar product may be sent as a launch pack. Not used by international franchises.
PartPackNo		CHAR	8	O	Usually 00000000
PartPackMasterComponent		CHAR	18	O	Can be blank.
PrimSizeDesc	Primary Size Description	CHAR	30	O	Please see list of descriptions in Primary Size tab in list of values spreadsheet.
SecSizeDesc	Secondary Size Description	CHAR	30	O	Please see list of descriptions in Secondary Size tab in list of values spreadsheet.
TransGroupDesc		CHAR	20	O	Please see TransGroup for descriptions.
PriceBandCatDesc		CHAR	20	O	Please see Price Band for descriptions.
ColourGrpCode		CHAR	6	O	
CoreNewnessDesc	Core / Newness Code Description	CHAR	30	O	See list of values.
BrandDesc	Brand Description	CHAR	30	O	Please see list of descriptions in Brands tab in list of values spreadsheet.
MerchandiseCatDesc	Merchandise Category Description	CHAR	20	O	

3.5	ArticleDescription
Description of the article and what language the description is in. May not always be populated depending on article status. 
XML	Article Description
Element	Description	Data Type 	Field Length	Mandatory
/Optional	List of Values / Comments
Function				O	As per Article.ArticleHeader
LangKey	Single character defining the language the description is in.	CHAR	1	O	Usually E for English.
LangKeyISO	ISO 2-digit language definition.	CHAR	2	O	Usually EN for English.
ArticleDesc	Freetext Article Description	CHAR	40	O	Whilst free text this is usually in a structured format e.g for GM this Stroke, Description, Colour Code then Size, for Foods this is usual this is description only.

3.6	UOM
Definition of the units that the article is shipped/sold (Quantity) in and dimensions/weights. UoM can also be used to store alternative dimensions of a product e.g. WEA might be used to store dimensions for the singular product (each) because the EA data may be of insufficient quality. This element may not always be populated depending on the status of the product. UoM information may differ at variant level e.g. a towel may come in small, medium, large and all may be shipped in packs of 4 but they will all have different dimensions. 

XML	UOM
Attribute	Description	Data Type 	Field Length	Mandatory
/Optional	List of Values / Comments
Function				O
	As per Article.ArticleHeader
UoM		CHAR	3	O	e.g. EA, O01 etc, see Units of Measures tab in spreadsheet.
UomISO		CHAR	3	O	e.g. EA, O01 etc, see Units of Measures tab in spreadsheet.
UoMToBaseUoMNumerator	Numerator for conversion to Base Units of Measure	DEC	6	O	e.g. Pallet etc, see Units of Measures tab in spreadsheet.
UoMToBaseUoMDenominator	Denominator for conversion to Base Units of Measure	DEC	6	O	e.g. Pallet etc, see Units of Measures tab in spreadsheet.
MainIntlArticleNo	International Article Number (not to be confused with M&S internal article number)	CHAR	18	O	This is the EAN/UPC for EA. Will be filled out with padded 0s.
MainIntlArticleNoCat	What standard the International Article Number is in. 	CHAR	2	O	Refers to how long the EAN/UPC is – will usually be the following:
Z1 - 8 Digit Food EAN
Z2 - 8 Digit GM EAN
Z3 – 13 Digit EAN
Z4 – 12 Digit EAN
Z5 – 14 Digit EAN
Length	Length	DEC	17	O	Numerical value related to the Volume UOM above.
Width	Width	DEC	17	O	Numerical value related to the Volume UOM above.
Height	Height	DEC	17	O	Numerical value related to the Volume UOM above.
UoD	Unit of Measure for Display	CHAR	3	O	e.g. Pallet etc, see Units of Measures tab in spreadsheet.
UoDISO	Unit of Measure for Display in ISO Format	CHAR	3	O	e.g. Pallet etc, see Units of Measures tab in spreadsheet.
Volume	Volume	DEC	15	O	Volume Figure. Can contain decimal (.)
VolumeUOM	Volume Unit of Measure	CHAR	3	O	e.g. CM3, see Units of Measures tab in spreadsheet.
VolumeUOMISO	Volume Unit of Measure ISO Format	CHAR	3	O	See Units of Measures tab in spreadsheet.
GrossWeight	Gross Weight	DEC	15	O	Numerical value related to the UOM below.
WeightUoM	Weight Unit	CHAR	3	O	Does not have to be 3 characters – usually KG. 
WeightUoMISO	ISO Weight Unit	CHAR	3	O	Complies with ISO standard e.g. KGM.

3.7	EAN
Identifies the barcode used with that article.
XML	EAN
Element	Description	Data Type 	Field Length	Optional/
Mandatory	List of Values / Comments
Function				O	As per ArticleHeader.Function
IntlArticleNo		INT	13	O	EAN/UPC – Will usually be 8 digits (6 and 7 digit UPCs are padded with leading 0s) unless using 13 digit EAN. For reasons why a 13 digit EAN might be used please see the Franchise Guide. 
IntlArticleNoCat				O	As per UOM.MainIntlArticleNoCat

3.8	VendorEAN
Identifies the barcode used with that article by the vendor. For certain products e.g. beauty, non-M&S branded foods this may be different to <EAN>.
XML	VendorEAN
Element	Description	Data Type 	Field Length	Optional/
Mandatory	List of Values / Comments
Function				O	As per ArticleHeader.Function
IntlArticleNo				O	As per UOM.MainIntlArticleNo
IntlArticleNoCat				O	As per UOM.MainIntlArticleNoCat

3.9	HierarchyLevel
M&S’ Hierarchy information. This element may not always be populated depending on the status of the product. For a full hierarchy explanation please refer to the Franchise Guide or to full examples in the Test Data section.
XML	HierarchyLevel
Attribute	Description	Data Type 	Field Length	Optional/Mandatory	List of Values / Comments
Function	Describes the Hierarchy Change.	CHAR	1	O	Different from the other <Function> in article! Can be I (Initialisation), C (Change) or D (Direct Request). Usually I.  
HierID	Hierarchy ID	CHAR	2	O	Always MS which is the M&S Hierarchy
HierNode	Hierarchy Node	CHAR	18	O	Code for the node in the hierarchy. Usually defines by Foods-GM indicator, the level in hierarchy, and then number/dept e.g. F6-F20A is Foods Dept.
HierLevel	Hierarchy Level	CHAR	2	O	From 1-8. 8 is item level.
LongText	Description
Of Node	INT	40	O	Description e.g. F6-F20A is Beers,  Wines and Spirits. 

3.10	ReferencePrices
Prices that are used across the M&S estate including their validity period, status and which location the price is used. This element may not always be populated depending on the status of the product. Price information may differ at variant level e.g. a towel may come in small, medium, large and will have different prices for each. 
XML	ReferencePrices
Attribute	Description	Data Type 	Field Length	List of Values / Comments
Price	Price Value	DEC	22	Actual price. Format will be “000000000000000000.00.” Contains padded zeros.
StartDate	Price Start Date	DATE	8	YYYY-MM-DD. Start dates can be future dated.
EndDate	Price End Date	DATE	8	YYYY-MM-DD
Siteno	Site Number	CHAR	4	Indicates which site the price (i.e. location/channel) is relevant for. Example values can be:

Z200	Retail: UK Plc Normal
Z205	Retail: UK Plc Outlet
Z209	Retail: Ireland
Z210	Retail: Jersey
Z211	Retail: Guernsey
Z222	Retail: FR Retail
Z223	Retail: FR Direct
Z225	Retail:   EU Direct
Z226	Retail: NL Retail
Z228	POS Retail: Compass UK

ArticleChangeInd	Article Change Indicator	CHAR	1	Y/N. Y  indicates article change. Used by the table sending changes to determine whether data needs to be sent. Both ArticleChangeInd and PriceChangeInd can be Y. 
PriceChangeInd	Price Change Indicator	CHAR	1	Y/N. Y  indicates price change. Used by the table sending changes to determine whether data needs to be sent.
PromotionIndicator	Promotion Indicator	CHAR	1	Y/N. Y indicates the article is on promotion and that site. Does not necessarily mean that the promotion is the reason for the price change.
Currency	Currency	CHAR	3	See list of Currency Values
MarkdownInd	Markdown Indicator	CHAR	1	Y/N. Y indicates that the article has gone into sale (reduced) at that site. Does not necessarily mean that the sale is the reason for the price change.



4	Test Data
Below is an Excel spreadsheet which contains a series of XMLs from M&S’ Test environment detailing various business scenarios. Where an I0449 has been triggered and has sent article changes for more than one article the article for which the business scenario is relevant for has been highlighted.
The I0545 has been zipped due to file size. As it in an I0545 that has been triggered it contains all articles within M&S test environment so all data may not be valid/as expected.

 

 
5	Data Quality
Ideally with all data it must be maintained accurately and regularly. When this is not always possible it is beneficial to be aware of how well maintained the data is and what is can be used for.
In order to help franchises with the data in I0449/I0545 all attributes have been given an indication of data quality of red/yellow/green and which systems they could be used for and any additional comments.
Please note that both are given as indication/suggestion only. M&S does not dictate which data should where into which franchise system and should be treated as guidelines only. 
Franchises should also be aware of the M&S product lifecycle/status when considering M&S’ data e.g. an article at status 3 may not contain hierarchy/pricing information, all attributes might not be complete/final at status 4 etc.
 





6	Appendix A - Glossary
Abbreviation	Description
COO	Country of Origin
UOM	Units of Measure
LOV	List of Values
DC	Distribution Centre
UOD	Unit of Display
ISO	International Standard
PO	Purchase Order
GM	General Merchandise (Clothing)
XML	EXtensible Markup Language


....can you please extract the mapping foreach of  these attributes....MainIntlArticleNoCat ,HierNode ,LongText ,UoMArticleDesc ,ArticleDesc