SMQMV

Field Name

Caption

Mask

Description

Field Type

LV_AMTPAID

Fine Amount Paid

nnnnnnnn.nn

Fine Amount Paid

Double

LV_COMP

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

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

Boolean

LV_CRT_BY

Created By

25x

Created By

String

LV_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

DateTime

LV_DDESC

Detailed Description

999x

Detailed Description

String

LV_DESC

Code Violation Description

254x

Code Violation Description

String

LV_DOC_FLG

Document Flag

Document Flag

Boolean

LV_ETYP_CD

Enforcement Type

nnn

Enforcement Type

Integer

LV_ETYP_TY

Enforcement Type Text

50x

Enforcement Type Text

String

LV_FINE

Fine Amount

nnnnnnnn.nn

Fine Amount

Double

LV_ID

Municipal Violation Record Number

nnnnnnnn

Auto ID

Long Integer

LV_INV_DT

Invoiced Date

mm/dd/yyyy hh:mm am

Invoiced Date

DateTime

LV_INVACCT

Invoice Acct No

45x

Invoice Acct No

String

LV_INVOICE

Invoice Number

25x

Invoice Number

String

LV_LI_ID

Industrial Inspection Record No

nnnnnnnn

Link to SMQMI.LI_ID

Long Integer

LV_MOD_BY

Last Modified By

25x

Last Modified By

String

LV_MOD_DT

Last Modified Date

mm/dd/yyyy hh:mm am

Last Modified Date

DateTime

LV_MOD_TM

Modified Time

mm/dd/yyyy hh:mm am

Modified Time

DateTime

LV_OCCR_DT

Occured Date

mm/dd/yyyy hh:mm am

Occured Date

DateTime

LV_PAID_DT

Date Fine Paid

mm/dd/yyyy hh:mm am

Date Fine Paid

DateTime

LV_PAYM_CD

Fine Payment Method

nnn

Fine Payment Method

Integer

LV_PAYM_TY

Fine Payment Method Text

50x

Fine Payment Method Text

String

LV_QM_ID

Municipal Record No

nnnnnnnn

Link to SMQM.QM_ID

Long Integer

LV_ROWVER

Rowversion for optimistic locking

TimeStamp

LV_VIOL

Code Violation

20x

Code Violation

String