SMQCCR

Field Name

Caption

Mask

Description

Field Type

KR_CRT_BY

Created By

25x

Created By

String

KR_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

DateTime

KR_EMAIL

Email

150x

Email

String

KR_FAX

Fax

25x

Fax

String

KR_ID

Commercial Contact Rec #: Unique ID

nnnnnnnn

Commercial Contact Rec #: Unique ID

Long Integer

KR_MOBILE

Mobile Phone

25x

Mobile Phone

String

KR_MOD_BY

Modified By

25x

Modified By

String

KR_MOD_DT

Modified Date

mm/dd/yyyy hh:mm am

Modified Date

DateTime

KR_MOD_TM

Modified Time

mm/dd/yyyy hh:mm am

Modified Time

DateTime

KR_NAME

Name

50x

Name

String

KR_PHONE

Phone

25x

Phone

String

KR_QC_ID

Commercial Record No

nnnnnnnn

Link to SMQC.QC_ID

Long Integer

KR_ROWVER

Rowversion for optimistic locking

TimeStamp

KR_TITL_CD

Title

nnn

Title

Integer

KR_TITL_TY

Title Text

50x

Title Text

String