Fleet Inventory
Field Name |
Caption |
Mask |
Description |
Field Type |
FL_AACCOUNT |
Asset Account # |
45x |
Asset Account # |
Text |
FL_ACL_CD |
Asset Class |
25x |
Asset Class |
String |
FL_ACL_TY |
Asset Class Text |
60x |
Asset Class Text |
String |
FL_ACTCST |
Actual Annual Cost |
nnnnnnnn.nn |
Actual Annual Cost |
Double |
FL_ACTHR |
Actual Hourmeter |
nnnnnnn.nn |
Actual Hours Used |
Double |
FL_ACTODO |
Actual Odometer |
nnnnnnn.n |
Actual Annual Odometer Reading |
Double |
FL_ACTOTH |
Actual Other Meter |
nnnnnnnn.nn |
Actual annual Other Meter Used |
Double |
FL_AMT_DT |
Amount Used Date |
nnnn.nnn |
Amount Used Date |
Double |
FL_AMTCST |
Used Cost |
nnnnnnnn.nn |
Amount of Cost Used |
Double |
FL_AMTHR |
Used Hourmeter |
nnnnnnn.nn |
Hours Used |
Double |
FL_AMTODO |
Used Odometer |
nnnnnnn.n |
Odometer Used |
Double |
FL_AMTOTH |
Used Other Meter |
nnnnnnnn.nn |
Amount Other Meter Used |
Double |
FL_APNUMACT |
Asset Proj No - Acct |
40x |
Asset Proj No - Acct |
Text |
FL_ASSET |
Asset Number |
30x |
Asset Number |
Text |
FL_AXL1_CD |
Rear Axle 1 Type |
nnn |
Rear Axle 1 Type |
Small Integer |
FL_AXL1_TY |
Rear Axle 1 Type Text |
25x |
Rear Axle 1 Type Text |
String |
FL_AXL2_CD |
Rear Axle 2 Type |
nnn |
Rear Axle 2 Type |
Small Integer |
FL_AXL2_TY |
Rear Axle 2 Type Text |
25x |
Rear Axle 2 Type Text |
String |
FL_AXL3_CD |
Rear Axle 3 Type |
nnn |
Rear Axle 3 Type |
Small Integer |
FL_AXL3_TY |
Rear Axle 3 Type Text |
25x |
Rear Axle 3 Type Text |
String |
FL_AZONE_CD |
Alternate Zone |
10x |
Alternate Zone |
String |
FL_AZONE_TY |
Alternate Zone Text |
60x |
Alternate Zone Text |
String |
FL_BF_ID |
Floor Rec # |
-nnnnnnnn |
Long Integer |
|
FL_BFRQ_CD |
Billing Freq. |
nnn |
Billing Freq |
Integer |
FL_BFRQ_TY |
Billing Freq. Text |
25x |
Billing Freq Text |
Text |
FL_BL_ID |
Bldg Rec # |
-nnnnnnnn |
Long Integer |
|
FL_BOOK |
Book Value |
nnnnnnnn.nn |
Book Value |
Double |
FL_BR_CD |
Default WO Cat |
10x |
Category |
Text |
FL_BR_ID |
Room Rec # |
-nnnnnnnn |
Link to Room |
Long Integer |
FL_BR_TY |
Default WO Cat Text |
60x |
Category Text |
Text |
FL_CAPAC |
Capacity |
30x |
Capacity |
Text |
FL_CAT_CD |
Category |
nnn |
Category: |
Integer |
FL_CAT_TY |
Category Text |
25x |
Category Text |
Text |
FL_CCAT_CD |
Cost Category |
10x |
Cost Category |
Text |
FL_CCAT_TY |
Cost Category Text |
25x |
Cost Category Text |
Text |
FL_CFRQ_CD |
Contract Freq. |
nnn |
Contract Freq |
Integer |
FL_CFRQ_TY |
Contract Freq. Text |
25x |
Contract Freq Text |
Text |
FL_CL_CD |
Class |
10X |
Class Code |
Text |
FL_CL_TY |
Class Text |
60X |
Class Type |
Text |
FL_CO_ID |
|
|
Link to EFCOMMENT Table |
Long Integer |
FL_COF |
Consequence of Failure |
-nnnnnnnn.nn |
Consequence of Failure |
Double |
FL_COLOR |
Color |
30x |
Color |
Text |
FL_COMMENT1 |
Long Note |
|
Long Note |
Memo |
FL_CONT_CST |
Contract Cost |
nnnnnnnn.nn |
Contract Cost |
Double |
FL_CP_HR |
Cost Per Hourmeter |
nnnnnnnn.nn |
Cost per Hour |
Double |
FL_CP_ODO |
Cost Per Odometer |
nnnnnnnn.nn |
Cost per Mile |
Double |
FL_CP_OTH |
Cost Per Other Meter |
nnnnnnnn.nn |
Cost per Other Meter |
Double |
FL_CRT_BY |
Created By |
25x |
Created By |
Text |
FL_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
FL_CST_CD |
Cost Center |
10x |
Cost Center: |
Text |
FL_CST_TY |
Cost Center Text |
25x |
Cost Center Text |
Text |
FL_CUR_DT |
Current Date |
mm/dd/yyyy |
Current Date |
Date/Time |
FL_CUR_TM |
Eval Current Time |
mm/dd/yyyy |
Eval Current Time |
DateTime |
FL_CURCST |
Current Cost |
nnnnnnnn.nn |
Current Cost |
Double |
FL_CURHR |
Current Hourmeter |
nnnnnnn.nn |
Current Hourmeter Reading |
Double |
FL_CURODO |
Current Odometer |
nnnnnnn.n |
Current Odometer Reading |
Double |
FL_CUROTH |
Current Other Meter |
nnnnnnnn.nn |
Current Meter reading |
Double |
FL_DEP_AMT |
Deprec Amount |
nnnnnnnn.nn |
Depreciation Amount |
Double |
FL_DEP_DT |
Full Depr. Date |
mm/dd/yyyy |
Fully Deprec Date |
Date/Time |
FL_DEPT_CD |
Department |
nnn |
Department: |
Integer |
FL_DEPT_TY |
Department Text |
50x |
Department Text |
Text |
FL_DOC_FLG |
Document Available |
|
Document Flag |
Boolean |
FL_EMAIL |
Operator Email |
150x |
Operator Email Address |
Text |
FL_EMPL_CD |
Work Employee |
20x |
Employee # |
Text |
FL_EMPL_TY |
Employee Name |
40x |
Employee Name |
Text |
FL_EQ_ID |
Equip Rec # |
-nnnnnnnn |
Long Integer |
|
FL_EQPT_CD |
WO Equip Code |
20x |
WO Equip Code |
Text |
FL_ESTCST |
Est. Annual Cost |
nnnnnnnn.nn |
Estimated Cost |
Double |
FL_ESTHR |
Est. Ann. Hourmeter |
nnnnnnn.nn |
Estimated Hours Used |
Double |
FL_ESTODO |
Est. Ann. Odometer |
nnnnnnn.n |
Estimated Annual Odometer Reading |
Double |
FL_ESTOTH |
Est Ann. Othermeter |
nnnnnnnn.nn |
Estimated annual Other Meter Used |
Double |
FL_FASSET |
Fixed Asset ID |
nnnnnnnn |
Fixed Asset ID |
Long Integer |
FL_FREQNR |
|
|
Do Not Include in Replacement Frequency Report ( 0 - include in report) |
Boolean |
FL_FUEL_CD |
Fuel Type |
nnn |
Fuel Type |
Integer |
FL_FUEL_TY |
Fuel Type Text |
25x |
Fuel Type Text |
Text |
FL_FUELCAP |
Fuel Tank Size |
nnnn.nn |
Fuel Tank Capacity |
Double |
FL_FUELCST |
Fuel Total Cost |
nnnnnnnn.nn |
Fuel Total Cost for the life of the vehicle |
Double |
FL_FUELTOT |
Fuel Total Units |
nnnnnnnn.nn |
Fuel Total for the life of the vehicle |
Double |
FL_GISNEED_CD |
Needs GIS |
nnn |
Needs GIS |
Integer |
FL_GISNEED_TY |
Needs GIS Text |
100x |
Needs GIS Text |
Text |
FL_GVW |
GVW |
nnnnnnn.nn |
Gross Vehicle Weight |
Double |
FL_HOURMETER |
Hourmeter |
|
Hour Meter Readings Tracked |
Boolean |
FL_ID |
Fleet Rec # |
-nnnnnnnn |
Fleet AutoID Number |
Long Integer |
FL_IFREQ |
Inspection Freq |
nnn |
Inspection Freq |
Small Integer |
FL_IFRQ_CD |
Inspection Freq Units |
nnn |
Inspection Freq Units |
Small Integer |
FL_IFRQ_TY |
Inspection Freq Units Text |
10x |
Inspection Freq Units Text |
String |
FL_IMG_FLG |
|
|
Image Flag |
Boolean |
FL_INMAP |
In Map? |
|
In Map Flag |
Boolean |
FL_INS_EXP |
Ins. Exp. Date |
mm/dd/yyyy |
Ins Expiration Date |
Date/Time |
FL_INSCOCD |
Insurance Co. |
nnn |
Insurance Co.: |
Integer |
FL_INSCOST |
Total Ins Cost |
nnnnnnnn.nn |
Total Insurance cost to date |
Double |
FL_INSCOTY |
Insurance Co. Text |
25x |
Insurance Company Text |
Text |
FL_INSP_DT |
Last Inspection |
mm/dd/yyyy |
Last Inspection |
DateTime |
FL_LEXPDT |
Lease Exp. Date |
mm/dd/yyyy |
Leasing Expiration Date |
Date/Time |
FL_MAINCST |
Total Maint Cost |
nnnnnnnn.nn |
Total Maintenance Cost - Fuel + Work Orders Costs |
Double |
FL_MAKE |
Make |
30x |
Make |
Text |
FL_MAN_CD |
Manufacturer |
12x |
Manufacturer |
Text |
FL_MAN_TY |
Manufacturer Text |
60x |
Manufacturer Text |
Text |
FL_MAX_DT |
Service Life |
nnnn.nnn |
Maximum Date |
Double |
FL_MAXCST |
Maximum Cost |
nnnnnnnn.nn |
Maximum Cost |
Double |
FL_MAXFUEL |
Max Fuel Units |
nnnnnnnn.nn |
Max Fuel Units |
Double |
FL_MAXHR |
Maximum Hourmeter |
nnnnnnn.nn |
Maximum Hours Allowed |
Double |
FL_MAXODO |
Maximum Odometer |
nnnnnnn.n |
Maximum allowed Odometer Reading |
Double |
FL_MAXOTH |
Maximum Other Meter |
nnnnnnnn.nn |
Maximum Other Meter allowed |
Double |
FL_MCPHR |
Maint Cost/Hourmeter |
nnnnnnnn.nn |
Total Maintenance Cost per hourmeter |
Double |
FL_MCPODO |
Maint Cost/Odometer |
nnnnnnnn.nn |
Total Maintenance Cost per Odometer |
Double |
FL_MCPOTH |
Maint Cost/Other Meter |
nnnnnnnn.nn |
Total Maintenance Cost per other meter |
Double |
FL_MITIGAT |
Mitigation |
-nnnnnnnn.nn |
Mitigation |
Double |
FL_MMTBF |
Manuf MTBF |
-nnnnnnnn.nn |
Manufacturer's Mean Time Between Failure |
Double |
FL_MOD_BY |
Last Modified By |
25x |
Modified By |
Text |
FL_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Modified Date |
Date/Time |
FL_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
FL_MODEL |
Model |
30x |
Model |
Text |
FL_MOV_FLG |
|
|
Movie Flag |
Boolean |
FL_MTBF |
MTBF |
-nnnnnnnn.nn |
Mean Time Between Failure |
Double |
FL_MZONE_CD |
Maintenance Zone |
10x |
Maintenance Zone |
String |
FL_MZONE_TY |
Maintenance Zone Text |
60x |
Maintenance Zone Text |
String |
FL_NEXT_DT |
Next Inspection |
mm/dd/yyyy |
Next Inspection |
DateTime |
FL_NOWORK |
No WO/PM/Req |
|
No WO/PM/Req |
Boolean |
FL_LWOT_DT |
Last WO Task Date |
mm/dd/yyyy |
Last WO Task Date |
DateTime |
FL_ODOMETER |
Odometer |
|
Odometer Readings Tracked |
Boolean |
FL_OIL_CD |
Oil Type |
nnn |
Oil Type |
Integer |
FL_OIL_TY |
Oil Type Text |
25x |
Oil Type Text |
Text |
FL_OILCAP |
Engine Oil Quantity |
nnn.nn |
Engine Oil Capacity |
Double |
FL_OP_DESC |
Operating Status Txt |
25x |
Operating Desc. |
Text |
FL_OP_STAT |
Operating Status |
nnn |
Operating Status |
Integer |
FL_OPERATR |
Operator |
30x |
Operator |
Text |
FL_OPERCST |
Total Oper Cost |
nnnnnnnn.nn |
Total Operational - Fuel + OtherFluids + Insurance +Work Orders Costs |
Double |
FL_OTFLCST |
Total Fluid Cost |
nnnnnnnn.nn |
Total Other Fluid Cost |
Double |
FL_OWN_CD |
Ownership |
nnn |
Ownership: |
Integer |
FL_OWN_TY |
Ownership Text |
100x |
Ownership Text |
Text |
FL_PLATE |
Plate |
30x |
Plate |
Text |
FL_PO |
P.O./Contract |
30x |
P.O./Contract # |
Text |
FL_POF |
Probability of Failure |
-nnnnnnnn.nn |
Probability of Failure |
Double |
FL_PRIORCD |
Priority |
nnn |
Priority: |
Integer |
FL_PRIORTY |
Priority Text |
25x |
Priority Text |
Text |
FL_PRO_CD |
Profit Center |
nnn |
Profit Center: |
Integer |
FL_PRO_TY |
Profit Center Text |
25x |
Profit Center Text |
Text |
FL_PUR_DT |
Purchase Date |
mm/dd/yyyy |
Purchased Date |
Date/Time |
FL_PURPRIC |
Purchase Amount |
nnnnnnnn.nn |
Purchase Price |
Double |
FL_RADIO |
Radio Number |
30x |
Radio Number |
Text |
FL_RAXLES |
Number of Rear Axles |
nnn |
Number of Rear Axles |
Small Integer |
FL_REC_DT |
Received Date |
mm/dd/yyyy |
Received Date |
Date/Time |
FL_REM_DT |
Remaining Date |
-nnnn.nnn |
Remaining Amount Date |
Double |
FL_REMCST |
Remaining Amt |
-nnnnnnnn.nn |
Remaining Cost |
Double |
FL_REMHR |
Remaining Hourmeter |
-nnnnnnn.nn |
Remaining Hours |
Double |
FL_REMODO |
Remaining Odometer |
-nnnnnnn.n |
Remaining Odometer |
Double |
FL_REMOTH |
Remaining Other Meter |
-nnnnnnnn.nn |
Remaining Other Meter |
Double |
FL_RENT |
Rented? |
|
Rented? |
Boolean |
FL_REP_CST |
Est. Replace Cost |
nnnnnnnn.nn |
Est. Replace Cost |
Double |
FL_REP_DT |
Replace Date |
mm/dd/yyyy |
Replacement Date |
Date/Time |
FL_REPFREQ |
Replacement Frequency |
-nnnnnnnn.nn |
Replacement Frequency |
Double |
FL_REQ_DT |
Requisition Date |
mm/dd/yyyy |
Requisition Date |
Date/Time |
FL_REQNO |
Requisition No |
30x |
Requisition Number |
Text |
FL_RF_ID |
Roof Rec # |
-nnnnnnnn |
Long Integer |
|
FL_RFX_CST |
Fixed Rate |
nnnnnnn.nn |
Fixed Cost |
Double |
FL_RHR_CST |
Hourly Cost |
nnnnnnn.nn |
Hourly Cost |
Double |
FL_RISK |
Risk |
-nnnnnnnn.nn |
Risk |
Double |
FL_RL_CST |
Remaining Cost Life |
-nnnn.nnn |
Remaining Life Cost |
Double |
FL_RL_HR |
Remaining Hour Life |
-nnnn.nnn |
Remaining Life in Hours |
Double |
FL_RL_ODO |
Remaining Life |
-nnnn.nnn |
Remaining Life in Miles |
Double |
FL_RL_OTH |
Remaining Other Life |
-nnnn.nnn |
Other Meter Remaining Life |
Double |
FL_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
FL_SALVAGE |
Salvage Value |
nnnnnnn.nn |
Salvage Value |
Double |
FL_SPEC1 |
Specification 1 |
30x |
Spec 1 |
Text |
FL_SPEC10 |
Specification 10 |
30x |
Spec 10 |
Text |
FL_SPEC11 |
Specification 11 |
30x |
Spec 11 |
Text |
FL_SPEC12 |
Specification 12 |
30x |
Spec 12 |
Text |
FL_SPEC13 |
Specification 13 |
30x |
Spec 13 |
Text |
FL_SPEC14 |
Specification 14 |
30x |
Spec 14 |
Text |
FL_SPEC15 |
Specification 15 |
30x |
Spec 15 |
Text |
FL_SPEC16 |
Specification 16 |
30x |
Spec 16 |
Text |
FL_SPEC17 |
Specification 17 |
30x |
Spec 17 |
Text |
FL_SPEC18 |
Specification 18 |
30x |
Spec 18 |
Text |
FL_SPEC19 |
Specification 19 |
30x |
Spec 19 |
Text |
FL_SPEC2 |
Specification 2 |
30x |
Spec 2 |
Text |
FL_SPEC20 |
Specification 20 |
30x |
Spec 20 |
Text |
FL_SPEC21 |
Specification 21 |
30x |
Spec 21 |
Text |
FL_SPEC22 |
Specification 22 |
30x |
Spec 22 |
Text |
FL_SPEC23 |
Specification 23 |
30x |
Spec 23 |
Text |
FL_SPEC24 |
Specification 24 |
30x |
Spec 24 |
Text |
FL_SPEC25 |
Specification 25 |
30x |
Spec 25 |
Text |
FL_SPEC26 |
Specification 26 |
30x |
Spec 26 |
Text |
FL_SPEC27 |
Specification 27 |
30x |
Spec 27 |
Text |
FL_SPEC28 |
Specification 28 |
30x |
Spec 28 |
Text |
FL_SPEC29 |
Specification 29 |
30x |
Spec 29 |
Text |
FL_SPEC3 |
Specification 3 |
30x |
Spec 3 |
Text |
FL_SPEC30 |
Specification 30 |
30x |
Spec 30 |
Text |
FL_SPEC4 |
Specification 4 |
30x |
Spec 4 |
Text |
FL_SPEC5 |
Specification 5 |
30x |
Spec 5 |
Text |
FL_SPEC6 |
Specification 6 |
30x |
Spec 6 |
Text |
FL_SPEC7 |
Specification 7 |
30x |
Spec 7 |
Text |
FL_SPEC8 |
Specification 8 |
30x |
Spec 8 |
Text |
FL_SPEC9 |
Specification 9 |
30x |
Spec 9 |
Text |
FL_ST_ID |
Site Rec # |
nnnnnnnn |
Long Integer |
|
FL_STRT_DT |
Start Date |
mm/dd/yyyy |
Starting Date |
Date/Time |
FL_STRTCST |
Starting Cost |
nnnnnnnn.nn |
Starting Cost |
Double |
FL_STRTHR |
Starting Hourmeter |
nnnnnnn.nn |
Starting Hourmeter Reading |
Double |
FL_STRTODO |
Starting Odometer |
nnnnnnn.n |
Starting Odometer Reading |
Double |
FL_STRTOTH |
Starting Other Meter |
nnnnnnnn.nn |
Other Meter starting Reading |
Double |
FL_STYPE_CD |
SubType |
nnn |
SubType |
Integer |
FL_STYPE_TY |
SubType Text |
25x |
SubType Text |
Text |
FL_TITLE |
Title |
30x |
Title |
Text |
FL_TWOCST |
Total W.O. Cost |
nnnnnnnn.nn |
Total Work Order Cost |
Double |
FL_USEHRS |
Usable Hrs/Yr |
nnnn |
Usable Hrs/Yr |
Integer |
FL_USER10 |
User 10 |
mm/dd/yyyy |
User 10 |
Date/Time |
FL_USER11 |
User 11 |
mm/dd/yyyy |
User 11 |
Date/Time |
FL_USER12 |
User 12 |
mm/dd/yyyy |
User 12 |
Date/Time |
FL_USER13 |
User 13 |
|
User 13 |
Boolean |
FL_USER14 |
User 14 |
|
User 14 |
Boolean |
FL_USER15 |
User 15 |
|
User 15 |
Boolean |
FL_USER16 |
User 16 |
|
User 13 |
Boolean |
FL_USER17 |
User 17 |
|
User 14 |
Boolean |
FL_USER18 |
User 18 |
|
User 15 |
Boolean |
FL_USER19_CD |
User 19 |
12x |
User 19 |
Text |
FL_USER19_TY |
User 19 Text |
60x |
User 19 Text |
Text |
FL_USER1CD |
User 1 |
nnn |
User 1 |
Integer |
FL_USER1TY |
User 1 Text |
25x |
User 1 Type |
Text |
FL_USER20_CD |
User 20 |
12x |
User 20 |
Text |
FL_USER20_TY |
User 20 Text |
60x |
User 20 Text |
Text |
FL_USER21 |
User 21 |
50x |
User 21 |
String |
FL_USER22 |
User 22 |
50x |
User 22 |
String |
FL_USER23 |
User 23 |
50x |
User 23 |
String |
FL_USER24 |
User 24 |
50x |
User 24 |
String |
FL_USER25 |
User 25 |
50x |
User 25 |
String |
FL_USER26 |
User 26 |
-nnnnnnnn.nn |
User 26 |
Double |
FL_USER27 |
User 27 |
-nnnnnnnn.nn |
User 27 |
Double |
FL_USER28 |
User 28 |
-nnnnnnnn.nn |
User 28 |
Double |
FL_USER29 |
User 29 |
-nnnnnnnn.nn |
User 29 |
Double |
FL_USER2CD |
User 2 |
nnn |
User 2 |
Integer |
FL_USER2TY |
User 2 Text |
25x |
User 2 Type |
Text |
FL_USER30 |
User 30 |
-nnnnnnnn.nn |
User 30 |
Double |
FL_USER31 |
User 31 |
mm/dd/yyyy |
User 31 |
DateTime |
FL_USER32 |
User 32 |
mm/dd/yyyy |
User 32 |
DateTime |
FL_USER33 |
User 33 |
mm/dd/yyyy |
User 33 |
DateTime |
FL_USER34 |
User 34 |
mm/dd/yyyy |
User 34 |
DateTime |
FL_USER35 |
User 35 |
mm/dd/yyyy |
User 35 |
DateTime |
FL_USER36 |
User 36 |
|
User 36 |
Boolean |
FL_USER37 |
User 37 |
|
User 37 |
Boolean |
FL_USER38 |
User 38 |
|
User 38 |
Boolean |
FL_USER39 |
User 39 |
|
User 39 |
Boolean |
FL_USER3CD |
User 3 |
nnn |
User 3 |
Integer |
FL_USER3TY |
User 3 Text |
25x |
User 3 Type |
Text |
FL_USER40 |
User 40 |
|
User 40 |
Boolean |
FL_USER41CD |
User 41 |
nnn |
User 41 |
Small Integer |
FL_USER41TY |
User 41 Text |
50x |
User 41 Text |
String |
FL_USER42CD |
User 42 |
nnn |
User 42 |
Small Integer |
FL_USER42TY |
User 42 Text |
50x |
User 42 Text |
String |
FL_USER43CD |
User 43 |
nnn |
User 43 |
Small Integer |
FL_USER43TY |
User 43 Text |
50x |
User 43 Text |
String |
FL_USER44CD |
User 44 |
nnn |
User 44 |
Small Integer |
FL_USER44TY |
User 44 Text |
50x |
User 44 Text |
String |
FL_USER45CD |
User 45 |
nnn |
User 45 |
Small Integer |
FL_USER45TY |
User 45 Text |
50x |
User 45 Text |
String |
FL_USER4 |
User 4 |
30x |
User 4 |
Text |
FL_USER5 |
User 5 |
30x |
User 5 |
Text |
FL_USER6 |
User 6 |
30x |
User 6 |
Text |
FL_USER7 |
User 7 |
nnnnnnnn.nn |
User 7 |
Double |
FL_USER8 |
User 8 |
nnnnnnnn.nn |
User 8 |
Double |
FL_USER9 |
User 9 |
nnnnnnnn.nn |
User 9 |
Double |
FL_VEH_CD |
Fleet ID |
20x |
Fleet:Unique ID |
Text |
FL_VEH_TY |
Fleet ID Text |
50x |
Description |
Text |
FL_VENDOR |
Vendor |
30x |
Vendor |
Text |
FL_VIN |
VIN |
30x |
VIN |
Text |
FL_VL_ID |
Vendor Rec # |
nnnnnnnn |
Vendor Rec # |
Long Integer |
FL_WO_COMM |
WO Comment |
255x |
Short Work Order Comment |
Text |
FL_X_COORD |
X Coordinate |
-nnnnnnnnn.nnnnnnnn |
X Coordinate |
Double |
FL_Y_COORD |
Y Coordinate |
-nnnnnnnnn.nnnnnnnn |
Y Coordinate |
Double |
FL_YEAR |
Year |
30x |
Year |
Text |
FL_Z_COORD |
Z Coordinate |
-nnnnnnnnn.nn |
Z Coordinate |
Double |