Fiscal Year
Field Name |
Caption |
Mask |
Description |
Field Type |
FY_APPROVE |
Approved Budget |
nnnnnnnn. |
Approved Budget |
Double |
FY_APR_WD |
April Working Days |
nn |
April Working Days |
Integer |
FY_AUG_WD |
August Working Days |
nn |
August Working Days |
Integer |
FY_CLOSED |
Closed |
|
Closed |
Boolean |
FY_CRT_BY |
Created By |
25x |
Created By |
Text |
FY_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
FY_DEC_WD |
December Working Days |
nn |
December Working Days |
Integer |
FY_DOC_FLG |
Document Available |
|
Document Available |
Boolean |
FY_END_DT |
End Date |
mm/dd/yyyy |
End Date |
Date/Time |
FY_ESTIMAT |
Estimated Budget |
nnnnnnnn. |
Estimated Budget |
Double |
FY_EXP_PCT |
% of Budget Used |
nnn.n |
% of Budget Expended |
Double |
FY_EXPEND |
Expended Budget |
nnnnnnnn. |
Expended Budget to Date |
Double |
FY_FEB_WD |
February Working Days |
nn |
February Working Days |
Integer |
FY_FY_PCT |
% of FY Completed |
nnn.n |
% of Fiscal Year Completed |
Double |
FY_FYEAR |
Fiscal Year |
nnnn |
Fiscal Year |
Integer |
FY_HRPDAY |
Hours/Day |
nn |
Hours Per Day |
Integer |
FY_ID |
Fiscal Year Rec Number |
nnnnnnnn |
Autonumber |
Long Integer |
FY_IMG_FLG |
|
|
Image Available |
Boolean |
FY_JAN_WD |
January Working Days |
nn |
January Working Days |
Integer |
FY_JUL_WD |
July Working Days |
nn |
July Working Days |
Integer |
FY_JUN_WD |
June Working Days |
nn |
June Working Days |
Integer |
FY_MAR_WD |
March Working Days |
nn |
March Working Days |
Integer |
FY_MAY_WD |
May Working Days |
nn |
May Working Days |
Integer |
FY_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
FY_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
FY_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
FY_MOV_FLG |
|
|
Movie Available |
Boolean |
FY_NOV_WD |
November Working Days |
nn |
November Working Days |
Integer |
FY_OCT_WD |
October Working Days |
nn |
October Working Days |
Integer |
FY_OU_PCT |
% Over/Under |
-nnn.n |
%Currently Over or Under Budget |
Double |
FY_REMAIN |
Remaining Budget |
-nnnnnnnn. |
Remaining Budget |
Double |
FY_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
FY_SEP_WD |
September Working Days |
nn |
September Working Days |
Integer |
FY_STARTDT |
Start Date |
mm/dd/yyyy |
Start Date |
Date/Time |
FY_TOT_WD |
Total Days |
nnn |
Total Working Days |
Integer |
FY_USER10 |
User 10 |
mm/dd/yyyy |
User 10 |
Date/Time |
FY_USER11 |
User 11 |
mm/dd/yyyy |
User 11 |
Date/Time |
FY_USER12 |
User 12 |
mm/dd/yyyy |
User 12 |
Date/Time |
FY_USER13 |
User 13 |
|
User 13 |
Boolean |
FY_USER14 |
User 14 |
|
User 14 |
Boolean |
FY_USER15 |
User 15 |
|
User 15 |
Boolean |
FY_USER1CD |
User 1 |
nnn |
User 1 |
Integer |
FY_USER1TY |
User 1 Text |
25x |
User 1 Text |
Text |
FY_USER2CD |
User 2 |
nnn |
User 2 |
Integer |
FY_USER2TY |
User 2 Text |
25x |
User 2 Text |
Text |
FY_USER3CD |
User 3 |
nnn |
User 3 |
Integer |
FY_USER3TY |
User 3 Text |
25x |
User 3 Text |
Text |
FY_USER4 |
User 4 |
30x |
User 4 |
Text |
FY_USER5 |
User 5 |
30x |
User 5 |
Text |
FY_USER6 |
User 6 |
30x |
User 6 |
Text |
FY_USER7 |
User 7 |
-nnnnnnnn.nn |
User 7 |
Double |
FY_USER8 |
User 8 |
-nnnnnnnn.nn |
User 8 |
Double |
FY_USER9 |
User 9 |
-nnnnnnnn.nn |
User 9 |
Double |