{{ model.title }}
This page is currently being edited by {{ model.editingBy }}.SmartFusion Modules > Fixed Assets > Process > Export Barcode File
Recent Changes:
6.150
- Export Barcode File Format layout
File Layout
Field Name | Starting Position | Length | Description | Format |
---|---|---|---|---|
fa300.cassetnum | 1 | 15 | Asset Number | Numeric, right filled with spaces |
fa300.dservice | 16 | 10 | Date in Service | Date (MM/DD/YYYY) |
fa300.cdesc1 | 26 | 50 | Description of Asset | Alpha, left justified, right filled with spaces |
fa300.cmanufact | 76 | 30 | Manufacturer of Asset | Alphanumeric, left justified, right filled with spaces |
fa300.cmodelnum | 106 | 15 | Manufacturer's Model of Asset | Alphanumeric, left justified, right filled with spaces |
fa300.cserialnum | 121 | 20 | Serial Number | Alphanumeric, left justified, right filled with spaces |
csi25.cdept | 141 | 6 | Department Code | Numeric, right filled with spaces |
csi24.cloc | 147 | 6 | Location Code | Alphanumeric, filled with spaces |
fa303.cgroupcode | 153 | 6 | Asset Group | Alphanumeric, right filled with spaces |
fa304.cclasscode | 159 | 6 | Asset Class | Alphanumeric, right filled with spaces |
fa305.cbuildcode | 165 | 6 | Building Code | Alphanumeric, right filled with spaces |
fa300.croom | 171 | 10 | Room | Alphanumeric, right filled with spaces |
fa300.ccondition | 181 | 6 | Room | Alphanumeric, right filled with spaces |
FixedAssetAcquisitions.Quantity | 187 | 4 | Quantity | Numeric, right justified, default 0 |
FixedAssetAcquisitions.UnitPrice | 191 | 12 | Unit Cost | Decimal, right justified, default 0.00 |
FixedAssetAcquisitions.Amount | 203 | 12 | Initial Cost | Decimal, right justified, default 0.00 |
fa300.ysalvage | 215 | 12 | Salvage | Decimal, right justified, default 0.00 |
fa300.yreplace | 227 | 12 | Replace | Decimal, right justified, default 0.00 |
fa300.yinsurance | 239 | 12 | Insurance Amount | Decimal, right justified, default 0.00 |
fa300.dchecked | 251 | 10 | Date Checked | Date, left justified |
fa300.ilifemon | 261 | 4 | Life in Months | Numeric, right justified, default 0 |
fa300.cstatus | 265 | 1 | Status | Alpha |
fa307.cnote | 266 | 30 | Note 1 | Alphanumeric,right filled with spaces |
fa307.cnote | 296 | 30 | Note 2 | Alphanumeric.right filled with spaces |
fa301d.ddate | 326 | 10 | Disposed Date | Date (MM/DD/YYYY) |
fa300.cbarcode | 336 | 15 | Bar Code | Alphanumeric, left justified |
FixedAssetAcquisitions.ReferenceNumber | 351 | 15 | Reference | Alphanumeric, left justified |
fa300.CSI24ID_lkh | 366 | 6 | Last Known Holder | Alphanumeric, left justified, when MIS then the location code |
fa300.lcalcdepr | 372 | 1 | Depreciate | Alpha, when 1 then Y else N |