Support

Bill Account is active. Same as Bill Account is Active Status Filter, but listed as a filter instead, since no bills are associated with this report type.

The account code (often called "account number") assigned by the vendor to a utility account. The Account Code is shown on the utility bill and is the primary means of tracking accounts. See Accounting - Accounts.

Memo field for Account (Account Properties Memo tab).

A display name associated with an account code (often called "account number"). Can be helpful in distinguishing accounts (ex: "Admin building main electric").

Internal Database Identifier for account. Appears in the Account Properties General tab to the right of the Code field.

The Accounting Period month.

The Accounting Period year.

The Start Year for the Budget.

The "current" year when used in year-to-year comparisons, format yyyy.

The number of days between bills that is acceptable (bills with gaps equal to or less than this number will not be included).

EnergyCAP User assigned to the Issue (Issue Tracker)

The audit number.

The user-created Code for the Audit Group.

The user-created Name for the Audit Group.

The audit name.

The code for the Audit Property

The name of the Audit Property.

Bill or Channel Audit Code

Bill or Channel Audit Name

Baseline adjustment codes assigned to CAP Adjustments.

The "beginning" year used in year-to-year comparisons.

The year that the base year period ends. Some reports may span more than one year. This filter enables filtering by the calendar year in which the base year ends.

The date (mm/dd/yyyy) on which a bill entry batch was closed (completed).

The code or number assigned to a bill entry Batch. Bill entry batch mode is optional; see Tools - Work Flow Wizard to activate Batches.

The date (mm/dd/yyyy) on which a bill entry batch was created (opened).

The total of the Pay Amounts of all bills in a bill entry batch.

The date (mm/dd/yyyy) on which a bill was approved. The approval process is optional; see Tools - Work Flow Wizard to activate it. If not activated, bills are approved when created.

The control number of a bill audit. See Analysis - Audit or report SU20 for a list of audits.

The date (mm/dd/yyyy) on which the billing period started (i.e. the date of the beginning meter reading).

The value in the Control Code field of the bill entry screen. This is an optional bill entry field; use Tools-Work Flow Wizard to activate it. Use Accounting-Accounts-Tools-View Options-Bill Image to designate this field as the Bill Image file name.

Energy CAP is set to track all bills using a bill cycle of "Monthly." Other options are disabled.

The value in the Due Date field of the bill entry screen. This is an optional bill entry field; use Tools-Work Flow Wizard to activate it.

The date (mm/dd/yyyy) on which the billing period ended (i.e. the date of the ending meter reading).

The User ID of the person who keyed or imported the bill.

The date (mm/dd/yyyy) on which the bill record was created.

When true, bill split processor has been run for the master account bill. This is a Status Filter.

The value in the Invoice Number field of the bill entry screen. This is an optional bill entry field; use Tools-Work Flow Wizard to activate it.

The value in the "Value" column (i.e. not the "Cost" column) of a line item on a bill.

A stored Bill Message. Bill Messages are created and managed in Tools - Work Flow Wizard and attached to bills via the yellow Message icon on the bill entry screen.

The optional two-character Key code of a stored Bill Message or system-defined message type. Bill Messages are created and managed in Tools - Work Flow Wizard and attached to bills via the yellow Message icon on the bill entry screen.

The billing month to which bills are assigned. Format mm (ex: July = 7). The billing period is shown on the bill entry screen.

The Bill Statement Date, as entered from the Bill window. This optional field can be added from the Work Flow Wizard.

Total amount due the vendor (Bill Header information)

The value in a billed demand line item on a bill.

The billing period to which bills are assigned. Format YYYYMM (ex: July 2006 = 200607). The billing period is shown on the bill entry screen.

The billing period year to which bills are assigned. Format yyyy (ex: 2006). The billing period month and year are shown on the bill entry screen.

The number of bills in a bill entry batch.

Billing Period or Account Period report basis (YY14/YY15 Reports)

The Name of the budget.

The Version of the Budget

Text shown on bill bodyline to describe the data value (i.e., Usage, Billed Demand)

In some YY reports, the change in cost or use from the previous year to the latest year.

The code of a meter channel (e.g. a 15-minute KW electric interval data channel). The code is created by the system (ex: USE:KWH:A:T:43200 which indicates Usage-Units-Automatic(i.e. imported)-Trip-Interval)

