Database Query - Aging Entity
Last Modified on 08/28/2026 11:18 am PDT
Pathway: Database > Database Query
The Aging entity represents the unpaid invoices or bills based on how long they have been outstanding as shown on the AR Aging Management screen. This data tracks the flow of cash into the business, identifying exactly who owes money, how much they owe, and—most importantly—how long that money has been outstanding. Information about Aging Buckets, Account Health, and Payment Behavior can be pulled from this data.
Initiating an Aging Query
To generate an Aging report using the Database Query tool, follow the steps outlined below. Reference the Database Query article for more details on how to use the tool for reporting.
- Go to the Database > Database Query screen.
- Click the New button in the top control bar. This will open the Select Main Entity popup.
- Select Aging.
- After the Display Fields for the Aging entity populate, select the check boxes for the fields you want to include in the report.
- If a specific order is required, select the fields in the order you want them to appear in the query.
- Click Run to execute the query. Results are generated in a new tab with the date and timestamp.
Columns Available for Display
The following data can be pulled in when running a User report.
|
Field Name
|
Description
|
|
Account & Division Information
|
| Account Id |
Unique identifier for the customer account associated with the outstanding receivables. |
| Account Name |
Name of the customer account with an accounts receivable balance. |
| Account Status |
System code representing the current operating or billing status of the customer account. |
| Account Status Text |
Description of the account status, such as active, inactive, suspended, or credit hold. |
| Division Id |
Unique identifier for the operating division responsible for the customer account. |
| Division Name |
Name of the operating division or business unit associated with the account. |
| Auditor Name |
Name of the employee or representative assigned to review account balances, payment activity, billing accuracy, or collection status. |
| Billgroup Id |
Unique identifier for the billing group used to organize invoices, charges, payment terms, or collection activity. |
| billgroup name |
Name of the billing group, invoice schedule, payment arrangement, or account billing category. |
|
Accounts Receivable Aging Balances
|
| Current Amount |
Outstanding balance that is current and has not exceeded the defined aging threshold. |
| 1 to 30 Amount |
Outstanding balance that is between 1 and 30 days overdue. |
| 31 to 60 Amount |
Outstanding balance that is between 31 and 60 days overdue. |
| 61 to 90 Amount |
Outstanding balance that is between 61 and 90 days overdue. |
| 91 to 120 Amount |
Outstanding balance that is between 91 and 120 days overdue. |
| Over 120 Amount |
Outstanding balance that is more than 120 days overdue and may require escalated collection activity. |
| Total |
Total accounts receivable balance for the customer, including current and aged outstanding amounts. |
| Unapplied Amount |
Payment or credit amount received from the customer that has not yet been applied to a specific invoice or account charge. |
|
Collections & Payment Activity
|
| Last Collections Activity Date |
Date of the most recent collection-related activity, such as a phone call, notice, dispute review, payment arrangement, or account follow-up. |
| Last Payment Date |
Date on which the most recent customer payment was received or posted to the account. |
Average Days To Pay
| Average number of days the customer takes to pay invoices after they are issued or become due.
|
Entity Join Options
When running reports against the Aging entity, the option to pull in data from other entities is provided by utilizing the Join feature in the Database Query tool.
Only select entities can join with other select entities. The only option provided for Aging is:
For more details on how to use the Join option for more complex, detailed reporting, reference the Database Query article.
Related Articles
Database Query
AR Aging Management - Accounting
