Skip to content

Query: Qry SubRpt Extra Sponsor Elements

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

Tables Referenced

  • Sales
  • Sales Brief Extra Sponsor Elements

Columns Selected

  • [Sales Brief Extra Sponsor Elements].[Sales Brief ID]
  • [Sales Brief Extra Sponsor Elements].[BBBEE Pillar]
  • [Sales Brief Extra Sponsor Elements].[Element Type]
  • [Sales Brief Extra Sponsor Elements].[Sponsorship Amount]
  • [Sales Brief Extra Sponsor Elements].[Admin Fee]
  • [Sales Brief Extra Sponsor Elements].[Number of Entrepreneurs]
  • [Sales Brief Extra Sponsor Elements].[Frequency of Payments]
  • [Sales Brief Extra Sponsor Elements].[Once Off Payment Date]
  • [Sales Brief Extra Sponsor Elements].[Monthly Day of Month]
  • [Sales Brief Extra Sponsor Elements].[Payment Amount]

SQL

SELECT [Sales Brief Extra Sponsor Elements].[Sales Brief ID], [Sales Brief Extra Sponsor Elements].[BBBEE Pillar], [Sales Brief Extra Sponsor Elements].[Element Type], [Sales Brief Extra Sponsor Elements].[Sponsorship Amount], [Sales Brief Extra Sponsor Elements].[Admin Fee], [Sales Brief Extra Sponsor Elements].[Number of Entrepreneurs], [Sales Brief Extra Sponsor Elements].[Frequency of Payments], [Sales Brief Extra Sponsor Elements].[Once Off Payment Date], [Sales Brief Extra Sponsor Elements].[Monthly Day of Month], [Sales Brief Extra Sponsor Elements].[Payment Amount] FROM [Sales Brief Extra Sponsor Elements]