GP Tables

SV99999 - SV_SQL_Filtering

SQL Query Builder

29 Columns

Column Description Type Length
SQL_Filtering_User_ID char(15)
FORMNAME char(79)
Technician char(11)
Technician_ID char(15)
Service_Area char(15)
CUSTNMBR char(15)
ADRSCODE char(15)
Type_Call_Short char(3)
Status_of_Call char(11)
Appointment_Status char(11)
STRTDATE datetime
ENDDATE datetime
Closed_Service_Call char(11)
Completed_Service_Call char(11)
Generated_Service_Call char(3)
Quote_Service_Call char(11)
Service_Calls char(21)
Jobs char(11)
Activities char(15)
Priority smallint
PriorityUpDown smallint
Wennsoft_Affiliate char(15)
Wennsoft_Region char(15)
Wennsoft_Branch char(15)
User_Define_1a char(31)
User_Define_2a char(31)
Technician_Team char(15)
WSReserved_CB1 tinyint
DEX_ROW_ID int auto number (1,1)

Related Tables

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

DEX_ROW_ID

AAG00200 AAG00201 AAG00202 AAG00300 AAG00301 AAG00302 ACColumn AF00100

WSReserved_CB1

JC00102 JC00103 JC00104 JC00106 JC00107 JC00201 JC00203 JC00301

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

Technician_ID

JC00102 JC00106 JC20003 JC30001 JC30003 JC30006 JC40203 JC40204