{{ model.title }}
This page is currently being edited by {{ model.editingBy }}.SmartFusion Modules > Fixed Assets > Process > Export Barcode File
Export File Format
The file will export as tab delimited text file
"R" = required field
Other fields available
csi25.cdept
fa300.croom
FixedAssetAcquisitions.UnitPrice
fa300.yreplace
fa300.yinsurance
fa300.dchecked
fa300.ilifemon
fa301d.ddate (Disposed Date)
FixedAssetAcquisitions.ReferenceNumber
fa300.CSI24ID_lkh (Last Known Holder)
fa300.lcalcdepr (Depreciate Yes/No)
| Field Name | Format | Comments |
|---|---|---|
| CLASSIFICATION | R - Alpha (20) | fa303.cgroupcode (Asset Group) |
| TYPE | R - Alpha (20) | fa304.cclasscode (Asset Class) |
| BARCODE | R - AlphaNumeric (20) | fa300.cbarcode (fa300.cassetnum if missing) |
| DESCRIPTION | R - Alpha (80) | fa300.cdesc1 |
| STORAGE FACILITY | R - Alpha (40) | fa305.cbuildcode (Building Code) |
| STORAGE LOCATION | R - AlphaNumeric (50) | csi24.cloc |
| STORAGE LOC BARCODE | R - AlphaNumeric (20) | |
| IN SERVICE DATE | Date (M/D/YYYY) | fa300.dservice |
| STATUS | Alpha | fa300.cstatus |
| ASSET NUMBER | Integer (30) | fa300.cassetnum |
| MANUFACTURER | Alpha (50) | fa300.cmanufact |
| MODEL | AlphaNumeric (30) | fa300.cmodelnum |
| SERIAL NUMBER | AlphaNumeric (30) | fa300.cserialnum |
| FUNDING SOURCE | Alpha (50) | |
| ACCOUNT NUMBER | AlphaNumeric (25) | |
| BIN | Yes/No (default) | |
| BIN QUANTITY | Integer | FixedAssetAcquisitions.Quantity |
| CONSUMABLE | Yes/No (default) | |
| CONTAINER | Yes/No (default) | |
| CHECKOUT CONTAINER BARCODE | AlphaNumeric (20) | |
| CHECKOUT FACILITY | Alpha (40) | |
| CHECKOUT LOCATION | Alpha (50) | |
| CHECKOUT LOC BARCODE | AlphaNumeric (20) | |
| CHECKOUT PERSON | Alpha | First(80) Mid(1) Last(30) |
| CHECKOUT PERSON BARCODE | AlphaNumeric (20) | |
| DATE OUT | DateTime | |
| DUE DATE | Date | |
| CHECKOUT BIN QUANTITY | Integer | |
| NOTES | AlphaNumeric (255) | fa307.cnote |
| ORIGINAL VALUE | Decimal | FixedAssetAcquisitions.Amount |
| DEPRECIATION TYPE | Integer | 0 - Straight Line (ConfigurationItem; FA; DepreciationConvention = STNDRD) |
| 1 - MACRS 1/2 year (ConfigurationItem; FA; DepreciationConvention = HALFYR) | ||
| 2 - MACRS mid quarter | ||
| 3 - MACRS Double Declining 1/2 year | ||
| 4 - MACRS Double Declining mid quarter | ||
| DEPRECIATION PERIOD | Integer (years) | |
| SALVAGE VALUE | Decimal | fa300.ysalvage |
| CONDITION | Alpha | fa300.ccondition (Excellent, Good, Poor) |
| REORDER POINT | ||
| TOOL IMAGE FILE | AlphaNumeric (255) | |
| WARRANTY EXPIRATION DATE | Date (M/D/YYYY) | |
| PURCHASED FROM | Alpha (255) | |
| MISCELLANEOUS | AlphaNumeric (20) | |
| PURCHASE ORDER | AlphaNumeric (30) |