beeline group EDI

Inventory report as flat file format

 

Message type Date Version Subsets
Inventory report 29.04.2014 1.0 Flat file

 

For the exchange of inventory data beeline GmbH offers a flat file format.
This format is line-orientied and separates the single data with a semicolon.
The data output is transferred in one row in the following order:
 

 Pos   Typ   Format   Description   Sample 
1 GLN an13 GLN or prefix & storenumber 4016632000000
KUNDE00000123
2 Date & time n14 Date / time of collection 
Format: JJJJMMTTHHMMSS		 20061231235959
3 GTIN n13 GTIN-articlecode or 
beeline article-Nr.		 4016632118279
4 Amount n..15 Amount of the available article 2
 
Sample: 4016632000000;20061231235859;4016632118279;2  
Sample: 4016632000000;20061231235900;4043977010016;1  
Sample: KUNDE00000123;20061231235901;4050262010023;3  


If only store numbers exist for item 1 and no GLNs, prefixes must be placed in front of the store numbers in order to reach a total of 13 digits. The prefix must be agreed bilaterally.

Here you can download a sample inventory report in flatfile format: 

 

Flatfile inventory report

 

Legend to the flat file tables:

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  
O optional