Table for BAQs in E9?

Epicor ERP 9
1

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

2

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

3

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

4

Thank you Calvin,

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

5

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

Shows:

image

this pane updates as different form controls are given focus

6

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

7

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’)

8

E10 has no table “Exports”

9

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

1 Like
10

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

11

But it currently is morning :wink:

12

It is in the US!
Not in the UK!

1 Like