SMQCV

Field Name

Caption

Mask

Description

Field Type

KV_AMTPAID

Fine Amount Paid

nnnnnnnn.nn

Fine Amount Paid

Double

KV_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

KV_CRT_BY

Created By

25x

Created By

String

KV_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

DateTime

KV_DDESC

Detailed Description

999x

Detailed Description

String

KV_DESC

Code Violation Description

254x

Code Violation Description

String

KV_DOC_FLG

Document Flag

Document Flag

Boolean

KV_ETYP_CD

Enforcement Type

nnn

Enforcement Type

Integer

KV_ETYP_TY

Enforcement Type Text

50x

Enforcement Type Text

String

KV_FINE

Fine Amount

nnnnnnnn.nn

Fine Amount

Double

KV_ID

Violation Record Number

nnnnnnnn

Violation Record Number

Long Integer

KV_INV_DT

Invoiced Date

mm/dd/yyyy hh:mm am

Invoiced Date

DateTime

KV_INVACCT

Invoice Acct No

45x

Invoice Acct No

String

KV_INVOICE

Invoice Number

25x

Invoice Number

String

KV_KI_ID

Commercial Inspection Record No

nnnnnnnn

Link to SMQCI.KI_ID

Long Integer

KV_MOD_BY

Last Modified By

25x

Last Modified By

String

KV_MOD_DT

Last Modified Date

mm/dd/yyyy hh:mm am

Last Modified Date

DateTime

KV_MOD_TM

Modified Time

mm/dd/yyyy hh:mm am

Modified Time

DateTime

KV_OCCR_DT

Occured Date

mm/dd/yyyy hh:mm am

Occured Date

DateTime

KV_PAID_DT

Date Fine Paid

mm/dd/yyyy hh:mm am

Date Fine Paid

DateTime

KV_PAYM_CD

Fine Payment Method

nnn

Fine Payment Method

Integer

KV_PAYM_TY

Fine Payment Method Text

50x

Fine Payment Method Text

String

KV_QC_ID

Commercial Record No

nnnnnnnn

Link to SMQC.QC_ID

Long Integer

KV_ROWVER

Rowversion for optimistic locking

TimeStamp

KV_VIOL

Code Violation

20x

Code Violation

String