Appendix: JD Edwards EnterpriseOne Console Data Movement Reports

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.

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).