GP Tables

JC00701 - JC_Job_Detail_MSTR

SQL Query Builder

125 Columns

Column Description Type Length
WS_Job_Number char(17)
Project_Number char(17)
Cost_Code_Number_1 char(7)
Cost_Code_Number_2 char(7)
Cost_Code_Number_3 char(7)
Cost_Code_Number_4 char(7)
Cost_Code_Alias char(27)
Cost_Code_Description char(31)
Cost_Element smallint
WS_Manager_ID char(15)
WS_Inactive tinyint
Profit_Type_Number smallint
Profit_Amount numeric(19,5)
Type_of_Transaction smallint
Next_Subdivision_Type smallint
WS_Account_Index_1 int
WS_Account_Index_2 int
Added_By_CO_Module tinyint
Track_Production_Qty tinyint
Cost_Code_Act_Cost_TTD numeric(19,5)
Cost_Code_Act_Cost_YTD numeric(19,5)
Actual_Units_TTD numeric(19,5)
Cost_Code_Estimated_Cst numeric(19,5)
Change_Order_Est_Cost numeric(19,5)
Cost_Code_Rvsd_Est_Cost numeric(19,5)
Cost_Code_Forecast_Cost numeric(19,5)
Cost_Code_Rvsd_Forecast numeric(19,5)
Forecasted_Units numeric(19,5)
Committed_Cost numeric(19,5)
Committed_Units numeric(19,5)
Cost_Code_Est_Unit numeric(19,5)
Estimated_Amt_Units numeric(19,5)
Production_Estimate_Qty numeric(19,5)
Production_Actual_Qty numeric(19,5)
Production_Qty_Unit numeric(19,5)
Production_Qty_Curr_Per numeric(19,5)
Production_Best numeric(19,5)
Production_Best_Date datetime
Production_Measure_Code char(7)
OVHD1_UOM char(21)
OVHD1_Type smallint
OVHD1_Percent smallint
OVHD1_Estimated_Units numeric(19,5)
OVHD1_Actual_Units numeric(19,5)
OVHD1_Forecasted_Units numeric(19,5)
OVHD1_Amt_Per_Unit numeric(19,5)
OVHD1_Estimated_Amount numeric(19,5)
OVHD1_Actual_Amount numeric(19,5)
OVHD1_Profit_Type smallint
OVHD1_Profit_Amount numeric(19,5)
OVHD2_UOM char(21)
OVHD2_Type smallint
OVHD2_Percent smallint
OVHD2_Estimated_Units numeric(19,5)
OVHD2_Actual_Units numeric(19,5)
OVHD2_Forecasted_Units numeric(19,5)
OVHD2_Amt_Per_Unit numeric(19,5)
OVHD2_Estimated_Amount numeric(19,5)
OVHD2_Actual_Amount numeric(19,5)
OVHD2_Profit_Type smallint
OVHD2_Profit_Amount numeric(19,5)
Bill_Type smallint
Sched_Completion_Date datetime
ACTCOMPDATE datetime
Schedule_Start_Date datetime
ACTSTARTDATE datetime
Billing_Schedule_Line char(9)
Estimated_Measure_Code char(7)
Amount_Pct_Complete smallint
Units_Pct_Complete smallint
Production_Pct_Complete smallint
Field_Pct_Complete smallint
Posted_To tinyint
WRKRCOMP char(7)
Change_Order_Est_Units numeric(19,5)
Labor_Group_Name char(15)
USERID char(15)
User_Define_1 char(31)
User_Define_2 char(31)
USERDEF1 char(21)
USERDEF2 char(21)
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)
USRDAT01 datetime
USRDAT02 datetime
User_Defined_Date_3 datetime
User_Defined_Date_4 datetime
User_Defined_CB_1 tinyint
User_Defined_CB_2 tinyint
User_Defined_CB_3 tinyint
User_Defined_CB_4 tinyint
VNDRNMBR char(25)
ITEMNMBR char(31)
PORDNMBR char(21)
CC_Rvsd_Forecast_Units numeric(19,5)
Rate_Per_Unit numeric(19,5)
Original_Estimate_Units numeric(19,5)
Original_Forecast_Units 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
WSReserved_CB6 tinyint
WSReserved_CB7 tinyint
WSReserved_CB8 tinyint
WSReserved_CB9 tinyint
WSReserved_CB10 tinyint
WSReserved_STR1 char(11)
WSReserved_STR2 char(11)
DEX_ROW_ID int auto number (1,1)

Related Tables

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