Attributes marked with (*) are mandatory.
Important: Data in XLSX files must be located in the first tab (far left). Other tabs are ignored during import.
Jump to:
Assets
Description: Fixed assets data that are the subject of the inventory.
Supported format: XLSX, CSV
column | description | num. of characters |
A | * asset code | 4-16 |
B | * asset name | 40 |
C | expected location code | 3-14 |
D | expected cost center code | 3-12 |
E | asset owner code | 3-12 |
F | asset serial number | 30 |
G | asset description | 100 |
H | asset status code | 1 |
I | asset status description | 20 |
J | custom asset field 1 | 50 |
K | custom asset field 2 | 50 |
L | custom asset field 3 | 50 |
M | custom asset field 4 | 50 |
N | custom asset field 5 | 50 |
O | asset RFID tag (EPC) | 1-256 |
P | asset organization code | 1-100 |
Q | asset value | 100 |
R | asset category code | 100 |
S | parent asset code | 4-16 |
Locations
Description: Locations data that are the subject of the inventory.
Supported format: XLSX, CSV
column | description | num. of characters |
A | * location code | 3-14 |
B | * location name | 40 |
C | additional location description | 100 |
Cost centers
Description: Cost centers data that are the subject of the inventory.
Supported format: XLSX, CSV
column | description | num. of characters |
A | * cost center code | 3-12 |
B | * cost center name | 40 |
C | additional cost center description | 100 |
Asset owners
Description: Asset owners data that are the subject of the inventory.
Supported format: XLSX, CSV
column | description | num. of characters |
A | * asset owner code | 3-12 |
B | * asset owner name | 37 |