B Appendix: JD Edwards EnterpriseOne Console Data Movement Reports

This appendix contains the following topics:

B.1 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 ID number 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.