## Appendix: Appendix: JD Edwards EnterpriseOne Console Data Movement Reports

This appendix lists and describes the JD Edwards EnterpriseOne Console data movement reports.

### JD Edwards EnterpriseOne Console Data Movement Reports: A to Z

The JD Edwards EnterpriseOne Console provides a variety of reports to help you review and manage the information in the metrics. This table lists the reports, sorted alphanumerically by report ID:

Report ID and Report Name | Description | Navigation
R80D010 Sales Order Fact Data Load | Populates the Sales Order Fact table (F80D010) from the Sales Order Detail table (F4211) and the Sales Order Detail History table (F42119). | Type BV in the Fast Path field and click the arrow. Enter the report ID number in the Batch Application field on the Available Versions form.
R80D0201 G/L Balances Fact Full Load UBE | Populates the GL Account Balances Fact table (F80D020) with data from the Account Ledger table (F0911). | Type BV in the Fast Path field and click the arrow. Enter the report ID number in the Batch Application field on the Available Versions form.
R80D0202 G/L Balances Fact Rebuild UBE | Populates the GL Account Balances Fact table (F80D020) with data from the Account Ledger table (F0911). | Type BV in the Fast Path field and click the arrow. Enter the report ID number in the Batch Application field on the Available Versions form.
R80D100 Date Dimension | Populates the PMD - Date Dimension table (F80D100) with the days, months, quarters, and weeks in each year for the view by display on the console. | Type BV in the Fast Path field and click the arrow. Enter the report ID number in the Batch Application field on the Available Versions form.
R80D112 Process SOD Violations | Populates the SOD Alert Master (F80D135) and SOD Alert Detail (F80D136) tables. | Type BV in the Fast Path field and click the arrow. Enter the report ID number in the Batch Application field on the Available Versions form.
R80D200 Days Sales Outstanding Aggregate | Determines the days sales outstanding by using a 52-week sales calculation divided by 360 and then divided into the total open accounts receivable and populates the Days Sales Outstanding Aggregate table (F80D200). | Type BV in the Fast Path field and click the arrow. Enter the report ID number in the Batch Application field on the Available Versions form.
R80D201 Days Payable Outstanding Data Load | Determines the days payables outstanding by using the last 52 weeks of cost-of-goods sold divided by 360 and then divided into the total open payables and populates the Days Payables Outstanding Aggregate table (F80D201). | Type BV in the Fast Path field and click the arrow. Enter the report ID number in the Batch Application field on the Available Versions form.
R80D202 Cash to Cash | Calculates cash to cash cycle time as DSO plus DSI minus DPO and populates the Cash to Cash Cycle Time Aggregate table (F80D202). | Type BV in the Fast Path field and click the arrow. Enter the report ID number in the Batch Application field on the Available Versions form.
R80D203 Forecasted Cash Flow Data Load | Populates the Forecasted Cash Flow Aggregate table (F80D203). | Type BV in the Fast Path field and click the arrow. Enter the report ID number in the Batch Application field on the Available Versions form.
R80D210 On-Time Shipment Customer Request Date Data Load | Calculates on-time, early, and late shipments for each date and populates the On Time Shipment Customer Request Date Aggregate table (F80D210). | Type BV in the Fast Path field and click the arrow. Enter the report ID number in the Batch Application field on the Available Versions form.
R80D211 On-Time Shipment Promised Date Data Load | Calculates on time, early, and late shipments for each date and populates the On Time Shipment Promise Ship Date Aggregate table (F80D211). | Type BV in the Fast Path field and click the arrow. Enter the report ID number in the Batch Application field on the Available Versions form.
R80D212 Past Due Processing | Calculates the past-due order amount and number of past-due sales order lines and populates the Past Due Aggregate table (F80D212). | Type BV in the Fast Path field and click the arrow. Enter the report ID number in the Batch Application field on the Available Versions form.
R80D213 Backorder Processing | Calculates the backorder amount and line count for unfilled sales orders and populates the Back Order Aggregate table (F80D213). | Type BV in the Fast Path field and click the arrow. Enter the report ID number in the Batch Application field on the Available Versions form.
R80D214 Variance Processing | Calculates the difference between the promise ship date and the requested ship date by item and populates the Variance Aggregate table (F80D214). | Type BV in the Fast Path field and click the arrow. Enter the report ID number in the Batch Application field on the Available Versions form.
R80D215 Book to Ship Days Processing | Determines the book-to-ship days value and the number of lines shipped for each sales order and populates the Book to Ship Aggregate table (F80D215). | Type BV in the Fast Path field and click the arrow. Enter the report ID number in the Batch Application field on the Available Versions form.
R80D220 Inventory Data Load | Calculates the days sales in inventory and the number of inventory turns and populates the Inventory Aggregate table (F80D220). | Type BV in the Fast Path field and click the arrow. Enter the report ID number in the Batch Application field on the Available Versions form.
R80D221A G/L Data Load - Cardex COGS | Populates the General Ledger Aggregate table (F80D221) with data from the Item Ledger table (F4111). | Type BV in the Fast Path field and click the arrow. Enter the report ID number in the Batch Application field on the Available Versions form.
R80D221B G/L Data Load - Direct Ship Orders COGS | Populates the General Ledger Aggregate table (F80D221) with data from the Sales Order Detail (F4211) and Sales Order History (F42119) tables. | Type BV in the Fast Path field and click the arrow. Enter the report ID number in the Batch Application field on the Available Versions form.
R80D230 Manufacturing On Time Completions | Calculates on-time, early, and late production completions and populates the On Time Manufacturing Completions table (F80D230). | Type BV in the Fast Path field and click the arrow. Enter the report IDnumber in the Batch Application field on the Available Versions form.
R80D231 Manufacturing Planned vs Actual Cost Variance | Determines the actual production costs for all finished goods and calculates the variance to planned production costs from the work orders and populates the Manufacturing Production Costing table (F80D231). | Type BV in the Fast Path field and click the arrow. Enter the report ID number in the Batch Application field on the Available Versions form.
R80D240 Booked Orders Aggregate Data Load | Calculates the booked order value for each day and populates the Booked Order Aggregate table (F80D240). | Type BV in the Fast Path field and click the arrow. Enter the report ID number in the Batch Application field on the Available Versions form.
R80D241 Shipped Orders Processing | Calculates the shipped revenue for each sales order and for each day and populates the Shipped Orders Aggregate table (F80D241). | Type BV in the Fast Path field and click the arrow. Enter the report ID number in the Batch Application field on the Available Versions form.
R80D242 Projected Revenue Processing | Calculates the projected revenue for each day and populates the Projected Revenue Aggregate table (F80D242). | Type BV in the Fast Path field and click the arrow. Enter the report ID number in the Batch Application field on the Available Versions form.
R80D243 Backlog Processing | Calculates the backlog value for each day and populates the Backlog Aggregate table (F80D243). | Type BV in the Fast Path field and click the arrow. Enter the report ID number in the Batch Application field on the Available Versions form.
R80D250 Supplier On-Time Delivery | Calculates on-time, early, and late deliveries from each supplier and populates the Supplier On Time Delivery Aggregate table (F80D250). | Type BV in the Fast Path field and click the arrow. Enter the report ID number in the Batch Application field on the Available Versions form.
R80D251 Material Lead Time Exception | Calculates the actual lead time for items and populates the Material Lead Time Exception Aggregate table (F80D251). | Type BV in the Fast Path field and click the arrow. Enter the report ID number in the Batch Application field on the Available Versions form.
R80D252 Supplier Pass Quality Performance | Calculates the quality pass percentage for each purchase order received and populates the Supplier Pass Quality Aggregate table (F80D252). | Type BV in the Fast Path field and click the arrow. Enter the report ID number in the Batch Application field on the Available Versions form.
R80D253 AP Daily Counts and Amounts | Populates the AP Daily Counts and Amounts table (F80D253). | Type BV in the Fast Path field and click the arrow. Enter the report ID number in the Batch Application field on the Available Versions form.
R80D254 AP Discount Information Data Load | Populates the AP Discount Information Aggregate table (F80D254). | Type BV in the Fast Path field and click the arrow. Enter the report ID number in the Batch Application field on the Available Versions form.
R80D255 AP Open Payables Data Load | Populates the AP Open Payables Aggregate table (F80D255). | Type BV in the Fast Path field and click the arrow. Enter the report ID number in the Batch Application field on the Available Versions form.
R80D256 AP Vouchers Paid Late - Data Load | Populates the AP Voucher Paid Late Aggregate table (F80D256). | Type BV in the Fast Path field and click the arrow. Enter the report ID number in the Batch Application field on the Available Versions form.
R80D272 ACA Most Profitable Customers Data Load | Populates the Most Profitable Customers Aggregate table (F80D272). | Type BV in the Fast Path field and click the arrow. Enter the report ID number in the Batch Application field on the Available Versions form.
R80D273 ACA Most Profitable Products Data Load | Populates the Most Profitable Products Aggregate table (F80D273). | Type BV in the Fast Path field and click the arrow. Enter the report ID number in the Batch Application field on the Available Versions form.
R80D274 ACA Most Profitable Brands Data Load | Populates the Most Profitable Brands Aggregate table (F80D274). | Type BV in the Fast Path field and click the arrow. Enter the report ID number in the Batch Application field on the Available Versions form.
R80D280 AR Daily Counts and Amounts | Populates the AR Daily Counts and Amts Aggr table (F80D280). | Type BV in the Fast Path field and click the arrow. Enter the report ID number in the Batch Application field on the Available Versions form.
R80D281 AR Delinquency – Data Load | Populates the AR Delinquency Info Aggregate table (F80D281). | Type BV in the Fast Path field and click the arrow. Enter the report ID number in the Batch Application field on the Available Versions form.
R80D282 AR Discount Information – Data Load | Populates the AR Discount Information Aggregate table (F80D282). | Type BV in the Fast Path field and click the arrow. Enter the report ID number in the Batch Application field on the Available Versions form.
R80D283 AR Open Chargeback Information - Data Load | Populates the AR Open Chargeback Aggregate table (F80D283). | Type BV in the Fast Path field and click the arrow. Enter the report ID number in the Batch Application field on the Available Versions form.
R80D284 AR Open Receivables Data Load | Populates the AR Open Receivables Aggregate table (F80D284). | Type BV in the Fast Path field and click the arrow. Enter the report ID number in the Batch Application field on the Available Versions form.
R80D285 AR Total Chargeback Information - Data Load | Populates the AR Total Chargebacks Aggregate table (F80D285). | Type BV in the Fast Path field and click the arrow. Enter the report ID number in the Batch Application field on the Available Versions form.
R80D701 Unposted Transaction - Data Load | Populates the Unposted Transactions Aggregate table (F80D701). | Type BV in the Fast Path field and click the arrow. Enter the report ID number in the Batch Application field on the Available Versions form.