The following file format is used by Fixed Asset Load if non-configurable is selected when loading the file.
The file must contain only data lines (no header line), and fields must be separated by a comma or a space (you specify which separator is used when you load the file). If columns are separated by spaces, all alphanumeric fields must be enclosed in quotation marks (" ").
Column | Description | Format | Coins ERP+ Field | Comments |
1 | Asset Code | x(8) | faa_code | If the FA parameter ASSFORM is not blank, the asset code is auto-generated; leave this column blank. |
2 | Description | x(30) | faa_desc | Mandatory if Mandatory Description is ticked when loading. |
3 | Group Code | x(8) | fag_code | Validated against the Asset Group table (fa_group). |
4 | Department Code | x(8) | fad_code | Validated against the Asset Department table (fa_dept). |
5 | Home Depot | x(8) | faa_home |
|
6 | Current Depot | x(8) | faa_depot |
|
7 | Serial Number | x(20) | faa_serialno | Validated to be unique if Serial No Validation is ticked when loading |
8 | Part Of | x(8) | faa_base | The asset code of which this asset is a part. If the other asset is being loaded at the same time, it must come earlier in the file. |
9 | Subgroup | x(4) | faa_sub |
|
10 | supplier code | x(8) | avm_num |
|
11 | Purchase Reference | x(12) | faa_pchref |
|
12 | Purchase Date | 99/99/99 | faa_pchdate | Mandatory if creating a purchase batch on load. |
13 | Price | >,>>>,>>9.99 | faa_price |
|
14 | Minimum Book Value | >,>>>,>>9.99 | faa_minbv |
|
15 | Depreciation Method | x(8) | fdm_code |
|
16 | Initial WDV | >,>>>,>>9.99 | faa_wdvinit1 |
|
17 | Current WDV | >,>>>,>>9.99 | faa_wdv |
|
18 | Car Registration | x(10) | flt_regno |
|
19 | Make | x(8) | fmk_code |
|
20 | Model | x(8) | fam_code |
|
21 | New | yes/no | flt_new |
|
22 | colour | x(20) | flt_colour |
|
23 | Trim | x(20) | flt_trim |
|
24 | Radio | x(20) | flt_radio |
|
25 | Key Number | x(20) | flt_keyno |
|
26 | Fuel Card | x(20) | flt_fuelcard |
|
27 | Current Miles | >>>>>>9 | flt_currmiles |
|
28 | Current Mile Date | 99/99/99 | flt_currmidat |
|
29 | Trigger Code 1 | x(8) | fat_code[1] |
|
30 | Trigger Value 1 | As in Trigger | ftv_value[1] |
|
31 | Trigger Date of Value 1 | 99/99/99 | ftv_lastupd[1] |
|
32 | Trigger expiry 1 | x(8) | ftv_exp[1] | The value at which the trigger expires. |
33 | Trigger code 2 | x(8) | fat_code[2] |
|
34 | Trigger Value 2 | As in Trigger | ftv_value[2] |
|
35 | Trigger Date of Value 2 | 99/99/99 | ftv_lastupd[2] |
|
36 | Trigger expiry 2 | x(8) | ftv_exp[2] |
|
37 | Trigger Code 3 | x(8) | fat_code[3] |
|
38 | Trigger Value 3 | As in Trigger | ftv_value[3] |
|
39 | Trigger Date of Value 3 | 99/99/99 | ftv_lastupd[3] |
|
40 | Trigger expiry 3 | x(8) | ftv_exp[3] |
|
41 | Trigger code 4 | x(8) | fat_code[4] |
|
42 | Trigger value 4 | As in Trigger | ftv_value[4] |
|
43 | Trigger Date of Value 4 | 99/99/99 | ftv_lastupd[4] |
|
44 | Trigger expiry 4 | x(8) | ftv_exp[4] |
|
45 | Trigger code 5 | x(8) | fat_code[5] |
|
46 | Trigger Value 5 | As in Trigger | ftv_value[5] |
|
47 | Trigger Date of Value 5 | 99/99/99 | ftv_lastupd[5] |
|
48 | Trigger expiry 5 | x(8) | ftv_exp[5] |
|
49 | First Analysis Code | x(8) | analysis 1 |
|
50 | Second Analysis Code | x(8) | analysis 2 |
|
51 | Third Analysis Code | x(8) | analysis 3 |
|
52 | Fourth Analysis Code | x(8) | analysis 4 |
|
53 | Depreciation Start Date | 99/99/99 | faa_dsdate1 |
|
54 | Extended Description | x(30) | faa_xdesc |
|
55 | MID Status | x(1) | faa_road | Whether this is a road-going vehicle [values: Y(es)/N(o)/P(ossible)] |
56 | MID Category | x(8) | faa_midcat |
|
57 | Leased | yes/no | leased |
|
58 | Depreciation cost head | x(8) | depnch |
|
59 | 2nd Depreciation Method Code | x(8) | fdm_code2 |
|
60 | 2nd Initial WDV | >,>>>,>>9.99 | faa_wdvinit2 |
|
61 | 2nd Current WDV | >,>>>,>>9.99 | faa_wdv2 |
|
62 | 2nd Depreciation Start Date | 99/99/99 | faa_dsdate2 |
|
63 | Asset Status | x(8) | faa_status |
|
64 | Ownership Charged To Date | 99/99/99 | faa_ownchgto |
|
65 | Acquisition Reason | x(8) | faa_acqreason | BLANK or one of the user-defined options |
66 | Market Value | ->,>>>,>>>,>>9.99 | faa_mrktval | Override price for % of value charge caps |
67 | Weight | >>>,>>>,>>9.999 | faa_weight |
|
68 | Ownership Status | X | faa_owntype | O,L,B,3 or X - Owned, Leased, Hire Purchase, 3rd Party or hired |
69 | Registration Issued By | x(8) | faa_authority | Not used in UK |
70 | Secondary | x(20) | faa_serial2 |
|
71 | Tertiary | x(20) | faa_serial3 |
|
72 | Registration | x(8) | faa_regstat | BLANK (Required), Exempt or Not |
73 | Load Footprint | x(30) | faa_footprint |
|
74 | Transport Class | x(8) | faa_tranclass | Only if Transport Classes defined |
75 | Assign To | x(8) | faa_cargo | Only if Transport Cargo Types defined |
76 | Maximum Load | ->>,>>>,>>9.99 | faa_maxload | BLANK or one of the user-defined options |
77 | Load Area | x(30) | faa_loadarea | Override price for % of value charge caps |
78 | Historical Depreciation Value | ->>,>>>,>>9.99 | faa_histdepn[1] |
|
79 | Historical Depreciation Value | ->>,>>>,>>9.99 | faa_histdepn[2] | Secondary depreciation |
80 | YTD Historical Depreciation Value | ->>,>>>,>>9.99 | faa_ytdhist[1] |
|
81 | YTD Historical Depreciation Value | ->>,>>>,>>9.99 | faa_ytdhist[2] | Secondary depreciation |
82 | Age Offset | ->>,>>>,>>9 | faa_ageoff[1] | The age of the asset in financial periods prior to Coins ERP+. When calculating SL depreciation, Coins ERP+ will reduce the life by the offset. |
83 | Age Offset | ->>,>>>,>>9 | faa_ageoff[2] | Secondary depreciation |