WKPROJRF

Project Revenue Sources

Field Name

Caption

Mask

Description

Field Type

RF_AMOUNT

Revenue Amount

nnnnnnnn.nnnn

Revenue Amount

Double

RF_AOF_DT

As of Date

mm/dd/yyyy

As of Date

Date/Time

RF_BUDG_CD

Budget

5x

Budget

Text

RF_BUDG_TY

Budget Text

60x

Budget Text

Text

RF_BVER

Budget Version

3x

Budget Version

Text

RF_CRT_BY

Created By

25x

Created By

Text

RF_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

RF_DOC_FLG

Document Available

 

Document Available

Boolean

RF_FC_CD

Fund Center

6x

Fund Center

Text

RF_FC_TY

Fund Center Text

60x

Fund Center Text

Text

RF_FYEAR

Fiscal Year

nnnn

Fiscal Year

Integer

RF_FYR_CD

Fiscal Year

nnn

Fiscal Year

Integer

RF_FYR_TY

Fiscal Year Text

25x

Fiscal Year Text

Text

RF_ID

Rev Fund Rec #

nnnnnnnn

Rev Fund Rec #

Long Integer

RF_MOD_BY

Last Modified By

25x

Last Modified By

Text

RF_MOD_DT

Last Modified Date

mm/dd/yyyy

Last Modified Date

Date/Time

RF_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

RF_MP_ID

Master Project Rec #

nnnnnnnn

Link to WKPROJM.MP_ID

Long Integer

RF_PG_ID

Program Rec #

nnnnnnnn

Link to WKPROG.PG_ID

Long Integer

RF_PJ_ID

Project Rec #

nnnnnnnn

Link to WKPROJ.PJ_ID

Long Integer

RF_PYEAR

Prior Year Budget

 

Prior Year Project

Boolean

RF_REV_CD

Revenue Source

10x

Revenue Source

Text

RF_REV_TY

Revenue Source Text

60x

Revenue Source Text

Text

RF_ROWVER

 

 

Rowversion for optimistic locking

Date/Time

RF_USER10

User 10

mm/dd/yyyy

User 10

Date/Time

RF_USER11

User 11

mm/dd/yyyy

User 11

Date/Time

RF_USER12

User 12

mm/dd/yyyy

User 12

Date/Time

RF_USER13

User 13

 

User 13

Boolean

RF_USER14

User 14

 

User 14

Boolean

RF_USER15

User 15

 

User 15

Boolean

RF_USER1CD

User 1

nnn

User 1

Integer

RF_USER1TY

User 1 Text

25x

User 1 Text

Text

RF_USER2CD

User 2

nnn

User 2

Integer

RF_USER2TY

User 2 Text

25x

User 2 Text

Text

RF_USER3CD

User 3

nnn

User 3

Integer

RF_USER3TY

User 3 Text

25x

User 3 Text

Text

RF_USER4

User 4

30x

User 4

Text

RF_USER5

User 5

30x

User 5

Text

RF_USER6

User 6

30x

User 6

Text

RF_USER7

User 7

-nnnnnnnn.nn

User 7

Double

RF_USER8

User 8

-nnnnnnnn.nn

User 8

Double

RF_USER9

User 9

-nnnnnnnn.nn

User 9

Double