List of Exportable Fields
The following table contains the list of fields available for exporting with the Custom Export Helper. For each field, the table provides the name and the required format.
|
Field Name |
Format |
|
General Information Fields |
|
|
Activity Code |
Text A, D, I, etc. |
|
Asset ID |
Alphanumeric |
|
Class |
Alphanumeric |
|
Creation Code |
Text O, D, etc. |
|
Custom Date 1 |
Date |
|
Custom Date 2 |
Date |
|
Custom Field 1 |
Alphanumeric |
|
Custom Field 2 |
Alphanumeric |
|
Custom Field 3 |
Alphanumeric |
|
Custom Field 4 |
Alphanumeric |
|
Custom Field 5 |
Alphanumeric |
|
Custom Field 6 |
Alphanumeric |
|
Custom Field 7 |
Alphanumeric |
|
Custom Field 8 |
Alphanumeric |
|
Custom Field 9 |
Alphanumeric |
|
Custom Field 10 |
Alphanumeric |
|
Department |
Alphanumeric |
|
Description |
Alphanumeric |
|
Entity |
Alphanumeric |
|
Extension |
Numeric |
|
G/L Accum Account |
Alphanumeric |
|
G/L Asset Account |
Alphanumeric |
|
G/L Expense Account |
Alphanumeric |
|
Invoice |
Alphanumeric |
|
Location |
Alphanumeric |
|
Owner |
Alphanumeric |
|
Purchase Order |
Alphanumeric |
|
Quantity |
Numeric |
|
Replacement Value |
Numeric (Currency) |
|
RV Override Amount |
Numeric (Currency) |
|
RV Override Date |
Date |
|
Serial Number |
Alphanumeric |
|
System Number |
Numeric |
|
Vendor |
Alphanumeric |
|
|
|
|
Critical Fields |
|
|
168 Allowance % |
Numeric - 0, 20, 30, 40, 50, 60, 80, 100 |
|
Acquisition Value |
Numeric (Currency) |
|
Declining Balance % |
Numeric - 100, 125, 150, 175, 200 |
|
Depreciation Method |
Text - MF, MT, SL, SD, etc. |
|
Estimated Life |
YYMM |
|
Placed-in-Service Date |
Date |
|
Property Type |
Text - P, A, T, |
|
|
|
|
Book Information Fields |
|
|
179 Deduction |
Numeric (Currency) |
|
179 Other Amount |
Numeric (Currency) |
|
179 Other Code |
Text - B, C, D, E, O, or N |
|
179 Qualified? |
Text - Yes/No |
|
ACE Basis |
Numeric (Currency) |
|
ACE Remaining Life |
YYMM |
|
Acquired By |
Text - Yes = Exchange, No = Purchase |
|
Acquisition Date |
Date |
|
Adjustment Amount |
Numeric (Currency) |
|
ADS Life |
YYMM |
|
Business Use 100% |
Text - Yes/No |
|
Current 179 Recapture |
Numeric (Currency) |
|
Current Business Use % |
Percentage - e.g., 60.5 |
|
Current Remaining Life |
YYMM |
|
GO Zone |
Text T or |
|
ITC % |
Percentage - e.g., 40.00 |
|
ITC Amount |
Numeric (Currency) |
|
ITC Basis Reduction Amt |
Numeric (Currency) |
|
ITC Option |
Alphanumeric - 1, 2, 3, A, C |
|
Last Calc Date |
Date |
|
Net Book Value |
Numeric (Currency) |
|
Salvage Value |
Numeric (Currency) |
|
Zone Type |
Text - G, K, E, D, or X |
|
|
|
|
Depreciation Fields |
|
|
168 Allowance Amount |
Numeric (Currency) |
|
Begin Prior Accum Depr |
Numeric (Currency) |
|
Beginning Accum |
Numeric (Currency) |
|
Beginning Date |
Date |
|
Beginning YTD |
Numeric (Currency) |
|
Current Accum |
Numeric (Currency) |
|
Current Key Codes |
Text - m |
|
Current Through Date |
Date |
|
Current YTD |
Numeric (Currency) |
|
Depreciation This Run |
Numeric (Currency) |
|
Exclude on Depr Report? |
Text - Yes/No |
|
Prior Accum Depr |
Numeric (Currency) |
|
|
|
|
Disposal Fields |
|
|
Cash Proceeds |
Numeric (Currency) |
|
Deferred Code |
Text - Y, N, D |
|
Deferral Date |
Date |
|
Disposal Date |
Date |
|
Disposal Description |
Alphanumeric |
|
Disposal Method |
Text - S, A, T, etc. |
|
Expense of Sale |
Numeric (Currency) |
|
Gain/Loss |
Numeric (Currency) |
|
ITC Recapture |
Numeric (Currency) |
|
Non-Cash Proceeds |
Numeric (Currency) |
|
|
|
|
Transfer Fields (Parent) |
|
|
Date of Transfer Out |
Date |
|
Effective Date of Transfer-Out |
Date |
|
Percent Transferred-Out |
Numeric |
|
Transfer By |
Alphanumeric |
|
Transfer From |
Alphanumeric |
|
Transfer Out Amount |
Numeric (Currency) |
|
Transfer To |
Alphanumeric |
|
|
|
|
Transfer Fields (Child) |
|
|
Date of Transfer In |
Date |
|
Effective Date of Transfer-In |
Date |
|
Percent Transferred-In |
Percent |
|
Transfer In Amount |
Numeric (Currency) |
|
Transferred-In From |
Alphanumeric |
|
Transferred-In To |
Alphanumeric |
|
|
|
|
Sage Fixed Assets—Tracking Fields |
|
|
Check-out Date |
Date |
|
Condition |
Alphanumeric |
|
Exception Status |
Text |
|
Expected Return Date |
Date |
|
Floor |
Alphanumeric |
|
Reconciliation Status |
Text |
|
Room |
Alphanumeric |
|
Tracking Field 1 |
Alphanumeric |
|
Tracking Field 2 |
Alphanumeric |
|
Tracking Field 3 |
Alphanumeric |
|
Tracking Field 4 |
Alphanumeric |
|
Tracking Field 5 |
Alphanumeric |
|
Tracking Field 6 |
Numeric |
|
Tracking Field 7 |
Numeric |
|
Tracking Field 8 |
Numeric |
|
Tracking Field 9 |
Numeric |
|
Tracking Field 10 |
Numeric |
|
Tracking Field 11 |
Numeric (Currency) |
|
Tracking Field 12 |
Alphanumeric |