project QadFinancials > class BBill > business logic query GetBillByPrintFilter

Description

Query used by BBillReport, seach bill according to Bill Report Print Filter


Parameters


iiCompanyIdintegerCompany id
icCurrencyCodecharacter
icDebtorCodecharacter
iiBillYearinteger
itBillDateFromdate
itBillDateTodate
iiBillNumberFrominteger
iiBillNumberTointeger
iiEmployeeIDinteger
icBillStatuscharacter


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 namedata typedb fielddescription
tiBill_IDintegerBill.Bill_IDRecord ID
tdBillClosingBalanceTCdecimalBill.BillClosingBalanceTCTC Closing Balance
ttBillConfirmDatedateBill.BillConfirmDateBill Confirm Date
ttBillDatedateBill.BillDateBill Date
ttBillDueDatedateBill.BillDueDateBill Due Date
tiBillNumberintegerBill.BillNumberBill Number
tcBillStatuscharacterBill.BillStatusStatus
tiBillYearintegerBill.BillYearBill Year
tiCompany_IDintegerBill.Company_IDLink to Company
tiCurrency_IDintegerBill.Currency_IDLink to Currency
tcCurrencyCodecharacterCurrency.CurrencyCodeCurrency Code
tiDebtor_IDintegerBill.Debtor_IDLink to Debtor
tiDInvoiceMovement_IDintegerBill.DInvoiceMovement_IDLink to highest DInvoiceMovement
tiEmployee_IDintegerBill.Employee_IDLink to Employee


Internal usage


QadFinancials
method BBillReport.BillReportDInvoice