xml Stock

The Stock message intent is to exchange information related to stock levels

General usage

- The message includes functionality to differentiate classes of inventory, and to permit financial valuation of inventories facilitating price protection claims, auditing, statutory declarations, etc.
- The specified quantities relating to a product can indicate opening stock, closing stock, and goods movement (receipts or withdrawals) of held inventory, for a given time frame.
- The specified quantities can relate directly to a product or package, and may be sub-detailed within different groups or classes, e.g., batch, age, valuation, location, etc.

Name Required Description Examples Xpath Type Limits Sort Id Edifact Path Edifact Qualifiers Edifact_Sample
(Header):EDI message name No

The name of the EDI message

 <stockReport text="Btwentyfour Example Stock Report" environment="Production" messageId="223456" messageDate="2021-12-23T12:19:05.167Z"  dateFrom="2021-12-22" dateTo="2021-12-22"> 

/b24Message/stockReport/@text

Text

None

100 1 INVRPT.FTX.C108.4440 INVRPT.FTX.4451 = ANM

FTX+ANM+++<b>Btwentyfour Example Stock Report</b>'

(Header):Environment No

Environment/test indicator - either "Production" or "Test"

 <stockReport text="Btwentyfour Example Stock Report" environment="Production" messageId="223456" messageDate="2021-12-23T12:19:05.167Z"  dateFrom="2021-12-22" dateTo="2021-12-22"> 

/b24Message/stockReport/@environment

Text

None

200 2 UNB.0035 [1 if it is a testfile]

UNB+UNOY:4+7340117852868:14+7340117852851:14+221129:2938+56487963468493++++++<b>1</b>'

(Header):Btwentyfour message ID No

Message ID set by Btwentyfour Open Commerce Platform.

 <stockReport text="Btwentyfour Example Stock Report" environment="Production" messageId="223456" messageDate="2021-12-23T12:19:05.167Z"  dateFrom="2021-12-22" dateTo="2021-12-22"> 

/b24Message/stockReport/@messageId

Number

None

300 3 INVRPT.RFF.C506.1154 INVRPT.RFF.C506.1153 = BID

RFF+BID:<b>223456</b>'
DTM+171:20211223:102'

(Header):Btwentyfour message date No

Message date set by Btwentyfour Open Commerce Platform.

 <stockReport text="Btwentyfour Example Stock Report" environment="Production" messageId="223456" messageDate="2021-12-23T12:19:05.167Z"  dateFrom="2021-12-22" dateTo="2021-12-22"> 

/b24Message/stockReport/@messageDate

Date/Time

None

400 4 INVRPT.RFF.DTM.C507.2380 INVRPT.RFF.C506.1153 = BID, INVRPT.RFF.DTM.C507.2005 = 171

RFF+BID:223456'
DTM+171:<b>20211223</b>:102'

(Header):Date From No

First stock reporting date in the file

 <stockReport text="Btwentyfour Example Stock Report" environment="Production" messageId="223456" messageDate="2021-12-23T12:19:05.167Z"  dateFrom="2021-12-22" dateTo="2021-12-22"> 

/b24Message/stockReport/dateFrom/#date

Date/Time

None

500 5 INVRPT.DTM.C507.2380 INVRPT.DTM.C507.2005 = 90 , INVRPT.DTM.C507.2370 = 102

DTM+90:<b>2021-12-22<b>:102'

(Header):Date To No

Last stock reporting date in the file

 <stockReport text="Btwentyfour Example Stock Report" environment="Production" messageId="223456" messageDate="2021-12-23T12:19:05.167Z"  dateFrom="2021-12-22" dateTo="2021-12-22"> 

/b24Message/stockReport/dateTo/#date

Date/Time

None

600 6 INVRPT.DTM.C507.2380 INVRPT.DTM.C507.2005 = 91 , INVRPT.DTM.C507.2370 = 102

DTM+91:<b>2021-12-22</b>:102'

(Header):Sender Gln Yes

The sender of the EDI message, identified by a GLN.

 <sender gln="7340117836950"> 

/b24Message/stockReport/sender/#gln

Number

None

700 7 UNB.S002.0004 UNB.S002.0007 = 14

UNB+UNOY:4+<b>7340117852868</b>:14+7340117852851:14+221129:2938+56487963468493++++++'

(Header):Recipient Gln Yes

The recipient of the EDI message, identified by a GLN. (If the file contains multiple supplier items, recipient should always be Btwentyfour Open Commerce Platform.)

 <recipient gln="7340117802900"> 

/b24Message/stockReport/recipient/#gln

Number

None

800 8 UNB.S003.0010 UNB.S003.0007 = 14

