Module List > Module SV tables SV00309
You are currently viewing the COMPANY database.
Change

COMPANY..SV00309 Table Definition

(COMPANY..SV_Service_Request_MSTR)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
Svc_Request_ID char(17)


NOTEINDX numeric(19,5)

Note Index...(more) Join Now
join ... more text available
Svc_Request_Date datetime


Svc_Request_Type smallint


EMPLOYID char(15)

Employee I...(more) Join Now UPR00100.EMPLOYID
join ... more text available
Svc_Request_Name char(31)


Svc_Request_Address char(31)


CITY char(35)

Field Type...(more) Join Now
STATE char(29)

Field Type...(more) Join Now
ZIP char(11)

Field Type...(more) Join Now
Svc_Request_Phone char(21)


Svc_Request_Phone_Type char(31)


Svc_Request_Alt_Phone char(21)


Alt_Phone_Type char(31)


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)

Field Type...(more) Join Now
join ... more text available
ADRSCODE char(15)

Field Type...(more) Join Now
Service_Call_ID char(17)


Date1 datetime

Field Type...(more) Join Now
WS_Time_1a datetime


Svc_Actual__Department char(31)


Equipment_ID char(31)


EMS_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

Date the r...(more) Join Now
Modified_Time datetime


MDFUSRID char(15)

User that ...(more) Join Now
join ... more text available
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)
Unique ide...(more) Join Now
SVC_Request_Note text


Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3