GP Tables

SV00800 - SV_Labor_Loading_Monthly_TEMP_SQL

SQL Query Builder

36 Columns

Column Description Type Length
CUSTNMBR char(15)
ADRSCODE char(15)
LOCATNNM char(31)
Contract_Number char(11)
WSCONTSQ int
Service_Call_ID char(17)
Status_of_Call char(11)
Completion_Date datetime
TRXHRUNT int
Primary_HoursUnits int
SLPRSNID char(15)
Technician char(11)
Technician_Team char(15)
Technician_Long_Name char(31)
Current_Month smallint
Total_Planned_Hours int
Total_Non_Planned_Hours int
Total_Planned_MCC_Hours int
TotalPlannedBurdenHrs int
TotalPlannedBillableHrs int
Start_Month_Number smallint
End_Month_Number smallint
USERID char(15)
CMPNYNAM char(65)
Salesperson_ID_Parm char(15)
Technician_Team_Parm char(15)
Technician_ID_Parm char(15)
Wennsoft_Affiliate char(15)
Wennsoft_Region char(15)
Wennsoft_Branch char(15)
Affiliate_Parm char(15)
Region_Parm char(15)
Branch_Parm char(15)
intComplete smallint
intOpen smallint
DEX_ROW_ID int auto number (1,1)

Related Tables

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

DEX_ROW_ID

AAG00200 AAG00201 AAG00202 AAG00300 AAG00301 AAG00302 ACColumn AF00100

USERID

AAG50001 AAG60001 AAG70001 ACTIVITY AHPSLH01 APR_APR30000 APR_APR30300 ASIEXP100

Wennsoft_Affiliate

JC00102 JC00103 JC00106 JC00201 JC00401 JC00501 JC00601 JC00701

Wennsoft_Region

JC00102 JC00103 JC00106 JC00201 JC00401 JC00501 JC00601 JC00701

Wennsoft_Branch

JC00102 JC00103 JC00106 JC00201 JC00401 JC00501 JC00601 JC00701

CUSTNMBR

ASIEXP02 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP15 ASIEXP19 ASIEXP20 ASIEXP21

ADRSCODE

ASIEXP02 ASIEXP05 ASIEXP07 ASIEXP08 ASIEXP10 ASIEXP15 ASIEXP16 ASIEXP18

Technician_Team

JC00102 JC00106 JC20003 JC30001 JC30003 JC30006 JC40203 JC40204