Click to enlarge

Overview

This page provides you with information about the ConnectWise® Manage™ Database Reporting Views that are prefixed with v_rpt in the database and are available through the Reporting API.

Database Reporting Views are available from within Manage in the System > All Reports > Database Reporting Views Report.

Tip: Use the v_rpt views whenever possible. The column names of these views will not change from release to release. As the application is enhanced, it is possible that table names and fields will change.

To locate this screen, navigate to System > All Reports.

ConnectWise Reporting Views Report

You can get a list of the latest reporting views from within Manage.

1. Navigate to System > All Reports.

2. Select the System module and click on Database Reporting Views.

   1. Render and print the report in the format of your choice (PDF, Excel, XML, or CSV).

Database Views and Details

When you pull the Database Reporting Views report and should you require a little more information, review the following table which displays each view and the cross-reference to the screen where that data is

displayed. Anything in the ConnectWise Database that is not v_rpt_ is subject to be changed or removed at anytime.

<table data-table-width="760" data-layout="default" ac:local-id="2d856250-8550-49d3-8eb8-0bb74a216ecf"><colgroup><col style="width: 340.0px;"><col style="width: 340.0px;"></colgroup><tbody><tr><td data-highlight-colour="#333333"><p><strong><span style="color: rgb(0,0,0);">View Name</span></strong></p></td><td data-highlight-colour="#333333"><p><strong><span style="color: rgb(0,0,0);">Corresponding Screen where the Data is Displayed</span></strong></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_Activity</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: My Favorites – Screen: My Activities – Tab: Activity</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_ActivityCustomFields</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Custom Fields - Screen: Activity- Pod: Activity Overview &amp; Schedule</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_ActivityStatus</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Activity Status</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_ActivityType</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Activity Type</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_AgreementAdditions</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Contacts – Screen: Agreements – Tab: Additions</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_AgreementAppCycle</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Finance - Screen: Agreements - Tab: Agreement</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_AgreementAudit</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Finance - Screen: Agreements - Tab: Audit Trail</span></p></td></tr></tbody></table> <table data-table-width="760" data-layout="default" ac:local-id="2d6d9bcd-6311-457b-a2c9-11b135d57dd2"><colgroup><col style="width: 340.0px;"><col style="width: 340.0px;"></colgroup><tbody><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_AgreementInvoice</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Finance - Screen: Agreements - Tab: Invoice</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_AgreementList</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Contacts – Screen: Agreements</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_AgrSite</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Contacts – Screen: Agreements – Tab: Sites</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_AgrType</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Agreement Type</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_AgrUnits</span></p></td><td><p><span style="color: rgb(0,0,0);">Agreement Applications: Amount, Hours, Incidents (no setup table)</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_Batch</span></p></td><td><p><span style="color: rgb(0,0,0);">GL Batch (no setup table)</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_BillingOptions</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Work Types</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_BillingCycle</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Billing Cycle</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_BillingDelivery</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Delivery Method List</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_BillingSetup</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Billing Setup</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_BillingStatus</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Billing Status</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_BillingTerms</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Billing Terms</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_BillingUnit</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Setup – Screen: My Company – Tab: Groups</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_BillingUnitLocation</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Setup – Screen: My Company – Tab: Groups Pod: Location</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_BillRateType</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Work Types - Rate Type</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_Calendar</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Calendar</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_CalendarSetup</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Calendar Setup</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_CampaignStatus</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Campaign Status</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_CampaignSubType</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Campaign SubType</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_CampaignTracking</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Marketing - Screen: Marketing Campaign</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_CampaignType</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Campaign Type</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_ChargeCode</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Charge Codes</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_CommunicationType</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Communication Types</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_Company</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Contacts - Screen: Company</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_CompanyAddress</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Contacts - Screen: Company - Tab: Sites</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_CompanyContactCommunication</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Companies - Screen: Company - Tab: Contacts</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_CompanyCustomFields</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Custom Fields - Screen: Company - Pod: Company Details</span></p><p><span style="color: rgb(0,0,0);">&amp; Company Overview</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_CompanyEntityType</span></p></td><td><p><span style="color: rgb(0,0,0);">Company Entity: Federal Government, State Government, ...(no setup table)</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_CompanyGroup</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Contacts - Screen: Company - Tab: Groups</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_CompanyMarkets</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Market Description</span></p></td></tr></tbody></table> <table data-table-width="760" data-layout="default" ac:local-id="7cca584d-1872-4dfe-8e05-110a216b04c5"><colgroup><col style="width: 340.0px;"><col style="width: 340.0px;"></colgroup><tbody><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_CompanyMgmt</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Contacts - Screen: Company - Tab: Management</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_CompanyProfileUserfields</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Companies - Screen: Company - Tab: Profile</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_CompanyStateTaxRate</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Finance - Screen: Company Finance - Tab: Summary</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_CompanyStatus</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Company Status</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_CompanyTeam</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Companies - Screen: Company - Tab: Team</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_CompanyType</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Company Type</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_CompanyWorkRoles</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Companies - Screen: Company - Tab: Work Role</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_CompanyWorkTypes</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Companies - Screen: Company - Tab: Work Type</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_ConfigCustomFields</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Custom Fields - Screen: Configurations - Pod: Configuration Details &amp; Company</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_Configs</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Contacts – Screen: Configuration Search</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_ConfigStatuses</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Configuration Status</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_ConfigTypes</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Configuration Types</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_Configuration</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Contacts – Configuration Search</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_ConfigurationAgreement</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Contacts – Screen: Agreements – Tab: Configurations</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_ConfigurationType</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Configuration Type</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_ConfigurationTypeQuestion</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Configuration Type - Screen: Configuration</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_ConnectWiseHostedApiScreen</span></p></td><td><p><span style="color: rgb(0,0,0);">Client Api ID: AgreementDetail, CompanyDetail and etc (no setup table)</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_Contact</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Contacts - Screen: Contacts (fully expanded)</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_ContactCommunication</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Contact Communication</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_ContactCustomFields</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Custom Fields - Screen: Contact- Pod: Contact Details &amp; Contact Overview</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_ContactGroup</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Contacts – Screen: Company – Tab: Groups</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_ContactName</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Contacts – Screen: Contacts (just the name)</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rptContactPresence</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Service Desk – Screen: Service Ticket - Pod: Chat Assist</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_ContactRelationship</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Contacts – Screen: Contact - Pod: Contact Details</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_Contacts</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Contacts – Screen: Contact Search</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_ContactType</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Contacts – Screen: Contact - Pod: Contact Details</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_ConversionHistory</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Sales - Screen: Sales Order &amp; Opportunity (Conversion to Service Ticket, Project or Agreement)</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_Countries</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Country</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_Currency</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Currency</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_CustomCaption</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: System– Screen: My Company</span></p></td></tr></tbody></table> <table data-table-width="760" data-layout="default" ac:local-id="08a0513e-5453-4753-8806-c02d07dc5f85"><colgroup><col style="width: 340.0px;"><col style="width: 340.0px;"></colgroup><tbody><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_CustomFields</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Custom Fields</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_CustomFieldsOption</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Custom Fields - Screen: (where a field is a List or Option)</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_Department</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Department</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_Document</span></p></td><td><p><span style="color: rgb(0,0,0);">All documents used in the application (no setup table)</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_Expense</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Time &amp; Expense – Screen: My Expense Reports</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_ExpenseClassification</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Time &amp; Expense – Screen: My Expense - Pod: Expense Entry</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_ExpenseCustomFields</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Custom Fields - Screen: Contact- Pod: Expense Entry &amp; Overview</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_ExpensePaymentMethod</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Payment Type</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_ExpenseReports</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Time &amp; Expense – Screen: My Expense Reports Date Range</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_ExpenseType</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Expense Type</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_GroupType</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Groups</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_Holiday</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Holiday List: Screen: Holiday</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_InventoryItem</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Procurement– Screen: Product Catalog</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_InvoiceAgreementAdditions</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Finance – Screen: Agreements</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_InvoiceCustomFields</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Custom Fields - Screen: Invoice - Pod: Billing, Shipping, Overview, Calculations, Credits and Payments and Notes.</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_InvoiceEmailTemplate</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Email Formats - Invoicing</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_InvoiceExpense</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Finance – Screen: Invoice Search (Invoices with Expenses)</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_InvoiceHeader</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Finance – Screen: Invoice Search (All Invoices)</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_InvoicePayments</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Finance – Screen: Invoice Search (Invoices Marked as Paid)</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_InvoiceProduct</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Finance – Screen: Invoice Search (Invoices With Products)</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_Invoices</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Finance- Screen: Invoice Search</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_InvoiceTemplate</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Invoice Templates</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_InvoiceTime</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Finance – Screen: Invoice Search (Invoices With Time)</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_InvoiceTypes</span></p></td><td><p><span style="color: rgb(0,0,0);">Invoice types: Standard, Credit Memo, etc. (no setup table)</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_IVCategory</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Product Category</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_IVClass</span></p></td><td><p><span style="color: rgb(0,0,0);">Inventory Classes: Service, Non-Inventory, etc. (no setup table)</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_IVProductBundle</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Setup – Screen: Products (Product Bundles)</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_IVSubCategory</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Product Sub-category</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_IVType</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Product Type</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_IVUom</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Product Unit of Measure (UOM)</span></p></td></tr></tbody></table> <table data-table-width="760" data-layout="default" ac:local-id="21d81d46-2ccb-4c74-90ce-8c420af9a991"><colgroup><col style="width: 340.0px;"><col style="width: 340.0px;"></colgroup><tbody><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_KbResolutionAuditTrail</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Service Desk – Screen: Knowledge Base</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_KnowledgebaseCategory</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table:Knowledge Base Tab: Categories</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_KnowledgebaseSubCategory</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table:Knowledge Base Tab: Subcategories</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_Link</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Companies – Screen: Company &amp; Screen: Contact (Links Dropdown)</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_LinkTokens</span></p></td><td><p><span style="color: rgb(0,0,0);">All the links in the application(Company link, Contact First Name link and ect)</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_Locale</span></p></td><td><p><span style="color: rgb(0,0,0);">List of locales supported by the application (no setup table)</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_LocationBusGroup</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Setup – Screen: My Company – Tab: Groups</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_LocationBusGroup</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Setup – Screen: My Company – Tab: Groups</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_Managed_Device_XRef</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Managed Devices Integration</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_Manufacturer</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Manufacturer</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_Market</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Market Description</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_MarketingCampaign</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Marketing – Screen: Marketing Campaign</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_MarketingROI</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Marketing – Screen: Marketing Campaign</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_MeetingAudit</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Service Desk – Screen: Service Ticket - Pod: Meeting</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_Member</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Setup – Screen: Members</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_MemberCertifications</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Setup – Screen: Members – Tab: Certifications</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_MemberSecurityRoles</span></p></td><td><p><span style="color: rgb(0,0,0);">All members security role information for each screen.</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_MemberSkills</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Setup – Screen: Members – Tab: Skills</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_MyAccountCustomFields</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Setup – Screen: My Account – Pod: Customizations</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_MyCompany</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: System – Screen: My Company</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_NoteType</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Note Type</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_NotifyWho</span></p></td><td><p><span style="color: rgb(0,0,0);">Roles that will be notified by events in the application(no setup table)</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_Opportunity</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Sales – Screen: My Opportunities</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_Opportunity_Restricted</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Sales – Screen: My Opportunities</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_OpportunityCustomFields</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Custom Fields – Screen: My Opportunities</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_OpportunityInterest</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Opportunity Rating</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_OpportunityNote</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: My Opportunities - Screen: Opportunity - Tab: Notes</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_OpportunityPipeline</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Sales Stage</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_OpportunityProbability</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Sales Probability</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_OpportunitySalesRole</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Sales Roles</span></p><p></p><p></p><p></p><p></p></td></tr></tbody></table> <table data-table-width="760" data-layout="default" ac:local-id="9531a169-150c-4f66-98c4-2bebfb9ad527"><colgroup><col style="width: 340.0px;"><col style="width: 340.0px;"></colgroup><tbody><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_OpportunityStatus</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Opportunity Status</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_OpportunityType</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Opportunity Type</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_OpportunityUrgency</span></p></td><td><p><span style="color: rgb(0,0,0);">Flags used on an Opportunity (no setup table)</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_OwnerLevel</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Setup – Screen: My Company – Tab: Structure</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_OwnershipType</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Ownership Type</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_PhaseStatus</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Phase Status</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_Pod</span></p></td><td><p><span style="color: rgb(0,0,0);">Lists all pods in the application (no setup table)</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_PortalAgrType</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Portal Configuration - Tab: Agreement Types</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_PortalConfigNames</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Portal Configuration</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_PortalConfigServiceBoards</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Portal Configuration - Tab: Boards</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_PortalInvoices</span></p></td><td><p><span style="color: rgb(0,0,0);">Invoice List for Customer Portal</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_PortalProject</span></p></td><td><p><span style="color: rgb(0,0,0);">Project List for Customer Portal</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_PortalSecurity</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Portal Security</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_PortalSecurityCaptions</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Portal Security</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_PortalService</span></p></td><td><p><span style="color: rgb(0,0,0);">Service Ticket List for Customer Portal</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_PortalService</span></p></td><td><p><span style="color: rgb(0,0,0);">Service Ticket List for Customer Portal</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_PortalTicketTypeDescription</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Portal Configuration - Tab: Types</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_PortalTicketTypes</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Customer Portal Types</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_PriceHeader</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Pricing Schedule</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_PricingSchedule</span></p></td><td><p><span style="color: rgb(0,0,0);">Companies that have a pricing schedule attached to it (no setup table)</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_Product</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Setup – Screen: Products</span></p><p><strong><span style="color: rgb(0,0,0);">Note: </span></strong><span style="color: rgb(0,0,0);">Products associated with opportunities, agreements, projects, and service tickets can be reported on.</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_ProductDetail</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Procurement – Screen: Product Catalog - Tab: References</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_ProductEntityType</span></p></td><td><p><span style="color: rgb(0,0,0);">Product Entity: Federal Government, State Government, ...(no setup table)</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_Project</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Project – Screen: My Projects</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_ProjectAudit</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Project – Screen: My Project - Tab: Audit Trail</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_ProjectBillingMethods</span></p></td><td><p><span style="color: rgb(0,0,0);">Fixed Fee, Actual, Not to Exceed, Override Rate (no setup table)</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_ProjectBoard</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Project Boards</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_ProjectContact</span></p></td><td><p><span style="color: rgb(0,0,0);">Contacts associated with projects.</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_ProjectCustomFields</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Custom Fields – Screen: Project - Pod: Project #, Contact</span></p></td></tr></tbody></table> <table data-table-width="760" data-layout="default" ac:local-id="7ab29c1d-67c7-4236-a350-9fb093f1fc29"><colgroup><col style="width: 340.0px;"><col style="width: 340.0px;"></colgroup><tbody><tr><td><p></p></td><td><p><span style="color: rgb(0,0,0);">Overview, Finance Information and etc.</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_ProjectHeader</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Project – Screen: My Projects</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_ProjectNote</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Project – Screen: My Projects - Pod: Notes</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_ProjectRole</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Role</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_ProjectStatus</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Project Status</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_ProjectStatuses</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Project Status</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_ProjectTeamMember</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Project – Screen: My Projects - Tab: Team</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_ProjectTemplate</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Project – Screen: My Projects - Tab: Project More Dropdown</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_ProjectTypes</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Project Type</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_PurchaseOrder</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Procurement – Screen: Purchase Orders</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_PurchaseOrderStatuses</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Purchase Order Status</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_PurchaseOrderWithLineItems</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Procurement – Screen: Purchase Orders – Tab: Products</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_ReminderMinutes</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Reminder Time</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_RMATag</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Procurement – Screen: RMA Processing</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_Sales_Team</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Sales Team</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_SalesOrder</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Procurement – Screen: Sales Order</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_SalesOrderCustomFields</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Custom Fields – Screen: Sales Order- Pod: Overview, Company, Shipping Information</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_SalesOrderStatus</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Sales Order Status</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_Schedule</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Service Desk – Screen: Dispatch Portal</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_ScheduleLocation</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Location</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_ScheduleSpan</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: System – Screen: My Company - Pod: Service and Scheduling Setup Options</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_ScheduleStatus</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Schedule Status</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_ScheduleType</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Schedule Type</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_Service</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Service Desk – Screen: Ticket Search</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_Service_Open</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Service Desk – Screen: Ticket Search (All open status tickets)</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_Service_SLA</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Service Desk – Screen: Ticket Search (All tickets with an SLA)</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_Service_Source</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Source</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_Service_Summary</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Service Desk – Screen: Ticket Search</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_Service_Summary_Open</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Service Desk – Screen: Ticket Search (Summaries of open tickets)</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_ServiceAudit</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Service Desk – Screen: Ticket - Tab: Audit Trail</span></p></td></tr></tbody></table> <table data-table-width="760" data-layout="default" ac:local-id="7e7ab972-9156-4abc-a6a4-59d01e264bbf"><colgroup><col style="width: 340.0px;"><col style="width: 340.0px;"></colgroup><tbody><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_ServiceBoard</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Service Boards</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_SeviceBoardMembers</span></p></td><td><p><span style="color: rgb(0,0,0);">Members apart of the service boards (no setup table)</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_ServiceCode</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Service Boards</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_ServiceCustomFields</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Custom Fields – Screen: Service - Pod: Company, Ticket, Additional Details and etc.</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_ServiceItem</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Service Boards – Tab: Items</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_ServiceLocation</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Location</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_ServiceMetricsAging</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Service Desk – Screen: Ticket Search (Counts Service Tickets with a set age.)</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_ServiceMetricsCounts</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Service Desk – Screen: Ticket Search (Counts Service Ticket's number of configurations and resources.)</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_ServiceNote</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Service Desk – Screen: Ticket - Pod: Notes (Discussion, Internal and Resolution)</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_ServicePriority</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Priority</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_ServiceSignoff</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Service Sign Off</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_ServiceStatus</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Service Boards – Tab: Status</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_ServiceSubType</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Service Boards – Tab: Sub Types</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_ServiceSubTypeItemTemplate</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Service Boards – Tab: Auto Templates</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_ServiceSubTypeItemTemplateOption</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Service Boards – Tab: Auto Templates</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_ServiceTask</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Service Desk – Screen: Ticket Search (Tickets with tasks)</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_ServiceTeam</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Service Boards – Tab: Teams</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_ServiceTemplate</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Ticket Template</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_ServiceTemplateTask</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Ticket Template - Tab: Tasks</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_ServiceType</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Service Boards – Tab: Types</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_ShipmentMethod</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Shipment Methods</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_SICCode</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Companies - Screen: Companies: Tab: Profile</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_SLA</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: SLA List</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_SLAPriority</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: SLA - Screen: SLA - Tab: SLA by Priority</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_States</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: States</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_Surveys</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Contacts – Screen: Company – Tab: Surveys</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_SurveysByTicket</span></p></td><td><p><span style="color: rgb(0,0,0);">Tickets that have a completed survey (no setup table)</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_TaxCode</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Tax Codes</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_TeamRole</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Team Role</span></p></td></tr></tbody></table> <table data-table-width="760" data-layout="default" ac:local-id="92f4379a-4f86-45a2-95b7-38abf492f34a"><colgroup><col style="width: 340.0px;"><col style="width: 340.0px;"></colgroup><tbody><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_TicketAudit</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Service Desk – Screen: Ticket - Tab: Audit Trail</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_Time</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Time &amp; Expense – Screen: Time Search</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_TimeAudit</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Time &amp; Expense – Screen: Time Entry - Pod: Audit Trail</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_TimeEntryCustomFields</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Custom Fields - Screen: Time Entry - Pod: Overview, Time Details</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_TimeSheetAudit</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Time &amp; Expense – Screen: Time Sheet - Pod: Audit Trail</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_TimeSheets</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Time &amp; Expense – Screen: My Time Sheets</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_TimeStatus</span></p></td><td><p><span style="color: rgb(0,0,0);">Time Sheet Statuses (no setup table)</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_TimeZone</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Time Zone</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_Track</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Track</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_Transaction</span></p></td><td><p><span style="color: rgb(0,0,0);">List of transactions</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_UnpostedExpense</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Time &amp; Expense- Screen: Expense Search (Closed Expenses)</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_UnpostedInvoice</span></p></td><td><p><span style="color: rgb(0,0,0);">Menu: Finance - Screen: Invoice Search (Closed Invoices)</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_UserDefinedEntryType</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Custom Fields - Screen: Any (Entry Types)</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_UserDefinedField</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Custom Fields - Screen: Any(Location of field)</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_UserDefinedFieldBillingUnits</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Custom Fields - Screen: Any (Billing Setup is set)</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_UserDefinedFieldOption</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Custom Fields - Screen: Any (Any field with options)</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_UserDefinedFieldOwnerLevels</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Custom Fields - Screen: Any (Any custom field added)</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_UserDefinedFieldType</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Custom Fields - Screen: Any (Fields types)</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_UserDefinedRequiredField</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Custom Fields - Screen: Any (Any custom field added)</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_Warehouse</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Warehouse</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_WarehouseBin</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Warehouse Bin</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_WorkRoles</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Work Roles</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_WorkRolesLocation</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Work Roles (Selected Locations)</span></p></td></tr><tr><td><p><span style="color: rgb(0,0,0);">v_rpt_WorkTypes</span></p></td><td><p><span style="color: rgb(0,0,0);">Setup Table: Work Types</span></p></td></tr></tbody></table>