TranGLC HeadNum -> Mapping?

Epicor ERP 10
1

I am writing some queries to extract details from the TranGLC table and am not sure I understand what exactly HeadNum points to.

I understand each series of Key1…Key5 maps to a different table/field depending on the RelatedToFile value - and I have a spreadsheet that has been passed around outlining that mapping.

But the HeadNum I am not sure about.

Does it point to CashHead.HeadNum?

Or does it point to CheckHed.HeadNum?

Or does the HeadNum table referenced depend on the value of RelatedToFile?

-Dean

2

Maybe I’m an idiot…

I assume RelatedToFile ALWAYS references a tablename, and if HeadNum is defined, it refers to the column of THAT table?

So…

[RelatedToFile].[HeadNum]

Correct?

3

I believe you are correct. HeadNum is not part of my TranGLC table (at least not that I see in BAQ Designer).

So, I’m assuming (for example):

TranGLC_RelatedToFile = CashHead
TranGLC_Key1 = HeadNum