WKUEQT

Work Flow Setup Equipment

Field Name

Caption

Mask

Description

Field Type

EQ_AC_ID

Account Rec #

-nnnnnnnn

Link to WKACCTNO.AC_ID

Long Integer

EQ_ACCOUNT

Account #

45x

Account #

Text

EQ_ACT_FLG

Active Equipment

 

Active Equipment

Boolean

EQ_AREA_CD

Area Code

10x

Area Code

String

EQ_AREA_TY

Area  Description

40x

Area  Description

String

EQ_COMMENT1

Long Note

 

Long Note

Memo

EQ_CRT_BY

Created By

25x

Created By

Text

EQ_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

EQ_DEPT_CD

Department

10x

Department

Text

EQ_DEPT_TY

Department Description

50x

Department Text

Text

EQ_DESC

Desc

30x

Desc

Text

EQ_DIV_CD

Division Code

10x

Division Code

String

EQ_DIV_TY

Division Description

40x

Division Description

String

EQ_DOC_FLG

Document Available

 

Doc Available: Doc Flag

Boolean

EQ_EA_ID

Eden Account Rec #

nnnnnnnnn

Link to WKEACCTNO.EA_ID

Long Integer

EQ_EF_CD

Fleet/Equip Asset

20x

Fleet/Equipment Asset Code: Unique ID

Text

EQ_EF_TY

Fleet/Equip Asset Text

50x

Fleet/Equipment Asset Description

Text

EQ_EP_ID

Eden Proj Rec #

nnnnnnnnn

Link to WKEPROJNO.EP_ID

Long Integer

EQ_EQPT_CD

Equipment

20x

Equipment Code

Text

EQ_EQPT_TY

Equipment Text

50x

Equipment Text

Text

EQ_EQUIPID

 

 

Link to Equipment ID.EQ_ID

Long Integer

EQ_FLEETID

 

 

Link to Fleet ID.FL_ID

Long Integer

EQ_ID

Equip Rec #

nnnnnnnn

Unique ID

Long Integer

EQ_IMG_FLG

 

 

Image Available

Boolean

EQ_IT_ID

 

 

Link to Common items

Long Integer

EQ_JE_FLG

Journal Entry Import

 

Journal Entry Flag

Boolean

EQ_MOD_BY

Modified By

25x

Modified By

Text

EQ_MOD_DT

Modified Date

mm/dd/yyyy

Modified Date

Date/Time

EQ_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

EQ_MODEL

Model No

40x

Model Number

Text

EQ_MOV_FLG

 

 

Movie Available

Boolean

EQ_OID

 

 

Visual CE Linking Field

Long Integer

EQ_PNUMACT

Proj No - Acct

40x

Proj No - Acct

Text

EQ_PW_ID

 

 

Not Used

Long Integer

EQ_REGE_C

Reg External Rate

nnnn.nn

Regular External Hourly Rate

Double

EQ_ROWVER

 

 

Rowversion for optimistic locking

Date/Time

EQ_SAREACD

Sub-Area Code

10x

Sub-Area Code

String

EQ_SAREATY

Sub-Area Description

40x

Sub-Area Description

String

EQ_SDIV_CD

SubDivision Code

10x

SubDivision Code

String

EQ_SDIV_TY

SubDivision Description

40x

SubDivision Description

String

EQ_SPECID

Special ID

30x

Special ID

Text

EQ_STAT_CD

Equipment Status

nnn

Equipment Status

Integer

EQ_STAT_TY

Equipment Status Text

25x

Equipment Status Txt

Text

EQ_TIME_CD

Time Cost

nnn

Time Cost

Integer

EQ_TIME_TY

Time Cost Type

25x

Time Cost Text

Text

EQ_TYPE_CD

Equipment Type

nnn

Equipment Type - 1-Fleet, 2-Equipment, 3-General

Integer

EQ_TYPE_TY

Equipment Type Text

25x

Equipment Type Text

Text

EQ_UNIT_C

Unit Cost

nnnnn.nnn

Unit Cost

Double

EQ_UNIT_M

Units of Measure

10x

Unit of Measure

Text

EQ_UOM_CD

Unit of Measure

5x

Unit of Measure

Text

EQ_UOM_TY

Unit of Measure Text

25x

Unit of Measure Text

Text

EQ_USER10

User 10

mm/dd/yyyy

User 10

Date/Time

EQ_USER11

User 11

mm/dd/yyyy

User 11

Date/Time

EQ_USER12

User 12

-nnnnnnnnn.nn

User 12

Double

EQ_USER13

User 13

-nnnnnnnnn.nn

User 13

Double

EQ_USER14

User 14

30x

User 14

Text

EQ_USER15

User 15

30x

User 15

Text

EQ_USER1CD

User 1

nnn

User 1

Integer

EQ_USER1TY

User 1 Text

25x

User 1 Text

Text

EQ_USER2CD

User 2

nnn

User 2

Integer

EQ_USER2TY

User 2 Text

25x

User 2 Text

Text

EQ_USER3CD

User 3

nnn

User 3

Integer

EQ_USER3TY

User 3 Text

25x

User 3 Text

Text

EQ_USER4

User 4

-nnnnnnnnn.nn

User 4

Double

EQ_USER5

User 5

30x

User 5

Text

EQ_USER6

User 6

 

User 6

Boolean

EQ_USER7

User 7

 

User 7

Boolean

EQ_USER8

User 8

 

User 8

Boolean

EQ_USER9

User 9

mm/dd/yyyy

User 9

Date/Time