WKUFLUID

Fluid Setup

Field Name

Caption

Mask

Description

Field Type

FD_AC_ID

Account Rec #

-nnnnnnnn

Link to WKACCTNO.AC_ID

Long Integer

FD_ACCOUNT

Account #

45x

Account #

Text

FD_ACT_FLG

Active Fluid

 

Active Fluid

Boolean

FD_AREA_CD

Area Code

10x

Area Code

String

FD_AREA_TY

Area  Description

40x

Area  Description

String

FD_COMMENT1

Long Note

 

Long Note

Memo

FD_CRT_BY

Created By

25x

Created By

Text

FD_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

FD_DEPT_CD

Department

10x

Department:

Text

FD_DEPT_TY

Department Text

50x

Department: Text

Text

FD_DIV_CD

Division Code

10x

Division Code

String

FD_DIV_TY

Division Description

40x

Division Description

String

FD_DOC_FLG

Document Available

 

Document Flag

Boolean

FD_EA_ID

Eden Acct Rec #

nnnnnnnnn

Link to WKEACCTNO.EA_ID

Long Integer

FD_EP_ID

Eden Proj Rec #

nnnnnnnnn

Link to WKEPROJNO.EP_ID

Long Integer

FD_FLUIDCD

Fluid

20x

Fluid:Unique ID

Text

FD_FLUIDTY

Fluid Text

75x

Fluid Text

Text

FD_ID

Fluid Rec #

nnnnnnnn

AutoID Number

Long Integer

FD_IMG_FLG

 

 

Image Flag

Boolean

FD_JE_FLG

Journal Entry Import

 

Journal Entry Flag

Boolean

FD_MAKE

Make

25x

Make of Fluid

Text

FD_MOD_BY

Last Modified By

25x

Modified By

Text

FD_MOD_DT

Last Modified Date

mm/dd/yyyy

Modification Date

Date/Time

FD_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

FD_MODEL

Model

25x

Model of Fluid

Text

FD_MOV_FLG

 

 

Movie Flag

Boolean

FD_PNUMACT

Proj No - Acct

40x

Proj No - Acct

Text

FD_PURP_CD

Purpose

nnn

Purpose

Integer

FD_PURP_TY

Purpose Text

25x

Purpose Text

Text

FD_ROWVER

 

 

Rowversion for optimistic locking

Date/Time

FD_SAREACD

Sub-Area Code

10x

Sub-Area Code

String

FD_SAREATY

Sub-Area Description

40x

Sub-Area Description

String

FD_SDIV_CD

SubDivision Code

10x

SubDivision Code

String

FD_SDIV_TY

SubDivision Description

40x

SubDivision Description

String

FD_SPECID

Special ID

25x

Special ID

Text

FD_STAT_CD

Fluid Status

nnn

Fluid Status

Integer

FD_STAT_TY

Fluid Status Text

25x

Fluid Status Txt

Text

FD_UNIT_C

Unit Cost

nnnnn.nnn

Unit Cost

Double

FD_UOM_CD

Unit of Measure

5x

Unit of Measure

Text

FD_UOM_TY

Unit of Measure Text

25x

Unit of Measure Text

Text

FD_USER10

User 10

mm/dd/yyyy

User 10

Date/Time

FD_USER11

User 11

mm/dd/yyyy

User 11

Date/Time

FD_USER12

User 12

mm/dd/yyyy

User 12

Date/Time

FD_USER13

User 13

 

User 13

Boolean

FD_USER14

User 14

 

User 14

Boolean

FD_USER15

User 15

 

User 15

Boolean

FD_USER1CD

User 1

nnn

User 1

Integer

FD_USER1TY

User 1 Text

25x

User 1 Text

Text

FD_USER2CD

User 2

nnn

User 2

Integer

FD_USER2TY

User 2 Text

25x

User 2 Text

Text

FD_USER3CD

User 3

nnn

User 3

Integer

FD_USER3TY

User 3 Text

25x

User 3 Text

Text

FD_USER4

User 4

30x

User 4

Text

FD_USER5

User 5

30x

User 5

Text

FD_USER6

User 6

30x

User 6

Text

FD_USER7

User 7

-nnnnnnnn.nn

User 7

Double

FD_USER8

User 8

-nnnnnnnn.nn

User 8

Double

FD_USER9

User 9

-nnnnnnnn.nn

User 9

Double