Skip to content

Query: Qry Report Bookkeeping Compliance by Company

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

Tables Referenced

  • Temp
  • Temp Compliance by Company

Columns Selected

  • [Temp Compliance by Company].[Delivery Location ID]
  • [Temp Compliance by Company].[Delivery Location]
  • [Temp Compliance by Company].[RC Bookkeeper Assigned]
  • [Temp Compliance by Company].[Entrepreneur Company ID]
  • [Temp Compliance by Company].[Company Name]
  • [Temp Compliance by Company].[Their Own Bookkeeper]
  • SubmissionDate
  • [Temp Compliance by Company].[Submission Status]
  • [Temp Compliance by Company].[Issue New Permanent Staff]
  • [Temp Compliance by Company].[Issue YTD Does Not Match]

Order By

[Temp Compliance by Company].[Delivery Location], [Temp Compliance by Company].[Company Name], [Temp Compliance by Company].SubmissionDate

SQL

SELECT [Temp Compliance by Company].[Delivery Location ID], [Temp Compliance by Company].[Delivery Location], [Temp Compliance by Company].[RC Bookkeeper Assigned], [Temp Compliance by Company].[Entrepreneur Company ID], [Temp Compliance by Company].[Company Name], [Temp Compliance by Company].[Their Own Bookkeeper], [Temp Compliance by Company].SubmissionDate, [Temp Compliance by Company].[Submission Status], [Temp Compliance by Company].[Issue New Permanent Staff], [Temp Compliance by Company].[Issue YTD Does Not Match] FROM [Temp Compliance by Company]