Project Funding Ecumbrances or Purchase Orders
Field Name |
Caption |
Mask |
Description |
Field Type |
FN_ACCT_CD |
Account |
5x |
Account |
Text |
FN_ACCT_TY |
Account Text |
25x |
Account Text |
Text |
FN_ADJREAS |
Adjustment Reason |
100x |
Adjustment Reason |
Text |
FN_AMOUNT |
Amount |
nnnnnnnnn.nn |
Amount |
Double |
FN_COMMENT1 |
Long Note |
|
Long Note |
Memo |
FN_CONTRID |
|
30x |
Contract ID |
Text |
FN_CRT_BY |
Created By |
25x |
Created By |
Text |
FN_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
FN_DIND_CD |
Deletion Indicator |
2x |
Deletion Indicator |
Text |
FN_DIND_TY |
Deletion Indicator Text |
60x |
Deletion Indicator Text |
Text |
FN_DOC_FLG |
Document Available |
|
Document Available |
Boolean |
FN_EMC_ID |
PO Number |
25x |
Encumbrance ID |
Text |
FN_END_DT |
PO End Date |
mm/dd/yyyy |
End Date |
Date/Time |
FN_ETPRICE |
Est Total Price |
-nnnnnnnn.nn |
Est Total Price |
Double |
FN_FSOURCE |
Funding Source |
40x |
Funding Source |
Text |
FN_FUND |
Add to Funding |
|
Add to Funding Flag |
Boolean |
FN_ID |
Funding Rec # |
nnnnnnnn |
Fund Source Rec # |
Long Integer |
FN_INVOIC |
Invoiced |
nnnnnnnnn.nn |
Invoiced |
Double |
FN_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
FN_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
FN_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
FN_MP_ID |
Master Proj Rec # |
nnnnnnnn |
Long Integer |
|
FN_NAME |
Name |
255x |
Name |
Text |
FN_PAID |
Paid |
nnnnnnnnn.nn |
Paid |
Double |
FN_PJ_ID |
Project Rec # |
nnnnnnnn |
Long Integer |
|
FN_POADJ |
PO Adjustment Request |
-nnnnnnnnn.nn |
PO Adjustment Request |
Double |
FN_REM |
Remaining |
nnnnnnnnn.nn |
Remaining |
Double |
FN_REQSTR |
Requester |
6x |
Requester |
Text |
FN_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
FN_SCNO |
Shopping Cart No |
10x |
Shopping Cart No |
Text |
FN_STAT_CD |
Status |
6x |
Status |
Text |
FN_STAT_TY |
Status Text |
30x |
Status Text |
Text |
FN_STRT_DT |
PO Start Date |
mm/dd/yyyy |
Start Date |
Date/Time |
FN_TRAN_CD |
Trans Type |
nnn |
Transaction |
Integer |
FN_TRAN_DT |
PO Date |
mm/dd/yyyy |
Transaction Date |
Date/Time |
FN_TRAN_TY |
Trans Type Text |
25x |
Transaction Text |
Text |
FN_USER10 |
User 10 |
mm/dd/yyyy |
User 10 |
Date/Time |
FN_USER11 |
User 11 |
mm/dd/yyyy |
User 11 |
Date/Time |
FN_USER12 |
User 12 |
mm/dd/yyyy |
User 12 |
Date/Time |
FN_USER13 |
User 13 |
|
User 13 |
Boolean |
FN_USER14 |
User 14 |
|
User 14 |
Boolean |
FN_USER15 |
User 15 |
|
User 15 |
Boolean |
FN_USER1CD |
User 1 |
nnn |
User 1 |
Integer |
FN_USER1TY |
User 1 Text |
25x |
User 1 Text |
Text |
FN_USER2CD |
User 2 |
nnn |
User 2 |
Integer |
FN_USER2TY |
User 2 Text |
25x |
User 2 Text |
Text |
FN_USER3CD |
User 3 |
nnn |
User 3 |
Integer |
FN_USER3TY |
User 3 Text |
25x |
User 3 Text |
Text |
FN_USER4 |
User 4 |
30x |
User 4 |
Text |
FN_USER5 |
User 5 |
30x |
User 5 |
Text |
FN_USER6 |
User 6 |
30x |
User 6 |
Text |
FN_USER7 |
User 7 |
-nnnnnnnn.nn |
User 7 |
Double |
FN_USER8 |
User 8 |
-nnnnnnnn.nn |
User 8 |
Double |
FN_USER9 |
User 9 |
-nnnnnnnn.nn |
User 9 |
Double |
FN_VEND_CD |
Vendor |
10x |
Vendor |
Text |
FN_VEND_TY |
Vendor Text |
60x |
Vendor Text |
Text |
FN_XC_ID |
Project Contract Rec # |
nnnnnnnn |
Long Integer |
|
FN_XE_ID |
Contract Estimate Rec # |
nnnnnnnn |
Long Integer |