View Full Version : Data Dictionary


04-03-2009, 06:08 PM
Is there a Data Dictionary available that shows the relationship of the various keys ?, I am specifically looking for a way to join InvoiceLine with BillItemLine
to show items billed (Invoiced) to the corresponding Purchase Order line that the items were purchased. I have joined InvoiceLine to BillItemLine on the InvoiceLineItemRefFullName. Thanks, Larry

Al Buchholz
04-03-2009, 06:15 PM

Are you purchasing product and then using the invoice generation to pull the purchasing information into the invoice?

You'll need to look at the linked transaction tables to see the relationship between the po and invoice.

04-03-2009, 06:21 PM
I have been all over almost every table in the system and compared the data in the tables (via odbc and MS Access)
I cannot find a good link between the two events.
without some kind of explanation of where the various link keys point
I can't seem to get the relationships to work


Al Buchholz
04-03-2009, 06:53 PM
Those relationships are some of the more complex ones..

The QODBC site has additional information including



There is also a search available for the site to get more info.

Essentially the field FQPrimaryKey is a composite of some of the listids, so you'll need to get the value pulled out of there and link from the bill to invoice or invoice to bill...

04-03-2009, 07:06 PM
Thanks for your help, the documentation links do show some of the table link information I was looking for

Thanks again for your help