Daily Inspection Equipment
Field Name |
Caption |
Mask |
Description |
Field Type |
DQ_ALTDESC |
Alt Description |
40x |
Alt Description |
Text |
DQ_CODE |
Equipment |
20x |
Equipment Code |
Text |
DQ_CRT_BY |
Created By |
25x |
Created By |
Text |
DQ_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
DQ_DESC |
Equipment Description |
50x |
Equipment Text |
Text |
DQ_DI_ID |
Daily Insp Rec # |
nnnnnnnn |
Long Integer |
|
DQ_ID |
Daily Equip Rec # |
nnnnnnnn |
Equip Res Rec # |
Long Integer |
DQ_INUSE |
In Use |
|
In Use - TRUE means being used |
Boolean |
DQ_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
DQ_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
DQ_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
DQ_MODEL |
Model |
40x |
Model |
Text |
DQ_NOTINUSE |
Not In Use |
|
Not in Use - TRUE means not in use |
Boolean |
DQ_QUANT |
Quantity |
nnn |
Quantity |
Integer |
DQ_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
DQ_USER10 |
User 10 |
mm/dd/yyyy hh:mm am |
User 10 |
DateTime |
DQ_USER11 |
User 11 |
mm/dd/yyyy hh:mm am |
User 11 |
DateTime |
DQ_USER12 |
User 12 |
mm/dd/yyyy hh:mm am |
User 12 |
DateTime |
DQ_USER13 |
User 13 |
|
User 13 |
Boolean |
DQ_USER14 |
User 14 |
|
User 14 |
Boolean |
DQ_USER15 |
User 15 |
|
User 15 |
Boolean |
DQ_USER1CD |
User 1 |
nnn |
User 1 |
integer |
DQ_USER1TY |
User 1 Text |
25x |
User 1 Text |
String |
DQ_USER2CD |
User 2 |
nnn |
User 2 |
integer |
DQ_USER2TY |
User 2 Text |
25x |
User 2 Text |
String |
DQ_USER3CD |
User 3 |
nnn |
User 3 |
integer |
DQ_USER3TY |
User 3 Text |
25x |
User 3 Text |
String |
DQ_USER4 |
User 4 |
50x |
User 4 |
String |
DQ_USER5 |
User 5 |
50x |
User 5 |
String |
DQ_USER6 |
User 6 |
50x |
User 6 |
String |
DQ_USER7 |
User 7 |
nnnnnnnn.nn |
User 7 |
Double |
DQ_USER8 |
User 8 |
nnnnnnnn.nn |
User 8 |
Double |
DQ_USER9 |
User 9 |
nnnnnnnn.nn |
User 9 |
Double |