Skip to content

Queries Summary

Query Type Tables
JB Qry Update Procurement Contact Update Principals Sales Contacts, Principals Sales, Principals
JB Qry Update Transformation Contact Update Principals Sales Contacts, Principals Sales, Principals
Qry Application Versions Select dbo_ApplicationVersions
Qry Company List Select Entrepreneur, CompanyStatus, Entrepreneur Company...
Qry Company Needs Replacement List Select Entrepreneur, Entrepreneur Company Programme Years, Entrepreneur Company...
Qry Company Pincipal Project Pillars Select Entrepreneur, Entrepreneur Company Principal Projects, Principal Project Pillars
Qry Count Number Months Billed by Company PP and Project Pillar Select Entrepreneur, Entrepreneur Company Monthly Billings, Entrepreneur Company Principal Projects
Qry Get BBBEE Pillars by Sales Brief Select Sales, Sales Brief Selection Marketing
Qry Get Products Sold by Sales Brief Select Products Sales, Products, Sales Brief Selection Marketing Products
Qry Get Sales Brief Marketing Sourced From Select Sales Brief Selection Marketing Sourced From, Sales, Delivery Locations Sales
Qry Principal List Select Principals
Qry Principal Project List Main Dashboard Select ProgrammeYearLookup, Entrepreneur, Entrepreneur Company Programme Years...
Qry Sales Briefs Not Through Gateway Select Sales, Sales Brief, Principals Sales
Qry SubFrm Principal Project Pillar Supporting Documents Select Principal, Principal Project Pillars
Qry Sum Total Billed by Company PP and Project Pillar Select
Qry Sum Total Sponsorship By Sales Brief Pillar Select Sales, Sales Brief Selection Marketing Products
Qry Sum Total Sponsorship By Sales Brief Select Sales, Sales Brief Selection Marketing Products
qryLinkODBC Select zstblODBC_tables, zstblODBC_db
SubQry Get EP Ready for Allocation Info by Company Select Entrepreneur Company, Entrepreneurs, Entrepreneur Company Programme Years