STGDMEMO

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

 

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

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

 

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