The data file to import Asset Types must consist of eighteen (18) comma separated columns. The columns must be in the following order:
Column |
Field |
Required/Optional |
Description |
|
1 |
Description |
Required |
If the asset type already exists in the Asset Types table, the asset type will be updated with the import information. If the asset type does not exist, it will be added. |
|
2 |
Barcode Location |
Optional |
|
|
3 |
Attractive |
Optional |
This field will default to 'N' if no value is supplied. |
|
4 |
Comments |
Optional |
|
|
5 |
Depreciation Expense Component Code |
Optional |
This field will default to the corresponding Component Code specified in the Defaults window in the Asset module if no value is supplied. |
|
6 |
Accumulated Depreciation Component Code |
Optional |
This field will default to the corresponding Component Code specified in the Defaults window in the Asset module if no value is supplied. |
|
7 |
Disposal Component Code |
Optional |
This field will default to the corresponding Component Code specified in the Defaults window in the Asset module if no value is supplied. |
|
8 |
Loss on Disposal Component Code |
Optional |
This field will default to the corresponding Component Code specified in the Defaults window in the Asset module if no value is supplied. |
|
9 |
Gain on Disposal Component Code |
Optional |
This field will default to the corresponding Component Code specified in the Defaults window in the Asset module if no value is supplied. |
|
10 |
Revaluation Component Code |
Optional |
This field will default to the corresponding Component Code specified in the Defaults window in the Asset module if no value is supplied. |
|
11 |
Write-off Component Code |
Optional |
This field will default to the corresponding Component Code specified in the Defaults window in the Asset module if no value is supplied. |
|
12 |
Revaluation Expense Component Code |
Optional |
This field will default to the corresponding Component Code specified in the Defaults window in the Asset module if no value is supplied. |
|
13 |
Category |
Optional |
The value in this field will be added to the Categories table if it does not already exist. |
|
14 |
Depreciation Method |
Optional |
The value for this field must be 'P' for Prime Cost, or 'R' for Reducing Balance. This will default to 'P' if no value is supplied. |
|
15 |
Depreciable Rate |
Optional |
This field will default to 0 if no value is supplied. |
|
16 |
Depreciable Flag |
Optional |
The value for this field must be 'Y' for Yes, 'N' for No. This field will default to 'Y' if no value is supplied. |
|
17 |
Residual Value |
Optional |
This field will default to 0.00 if no value is supplied. |
|
18 |
Depreciation Book |
Optional |
If you do not choose a depreciation book, then all depreciation books will be updated. |