SWIPTBHPA

Field Name

Caption

Mask

Description

Field Type

HP_AL

Average Loading

nnnnnnnn.nnnnnn

Average Loading

Double

HP_BH_ID

MP Billing History Rec #

nnnnnnnn

Link to SWIPTBH.BH_ID

Long Integer

HP_CHARGE

Charge

nnnnnnnn.nnnnnn

Charge

Double

HP_CRT_BY

Created By

25x

Created By

Text

HP_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

HP_DA

Domestic Allowance

nnnnnnnn.nn

Domestic Allowance

Double

HP_EXCESS

Excess

nnnnnnnn.nnnnnn

Excess

Double

HP_ID

MP Billing 12YR Ave Rec #

nnnnnnnn

MP Billing 12YR Ave Rec #

Long Integer

HP_LBS

Pounds

nnnnnnnn.nnnnnn

Pounds

Double

HP_MG

Milligrams

nnnnnnnnnnnnnnn.nnnnnnnn

Milligrams

Double

HP_MGPP

Milligrams per Pound

nnnnnnnn.nn

Milligrams per Pound

Double

HP_MOD_BY

Last Mod By

25x

Last Modified By

Text

HP_MOD_DT

Last Mod Date

mm/dd/yyyy

Last Modified Date

Date/Time

HP_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

HP_PARA_CD

Parameter

5x

Parameter

Text

HP_PARA_TY

Parameter Text

60x

Parameter Text

Text

HP_ROWVER

Rowversion for optimistic locking

Date/Time

HP_UOM_CD

UOM

10x

UOM

Text

HP_UOM_TY

UOM Text

60x

UOM Text

Text

HP_UR

Unit Rate

nnnnnnnn.nnnn

Unit Rate

Double