WKRTRES

Field Name

Caption

Mask

Description

Field Type

TR_AC_ID

Account Rec #

nnnnnnnn

Link To WKACCTNO.AC_ID

Long Integer

TR_ACCOUNT

Res Account #

45x

Account #

Text

TR_ALTDESC

Alt Description

90x

Alternate Description

Text

TR_CLASS

Class

10x

Class

Text

TR_CRT_BY

Created By

25x

Created By

Text

TR_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

TR_DEPT_CD

10x

Department

Text

TR_DEPT_TY

40x

Department Text

Text

TR_DOC_FLG

Document Available

Doc Available: Doc Flag

Boolean

TR_DUNIT_C

Default Unit Cost

nnnnn.nnn

Default Unit Cost

Double

TR_EA_ID

Eden Account Rec #

nnnnnnnn

Link to WKEACCTNO.EA_ID

Long Integer

TR_EP_ID

Eden Project Rec #

nnnnnnnn

Link to WKEPROJNO.EP_ID

Long Integer

TR_GROUP

Group No

nnn

Group Number

Integer

TR_ID

Res Rec #

nnnnnnnn

Unique ID

Long Integer

TR_IMG_FLG

Image Available

Boolean

TR_ITEM_ID

Link to item

nnnnnnnn

Link to item

Long Integer

TR_MOD_BY

Last Modified By

25x

Modified By :

Text

TR_MOD_DT

Last Modified Date

mm/dd/yyyy

Date Modified :

Date/Time

TR_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

TR_MOV_FLG

Movie Available

Boolean

TR_PNUMACT

Res Proj No - Acct

40x

Proj No - Acct

Text

TR_REC_T

Financial Record Type

1x

Eden Record Type

Text

TR_RESTYP

13x

Resource Type EMP, EQT, MAT

Text

TR_ROWVER

Rowversion for optimistic locking

Date/Time

TR_RSRC_CD

Resource

20x

Resource

Text

TR_RSRC_TY

Resource Text

75x

Resource Text

Text

TR_RTYP_CD

Resource Type

nnn

Resource Type

Integer

TR_RTYP_TY

Resource Type Text

25x

Resource Type Text

Text

TR_STOCKED

Stocked :

Boolean

TR_TIME_CD

Time Cost

nnn

Time Cost

Integer

TR_TIME_TY

Time Cost Text

25x

Time Cost Text

Text

TR_TO_ID

PM Rec #

nnnnnnnn

Link to WKROUTINE.TO_ID

Long Integer

TR_TOTCOST

Total Cost

nnnnnnn.nn

Total Cost

Double

TR_TT_ID

Task Rec #

nnnnnnnn

Link to WKRTTSK.TT_ID

Long Integer

TR_UNIT_C

Unit Cost

nnnnn.nnn

Unit Cost

Double

TR_UNIT_M

Units of Measure

8x

Unit of Measure

Text

TR_UNITEST

Estimated Units

nnnnn.nn

Estimated Units

Double

TR_UNITS

Units

nnnnn.nn

Units

Double

TR_UNITS_OT

Overtime Hours

nnnnn.nn

Overtime Hours

Double

TR_UNITS_R

Regular Time

nnnnn.nn

Regular Time Hours

Double

TR_UOM_CD

Unit of Measure

5x

Unit of Measure

Text

TR_UOM_TY

Unit of Measure Text

25x

Unit of Measure Text

Text

TR_UPC

UPC Code

50x

UPC Code

Text

TR_WHSE_ID

Eden Warehouse

nnnnnnnn

Link to Warehouse ID

Long Integer

TR_WHSE_TY

Warehouse

35x

Eden Warehouse for Part

Text