Sales report as flat file format 1.4
1. Document information
| Message type | Date | Version | Subsets |
| Sales report | 03.05.2016 | 1.3 | Flat file |
| 30.03.2020 | 1.4 | Flat file |
2. Format and content
beeline GmbH offers a flat file format for the sales data transfer. This format is based on rows and separates the itemized data with a semicolon.
Below description shows some optional information which may currently only be provided for our brand TOSH. All other brands to follow soon.
We expect the fields in the following order without headlines and position descriptions:
Pos | Type | Format | Description/Remarks | Examples | Must/Optional |
| 1 | GLN | an13 | GLN or Pseudo-GLN of the partner´s store | 4016632000000 | M |
| 2 | Date | an..35 | Date of sale/return Format: YYYYMMDDHHMMSS Alternative Format: YYYYMMDD | 20150428092659 20150428 | M |
| 3 | Article definition | an..35 | GTIN article code | 4016632118279 | M |
| 4 | Brand ID | n..2 | Brand ID 1 = SIX 2 = ACC/White Label 3 = IAM 5 = TOSH | 1 | O |
| 5 | Quantity | an..15 | Quantity of articles for each retail price. Returns need to be indicated with negative quantity. If negative quantity is indicated, please fill in Pos 13 | 1 | M |
| 6 | Gross selling price | n..15 | Single selling price (minus sales discount and incl. VAT), always positive even for returned quantities | 5,95 or 5.95 | M |
| 7 | Currency | an3 | Currency code ISO 4217 | EUR | M |
| 8 | Cash desk number | an..10 | Identifier of cash desk/till | 1234567890 | O |
| 9 | Discount type | n..4 | Type of discount if price is reduced in Pos 5, blanc if no discount applies. 1 = Employee discount 2 = Customer discount | 1 | O |
| 10 | Promo | an..1 | In case of promotion took place, please indicate promo number 0 = no 1 = yes | 1 | O |
| 11 | Promo Type | an..4 | Promotion type in case promotion took place, Pos 9 is filled. | 4 | O |
| 12 | Customer reference | an...40 | Please indicate reference to be linked to, e.g. purchase Order ID, Receiving Note ID... | 123456gfh0147258369g123456gfh0147258369g | O |
| 13 | Receipt number | an..20 | Cash desk / till receipt number | 12345678901234567890 | O |
| 14 | Retoure reason | n..4 | Reason of return, pleae indicate in case pos 4 is negative | Did Not Meet Customer’s Expectations. | O |
The specification at position 1 must always be 13 characters long, as is the case with a GLN. If no GLN exists, you can use a store numberer that is extended to 13 characters by a prefix agreed with beeline (more information on this pseudo GLN here).
If a GTIN is specified in position 3, position 4 can remain empty.
3. sample sales report in flatfile format:
Flatfile sales report
Flatfile sales report with timestamp
Test Barcodes (matching sample messages)
4. Return OF SINGLE SALE
For returned articles return, the indicated amount needs to be negative. The price indication must be positive.
Example:
4016632000000;20061231;4016632118279;;-2;5,95;EUR
In combination with articles which are returned, it is necessary to quote the price and the discount price, too.
5. Legend of the flat file format
Element | Definition | Example |
| Format | ||
| n | numeric | n3 = exact 3 numeric positions n...35 = up to 35 numeric positions |
| an | alphanumeric | an12 = exakt 12 alphanumeric positions an...35 = bis zu 35 alphanumeric positions |
| Status | ||
| M | must | M |
| O | optional | O |