Query Library

The Query Library is the reusable SQL repository for this section. It is best after students know the business question they are working on. If students are still learning how to run SQL or read the company story, start with SQL Guide, Reports Hub, or Cases first.

Reports and cases answer different teaching needs. Reports show finished outputs. Cases give students a guided assignment flow. The Query Library sits underneath both: it exposes the SQL building blocks and the source-table logic behind the learning path.

Query Domains

Domain	What students use it for	Go to
Financial Queries	Statements, settlement timing, working capital, payroll liabilities, accruals, CAPEX, budget, and commercial performance	Financial Queries
Managerial Queries	Cost management, product portfolio, manufacturing, labor, workforce coverage, planning, replenishment, pricing, and design-service utilization	Managerial Queries
Audit Queries	Document completeness, approvals, master data, workforce controls, planning support, pricing governance, source tracing, and anomaly review	Audit Queries

When to Use the Query Library

Open the Query Library when the class needs the SQL inventory rather than a finished report or a guided case. It is not the first reading page for beginners:

1. start with SQL Guide when students need the mechanics of running SQL
2. open the query domain that matches the accounting or business question after the process is clear
3. use the compact query cards to read the objective, output grain, and main tables
4. expand the SQL only when students are ready to inspect joins, filters, or calculations
5. move into Reports or Cases when students need interpretation or a structured assignment

Case-Support Trace Queries

These queries are built for the core process-tracing cases. They are public SQL, but they are best used inside the matching case because the case explains the transaction story and the required student output.

Use these trace queries with the matching case page. They are source-level support queries rather than general starter packs.

O2C Line Trace Order Shipment Invoice

Trace one O2C line from order entry through shipment and invoice detail.

Output

One row per order-line-to-shipment-line-to-invoice-line trace.

Main tables

SalesOrder, SalesOrderLine, Shipment, ShipmentLine, SalesInvoice, SalesInvoiceLine, Customer.

O2C Source to GL Trace

Tie shipment, invoice, and commission source rows back to posted GL activity.

Output

One row per shipment or invoice source line and related GL posting row.

Main tables

Shipment, ShipmentLine, SalesInvoice, SalesInvoiceLine, SalesCommissionAccrual, SalesCommissionAdjustment, SalesCommissionPayment, GLEntry, Account, SalesOrder, Customer.

P2P Invoice Line Trace Receipt vs Accrual

Separate receipt-matched supplier invoice lines from accrual-linked service-settlement lines.

Output

One row per purchase invoice line.

Main tables

PurchaseInvoiceLine, PurchaseInvoice, PurchaseOrderLine, PurchaseRequisition, GoodsReceiptLine, JournalEntry, Supplier, Item.

P2P Accrual Journal Invoice Payment GL Trace

Trace an accrual-linked supplier invoice line from accrual journal through invoice clearing and disbursement postings.

Output

One row per accrual-linked purchase invoice line.

Main tables

JournalEntry, PurchaseInvoiceLine, PurchaseInvoice, DisbursementPayment, GLEntry, Account, Supplier, Item.

Manufacturing Work Order Operation Trace

Trace one work order through operation sequence, schedule rows, approved clocks, and direct labor support.

Output

One row per work-order operation.

Main tables

WorkOrderOperation, WorkOrder, Item, RoutingOperation, WorkCenter, WorkOrderOperationSchedule, TimeClockEntry, LaborTimeEntry.

Manufacturing Work Order Close GL Trace

Trace one work order from material issue through completion, close variance, and supporting GL postings.

Output

One row per work order.

Main tables

WorkOrder, MaterialIssue, MaterialIssueLine, ProductionCompletion, ProductionCompletionLine, WorkOrderClose, GLEntry, Account, Item.

Next Steps

1. Use Financial Queries, Managerial Queries, or Audit Queries when students need reusable SQL.
2. Use Reports Hub when students need management-style or perspective-led interpretation.
3. Use Cases when students need a guided assignment with required output.