EFGETRAK

Equipment Status

Field Name

Caption

Mask

Description

Field Type

GT_CRT_BY

Created By

25x

Created By

Text

GT_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

GT_DAYS

Units Since Failure

nnnnn.n

Days

Double

GT_DT

Date

mm/dd/yyyy

Date

Date/Time

GT_GE_ID

Equipment Rec #

-nnnnnnnn

Link to EFEQUIP.GE_ID

Long Integer

GT_ID

Equip Track Rec #

-nnnnnnnn

AutoNumber

Long Integer

GT_MOD_BY

Last Modified By

25x

Last Modified By

Text

GT_MOD_DT

Last Modfied Date

mm/dd/yyyy

Last Modified Date

Date/Time

GT_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

GT_ROWVER

 

 

Rowversion for optimistic locking

Date/Time

GT_STAT_CD

Status

nnn

Status

Integer

GT_STAT_TY

Status Text

25x

Status Text

Text

GT_TM

Time

hh:mm am

Time

Date/Time