Module List >
Module JC tables
JC01511
You are currently viewing the COMPANY
database.
Change
|
COMPANY..JC01511 Table Definition
(COMPANY..JC_Master_Subcontractor_MSTR)
Field Definitions:
What is the 'source' column?
| WS_Job_Number |
char(17)
|
|
|
|
|
| Project_Number |
char(17)
|
|
|
|
|
| VENDORID |
char(15)
|
Vendor ID:...(more) Join Now
|
PM10000.VENDORID
|
|
join ... more text available
|
| VENDNAME |
char(65)
|
Vendor Nam...(more) Join Now
|
POP30300.VENDNAME
|
|
|
| LNSEQNBR |
numeric(19,5)
0
|
Line SEQ N...(more) Join Now
|
|
|
|
| ADRSCODE |
char(15)
|
Address Co...(more) Join Now
|
RM20101.ADRSCODE
|
|
|
| Retention_Pct |
numeric(19,5)
|
|
|
|
|
| Mod_Rate |
smallint
|
|
|
|
|
| PSTGSTUS |
smallint
|
Posting St...(more) Join Now
|
RM10301.PSTGSTUS
|
|
|
| PORDNMBR |
char(21)
|
Purchase O...(more) Join Now
|
|
|
|
| Contract_Date |
datetime
|
|
|
|
|
| Vendor_Contract_Type |
smallint
|
|
|
|
|
| Ins_Cert_on_File |
tinyint
|
|
|
|
|
| Ins_Expiration_Date |
datetime
|
|
|
|
|
| Bonded |
tinyint
|
|
|
|
|
| Retention_Withheld_TTD |
numeric(19,5)
|
|
|
|
|
| Apply_Doc_Paid_TTD |
numeric(19,5)
|
|
|
|
|
| Orig_Contract_Amount |
numeric(19,5)
|
|
|
|
|
| Change_Orders_TTD |
numeric(19,5)
|
|
|
|
|
| Contract_to_Date |
numeric(19,5)
|
|
|
|
|
| Lien_Waiver_on_File |
tinyint
|
|
|
|
|
| Submittals |
tinyint
|
|
|
|
|
| Vendor_Invoices_TTD |
numeric(19,5)
|
|
|
|
|
| Actual_Units_TTD |
numeric(19,5)
|
|
|
|
|
| Submit_Date |
datetime
|
|
|
|
|
| Resubmit_Date |
datetime
|
|
|
|
|
| Approved_Date |
datetime
|
|
|
|
|
| Disapproved_Date |
datetime
|
|
|
|
|
| HOLD |
tinyint
|
Hold: 1 i...(more) Join Now
|
RM00101.HOLD
|
|
|
| WRKRCOMP |
char(7)
|
Workers Co...(more) Join Now
|
|
|
|
| Max_Retention_Percent |
numeric(19,5)
|
|
|
|
|
| Max_Retention_Withhold |
numeric(19,5)
|
|
|
|
|
| Maximum_Retention_Type |
smallint
|
|
|
|
|
| JCCIS_Verification_Numb |
char(15)
|
|
|
|
|
| JC_CheckBox_1 |
tinyint
|
|
|
|
|
| JC_CheckBox_2 |
tinyint
|
|
|
|
|
| JC_CheckBox_3 |
tinyint
|
|
|
|
|
| JC_CheckBox_4 |
tinyint
|
|
|
|
|
| JC_CheckBox_5 |
tinyint
|
|
|
|
|
| JC_CheckBox_6 |
tinyint
|
|
|
|
|
| JC_CheckBox_7 |
tinyint
|
|
|
|
|
| JC_CheckBox_8 |
tinyint
|
|
|
|
|
| JC_CheckBox_9 |
tinyint
|
|
|
|
|
| JC_CheckBox_10 |
tinyint
|
|
|
|
|
| USERID |
char(15)
|
The user t...(more) Join Now
|
|
|
join ... more text available
|
| User_Define_1 |
char(31)
|
|
|
|
|
| User_Define_2 |
char(31)
|
|
|
|
|
| User_Define_3 |
char(31)
|
|
|
|
|
| User_Define_4 |
char(31)
|
|
|
|
|
| User_Define_5 |
char(31)
|
|
|
|
|
| User_Define_6 |
char(31)
|
|
|
|
|
| USERDEF1 |
char(21)
|
UserDefine...(more) Join Now
|
|
|
|
| USERDEF2 |
char(21)
|
UserDefine...(more) Join Now
|
|
|
|
| User_Defined_CB_1 |
tinyint
|
|
|
|
|
| User_Defined_CB_2 |
tinyint
|
|
|
|
|
| User_Defined_CB_3 |
tinyint
|
|
|
|
|
| User_Defined_CB_4 |
tinyint
|
|
|
|
|
| USRDAT01 |
datetime
|
|
|
|
|
| USRDAT02 |
datetime
|
|
|
|
|
| User_Defined_Date_3 |
datetime
|
|
|
|
|
| User_Defined_Date_4 |
datetime
|
|
|
|
|
| User_Defined_Dollar_1 |
numeric(19,5)
|
|
|
|
|
| User_Defined_Dollar_2 |
numeric(19,5)
|
|
|
|
|
| User_Defined_Dollar_3 |
numeric(19,5)
|
|
|
|
|
| User_Defined_Dollar_4 |
numeric(19,5)
|
|
|
|
|
| User_Def_Integer_1 |
int
|
|
|
|
|
| User_Def_Integer_2 |
int
|
|
|
|
|
| User_Defined_Integer_3 |
int
|
|
|
|
|
| User_Defined_Integer_4 |
int
|
|
|
|
|
| Wennsoft_Affiliate |
char(15)
|
|
|
|
|
| Wennsoft_Branch |
char(15)
|
|
|
|
|
| Wennsoft_Region |
char(15)
|
|
|
|
|
| MODIFDT |
datetime
|
Date the r...(more) Join Now
|
|
|
|
| Modified_Time |
datetime
|
|
|
|
|
| MDFUSRID |
char(15)
|
User that ...(more) Join Now
|
|
|
join ... more text available
|
| WSReserved_CB1 |
tinyint
|
|
|
|
|
| WSReserved_CB2 |
tinyint
|
|
|
|
|
| WSReserved_CB3 |
tinyint
|
|
|
|
|
| WSReserved_CB4 |
tinyint
|
|
|
|
|
| WSReserved_CB5 |
tinyint
|
|
|
|
|
| WSReserved_STR1 |
char(11)
|
|
|
|
|
| WSReserved_STR2 |
char(11)
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
|