WennSoft Service Management

350 tables in this module

Table	Description	Columns
SV00AD1	Actual Department	2
SV00010	SVFacilityBrokerSetup	4
SV00012	SV_System_Option_MSTR	55
SV00015	SV_Branch_MSTR	54
SV00020	SV_Affiliate_MSTR	1
SV00021	SV_Region_MSTR	44
SV00030	SV_SA_Password_Setup_MSTR	48
SV00032	SV_SA_Password_User_MSTR	51
SV00033	SV_Security_Level_MSTR	46
SV00034	SV_System_Administration_MSTR	6
SV00040	SV_Postal_Code_MSTR	56
SV00045	SV_Time_Zone_MSTR	33
SV00053	SV_Contract_Quicksearch	23
SV00054	SV_Customer_Quicksearch	21
SV00055	SV_Equipment_Quicksearch	18
SV00062	SV_Number_MSTR	1
SV00077	SV_Division_MSTR	46
SV00099	SV_Conversion_MSTR	4
SV00100	SV_Customer_MSTR	67
SV00101	SV_RM_Class_MSTR	26
SV00105	SV_Customer_Define1a_MSTR	19
SV00110	SV_Customer_Define2a_MSTR	19
SV00113	SV_Vehicle_MSTR	1
SV00114	SV_Technician_Branch_MSTR	39
SV00115	SV_Lookup_Tech_MSTR	38
SV00116	SV_Technician_Team_MSTR	17
SV00117	SV_Invoice_Number_MSTR	3
SV00118	SV_Technician_Shift_SETP	5
SV00119	SV_InternalCustomer	52
SV00120	SV_Lookup_Billing_Rate_MSTR	4
SV00122	SV_Billing_Rate_MSTR	1
SV00123	SV_Labor_Rate_Group_MSTR	1
SV00130	SV_Salesperson_MSTR	41
SV00131	SV_Salesperson_Mass_Reassign_Source	10
SV00132	SV_Salesperson_Mass_Reassign_Dest	11
SV00142	SV_Quote_Pricing_MSTR	23
SV00143	SV_Pricing_Matrix_MSTR	20
SV00144	SV_Inventory_Markdown_MSTR	31
SV00145	SV_Other_Costs_MSTR	44
SV00148	Graphical Dispatch Board Setup	30
SV00149	Graphical Dispatch Board Fields	12
SV00150	SV_Technician_Labor_Plan_MSTR	141
SV00155	SV_Technician_Skill_Set_MSTR	57
SV00160	SV_Customer_Contact_MSTR	54
SV00165	SV_Extended_Pricing_Matrix_HDR	12
SV00166	SV_Extended_Pricing_Matrix_LINE	22
SV00167	SV_Extended_Pricing_Matrix_SETP	10
SV00182	SV_Equipment_Replacement_Parts_MSTR	1
SV00183	SV_Equipment_Type_Replacement_Parts_MSTR	1
SV00196	SV_Setup2_MSTR	109
SV00197	SV_Setup_Custom_Options	119
SV00198	SV_Setup_Custom_Options_Labels	3
SV00199	Service Auto Number Master	56
SV00200	SV_Location_MSTR	112
SV00201	SV_SubLocation_MSTR	32
SV00205	SV_Location_Contact_MSTR	56
SV00215	SV_Location_Technicians_MSTR	42
SV00220	SV_Service_Area_MSTR	24
SV00221	SV_Service_Area_Technicians_MSTR	4
SV00225	SV_Location_Define1a_MSTR	19
SV00230	SV_Location_Define2a_MSTR	19
SV00300	SV_Service_MSTR	143
SV00301	SV_Service_Appointments_MSTR	52
SV00302	SV_Service_Tasks_MSTR	95
SV00303	SV_Service_Response_Numeric_MSTR	9
SV00304	SV_Service_Response_String_MSTR	6
SV00305	SV_Tool_Unit_MSTR	31
SV00306	SV_Service_Request_SETP	43
SV00307	SV_Service_Request_Lookup_Type_MSTR	35
SV00308	SV_Service_Request_Lookup_MSTR	43
SV00309	SV_Service_Request_MSTR	80
SV00310	SV_Type_Problem_MSTR	20
SV00311	SV_Service_Task_Code_Materials	48
SV00312	SV_Service_Activity_MSTR	17
SV00314	SV_Time_Ticket_Activity_MSTR	14
SV00315	SV_Type_Equipment_MSTR	19
SV00320	SV_Type_Call_MSTR	22
SV00324	SV_Task_Status_SETP	19
SV00325	SV_Type_Status_MSTR	21
SV00326	SV_Technician_Status_MSTR	5
SV00330	SV_Service_Define1a_MSTR	19
SV00331	SV_Service_Define2a_MSTR	19
SV00340	SV_Service_ID_Log_MSTR	54
SV00351	SV_Service_Technician_WORK	63
SV00360	SV_Task_Define5_MSTR	17
SV00361	SV_Task_Define6_MSTR	17
SV00362	SV_Task_Define7_MSTR	17
SV00370	SV_Task_Define_5_6_Combination	42
SV00387	SV_Service_Assigned_Equipment_MSTR	122
SV00392	SV_Trouble_Codes_MSTR	37
SV00393	SV_Resolution_Codes_MSTR	37
SV00394	SV_Service_Resolution_MSTR	45
SV00400	SV_Equipment_MSTR	112
SV00401	SV_Equipment_MSTR_TEMP	96
SV00402	SV_Quote_Equipment_MSTR	13
SV00403	SV_Equipment_Contract_Coverage_MSTR	38
SV00405	SV_Equipment_Type_MSTR	82
SV00406	SV_IV_Item_MSTR	34
SV00410	SV_Manufacturer_MSTR	3
SV00411	SV_Model_Number_MSTR	7
SV00415	SV_Install_MSTR	1
SV00420	SV_Warranty_MSTR	19
SV00425	SV_Equipment_Type_MSTR_TRX	81
SV00430	SV_Equipment_Meter_MSTR	35
SV00450	SV_Equipment_Test_Label_SETP	1
SV00451	SV_Equipment_Test_MSTR	1
SV00460	SV_Plant_MSTR	64
SV00470	SV_Plant_Type_MSTR	58
SV00480	SV_Report_Button_Names_MSTR	62
SV00490	Service PO Integration	18
SV00500	SV_Maint_MSTR	254
SV00501	SV_Maint_HIST	254
SV00502	SV_Quote_MSTR	148
SV00503	SV_Maint_Cost_Estimates	43
SV00504	SV_Maint_Cost_Estimates_History	44
SV00505	SV_Contract_Detail_Summary	34
SV00506	SV_Maintenance_Number_MSTR	20
SV00507	SV_Contract_Billing_HIST	105
SV00508	SV_Contract_Revenue_Method2_HIST	47
SV00509	SV_Contract_Revenue_Method2_MSTR	46
SV00510	SV_Contract_Billing_MSTR	105
SV00511	SV_Maintenance_Setup_MSTR	73
SV00512	SV_Maintenance_Setup1_MSTR	30
SV00514	SV_Revenue_Recognition_Summary	54
SV00515	SV_Maint_Contract_Type_MSTR	38
SV00517	Service Level Master	63
SV00519	Service Time Master	85
SV00520	SV_Major_MSTR	25
SV00521	SV_Sub1_MSTR	25
SV00522	SV_Sub2_MSTR	25
SV00523	SV_Sub3_MSTR	25
SV00524	SV_Sub4_MSTR	25
SV00525	SV_System_MSTR	25
SV00526	SV_Escalation_Index_MSTR	18
SV00527	SV_Escalation_Index_Detail	24
SV00528	SV_Maint_Escalation_Index_MSTR	43
SV00529	SV_Equipment_Type_Task_Codes_MSTR	161
SV00531	SV_Contract_Task_Comment	24
SV00532	SV_Maint_Period_MSTR	27
SV00533	SV_Maint_Escalation_MSTR	94
SV00534	SV_Maint_Escalation_HIST	72
SV00535	SV_Maint_Escalation_Builds_MSTR	22
SV00536	SV_Contract_Task_Response_MSTR	59
SV00537	SV_Maint_Service_HDR	9
SV00538	SV_Equipment_Type_Task_Codes_MSTR_TRX	161
SV00540	SV_Standard_Frequency_MSTR	15
SV00541	SV_Standard_Frequency_Schedule_MSTR	29
SV00544	SV_Quote_Task_List_MSTR	42
SV00545	SV_Quote_Task_MSTR	117
SV00546	SV_Quote_Task_Subtasks_MSTR	26
SV00547	SV_Revenue_Recognition_WORK	20
SV00548	SV_Quote_Task_Schedule	17
SV00549	SV_Quote_Task_Code_Materials	48
SV00550	SV_Maint_Annual_MSTR	85
SV00551	SV_Maint_Annual_Rate_MSTR	56
SV00552	SV_Maint_Annual_Task_Desc	16
SV00555	SV_Contract_Define1a_MSTR	19
SV00556	SV_Contract_Define2a_MSTR	19
SV00559	SV_Task_Code_Materials	44
SV00560	SV_Task_Codes_MSTR	96
SV00561	SV_Task_Codes_MSTR_TRX	111
SV00562	SV_Task_Codes_Description_MSTR	19
SV00563	SV_Task_Codes_Description_MSTR_TRX	19
SV00564	SV_Maint_Invoice_MSTR	96
SV00565	SV_Sub_Tasks_MSTR	21
SV00566	SV_Sub_Task_Define1a_MSTR	19
SV00567	SV_Maint_Billing_Note_MSTR	22
SV00568	SV_Maint_Billing_Note	26
SV00569	SV_Task_Response_DDL_SETP	4
SV00570	SV_Toolkit_MSTR	39
SV00572	SV_Skill_Level_MSTR	38
SV00573	SV_Material_Kit_MSTR	39
SV00575	SV_Contract_Contact_MSTR	60
SV00580	SV_Task_Group_MSTR	25
SV00581	SV_Contract_Task_List_MSTR	43
SV00582	SV_Contract_Task_MSTR	119
SV00583	SV_Contract_Task_Sub_Task_MSTR	28
SV00584	SV_Task_List_Type_MSTR	2
SV00585	SV_Contract_Task_Schedule	18
SV00586	SV_Contract_Task_Code_Materials	49
SV00587	SV_Contract_Task_Code_Materials_History	50
SV00591	SV_Task_List_MSTR	31
SV00592	SV_Task_List_Tasks_MSTR	110
SV00593	SV_Task_List_Sub_Task_MSTR	22
SV00598	SV_Overdue_PM_MSTR	1
SV00602	SV_Cost_Codes_MSTR	3
SV00640	SV_Master_Contract_Financial_MSTR	163
SV00650	SV_Master_Contract_MSTR	100
SV00651	Master Contract User Defined1 Master	46
SV00652	Master Contract User Defined2 Master	46
SV00654	SV_Master_Contract_Escalation_MSTR	51
SV00655	SV_Master_Contract_Billing_MSTR	1
SV00660	SV_Customer_Contract_Detail	7
SV00700	SV_Invoice_MSTR	192
SV00701	SV_Invoice_History	191
SV00702	SV_Invoice_MSTR_Report	212
SV00735	SV_Cost_Element_MSTR	38
SV00736	SV_Cost_Element_MC_MSTR	38
SV00785	SV_Other_Costs_Maintenance_Accounts	1
SV00786	SV_Other_Costs_Accounts	1
SV00787	SV_Invoice_Setup_MSTR	1
SV00788	SV_Invoice_Setup2_MSTR	1
SV00789	SV_Invoice_Tax_Option_MSTR	1
SV00790	SV_Invoice_Tax_Option_Other_MSTR	1
SV00791	SV_Maint_Tax_Option_MSTR	1
SV00792	SV_Maint_Tax_Option_Other_MSTR	1
SV00798	SV_Invoices_To_Group_Batch_Settings	1
SV00799	SV_Invoices_To_Group_TEMP	1
SV00800	SV_Labor_Loading_Monthly_TEMP_SQL	36
SV00801	SV_Labor_Load_Annual_Schedule	95
SV00805	SV_Note_MSTR	1
SV00810	SV_Job_Costs_WORK	1
SV00811	SV_Job_Costs_WORK_Report	1
SV00815	SV_Job_Costs_HISTORY	1
SV00816	SV_Invoice_Trailing_Costs	1
SV00817	SV_Invoice_Trailing_PPV_Costs	1
SV00900	SV_User_Defined_MSTR	62
SV00905	SV_User_Defined2_MSTR	54
SV00906	SV_Active_User_Defined_MSTR	33
SV00910	SV_User_Preference_MSTR	73
SV008115	SV_Work_Order_Name_MSTR	42
SV01100	SV_Contact_MSTR	78
SV01105	SV_Contact_ID_MSTR	6
SV01110	SV_Contact_Define1_MSTR	46
SV01115	SV_Technician_Inventory_Sites	3
SV01120	SV_Contact_Define2_MSTR	46
SV01130	SV_Contact_Define3_MSTR	46
SV01140	SV_Contact_Define4_MSTR	46
SV01150	SV_Contact_Phone_MSTR	52
SV01160	SV_Phone_Type_MSTR	45
SV01170	SV_Contact_Role_Type_MSTR	46
SV02001	SV_RDC_Audit_Trail	54
SV10000	SV_File_Maint_Error_Log	1
SV30180	SV_Refrigerant_Tracking	1
SV30301	SV_Appointment_History_MSTR	33
SV30302	SV_Service_Call_Task_Lists_TEMP	7
SV40100	SV Monitor Setup	9
SV40180	SV_Refrigerant_Type_SETP	1
SV40182	SV_Refrigerant_Codes_SETP	1
SV40184	SV_Refrigerant_Leak_SETP	1
SV40200	SV_Shift_SETP	14
SV40201	SV_Shift_Daily_SETP	10
SV40401	SV_Time_Refresh_SETP	7
SV70001	SV_SQL_Dispatch_Join	55
SV71100	SVFacilityBrokerClient	1
SV71200	SVFacilityBrokerLocation	1
SV71300	SVFacilityBrokerCall	1
SV90001	SV_Dispatch_Join	1
SV90002	SV_Tech_Board_Join	1
SV90006	SV_Service_Calls_By_Tech	1
SV90010	SV_Master_Contract_Amt_Summary	1
SV90011	SV_Master_Contract_Escal_Summary	1
SV90012	SV_Master_Contract_Rev_Summary	1
SV90020	SV_Sum_Call_Hrs	1
SV90119	SV_Customer_Billing_View	1
SV90120	SV_Customer_Billing_Address_View	1
SV90221	SV_Service_Area_Tech_Join	1
SV90300	SV_Technician_Shift_Exception_View	1
SV90585	SV_Contract_Task_Subtask_Join	1
SV90590	SV_Task_Subtask_Join	1
SV90591	SV_Contract_Task_Subtask_Join_2	1
SV99300	SV_Service_MSTR_VIEW	1
SV99302	SV_Service_Tasks_Equipment_MSTR_View	1
SV99403	SV_Equipment_Contract_Coverage_VIEW	1
SV99503	SV_Maint_Contract_Spending_Plan_Report	1
SV99548	SV_Quote_Schedule_View	1
SV99560	SV_Task_Task_Sub_Join	1
SV99585	SV_Contract_Schedule_View	1
SV99585c	SV_Contract_Schedule_Cal_View	1
SV99593	SV_Task_List_Task_Sub_Join	1
SV99999	SV_SQL_Filtering	29
SV333333	SV_Broadcast_Warehouse_MSTR	23
SV585CLP	SV_Contract_Tasks_TEMP	38
SV_Costs	SV_Service_Costs_VIEW	1
SV_NotGL	SV_ServiceNotInGL_View	1
SV_NotSV	SV_GLCostNotInService_VIEW	1
SV_Recon	SV_Reconciliation_View	1
SV_SVC_R	SV_Service_Request_MSTR_RPT	26
SV_SVRec	SV_SVReconciliation_View	1
SVAUTONM	SV_Auto_Numbers_Used	6
SVBTRIEV	SV_Error_Messages_MSTR_Btrieve	1
SVCTREE	SV_Error_Messages_MSTR_Ctree	1
SVDISMAP	Dispatch Mapping Temporary	1
SVDOCMST	SV_Document_MSTR	48
SVDOCPAR	SV_Document_Parms	41
SVDOCVUE	SV_Document_Viewers	42
SVERRORS	SV_Error_Messages_MSTR	7
SVINTER1	ServiceCallWarehouse	133
SVINTER2	ServiceCallOptions	23
SVINTER3	ServiceEquipWarehouse	94
SVINTER4	ServiceTechWarehouse	33
SVINTER5	ServiceMaintWarehouse	228
SVINTER6	ServiceMeterWarehouse	35
SVINTER7	ServiceJCHWarehouse	99
SVINTER8	ServiceNoteWarehouse	61
SVMAINTE	SV_Maint_Escalation_TEMP	107
SVPGMESG	SV_Pager_Message_Setup_MSTR	19
SVPGSETP	SV_Pager_Setup_MSTR	15
SVPGVNDR	SV_Pager_Vendor_MSTR	18
SVRSPMST	SV_Response_Type_MSTR	14
SVRMA301	Receivables GL Distribution History Archive	19
SVRMA305	Commission History Archive	22
DummySVL	Dummy SV Contract	1
DummySVC	Dummy SV Customer	1
DummyET	Dummy SV Equipment Type	1
DummySVE	Dummy SV Equipment	1
DummyM	Dummy SV Model	1
SVA0053	SV_Contract_Quicksearch_Archive	21
SVA0054	SV_Customer_Quicksearch_Archive	21
SVA0055	SV_Equipment_Quicksearch_Archive	18
SVA0100	SV_Customer_MSTR_Archive	67
SVA0115	SV_Lookup_Tech_MSTR_Archive	38
SVA0118	SV_Technician_Shift_SETP_Archive	5
SVA0150	SV_Technician_Labor_Plan_MSTR_Archive	141
SVA0155	SV_Technician_Skill_Set_MSTR_Archive	57
SVA0160	SV_Customer_Contact_MSTR_Archive	54
SVA0200	SV_Location_MSTR_Archive	112
SVA0205	SV_Location_Contact_MSTR_Archive	56
SVA0215	SV_Location_Technicians_MSTR_Archive	42
SVA0300	SV_Service_MSTR_Archive	143
SVA0301	SV_Service_Appointments_MSTR_Archive	52
SVA0302	SV_Service_Tasks_MSTR_Archive	95
SVA0309	SV_Service_Requests_Archive	76
SVA0311	SV_Service_Task_Code_Materials_Archive	48
SVA0340	SV_Service_ID_Log_MSTR_Archive	54
SVA0400	SV_Equipment_MSTR_Archive	112
SVA0430	SV_Equipment_Meter_MSTR_Archive	35
SVA0460	SV_Plant_MSTR_Archive	64
SVA0500	SV_Maint_MSTR_Archive	249
SVA0501	SV_Maint_HIST_Archive	251
SVA0503	SV_Maint_Cost_Estimates_Archive	44
SVA0505	SV_Contract_Detail_Summary_Archive	34
SVA0507	SV_Contract_Billing_HIST_Archive	105
SVA0508	SV_Contract_Revenue_Method2_HIST_Archive	47
SVA0509	SV_Contract_Revenue_Method2_MSTR_Archive	46
SVA0514	SV_Revenue_Recognition_Summary_Archive	54
SVA0519	Service Time Master Archive	83
SVA0533	SV_Maint_Escalation_MSTR_Archive	94
SVA0534	SV_Maint_Escalation_HIST_Archive	72
SVA0547	SV_Revenue_Recognition_WORK_Archive	20
SVA0550	SV_Maint_Annual_MSTR_Archive	85
SVA0564	SV_Maint_Invoice_MSTR_Archive	96
SVA0568	SV_Maint_Billing_Note_Archive	26
SVA0575	SV_Contract_Contact_MSTR_Archive	60
SVA0587	SV_Contract_Task_Code_Materials_Archive	50
SVA0598	SV_Overdue_PM_MSTR_Archive	133
SVA0701	SV_Invoice_History_Archive	191
SVA00805	SV_Note_MSTR_Archive	62
SVA00815	SV_Job_Costs_HISTORY_Archive	122
SVADOCMS	SV_Document_MSTR_Archive	48