SQL Table Relationships? : QuoteWerks Support Portal

How can we help you today?

Start a new topic

SQL Table Relationships?

Amy Ragatz

started a topic almost 7 years ago

Hello -

Has anyone come across any documentation that lists the table relationships for the database and how some of the main tables can be joined?

We are looking to do some internal reporting, but want to make sure we are properly joining tables.

Thanks

Amy

1 Comment

Steve Siggs

said almost 7 years ago

I'm not aware of any formal documentation but most of the table structures are pretty straightforward... DocumentItems.DocID >> DocumentHeaders.ID, DocumentItems.ManufacturerPartNumber >> Products.ManufacturerPartNumber , etc.

If there's a relationship that you are not sure about or if there's some particular BI report you want to get out of QuoteWerks, then please post details and I'll try to advise.