All Collections
Integrations
Files
Export files specification
Export files specification
A
Written by Andraž Stošić
Updated over a week ago

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 - yes

  • 0 - no

1

12

new:

  • 1 - yes

  • 0 - no

1

13

renamed:

  • 1 - yes

  • 0 - no

1

14

audit type:

  • 0 - scanner

  • 1 - manual

  • 2 - RFID

1

15

expected cost center code

3-12

16

audit user

50

17

audit comment

20

18

write-off proposal:

  • 1 - yes

  • 0 - no

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 - yes

  • 0 - no

1

10

new:

  • 1 - yes

  • 0 - no

1

11

renamed:

  • 1 - yes

  • 0 - no

1

12

audit type:

  • 0 - scanner

  • 1 - manual

  • 2 - RFID

1

13

expected cost center code

3-12

14

audit user

50

15

audit comment

20

16

write-off proposal:

  • 1 - yes

  • 0 - no

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

Did this answer your question?