Water Test Request - Pipes Tested for Contracts
Field Name |
Caption |
Mask |
Description |
Field Type |
ZJ_COMMENT1 |
Long Note |
|
Long Note |
Memo |
ZJ_CRT_BY |
Created By |
25x |
Created By |
Text |
ZJ_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
DateTime |
ZJ_DOC_FLG |
Document Available |
|
Document Available |
Boolean |
ZJ_ID |
Water Pipes Tested Rec # |
nnnnnnnn |
Water Pipes Tested Rec # AutoID |
Long Integer |
ZJ_LENGTH |
Length |
nnnnnnnn.nn |
Length |
Double |
ZJ_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
ZJ_MOD_DT |
Last Modified Date |
mm/dd/yyyy hh:mm am |
Last Modified Date |
DateTime |
ZJ_MOD_TM |
Modified Time |
mm/dd/yyyy hh:mm am |
Modified Time |
DateTime |
ZJ_PSIZE |
Pipe Size |
nnnnnnnn.nn |
Pipe Size |
Double |
ZJ_PTYP_CD |
Pipe Type |
20x |
Pipe Type |
Text |
ZJ_PTYP_TY |
Pipe Type Text |
100x |
Pipe Type Text |
Text |
ZJ_ROWVER |
Rowversion for optimistic locking |
|
Rowversion for optimistic locking |
TimeStamp |
ZJ_ZL_ID |
Water Test Request Rec # - Link to WKPROJWT table |
nnnnnnnn |
Water Test Request Rec # - Link to WKPROJWT table |
Long Integer |