PKGDMEMO

Grid Memo

Field Name

Caption

Mask

Description

Field Type

GM_CRT_BY

Created By

25x

Created By

Text

GM_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

GM_CRYTOWO

 

 

Column used to determine if the comment should be carried over to the WO

Boolean

GM_HANDHELD

 

50x

Handheld Name

Text

GM_ID

Comment Rec #

-nnnnnnnn

AutoID

Long Integer

GM_MBL_ID

 

 

Copy of WO_ID for mobile device

Long Integer

GM_MEMO

General Comment

 

Comment

Text

GM_MOD_BY

LastModifiedBy

25x

Modified By

Text

GM_MOD_DT

Last Modified Date

mm/dd/yyyy

Modified Date

Date/Time

GM_MOD_TM

LastModifiedTime

hh:mm am

Modified Time

Date/Time

GM_OID

 

 

Visual CE Linking Field

Long Integer

GM_PAR_ID

ParentID

-nnnnnnnn

AutoID of parent record for this comment

Long Integer

GM_PARENT

ParentTable

20x

Table containing the parent record for this comment

Text

GM_PUBLIC

Publically Available

 

When true, the record can be shared with the public.

Boolean

GM_REC_BY

Recorded By

25x

Recorded by

Text

GM_REC_DT

Recorded Date

mm/dd/yyyy

Recorded Date

Date/Time

GM_REC_TM

Recorded Time

hh:mm am

Recorded Time

Date/Time

GM_ROWVER

 

 

Rowversion for optimistic locking

Date/Time

GM_TIMESTAMP

Timestamp

mm/dd/yyyy

Timestamp for Visual CE

Date/Time