Project Contractor Payments
Field Name |
Caption |
Mask |
Description |
Field Type |
IP_ACCTNO |
Account Number |
30x |
Account No |
Text |
IP_CHECKNO |
Check Number |
30x |
Check No |
Text |
IP_CP_ID |
Invoice Rec # |
nnnnnnnn |
Long Integer |
|
IP_CRT_BY |
Created By |
25x |
Created By |
Text |
IP_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
IP_DOC_FLG |
Document Available |
|
Document Available |
Boolean |
IP_ID |
Invoice Payment Rec # |
nnnnnnnn |
Invoice Payment Rec # |
Long Integer |
IP_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
IP_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
IP_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
IP_PAY_DT |
Payment Date |
mm/dd/yyyy |
Payment Date |
Date/Time |
IP_PAYAMT |
Payment Amount |
nnnnnnnnn.nn |
Payment Amount |
Double |
IP_PYEAR |
Prior Year Payment |
|
Prior Year Project |
Boolean |
IP_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
IP_USER10 |
User 10 |
mm/dd/yyyy |
User 10 |
Date/Time |
IP_USER11 |
User 11 |
mm/dd/yyyy |
User 11 |
Date/Time |
IP_USER12 |
User 12 |
mm/dd/yyyy |
User 12 |
Date/Time |
IP_USER13 |
User 13 |
|
User 13 |
Boolean |
IP_USER14 |
User 14 |
|
User 14 |
Boolean |
IP_USER15 |
User 15 |
|
User 15 |
Boolean |
IP_USER1CD |
User 1 |
nnn |
User 1 |
Integer |
IP_USER1TY |
User 1 Text |
25x |
User 1 Text |
Text |
IP_USER2CD |
User 2 |
nnn |
User 2 |
Integer |
IP_USER2TY |
User 2 Text |
25x |
User 2 Text |
Text |
IP_USER3CD |
User 3 |
nnn |
User 3 |
Integer |
IP_USER3TY |
User 3 Text |
25x |
User 3 Text |
Text |
IP_USER4 |
User 4 |
30x |
User 4 |
Text |
IP_USER5 |
User 5 |
30x |
User 5 |
Text |
IP_USER6 |
User 6 |
30x |
User 6 |
Text |
IP_USER7 |
User 7 |
-nnnnnnnn.nn |
User 7 |
Double |
IP_USER8 |
User 8 |
-nnnnnnnn.nn |
User 8 |
Double |
IP_USER9 |
User 9 |
-nnnnnnnn.nn |
User 9 |
Double |
IP_VEND_CD |
Vendor |
10x |
Vendor |
Text |
IP_VEND_TY |
Vendor Name |
60x |
Vendor Name |
Text |