Body
Business Intelligence Stock
The Business Intelligence 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.
Fields used in the Business Intelligence Stock message
# | Field Name | Required | Field Description | Xpath | Example |
---|---|---|---|---|---|
1 | Sender | Yes | The sender of the EDI message, identified by a GLN. | /b24Message/salesReport/sender/#gln |
|
2 | Recipient | Yes | The recipient of the EDI message, identified by a GLN. | /b24Message/salesReport/recipient/#gln |
|
3 | Document Number | Sales report ID for the whole transaction. | /b24Message/salesReport/documentReference[@documentType="salesReport"]/@id |
|
|
4 | Document Date | Sales report date. | /b24Message/salesReport/documentReference[@documentType="salesReport"]/@date |
|
|
5 | Buyer | Yes | The reseller group/HQ, identified by a GLN. | /b24Message/salesReport/buyer/#gln |
|
6 | Site | Yes | The store in which the goods were sold, identified by a GLN. | /b24Message/salesReport/site/location/#gln |
|
7 | Sales date | Yes | Date and time when the sale took place. | /b24Message/salesReport/site/sale/#date |
|
8 | Sales ID | ID of the sale transaction, receipt/terminal number. | /b24Message/salesReport/site/sale/#id |
|
|
9 | SKU Description | The supplier's SKU description for the product. Preferably including: model name, colour and size. | /b24Message/salesReport/site/sale/item/property[@name="description"] |
|
|
10 | Brand | The brand name of the product | /b24Message/salesReport/site/sale/item/property[@name="brand"] |
|
|
11 | Model number | The model number of the product. (suppliers model number) | /b24Message/salesReport/site/sale/item/property[@name="modelNo"] |
|
|
12 | Model color | The supplier's unique model and color ID of the product. | /b24Message/salesReport/site/sale/item/property[@name="modelColor"] |
|
|
13 | Gender category | The gender category, such as: Men, Woman, Unisex, Boys/Girls or Kids. | /b24Message/salesReport/site/sale/item/property[@name="gender"] |
|
|
14 | Goods class | The goods class of the product - either FEDAS, B24 Product Category Keys, Supplier or Customer. | /b24Message/salesReport/site/item/[@set="goods class type" and @code="goods class code"] |
|
|
15 | Supplier | Yes | The supplier/brand, identified by a GLN. | /b24Message/salesReport/supplier/#gln |
|
16 | Color code | The code of the product colour. | /b24Message/salesReport/site/sale/item/dimension[@name="color"] |
|
|
17 | Size | The size of the item. | /b24Message/salesReport/site/sale/item/dimension[@name="size"] |
|
|
18 | Barcode with type | The supplier's EAN/UPC code of the product. | /b24Message/salesReport/site/sale/item/itemReference[@registry="Supplier" and @coding="EAN13"] |
|
|
19 | Retail value on-hand | Retail value (at full price) of inventory on hand | /b24Message/salesReport/site/sale/item/price[@type="retailAmountOnHand" and @value and @currency] |
|
|
20 | Retail value on-order | Retail value (at full price) of inventory on order | /b24Message/salesReport/site/sale/item/price[@type="retailAmountOnOrder" and @value and @currency] |
|
|
21 | Cost value on-hand | Purchase price times quantity on hand | /b24Message/salesReport/site/sale/item/price[@type="costAmountOnHand" and @value and @currency] |
|
|
22 | Cost value on-order | Purchase price times quantity on order | /b24Message/salesReport/site/sale/item/price[@type="costAmountOnOrder" and @value and @currency] |
|
|
23 | Recommended retail price | Recommended retail price including VAT | /b24Message/salesReport/site/sale/item/price[@type="recRetailPrice" and @value and @currency] |
|
|
24 | Cost price | Product price (purchase price) | /b24Message/salesReport/site/sale/item/price[@type="costPrice" and @value and @currency] |
|
|
25 | Quantity on-hand | Number of pieces of item barcode at site | /b24Message/salesReport/site/sale/item/quantity[@type="OnHand"] |
|
|
26 | Quantity on-order | Number of pieces on order/allocated to (but not yet received at) site | /b24Message/salesReport/site/sale/item/quantity[@type="OnOrder"] |
|