# ERP SQL Query Catalog Worksheet

> Source: https://netray.co/tools/erp-sql-query-catalog-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

An editable inventory of the queries and reports your team runs, with owner, frequency, runtime and monthly effort.

## Category

developer

## Audience

- ERP analyst
- Database administrator
- IT manager

## Tool

**Kind:** worksheet

**Mode:** editable

**Columns:**

#### Query or report

**Key:** name

**Type:** text

#### Purpose

**Key:** purpose

**Type:** text

#### Type

**Key:** kind_

**Type:** select

**Options:**

- Ad hoc SQL
- Stored procedure
- ERP report
- Excel with query
- BI dashboard

#### Owner

**Key:** owner

**Type:** text

#### Runs per month

**Key:** runs

**Type:** number

#### Minutes per run

**Key:** minutes

**Type:** number

**Unit:** min

#### Hours per month

**Key:** hours

**Type:** number

**Expr:** runs * minutes / 60

**Format:** decimal

#### Last reviewed

**Key:** reviewed

**Type:** date

**Rows:**

#### Open PO lines past due

**Purpose:** Weekly supplier expediting

**Kind :** Ad hoc SQL

**Owner:** Buyer team

**Runs:** 4

**Minutes:** 25

**Reviewed:** 2026-08-12

#### Inventory aging by site

**Purpose:** Month end reserve review

**Kind :** Stored procedure

**Owner:** Finance

**Runs:** 1

**Minutes:** 90

**Reviewed:** 2026-09-30

#### Daily shipments

**Purpose:** Shipping manager dashboard

**Kind :** BI dashboard

**Owner:** Logistics

**Runs:** 22

**Minutes:** 5

**Reviewed:** 2026-06-03

#### Customer backlog by week

**Purpose:** Sales and operations meeting

**Kind :** Excel with query

**Owner:** Planning

**Runs:** 4

**Minutes:** 45

**Reviewed:** 2026-07-21

#### Scrap by work center

**Purpose:** Quality review

**Kind :** ERP report

**Owner:** Quality

**Runs:** 4

**Minutes:** 30

**Reviewed:** 2025-11-10

**Totals:**

#### Total hours per month

**Key:** hours

**Agg:** sum

**Format:** decimal

#### Total runs per month

**Key:** runs

**Agg:** sum

**Format:** integer

**Summary:**

#### Average hours per query

**Key:** avg_hours

**Expr:** sum_hours / count

**Format:** decimal

#### Annualized hours

**Key:** annual_hours

**Expr:** sum_hours * 12

**Format:** decimal

**Primary:** true

**Notes:** Runtime here means the person time to run, refresh and check the output, not only database execution time. Sort by hours to find the best candidates for automation or retirement.

## Content

**Intro:** Most ERP teams cannot say how many queries they own, who runs them or what they cost in time. This worksheet builds that inventory and ranks queries by effort.

**Sections:**

#### How to use the catalog

**Body:** List every query, report and spreadsheet that pulls ERP data, including the ones that live on someone's desktop. Capture who owns it, how often it is run and how many minutes a run takes from start to usable output. The worksheet computes hours per month for each row and the annualized total.

#### Reading the result

**Body:** Hours per month equals runs times minutes divided by 60. A 90 minute month end query run once is 1.5 hours a month, while a 5 minute daily dashboard refresh run 22 times is about 1.8 hours. Sort by hours and look at the top five: these are candidates to automate with a scheduled job, to simplify, or to replace with a self service view.

**Bullets:**

- High hours, high frequency: automate first
- Old review date: confirm it is still needed
- No owner: assign one or retire it
- Duplicates of the same logic: consolidate

#### Governance benefits

**Body:** A catalog exposes logic that exists in five slightly different versions, queries pointing at retired tables and numbers that disagree between reports. It also helps in migrations: you know what must be rebuilt on the new platform and what can be left behind. Keep the review date current and revisit at least twice a year.

#### Common mistakes

**Body:** People record only database runtime and miss the manual work around it, such as copying results into Excel and formatting. Others list only official reports and ignore personal scripts. Both hide most of the real effort. Be honest and include the manual steps in the minutes figure.

**Cta:** If the top rows of your catalog are manual weekly pulls, we can discuss replacing them with governed, read-only natural language queries over your ERP data.

**Faq:**

#### What counts as a query for this catalog?

**Answer:** Any repeatable way you get data from the ERP: SQL scripts, stored procedures, ERP reports, Excel files with data connections and BI dashboards. Include the ones that only one person knows how to run.

#### How do I estimate minutes per run?

**Answer:** Time a typical run from opening the tool to a checked, usable result. Include refresh waits and manual formatting. Use an average, and note that month end runs are often longer than normal weeks.

#### How often should the catalog be reviewed?

**Answer:** Review twice a year, and after an ERP upgrade or migration. Anything not reviewed in 12 months is a candidate for retirement or confirmation by its owner.

#### Can I export it to share?

**Answer:** Yes. Export to Excel or CSV and keep it on your team site. Treat it as a living document and name an owner for the catalog itself.

## Search terms

sql query inventory template, report inventory template excel, erp report catalog, sql script library template, query documentation template, report rationalization worksheet, erp report inventory

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json