# Table for BAQs in E9?

**URL:** <https://www.epiusers.help/t/table-for-baqs-in-e9/47715>\
**Category:** Epicor ERP 9\
**Created:** [September 12, 2018, 2:21pm UTC](https://www.epiusers.help/t/table-for-baqs-in-e9/47715 "2018-09-12T14:21:13Z")\
**Posts on this page:** 12\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rowley150](https://www.epiusers.help/user_avatar/www.epiusers.help/rowley150/32/15051_2.png) [@Rowley150](https://www.epiusers.help/u/Rowley150)\
**Post date:** [September 12, 2018, 2:21pm UTC](https://www.epiusers.help/t/table-for-baqs-in-e9/47715/1 "2018-09-12T14:21:13Z")

</div>

**Epicor 9.05.701**

Is there a table of BAQs in 9.05.701 that shows

- BAQ ID

- BAQ Description

- Author (User ID of who wrote it)

- If the BAQ is in use…(i.e used in a crystal report, or dashboard etc)

Many thanks in advance.

**UPDATE:** I think the table “Exports” holds some of it

---

<div class="post-metadata">

**Author:** ![ckrusen](https://www.epiusers.help/user_avatar/www.epiusers.help/ckrusen/32/50584_2.png) [@ckrusen](https://www.epiusers.help/u/ckrusen)\
**Post date:** [September 12, 2018, 2:33pm UTC](https://www.epiusers.help/t/table-for-baqs-in-e9/47715/2 "2018-09-12T14:33:26Z")

</div>

QueryHdr has all but “in use” A join to BAQ reports and dashboards could tell that

---

<div class="post-metadata">

**Author:** ![ckrusen](https://www.epiusers.help/user_avatar/www.epiusers.help/ckrusen/32/50584_2.png) [@ckrusen](https://www.epiusers.help/u/ckrusen)\
**Post date:** [September 12, 2018, 2:35pm UTC](https://www.epiusers.help/t/table-for-baqs-in-e9/47715/3 "2018-09-12T14:35:57Z")

</div>

DashBdBAQ for BAQs used by dashboards  
BAQReport for BAQs used by … you guessed it! BAQ Reports

---

<div class="post-metadata">

**Author:** ![Rowley150](https://www.epiusers.help/user_avatar/www.epiusers.help/rowley150/32/15051_2.png) [@Rowley150](https://www.epiusers.help/u/Rowley150)\
**Post date:** [September 12, 2018, 2:38pm UTC](https://www.epiusers.help/t/table-for-baqs-in-e9/47715/4 "2018-09-12T14:38:09Z")

</div>

Thank you Calvin,

The only table i don’t have is QueryHdr, …maybe thats an E10 table?

---

<div class="post-metadata">

**Author:** ![ckrusen](https://www.epiusers.help/user_avatar/www.epiusers.help/ckrusen/32/50584_2.png) [@ckrusen](https://www.epiusers.help/u/ckrusen)\
**Post date:** [September 12, 2018, 2:42pm UTC](https://www.epiusers.help/t/table-for-baqs-in-e9/47715/5 "2018-09-12T14:42:42Z")

</div>

Maybe. I’m going off of E10 -which \> 90% of tables are the same since V8.

Does E9 have the ability to show field details right in the form?  
 ![image](https://epiusers.help/uploads/default/original/2X/0/04e9357ee88c462bc300f8a92dab7dd1d3ea94df.png)

Shows:

![image](https://epiusers.help/uploads/default/original/2X/e/e437e81328d7eb2743f734f7fd3b27ba4ebe99f2.png)

this pane updates as different form controls are given focus

---

<div class="post-metadata">

**Author:** ![Rowley150](https://www.epiusers.help/user_avatar/www.epiusers.help/rowley150/32/15051_2.png) [@Rowley150](https://www.epiusers.help/u/Rowley150)\
**Post date:** [September 12, 2018, 2:44pm UTC](https://www.epiusers.help/t/table-for-baqs-in-e9/47715/6 "2018-09-12T14:44:09Z")

</div>

Hi Calvin,  
It does - the table for E9 appears to be “Exports”

---

<div class="post-metadata">

**Author:** ![ckrusen](https://www.epiusers.help/user_avatar/www.epiusers.help/ckrusen/32/50584_2.png) [@ckrusen](https://www.epiusers.help/u/ckrusen)\
**Post date:** [September 12, 2018, 2:44pm UTC](https://www.epiusers.help/t/table-for-baqs-in-e9/47715/7 "2018-09-12T14:44:12Z")

</div>

Another “trick” (albeit a painful one) is to export the Data Dictionary to a PDF. Then search for tables with the same field name (i.e. ‘QueryID’)

---

<div class="post-metadata">

**Author:** ![ckrusen](https://www.epiusers.help/user_avatar/www.epiusers.help/ckrusen/32/50584_2.png) [@ckrusen](https://www.epiusers.help/u/ckrusen)\
**Post date:** [September 12, 2018, 2:45pm UTC](https://www.epiusers.help/t/table-for-baqs-in-e9/47715/8 "2018-09-12T14:45:01Z")

</div>

E10 has no table “Exports”

---

<div class="post-metadata">

**Author:** ![ckrusen](https://www.epiusers.help/user_avatar/www.epiusers.help/ckrusen/32/50584_2.png) [@ckrusen](https://www.epiusers.help/u/ckrusen)\
**Post date:** [September 12, 2018, 3:00pm UTC](https://www.epiusers.help/t/table-for-baqs-in-e9/47715/9 "2018-09-12T15:00:23Z")

</div>

I have a PDF of the V8 Dictionary, and it uses “Exports” as well.

ExportID is referenced in the following tables:  
BAQReport  
Exports  
MfgCube  
PerfSet  
QueryCalcF  
QueryField  
QueryLikeR  
QueryRelat  
QuerySortB  
QueryTable  
QueryWhere

---

<div class="post-metadata">

**Author:** ![Rowley150](https://www.epiusers.help/user_avatar/www.epiusers.help/rowley150/32/15051_2.png) [@Rowley150](https://www.epiusers.help/u/Rowley150)\
**Post date:** [September 12, 2018, 3:03pm UTC](https://www.epiusers.help/t/table-for-baqs-in-e9/47715/10 "2018-09-12T15:03:15Z")

</div>

thank you, i’ll get back on this again in the morning.

---

<div class="post-metadata">

**Author:** ![ckrusen](https://www.epiusers.help/user_avatar/www.epiusers.help/ckrusen/32/50584_2.png) [@ckrusen](https://www.epiusers.help/u/ckrusen)\
**Post date:** [September 12, 2018, 3:10pm UTC](https://www.epiusers.help/t/table-for-baqs-in-e9/47715/11 "2018-09-12T15:10:13Z")

</div>

But it currently is morning 😉

---

<div class="post-metadata">

**Author:** ![Rowley150](https://www.epiusers.help/user_avatar/www.epiusers.help/rowley150/32/15051_2.png) [@Rowley150](https://www.epiusers.help/u/Rowley150)\
**Post date:** [September 12, 2018, 3:16pm UTC](https://www.epiusers.help/t/table-for-baqs-in-e9/47715/12 "2018-09-12T15:16:01Z")

</div>

It is in the US!  
Not in the UK!