Jump to:
Assets (Extended data)
Description: The file contains extended data of fixed assets and the audit results.
File name: INVEN3
Format: CSV, Fixed-width
Encoding: UTF-8
# | description | no. of characters |
1 | asset code | 4-16 |
2 | asset name | 40 |
3 | expected location code | 3-14 |
4 | expected location name | 40 |
5 | actual location code | 3-14 |
6 | actual location name | 40 |
7 | actual cost center code | 3-12 |
8 | new asset code | 4-16 |
9 | audit date (ddmmYYYY) | 8 |
10 | audit time (hhmm) | 4 |
11 | audited:
| 1 |
12 | new:
| 1 |
13 | renamed:
| 1 |
14 | audit type:
| 1 |
15 | expected cost center code | 3-12 |
16 | audit user | 50 |
17 | audit comment | 20 |
18 | write-off proposal:
| 1 |
19 | old asset name | 40 |
20 | asset description | 100 |
21 | asset serial number | 30 |
22 | asset owner code | 3-12 |
23 | asset owner name | 37 |
24 | asset status code | 1 |
25 | asset status name | 20 |
Assets
Description: The file contains data of fixed assets and the audit results.
File name: INVEN
Format: CSV, Fixed-width
Encoding: UTF-8 (TXT) / ASCII (ASC)
# | description | no. of characters |
1 | asset code | 4-16 |
2 | asset name | 40 |
3 | expected location code | 3-14 |
4 | actual location code | 3-14 |
5 | actual cost center code | 3-12 |
6 | new asset code | 4-16 |
7 | audit date (ddmmYYYY) | 8 |
8 | audit time (hhmm) | 4 |
9 | audited:
| 1 |
10 | new:
| 1 |
11 | renamed:
| 1 |
12 | audit type:
| 1 |
13 | expected cost center code | 3-12 |
14 | audit user | 50 |
15 | audit comment | 20 |
16 | write-off proposal:
| 1 |
17 | old asset name | 40 |
Locations
Description: The file contains locations data.
File name: LOCAT
Format: CSV, Fixed-width
Encoding: UTF-8
# | description | no. of characters |
1 | location code | 3-14 |
2 | location name | 40 |
Cost centers
Description: The file contains cost centers data.
File name: COSTC
Format: CSV, Fixed-width
Encoding: UTF-8
# | opis | no. of characters |
1 | cost center code | 3-14 |
2 | cost center name | 40 |
Audits
Description: The file contains audit results data.
File name: READ
Format: CSV, Fixed-width
Encoding: UTF-8 (TXT) / ASCII (ASC)
# | description | no. of characters |
1 | asset code | 4-16 |
2 | actual location code | 3-14 |