GP Tables

SVA0309 - SV_Service_Requests_Archive

SQL Query Builder

76 Columns

Column Description Type Length
Svc_Request_ID char(17)
Svc_Request_Date datetime
Svc_Request_Type smallint
EMPLOYID char(15)
Svc_Request_Name char(31)
Svc_Request_Address char(31)
CITY char(35)
STATE char(29)
ZIP char(11)
Svc_Request_Phone char(21)
Svc_Request_Alt_Phone char(21)
Request_Email_Address char(41)
Request_Notify_Method char(31)
Svc_Request_Association char(31)
Service_Type_Group smallint
Request_Location_Govt char(31)
Request_Location_Other char(51)
Location_Address char(31)
Svc_Request_Street char(31)
Svc_Request_LCity char(31)
Svc_Request_LZip char(11)
Type_of_Problem char(31)
Svc_Request_Issue char(31)
Svc_Request_Issue_Date datetime
Previously_ReportedGroup smallint
Svc_Request_Department char(31)
CUSTNMBR char(15)
ADRSCODE char(15)
Service_Call_ID char(17)
Date1 datetime
WS_Time_1a datetime
Svc_Actual__Department char(31)
Equipment_ID char(31)
Equipment_Meter1_Master int
Meter_Read_Date datetime
Request_Equipment__Down tinyint
Location_Emergency tinyint
Dept_Emergency_Contact char(41)
Request_EmergencyContact char(41)
MODIFDT datetime
Modified_Time datetime
MDFUSRID char(15)
Service_User_Define_1 char(21)
Service_User_Define_2 char(21)
Service_User_Define_3 char(31)
Service_User_Define_4 char(31)
Service_User_Define_5 int
Service_User_Define_6 int
Service_User_Define_7 int
Service_User_Define_8 int
Service_User_Define_9 datetime
Service_User_Define_10 datetime
Service_User_Define_11 datetime
Service_User_Define_12 datetime
Service_User_Define_18 tinyint
Service_User_Define_19 tinyint
Service_User_Define_20 tinyint
Service_User_Define_21 tinyint
Service_User_Define_22 numeric(19,5)
Service_User_Define_23 numeric(19,5)
Service_User_Define_24 numeric(19,5)
Service_User_Define_25 numeric(19,5)
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)
SVC_Request_Note text

Related Tables

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

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

WSReserved_STR1

JC00102 JC00103 JC00104 JC00106 JC00107 JC00201 JC00401 JC00600