Project Invoice Payments
Field Name |
Caption |
Mask |
Description |
Field Type |
VP_CP_ID |
Invoice Rec # |
nnnnnnnn |
Long Integer |
|
VP_CRT_BY |
Created By |
25x |
Created By |
Text |
VP_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
VP_DOCKNO |
Doc No |
10x |
Doc No |
Text |
VP_FMONTH |
Fiscal Month |
2x |
Fiscal Month |
Text |
VP_FYEAR |
Fiscal Year |
nnnn |
Fiscal Year |
Integer |
VP_GLACCT |
G-L Account |
10x |
G-L Account |
Text |
VP_ID |
Invoice Payment Rec # |
nnnnnnnn |
Invoice Payment Rec # |
Long Integer |
VP_IP_ID |
Payment Rec # |
nnnnnnnn |
Long Integer |
|
VP_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
VP_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
VP_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
VP_PAYAMT |
Payment Amount |
nnnnnnnnn.nn |
Payment Amount |
Double |
VP_POST_DT |
Posting Date |
mm/dd/yyyy |
Posting Date |
Date/Time |
VP_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |