Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SVC scripts. All of our scripts for Dynamics GP can be found here
SVC Scripts
 
No records to display.
Module List > Module COMPANY..SVC 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
 SVC00010SVC_Revision_Level
 SVC00020SVC_Fiscal_Period
 SVC00100Technician Master
 SVC00101Technician Schedule
 SVC00102Technician Skills
 SVC00104Technician Service Area
 SVC00105Tech Misc Skills
 SVC00106SVC_Vendor_Ext
 SVC00110SVC_ExtPricing_PriceLevel
 SVC00120svcPayrollLaborLine
 SVC00200Service Call Master
 SVC00201Service Call Analysis Codes
 SVC00202Service Call Equipment
 SVC00203Service Call Line Detail
 SVC00204Service Master PM
 SVC00205SVC_Service_MSTR_Line_Access
 SVC00207Service Call Tech
 SVC00210Service Master Audit Trail
 SVC00211SVC_Service_Escalation_Audit
 SVC00212SVC_Service_Bin_Work
 SVC00215SVC_Service_Call_Billing_WORK
 SVC00220SVC_Service_Invoice_HIST
 SVC00225Problem_Repair
 SVC00230SVC_Service_MSTR_Distribution
 SVC00231SVC_Service_MSTR_Line_Distribution
 SVC00240Service Call Service Task
 SVC00250Service Serial/Lot Work and History
 SVC00300Serial Master
 SVC00301Serial Meter Readings
 SVC00302Serial Superssion Master
 SVC00303System Configuration
 SVC00305SVC_Serial_MSTR_PM
 SVC00306SVC_Serial_MSTR_ECO
 SVC00307Serial Master Tech
 SVC00310Serial Master Audit
 SVC00315Serial PM Schedule
 SVC00325List Equipment Import Work Table
 SVC00350SVC_PM_Schedule_WORK
 SVC00400Configuration Master
 SVC00401System Configuration
 SVC00501Delta Item Master
 SVC00502Delta Item Site
 SVC00600SVC_Contract_HDR
