WKPROJCWT

Water Test Request - Pipes Tested for Contracts

Field Name

Caption

Mask

Description

Field Type

YE_COMMENT1

Long Note

 

Long Note

Memo

YE_CRT_BY

Created By

25x

Created By

String

YE_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

DateTime

YE_DOC_FLG

Document Available

 

Document Available

Boolean

YE_ID

Water Pipes Tested Rec #

nnnnnnnn

Water Pipes Tested AutoID

Long Integer

YE_LENGTH

Length

nnnnnnnn.nn

Length

Double

YE_MOD_BY

Last Modified By

25x

Last Modified By

String

YE_MOD_DT

Last Modified Date

mm/dd/yyyy hh:mm am

Last Modified Date

DateTime

YE_MOD_TM

Modified Time

mm/dd/yyyy hh:mm am

Modified Time

DateTime

YE_PSIZE

Pipe Size

nnnnnnnn.nn

Pipe Size

Double

YE_PTYE_CD

Pipe Type

20x

Pipe Type

String

YE_PTYE_TY

Pipe Type Text

60x

Pipe Type Text

String

YE_ROWVER

Rowversion for optimistic locking

 

Rowversion for optimistic locking

TimeStamp

YE_XW_ID

Water Test Request Rec # - Link to WKPROJCW table

nnnnnnnn

Link to WKPROJCW.XW_ID

Long Integer