Code for unit of measure for data being tracked (i.e., Value, KW, KWh, CCF)

Name for the unit of measure for data being tracked (i.e., Value, KW, KWh, CCF)

The date (mm/dd/yyyy) of the payment check. Use the Administrator program to import bill payment data.

The number of the payment check. Use the Administrator program to import bill payment data.

The City (Place address, City field).

Date the check was cleared. When False, the check has not cleared.

The code of a Commodity (ex: ELECTRIC). See Tools-Unit System for a list of available commodities or to add a new commodity.

The display name of a Commodity (ex: Electric). See Tools-Unit System for a list of available commodities or to add a new commodity.

The first three digits of the Contact Phone Number (Person Properties-Phone field).

The City of the Contact (taken from Contact Address field)

The Country of the Contact (taken from the Contact Address field)

Email address of Contact (taken from Contact Email field).

Contact first name.

Contact First Name (from Full Name window).

Contact Last Name (from Full Name window).

Contact last name.

Postal Code of the Contact (taken from the Contact Address field).

The State of the Contact (taken from the Address field for the Contact).

The telephone number for a contact.

The end date for the Contract.

The ID or number of the Contract.

The renewal date for the Contract.

The start date for the Contract.

The Control Code

The cost as indicated on the bill.

The dollar value of cost avoidance; positive indicates savings, negative indicates loss.

The cost avoidance percentage that relates cost avoidance dollars to "cost without CAP."

The code of a Cost Center. See Accounting-Accounts to create new cost centers or to manage existing cost centers. A Cost Center is a flexible method of organizing utility accounts; all utility accounts fall under a Cost Center.

The display name of a Cost Center. See Accounting-Accounts to create new cost centers or to manage existing cost centers. A Cost Center is a flexible method of organizing utility accounts; all utility accounts fall under a Cost Center.

Unit cost -- cost divided by usage.

The type of Counter (user-defined)

The Country (Place address, Country field).

The current time period used in year-to-year comparisons. Distinguishes it from baseline or previous years.

The current year used in year-to-year comparisons.

Similar to Vendor Code; the code of the Customer in rebillings and chargebacks. See Setup-Contacts.

Daily summation of channel data.

Format mm/dd/yyyy

Used in Report BL34 to indicate the allowable number of days past the expected receipt date of a bill.

Deposit Amount (as listed in Account Properties, Services tab).

Note field content for account deposit.

Date the account deposit was paid (Account Properties/Services tab)

Date the account deposit should be returned (Account Properties/Services tab)

The City portion of the address for a meter/counter/weather station.

The Code associated with the device (meter/counter/weather station).

The Name associated with the device (meter/counter/weather station).

The Postal Code portion of the address for a meter/counter/weather station.

The State portion of the address for a meter/counter/weather station.

Identifies the device as a meter, counter or weather station.

Vendor banking code number (Vendor Properties/Other tab).

The Date the bill payment is due.

The End Date for the Accrual (Reports BL33 and BL33A)

End month for report data.

End year for report data.

The effective start date for the equation (virtual accounts/calculated accounts/bill splits).

Date the bill is exported to AP/GL.

The first month included in a budget report. This allows the report to be processed on a fiscal year basis (ex: When Start Month is set to 7, the report will be on a July fiscal basis).

The first month included in a report. This allows the report to be processed on a fiscal year basis (ex: When First Month is set to 7, the report will be on a July fiscal basis).

Effective date of floor area change (Place Properties/Building tab)

Building floor area. See Place Properties - Building to enter and manage floor areas.

The General Ledger Code. GL records are associated with meters and accounts for interface with accounting systems.

The General Ledger Name. GL records are associated with meters and accounts for interface with accounting systems.

The name given to the GL subcode field. See Accounting-Accounts. A GL record can have 20 subcodes.

The value for the GL subcode.

The number of the invoice. This is a Status Filter.

The person the issue is assigned to (from Contact Manager contact list)

The cost associated with the issue (Issue Tracker).

The effective date associated with the issue (Issue Tracker).

The status associated with the issue (Issue Tracker).

The Type associated with the issue (Issue Tracker).

Load Factor Percentage.

Similar to meter code. A Logical Device is a distribution point for energy or information.

Similar to meter display name. A Logical Device is a distribution point for energy or information.