This table is used to store the contract header information in the Field Service product. This information is designed to control some functions for the entire contract, such as billing and revenue recognition, and default on contract lines as they are added to the contract.
 SVC00601SVC_Contract_Line
 SVC00602SVC_Codes_Contract_Type
 SVC00603SVC_Contract_Line_Invoice_Line
 SVC00604SVC_Contract_Line_Revenue_Line
 SVC00605SVC_Contract_Invoice_HIST
 SVC00606SVC_Contract_Noncovered_Line
 SVC00607SVC_Contract_Line_Meter
 SVC00608SVC_Contract_HDR
 SVC00609SVC_Contract_Line_Distribution
 SVC00610Item Schedule
 SVC00614svc Contract Line Revenue Audit
 SVC00615SVC_Contract_Billing_WORK
 SVC00620SVC_Contract_HDR_Audit
 SVC00625SVC_Contract_Revenue_WORK
 SVC00631SVC_Contract_Line_Invoice_Distribution
 SVC00635svcContractBillingReversalWork
 SVC00640svcContractHdrAccess
 SVC00650SVC_Contract_Price_Book
 SVC00651SVC_Contract_Price_Book_Line
 SVC00652SVC_Contract_Line_Option
 SVC00653SVC_Contract_Option_Types
 SVC00654SVC_Contract_Price_Book_Group
 SVC00655SVC_Contract_Line_Option
 SVC00660SVC_SOP_Contract
 SVC00661SVC_SOP_Contract_Post
 SVC00670SVC_Contract_Move_WORK
 SVC00675svcContractLineMoveWork
 SVC00680svcContractTypeCoveragePeriod
 SVC00681svcContractHdrCoveragePeriod
 SVC00682svcContractSiteCoveragePeriod
 SVC00683svcContractLineCoveragePeriod
 SVC00700Service Transfer Header
 SVC00701Service Transfer Line Detail
 SVC00702Transfer Line Serial Lot
 SVC00710SVC_Inventory_Requirements_Work
 SVC00712SVC_Transfer_Bin_Work
 SVC00720 
 SVC00731SVC_Transfer_Line_Distribution
 SVC00800Keyword Master File
 SVC00801Keywords Detail 0
 SVC00850SVC_ECO_HDR
 SVC00851SVC_ECO_Line
 SVC00900Time Zone Codes
 SVC00901Cause Codes Validation
 SVC00902Office Master
 SVC00903SVC_Office_MSTR_Holidays
 SVC00904Priority Codes Validation
 SVC00905Tech Status Validation Codes
 SVC00906Warranty Validation Codes
 SVC00907Problem Codes Validation
 SVC00908Repair Codes Validation
 SVC00909Service Area Validation Codes
 SVC00910Service Area Zip Validation
 SVC00911Serial Status Validation Codes
 SVC00913Service Call Status Codes
 SVC00914SVC_Additional_Files
 SVC00920Service Type Validation Codes
 SVC00921Service Type Line Validation
 SVC00922Service Type Escalation
 SVC00925Service Type Service Task
 SVC00930SVC_Codes_Work_Type
 SVC00940Service Code Master
 SVC00941Service Task Master
 SVC00942Service Code Default Tasks
 SVC00946 
 SVC00947 
 SVC00950Customer Site Extensions
 SVC00951Item Master Extensions
 SVC00952Item Site Extensions
 SVC00953SVC_Site_Ext
 SVC00955Customer Site Schedule
 SVC00960SVC_Customer_Site_Call
 SVC00970SVC_DL_MSTR
 SVC00980SVC_Misc_Address
 SVC00995Escalation Activity
 SVC00997Service Managemen Security
 SVC00998Master Defaults
 SVC00999Master Numbers
 SVC01000Item Schedule
 SVC01100Split Terms Header
 SVC01101Split Terms Detail
 SVC01400SVC_Call_Dispatch_Setup
 SVC03000SVC_Routing_MSTR
 SVC05000Returns Master
 SVC05001SVC_RMA_MSTR_Line
 SVC05002SVC_Codes_RTV_Status
 SVC05003SVC_Codes_RTV_Type
 SVC05004SVC_Vendor_Item_Reimbursement
 SVC05015SVC_RMA_Receiving_WORK
 SVC05020SVC_RMA_Audit
 SVC05030SVC_RMA_MSTR_Distribution
 SVC05115SVC_RMA_Closing_WORK
 SVC05200Returns Line Master
 SVC05210SVC_RMA_Line_Process
 SVC05212SVC_RMA_Bin_Work
 SVC05250SVC_SOP_Line_Serial_Lot
 SVC05251SVC_RMA_Line_Serial_Lot
 SVC05255SVC_RMA_Serial_Lot_Work
 SVC05256SVC_RMA_Replace_Serial_Lot
 SVC05500RMA Status Codes
 SVC05501Return Type Validation Codes
 SVC05502SVC_RMA_Reason_Code
 SVC05600SVC_RTV_MSTR
 SVC05601SVC_RTV_Line
 SVC05602SVC_RTV_Serial_Lot_Work
 SVC05612SVC_RTV_Bin_Work
 SVC05615SVC_RTV_Shipping_WORK
 SVC05620SVC_RTV_Audit
 SVC05625SVC_RTV_Receiving_WORK
 SVC05630SVC_RTV_MSTR_Distribution
 SVC05635SVC_RTV_Closing_WORK
 SVC06001Depot Station ID Codes
 SVC06002Depot Station Group
 SVC06003Depot Status Validation Codes
 SVC06004Depot Inbound Analysis Codes
 SVC06005Depot Anaylsis Codes Outbound
 SVC06010Depot Route Validation Codes
 SVC06011Depot Route Line Item Detail
 SVC06015Depot Route By Item
 SVC06016Depot Route By Item Lines
 SVC06017Depot Route By Item - Parts
 SVC06020Work Order Type Codes
 SVC06021Depot Type Escalcation
 SVC06100Depot Master
 SVC06101Depot Master Line
 SVC06103Work Order Posting
 SVC06105Depot Master Route
 SVC06110Work Order Audit
 SVC06112SVC_Depot_Bin_Work
 SVC06115SVC_Depot_Completion_WORK
 SVC06120Depot Lot/Serial Information
 SVC06130SVC_Depot_MSTR_Distribution
 SVC06131SVC_Depot_MSTR_Line_Distribution
 SVC06200Service Bill of Material
 SVC06201Service Bill of Material Detail
 SVC06300Depot Schedule
 SVC06301Depot Schedule Status
 SVC07000SVC Solution Master
 SVC07100SVC_Issue_Call_MSTR
 SVC07500SVC_eTech_Technician_Maint
 SVC07510SVC_Expense_Form_HDR
 SVC07511SVC_Expense_Form_Line
 SVC07550SVC_eTech_SETP
 SVC8000SVC Maintenance Detail Header
 SVC8001SVC Maintenance Detail Line
 SVC8005PM Sched Header
 SVC8009PM Schedule Line
