SMQSD

Field Name

Caption

Mask

Description

Field Type

HD_CRT_BY

Created By

25x

Created By

String

HD_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

DateTime

HD_DN_ID

Detention Basin Rec #

nnnnnnnn

Link to SMVDBASN.DN_ID

Long Integer

HD_ID

Construction Site Detention Basin Rec #

nnnnnnnn

Auto ID

Long Integer

HD_MOD_BY

Last Modified By

25x

Last Modified By

String

HD_MOD_DT

Last Modified Date

mm/dd/yyyy hh:mm am

Last Modified Date

DateTime

HD_MOD_TM

Modified Time

mm/dd/yyyy hh:mm am

Modified Time

DateTime

HD_QS_ID

Construction Site Rec #

nnnnnnnn

Link to SMQS.QS_ID

Long Integer

HD_ROWVER

Rowversion for optimistic locking

TimeStamp