[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 the respective table like Invoice, or InvoiceLine or Check or Bill or BillItemLine to get full information.
In this example, we will be using the Transaction and BillItemLine table.
In case you want to link it to BillExpenseLine (or any other), you will have to change the table name and field name.
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: