Skip to content

Query: Qry Report Sales Brief

Type: Select
Has Parameters: Yes
Has Joins: No
Has Subquery: No

Tables Referenced

  • Qry Get Date Sales Brief Submitted to Business
  • Reporting Frequency
  • Qry Sum Total Programme Fee by Sales Brief
  • Qry Sum Total Sub Product Fee by Sales Brief
  • Sales Brief
  • Sales
  • Sales Brief Status
  • Qry Sum Total Distribution Model Fees by Sales Brief
  • Qry Sum Total Extra Sponsor Elements by Sales Brief

Columns Selected

  • [Sales Brief].[Sales Brief ID]
  • [Sales Brief].[Sales Brief Number]
  • [Sales Brief].[Principal ID]
  • [Sales Brief].[Sales Brief Number]
  • [Sales Brief].[Version Number]
  • [Qry Get Date Sales Brief Submitted to Business].[Date Submitted to Business]
  • [Sales Brief].[Date Created]
  • [Sales Brief Status].[Sales Brief Status]
  • [Sales Brief].[Date Status Changed]
  • [Sales Brief].[Status Modified By]
  • [Sales Brief].[Solutions Architect]
  • [Sales Brief].[Key Account Manager]
  • [Sales Brief].[Sales Manager]
  • [Sales Brief].[Contract Type]
  • [Sales Brief].[Contract Duration]
  • [Sales Brief].[Contract Duration Other]
  • [Sales Brief].[How Lead Generated]
  • [Sales Brief].[Client (Lead Generated)]
  • [Sales Brief].[Conference (Lead Generated)]
  • [Sales Brief].[Solution Architect (Lead Generated)]
  • [Sales Brief].[Marketing Campaign (Lead Generated)]
  • [Sales Brief].[Which Database (Lead Generated)]
  • [Sales Brief].[Raizcorp Management (Lead Generated)]
  • [Sales Brief].[Lead Report Frequency]
  • [Sales Brief].[Verification Agency Name]
  • [Sales Brief].[Principal Verified Date]
  • [Sales Brief].[VA Pack Date]
  • IIf([Non Standard Bookkeeping Process]=1,\
  • IIf([Efficacy Non Standard Elements]=1,\
  • IIf([Standard Ignition Apply]=1,\
  • [Sales Brief].[Ignition Description]
  • [Reporting Frequency].[Reporting Frequency]
  • [Reporting Frequency].[Reporting Frequency Description]
  • IIf(IsNull([Total Programme Fee]),0,[Total Programme Fee])
  • IIf(IsNull([Total Sub Product Fee]),0,[Total Sub Product Fee])
  • IIf(IsNull([Total Dist Model Fee]),0,[Total Dist Model Fee])
  • 025
  • IIf(IsNull([Additional Marketing Costs]),0,[Additional Marketing Costs])
  • IIf(IsNull([Total Stipend Costs]),0,[Total Stipend Costs])
  • [Tot Programme Fee]+[Tot Sub Product Fee]+[Tot Dist Model Fee]+[Add Marketing Co
  • [Sales Brief].[Contract Payment Terms]
  • [Sales Brief].[Invoice Day of Month]
  • [Sales Brief].[Invoice Day of Month Other]
  • [Sales Brief].[Once Off Invoice Date]
  • [Sales Brief].[Entity Contracted]
  • [Sales Brief].[Channel Partner]
  • [Sales Brief].[Channel Partner Percentage]
  • [Total Programme Fee]*[Channel Partner Percentage]
  • [Sales Brief].[Channel Partner Approver]
  • Notes
  • [Sales Brief].[Modified By]
  • [Sales Brief].[Date Modified]
  • Project
  • [Sales Brief].[Contract Start Date]

Where Clause

((([Sales Brief].[Sales Brief ID])=[Forms]![Frm Sales Brief List]![SalesBriefLis

SQL

SELECT [Sales Brief].[Sales Brief ID], [Sales Brief].[Sales Brief Number], [Sales Brief].[Principal ID], [Sales Brief].[Sales Brief Number], [Sales Brief].[Version Number], [Qry Get Date Sales Brief Submitted to Business].[Date Submitted to Business], [Sales Brief].[Date Created], [Sales Brief Status].[Sales Brief Status], [Sales Brief].[Date Status Changed], [Sales Brief].[Status Modified By], [Sales Brief].[Solutions Architect], [Sales Brief].[Key Account Manager], [Sales Brief].[Sales Manager], [Sales Brief].[Contract Type], [Sales Brief].[Contract Duration], [Sales Brief].[Contract Duration Other], [Sales Brief].[How Lead Generated], [Sales Brief].[Client (Lead Generated)], [Sales Brief].[Conference (Lead Generated)], [Sales Brief].[Solution Architect (Lead Generated)], [Sales Brief].[Marketing Campaign (Lead Generated)], [Sales Brief].[Which Database (Lead Generated)], [Sales Brief].[Raizcorp Management (Lead Generated)], [Sales Brief].[Lead Report Frequency], [Sales Brief].[Verification Agency Name], [Sales Brief].[Principal Verified Date], [Sales Brief].[VA Pack Date], IIf([Non Standard Bookkeeping Process]=1,\, IIf([Efficacy Non Standard Elements]=1,\, IIf([Standard Ignition Apply]=1,\, [Sales Brief].[Ignition Description], [Reporting Frequency].[Reporting Frequency], [Reporting Frequency].[Reporting Frequency Description], IIf(IsNull([Total Programme Fee]),0,[Total Programme Fee]), IIf(IsNull([Total Sub Product Fee]),0,[Total Sub Product Fee]), IIf(IsNull([Total Dist Model Fee]),0,[Total Dist Model Fee]), [Tot Programme Fee]*0.025, IIf(IsNull([Additional Marketing Costs]),0,[Additional Marketing Costs]), IIf(IsNull([Total Stipend Costs]),0,[Total Stipend Costs]), [Tot Programme Fee]+[Tot Sub Product Fee]+[Tot Dist Model Fee]+[Add Marketing Co, [Sales Brief].[Contract Payment Terms], [Sales Brief].[Invoice Day of Month], [Sales Brief].[Invoice Day of Month Other], [Sales Brief].[Once Off Invoice Date], [Sales Brief].[Entity Contracted], [Sales Brief].[Channel Partner], [Sales Brief].[Channel Partner Percentage], [Total Programme Fee]*[Channel Partner Percentage], [Sales Brief].[Channel Partner Approver], [Sales Brief].Notes, [Sales Brief].[Modified By], [Sales Brief].[Date Modified], [Sales Brief].Project, [Sales Brief].[Contract Start Date] FROM [Sales Brief], [Sales Brief Status], [Reporting Frequency], [Qry Sum Total Distribution Model Fees by Sales Brief], [Qry Sum Total Programme Fee by Sales Brief], [Qry Sum Total Extra Sponsor Elements by Sales Brief], [Qry Get Date Sales Brief Submitted to Business], [Qry Sum Total Sub Product Fee by Sales Brief] WHERE ((([Sales Brief].[Sales Brief ID])=[Forms]![Frm Sales Brief List]![SalesBriefLis