UNB+UNOY:4+7340117852868:14+<b>7340117852851</b>:14+221129:2938+56487963468493++++++1'

(Header):StockReport Number Yes

Stock report ID for the whole transaction.

 <documentReference documentType="StockReport" id="STOCK1X2345" date="2021-12-23"> 

/b24Message/stockReport/documentReference[@documentType="stockReport"]/@id

Text

None

900 9 INVRPT.RFF.C506.1154 INVRPT.RFF.C506.1153 = STK

RFF+STK:<b>STOCK1X2345</b>'
DTM+171:20211223:102'

(Header):StockReport Date Yes

Stock report date.

 <documentReference documentType="StockReport" id="STOCK1X2345" date="2021-12-23"> 

/b24Message/stockReport/documentReference[@documentType="stockReport"]/@date

Date/Time

None

1000 10 INVRPT.RFF.DTM.C507.2380 INVRPT.RFF.C506.1153 = STK, INVRPT.RFF.DTM.C507.2005 = 171

RFF+STK:STOCK1X2345'
DTM+171:<b>20211223</b>:102'

(Header):Supplier Gln on header level No

The supplier identified with by GLN (use only if the report contains items from one single supplier)

 <supplier gln="7340117815580"> 

/b24Message/stockReport/supplier/#gln

Number

None

1100 11 INVRPT.NAD.C082.3039 INVRPT.LIN.NAD.3035 = SU

NAD+SU+<b>7340117815580</b>::9'

(Header):Buyer Gln Yes

The buyer/retailer/marketplace HQ, identified by GLN

 <buyer gln="7340117836950"> 

/b24Message/stockReport/buyer/#gln

Number

None

1200 12 INVRPT.NAD.C082.3039 INVRPT.LIN.NAD.3035 = BY

NAD+BY+<b>7340117852868</b>::9'

(Header):Site Gln per Message Yes

The specific site/warehouse/store holding the reported stock, identified with GLN, sent on header level in our D01B format, but it is otherwise an iterative element in c21.

 <site><location gln="3333333333333"> 

/b24Message/stockReport/site/location/#gln

Number

None

1300 13 INVRPT.NAD.C082.3039 INVRPT.NAD.3035 = GY

NAD+GY+<b>7340117852868</b>::9'

Site Gln per Item No

Site used on item level in our D01B format, however the C21 xpath is the exact same as the value Site Gln, used to send information from several different storage locations in a single EDI message

 <site><location gln="3333333333333"> 

/b24Message/stockReport/site/location/#gln

Number

None

1400 14 INVRPT.LIN.INV.LOC.C517.3225 INVRPT.LIN.INV.LOC.3227 = 14

LOC+14+<b>7340117852868'</b>

Stock date Yes

Date of the reported stock count

 <stock date="2021-12-22" id="160-36282308640-2021-12-22"> 

/b24Message/stockReport/site/stock/#date

Date/Time

None

1500 15 INVRPT.LIN.INV.DTM.C507.2380 INVRPT.LIN.INV.DTM.C507.2005 = 414

DTM+414:<b>20211222</b>:102'

Stock Id No

A unique identification code used to identify the stock of the storage location at the exact date, Possibly a combination of the Location's own Id and the date such as "gln-2022-11-22"

 <stock date="2021-12-22" id="160-36282308640-2021-12-22"> 

/b24Message/stockReport/site/stock/@id

Text

None

1600 16 INVRPT.LIN.INV.RFF.C506.1154 INVRPT.LIN.INV.RFF.C506.1153 = STK

RFF+STK:<b>STOCK1X2345</b>'

Age Group No

The intended age Group/category such as: Adult, Junior, Kids

 <property name="ageGroup">Adults</property> 

/b24Message/stockReport/site/stock/item/property[@name="ageGroup"]

Text

None

1700 17 INVRPT.LIN.IMD.C273.7008 INVRPT.LIN.IMD.C272.7081 = AGR

IMD+F+AGR+::91:<b>Adults</b>'

Supplier on item level Yes

The supplier of the item, identified by a GLN. (should be same for all items if supplier GLN is also specified in message header)

 <supplier gln="7340117815580"> 

/b24Message/stockReport/site/stock/item/supplier/#gln

Number

None

1800 18 INVRPT.LIN.NAD.C082.3039 INVRPT.LIN.NAD.3035 = SU

NAD+SU+<b>7340117852851</b>::9'

Color Description No

Plain text description of the product color

 <dimension name="color" code="666">Black</dimension> 

/b24Message/stockReport/site/stock/item/dimension[@name="color"]

Text

None

1900 19 INVRPT.LIN.IMD.C273.7008 INVRPT.LIN.IMD.C272.7081 = 35

