EFGEICOST

Equipment Insurance Cost

Field Name

Caption

Mask

Description

Field Type

GI_ACCOUNT

Account #

45x

Account #

Text

GI_AMOUNT

Amount

nnnnnnnn.nn

Amount of Cost

Double

GI_CLOSED

Closed

 

All monies accounted for

Boolean

GI_CRT_BY

Created By

25x

Created By

Text

GI_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

GI_DOC_FLG

Document Available

 

Document Available

Boolean

GI_END_DT

End Date

mm/dd/yyyy

End Date

Date/Time

GI_GE_ID

Equipment Rec #

-nnnnnnnn

Link to EFEQUIP.GE_ID

Long Integer

GI_ID

Equip Ins Cost Rec #

-nnnnnnnn

Unique ID

Long Integer

GI_MOD_BY

Last Modified By

25x

Modified By

Text

GI_MOD_DT

Last Modified Date

mm/dd/yyyy

Modification Date

Date/Time

GI_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

GI_NOTE

Note

255x

Note

Text

GI_PNUMACT

Proj No - Acct

40x

Proj No - Acct

Text

GI_ROWVER

 

 

Rowversion for optimistic locking

Date/Time

GI_STRT_DT

Start Date

mm/dd/yyyy

Start Date

Date/Time

GI_TYPE_CD

Type

nnn

Type

Integer

GI_TYPE_TY

Type Text

25x

Type Text

Text

GI_USED

Amount Used

nnnnnnnn.nn

Amount Used

Double

GI_VEND_CD

Vendor

nnn

Vendor

Integer

GI_VEND_TY

Vendor Text

25x

Vendor Text

Text