SMQCVC

Field Name

Caption

Mask

Description

Field Type

KA_CACTION

Corrective Action

20x

Corrective Action

String

KA_COMP

Completed

Completed

Boolean

KA_COMP_DT

Completed Date

mm/dd/yyyy hh:mm am

Completed Date

DateTime

KA_CRT_BY

Created By

25x

Created By

String

KA_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

DateTime

KA_DDESC

Detailed Description

999x

Detailed Description

String

KA_DESC

Corrective Actionn Description

999x

Corrective Actionn Description

String

KA_DOC_FLG

Document Flag

Document Flag

Boolean

KA_DUE_DT

Due Date

mm/dd/yyyy hh:mm am

Due Date

DateTime

KA_ID

Violation Corrective Action Record Number

nnnnnnnn

Violation Corrective Action Record Number

Long Integer

KA_KV_ID

Commercial Inspection Violation Record No

nnnnnnnn

Link to SMQCV.KV_ID

Long Integer

KA_MOD_BY

Last Modified By

25x

Last Modified By

String

KA_MOD_DT

Last Modified Date

mm/dd/yyyy hh:mm am

Last Modified Date

DateTime

KA_MOD_TM

Modified Time

mm/dd/yyyy hh:mm am

Modified Time

DateTime

KA_NOT_DT

Notification Date

mm/dd/yyyy hh:mm am

Notification Date

DateTime

KA_NOTES

Notes

254x

Notes

String

KA_QC_ID

Commercial Rec No

nnnnnnnn

Link to SMQC.QC_ID

Long Integer

KA_ROWVER

Rowversion for optimistic locking

TimeStamp