project QadFinancials > class BBill > business logic query GetDInvoiceByBillID
Parameters
| iiCompanyId | integer | Company id |
| iiBill_Id | integer | |
| ilIsOpen | logical | |
query condition
each Bill where
Bill.Company_Id = iiCompanyId AND
Bill.Bill_ID = iiBill_Id
each DInvoice (inner-join) where
DInvoice.Company_Id = iiCompanyId AND
DInvoice.Bill_ID = Bill.Bill_ID AND
DInvoice.DInvoiceIsOpen = ilIsOpen
query resultset tqGetDInvoiceByBillID
| field name | data type | db field | description |
|---|
| tiBill_ID | integer | Bill.Bill_ID | Record ID |
| tiCompany_ID | integer | DInvoice.Company_ID | Link to Company |
| tiDInvoice_ID | integer | DInvoice.DInvoice_ID | Record ID |
Internal usage
QadFinancials