SMQFV

Field Name

Caption

Mask

Description

Field Type

FV_AMTPAID

Fine Amount Paid

nnnnnnnn.nn

Fine Amount Paid

Double

FV_COMP

Completed

Completed Flag - This violation has had all of the followup efforts completed

Boolean

FV_CRT_BY

Created By

25x

Created By

String

FV_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

DateTime

FV_DDESC

Detailed Description

999x

Detailed Description

String

FV_DESC

Code Violation Description

254x

Code Violation Description

String

FV_DOC_FLG

Document Flag

Document Flag

Boolean

FV_ETYP_CD

Enforcement Type

nnn

Enforcement Type

Integer

FV_ETYP_TY

Enforcement Type Text

50x

Enforcement Type Text

String

FV_FI_ID

Management Plan Inspection Record No

nnnnnnnn

Link to SMQFI.FI_ID

Long Integer

FV_FINE

Fine Amount

nnnnnnnn.nn

Fine Amount

Double

FV_ID

Management Plan Violation Record Number

nnnnnnnn

Management Plan Violation Record Number

Long Integer

FV_INV_DT

Invoiced Date

mm/dd/yyyy hh:mm am

Invoiced Date

DateTime

FV_INVACCT

Invoice Acct No

45x

Invoice Acct No

String

FV_INVOICE

Invoice Number

25x

Invoice Number

String

FV_MOD_BY

Last Modified By

25x

Last Modified By

String

FV_MOD_DT

Last Modified Date

mm/dd/yyyy hh:mm am

Last Modified Date

DateTime

FV_MOD_TM

Modified Time

mm/dd/yyyy hh:mm am

Modified Time

DateTime

FV_OCCR_DT

Occured Date

mm/dd/yyyy hh:mm am

Occured Date

DateTime

FV_PAID_DT

Date Fine Paid

mm/dd/yyyy hh:mm am

Date Fine Paid

DateTime

FV_PAYM_CD

Fine Payment Method

nnn

Fine Payment Method

Integer

FV_PAYM_TY

Fine Payment Method Text

50x

Fine Payment Method Text

String

FV_QF_ID

Management Plan Record No

nnnnnnnn

Link to SMQF.QF_ID

Long Integer

FV_ROWVER

Rowversion for optimistic locking

TimeStamp

FV_VIOL

Code Violation

20x

Code Violation

String