Knowledgebase
[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

Instructions

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:

 

(10 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).