SWIPTBHPAH

Sewer IPT MP Billing 12YR Ave Summation

Field Name

Caption

Mask

Description

Field Type

HH_CRT_BY

Created By

25x

Created By

Text

HH_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

HH_DATE_DT

Date

mm/dd/yyyy

Date

Date/Time

HH_HP_ID

MP Billing 12YR Ave Rec #

nnnnnnnn

Link to SWIPTBHPA.HP_ID

Long Integer

HH_ID

MP 12YR History Rec #

nnnnnnnn

MP 12YR History Rec #

Long Integer

HH_MOD_BY

Last Mod By

25x

Last Modified By

Text

HH_MOD_DT

Last Mod Date

mm/dd/yyyy

Last Modified Date

Date/Time

HH_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

HH_PARA_CD

Parameter

5x

Parameter

Text

HH_PARA_TY

Parameter Text

60x

Parameter Text

Text

HH_RESULT

Result

nnnnnnnnn.nn

Result

Double

HH_ROWVER

 

 

Rowversion for optimistic locking

Date/Time

HH_SAMPLE

Sample ID

90x

Sample Name

Text

HH_UOM_CD

UOM

10x

UOM

Text

HH_UOM_TY

UOM Text

60x

UOM Text

Text