beeline group EDI
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. Legend
| 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 |
3. 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 |
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.
4. Sample sales report in flatfile format:
Flatfile sales report
Flatfile sales report with timestamp
5. 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.