Identifying the Device as a Meter, Counter or Weather Station.

The earliest date the Account Message will be displayed.

The latest date the Account Message will be displayed.

The code of a Meter (also called a Logical Device). See Setup-Facilities to create new meters or to manage existing meters.

The cost associated with the meter.

The code for the Meter Group (Group Properties).

The name for the Meter Group (Group Properties).

The code of a Meter Group. See Setup-Groups-Meter Groups to create new groups of meters or to manage existing groups.

The display name of a Meter Group. See Setup-Groups-Meter Groups to create new groups of meters or to manage existing groups.

The display name of a Meter (also called a Logical Device). See Setup-Facilities to create new meters or to manage existing meters.

The serial number stamped on the utility meter and usually shown on the utility bill. Use Meter Properties - Specific tab to track meter serial numbers.

Number of months (1-12) included on the report.

the number of months that EnergyCAP will use in preparing the Report.

The number of months included in the report.

The Date of the Channel observation (see CH08 report).

The observation method of a channel reading (interval data or meter reading).

The time of a channel reading (interval data or meter reading).

The code of an Observation Type (a bill line item); see Tools - Unit System - Types.

The display name of an Observation Type (a bill line item); see Tools - Unit System - Types.

A Place Group; see Setup - Groups - Place Groups.

The amount paid.

The status of the payment check. Use the Administrator program to import bill payment data.

Difference between baseline and current bill, expressed as a percentage (Cost Avoidance).

Total area associated with the place, expressed in either square feet or square meters (Place Properties/Building tab).

The City portion of the address for a place.

The code of a Place. See Setup-Facilities to create new places or to manage existing places. Both buildings and organizational levels (divisions, departments, etc) are called Places. See also Topmost Place.

The Country portion of the address for a place.

The code of a Place Group. See Setup-Groups-Place Groups to create new groups of places or to manage existing groups.

The display name of a Place Group. See Setup-Groups-Place Groups to create new groups of places or to manage existing groups.

The Code for the Place Group Type.

The display name of a Place. See Setup-Facilities to create new places or to manage existing places. Both buildings and organizational levels (divisions, departments, etc) are called Places. See also Topmost Place.

ZIP or other postal code for Place(s).

The State portion of the address for a place.

The Code for the Place Type (Place Properties.General tab). Examples: Organization, Building, Site

The Name for the Place Type (Place Properties.General tab). Examples: Organization, Building, Site

The Postal Code for the address referenced in the report.

Primary Use is a Place property (General tab)indicating the main purpose of the facility. Primary Use options are user-defined. EnergyCAP creates and maintains auto-groups based on each defined Primary Use.

The Budget Code and Budget Version. A Budget can have multiple versions.

