Floor Inventory
Field Name |
Caption |
Mask |
Description |
Field Type |
BF_AACCOUNT |
Asset Account # |
45x |
Asset Account # |
Text |
BF_ACCESS_CD |
Access Type |
nnn |
Access Type |
Integer |
BF_ACCESS_TY |
Access Type Text |
50x |
Access Type Text |
Text |
BF_APNUMACT |
Asset Proj No - Acct |
40x |
Asset Proj No - Acct |
Text |
BF_AREA |
Area |
nnnnnn.nn |
Area |
Double |
BF_AZONE_CD |
Alternate Zone |
10x |
Alternate Zone |
String |
BF_AZONE_TY |
Alternate Zone Text |
60x |
Alternate Zone Text |
String |
BF_BELEV |
Base Elevation |
-nnnnnnnn.nn |
Base Elevation |
Double |
BF_BL_ID |
Bldg Rec # |
nnnnnnnn |
Long Integer |
|
BF_BR_CD |
Default WO Cat |
10x |
Category |
Text |
BF_BR_TY |
Default WO Cat Text |
60x |
Category Text |
Text |
BF_CECNDCD |
Ceiling Cond |
nnn |
Ceiling Cond |
Integer |
BF_CECNDTY |
Ceiling Cond Text |
25x |
Ceiling Cond Text |
Text |
BF_CEIL_CD |
Ceiling |
nnn |
Ceiling |
Integer |
BF_CEIL_HT |
Ceiling Height |
nnn.nn |
Ceiling Height |
Double |
BF_CEIL_TY |
Ceiling Text |
25x |
Ceiling Text |
Text |
BF_CEINSP |
Ceiling Insp |
mm/dd/yyyy |
Ceiling Insp |
Date/Time |
BF_COMMENT1 |
Long Note |
|
Long Note |
Memo |
BF_COND_CD |
Last Condition Code |
nnn |
Last Condition Code |
Integer |
BF_COND_TY |
Last Condition Text |
100x |
Last Condition Text |
Text |
BF_CONFER |
Conference Room |
|
Conference Room |
Boolean |
BF_CRT_BY |
Created By |
25x |
Created By |
Text |
BF_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
BF_DESCR |
Floor ID Text |
40x |
Floor Description |
Text |
BF_DOC_FLG |
Document Available |
|
Document Flag |
Boolean |
BF_FASSET |
Fixed Asset ID |
nnnnnnnn |
Fixed Asset ID |
Long Integer |
BF_FLCNDCD |
Flooring Cond |
nnn |
Flooring Cond |
Integer |
BF_FLCNDTY |
Flooring Cond Text |
25x |
Flooring Cond Text |
Text |
BF_FLINSP |
Flooring Insp |
mm/dd/yyyy |
Flooring Insp |
Date/Time |
BF_FLOORCD |
Flooring Type |
nnn |
Flooring Type |
Integer |
BF_FLOORTY |
Flooring Type Text |
25x |
Flooring Type Text |
Text |
BF_FNUM |
Floor Number |
5x |
Floor Number |
Text |
BF_GISNEED_CD |
Needs GIS |
nnn |
Needs GIS |
Integer |
BF_GISNEED_TY |
Needs GIS Text |
100x |
Needs GIS Text |
Text |
BF_HEIGHT |
Floor Height |
-nnnnnnnn.nn |
Floor Height |
Double |
BF_ID |
Floor Rec # |
nnnnnnnn |
AutoNumber |
Long Integer |
BF_IFREQ |
Inspection Freq |
nnn |
Inspection Freq |
Integer |
BF_IFRQ_CD |
Inspection Freq Units |
nnn |
Inspection Freq Units |
Integer |
BF_IFRQ_TY |
Inspection Freq Units Text |
10x |
Inspection Freq Units Text |
Text |
BF_IMG_FLG |
|
|
Image Flag |
Boolean |
BF_INMAP |
In Map? |
|
In Map Flag |
Boolean |
BF_LAST_DT |
Last Condition Date |
mm/dd/yyyy hh:mm am |
Last Condition Date |
DateTime |
BF_LICNDCD |
Lighting Cond |
nnn |
Lighting Cond |
Integer |
BF_LICNDTY |
Lighting Cond Text |
25x |
Lighting Cond Text |
Text |
BF_LIGHTCD |
Lighting |
nnn |
Lighting |
Integer |
BF_LIGHTTY |
Lighting Text |
25x |
Lighting Text |
Text |
BF_LIINSP |
Lighting Insp |
mm/dd/yyyy |
Lighting Insp |
Date/Time |
BF_LWOT_DT |
Last WO Task Date |
mm/dd/yyyy |
Last WO Task Date |
DateTime |
BF_MENS |
Men's Restroom |
|
Men's Restroom |
Boolean |
BF_MOD_BY |
Last Modified By |
25x |
Modified By |
Text |
BF_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Modified Date |
Date/Time |
BF_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
BF_MOV_FLG |
|
|
Movie Flag |
Boolean |
BF_MZONE_CD |
Maintenance Zone |
10x |
Maintenance Zone |
String |
BF_MZONE_TY |
Maintenance Zone Text |
60x |
Maintenance Zone Text |
String |
BF_NEXT_DT |
Next Inspection Date |
mm/dd/yyyy hh:mm am |
Next Inspection Date |
DateTime |
BF_NOWORK |
No WO/PM/Req |
|
No WO/PM/Req |
Boolean |
BF_ROOMS |
# of Room |
nnnn |
# of Room |
Integer |
BF_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
BF_SPEC1 |
Spec 1 |
30x |
Spec 1 |
Text |
BF_SPEC10 |
Spec 10 |
30x |
Spec 10 |
Text |
BF_SPEC11 |
Spec 11 |
30x |
Spec 11 |
Text |
BF_SPEC12 |
Spec 12 |
30x |
Spec 12 |
Text |
BF_SPEC13 |
Spec 13 |
30x |
Spec 13 |
Text |
BF_SPEC14 |
Spec 14 |
30x |
Spec 14 |
Text |
BF_SPEC15 |
Spec 15 |
30x |
Spec 15 |
Text |
BF_SPEC16 |
Spec 16 |
30x |
Spec 16 |
Text |
BF_SPEC17 |
Spec 17 |
30x |
Spec 17 |
Text |
BF_SPEC18 |
Spec 18 |
30x |
Spec 18 |
Text |
BF_SPEC19 |
Spec 19 |
30x |
Spec 19 |
Text |
BF_SPEC2 |
Spec 2 |
30x |
Spec 2 |
Text |
BF_SPEC20 |
Spec 20 |
30x |
Spec 20 |
Text |
BF_SPEC3 |
Spec 3 |
30x |
Spec 3 |
Text |
BF_SPEC4 |
Spec 4 |
30x |
Spec 4 |
Text |
BF_SPEC5 |
Spec 5 |
30x |
Spec 5 |
Text |
BF_SPEC6 |
Spec 6 |
30x |
Spec 6 |
Text |
BF_SPEC7 |
Spec 7 |
30x |
Spec 7 |
Text |
BF_SPEC8 |
Spec 8 |
30x |
Spec 8 |
Text |
BF_SPEC9 |
Spec 9 |
30x |
Spec 9 |
Text |
BF_STAT_CD |
Status |
nnn |
Status |
Integer |
BF_STAT_TY |
Status Text |
25x |
Status Text |
Text |
BF_UNIQUE |
Floor ID |
20x |
Unique Floor ID |
Text |
BF_UNISEX |
Unisex Restroom |
|
Unisex Restroom |
Boolean |
BF_USER10 |
User 10 |
mm/dd/yyyy |
User 10 |
Date/Time |
BF_USER11 |
User 11 |
mm/dd/yyyy |
User 11 |
Date/Time |
BF_USER12 |
User 12 |
mm/dd/yyyy |
User 12 |
Date/Time |
BF_USER13 |
User 13 |
|
User 13 |
Boolean |
BF_USER14 |
User 14 |
|
User 14 |
Boolean |
BF_USER15 |
User 15 |
|
User 15 |
Boolean |
BF_USER16CD |
User 16 |
nnn |
User 16 |
Small Integer |
BF_USER16TY |
User 16 Text |
50x |
User 16 Text |
String |
BF_USER17CD |
User 17 |
nnn |
User 17 |
Small Integer |
BF_USER17TY |
User 17 Text |
50x |
User 17 Text |
String |
BF_USER18CD |
User 18 |
nnn |
User 18 |
Small Integer |
BF_USER18TY |
User 18 Text |
50x |
User 18 Text |
String |
BF_USER19CD |
User 19 |
nnn |
User 19 |
Small Integer |
BF_USER19TY |
User 19 Text |
50x |
User 19 Text |
String |
BF_USER1CD |
User 1 |
nnn |
User 1 Code |
Integer |
BF_USER1TY |
User 1 Text |
25x |
User 1 Text |
Text |
BF_USER20CD |
User 20 |
nnn |
User 20 |
Small Integer |
BF_USER20TY |
User 20 Text |
50x |
User 20 Text |
String |
BF_USER21 |
User 21 |
50x |
User 21 |
String |
BF_USER22 |
User 22 |
50x |
User 22 |
String |
BF_USER23 |
User 23 |
50x |
User 23 |
String |
BF_USER24 |
User 24 |
50x |
User 24 |
String |
BF_USER25 |
User 25 |
50x |
User 25 |
String |
BF_USER26 |
User 26 |
-nnnnnnnn.nn |
User 26 |
Double |
BF_USER27 |
User 27 |
-nnnnnnnn.nn |
User 27 |
Double |
BF_USER28 |
User 28 |
-nnnnnnnn.nn |
User 28 |
Double |
BF_USER29 |
User 29 |
-nnnnnnnn.nn |
User 29 |
Double |
BF_USER2CD |
User 2 |
nnn |
User 2 Code |
Integer |
BF_USER2TY |
User 2 Text |
25x |
User 2 Text |
Text |
BF_USER30 |
User 30 |
-nnnnnnnn.nn |
User 30 |
Double |
BF_USER31 |
User 31 |
mm/dd/yyyy |
User 31 |
DateTime |
BF_USER32 |
User 32 |
mm/dd/yyyy |
User 32 |
DateTime |
BF_USER33 |
User 33 |
mm/dd/yyyy |
User 33 |
DateTime |
BF_USER34 |
User 34 |
mm/dd/yyyy |
User 34 |
DateTime |
BF_USER35 |
User 35 |
mm/dd/yyyy |
User 35 |
DateTime |
BF_USER36 |
User 36 |
|
User 36 |
Boolean |
BF_USER37 |
User 37 |
|
User 37 |
Boolean |
BF_USER38 |
User 38 |
|
User 38 |
Boolean |
BF_USER39 |
User 39 |
|
User 39 |
Boolean |
BF_USER3CD |
User 3 |
nnn |
User 3 Code |
Integer |
BF_USER3TY |
User 3 Text |
25x |
User 3 Text |
Text |
BF_USER40 |
User 40 |
|
User 40 |
Boolean |
BF_USER4 |
User 4 |
30x |
User 4 |
Text |
BF_USER5 |
User 5 |
30x |
User 5 |
Text |
BF_USER6 |
User 6 |
30x |
User 6 |
Text |
BF_USER7 |
User 7 |
-nnnnnnnn.nn |
User 7 |
Double |
BF_USER8 |
User 8 |
-nnnnnnnn.nn |
User 8 |
Double |
BF_USER9 |
User 9 |
-nnnnnnnn.nn |
User 9 |
Double |
BF_VORDER |
Vertical Order |
nnnn |
Vertical Order |
Integer |
BF_WO_COMM |
WO Comment |
255x |
Short Work Order Comment |
Text |
BF_WOMENS |
Women's Restroom |
|
Women's Restroom |
Boolean |
BF_X |
X Coordinate |
-nnnnnnnn.nn |
X Coordinate |
Double |
BF_Y |
Y Coordinate |
-nnnnnnnn.nn |
Y Coordinate |
Double |