EFSLOTH

Field Name

Caption

Mask

Description

Field Type

SG_ACT_CD

Action

nnn

Action

Small Integer

SG_ACT_TY

Action Text

25x

Action Text

String

SG_CRT_BY

Created By

25x

Created By

String

SG_CRT_DTTM

Creation Date Time

mm/dd/yyyy

Creation Date Time

DateTime

SG_DATE_DT

Effective Date

mm/dd/yyyy

Effective Date

DateTime

SG_GE_ID

Equipment Rec #

nnnnnnnn

Link to EFEQUIP.GE_ID

Long Integer

SG_ID

AutoID

nnnnnnnn

AutoID

Long Integer

SG_MOD_BY

Modified By

25x

Modified By

String

SG_MOD_DT

Modified Date

mm/dd/yyyy

Modified Date

DateTime

SG_MOD_TM

Modified Time

mm/dd/yyyy

Modified Time

DateTime

SG_READ

Reading

-nnnnnnnn.nn

Reading

Double

SG_ROWVER

Rowversion for optimistic locking

Rowversion for optimistic locking

TimeStamp

SG_SL_ID

Slot Rec #

nnnnnnnn

Link to EFSLOT.SL_ID

Long Integer

SG_TIME_TM

Effective Time

mm/dd/yyyy

Effective Time

DateTime

SG_TXT

Short Desc

150x

Short Desc

String