Project Subcontractors
Field Name |
Caption |
Mask |
Description |
Field Type |
SC_CCMP_DT |
Subcontract Compl |
mm/dd/yyyy |
Subcontractor Completion Date |
Date/Time |
SC_CEXP_DT |
Subcontract Expires |
mm/dd/yyyy |
Subcontractor Expiration Date |
Date/Time |
SC_CONT_CD |
Subcontractor |
20x |
Subcontractor |
Text |
SC_CONT_TY |
Subcontractor Text |
40x |
Subcontractor Text |
Text |
SC_CONTAMT |
Subcontract Amt |
nnnnnnnnn.nn |
Subcontractor Amount |
Double |
SC_CONTNUM |
Subcontract # |
20x |
Subcontractor Number |
Text |
SC_CRT_BY |
Created By |
25x |
Created By |
Text |
SC_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
SC_CST_DT |
Subcontract Start |
mm/dd/yyyy |
Subcontractor Start Date |
Date/Time |
SC_DOC_FLG |
Document Available |
|
Document Available |
Boolean |
SC_ID |
Subcontractor Rec # |
nnnnnnnn |
Project Rec # |
Long Integer |
SC_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
SC_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
SC_MOD_TM |
Last Modified TIme |
hh:mm am |
Modified Time |
Date/Time |
SC_MP_ID |
Master Proj Rec # |
nnnnnnnn |
Long Integer |
|
SC_PJ_ID |
Project Rec # |
nnnnnnnn |
Long Integer |
|
SC_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |