Body
Business Intelligence Sales
The Business Intelligence Sales message intent is to provide sales information for one or more locations for a series of products within a specified time period.
General usage
- It allows to know for a specific product, for example the Location of the sale, Period in which it was sold, Product selling price, quantity and value of the sales etc.
Fields used in the Business Intelligence Sales 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 | Gross sales amount | The total sales amount for the sold quantity of the product, including VAT- | /b24Message/salesReport/site/sale/item/price[@type="grossSalesAmount" and @value] |
|
|
20 | Gross sales price | The sales price for one unit of the sold product, including VAT | /b24Message/salesReport/site/sale/item/price[@type="grossSalesPrice" and @value] |
|
|
21 | Net sales amount | The total sales amount for the sold quantity of the product, ?excluding VAT. | /b24Message/salesReport/site/sale/item/price[@type="netSalesAmount" and @value] |
|
|
22 | Net sales price | The sales price for one unit of the sold product, including VAT | /b24Message/salesReport/site/sale/item/price[@type="netSalesPrice" and @value] |
|
|
23 | Cost amount | The total cost for sold quantity of the product. | /b24Message/salesReport/site/sale/item/price[@type="costAmount" and @value] |
|
|
24 | Cost price | The cost price for one unit of the sold quantity of the product. | /b24Message/salesReport/site/sale/item/price[@type="costPrice" and @value] |
|
|
25 | Recommended retail price | Recommended retail price including VAT | /b24Message/salesReport/site/sale/item/price[@type="recRetailPrice" and @value] |
|
|
26 | Net return price | The return price for one unit of the sold product, including VAT | /b24Message/salesReport/site/sale/item/price[@type="netReturnPrice" and @value] |
|
|
27 | Net return amount | The total return amount for the sold quantity of the product, ?excluding VAT. | /b24Message/salesReport/site/sale/item/price[@type="netReturnAmount" and @value] |
|
|
28 | Gross return price | The return price for one unit of the sold product, including VAT | /b24Message/salesReport/site/sale/item/price[@type="grossReturnPrice" and @value] |
|
|
29 | Gross return amount | The total return amount for the sold quantity of the product, including VAT- | /b24Message/salesReport/site/sale/item/price[@type="grossReturnsAmount" and @value] |
|
|
30 | Quantity Sales | The quantity of the item sold at the site. | /b24Message/salesReport/site/sale/item/quantity[@type="Sales" and @value] |
|
|
31 | Quantity Return | The quantity of the item returned at the site. | /b24Message/salesReport/site/sale/item/quantity[@type="Return" and @value] |
|
|
32 | Quantity Cancel | The quantity of the item cancelled at the site. | /b24Message/salesReport/site/sale/item/quantity[@type="Cancel" and @value] |
|