Skip to content

Query: Qry Export Commitment Fee Information for Invoice

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

Tables Referenced

  • SubQry Export Commitment Fee Information for Notification
  • Temp Entrepreneur ID for Contract Mail Merge
  • Temp

Columns Selected

  • [SubQry Export Commitment Fee Information for Notification].[Committment Fee Inv
  • [SubQry Export Commitment Fee Information for Notification].[Entrepreneur Compan
  • [SubQry Export Commitment Fee Information for Notification].[Company Name]
  • [SubQry Export Commitment Fee Information for Notification].[Delivery Location]
  • [SubQry Export Commitment Fee Information for Notification].[Committment Fee]
  • [SubQry Export Commitment Fee Information for Notification].[Contract Start Date

Order By

[SubQry Export Commitment Fee Information for Notification].[Company Name]

SQL

SELECT [SubQry Export Commitment Fee Information for Notification].[Committment Fee Inv, [SubQry Export Commitment Fee Information for Notification].[Entrepreneur Compan, [SubQry Export Commitment Fee Information for Notification].[Company Name], [SubQry Export Commitment Fee Information for Notification].[Delivery Location], [SubQry Export Commitment Fee Information for Notification].[Committment Fee], [SubQry Export Commitment Fee Information for Notification].[Contract Start Date FROM [Temp Entrepreneur ID for Contract Mail Merge], [SubQry Export Commitment Fee Information for Notification]