Avoiding Field Names Used by the Application

You can customize the names of fields so that you can tailor the application to meet the specific needs of your organization. However, you should not rename a field to a name that is already in use by Sage Fixed Assets—Premier Depreciation. In addition, we recommend that you avoid using a field name that is in use by Sage Fixed Assets—Tracking.

Renaming a field to a field name used by the application creates duplicate fields. This causes problems while using certain features in the application, such as creating a group or changing the sort order when running a report. You could also experience problems when you add columns to a report. (This feature is available only if you have purchased Sage Fixed Assets—Reporting.)

Below is a list of field names that you should avoid because they are used by a Sage Fixed Assets application. The left column displays the field name, and the right column displays the field name as it appears on the standard reports.

Tip: If the name that you want to use is a reserved field name, then you can use a similar name instead. For example, if you want to change the name of a field to "Floor," you might consider using "Floors" or "FLOOR" instead.

The following field names should not be used when customizing a field.

Sage Fixed Assets—Depreciation Field Names	Report Headers
168 Allowance Amount	168 Allowance
168 Expense	168 Expense
168 Allowance %	168 Pct
168 Transfer In Amount	n/a
168 Transfer Out Amount	n/a
179 Deduction	179 Deduction
179 Other Amount	Sec 179/Other Amt
179 Other Code	C S
179 Qualified?	S Q
1st Year Business Use %	n/a
ACE Basis	ACE Basis
ACE Remaining Life	ACE Rem Life
Acquired by	n/a
Acquisition Date	Acq Date
Acquisition Value	Acquired Value
Activity Code	A C
Adjustment Amount	Over (Under) Depreciated
ADS Life	ADS Life
Asset ID	Asset ID
Beginning Accum	Beginning Accum
Beginning YTD	Beginning YTD
Begin Prior Accum Depr	Beginning Prior Accum Depr
Beginning Date	Begin Date
Business Use 100%	F B
Cash Proceeds	Cash Proceeds
Child Company Name (1)	n/a
Child Company Name (2)	n/a
Child Company Name (3)	n/a
Child System Number (1)	n/a
Child System Number (2)	n/a
Child System Number (3)	n/a
Class	Cl
Creation Code	C C
Current 179 Recapture	Section 179 Recapture
Current Accum	Current Accum
Current Business Use %	Bus Use %
Current Depr This Run	Depreciation This Run
Current Prior Accum Depr	Prior Accum Depreciation
Current Remaining Life	Rem Life
Current Through Date	Thru Date
Current YTD	Current YTD
Custom Date 1	Custom Date 1
Custom Date 2	Custom Date 2
Custom Field 1	Custom Field 1
Custom Field 2	Custom Field 2
Custom Field 3	Custom Field 3
Custom Field 4	Custom Field 4
Custom Field 5	Custom Field 5
Custom Field 6	Custom Field 6
Custom Field 7	Custom Field 7
Custom Field 8	Custom Field 8
Custom Field 9	Custom Field 9
Custom Field 10	Custom Field 10
Date of Transfer In	Transfer Date-In
Date of Transfer Out	Transfer Date-Out
Deferred Code	G L
Deferred Date	Deferral Date
Department	Department
Depreciable Basis	Depreciable Basis
Depreciation Method	Depr Meth
Description	Description
Disposal Date	Disposal Date
Disposal Description	Disposal Description
Disposal Method	D M
Disposal Percent-In	Disp %-in
Disposal %	Disp %-out
n/a	Eff. Trans-In Date
n/a	Eff. Trans-Out Date
Entity	Entity
Estimated Life	Est Life
Exclude on Depr Report?	E D
Expense of Sale	Expense of Sale
Extension	Ext
G/L Accum Account	G/L Accum Account
G/L Asset Account	G/L Asset Account
G/L Expense Account	G/L Expense Account
Gain/Loss	Realised Gain (Loss)
Invoice	Invoice
ITC Amount	ITC Amount
ITC Basis Reduction	n/a
ITC Option	I O
ITC %	ITC %
ITC Recapture	ITC Recap
Key Code	Key Code
Last Calc Date	Last Calc Date
Location	Location
Midquarter Convention	n/a
Net Book Value	Net Book Value
Non Cash Proceeds	Non-Cash Proceeds
Override RV	n/a
Parent Company Name	n/a
Parent System Number	n/a
Percent Transferred-In	Pct Trans-in
Percent Transferred-Out	Pct Trans-out
n/a	P E
Period Close Accum	Prd Close Accum
Period Close Date	Prd Close Date
Period Close YTD	Prd Close YTD
Placed-in-Service Date	In Svc Date
n/a	Prd Cl Key Code
n/a	Prd Close ACE Basis
n/a	Prd Close Depr Basis
Prd Close Depr This Run	Prd Close Depr This Run
n/a	Prd Close ITC Recap
Prd Close Net Book Value	Prd Close Net Book Value
Prd Close Prior Accum Depr	Prd Close Prior Accum
n/a	Prd Cls ACE Life
n/a	Prd Cls BU%
n/a	Prd Cls Rem Life
Prior Thru Date	Prior Thru
Property Type	P T
n/a	PT Acq Date
Purchase Order	Purchase Order
Quantity	Quantity
Replacement Value	Replacement Value
RV Override Amount	RV Override Amount
RV Override Date	RV Ovrd Date
Salvage Value	Salvage Value
Serial Number	Serial Number
System Number	Sys No
Transfer 168-In	Transfer 168-In
Transfer 168-Out	Transfer 168-Out
Transfer Book	n/a
Transfer By	Transfer By Field
Transfer From	Transfer From
Transfer In Amount	n/a
Transfer Out Amount	Amount Transferred
Transfer To	Transfer To
Transferred-In From	Trans-In From
Transferred-In To	Trans-In To
Vendor	Vendor
Zone Type	Z T

Sage Fixed Assets—Tracking Fields	Report Headers
Check-out Date	Check-out Date
Condition	Condition
Exception Status	E S
Expected Return Date	Exp. Return Date
Floor	Floor
Reconciliation Status	R S
Room	Room
Tracking Field 1	Tracking Field 1
Tracking Field 2	Tracking Field 2
Tracking Field 3	Tracking Field 3
Tracking Field 4	Tracking Field 4
Tracking Field 5	Tracking Field 5
Tracking Field 6	Tracking Field 6
Tracking Field 7	Tracking Field 7
Tracking Field 8	Tracking Field 8
Tracking Field 9	Tracking Field 9
Tracking Field 10	Tracking Field 10
Tracking Field 11	Tracking Field 11
Tracking Field 12	Tracking Field 12