| Previous topic :: Next topic |
| Author |
Message |
stuart.elvish
Joined: 26 Mar 2008
Posts: 5
Location: Melbourne, Australia
|
| Posted: Fri Jun 13, 2008 4:12 am Post subject: How do I access quote details from SQL database? |
|
|
Hi. I am building a PHP script to extract quote details from the vtiger database and show (via a formatted web page) the details of the quotation. (The project is based around a customer portal concept.)
The only problem is that I can't find the table which links the quote number (for example 148) with any of the products on that quote.
Could someone please tell me where I can find the specific details of the products included on a quote? I specifically need to know the table name as I haven't found it yet.
Thanks. |
|
| Back to top |
|
Asha
Joined: 31 Jul 2007
Posts: 300
|
| Posted: Fri Jun 13, 2008 1:15 pm Post subject: Re: How do I access quote details from SQL database? |
|
|
Hi,
stuart.elvish wrote:
Could someone please tell me where I can find the specific details of the products included on a quote? I specifically need to know the table name as I haven't found it yet.
Please refer to the table vtiger_inventoryproductrel. That has the relationship between the Invoice/Quote/SO/PO and the products. |
|
| Back to top |
|
| |
