PDA

View Full Version : Data Dictionary


ABC123

lreed
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
Larry

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.

lreed
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

Thanks,

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

The QODBC site has additional information including

http://doc.qodbc.com/qodbc/Qodbc_20_us.html

http://doc.qodbc.com/qodbc/20/tables/table_detail_usc446.html?details_id=5&tn_us=TRUE

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...

lreed
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