Inventory report as flat file format

1. Document information

Message typeDateVersionSubsets
Inventory report29.04.20141.0Flat file

2. Format and content

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 
1GLNan13GLN or prefix & storenumber4016632000000
KUNDE00000123
2Date & timen14Date / time of collection 
Format: JJJJMMTTHHMMSS
20061231235959
3GTINn13GTIN-articlecode or 
beeline article-Nr.
4016632118279
4Amountn..15Amount of the available article2
 
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

 

3. Legend to the flat file tables:

ElementDefinitionExample
Format  
nnumericn3 = exact 3 numeric positions
n...35 = up to 35 numeric positions
analphanumerican12 = exakt 12 alphanumeric positions
an...35 = bis zu 35 alphanumeric positions
Status  
Mmust 
Ooptional