[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 Transactions and Bill
Table Transaction in QODBC shows summary information of all transactions. But it doesn't contain Class information. You could use the TxnID field in the Transaction table to link to the respective table, like Invoice, InvoiceLine, or Check or Bill or BillItemLine, to get full information.
In this example, we will be using the Transaction and BillItemLine table.
You will have to change the table and field names if you want to link it to BillExpenseLine (or any other).
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 find the Bill header and line item record.
Get Class Information from BillItemLine
We can find the related Class information via the field ItemLineClassRefListID. This field directly links to the record in Class Table. Please note down the List ID in the field ItemLineClassRefListID.
Here is the related class information in the Class table with the same List ID: