STKRPT

STKRPT (Stock Report)

40 fields

40 fields
Column visibility
Name Required Description Examples XPath Property Type Sets Limits Categories Access Sort Id
(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 DateTime None 400 4
(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
(Header):Buyer Gln Yes The buyer/retailer/marketplace HQ, identified by GLN
 <buyer gln="7340117836950"> 
/b24Message/stockReport/buyer/#gln Number None 1200 12
(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 DateTime None 500 5
(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 DateTime None 600 6
(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
(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
(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
(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
(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
(Header):StockReport Date Yes Stock report date.
  <documentReference documentType="StockReport" id="STOCK1X2345" date="2021-12-23"> 
/b24Message/stockReport/documentReference[@documentType="stockReport"]/@date DateTime None 1000 10
(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
(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
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
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
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
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
Barcode Type No The type of barcode, for example "EAN13" or "UPCA". For a complete list, see http://big.btwentyfour.com/codes#id1
 <itemReference coding="EAN13" registry="Supplier">1234567891125</itemReference> 
/b24Message/stockReport/site/stock/item/itemReference[@registry="Supplier"]/@coding Text None 2800 32
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
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
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
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
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
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
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
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
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
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
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
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
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
Quantity Return No

Quantity of goods that have been returned to the supplier.

 <quantity type="Return" value="4" />

 

/b24Message/stockReport/site/stock/item/quantity[@type = "Return"] Text None 3225 39
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
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
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
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
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 DateTime None 1500 15
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 Number None 1600 16
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
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
No fields match your filters.