The following table provides the full list of columns that can be viewed per each Tenant Bill that is displayed in the Bills table.
Columns highlighted in bold are enabled/visible by default if this is the first time the Tenant Approve and Issue Bills Activity has ever been opened.
Column | Description |
Billing Group | The Tenant Billing Group linked to the Tenant Bill |
Bill Run ID | The unique ID of the Tenant Bill Run that created the Tenant Bill |
Bill Run Start Date | The Start Date of the Tenant Bill Run that created the Tenant Bill |
Bill Run End Date | The End Date of the Tenant Bill Run that created the Tenant Bill |
Invoice ID | The unique Invoice ID created for the Tenant Bill |
Invoice Date | The date the Tenant Bill was issued |
Contra | A flag to identify the Tenant Bill as a Contra (Credit) bill |
Contra Reference | The Invoice ID of the original Tenant Bill that is being reversed by this Contra bill |
Bill Type | The Bill Type configured for the Tariff used to calculate the Tenant Bill |
Status | The Status of the Tenant Bill: Normal, Cancelled, Approved, Issued, Withdrawn, Withdrawn and Rebilled, Test or Accrual |
Pending Action | The Pending Action on the Tenant Bill:
|
Supply Point | The Name of the Supply Point that is linked to the Tenant Bill |
Supply Point Reference | The Reference of the Supply Point that is linked to the Tenant Bill |
Issue Bill 1 | The value configured for the 'IssueBill1' Supply Point Property Key |
Issue Bill 2 | The value configured for the 'IssueBill2' Supply Point Property Key |
Site Name | The Name of the Site that is linked to the Tenant Bill |
Site Reference | The Reference of the Site that is linked to the Tenant Bill |
Site Identifier | The unique ID of the Site that is linked to the Tenant Bill |
Financial ID Code | The Financial ID of the Site that is linked to the Tenant Bill |
Tenant | The Name of the Tenant that is linked to the Tenant Bill |
Tenant Reference | The Reference of the Tenant that is linked to the Tenant Bill |
Tenant Account | The Account Number of the Tenant Account that is linked to the Tenant Bill |
Tenant Provider | The Name of the Tenant Provider that is linked to the Tenant Bill (via the Tenant Billing Group) |
Settlement Type | The Settlement Type (Payment Method) configured for the Tenant Account that is linked to the Tenant Bill |
Payment Terms | The Payment Terms configured for the Tenant Account that is linked to the Tenant Bill |
Bill Start Date | The Start Date of the Bill Period for the Tenant Bill |
Bill End Date | The End Date of the Bill Period for the Tenant Bill |
Consumption | The total consumption recorded in the Channel(s) used to calculate the Tenant Bill |
Total incl VAT | The total value of the Tenant Bill including VAT |
Total excl VAT | The total value of the Tenant Bill excluding VAT |
VAT Rate | The VAT rate used to calculate the Tenant Bill |
Total VAT | The total VAT value of the Tenant Bill |
Bill Query Flag | A flag to identify whether one of more Queries have been created for the Tenant Account linked to the Tenant Bill |
Channel Data Quality | The data quality of the Channel(s) used to calculate the Tenant Bill: Primary, Secondary, Tertiary, Sample |
Validation Stats | Information on how many Validators Passed, Failed or were Unable to Complete and their severity levels |
Validation Status | Overall result of bill validation: Passed, Failed or Query |
Batch Number | The Batch Number stamped on an issued Tenant Bill when it was exported |
External Invoice ID | The External Invoice ID that has been applied to the Tenant Bill |
Extrapolate Non Periodic Consumption | A flag to identify whether consumption for a Non Periodic Channel used to calculate the Tenant Bill has been extrapolated |
Missing Data | A flag to identify whether a gap was identified for a Periodic Channel used to calculate the Tenant Bill |
Billing Group Timezone | The Time zone configured for the Tenant Billing Group |
Meter Source Description | Contains details of the Meter(s) and/or the Tariff Source(s) of the Tariff Connector(s) used to calculate a Tenant Bill. Where multiple Meter(s) and/or Tariff Source(s) have been used, the values will be concatenated |
Meter Type Description | Contains details of the Meter Type(s) and/or the Tariff Connector(s) used to calculate a Tenant Bill. Where multiple Meter Type(s) and/or Tariff Connector(s) have been used, the values will be concatenated |
TA Property 1 | If the Property Key 1 checkbox is ticked, the value configured for the selected Property Key 1 |
TA Property 2 | If the Property Key 2 checkbox is ticked, the value configured for the selected Property Key 2 |
TA Property 3 | If the Property Key 3 checkbox is ticked, the value configured for the selected Property Key 3 |
TA Property 4 | If the Property Key 4 checkbox is ticked, the value configured for the selected Property Key 4 |
Customised column settings are saved for the next time the Activity is opened