Pavement Field Recommendations
Field Name |
Caption |
Mask |
Description |
Field Type |
FZ_CRT_BY |
Created By |
25x |
Created By |
Text |
FZ_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
FZ_DOC_FLG |
Document Available |
|
Doc Available: Doc Flag |
Boolean |
FZ_FD_ID |
Field Insp Rec # |
nnnnnnnn |
Long Integer |
|
FZ_ID |
Auto Number |
nnnnnnnn |
|
Long Integer |
FZ_MOD_BY |
Last Modified By |
25x |
Modified By |
Text |
FZ_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Modified Date |
Date/Time |
FZ_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
FZ_PRIOR |
Priority |
nnn |
Priority |
Integer |
FZ_REC_CD |
Recommendation |
nnn |
Recommendation |
Integer |
FZ_REC_TY |
Recommendation Text |
25x |
Recommendation Text |
Text |
FZ_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |