GP Tables

SV70001 - SV_SQL_Dispatch_Join

SQL Query Builder

55 Columns

Column Description Type Length
Service_Call_ID char(17)
Type_of_Problem char(31)
Technician char(11)
Priority_of_Call char(1)
Status_of_Call char(11)
LOCATNNM char(31)
Service_Description char(31)
Purchase_Order char(15)
Division smallint
Divisions char(15)
Contract_Number char(11)
WSCONTSQ int
User_Define_1a char(31)
User_Define_2a char(31)
User_Define_3a char(31)
User_Define_4a char(31)
Type_Call_Short char(3)
Type_of_Call char(15)
CUSTNMBR char(15)
CUSTNAME char(65)
Call_Invoice_Number char(17)
ADRSCODE char(15)
Technician_Team char(15)
Service_Area char(15)
Wennsoft_Affiliate char(15)
Wennsoft_Region char(15)
Wennsoft_Branch char(15)
Completion_Date datetime
Appointment char(25)
Appointment_Status char(11)
Appointment_Type smallint
Estimate_Hours int
STRTTIME datetime
Task_Date datetime
Resolution_ID char(3)
Resolution_Description char(31)
Skill_Level char(15)
ADDRESS1 char(61)
ADDRESS2 char(61)
CNTCPRSN char(61)
PHONE1 char(21)
CITY char(35)
STATE char(29)
ZIP char(11)
Contract_Description char(31)
Contract_Internal_Name char(15)
WS_Job_Number char(17)
Cost_Code_Alias char(27)
Location_Time_Zone_Tag char(5)
Location_Start_Time datetime
Location_Task_Date datetime
Technician_Time_Zone_Tag char(5)
Technician_Start_Time datetime
Technician_Task_Date datetime
DEX_ROW_ID int auto number (1,1)

Related Tables

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

DEX_ROW_ID

AAG00200 AAG00201 AAG00202 AAG00300 AAG00301 AAG00302 ACColumn AF00100

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