This data view allows you to access the data that displays within the AR Detail data grid in AR Credit & Collections.
This data is pulled from the GP Warehouse table in MoversSuite, therefore it is highly suggested that you perform a Data Warehouse Refresh prior to accessing this view.
The following table lists the data available through this view and in the order in which they display. Please refer to AR Detail for field descriptions.
|
Fields included in this view |
|
Customer Number |
|
Order Number |
|
Invoice Number |
|
Invoice Date |
|
Invoice Total |
|
Days Old |
|
Invoice Created Date |
|
Invoice Created By |
|
Shipper Name |
|
From Address |
|
To Address |
|
Revenue Clerk |
|
Type of Move |
|
National Account |
|
Alerts |
|
Purchase Order Number |
|
GBL Number |
|
Document Number |
|
Original Amount |
|
Current Balance |
|
Document Type |
|
Document Description |
|
Item Code |
|
Journal Date |
|
Document Date |
|
Date Posted |
|
Document Age |
|
Branch |
|
Collector |
RELATED TOPIC: