This view contains the following columns, pulling data from all Goods & Services transactions that have Goods or Services within them.

• ServiceID
  
• ReasonForService
  
• OrganizationID
  
• ServiceProvider
  
• ClientID
  
• ClientName
  
• TransactionDate
  
• ProgramID (if there is more than one Program, this will display "-1")
  
• Program (if there is more than one Program, this will display "Multiple")
• ActivitiesID
  
• ActivitiesInTransaction
  
• ServiceActivityType
  
• DateStart
  
• DateEnd
  
• Minutes
  
• UnitPrice
  
• UnitCost
  
• UserID
  
• StaffName

Documentation

• vw_ACRE_GoodsAndServices_Services - Sample Data.csv
• vw_ACRE_GoodsAndServices_Services - Schema.csv