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