Despatch advice data flatfile V1.3
1. Document information
Message type | Date | Version | Subsets |
Despatchadvice data | 18.09.2018 | 1.2 | Flat file |
30.03.2020 | 1.3 | Flat file |
2. Format and content
Upon request, beeline GmbH offers a flat file format for the deliver note transfer. This format is based on rows and separates the itemized data with a semicolon. It does not contain a headline with position descriptions.
Below description shows some optional information which may currently only provided for our brand TOSH. All other brands to follow soon.
The data is transferred in one row with the following order:
Pos | Type | Format | Description/Remarks | Example | Muss/Optional | |
1 | Delivery Note Number | an13 | beeline internal delivery note reference number | 43299861 | M | |
2 | Order Number | n14 | beeline internal order reference number | 30637280 | M | |
3 | Store GLN | an13 | GLN or Pseudo-GLN of the partner´s store | GLN00000000013 | M | |
4 | Release Date | n14 | Release date of delivery note Format: "YYYYMMDDHHMMSS" | 20101103100647 | M | |
5 | GTIN | n13 | GTIN-13 article code variant | 4016632118279 | M | |
6 | Quantity | n…4 | Quantity of each article | 1 | M | |
7 | Packaging unit | n..15 | Packaging unit | 2 | M | |
8 | Parcel Reference Number | n…18 | Coded parcel delivery note number (Box-ID Number) | 2001432998611 | M | |
9 | Brand ID | N1 | 1 = SIX 2 = ACC/White Label 3 = IAM 5 = TOSH | 1 | M | |
10 | GTIN polybag | n..15 | GTIN-13 article code of group article. This article groups different variants. This barcode is found on polybag | 4016632068260 | O | |
11 | Polybag quantity | n..4 | Quantity of polybag | 4 | O | |
12 | beeline store | n..10 | beeline internal store number | 46091 | O |
3. sample despatch advice data in flatfile format:
Flatfile despatch advice data with options
4.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 |