Furnishings Inventory
Field Name |
Caption |
Mask |
Description |
Field Type |
BN_AACCOUNT |
Asset Account # |
45x |
Asset Account # |
Text |
BN_APNUMACT |
Asset Proj No - Acct |
40x |
Asset Proj No - Acct |
Text |
BN_ASSIGN |
Person Assigned To |
30x |
Person Assigned To |
Text |
BN_AZONE_CD |
Alternate Zone |
10x |
Alternate Zone |
String |
BN_AZONE_TY |
Alternate Zone Text |
60x |
Alternate Zone Text |
String |
BN_BARCOD |
Bar Code |
20x |
Bar Code |
Text |
BN_BL_ID |
Building Rec # |
-nnnnnnnn |
Long Integer |
|
BN_BR_CD |
Default WO Cat |
10x |
Default Category Code |
Text |
BN_BR_ID |
Room Rec # |
nnnnnnnn |
Long Integer |
|
BN_BR_TY |
Default WO Cat Text |
60x |
Default Category Text |
Text |
BN_COF |
Consequence of Failure |
-nnnnnnnn.nn |
Consequence of Failure |
Double |
BN_COMMENT1 |
Long Note |
|
Long Note |
Memo |
BN_CONDCD |
Condition |
nnn |
Condition |
Integer |
BN_CONDTY |
Condition Text |
25x |
Condition Text |
Text |
BN_CRT_BY |
Created By |
25x |
Created By |
Text |
BN_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
BN_CVALUE |
Current Value |
nnnnnnnn.nn |
Current Value |
Double |
BN_DESC |
Description |
50x |
Description |
Text |
BN_DOC_FLG |
Document Available |
|
Document Flag |
Boolean |
BN_EXPLIFE |
Expected Life |
nnn |
Expected life in months |
Integer |
BN_FASSET |
Fixed Asset ID |
nnnnnnnn |
Fixed Asset ID |
Long Integer |
BN_GISNEED_CD |
Needs GIS |
nnn |
Needs GIS |
Integer |
BN_GISNEED_TY |
Needs GIS Text |
100x |
Needs GIS Text |
Text |
BN_ID |
Furn Rec # |
nnnnnnnn |
Furn Record No |
Long Integer |
BN_IMG_FLG |
|
|
Image Flag |
Boolean |
BN_INITCST |
Initial Cost |
nnnnnnnn.nn |
Initial Cost |
Double |
BN_INMAP |
In Map Flag |
|
|
Boolean |
BN_INSP_DT |
Inspection Date |
mm/dd/yyyy |
Inspection Date |
Date/Time |
BN_INST_DT |
Installed Date |
mm/dd/yyyy |
Installed Date |
Date/Time |
BN_LWOT_DT |
Last WO Task Date |
mm/dd/yyyy |
Last WO Task Date |
DateTime |
BN_MAN |
Manufacturer |
30x |
Manufacturer |
Text |
BN_MITIGAT |
Mitigation |
-nnnnnnnn.nn |
Mitigation |
Double |
BN_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
BN_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Modification Date |
Date/Time |
BN_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
BN_MODEL |
Model Number |
30x |
Model Number |
Text |
BN_MOV_FLG |
|
|
Movie Flag |
Boolean |
BN_MZONE_CD |
Maintenance Zone |
10x |
Maintenance Zone |
String |
BN_MZONE_TY |
Maintenance Zone Text |
60x |
Maintenance Zone Text |
String |
BN_NOWORK |
No WO/PM/Req |
|
No WO/PM/Req |
Boolean |
BN_POF |
Probability of Failure |
-nnnnnnnn.nn |
Probability of Failure |
Double |
BN_QUAN |
Quantity |
nnnn.nn |
Quantity |
Double |
BN_REP_DT |
Replacement Date |
mm/dd/yyyy |
Est. Replacement Date |
Date/Time |
BN_REPCOST |
Replacement Cost |
nnnnnn.nn |
Replacement Cost |
Double |
BN_RISK |
Risk |
-nnnnnnnn.nn |
Risk |
Double |
BN_RLIFE |
Remaining Life |
-nnnnnnnn.nn |
Remaining Life |
Double |
BN_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
BN_SERIAL |
Serial Number |
30x |
Serial Number |
Text |
BN_STAT_CD |
Status |
nnn |
Status |
Integer |
BN_STAT_DT |
Status Date |
mm/dd/yyyy |
Status Date |
Date/Time |
BN_STAT_TM |
Status Time |
hh:mm am |
Status Time |
Date/Time |
BN_STAT_TY |
Status Text |
25x |
Status Text |
Text |
BN_SVALUE |
Salvage Value |
nnnnnnnn.nn |
Salvage Value |
Double |
BN_TYPECD |
Type |
6x |
Type |
Text |
BN_TYPETY |
Type Text |
50x |
Type Text |
Text |
BN_UNIF_CD |
Uniformat II |
10x |
Uniformat II |
String |
BN_UNIF_TY |
Uniformat II Text |
60x |
Uniformat II Text |
String |
BN_UNIQUE |
Furn ID |
20x |
Furniture ID |
Text |
BN_USER10 |
User 10 |
mm/dd/yyyy |
User 10 |
Date/Time |
BN_USER11 |
User 11 |
mm/dd/yyyy |
User 11 |
Date/Time |
BN_USER12 |
User 12 |
mm/dd/yyyy |
User 12 |
Date/Time |
BN_USER13 |
User 13 |
|
User 13 |
Boolean |
BN_USER14 |
User 14 |
|
User 14 |
Boolean |
BN_USER15 |
User 15 |
|
User 15 |
Boolean |
BN_USER16CD |
User 16 |
nnn |
User 16 |
Small Integer |
BN_USER16TY |
User 16 Text |
50x |
User 16 Text |
String |
BN_USER17CD |
User 17 |
nnn |
User 17 |
Small Integer |
BN_USER17TY |
User 17 Text |
50x |
User 17 Text |
String |
BN_USER18CD |
User 18 |
nnn |
User 18 |
Small Integer |
BN_USER18TY |
User 18 Text |
50x |
User 18 Text |
String |
BN_USER19CD |
User 19 |
nnn |
User 19 |
Small Integer |
BN_USER19TY |
User 19 Text |
50x |
User 19 Text |
String |
BN_USER1CD |
User 1 |
nnn |
User 1 Code |
Integer |
BN_USER1TY |
User 1 Text |
25x |
User 1 Text |
Text |
BN_USER20CD |
User 20 |
nnn |
User 20 |
Small Integer |
BN_USER20TY |
User 20 Text |
50x |
User 20 Text |
String |
BN_USER21 |
User 21 |
50x |
User 21 |
String |
BN_USER22 |
User 22 |
50x |
User 22 |
String |
BN_USER23 |
User 23 |
50x |
User 23 |
String |
BN_USER24 |
User 24 |
50x |
User 24 |
String |
BN_USER25 |
User 25 |
50x |
User 25 |
String |
BN_USER26 |
User 26 |
-nnnnnnnn.nn |
User 26 |
Double |
BN_USER27 |
User 27 |
-nnnnnnnn.nn |
User 27 |
Double |
BN_USER28 |
User 28 |
-nnnnnnnn.nn |
User 28 |
Double |
BN_USER29 |
User 29 |
-nnnnnnnn.nn |
User 29 |
Double |
BN_USER2CD |
User 2 |
nnn |
User 2 Code |
Integer |
BN_USER2TY |
User 2 Text |
25x |
User 2 Text |
Text |
BN_USER30 |
User 30 |
-nnnnnnnn.nn |
User 30 |
Double |
BN_USER31 |
User 31 |
mm/dd/yyyy |
User 31 |
DateTime |
BN_USER32 |
User 32 |
mm/dd/yyyy |
User 32 |
DateTime |
BN_USER33 |
User 33 |
mm/dd/yyyy |
User 33 |
DateTime |
BN_USER34 |
User 34 |
mm/dd/yyyy |
User 34 |
DateTime |
BN_USER35 |
User 35 |
mm/dd/yyyy |
User 35 |
DateTime |
BN_USER36 |
User 36 |
|
User 36 |
Boolean |
BN_USER37 |
User 37 |
|
User 37 |
Boolean |
BN_USER38 |
User 38 |
|
User 38 |
Boolean |
BN_USER39 |
User 39 |
|
User 39 |
Boolean |
BN_USER3CD |
User 3 |
nnn |
User 3 Code |
Integer |
BN_USER3TY |
User 3 Text |
25x |
User 3 Text |
Text |
BN_USER40 |
User 40 |
|
User 40 |
Boolean |
BN_USER4 |
User 4 |
30x |
User 4 |
Text |
BN_USER5 |
User 5 |
30x |
User 5 |
Text |
BN_USER6 |
User 6 |
30x |
User 6 |
Text |
BN_USER7 |
User 7 |
-nnnnnnnn.nn |
User 7 |
Double |
BN_USER8 |
User 8 |
-nnnnnnnn.nn |
User 8 |
Double |
BN_USER9 |
User 9 |
-nnnnnnnn.nn |
User 9 |
Double |
BN_WO_COMM |
WO Comment |
255x |
Short Work Order Comment |
Text |
BN_X |
X Coordinate |
-nnnnnnnn.nn |
X Coordinate |
Double |
BN_Y |
Y Coordinate |
-nnnnnnnn.nn |
Y Coordinate |
Double |