Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SV scripts. All of our scripts for Dynamics GP can be found here
SV Scripts
 
No records to display.
Module List > Module COMPANY..SV tables
DynDeveloper Table Reference is in Wiki format! Registered users have the ability to improve the table reference, add comments, and generally make the world a better place.
You are currently viewing the COMPANY database.
Change


ClearPixel
Freq
Used
 Display Name
 SV_00415SV_Install_MSTR
 sv000020SV_Affiliate_MSTR
 SV000031SV_Invoice_Comment_MSTR
 SV000062SV_Number_MSTR
 SV00010 
 SV00012SV_System_Option_MSTR
 SV000122SV_Billing_Rate_MSTR
 SV000123SV_Labor_Rate_Group_MSTR
 sv00015SV_Branch_MSTR
 SV000182SV_Equipment_Replacement_Parts_MSTR
 SV000183SV_Equipment_Type_Replacement_Parts_
 sv00021SV_Region_MSTR
 SV00030SV_SA_Password_Setup_MSTR
 SV00032SV_SA_Password_User_MSTR
 SV00033SV_Security_Level_MSTR
 sv00034SV_System_Administration_MSTR
 SV00040SV_Postal_Code_MSTR
 SV00045SV_Time_Zone_MSTR
 SV00053SV_Contract_Quicksearch
 SV00054SV_Customer_Quicksearch
 SV00055SV_Equipment_Quicksearch
 SV00077SV_Division_MSTR
 SV000785SV_Other_Costs_Maintenance_Accounts
 SV000786SV_Other_Costs_Accounts
 SV000787SV_Invoice_Setup_MSTR
 SV000788SV_Invoice_Setup2_MSTR
 SV000789SV_Invoice_Tax_Option_MSTR
 SV000790SV_Invoice_Tax_Option_Other_MSTR
 SV000791SV_Maint_Tax_Option_MSTR
 SV000792SV_Maint_Tax_Option_Other_MSTR
 SV000805SV_Note_MSTR
 SV000810SV_Job_Costs_WORK
 SV000811SV_Job_Costs_WORK_Report
 SV000815SV_Job_Costs_HISTORY
 SV000816SV_Invoice_Trailing_Costs
 SV000817SV_Invoice_Trailing_PPV_Costs
 SV000820 
 SV00099SV_Conversion_MSTR
 SV00100SV_Customer_MSTR
 SV00101SV_RM_Class_MSTR
 SV00105SV_Customer_Define1a_MSTR
 SV00110SV_Customer_Define2a_MSTR
 SV00114SV_Technician_Branch_MSTR
 SV00115SV_Lookup_Tech_MSTR
 SV00116SV_Technician_Team_MSTR
 SV00117SV_Invoice_Number_MSTR
 SV00118SV_Technician_Shift_SETP
 SV00119SV_InternalCustomer
 SV00120SV_Lookup_Billing_Rate_MSTR
 SV00130SV_Salesperson_MSTR
 SV00131SV_Salesperson_Mass_Reassign_Source
 SV00132SV_Salesperson_Mass_Reassign_Dest
 SV00142SV_Quote_Pricing_MSTR
 SV00143SV_Pricing_Matrix_MSTR
 SV00144SV_Inventory_Markdown_MSTR
 SV00145SV_Other_Costs_MSTR
 SV00148SV_GDB_SETP
 SV00149SV_GDB_Fields
 sv00150SV_Technician_Labor_Plan_MSTR
 SV00155SV_Technician_Skill_Set_MSTR
 SV00160SV_Customer_Contact_MSTR
 SV00165SV_Extended_Pricing_Matrix_HDR
 SV00166SV_Extended_Pricing_Matrix_LINE
 SV00167SV_Extended_Pricing_Matrix_SETP
 sv00196SV_Setup2_MSTR
 SV00197SV_Setup_Custom_Options
 SV00198SV_Setup_Custom_Options_Labels
 SV00199SV_Auto_Number_MSTR
 SV00200SV_Location_MSTR
 SV00201SV_SubLocation_MSTR
 SV00205SV_Location_Contact_MSTR
 SV00215SV_Location_Technicians_MSTR
 SV00220SV_Service_Area_MSTR
 SV00221SV_Service_Area_Technicians_MSTR
 SV00225SV_Location_Define1a_MSTR
 SV00230SV_Location_Define2a_MSTR
 SV00300SV_Service_MSTR
 SV00301SV_Service_Appointments_MSTR
 SV00302SV_Service_Tasks_MSTR
 SV00303SV_Service_Response_Numeric_MSTR
 SV00304SV_Service_Response_String_MSTR
 SV00305SV_Tool_Unit_MSTR
 SV00306SV_Service_Request_SETP
 SV00307SV_Service_Request_Lookup_Type_MSTR
 SV00308SV_Service_Request_Lookup_MSTR
 SV00309SV_Service_Request_MSTR
 SV00310SV_Type_Problem_MSTR
 SV00311SV_Service_Task_Code_Materials
 SV00312SV_Service_Activity_MSTR
 sv00314SV_Time_Ticket_Activity_MSTR
 SV00315SV_Type_Equipment_MSTR1
 SV00320SV_Type_Call_MSTR
 SV00324SV_Task_Status_SETP
 SV00325SV_Type_Status_MSTR
 sv00326SV_Technician_Status_MSTR
 SV00330SV_Service_Define1a_MSTR
 SV00331SV_Service_Define2a_MSTR
 SV00340SV_Service_ID_Log_MSTR
 sv00351SV_Service_Technician_WORK
 SV00360SV_Task_Define5_MSTR
 SV00361SV_Task_Define6_MSTR
 SV00362SV_Task_Define7_MSTR
 SV00370SV_Task_Define_5_6_Combination
 sv00387SV_Service_Assigned_Equipment_MSTR
 sv00392SV_Trouble_Codes_MSTR
 sv00393SV_Resolution_Codes_MSTR
 SV00394SV_Service_Resolution_MSTR
 SV00400SV_Equipment_MSTR
 SV00401SV_Equipment_MSTR_TEMP
 SV00402SV_Quote_Equipment_MSTR
 SV00403SV_Equipment_Contract_Coverage_MSTR
 SV00405SV_Equipment_Type_MSTR
 SV00406SV_IV_Item_MSTR
 SV00410SV_Manufacturer_MSTR
 SV00411SV_Model_Number_MSTR
 SV00420SV_Warranty_MSTR
 SV00425SV_Equipment_Type_MSTR_TRX
 sv00430SV_Equipment_Meter_MSTR
 SV00460SV_Plant_MSTR
 SV00470SV_Plant_Type_MSTR
 SV00480SV_Report_Button_Names_MSTR
 SV00490SV_PO_Integration
 SV00500SV_Maint_MSTR
 SV00501SV_Maint_HIST
 SV00502SV_Quote_MSTR
 SV00503SV_Maint_Cost_Estimates
 SV00504SV_Maint_Cost_Estimates_History
 sv00505SV_Contract_Detail_Summary
 SV00506SV_Maintenance_Number_MSTR
 sv00507SV_Contract_Billing_HIST
 SV00508SV_Contract_Revenue_Method2_HIST
 SV00509SV_Contract_Revenue_Method2_MSTR
 sv00510SV_Contract_Billing_MSTR
 sv00511SV_Maintenance_Setup_MSTR
 sv00512SV_Maintenance_Setup1_MSTR
 SV00514SV_Revenue_Recognition_Summary
 SV00515SV_Maint_Contract_Type_MSTR
 SV00517SV_Service_Level_MSTR
 SV00519SV_Service_Time_MSTR
 SV00520SV_Major_MSTR
 SV00521SV_Sub1_MSTR
 SV00522SV_Sub2_MSTR
 SV00523SV_Sub3_MSTR
 SV00524SV_Sub4_MSTR
 SV00525SV_System_MSTR
 SV00526SV_Escalation_Index_MSTR
 SV00527SV_Escalation_Index_Detail
 sv00528SV_Maint_Escalation_Index_MSTR
 SV00529SV_Equipment_Type_Task_Codes_MSTR
 sv00531SV_Contract_Task_Comment
 sv00532SV_Maint_Period_MSTR
 sv00533SV_Maint_Escalation_MSTR
 sv00534SV_Maint_Escalation_HIST
 sv00535SV_Maint_Escalation_Builds_MSTR
 sv00536SV_Contract_Task_Response_MSTR
 sv00537SV_Maint_Service_HDR
 SV00538SV_Equipment_Type_Task_Codes_MSTR_TR
 SV00540SV_Standard_Frequency_MSTR
 SV00541SV_Standard_Frequency_Schedule_MSTR
 SV00544SV_Quote_Task_List_MSTR
 SV00545SV_Quote_Task_MSTR
 SV00546SV_Quote_Task_Subtasks_MSTR
 SV00547SV_Revenue_Recognition_WORK
 SV00548SV_Quote_Task_Schedule
 SV00549SV_Quote_Task_Code_Materials
 SV00550SV_Maint_Annual_MSTR
 SV00551SV_Maint_Annual_Rate_MSTR
 SV00552SV_Maint_Annual_Task_Desc
 SV00555SV_Contract_Define1a_MSTR
 SV00556SV_Contract_Define2a_MSTR
 SV00559SV_Task_Code_Materials
 SV00560SV_Task_Codes_MSTR
 SV00561SV_Task_Codes_MSTR_TRX
 SV00562SV_Task_Codes_Description_MSTR
 SV00563SV_Task_Codes_Description_MSTR_TRX
 SV00564SV_Maint_Invoice_MSTR
 SV00565SV_Sub_Tasks_MSTR
 SV00566SV_Sub_Task_Define1a_MSTR
 SV00567SV_Maint_Billing_Note_MSTR
 SV00568SV_Maint_Billing_Note
 SV00569SV_Task_Response_DDL_SETP
 SV00570SV_Toolkit_MSTR
 SV00572SV_Skill_Level_MSTR
 SV00573SV_Material_Kit_MSTR
 SV00575SV_Contract_Contact_MSTR
 SV00580SV_Task_Group_MSTR
 SV00581SV_Contract_Task_List_MSTR
 SV00582SV_Contract_Task_MSTR
 SV00583SV_Contract_Task_Sub_Task_MSTR
 SV00584SV_Task_List_Type_MSTR
 SV00585SV_Contract_Task_Schedule
 SV00586SV_Contract_Task_Code_Materials
 SV00587SV_Contract_Task_Code_Materials_Hist
 SV00591SV_Task_List_MSTR
 SV00592SV_Task_List_Tasks_MSTR
 SV00593SV_Task_List_Sub_Task_MSTR
 SV00602SV_Cost_Codes_MSTR
 SV00640SV_Master_Contract_Financial_MSTR
 SV00650SV_Master_Contract_MSTR
 SV00651SV_Master_Contract_User_Defined1_MST
 SV00652SV_Master_Contract_User_Defined2_MST
 SV00654SV_Master_Contract_Escalation_MSTR
 SV00660SV_Customer_Contract_Detail
 SV00700SV_Invoice_MSTR
 SV00701SV_Invoice_History
 SV00702SV_Invoice_MSTR_Report
 SV00735SV_Cost_Element_MSTR
 SV00736SV_Cost_Element_MC_MSTR
 SV00800SV_Labor_Loading_Monthly_TEMP_SQL
 SV00801SV_Labor_Load_Annual_Schedule
 SV008115SV_Work_Order_Name_MSTR
 SV00900SV_User_Defined_MSTR
 SV00905SV_User_Defined2_MSTR
 SV00906SV_Active_User_Defined_MSTR
 SV00910SV_User_Preference_MSTR
 SV00AD1SV_Service_Request_Actual_Department
 sv010000SV_File_Maint_Error_Log
 SV01100SV_Contact_MSTR
 SV01105SV_Contact_ID_MSTR
 SV01110SV_Contact_Define1_MSTR
 SV01115SV_Technician_Inventory_Sites
 SV01120SV_Contact_Define2_MSTR
 SV01130SV_Contact_Define3_MSTR
 SV01140SV_Contact_Define4_MSTR
 SV01150SV_Contact_Phone_MSTR
 SV01160SV_Phone_Type_MSTR
 SV01170SV_Contact_Role_Type_MSTR
 SV02000 
 SV02001SV_RDC_Audit_Trail
 SV02002 
 SV02003 
 SV02004 
 SV02005 
 SV02010 
 SV02020 
 SV02030 
 SV02100 
 SV02196 
 SV02200 
 SV02312 
 SV02400 
 SV02500 
 SV02582 
 SV02810 
 SV02900 
 SV585CLPSV_Contract_Tasks_TEMP
 SVA0053SV_Contract_Quicksearch_Archive
 SVA0054SV_Customer_Quicksearch_Archive
 SVA0055SV_Equipment_Quicksearch_Archive
 SVA00805SV_Note_MSTR_Archive
 SVA00815SV_Job_Costs_HISTORY_Archive
 SVA0100SV_Customer_MSTR_Archive
 SVA0115SV_Lookup_Tech_MSTR_Archive
 SVA0118SV_Technician_Shift_SETP_Archive
 SVA0150SV_Technician_Labor_Plan_MSTR_Archiv
 SVA0155SV_Technician_Skill_Set_MSTR_Archive
 SVA0160SV_Customer_Contact_MSTR_Archive
 SVA0200SV_Location_MSTR_Archive
 SVA0205SV_Location_Contact_MSTR_Archive
 SVA0215SV_Location_Technicians_MSTR_Archive
 SVA0300SV_Service_MSTR_Archive
 SVA0301SV_Service_Appointments_MSTR_Archive
 SVA0302SV_Service_Tasks_MSTR_Archive
 SVA0309SV_Service_Request_MSTR_Archive
 SVA0311SV_Service_Task_Code_Materials_Archi
 SVA0340SV_Service_ID_Log_MSTR_Archive
 SVA0400SV_Equipment_MSTR_Archive
 SVA0430SV_Equipment_Meter_MSTR_Archive
 SVA0460SV_Plant_MSTR_Archive
 SVA0500SV_Maint_MSTR_Archive
 SVA0501SV_Maint_HIST_Archive
 SVA0503SV_Maint_Cost_Estimates_Archive
 SVA0505SV_Contract_Detail_Summary_Archive
 SVA0507SV_Contract_Billing_HIST_Archive
 SVA0508SV_Contract_Revenue_Method2_HIST_Arc
 SVA0509SV_Contract_Revenue_Method2_MSTR_Arc
 SVA0514SV_Revenue_Recognition_Summary_Archi
 SVA0519SV_Service_Time_MSTR_Archive
 SVA0533SV_Maint_Escalation_MSTR_Archive
 SVA0534SV_Maint_Escalation_HIST_Archive
 SVA0547SV_Revenue_Recognition_WORK_Archive
 SVA0550SV_Maint_Annual_MSTR_Archive
 SVA0564SV_Maint_Invoice_MSTR_Archive
 SVA0568SV_Maint_Billing_Note_Archive
 SVA0575SV_Contract_Contact_MSTR_Archive
 SVA0587SV_Contract_Task_Code_Materials_Arch
 SVA0598SV_Overdue_PM_MSTR_Archive
 SVA0701SV_Invoice_History_Archive
