The Approaching Due Numbers Report contains Reserved TFNs that are within a specified number of days from their Reserved Until date for the selected Resp Org. The following figure provides an example of the Approaching Due Report..
Disclaimer: Any images in this article are intended to be used as a guide for educational purposes only and they may differ slightly from the Production Environment.
Approaching Due Number Report Fields Description
The following table identifies the Approaching Due Number report fields and their descriptions.
|
Approaching Due Number Report Field Descriptions |
|
|
Field |
Description |
|
Entity |
An identifier for the Entity |
|
Resp Org |
An identifier for the Resp Org. |
|
Toll-Free Number |
Toll-Free Numbers that are approaching their reserved until date. |
|
Reserve Until Date |
The reserve until date if the Toll-Free Number was reserved or the reserved until date was modified. |
|
Login ID |
The Login ID of the person who reserved the Toll-Free Number. |
|
Last Updated Date/Time |
The date/time when the data updated in the Transactional database (when activity occurred). |
|
Last Refresh Date/Time |
Identifies the date and time the report last refreshed. |
|
Record Count |
Display the count of records associated with the filtered data set (xxxxxxx) and the grand total of records (yyyyyyy) formatted as xxxxxxx/yyyyyyy. |
Data Source Used to Create the Report
The “RHDB_RESERVEDNUMBERS” data source is used to create the Approaching Due Number Report. The fields used from this table are:
- Dialnbr
- Resporg
- Numberstatus
- Logonid
- Reserveduntildate
- Statuschangedate
- Extractdate
- Create_Time
- Update_Time
- Create_Logonid
- Update_Logonid
Please Note: Please refer Reserved Numbers Table (RHDB_RESERVEDNUMBERS) for more information.