Describes the logical device property (i.e., import ID, serial #, date installed)

Data (value) associated with the logical device property (i.e., import ID, serial #, date installed)

The code of a Rate record; see Accounting - Rates.

The effective date of the rate.

The End Date associated with the Rate.

The name of the rate.

The name of the report (filter for SU19 report).

The type of report (filter for SU19 report).

The Code for the meter or counter route.

The Name for the meter or counter route.

The Name of the season (used in establishing rate periods).

The Code for the season set (used in establishing rate periods).

The date on which an account's service began. Use Account Properties - Services to track account service dates.

The date on which an account's service ended. Use Account Properties - Services to track account service dates. Bills cannot be entered that have a start date later than account service end date.

The severity code of an audit or bill message. 0-pass, 1-low, 2-moderate, 3-severe, 4-fail.

The first month included in a report. This allows the report to be processed on a fiscal year basis (ex: When Start Month is set to 7, the report will be on a July fiscal basis).

The start time for interval data included in a report.

State/province abbreviation from the Address block of a place, meter or account.

The status of an audit result: Problem, Fixed, Ignored

The Place Type for which summary data should be provided. EXAMPLE: If reporting for a range of buildings with a Place Type of "Division", summary data would be provided at the Division level for the buildings within each Division.

The Vendor tax identification number.

The telephone area code for a contact.

The Code for the Bill Entry Template.

The Effective Date of the template.

The Name of the Bill Entry Template.

The name for the Time of Use associated with the rate (i.e., On-Peak, Off-Peak).

The name for the Time of Use Period associated with the rate (i.e., On-Peak, Off-Peak).

The Time Zone associated with the logical device (Meter Properties/General tab).

The code of a Cost Center in the Account Manager treeview. ALL accounts located anywhere under this treeview node will be included. This varies from the Cost Center Code filter that requires an account to be assigned DIRECTLY to that Cost Center.

The display name of a Cost Center in the Account Manager treeview. ALL accounts located anywhere under this treeview node will be included. This varies from the Cost Center filter that requires an account to be assigned DIRECTLY to that Cost Center.

The code of a Place in the Facility Manager treeview. ALL places and meters located anywhere under this treeview node will be included. This varies from the Place Code filter that requires a meter to be assigned DIRECTLY to that Place.

The display name of a Place in the Facility Manager treeview. ALL places and meters located anywhere under this treeview node will be included. This varies from the Place Code filter that requires a meter to be assigned DIRECTLY to that Place.

The total cost associated with the bill.

The Code for the consumption unit of measure (ex: kWh for electricity).

The Name for the consumption unit of measure (ex: kWh for electricity).

The Unit Type Code from the units tab of the unit system.

The Unit Type Name from the units tab of the unit system.

Consumption quantity

The code (User ID) of an Energy CAP user. See Setup-Users to create and manage Users.

The value in a user-defined field. User-defined fields for meters, accounts, places and vendors are activated through the Administrator program, and are then entered and edited via Properties.

The display name of an Energy CAP user. See Setup-Users to create and manage Users.

The User Roles from the permissions tab of the create user screen

The City portion of the Vendor address.

The code of a Vendor. See Setup-Contacts to create new vendors or to manage existing vendors.

The Country portion of the Vendor address.

The display name of a Vendor. See Setup-Contacts to create new vendors or to manage existing vendors.

The Postal Code portion of the Vendor address.

The State portion of the Vendor address.

The code of a weather channel, typically Mean Temperature.

The code of a Weather Station. See Setup-Weather Stations to create new weather stations or to manage existing weather stations.

The Name of the weather station.

The first year (format yyyy) of a multi-year report.

The third year (format yyyy) of a multi-year report.

The second year (format yyyy) of a multi-year report.

A value of Yes (True, 1) means that the account is active (i.e. the Active checkbox is checked in Account Properties - Services). This is a Status Filter.

A value of Yes (True,1) means that this bill was created via the accrual module. Both accruals and their subsequent accrual reversals have this flag set to Yes. This is a Status Filter.

A value of Yes (True,1) means that this bill is an accrual reversal that was created via the accrual module. When the reversal is created, both the accrual and the accrual reversal have this flag set to Yes. This is a Status Filter.

A value of Yes (True,1) means that this bill is on export Hold. It will not be eligible for export until toggled off of Hold (right click from Export Hold list in Work Flow Manager.) This is a Status Filter.

A value of Yes (True,1) means that this bill was exported to A/P. (See also G/L Exported.) This is a Status Filter.

A value of Yes (True,1) means that this bill was exported to G/L. (See also Exported.) This is a Status Filter.

A value of Yes (True,1) means that this bill was held in the Import Queue.

A value of Yes (True,1) means that this bill (1) was imported into Energy CAP and (2) was verified via right click from the Import Verified bill list in the Work Flow Manager. Bills that are not imported have the Import Verified flag set to 1 automatically. The purpose of the Import Verified work flow list is to allow you to quickly review, audit or delete an entire group of imported bills in the event that you discover a problem with the source file (wrong month,wrong format, missing data, etc). This is a Status Filter.

A value of Yes (True, 1) means that this bill has been approved. The approval process is optional and is activated via Tools - Work Flow Wizard. If the approval process is not activated, all bills are flagged as approved when created. This is a Status Filter.

A value of Yes (True,1) means that this bill is a payable from an outside utility vendor. A value of No (False, 0) means that this bill was created internally by an EnergyCAP process for accounting, billing or chargeback to a Customer. These "customer" bills will generally be shown as "simulated" in the Creation column of Account Manager bill lists. Processes that create simulated bills include the split processor and the virtual bill processor. This is a Status Filter.

A value of Yes (True,1) means that this bill was voided. Normally, voided bills are excluded from reports. This is a Status Filter.

Select rates to include in the report.
Filter to only return current rates (Yes), historic rates (No), or return both current and historic rates (All).