beeline group EDI

Sales report as flat file format 1.4

 

Message type Date Version Subsets
Sales report 03.05.2016 1.3 Flat file
  30.03.2020 1.4 Flat file

 

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.

 

Flatfile sales report 
Flatfile sales report with timestamp 

Test Barcodes (matching sample messages)

 

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.

 

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