Project Contractor Invoices
Field Name |
Caption |
Mask |
Description |
Field Type |
CP_APP_DT |
Approved Date |
mm/dd/yyyy |
Approved Date |
Date/Time |
CP_APPAMT |
Approved Amount |
nnnnnnnnn.nn |
Approved Amount |
Double |
CP_COMMENT1 |
Long Note |
|
Long Note |
Memo |
CP_CRT_BY |
Created By |
25x |
Created By |
Text |
CP_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
CP_DOC_FLG |
Document Available |
|
Document Available |
Boolean |
CP_HLDAMT |
Retainage |
nnnnnnnnn.nn |
Held Amount |
Double |
CP_ID |
Contr Payment Rec # |
nnnnnnnn |
Contractor Payment Rec # |
Long Integer |
CP_INV_NO |
Invoice Number |
25x |
Invoice Number |
Text |
CP_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
CP_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
CP_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
CP_MP_ID |
Master Project Rec # |
nnnnnnnn |
Long Integer |
|
CP_PAID |
Amount Paid |
nnnnnnnnn.nn |
Amount Paid |
Double |
CP_PJ_ID |
Project Rec # |
nnnnnnnn |
Long Integer |
|
CP_REMAMT |
Remaining Amount |
nnnnnnnnn.nn |
Remaining Amount |
Double |
CP_REQ_DT |
Invoice Date |
mm/dd/yyyy |
Requested Date |
Date/Time |
CP_REQAMT |
Invoiced Amount |
nnnnnnnnn.nn |
Requested Amount |
Double |
CP_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
CP_USER10 |
User 10 |
mm/dd/yyyy |
User 10 |
Date/Time |
CP_USER11 |
User 11 |
mm/dd/yyyy |
User 11 |
Date/Time |
CP_USER12 |
User 12 |
mm/dd/yyyy |
User 12 |
Date/Time |
CP_USER13 |
User 13 |
|
User 13 |
Boolean |
CP_USER14 |
User 14 |
|
User 14 |
Boolean |
CP_USER15 |
User 15 |
|
User 15 |
Boolean |
CP_USER1CD |
User 1 |
nnn |
User 1 |
Integer |
CP_USER1TY |
User 1 Text |
25x |
User 1 Text |
Text |
CP_USER2CD |
User 2 |
nnn |
User 2 |
Integer |
CP_USER2TY |
User 2 Text |
25x |
User 2 Text |
Text |
CP_USER3CD |
User 3 |
nnn |
User 3 |
Integer |
CP_USER3TY |
User 3 Text |
25x |
User 3 Text |
Text |
CP_USER4 |
User 4 |
30x |
User 4 |
Text |
CP_USER5 |
User 5 |
30x |
User 5 |
Text |
CP_USER6 |
User 6 |
30x |
User 6 |
Text |
CP_USER7 |
User 7 |
-nnnnnnnn.nn |
User 7 |
Double |
CP_USER8 |
User 8 |
-nnnnnnnn.nn |
User 8 |
Double |
CP_USER9 |
User 9 |
-nnnnnnnn.nn |
User 9 |
Double |
CP_VEND_CD |
Vendor |
10x |
Vendor |
Text |
CP_VEND_TY |
Vendor Text |
60x |
Vendor Text |
Text |