PKMETWL

Park Water Meter Reading/Consumption Library

Field Name

Caption

Mask

Description

Field Type

MS_APRTC

April Target Consumption in inches

nnnnnnnn.nn

April Target Consumption in inches

Double

MS_AUGTC

August Target Consumption in inches

nnnnnnnn.nn

August Target Consumption in inches

Double

MS_CRT_BY

Created By

25x

Created By

String

MS_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

DateTime

MS_DECTC

December Target Consumption in inches

nnnnnnnn.nn

December Target Consumption in inches

Double

MS_FEBTC

February Target Consumption in inches

nnnnnnnn.nn

February Target Consumption in inches

Double

MS_ID

Water Meter Lib Rec #

nnnnnnnn

Water Meter Lib Rec #

Long Integer

MS_JANTC

January Target Consumption in inches

nnnnnnnn.nn

January Target Consumption in inches

Double

MS_JULTC

July Target Consumption in inches

nnnnnnnn.nn

July Target Consumption in inches

Double

MS_JUNTC

June Target Consumption in inches

nnnnnnnn.nn

June Target Consumption in inches

Double

MS_MARTC

March Target Consumption in inches

nnnnnnnn.nn

March Target Consumption in inches

Double

MS_MAYTC

May Target Consumption in inches

nnnnnnnn.nn

May Target Consumption in inches

Double

MS_MOD_BY

Last Modified By

25x

Last Modified By

String

MS_MOD_DT

Last Modified Date

mm/dd/yyyy hh:mm am

Last Modified Date

DateTime

MS_MOD_TM

Modified Time

mm/dd/yyyy hh:mm am

Modified Time

DateTime

MS_MT_ID

Meter Rec #

nnnnnnnn

Link to PKMETER.MT_ID

Long Integer

MS_NOVTC

November Target Consumption in inches

nnnnnnnn.nn

November Target Consumption in inches

Double

MS_OCTTC

October Target Consumption in inches

nnnnnnnn.nn

October Target Consumption in inches

Double

MS_RATE

Water Rate (in Ccf)

nnnnnnnn.nn

Water Rate (in Ccf)

Double

MS_ROWVER

 

 

Rowversion for optimistic locking

TimeStamp

MS_SEPTC

September Target Consumption in inches

nnnnnnnn.nn

September Target Consumption in inches

Double