Skip to content

Queries Summary

Query Type Tables
aa1 Select Sales Brief Selection Marketing, Sales, Sales Brief Status...
aa2 Select Sales Brief Selection Marketing, Sales, Sales Brief
Find duplicates for Sales Brief Selection Marketing Select Sales Brief Selection Marketing, Sales
JB Check it Select Sales, Sales Brief
JB Convert Delete Extra Records Select Sales Brief Selection Marketing, Sales, Sales Brief Selection Marketing Products
JB Qry Append Proposal Writers Delete Proposal
JB Qry Append Selection Marketing Products Delete Sales Brief Selection Marketing, Sales
JB Qry Check Sales Brief Selection Marketing Products Select Sales Brief Selection Marketing, Sales, Sales Brief Selection Marketing Products
JB Qry Check the conversion Select Sales Brief Selection Marketing Products, Principals Sales, Sales Brief Selection Marketing...
JB Qry Update Principal Countries Delete Principals, Principals Sales
JB Qry Update Principal Languages Delete Principals, Principals Sales
Qry Application Versions Select
Qry Calculate Standard Marketing Budget by Sales Brief Select Qry Sum Total Programme Fee by Sales Brief, Sales Brief, Qry
Qry Get Date Sales Brief Submitted to Business Select Sales, Sales Brief Status History
Qry Get Emerald Users Select DatabaseUsers Module Permissions, DatabaseUsers
Qry Get Principal Marketing Contact by Sales Brief Select Sales, Principals Sales Contacts, Sales Brief...
Qry Get Unique Proposal Divisions Select Divisions Proposal, Proposal Delivery Regions, Proposal
Qry Principal List Select Principals, Principals Sales
Qry Product Distribution Models Proposal Select Distribution Models Proposal, Product Distribution Models Proposal, Product
Qry Product Divisions Proposal Select Divisions Proposal, Product, Product Divisions Proposal
Qry Product List Proposal Select Products Proposal, Products
Qry Products NOT in Proposal Select Products Proposal, SubQry Products NOT in Proposal, SubQry
Qry Proposal Delivery Regions List Select Delivery Locations Sales, Proposal, Divisions Proposal...
Qry Proposal List Select Principals, Proposal, Proposal Status...
Qry Proposal Product List Select Proposal Products, Products Proposal, Proposal
Qry Proposals Assigned to Principal List Select Principals, Proposal, Proposal Status...
Qry Report Proposal TAT Non Standard Select Qry Sum Time Tracker Minutes by Proposal, Principals Sales, Principals...
Qry Report Proposal TAT Standard Select Qry Sum Time Tracker Minutes by Proposal, Principals Sales, Principals...
Qry Report Sales Brief Select Qry Get Date Sales Brief Submitted to Business, Reporting Frequency, Qry Sum Total Programme Fee by Sales Brief...
Qry Report Writer Select Qry Sum Time Tracker Minutes by Proposal, Principals Sales, Proposal...
Qry Rpt Sales Brief Past In Progress No Contract Number Select Principals Sales, Client Tiers, Sales Brief Contract Numbers...
Qry Sales Brief List Select Sales, Sales Brief Status, Sales Brief...
Qry Sales Briefs Assigned to Principal List Select Principals, Sales Brief Status, Sales Brief...
Qry SubRpt Corhort Ignition Qty Year by Sales Brief Select Sales Brief Selection Marketing, Sales
Qry SubRpt Extra Sponsor Elements Select Sales, Sales Brief Extra Sponsor Elements
Qry SubRpt Finance Distribution Model Type Fees Select Distribution Model Types, Sales, Sales Brief Finance Distribution Model Type Fees
Qry SubRpt Finance Programme Fees Select Sales, Sales Brief Selection Marketing Products, Products Sales
Qry SubRpt Principals Sales Contacts Select Contact Type LkUp, Principals Sales Contacts, Principals
Qry SubRpt Principals Sales Countries Select CountryLookup, Principals Sales Countries
Qry SubRpt Principals Sales Select Principals, Client Tiers, IndustryLookupSales...
Qry SubRpt Sales Brief Marketing Select Sales Brief Selection Marketing, Qry Get Principal Marketing Contact by Sales Brief, Sales
Qry SubRpt Sales Brief Selection Marketing Sourced From Select Delivery Locations Sales, Sales, Sales Brief Selection Marketing Sourced From
Qry SubRpt Sales Brief Selection Select Sales Brief Selection Marketing, Sales
Qry SubRpt Sales Brief Status and Revision History Select Sales, Sales Brief Status, Sales Brief...
Qry SubRpt Sub Products Select Sub Products Sales, Sales, Sales Brief Sub Products
Qry Sum Time Tracker Minutes by Proposal Select Proposal Time Tracking, Proposal
Qry Sum Total Distribution Model Fees by Sales Brief Select Sales, Sales Brief Finance Distribution Model Type Fees
Qry Sum Total Extra Sponsor Elements by Sales Brief Select Sales, Sales Brief Extra Sponsor Elements
Qry Sum Total Programme Fee by Sales Brief Select Sales, Sales Brief Selection Marketing Products
Qry Sum Total Sub Product Fee by Sales Brief Select Sales, Sales Brief Sub Products
qryLinkODBC Select zstblODBC_tables, zstblODBC_db
SubQry Products NOT in Proposal Select Proposal Products, Proposal