IMD+F+35+:::<b>Black</b>'

Color Code No

Code for the product color

 <dimension name="color" code="666">Black</dimension> 

/b24Message/stockReport/site/stock/item/dimension[@name="color"]/@code

Text

None

2000 20 INVRPT.LIN.IMD.C273.7008 INVRPT.LIN.IMD.C273.7008 = 35

IMD+C+35+:::<b>666</b>'

Brand No

The brand of the product

 <property name="brand">B24 Running</property> 

/b24Message/stockReport/site/stock/item/property[@name = "brand"]

Text

None

2100 21 INVRPT.LIN.IMD.C273.7008 INVRPT.LIN.IMD.C272.7081 = BRN

IMD+F+BRN+::91:<b>B24 Running</b>'

Description No

Description including product attributes that make up the specific item/SKU that is offered to the buyer/consumer. For Apparel/Footwear-products typically a combination of the model name, color and size, for cosmetics/beuaty-products the description could e.g. consist of model name, fragrance/scent and volume.

 <property name="description">Btwentyfour Running Shoe Black 38</property> 

/b24Message/stockReport/site/stock/item/property[@name = "description"]

Text

None

2200 22 INVRPT.LIN.IMD.C273.7008 INVRPT.LIN.IMD.C272.7081 = DSC

IMD+F+DSC+::91:<b>Btwentyfour Running Shoe Black 38</b>'

Gender No

The gender category of the product (b24 example values: "Male", "Female" or "Unisex")

 <property name="gender">Women</property> 

/b24Message/stockReport/site/stock/item/property[@name = "gender"]/@code

Text

None

2300 23 INVRPT.LIN.IMD.C273.7008 INVRPT.LIN.IMD.C272.7081 = GEN

IMD+F+GEN+::91:<b>Women</b>'

Supplier Item Id No

The supplier's unique Id for the article, often a combination of the article's Model number, Color, and Size

 <item id="1064"> 

/b24Message/stockReport/site/stock/item/@id

Text

None

2400 28 INVRPT.LIN.PIA.C212.7140 INVRPT.LIN.PIA..4347 = "5",INVRPT.LIN.PIA.C212.7143 = SA[Supplier = 91, Buyer = 92, b24 = B24]

PIA+5+<b>testId1</b>:SA::91'

Buyer Item Id No

The buyer's unique id for the article

 <itemReference  name="itemId" registry="Buyer">1234567891125</itemReference> 

/b24Message/stockReport/site/stock/item/itemReference[name ="itemId"]

Text

None

2500 29 INVRPT.LIN.PIA.C212.7140 INVRPT.LIN.PIA..4347 = "5",INVRPT.LIN.PIA.C212.7143 = LN[Supplier = 91, Buyer = 92, b24 = B24]

PIA+5+<b>TestId01</b>:IN::92'

Model Number No

Idenficiation of the Article's Model

 <property name="modelNo" registry="Supplier">1064</property> 

/b24Message/stockReport/site/stock/item/property[@name = "modelNo"]

Text

None

2600 30 INVRPT.LIN.PIA.C212.7140 INVRPT.LIN.PIA..4347 = "1",INVRPT.LIN.PIA.C212.7143 = MN, INVRPT.LIN.PIA.C212.3055 = registry[Supplier = 91, Buyer = 92, b24 = B24]

PIA+1+<b>1064</b>:MN::91'

Barcode No

The supplier's EAN/UPC code of the product

 <itemReference coding="EAN13" registry="Supplier">1234567891125</itemReference> 

/b24Message/stockReport/site/stock/item/itemReference[@registry="Supplier"]

Number

None

2700 31 INVRPT.LIN.C212.7140 N/A

LIN+1++<b>7313492579316</b>:EN'

Barcode Type No

The type of barcode, for example "EAN13" or "UPCA". For a complete list, see http://big.btwentyfour.com/codes#id1 <itemReference registry="Supplier"

 <itemReference coding="EAN13" registry="Supplier">1234567891125</itemReference> 

/b24Message/stockReport/site/stock/item/itemReference[@registry="Supplier"]/@coding

Text

None

2800 32 INVRPT.LIN.C212.7143 N/A

LIN+1++7313492579316:<b>EN</b>'

Quantity On Hand No

Quantity of goods currently stored at the location

 <quantity type="OnHand" value="6">             
   <quantityState type="Available" value="3" />             
   <quantityState type="Allocated" value="3" />  
</quantity> 

/b24Message/stockReport/site/stock/item/quantity[@type = "OnHand"]

Number

None

2900 33 INVRPT.LIN.INV.QTY.C186.6060 INVRPT.LIN.INV.QTY.C186.6063 = 145

