EFPARTEF

Field Name

Caption

Mask

Description

Field Type

FP_COMMENT1

Long Note

Long Note

Memo

FP_CRT_BY

Created By

25x

Created By

Text

FP_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

FP_DESC

Description

50x

Description

Text

FP_DOC_FLG

Document Available

Document Flag

Boolean

FP_FL_ID

Fleet Rec #

-nnnnnnnn

Link to EFFLEET.FL_ID

Long Integer

FP_GE_ID

Equipment Rec #

-nnnnnnnn

Link to EFEQUIP.GE_ID

Long Integer

FP_ID

Part Equip Rec #

-nnnnnnnn

AutoID Number

Long Integer

FP_INAC_DT

Inactive Date

mm/dd/yyyy

Inactive Date

Date/Time

FP_INST_DT

Install Date

mm/dd/yyyy

Installed Date

Date/Time

FP_MAN_CD

Manufacturer

12x

Manufacturer

Text

FP_MAN_TY

Manufacturer Text

60x

Manufacturer Text

Text

FP_MOD_BY

Last Modified By

25x

Last Modified By

Text

FP_MOD_DT

Last Modified Date

mm/dd/yyyy

Modification Date

Date/Time

FP_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

FP_MODEL

Model

30x

Model

Text

FP_MT_ID

Work Material Rec #

-nnnnnnnn

Link to WKUMTR.MT_ID

Long Integer

FP_PC_ID

Parts to Components Link

-nnnnnnnn

Link to EFPARTEFC.PC_ID

Long Integer

FP_PT_ID

Parts Setup Rec #

-nnnnnnnn

Link to PTPARTS.PT_ID

Long Integer

FP_QUAN

Quantity

nnnn.nn

Quantity

Double

FP_ROWVER

Rowversion for optimistic locking

Date/Time

FP_SERIAL

Serial Number

30x

Serial Number

Text

FP_SPEC

Spec

100x

Spec

Text

FP_STAT_CD

Status

nnn

Status

Integer

FP_STAT_TY

Status Text

25x

Status Text

Text

FP_YEAR

Year

30x

Year

Text