SLSRPT (Sales Report)
The SLSRPT message intent is to provide sales information for one or more locations for a series of products within a specified time period.
General usage
- The message is transmitted either from a seller to its supplier or from a headquarters, coordination or distribution centre to a manufacturer, supplier or a third party for statistical analysis.
- It allows the recipient 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 SLSRPT message
Id | Name | Required | Description | Examples | XPATH | Edifact_Path | Edifact_Qualifiers | Edifact_Sample | Type | Limits | Sort |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | Sender gln | Yes | The sender of the EDI message, identified by a GLN. |
|
/b24Message/salesReport/sender/#gln | UNB.S002.0004 | UNB.S002.0007 = 14 | UNB+UNOY:3+7340117852868:14+7340117852851:14+230102:0935' | Number | Must be a valid EAN13 GLN |
1 |
2 | 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, either "0000000000010" as in the xml sample for the test environment or "7340117802900" for our production environment". |
|
/b24Message/salesReport/recipient/#gln | UNB.S003.0010 | UNB.S003.0007 = 14 | UNB+UNOY:3+7340117852868:14+0000000000010:14+230102:0935' |
Number | Must be a valid EAN13 GLN |
2 |
3 | Salesreport Number | Yes | Sales report ID for the whole transaction. |
|
/b24Message/salesReport/documentReference[@documentType="salesReport"]/@id | SLSRPT.BGM.C106.1004, & SLSRPT.RFF.C506.1154 | SLSRPT.BGM.C002.1001 = "75E", BGM.1225 = 9 , & SLSRPT.RFF.C506.1153 = "ALS" | BGM+75E+SAL-123+9' & RFF+ALS:SAL-123' | Text | Must be unique for the business relaitonship |
3 |
4 | SalesReport Date | Yes | Sales report date. |
|
/b24Message/salesReport/documentReference[@documentType="salesReport"]/@date | SLSRPT.RFF.DTM.C507.2380 | SLSRPT.RFF.C506.1153 = SS, SLSRPT.RFF.DTM.C507.2005 = 127 | RFF+ALS:SAL-123' DTM+127:20180321:102' | Date/Time | Must be in the format "YYYY-MM-DD" in C21, and in "YYYYMMDD" in B24s D01B format |
4 |
5 | Buyer gln | Yes | The buyer, identified by a GLN. |
|
/b24Message/salesReport/buyer/#gln | SLSRPT.NAD.C082.3039 | SLSRPT.NAD.3055 = BY | NAD+BY+7340117852868::9' | Number | Must be a valid EAN13 GLN |
5 |
6 | Site gln | Yes | The store in which the goods were sold, identified by a GLN. |
|
/b24Message/salesReport/site/location/#gln | SLSRPT.LOC.C517.3225 | SLSRPT.LOC.3227 = 14 | LOC+14+4444444444444' | Number | Must be a valid EAN13 GLN |
6 |
7 | Sale Date | Yes | Date and time when the sale took place. |
|
/b24Message/salesReport/site/sale/#date | SLSRPT.LOC.LIN.DTM.C507.2380 | SLSRPT.DTM.C507.2005 = 356 | DTM+356:20150517:102' | Date/Time | Must be in the format "YYYY-MM-DD" in C21, and in "YYYYMMDD" in B24s D01B format |
7 |
8 | Sale ID | Yes | Unique ID of the sale transaction, (typically including terminal+receipt-number). |
|
/b24Message/salesReport/site/sale/#id | SLSRPT.LOC.LIN.RFF.C506.1154 | SLSRPT.LOC.LINF.C506.1153 = SS | RFF+SS:1_19_201505' | Text | None |
8 |
9 | Sales Associate | No | ID/Reference of the associate/representative selling the goods to the consumer at the terminal/counter. |
|
/b24Message/salesReport/site/sale/#salesAssociate | SLSRPT.LOC.LIN.RFF.C506.1154 | SLSRPT.RFF.C506.1153= SA | RFF+SA:987880' | Text | None |
9 |
10 | 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"] | SLSRPT.LOC.LIN.IMD.C273.7008 | SLSRPT.LOC.LIN.IMD.7077 = F, SLSRPT.LOC.LIN.IMD.C272.7081 = DSC, SLSRPT.LOC.LIN.IMD.C273.3055 = sRegistry[91 = Supplier, 92 = Buyer, B24 = Btwentyfour] |
IMD+F+DSC+:::Sun Cap-Yellow-OneSize' | Text | None |
10 |
11 | Brand | No | The brand name of the product. |
|
/b24Message/salesReport/site/sale/item/property[@name="brand"] | SLSRPT.LOC.LIN.IMD.C273.7008 | SLSRPT.LOC.LIN.IMD.7077 = F, SLSRPT.LOC.LIN.IMD.C272.7081 = BRN, SLSRPT.LOC.LIN.IMD.C273.3055 = sRegistry[91 = Supplier, 92 = Buyer, B24 = Btwentyfour] |
IMD+F+BRN+::91:BrandWear' | Text | None |
11 |
12 | Model Number | No | The model number of the product. (suppliers model number) |
|
/b24Message/salesReport/site/sale/item/property[@name="modelNo"] | SLSRPT.LOC.LIN.PIA.C212.7140 | SLSRPT.LOC.LIN.PIA.4347 = 5, SLSRPT.LOC.LIN.PIA.C212.7143 = MCI, SLSRPT.LOC.LIN.PIA.C212.3055 [Registry[91 = Supplier, 92 = Buyer, B24 = Btwentyfour] |
PIA+1+45678:MN::91' | Text | None |
12 |
13 | Model Color | No | The supplier's unique model and color ID of the product. |
|
/b24Message/salesReport/site/sale/item/property[@name="modelColor"] | SLSRPT.LOC.LIN.PIA.C212.7140 | SLSRPT.LOC.LIN.PIA.4347 = 5, SLSRPT.LOC.LIN.PIA.C212.7143 = MN, SLSRPT.LOC.LIN.PIA.C212.3055 [Registry[91 = Supplier, 92 = Buyer, B24 = Btwentyfour] |
PIA+1+45378-511:MCI::91' | Text | None |
13 |
14 | Gender Category | No | The gender category, such as: Men, Woman, Unisex, Boys/Girls or Kids. |
|
/b24Message/salesReport/site/sale/item/property[@name="gender"] | SLSRPT.LOC.LIN.IMD.C273.7008 | SLSRPT.LOC.LIN.IMD.7077 = F, SLSRPT.LOC.LIN.IMD.C272.7081 = GEN, SLSRPT.LOC.LIN.IMD.C273.3055 = sRegistry[91 = Supplier, 92 = Buyer, B24 = Btwentyfour] |
IMD+F+GEN+::91:UNISEX' | Text | None |
14 |
15 | Supplier's Internal Goodsclass | No | The Supplier's own internal goodsclass code, mapped in the portal |
|
/b24Message/stockReport/site/stock/item/property[@name = "goodsClass" AND @registry = "Supplier" AND @set = "suppliergc"]/@code | SLSRPT.LOC.LIN.PIA.C212.7140 | SLSRPT.LOC.LIN.PIA.C212.7143 = SGC, INVRPT.LIN.PIA.C212.3055 = 91 | PIA+5+275011:SGC::91' | Text | None |
15 |
16 | Buyer's Internal Goodsclass | No | The Buyer's own internal goodsclass code, mapped in the portal |
|
/b24Message/stockReport/site/stock/item/property[@name = "goodsClass" and @set = "buyergc" and @registry = "Buyer"]/@code | SLSRPT.LOC.LIN.PIA.C212.7140 | SLSRPT.LOC.LIN.PIA.C212.7143 = GC, INVRPT.LIN.PIA.C212.3055 = 92 | PIA+5+275011:GB::92' | Text | None |
16 |
17 | 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/stockReport/site/stock/item/property[@name = "goodsClass" and @set = "Fedas"]@code | SLSRPT.LOC.LIN.PIA.C212.7140 | SLSRPT.LOC.LIN.PIA.C212.7143 = GD, INVRPT.LIN.PIA.C212.3055 =Registry[91 = Supplier, 92 = Buyer, B24 = b24] | PIA+5+275011:GD::B24' | Text | None |
17 |
18 | Item Supplier | Yes | GLN of the supplier/brand of the sold/returned item. |
|
/b24Message/salesReport/site/sale/item/supplier/#gln | SLSRPT.LOC.LIN.NAD.C082.3039 | SLSRPT.LOC.LIN.NAD.3055 = SU | NAD+SU+7340117852851::9' | Number | None |
18 |
19 | Color Code | No | The code of the product colour. |
|
/b24Message/salesReport/site/sale/item/dimension[@name="color" and @code="colorCode"] | SLSRPT.LOC.LIN.IMD.C273.7008 | SLSRPT.LOC.LIN.IMD.7077 = C, SLSRPT.LOC.LIN.IMD.C272.7081 = 35, SLSRPT.LOC.LIN.IMD.C273.3055 = sRegistry[91 = Supplier, 92 = Buyer, B24 = Btwentyfour] |
IMD+C+35+:::511' | Text | None |
19 |
20 | Size | No | The size of the item. |
|
/b24Message/salesReport/site/sale/item/dimension[@name="size"] | SLSRPT.LOC.LIN.IMD.C273.7008 | SLSRPT.LOC.LIN.IMD.7077 = F, SLSRPT.LOC.LIN.IMD.C272.7081 = 98, SLSRPT.LOC.LIN.IMD.C273.3055 = sRegistry[91 = Supplier, 92 = Buyer, B24 = Btwentyfour] |
IMD+F+35+:::Yellow' | Text | None |
20 |
21 | Barcode | Yes | The supplier's EAN/UPC code of the product. |
|
/b24Message/salesReport/site/sale/item/itemReference[@registry="Supplier" and @coding!=""] | SLSRPT.LOC.LIN.C212.7140 | SLSRPT.LOC.LIN..C212.7143 = barcodetype[ EN = EAN13, UP = UPCA] | LIN+1++4561234561234:EN::91' | Number | None |
21 |
22 | 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 | SLSRPT.LOC.LIN.PRI.C509.5118 | SLSRPT.LOC.LIN.SLSRPT.LOC.LIN.PRI.C509.5125 = GSA, SLSRPT.LOC.LIN.PRI.C509.5387 = VAL, SLSRPT.LOC.LIN.PRI.CUX.C504[1].6345 = Price currency, SLSRPT.LOC.LIN.PRI.CUX.C505[1].6347 = 2 | PRI+GSA:897.00::VAL' | Number | Must equal to gross Sales price times the Sales quantity |
22 |
23 | Gross Sales Price | No | The Sales Price for one unit of the sold product, excluding discount/markdown, including VAT. |
|
/b24Message/salesReport/site/sale/item/price[@type="grossSalesPrice"]@value | SLSRPT.LOC.LIN.PRI.C509.5118 | SLSRPT.LOC.LIN.SLSRPT.LOC.LIN.PRI.C509.5125 = NSP, SLSRPT.LOC.LIN.PRI.C509.5387 = VAL, SLSRPT.LOC.LIN.PRI.CUX.C504[1].6345 = Price currency, SLSRPT.LOC.LIN.PRI.CUX.C505[1].6347 = 2 | PRI+GSP:299.00::VAL' | Number | None |
23 |
24 | Net Sales Amount | No | The total Sales Amount for the sold quantity of the product after deducted discount/markdown, including VAT. |
|
/b24Message/salesReport/site/sale/item/price[@type="netSalesAmount"]@value | SLSRPT.LOC.LIN.PRI.C509.5118 | SLSRPT.LOC.LIN.SLSRPT.LOC.LIN.PRI.C509.5125 = NSA, , SLSRPT.LOC.LIN.PRI.C509.5387 = VAL, SLSRPT.LOC.LIN.PRI.CUX.C504[1].6345 = Price currency, SLSRPT.LOC.LIN.PRI.CUX.C505[1].6347 = 2 | PRI+NSA:747.51::VAL' | Number | Must be equal to net sales price times the Sales quantity |
24 |
25 | Net Sales Price | No | The Sales Price for one unit of the sold product after deducted discount/markdown, including VAT. |
|
/b24Message/salesReport/site/sale/item/price[@type="netSalesPrice"]@value | SLSRPT.LOC.LIN.PRI.C509.5118 | SLSRPT.LOC.LIN.PRI.C509.5125 = NSP, SLSRPT.LOC.LIN.PRI.C509.5387 = VAL, SLSRPT.LOC.LIN.PRI.CUX.C504[1].6345 = Price currency, SLSRPT.LOC.LIN.PRI.CUX.C505[1].6347 = 2 | PRI+NSP:249.17::VAL' | Number | None |
25 |
26 | 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 | SLSRPT.LOC.LIN.PRI.C509.5118 | SLSRPT.LOC.LIN.PRI.C509.5125 = CSA, SLSRPT.LOC.LIN.PRI.C509.5387 = VAL, SLSRPT.LOC.LIN.PRI.CUX.C504[1].6345 = Price currency, SLSRPT.LOC.LIN.PRI.CUX.C505[1].6347 = 2 | PRI+CSA:180.00::VAL' | Number | Must be equal to cost sales price times the sales quantity |
26 |
27 | 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 | SLSRPT.LOC.LIN.PRI.C509.5118 | SLSRPT.LOC.LIN.PRI.C509.5125 = CSP, SLSRPT.LOC.LIN.PRI.C509.5387 = VAL, SLSRPT.LOC.LIN.PRI.CUX.C504[1].6345 = Price currency, SLSRPT.LOC.LIN.PRI.CUX.C505[1].6347 = 2 | PRI+CSP:90.00::VAL' | Number | None |
27 |
28 | Retail Price | No | The set Retail Price for the product at the sales site, including VAT. (used for concession/consignment) |
|
/b24Message/salesReport/site/sale/item/price[@type="retailPrice"]@value | SLSRPT.LOC.LIN.PRI.C509.5118 | SLSRPT.LOC.LIN.PRI.C509.5125 = FSP, SLSRPT.LOC.LIN.PRI.C509.5387 = VAL, SLSRPT.LOC.LIN.PRI.CUX.C504[1].6345 = Price currency, SLSRPT.LOC.LIN.PRI.CUX.C505[1].6347 = 2 | PRI+FSP:299.00::VAL' | Number | None |
28 |
29 | 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 | SLSRPT.LOC.LIN.PRI.C509.5118 | SLSRPT.LOC.LIN.PRI.C509.5125 = NRA, SLSRPT.LOC.LIN.PRI.C509.5387 = VAL, SLSRPT.LOC.LIN.PRI.CUX.C504[1].6345 = Price currency, SLSRPT.LOC.LIN.PRI.CUX.C505[1].6347 = 2 | PRI+FSP:299.00::VAL' | Number | None |
29 |
30 | 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 | SLSRPT.LOC.LIN.PRI.C509.5118 | SLSRPT.LOC.LIN.PRI.C509.5125 = NRP, SLSRPT.LOC.LIN.PRI.C509.5387 = VAL, SLSRPT.LOC.LIN.PRI.CUX.C504[1].6345 = Price currency, SLSRPT.LOC.LIN.PRI.CUX.C505[1].6347 = 2 | PRI+NRP:271.82::VAL' | Number | None |
30 |
31 | 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 | SLSRPT.LOC.LIN.PRI.C509.5118 | SLSRPT.LOC.LIN.PRI.C509.5125 = NRA, SLSRPT.LOC.LIN.PRI.C509.5387 = VAL, SLSRPT.LOC.LIN.PRI.CUX.C504[1].6345 = Price currency, SLSRPT.LOC.LIN.PRI.CUX.C505[1].6347 = 2 | PRI+NRA:543.64::VAL' | Number | None |
31 |
32 | 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 | SLSRPT.LOC.LIN.PRI.C509.5118 | SLSRPT.LOC.LIN.PRI.C509.5125 = GRP, SLSRPT.LOC.LIN.PRI.C509.5387 = VAL, SLSRPT.LOC.LIN.PRI.CUX.C504[1].6345 = Price currency, SLSRPT.LOC.LIN.PRI.CUX.C505[1].6347 = 2 | PRI+GRP:299.00::VAL' | Number | None |
32 |
33 | 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 | SLSRPT.LOC.LIN.PRI.C509.5118 | SLSRPT.LOC.LIN.PRI.C509.5125 = GRA, SLSRPT.LOC.LIN.PRI.C509.5387 = VAL, SLSRPT.LOC.LIN.PRI.CUX.C504[1].6345 = Price currency, SLSRPT.LOC.LIN.PRI.CUX.C505[1].6347 = 2 | PRI+GRA:598.00::VAL' | Number | None |
33 |
34 | 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 | SLSRPT.LOC.LIN.PRI.C509.5118 | SLSRPT.LOC.LIN.PRI.C509.5125 = CSA, SLSRPT.LOC.LIN.PRI.C509.5387 = VAL, SLSRPT.LOC.LIN.PRI.CUX.C504[1].6345 = Price currency, SLSRPT.LOC.LIN.PRI.CUX.C505[1].6347 = 2 | PRI+CRA:180.00::VAL' | Number | None |
34 |
35 | 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 | SLSRPT.LOC.LIN.PRI.C509.5118 | SLSRPT.LOC.LIN.PRI.C509.5125 = CSP, SLSRPT.LOC.LIN.PRI.C509.5387 = VAL, SLSRPT.LOC.LIN.PRI.CUX.C504[1].6345 = Price currency, SLSRPT.LOC.LIN.PRI.CUX.C505[1].6347 = 2 | PRI+CRP:90.00::VAL' | Number | None |
35 |
36 | 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 | SLSRPT.LOC.LIN.PRI.C509.5118 | SLSRPT.LOC.LIN.PRI.C509.5125 = GSW, SLSRPT.LOC.LIN.PRI.C509.5387 = VAL, SLSRPT.LOC.LIN.PRI.CUX.C504[1].6345 = Price currency, SLSRPT.LOC.LIN.PRI.CUX.C505[1].6347 = 2 | PRI+GSW:717.60::VAL' |
Number | None |
36 |
37 | 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"] | SLSRPT.LOC.LIN.PRI.C509.5118 | SLSRPT.LOC.LIN.PRI.C509.5125 = GSW,SLSRPT.LOC.LIN.PRI.C509.5387 = VAT, SLSRPT.LOC.LIN.PRI.CUX.C504[1].6345 = Price currency, SLSRPT.LOC.LIN.PRI.CUX.C505[1].6347 = 2 | PRI+GSW:179.40::VAT' |
Number | None |
37 |
38 | Gross Sales Price Ex. VAT | No | The Sales Price for one unit of the sold product, excluding discount/markdown, excluding VAT. |
|
/b24Message/salesReport/site/sale/item/price[@type="grossSalesPriceExVAT"]@value | SLSRPT.LOC.LIN.PRI.C509.5118 | SLSRPT.LOC.LIN.PRI.C509.5125 = GSV,SLSRPT.LOC.LIN.PRI.C509.5387 = VAL, SLSRPT.LOC.LIN.PRI.CUX.C504[1].6345 = Price currency, SLSRPT.LOC.LIN.PRI.CUX.C505[1].6347 = 2 | PRI+GSV:239.20::VAL' | Number | None |
38 |
39 | Gross Sales Price's VAT amount | No | The gross Sales Price's VAT Amount |
|
/b24Message/salesReport/site/sale/item/price[@type="grossSalesPriceExVAT"]/property[@name = "vatAmount"] | SLSRPT.LOC.LIN.PRI.C509.5118 | SLSRPT.LOC.LIN.PRI.C509.5125 = GSV,SLSRPT.LOC.LIN.PRI.C509.5387 = VAT, SLSRPT.LOC.LIN.PRI.CUX.C504[1].6345 = Price currency, SLSRPT.LOC.LIN.PRI.CUX.C505[1].6347 = 2 | PRI+GSV:59.80::VAT' |
Number | None |
39 |
40 | 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 | SLSRPT.LOC.LIN.PRI.C509.5118 | SLSRPT.LOC.LIN.PRI.C509.5125 = NSW, SLSRPT.LOC.LIN.PRI.C509.5387 = VAL, SLSRPT.LOC.LIN.PRI.CUX.C504[1].6345 = Price currency, SLSRPT.LOC.LIN.PRI.CUX.C505[1].6347 = 2 | PRI+NSW:598.01::VAL' | Number | None |
40 |
41 | 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"] | SLSRPT.LOC.LIN.PRI.C509.5118 | SLSRPT.LOC.LIN.PRI.C509.5125 = NSW, SLSRPT.LOC.LIN.PRI.C509.5387 = VAT, SLSRPT.LOC.LIN.PRI.CUX.C504[1].6345 = Price currency, SLSRPT.LOC.LIN.PRI.CUX.C505[1].6347 = 2 | PRI+NSW:149.50::VAT' |
Number | None |
41 |
42 | Net Sales Price Ex. VAT | No | The Sales Price for one unit of the sold product after deducted discount/markdown, excluding VAT. |
|
/b24Message/salesReport/site/sale/item/price[@type="netSalesPriceExVAT"]@value | SLSRPT.LOC.LIN.PRI.C509.5118 | SLSRPT.LOC.LIN.PRI.C509.5125 = CSV, SLSRPT.LOC.LIN.PRI.C509.5387 = VAL, SLSRPT.LOC.LIN.PRI.CUX.C504[1].6345 = Price currency, SLSRPT.LOC.LIN.PRI.CUX.C505[1].6347 = 2 | PRI+NSV:199.34::VAL' | Number | None |
42 |
43 | Net Sales Price's VAT Amount | No | The net Sales Price's VAT Amount |
|
/b24Message/salesReport/site/sale/item/price[@type="netSalesPriceExVAT"]/property[@name = "vatAmount"] | SLSRPT.LOC.LIN.PRI.C509.5118 | SLSRPT.LOC.LIN.PRI.C509.5125 = CSV, SLSRPT.LOC.LIN.PRI.C509.5387 = VAT, SLSRPT.LOC.LIN.PRI.CUX.C504[1].6345 = Price currency, SLSRPT.LOC.LIN.PRI.CUX.C505[1].6347 = 2 | PRI+NSV:49.83::VAT' |
Number | None |
43 |
44 | 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 | SLSRPT.LOC.LIN.PRI.C509.5118 | SLSRPT.LOC.LIN.PRI.C509.5125 = CSW, SLSRPT.LOC.LIN.PRI.C509.5387 = VAL, SLSRPT.LOC.LIN.PRI.CUX.C504[1].6345 = Price currency, SLSRPT.LOC.LIN.PRI.CUX.C505[1].6347 = 2 | PRI+CSW:144.00::VAL' | Number | None |
44 |
45 | 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 | SLSRPT.LOC.LIN.PRI.C509.5118 | SLSRPT.LOC.LIN.PRI.C509.5125 = CSV,,SLSRPT.LOC.LIN.PRI.C509.5387 = VAL, SLSRPT.LOC.LIN.PRI.CUX.C504[1].6345 = Price currency, SLSRPT.LOC.LIN.PRI.CUX.C505[1].6347 = 2 | PRI+CSV:72.00::VAL' | Number | None |
45 |
46 | Retail Price Ex. VAT | No | The set Retail Price for the product at the sales site, excluding VAT. (used for concession/consignment) |
|
/b24Message/salesReport/site/sale/item/price[@type="retailPriceExVAT"]@value | SLSRPT.LOC.LIN.PRI.C509.5118 | SLSRPT.LOC.LIN.PRI.C509.5125 = FSP,SLSRPT.LOC.LIN.PRI.C509.5387 = VAL, SLSRPT.LOC.LIN.PRI.CUX.C504[1].6345 = Price currency, SLSRPT.LOC.LIN.PRI.CUX.C505[1].6347 = 2 | PRI+FSV:239.20::VAL' | Number | None |
46 |
47 | 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 | SLSRPT.LOC.LIN.PRI.C509.5118 | SLSRPT.LOC.LIN.PRI.C509.5125 = RSP, SLSRPT.LOC.LIN.PRI.C509.5118 = Recommended Retail SLSRPT.LOC.LIN.PRIce,SLSRPT.LOC.LIN.PRI.C509.5387 = VAL, SLSRPT.LOC.LIN.PRI.CUX.C504[1].6345 = Price currency, SLSRPT.LOC.LIN.PRI.CUX.C505[1].6347 = 2 | PRI+RSV:240.00::VAL' | Number | None |
47 |
48 | 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 | SLSRPT.LOC.LIN.PRI.C509.5118 | SLSRPT.LOC.LIN.PRI.C509.5125 = NRV, SLSRPT.LOC.LIN.PRI.C509.5387 = VAL, SLSRPT.LOC.LIN.PRI.CUX.C504[1].6345 = Price currency, SLSRPT.LOC.LIN.PRI.CUX.C505[1].6347 = 2 | PRI+NRV:217.46::VAL' | Number | None |
48 |
49 | 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 | SLSRPT.LOC.LIN.PRI.C509.5118 | SLSRPT.LOC.LIN.PRI.C509.5125 = NRW, SLSRPT.LOC.LIN.PRI.C509.5387 = VAL, SLSRPT.LOC.LIN.PRI.CUX.C504[1].6345 = Price currency, SLSRPT.LOC.LIN.PRI.CUX.C505[1].6347 = 2 | PRI+NRW:434.91::VAL' | Number | None |
49 |
50 | 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 | SLSRPT.LOC.LIN.PRI.C509.5118 | SLSRPT.LOC.LIN.PRI.C509.5125 = GRV,SLSRPT.LOC.LIN.PRI.C509.5387 = VAL, SLSRPT.LOC.LIN.PRI.CUX.C504[1].6345 = Price currency, SLSRPT.LOC.LIN.PRI.CUX.C505[1].6347 = 2 | PRI+GRV:239.20::VAL' | Number | None |
50 |
51 | 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 | SLSRPT.LOC.LIN.PRI.C509.5118 | SLSRPT.LOC.LIN.PRI.C509.5125 = GRW,SLSRPT.LOC.LIN.PRI.C509.5387 = VAL, SLSRPT.LOC.LIN.PRI.CUX.C504[1].6345 = Price currency, SLSRPT.LOC.LIN.PRI.CUX.C505[1].6347 = 2 | PRI+GRW:478.40::VAL' | Number | None |
51 |
52 | 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 | SLSRPT.LOC.LIN.PRI.C509.5118 | SLSRPT.LOC.LIN.PRI.C509.5125 = CRW,,SLSRPT.LOC.LIN.PRI.C509.5387 = VAL, SLSRPT.LOC.LIN.PRI.CUX.C504[1].6345 = Price currency, SLSRPT.LOC.LIN.PRI.CUX.C505[1].6347 = 2 | PRI+CRW:144.00::VAL' | Number | None |
52 |
53 | 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 | SLSRPT.LOC.LIN.PRI.C509.5118 | SLSRPT.LOC.LIN.PRI.C509.5125 = CRV, ,SLSRPT.LOC.LIN.PRI.C509.5387 = VAL, SLSRPT.LOC.LIN.PRI.CUX.C504[1].6345 = Price currency, SLSRPT.LOC.LIN.PRI.CUX.C505[1].6347 = 2 | PRI+CRV:72.00::VAL' | Number | None |
53 |
54 | VAT Amount | No | Specified VAT-amount for the referred price element with type. |
|
/b24Message/salesReport/site/sale/item/price/property[@name="vatAmount"] | SLSRPT.LOC.LIN.PRI.C509.5118 | SLSRPT.LOC.LIN.PRI.C509.5125 = NRW, SLSRPT.LOC.LIN.PRI.C509.5387 = VAT, SLSRPT.LOC.LIN.PRI.CUX.C504[1].6345 = Price currency, SLSRPT.LOC.LIN.PRI.CUX.C505[1].6347 = 2 |
PRI+CRV:72.00::VAT' | Number | None |
54 |
55 | Quantity Sales | Yes | The quantity of the item sold at the site. |
|
/b24Message/salesReport/site/sale/item/quantity[@type="Sales"]@value | SLSRPT.LOC.LIN.QTY.C186.6060 | SLSRPT.LOC.LIN.QTY.C186.6063=153 SLSRPT.LOC.LIN.QTY.C186.6411 = sUnitOfMeasure; |
QTY+153:3' | Number | None |
55 |
56 | Quantity Return | Yes | The quantity of the item returned at the site. |
|
/b24Message/salesReport/site/sale/item/quantity[@type="Return"]@value | SLSRPT.LOC.LIN.QTY.C186.6060 | SLSRPT.LOC.LIN.QTY.C186.6063 = 61 SLSRPT.LOC.LIN.QTY.C186.6411 = sUnitOfMeasure; |
QTY+61:2' | Number | None |
56 |
57 | Quantity Cancel | No | The quantity of the item cancelled at the site. |
|
/b24Message/salesReport/site/sale/item/quantity[@type="Cancel"]@value | SLSRPT.LOC.LIN.QTY.C186.6060 | SLSRPT.LOC.LIN.QTY.C186.6063 = 182 SLSRPT.LOC.LIN.QTY.C186.6411 = sUnitOfMeasure; |
QTY+182:1' | Number | None |
57 |
58 | (Item): 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 | N/A | N/A | N/A |
Number | 58 | |
59 | (Item): 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 | N/A | N/A | N/A |
Number | 59 |