QTY+145:<b>6</b>'

Available Quantity No

Quantity of goods currently stored at the location that is available for sale

 <quantity type="OnHand" value="6">             
   <quantityState type="Available" value="3" />             
   <quantityState type="Allocated" value="3" />  
</quantity> 

/b24Message/stockReport/site/stock/item/quantity[@type = "OnHand"]/quantityState[@type = "Available"]

Number

None

3000 34 INVRPT.LIN.INV.QTY.C186.6060 INVRPT.LIN.INV.QTY.C186.6063 = 17

QTY+17:<b>3</b>'

Allocated Quantity No

Quantity of goods currently stored at the location that has already been allocated for sale

 <quantity type="OnHand" value="6">             
   <quantityState type="Available" value="3" />             
   <quantityState type="Allocated" value="3" />  
</quantity> 

/b24Message/stockReport/site/stock/item/quantity[@type = "OnHand"]/quantityState[@type = "Allocated"]

Number

None

3100 35 INVRPT.LIN.INV.QTY.C186.6060 INVRPT.LIN.INV.QTY.C186.6063 = 170

QTY+170:<b>3</b>'

Quantity On Order No

Quantity of goods that have been ordered to the location, currently awaiting delivery

 <quantity type="OnOrder" value="2" /> 

/b24Message/stockReport/site/stock/item/quantity[@type = "OnOrder"]

Number

None

3200 36 INVRPT.LIN.INV.QTY.C186.6060 INVRPT.LIN.INV.QTY.C186.6063 = 198

QTY+198:<b>2</b>'

Price/Amount Currency No

The currency in which the referenced unit price or amount has been specified. All price types reported for the item should be accompanied by an ISO 4217 currency code.

 <price type="retailPrice" value="200.00" currency="EUR" /> 

/b24Message/stockReport/site/stock/item/price[@type = ""]\@currency

Text

None

3250 38 INVRPT.LIN.INV.PRI.CUX.C504.6345 INVRPT.LIN.INV.PRI.CUX.C504.6347 = 2

CUX+2:<b>EUR</b>'

Retail Price No

The current list price the product has at the buyer's store location.

 <price type="retailPrice" value="200.00" currency="EUR" /> 

/b24Message/stockReport/site/stock/item/price[@type = "retailPrice"]

Number

None

3300 37 INVRPT.LIN.INV.PRI.C509.5118 INVRPT.LIN.INV.PRI.C509.5125 = REP

PRI+REP:<b>200.00</b>'

Cost Price No

The price that the product was bought from the Supplier.

 <price type="costPrice" value="80.00" currency="EUR" /> 

/b24Message/stockReport/site/stock/item/price[@type = "costPrice"]

Number

None

3500 39 INVRPT.LIN.INV.PRI.C509.5118 INVRPT.LIN.INV.PRI.C509.5125 = COP

PRI+COP:<b>80.00</b>'

Retail Amount On Hand No

The Retail Price times the On Hand Quantity

 <price type="retailAmountOnHand" value="1200.00" currency="EUR" /> 

/b24Message/stockReport/site/stock/item/price[@type = "retailAmountOnHand"]

Number

None

3700 41 INVRPT.LIN.INV.PRI.C509.5118 INVRPT.LIN.INV.PRI.C509.5125 = RAO

PRI+RAO:<b>200.00</b>'

Retail Amount On Order No

The Retail Price times the On Order Quantity

 <price type="retailAmountOnOrder" value="400.00" currency="EUR" /> 

/b24Message/stockReport/site/stock/item/price[@type = "retailAmountOnOrder"]

Number

None

3800 42 INVRPT.LIN.INV.PRI.C509.5118 INVRPT.LIN.INV.PRI.C509.5125 = RAH

PRI+RAH:<b>1200.00</b>'

Cost Amount On Hand No

The Cost Price times the On Hand Quantity

 <price type="costAmountOnHand" value="480.00" currency="EUR" /> 

/b24Message/stockReport/site/stock/item/price[@type = "costAmountOnHand"]

Number

None

3900 43 INVRPT.LIN.INV.PRI.C509.5118 INVRPT.LIN.INV.PRI.C509.5125 = CAO

PRI+CAO:<b>160.00</b>'

Cost Amount On Order No

The Cost Price times the On Order Quantity

 <price type="costAmountOnOrder" value="160.00" currency="EUR" / 

/b24Message/stockReport/site/stock/item/price[@type = "costAmountOnOrder"]

Number

None

4000 44 INVRPT.LIN.INV.PRI.C509.5118 INVRPT.LIN.INV.PRI.C509.5125 = CAH

PRI+CAH:<b>480.00</b>'