GP Tables

JC40702 - JC_Subs_Dates_SETP

SQL Query Builder

107 Columns

Column Description Type Length
Record_Sequence smallint
Ins_Cert_on_File tinyint
Lien_Waiver_on_File tinyint
O_M_Manuals tinyint
Payment_Bond tinyint
Performance_Bond tinyint
Ins_Certificate_Reminder tinyint
Lien_Waiver_Reminder tinyint
O_M_Manuals_Reminder tinyint
Payment_Bond_Reminder tinyint
Performance_Bond_Reminde tinyint
Ins_Certificate_Days smallint
Lien_Waiver_Days_Notice smallint
O_M_Manuals_Days smallint
Payment_Bond_Days_Notice smallint
Perform_Bond_Days_Notice smallint
JC_Required_CB_1 tinyint
JC_Required_CB_2 tinyint
JC_Required_CB_3 tinyint
JC_Required_CB_4 tinyint
JC_Required_CB_5 tinyint
JC_Required_CB_6 tinyint
JC_Required_CB_7 tinyint
JC_Required_CB_8 tinyint
JC_Required_CB_9 tinyint
JC_Required_CB_10 tinyint
JC_Required_CB_11 tinyint
JC_Required_CB_12 tinyint
JC_Required_CB_13 tinyint
JC_Required_CB_14 tinyint
JC_Required_CB_15 tinyint
JC_Required_CB_16 tinyint
JC_Required_CB_17 tinyint
JC_Required_CB_18 tinyint
JC_Required_CB_19 tinyint
JC_Required_CB_20 tinyint
JC_Reminder_CB_1 tinyint
JC_Reminder_CB_2 tinyint
JC_Reminder_CB_3 tinyint
JC_Reminder_CB_4 tinyint
JC_Reminder_CB_5 tinyint
JC_Reminder_CB_6 tinyint
JC_Reminder_CB_7 tinyint
JC_Reminder_CB_8 tinyint
JC_Reminder_CB_9 tinyint
JC_Reminder_CB_10 tinyint
JC_Reminder_CB_11 tinyint
JC_Reminder_CB_12 tinyint
JC_Reminder_CB_13 tinyint
JC_Reminder_CB_14 tinyint
JC_Reminder_CB_15 tinyint
JC_Reminder_CB_16 tinyint
JC_Reminder_CB_17 tinyint
JC_Reminder_CB_18 tinyint
JC_Reminder_CB_19 tinyint
JC_Reminder_CB_20 tinyint
JC_Days_Notice_1 smallint
JC_Days_Notice_2 smallint
JC_Days_Notice_3 smallint
JC_Days_Notice_4 smallint
JC_Days_Notice_5 smallint
JC_Days_Notice_6 smallint
JC_Days_Notice_7 smallint
JC_Days_Notice_8 smallint
JC_Days_Notice_9 smallint
JC_Days_Notice_10 smallint
JC_Days_Notice_11 smallint
JC_Days_Notice_12 smallint
JC_Days_Notice_13 smallint
JC_Days_Notice_14 smallint
JC_Days_Notice_15 smallint
JC_Days_Notice_16 smallint
JC_Days_Notice_17 smallint
JC_Days_Notice_18 smallint
JC_Days_Notice_19 smallint
JC_Days_Notice_20 smallint
USERID char(15)
User_Define_1 char(31)
User_Define_2 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
User_Def_Integer_1 int
User_Def_Integer_2 int
User_Defined_Integer_3 int
User_Defined_Integer_4 int
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)
Wennsoft_Affiliate char(15)
Wennsoft_Branch char(15)
Wennsoft_Region char(15)
MODIFDT datetime
Modified_Time datetime
MDFUSRID char(15)
SV_Language_ID smallint
Time_Zone char(3)
WSReserved_CB1 tinyint
WSReserved_CB2 tinyint
WSReserved_CB3 tinyint
WSReserved_CB4 tinyint
WSReserved_CB5 tinyint
DEX_ROW_ID int auto number (1,1)

Related Tables

Tables that share columns with JC40702. 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