Inventory report as flat file format
1. Document information
Message type | Date | Version | Subsets |
Inventory report | 29.04.2014 | 1.0 | Flat 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 |
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:
3. 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 |