[QODBC-Desktop] How to link Class information from Transaction and Bill
Posted by Wilson (QODBC Support) on 14 February 2012 06:30 AM
Find the transaction related Class information
How to link Class information from Transaction and Bill
Table Transaction in QODBC shows summary information of all transaction. But it doesn't contain Class information. You could use TxnID field in Transaction table to link to table Bill and BillItemLine to get full information.
Use Transaction.TxnID to link to Bill and BillItemLine Tables.
Fields TxnID and TxnLineID in table Transaction refer to Bill header record and Bill line item record:
With the value of TxnID and TxnLineID, we could simply find the Bill header and line item record.
Get Class Information from BillItemLine
We can find the related Class information via field ItemLineClassRefListID. This field directly links to the record in Class Table. Please note down the List ID in field ItemLineClassRefListID.
Here is the related class information in Class table with the same List ID: