Journal Entries And Subledger Details Query Help

Summary:

We just implemented Fusion Cloud/Financials so I'm very new trying to figure out the database tables and relationships. I've been tasked with creating a custom BI report where the users want data on the report from Journal Entries, Subledger and related document data (Invoices, Purchase Orders, Suppliers, Customer…). They want the report to include Journal Entries that are manually created/imported to be included as well and it is my understanding when they do these that their is no subledger data for those Journal Entries. We don't want to use subject areas for this report and want to