| Name↕ | Required↕ | Description↕ | Examples↕ | XPath↕ | Property↕ | Type↕ | Sets↕ | Limits↕ | Categories↕ | Access↕ | Sort↕ | Id↕ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| (Header) : Buyer gln | Yes | The buyer, identified by a GLN. | |
/b24Message/salesReport/buyer/@gln | Number | Must be a valid EAN13 GLN | 1600 | 7 | ||||
| (Item/Line) : 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. | |
/b24Message/salesReport/site/sale/item/price[@type=""]@currency | Text | *Required if price is included. | 3250 | 69 | ||||
| (Item/Line) : Gross Sales Minus Return Amount | No | The total Sales Amount (including VAT) for the sold quantity of the product after deduction for Returns, before deduction for discounts/markdowns/fees/charges. (grossSalesAmount - grossReturnAmount) Negative amount indicates more returns than sales for the item. | |
/b24Message/salesReport/site/sale/item/price[@type="grossSalesMinusReturnAmount"]@value | Number | 6450 | 66 | |||||
| (Item/Line) : Gross Sales Minus Return Amount Ex. VAT | No | The total Sales Amount (excluding VAT) for the sold quantity of the product after deduction for Returns, before deduction for discounts/markdowns/fees/charges. (grossSalesAmountExVAT - grossReturnAmountExVAT)�Negative amount indicate more returns than sales for the item. | |
/b24Message/salesReport/site/sale/item/price[@type="grossSalesMinusReturnAmountExVAT"]@value | Number | 6460 | 67 | |||||
| (Item/Line) : Net Sales Minus Return Amount | No | The total Net Sales Amount (including VAT) for the sold quantity after deductions for sale discounts/markdowns AND Returns with possible charges/fees. (netSalesAmount - netReturnAmount) �Negative amount indicates more returns than sales for the item. | |
/b24Message/salesReport/site/sale/item/price[@type="netSalesMinusReturnAmount"]@value | Number | 6490 | 64 | |||||
| (Item/Line) : Net Sales Minus Return Amount Ex. VAT | No | The total net Sales Amount (excluding VAT) for the sold quantity after deductions for discounts/markdowns AND Returns with possible charges/fees. (netSalesAmountExVAT - netReturnAmountExVAT) Negative amount indicates more returns than sales for the item. | |
/b24Message/salesReport/site/sale/item/price[@type="netSalesMinusReturnAmountExVAT"]@value | Number | 6495 | 65 | |||||
| (Item/Line) : Quantity Sales Minus Return | No | The total transaction�net quantity for the item at the site/store Sales quantity - Return quantity). Negtative quantity indicates more returns than sales for the item. | |
/b24Message/salesReport/site/sale/item/quantity[@type="SalesMinusReturn"]@value | Number | 6750 | 60 | |||||
| (Item/Line) : Cost Price (Return) | No | The retailer's Cost Of Goods Sold (COGS) for one unit of the returned product, including VAT. | |
/b24Message/salesReport/site/sale/item/price[@type="costPriceReturn"]@value | Number | None | 4600 | 37 | ||||
| (Header) : Date To | Yes | The last date the SalesReport covers | |
/b24Message/salesReport/@dateTo | Number | None | 1100 | 2 | ||||
| (Header) : Recipient gln | Yes | The recipient of the EDI message, identified by a GLN. Please note that for the Sales Report message the recipient must always be Btwentyfour. The supplier of the sold/returned goods is specified on each item. | |
/b24Message/salesReport/recipient/@gln | Number | Must be a valid EAN13 GLN | 1300 | 4 | ||||
| (Header) : SalesReport Date | Yes | Sales report date. | |
/b24Message/salesReport/documentReference[@documentType="salesReport"]/@date | Must be in the format "YYYY-MM-DD" in C21, and in "YYYYMMDD" in B24s D01B format | 1500 | 6 | |||||
| (Header) : Salesreport Number | Yes | Sales report ID for the EDI transaction. | |
/b24Message/salesReport/documentReference[@documentType="salesReport"]/@id | Text | Must be unique for the business relaitonship | 1400 | 5 | ||||
| (Header) : Sender gln | Yes | The sender of the EDI message, identified by a GLN. | |
/b24Message/salesReport/sender/@gln | Number | Must be a valid EAN13 GLN | 1200 | 3 | ||||
| (Item/Line) : Barcode | Yes | The supplier's EAN/UPC code of the product. | |
/b24Message/salesReport/site/sale/item/itemReference[@registry="Supplier" and @coding!=""] | Number | None | 3200 | 23 | ||||
| (Item/Line) : Brand | No | The brand name of the product. | |
/b24Message/salesReport/site/sale/item/property[@name="brand"] | Text | None | 2200 | 13 | ||||
| (Item/Line) : Buyer's Internal Goodsclass | No | The Buyer's own internal goodsclass code, mapped in the portal | |
/b24Message/salesReport/site/stock/item/property[@name = "goodsClass" and @set = "buyergc" and @registry = "Buyer"]/@code | Text | None | 2700 | 18 | ||||
| (Item/Line) : Color Code | No | The code of the product colour. | |
/b24Message/salesReport/site/sale/item/dimension[@name="color" and @code="colorCode"] | Text | None | 3000 | 21 | ||||
| (Item/Line) : Cost Amount (Return) | No | The retailer's total Cost Of Goods Sold (COGS) for the returned quantity of the product, including VAT. | |
/b24Message/salesReport/site/sale/item/price[@type="costAmountReturn"]@value | Number | None | 4500 | 36 | ||||
| (Item/Line) : Cost Amount (Return) Ex. VAT | No | The retailer's total Cost Of Goods Sold (COGS) for the returned quantity of the product, excluding VAT. | |
/b24Message/salesReport/site/sale/item/price[@type="costAmountReturnExVAT"]@value | Number | None | 6300 | 54 | ||||
| (Item/Line) : Cost Amount (Sales) | No | The retailer's total Cost Of Goods Sold (COGS) for the sold quantity of the product, including VAT. | |
/b24Message/salesReport/site/sale/item/price[@type="costAmountSales"]@value | Number | Must be equal to cost sales price times the sales quantity | 3700 | 28 | ||||
| (Item/Line) : Gross Sales Price | No | The Gross Retail Sales Price for one unit of the sold product, excluding discount/markdown, including VAT. | |
/b24Message/salesReport/site/sale/item/price[@type="grossSalesPrice"]@value | Number | None | 3400 | 25 | ||||
| (Header) : Date From | Yes | The first date the SalesReport covers | |
/b24Message/salesReport/@dateFrom | Number | None | 1000 | 1 | ||||
| (Item/Line) : Cost Price (Return) Ex. VAT | No | The retailer's Cost Of Goods Sold (COGS) for one unit of the returned product, excluding VAT. | |
/b24Message/salesReport/site/sale/item/price[@type="costPriceReturnExVAT"]@value | Number | None | 6400 | 55 | ||||
| (Item/Line) : Cost Price (Sales) | No | The retailer's Cost Of Goods Sold (COGS) for one unit of the sold product, including VAT. | |
/b24Message/salesReport/site/sale/item/price[@type="costPriceSales"]@value | Number | None | 3800 | 29 | ||||
| (Item/Line) : Cost Price (Sales) Ex. VAT | No | The retailer's Cost Of Goods Sold (COGS) for one unit of the sold product, excluding VAT. | |
/b24Message/salesReport/site/sale/item/price[@type="costPriceSalesExVAT"]@value | Number | None | 5600 | 47 | ||||
| (Item/Line) : Fedas Goodsclass | No | Fedas Goodsclass assigned to the product, with 3 different possible registries(party/system that assigned the value), Supplier and Buyer are the only expected registries in a Stockreport | |
/b24Message/salesReport/site/stock/item/property[@name = "goodsClass" and @set = "Fedas"]@code | Text | None | 2800 | 19 | ||||
| (Item/Line) : Gender Category | No | The gender category, such as: Men, Woman, Unisex, Boys/Girls or Kids. | |
/b24Message/salesReport/site/sale/item/property[@name="gender"] | Text | None | 2500 | 16 | ||||
| (Item/Line) : Gross Return Amount | No | The total Return Amount for the sold quantity of the product excluding (possible) fees/charges, including VAT. | |
/b24Message/salesReport/site/sale/item/price[@type="grossReturnAmount"]@value | Number | None | 4400 | 35 | ||||
| (Item/Line) : Gross Return Amount Ex. VAT | No | The total Return Amount for the sold quantity of the product excluding (possible) fees/charges, excluding VAT. | |
/b24Message/salesReport/site/sale/item/price[@type="grossReturnAmountExVAT"]@value | Number | None | 6200 | 53 | ||||
| (Item/Line) : Gross Return Price | No | The Return Price for one unit of the returned product excluding (possible) fees/charges, including VAT. | |
/b24Message/salesReport/site/sale/item/price[@type="grossReturnPrice"]@value | Number | None | 4300 | 34 | ||||
| (Item/Line) : Gross Return Price Ex. VAT | No | The Return Price for one unit of the returned product excluding (possible) fees/charges, excluding VAT. | |
/b24Message/salesReport/site/sale/item/price[@type="grossReturnPriceExVAT"]@value | Number | None | 6100 | 52 | ||||
| (Item/Line) : Gross Sales Amount | No | The total Sales Amount for the sold quantity of the product, excluding discount/markdown, including VAT. | |
/b24Message/salesReport/site/sale/item/price[@type="grossSalesAmount"]@value | Number | Must equal to gross Sales price times the Sales quantity | 3300 | 24 | ||||
| (Item/Line) : Gross Sales Amount Ex. VAT | No | The total Sales Amount for the sold quantity of the product, excluding discount/markdown, excluding VAT. | |
/b24Message/salesReport/site/sale/item/price[@type="grossSalesAmountExVAT"]@value | Number | None | 4700 | 38 | ||||
| (Item/Line) : Gross Sales Amount's VAT amount | No | The gross Sales Amount's VAT Amount | |
/b24Message/salesReport/site/sale/item/price[@type="grossSalesAmountExVAT"]/property[@name = "vatAmount"] | Number | None | 4800 | 39 | ||||
| (Item/Line) : Cost Amount (Sales) Ex. VAT | No | The retailer's total Cost Of Goods Sold (COGS) for the reported quantity of the product, excluding VAT. | |
/b24Message/salesReport/site/sale/item/price[@type="costAmountSalesExVAT"]@value | Number | None | 5500 | 46 | ||||
| (Item/Line) : Gross Sales Price Ex. VAT | No | The Gross Retail Sales Price for one unit of the sold product, excluding discount/markdown, excluding VAT. | |
/b24Message/salesReport/site/sale/item/price[@type="grossSalesPriceExVAT"]@value | Number | None | 4900 | 40 | ||||
| (Item/Line) : Quantity Cancel | No | The quantity of the item cancelled at the site. | |
/b24Message/salesReport/site/sale/item/quantity[@type="Cancel"]@value | Number | None | 6800 | 59 | ||||
| (Item/Line) : Quantity Return | Yes | The returned quantity of the item at the site/store. | |
/b24Message/salesReport/site/sale/item/quantity[@type="Return"]@value | Number | None | 6700 | 58 | ||||
| (Item/Line) : Model Color | No | The supplier's unique model and color ID of the product. | |
/b24Message/salesReport/site/sale/item/property[@name="modelColor"] | Text | None | 2400 | 15 | ||||
| (Item/Line) : Model Number | No | The model number of the product. (suppliers model number) | |
/b24Message/salesReport/site/sale/item/property[@name="modelNo"] | Text | None | 2300 | 14 | ||||
| (Item/Line) : Net Return Amount | No | The total Return Amount for the returned quantity of the product after deduction for (possible) fees/charges, including VAT. | |
/b24Message/salesReport/site/sale/item/price[@type="netReturnAmount"]@value | Number | None | 4200 | 33 | ||||
| (Item/Line) : Net Return Amount Ex. VAT | No | The total Return Amount for the returned quantity of the product after deduction for (possible) fees/charges, excluding VAT. | |
/b24Message/salesReport/site/sale/item/price[@type="netReturnAmountExVAT"]@value | Number | None | 6000 | 51 | ||||
| (Item/Line) : Net Return Price | No | The Return Price for one unit of the returned product after deduction for (possible) fees/charges, including VAT. | |
/b24Message/salesReport/site/sale/item/price[@type="netReturnPrice"]@value | Number | None | 4100 | 32 | ||||
| (Item/Line) : Net Return Price Ex. VAT | No | The Return Price for one unit of the returned product after deduction for (possible) fees/charges, excluding VAT. | |
/b24Message/salesReport/site/sale/item/price[@type="netReturnPriceExVAT"]@value | Number | None | 5900 | 50 | ||||
| (Item/Line) : Net Sales Amount | No | The total Retail Sales Amount for the sold quantity of the product after deducted discount/markdown, including VAT. | |
/b24Message/salesReport/site/sale/item/price[@type="netSalesAmount"]@value | Number | Must be equal to net sales price times the Sales quantity | 3500 | 26 | ||||
| (Item/Line) : Net Sales Amount Ex. VAT | No | The total Sales Amount for the sold quantity of the product after deducted discount/markdown, excluding VAT. | |
/b24Message/salesReport/site/sale/item/price[@type="netSalesAmountExVAT"]@value | Number | None | 5100 | 42 | ||||
| (Item/Line) : Net Sales Amount's VAT Amount | No | The net Sales Amount's VAT Amount | |
/b24Message/salesReport/site/sale/item/price[@type="netSalesAmountExVAT"]/property[@name = "vatAmount"] | Number | None | 5200 | 43 | ||||
| (Item/Line) : Net Sales Price | No | The Retail Sales Price for one unit of the sold product after deducted discount/markdown, including VAT. | |
/b24Message/salesReport/site/sale/item/price[@type="netSalesPrice"]@value | Number | None | 3600 | 27 | ||||
| (Item/Line) : Net Sales Price Ex. VAT | No | The Retail Sales Price for one unit of the sold product after deducted discount/markdown, excluding VAT. | |
/b24Message/salesReport/site/sale/item/price[@type="netSalesPriceExVAT"]@value | Number | None | 5300 | 44 | ||||
| (Item/Line) : Net Sales Price's VAT Amount | No | The net Retail Sales Price's VAT Amount | |
/b24Message/salesReport/site/sale/item/price[@type="netSalesPriceExVAT"]/property[@name = "vatAmount"] | Number | None | 5400 | 45 | ||||
| (Item/Line) : Gross Sales Price's VAT amount | No | The Gross Retail Sales Price's VAT Amount | |
/b24Message/salesReport/site/sale/item/price[@type="grossSalesPriceExVAT"]/property[@name = "vatAmount"] | Number | None | 5000 | 41 | ||||
| (Item/Line) : Item Supplier | Yes | GLN of the supplier/brand of the sold/returned item. | |
/b24Message/salesReport/site/sale/item/supplier/@gln | Number | None | 2900 | 20 | ||||
| (Item/Line) : Quantity Sales | Yes | The gross sales quantity of the item at the site/store. | |
/b24Message/salesReport/site/sale/item/quantity[@type="Sales"]@value | Number | None | 6600 | 57 | ||||
| (Item/Line) : Recommended Retail Price | No | The supplier's Recommended Retail Price for the item at the sales site, including VAT. (used for wholesale) | |
/b24Message/salesReport/site/sale/item/price[@type="recRetailPrice"]@value | Number | None | 4000 | 31 | ||||
| (Item/Line) : Recommended Retail Price Ex. VAT | No | The supplier's Recommended Retail Price for the item at the sales site, excluding VAT. (used for wholesale) | |
/b24Message/salesReport/site/sale/item/price[@type="recRetailPriceExVAT"]@value | Number | None | 5800 | 49 | ||||
| (Item/Line) : Size | No | The size of the item. | |
/b24Message/salesReport/site/sale/item/dimension[@name="size"] | Text | None | 3100 | 22 | ||||
| (Item/Line) : SKU Description | No | The supplier's SKU description for the product. Preferably including: model name, colour and size. | |
/b24Message/salesReport/site/sale/item/property[@name="description"] | Text | None | 2100 | 12 | ||||
| (Item/Line) : Supplier's Internal Goodsclass | No | The Supplier's own internal goodsclass code, mapped in the portal | |
/b24Message/salesReport/site/stock/item/property[@name = "goodsClass" AND @registry = "Supplier" AND @set = "suppliergc"]/@code | Text | None | 2600 | 17 | ||||
| (Item/Line) : VAT Amount | No | Specified VAT-amount for the referred price element with type. | |
/b24Message/salesReport/site/sale/item/price/property[@name="vatAmount"] | Number | None | 6500 | 56 | ||||
| (Item/Line): Discount Amount | No | The deducted discount amount incl. VAT for the reported transaction (difference between grossSalesAmount - netSalesAmount or grossSalesPrice -netSalesPrice). | |
/b24Message/salesReport/site/sale/item/price[@type="discountAmount"]@value | Number | None | 7100 | 62 | ||||
| (Item/Line): Discount Amount Excluding VAT | No | The deducted discount amount excl. VAT for the reported transaction (difference between grossSalesAmountExVAT - netSalesAmountExVAT or grossSalesPriceExVAT - netSalesPriceExVAT) | |
/b24Message/salesReport/site/sale/item/price[@type="discountAmountExVAT "]@value | Number | None | 7200 | 63 | ||||
| (Sale) : Sale ID | Yes | Unique ID of the sale transaction, (typically including terminal+receipt-number). | |
/b24Message/salesReport/site/sale/@id | Text | None | 1900 | 10 | ||||
| (Sale) : Sales Associate | No | ID/Reference of the associate/representative selling the goods to the consumer at the terminal/counter. | |
/b24Message/salesReport/site/sale/@salesAssociate | Text | None | 2000 | 11 | ||||
| (Site) : Sale Date | Yes | Date and time when the sale took place. | |
/b24Message/salesReport/site/sale/@date | Must be in the format "YYYY-MM-DD" in C21, and in "YYYYMMDD" in B24s D01B format | 1800 | 9 | |||||
| (Site) : Site gln | Yes | The store in which the goods were sold, identified by a GLN, Global Location Number Retailer Location Number) | |
/b24Message/salesReport/site/location/@gln | Number | Must be a valid EAN13 GLN | 1700 | 8 |
No fields match your filters.