Work Tables
Freq
Used
 Display Name
 SV30301SV_Appointment_History_MSTR
 SV30302SV_Service_Call_Task_Lists_TEMP
 SV333333SV_Broadcast_Warehouse_MSTR
Freq
Used
 Display Name
 SV_SVC_RSV_Service_Request_MSTR_RPT
 SV40100SV_Monitor_SETP
 SV40200SV_Shift_SETP
 SV40201SV_Shift_Daily_SETP
 SV40401SV_Time_Refresh_SETP
 SV70001SV_SQL_Dispatch_Join
 SV90000 
 SV90003 
 SV99999SV_SQL_Filtering
 SVADOCMSSV_Document_MSTR_Archive
 SVAUTONMSV_Auto_Numbers_Used
 SVDOCMSTSV_Document_MSTR
 SVDOCPARSV_Document_Parms
 SVDOCVUESV_Document_Viewers
 SVERRORSSV_Error_Messages_MSTR
 SVFAILED 
 SVinb 
 SVINBND 
 SVINTER1ServiceCallWarehouse
 SVINTER2ServiceCallOptions
 SVINTER3ServiceEquipWarehouse
 SVINTER4ServiceTechWarehouse
 SVINTER5ServiceMaintWarehouse
 SVINTER6ServiceMeterWarehouse
 SVINTER7ServiceJCHWarehouse
 SVINTER8ServiceNoteWarehouse
 SVmail 
 SVMAINTESV_Maint_Escalation_TEMP
 SVMAPTEC 
 SVMTOPT 
 SVout 
 SVOUTBND 
 SVPGMESGSV_Pager_Message_Setup_MSTR
 SVPGSETPSV_Pager_Setup_MSTR
 SVPGVNDRSV_Pager_Vendor_MSTR
 SVRDCOPT 
 SVRDCTRX 
 SVreg 
 SVRGSTRY 
 SVRMA101 
 SVRMA102 
 SVRMA300 
 SVRMA301RM_Distribution_History_Archive
 SVRMA302 
 SVRMA305RM_Commission_History_Archive
 SVRMA306 
 SVRSPMSTSV_Response_Type_MSTR
 SVseqi 
 SVseqo 
 SVTCHPTH 
 SVtempInb 
 SVTRXACT 
 SVTRXGRP 
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