SLSRPT (Sales Report)

The first date the SalesReport covers

The last date the SalesReport covers

The sender of the EDI message, identified by a GLN.

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.

Sales report ID for the EDI transaction.

Sales report date.

The buyer, identified by a GLN.

The store in which the goods were sold, identified by a GLN, Global Location Number (Retailer Location Number)

Date and time when the sale took place.

Unique ID of the sale transaction, (typically including terminal+receipt-number).

ID/Reference of the associate/representative selling the goods to the consumer at the terminal/counter.

The supplier's SKU description for the product. Preferably including: model name, colour and size.

The brand name of the product.

The model number of the product. (suppliers model number)

The supplier's unique model and color ID of the product.

The gender category, such as: Men, Woman, Unisex, Boys/Girls or Kids.

The Supplier's own internal goodsclass code, mapped in the portal

The Buyer's own internal goodsclass code, mapped in the portal

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

GLN of the supplier/brand of the sold/returned item.

The code of the product colour.

The size of the item.

The supplier's EAN/UPC code of the product.

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.

The total Sales Amount for the sold quantity of the product, excluding discount/markdown, including VAT.

The Gross Retail Sales Price for one unit of the sold product, excluding discount/markdown, including VAT.

The total Retail Sales Amount for the sold quantity of the product after deducted discount/markdown, including VAT.

The Retail Sales Price for one unit of the sold product after deducted discount/markdown, including VAT.

The retailer's total Cost Of Goods Sold (COGS) for the sold quantity of the product, including VAT.

The retailer's Cost Of Goods Sold (COGS) for one unit of the sold product, including VAT.

The supplier's Recommended Retail Price for the item at the sales site, including VAT. (used for wholesale)

The Return Price for one unit of the returned product after deduction for (possible) fees/charges, including VAT.

The total Return Amount for the returned quantity of the product after deduction for (possible) fees/charges, including VAT.

The Return Price for one unit of the returned product excluding (possible) fees/charges, including VAT.

The total Return Amount for the sold quantity of the product excluding (possible) fees/charges, including VAT.

The retailer's total Cost Of Goods Sold (COGS) for the returned quantity of the product, including VAT.

The retailer's Cost Of Goods Sold (COGS) for one unit of the returned product, including VAT.

The total Sales Amount for the sold quantity of the product, excluding discount/markdown, excluding VAT.

The gross Sales Amount's VAT Amount

The Gross Retail Sales Price for one unit of the sold product, excluding discount/markdown, excluding VAT.

The Gross Retail Sales Price's VAT Amount

The total Sales Amount for the sold quantity of the product after deducted discount/markdown, excluding VAT.

The net Sales Amount's VAT Amount

The Retail Sales Price for one unit of the sold product after deducted discount/markdown, excluding VAT.

The net Retail Sales Price's VAT Amount

The retailer's total Cost Of Goods Sold (COGS) for the reported quantity of the product, excluding VAT.

The retailer's Cost Of Goods Sold (COGS) for one unit of the sold product, excluding VAT.

The supplier's Recommended Retail Price for the item at the sales site, excluding VAT. (used for wholesale)

The Return Price for one unit of the returned product after deduction for (possible) fees/charges, excluding VAT.

The total Return Amount for the returned quantity of the product after deduction for (possible) fees/charges, excluding VAT.

The Return Price for one unit of the returned product excluding (possible) fees/charges, excluding VAT.

The total Return Amount for the sold quantity of the product excluding (possible) fees/charges, excluding VAT.

The retailer's total Cost Of Goods Sold (COGS) for the returned quantity of the product, excluding VAT.

The retailer's Cost Of Goods Sold (COGS) for one unit of the returned product, excluding VAT.

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.

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.

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.

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.

Specified VAT-amount for the referred price element with type.

The gross sales quantity of the item at the site/store.

The returned quantity of the item at the site/store.

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.

The quantity of the item cancelled at the site.

The deducted discount amount incl. VAT for the reported transaction (difference between grossSalesAmount - netSalesAmount or grossSalesPrice -netSalesPrice).

The deducted discount amount excl. VAT for the reported transaction (difference between grossSalesAmountExVAT - netSalesAmountExVAT or grossSalesPriceExVAT - netSalesPriceExVAT)