Freq
Used
 Display Name
 SVC10300SVC_Meter_Batch_HDR
 SVC10301SVC_Meter_Batch_Line
Work Tables
Freq
Used
 Display Name
 SVC30200Service Call Master History
 SVC30201Service Call Analysis Codes History
 SVC30202Service Call Equipment History
 SVC30203Service Call Line Detail History
 SVC30207Service Call Tech History
 SVC30210Service Master Audit Trail History
 SVC30220SVC_Service_Invoice_HIST_HIST
 SVC30230SVC_Service_MSTR_Distribution_HIST
 SVC30231SVC_Service_MSTR_Line_Distribution_HIST
 SVC30240Service Call Service Task History
 SVC30250Service Serial/Lot Work and History HIST
 SVC30600SVC_Contract_HDR_HIST
 SVC30601SVC_Contract_Line_HIST
 SVC30603SVC_Contract_Line_Invoice_HIST
 SVC30604SVC_Contract_Line_Revenue_HIST
 SVC30605SVC_Contract_Invoice_HIST_HIST
 SVC30606SVC_Contract_Noncovered_Line_HIST
 SVC30607SVC_Contract_Line_Meter_HIST
 SVC30608SVC_Contract_Site_HDR_HIST
 SVC30609SVC_Contract_Line_Distribution_HIST
 SVC30610Item Schedule History
 SVC30620SVC_Contract_HDR_Audit_HIST
 SVC30652SVC_Contract_Line_Option_HIST
 SVC30655SVC_Contract_Site_Option_HIST
 SVC30681svcContractHdrCoveragePeriodHIST
 SVC30682svcContractSiteCoveragePeriodHIST
 SVC30683svcContractLineCoveragePeriodHIST
 SVC30700Service Transfer Header History
 SVC30701Service Transfer Line Detail History
 SVC30702Transfer Line Serial Lot History
 SVC30731SVC_Transfer_Line_Distribution_HIST
 SVC35000SVC_RMA_MSTR_HIST
 SVC35001SVC_RMA_MSTR_Line_HIST
 SVC35020SVC_RMA_Audit_HIST
 SVC35030SVC_RMA_MSTR_Distribution_HIST
 SVC35200SVC_RMA_Line_HIST
 SVC35210SVC_RMA_Line_Process_HIST
 SVC35255SVC_RMA_Serial_Lot_Work_HIST
 SVC35256SVC_RMA_Replace_Serial_Lot_HIST
 SVC35600SVC_RTV_MSTR_HIST
 SVC35601SVC_RTV_Line_HIST
 SVC35602SVC_RTV_Serial_Lot_Work_HIST
 SVC35620SVC_RTV_Audit_HIST
 SVC35630SVC_RTV_MSTR_Distribution_HIST
Freq
Used
 Display Name
 SVC40500Business Alerts Rules Master
 SVC70500Service Report Options
 SVC80010SVC_PM_WORK_HDR
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