Project Expenditures
Field Name |
Caption |
Mask |
Description |
Field Type |
ED_ACTDETL |
Account Detail |
3x |
Account Detail |
Text |
ED_AMOUNT |
Expenditure Amount |
nnnnnnnn.nnnn |
Expenditure Amount |
Double |
ED_CODE_CD |
Expenditure Code |
5x |
Expenditure Code |
Text |
ED_CODE_TY |
Expenditure Code Text |
60x |
Expenditure Code Text |
Text |
ED_CRT_BY |
Created By |
25x |
Created By |
Text |
ED_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
ED_DOC_FLG |
Document Available |
|
Document Available |
Boolean |
ED_FC_CD |
Fund Center |
6x |
Fund Center |
Text |
ED_FC_TY |
Fund Center Text |
60x |
Fund Center Text |
Text |
ED_FMONTH |
Fiscal Month |
2x |
Fiscal Month |
Text |
ED_FUND_CD |
Fund Source |
5x |
Fund Source |
Text |
ED_FUND_TY |
Fund Source Text |
60x |
Fund Source Text |
Text |
ED_FYEAR |
Fiscal Year |
nnnn |
Fiscal Year |
Integer |
ED_FYR_CD |
Fiscal Year |
nnn |
Fiscal Year |
Integer |
ED_FYR_TY |
Fiscal Year Text |
25x |
Fiscal Year Text |
Text |
ED_ID |
Expend Rec # |
nnnnnnnn |
Expend Rec # |
Long Integer |
ED_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
ED_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
ED_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
ED_MP_ID |
Master Project Rec # |
nnnnnnnn |
Long Integer |
|
ED_PG_ID |
Program Rec # |
nnnnnnnn |
Long Integer |
|
ED_PJ_ID |
Project Rec # |
nnnnnnnn |
Long Integer |
|
ED_POST_DT |
Posting Date |
mm/dd/yyyy |
Posting Date |
Date/Time |
ED_POSTSEQ |
Posting Sequence |
16x |
Posting Sequence |
Text |
ED_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
ED_USER10 |
User 10 |
mm/dd/yyyy |
User 10 |
Date/Time |
ED_USER11 |
User 11 |
mm/dd/yyyy |
User 11 |
Date/Time |
ED_USER12 |
User 12 |
mm/dd/yyyy |
User 12 |
Date/Time |
ED_USER13 |
User 13 |
|
User 13 |
Boolean |
ED_USER14 |
User 14 |
|
User 14 |
Boolean |
ED_USER15 |
User 15 |
|
User 15 |
Boolean |
ED_USER1CD |
User 1 |
nnn |
User 1 |
Integer |
ED_USER1TY |
User 1 Text |
25x |
User 1 Text |
Text |
ED_USER2CD |
User 2 |
nnn |
User 2 |
Integer |
ED_USER2TY |
User 2 Text |
25x |
User 2 Text |
Text |
ED_USER3CD |
User 3 |
nnn |
User 3 |
Integer |
ED_USER3TY |
User 3 Text |
25x |
User 3 Text |
Text |
ED_USER4 |
User 4 |
30x |
User 4 |
Text |
ED_USER5 |
User 5 |
30x |
User 5 |
Text |
ED_USER6 |
User 6 |
30x |
User 6 |
Text |
ED_USER7 |
User 7 |
-nnnnnnnn.nn |
User 7 |
Double |
ED_USER8 |
User 8 |
-nnnnnnnn.nn |
User 8 |
Double |
ED_USER9 |
User 9 |
-nnnnnnnn.nn |
User 9 |
Double |