Goods & Services (Goods) Dataset

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")
• GoodsID
  
• GoodsInTransaction
  
• GoodsType
  
• NoOfUnits
  
• UnitType
  
• UnitPrice
  
• UnitCost
  
• UserID
  
• StaffName

Documentation

• vw_ACRE_GoodsAndServices_Goods - Sample Data.csv
• vw_ACRE_GoodsAndServices_Goods - Schema.csv