FAUTLI Input File Format

The FAUTLI input file should contain the following information. All of these fields represent one asset to update/insert and should exist as one line per asset in the file.

Unique Identifier: The asset's unique identifier; specific to each asset
Description: Description of the asset
In Service Date: Date the asset begins to depreciate
Purchamt: Original purchase amount of the asset
Make: Manufacturer of the asset
Model: Model of the asset
Serialno: Serial number of the asset
License: License number of the asset
Year: Year the asset was manufactured
Qty: How many of this type of asset
Location: Location of the asset
Dept: Department in which the asset is used or belongs to
Rpid: Responsible ID
Bldg: Building in which the asset resides
Room: Room in which the asset resides
Count: How many of asset
Key: Ledger key the asset is specific to
Obj: Ledger object the asset is specific to
Po: Purchase order number used to acquire the asset
Vendor: Vendor the asset was purchased from
Inventory date: Date the asset was added to the inventory
Cate: Category (Primary Class)
Subtype: Secondary Class
Stat: Current status of the asset
Indt: In service date of asset
Tag: Tag ID: Default is the Fixed Assets ID Value
Cost: Cost of Asset
Replace: Replacement Cost of Asset
Condition: Condition of the asset