project QadFinancials > class BBill > business logic query GetBillByPrintFilter
Description
Query used by BBillReport, seach bill according to Bill Report Print Filter
Parameters
| iiCompanyId | integer | Company id |
| icCurrencyCode | character | |
| icDebtorCode | character | |
| iiBillYear | integer | |
| itBillDateFrom | date | |
| itBillDateTo | date | |
| iiBillNumberFrom | integer | |
| iiBillNumberTo | integer | |
| iiEmployeeID | integer | |
| icBillStatus | character | |
query condition
each Bill where
Bill.Company_Id = iiCompanyId AND
Bill.BillYear = iiBillYear AND
Bill.BillDate >= itBillDateFrom AND
Bill.BillDate <= itBillDateTo AND
Bill.BillNumber >= iiBillNumberFrom AND
Bill.BillNumber <= iiBillNumberTo AND
Bill.Employee_ID = iiEmployeeID AND
Bill.BillStatus can-do icBillStatus
first Currency (inner-join) where
Currency.Currency_ID = Bill.Currency_ID AND
Currency.CurrencyCode = icCurrencyCode
first Debtor (inner-join) where
Debtor.SharedSet_Id = vi_DEBTOR_sharedset(iiCompanyId) AND
Debtor.Debtor_ID = Bill.Debtor_ID AND
Debtor.DebtorCode can-do icDebtorCode
query sort order
Bill.Bill_ID (ascending)
query resultset tqGetBillByPrintFilter
| field name | data type | db field | description |
|---|
| tiBill_ID | integer | Bill.Bill_ID | Record ID |
| tdBillClosingBalanceTC | decimal | Bill.BillClosingBalanceTC | TC Closing Balance |
| ttBillConfirmDate | date | Bill.BillConfirmDate | Bill Confirm Date |
| ttBillDate | date | Bill.BillDate | Bill Date |
| ttBillDueDate | date | Bill.BillDueDate | Bill Due Date |
| tiBillNumber | integer | Bill.BillNumber | Bill Number |
| tcBillStatus | character | Bill.BillStatus | Status |
| tiBillYear | integer | Bill.BillYear | Bill Year |
| tiCompany_ID | integer | Bill.Company_ID | Link to Company |
| tiCurrency_ID | integer | Bill.Currency_ID | Link to Currency |
| tcCurrencyCode | character | Currency.CurrencyCode | Currency Code |
| tiDebtor_ID | integer | Bill.Debtor_ID | Link to Debtor |
| tiDInvoiceMovement_ID | integer | Bill.DInvoiceMovement_ID | Link to highest DInvoiceMovement |
| tiEmployee_ID | integer | Bill.Employee_ID | Link to Employee |
Internal usage
QadFinancials