SWIPTBH

Field Name

Caption

Mask

Description

Field Type

BH_AA

Admin Adjustment

nnnnnnnn.nn

Administrative Adjustment

Double

BH_BC

Base Charge

nnnnnnnn.nn

Base Charge

Double

BH_CREDIT

Credit

nnnnnnnn.nn

Credit

Double

BH_CRT_BY

Created By

25x

Created By

Text

BH_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

BH_CSC

Calc Sanitary Credit

nnnnnnnn.nn

Calculated Sanitary Credit

Double

BH_CSTC

Calc Storm Credit

nnnnnnnn.nn

Calculated Storm Credit

Double

BH_CSTMVL

Calc Storm Vol

nnnnnnnn.nn

Calculated Stormwater Volume

Double

BH_DATE_DT

Date

mm/dd/yyyy

Date

Date/Time

BH_DOC_FLG

Document Available

Document Flag

Boolean

BH_ECLF

Extra Chemical Load Fees

nnnnnnnn.nn

Extra Chemical Load Fees

Double

BH_EFFLU

Metered Effl Vol

nnnnnnnn.nn

Metered Effluent Volume

Double

BH_EVAPC

Evaporation Credit

nnnnnnnn.nn

Evaporation Credit

Double

BH_FINE

Fine

nnnnnnnn.nn

Fine

Double

BH_HAULED

Hauled Water Vol

nnnnnnnn.nn

Hauled Water Volume

Double

BH_ID

MP Billing History Rec #

nnnnnnnn

MP Billing History Rec #

Long Integer

BH_IF_ID

IPT Facility Rec #

nnnnnnnn

Link to SWIPTF.IF_ID

Long Integer

BH_IPC

In-Process Credit

nnnnnnnn.nn

In-Process Credit

Double

BH_IRRC

Irrigation Credit

nnnnnnnn.nn

Irrigation Credit

Double

BH_LTF

Laboratory Test Fees

nnnnnnnn.nn

Laboratory Test Fees

Double

BH_MF_ID

IPT Monitoring Pnt Rec #

nnnnnnnn

Link to SWIPTFM.MF_ID

Long Integer

BH_MOD_BY

Last Mod By

25x

Last Modified By

Text

BH_MOD_DT

Last Mod Date

mm/dd/yyyy

Last Modified Date

Date/Time

BH_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

BH_MPF

Metered Process Flow

nnnnnnnn.nn

Metered Process Flow

Double

BH_MSC

Metered Sanitary Credit

nnnnnnnn.nn

Metered Sanitary Credit

Double

BH_MSTC

Metered Storm Credit

nnnnnnnn.nn

Metered Storm Credit

Double

BH_MSTMVL

Metered Storm Vol

nnnnnnnn.nn

Metered Stormwater Volume

Double

BH_MSV

Metered Sanitary Vol

nnnnnnnn.nn

Metered Sanitary Volume

Double

BH_NBF

Net Billable Flow

nnnnnnnn.nn

Net Billable Flow

Double

BH_NPF

Non-Process Flow

nnnnnnnn.nn

Non-Process Flow

Double

BH_NSW

Non-Sewered Water

nnnnnnnn.nn

Non-Sewered Water

Double

BH_PF

Permit Fee

nnnnnnnn.nn

Permit Fee

Double

BH_PFS

Process Flow Surcharge

nnnnnnnn.nn

Process Flow Surcharge

Double

BH_RA

Reimbursable Amount

nnnnnnnn.nn

Reimbursable Amount

Double

BH_ROWVER

Rowversion for optimistic locking

Date/Time

BH_SOG

Septic Oil and Grease

nnnnnnnn.nn

Septic Oil and Grease

Double

BH_SV

Surcharge Value

nnnnnnnn.nn

Surcharge Value

Double

BH_SVC

Septic Volume Charge

nnnnnnnn.nn

Septic Volume Charge

Double

BH_TANK

Tank Discharge Vol

nnnnnnnn.nn

Tank Discharge Volume

Double

BH_TC

Total Charges

nnnnnnnn.nn

Total Charges

Double

BH_WELL

Well Water Vol

nnnnnnnn.nn

Well Water Volume

Double

BH_WMR

Water Meter Reading

nnnnnnnn.nn

Water Meter Reading

Double