Skip to content
BUZ Help

OData Table Headings

When you connect to BUZ over OData, each report is exposed as its own feed (an OData entity). Every feed carries its own set of columns — the headings you see depend entirely on which report you’re querying.

How the feeds are organised

Section titled “How the feeds are organised”

BUZ groups its OData feeds by reporting area. The feeds available to you include:

  • Leads — Lead Conversion, Lead Conversion by Sales Rep, Lead Reports, Lead Analysis, Lead Analysis by Branch, Lead Sources, Leads Report, Lead Source Matrix.
  • Sales — Product Ordered, Sales Conversion by Product, Sales Orders, Sales Report.
  • Jobs & production — Job Line Levels, Jobs Schedule Detailed, Jobs Schedule Summary, Jobs Schedule Summary (Shutters), Work in Progress.
  • Banking — Banking Transaction Summary, Deposits Held.

Reading the columns

Section titled “Reading the columns”

A few patterns hold across most feeds:

  • Key columns (e.g. Id, LeadPkId, OrderID, OrderNo) uniquely identify each row and are useful for joining feeds together.
  • *PkId columns (e.g. SalesRepPkId, LeadStatusPkId, ProductionStatusPkId) are internal identifiers for related records. They’re handy for filtering, while the matching descriptive column (e.g. SalesRep, LeadStatus) is what you’ll usually display.
  • Date columns (e.g. DateDoc, CreationDate, DateAppointment, InvoicedDate) let you slice by period. Some feeds also break dates out into Year / Month / Week / Day for easier grouping.
  • Amount columns (e.g. Amt, OrderAmt, Order_Amount_ExTax, Order_Tax, Order_Amount_IncTax) hold the monetary values; watch for the ex-tax / inc-tax distinction where both are present.
Section titled “Related pages”