Markup table relationships

I’m trying to understand what kinds of things can carry markups and how the database tables relate. Could someone on-prem run this query for me?

select t.name tbl, c.name col
from sys.tables t
join sys.columns c on t.object_id = c.object_id
where c.name like '%markupid%'

Here you are Kevin ~

tbl col
GlbCustomer MarkUpID
IMPrjMkUp MarkUpID
IMProject MarkUpID
HXProject MarkUpID
IMEQSyst MarkUpID
GlbPrjMkUp GlbMarkUpID
GlbPrjMkUp MarkUpID
PrjMkUp MarkUpID
QMarkUp MarkUpID
IMQMarkUp MarkUpID
IMCustomer MarkUpID
IMGlbQMarkUp GlbMarkUpID
IMGlbQMarkUp MarkUpID
EQSyst MarkUpID
Customer MarkUpID
GlbQMarkUp GlbMarkUpID
GlbQMarkUp MarkUpID
Qmmkup MarkUpID
IMGlbQmmkup GlbMarkUpID
IMGlbQmmkup MarkUpID
IMQmmkup MarkUpID
GlbQmmkup GlbMarkUpID
GlbQmmkup MarkUpID
QuoteQty MarkUpID
Project MarkUpID
IMGlbPrjMkUp GlbMarkUpID
IMGlbPrjMkUp MarkUpID
IMGlbCustomer MarkUpID
IMQuoteQty MarkUpID
IMHXProject MarkUpID
1 Like

Kevin, you can use @hkeric.wci 's .chm solutions to look this up.

[ Download ] Epicor 10.2 & Kinetic .CHM Schema - ERP 10 - Epicor User Help Forum (epiusers.help)

1 Like

You going to be at Insights Kevin?