GP Tables

JC01501 - JC_Vendor_MSTR

SQL Query Builder

83 Columns

Column Description Type Length
WS_Job_Number char(17)
Project_Number char(17)
VENDORID char(15)
VENDNAME char(65)
LNSEQNBR numeric(19,5) 0
ADRSCODE char(15)
Retention_Pct numeric(19,5)
Mod_Rate smallint
PSTGSTUS smallint
Posting Status values (11)
0 = Unposted / New1 = Unposted / Work2 = Posted / Open3 = History / Posted with Error10 = First entry before save20 = Saved and unposted30 = Currently posting40 = Posted50 = Error during posting60 = Edited after save70 = Edited recurring batch
PORDNMBR char(21)
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 Status values (2)
0 = Not on hold1 = On hold
WRKRCOMP char(7)
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)
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)
USERDEF2 char(21)
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
Modified_Time datetime
MDFUSRID char(15)
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)

Related Tables

Tables that share columns with JC01501. Click "Join" to add to your query.

DEX_ROW_ID

AAG00200 AAG00201 AAG00202 AAG00300 AAG00301 AAG00302 ACColumn AF00100

MODIFDT

ASIEXP01 ASIEXP02 ASIEXP03 ASIEXP04 ASIEXP06 ASIEXP07 ASIEXP09 ASIEXP11

MDFUSRID

ASIEXP09 ASIEXP19 ASIEXP22 CM20200 CM20300 CT00002 CT00102 CT40401

USERID

AAG50001 AAG60001 AAG70001 ACTIVITY AHPSLH01 APR_APR30000 APR_APR30300 ASIEXP100

Modified_Time

PDK10500 JC00102 JC00103 JC00104 JC00106 JC00107 JC00201 JC00301

WSReserved_CB1

JC00102 JC00103 JC00104 JC00106 JC00107 JC00201 JC00203 JC00301

WSReserved_CB2

JC00102 JC00103 JC00104 JC00106 JC00107 JC00201 JC00203 JC00301

WSReserved_CB3

JC00102 JC00103 JC00104 JC00106 JC00107 JC00201 JC00203 JC00301

WSReserved_CB5

JC00102 JC00103 JC00104 JC00106 JC00107 JC00201 JC00203 JC00301

WSReserved_CB4

JC00102 JC00103 JC00104 JC00106 JC00107 JC00201 JC00203 JC00301