project QadFinancials > class BBill > business logic query GetConfirmedBillAfterBillDate
Parameters
| iiCompanyId | integer | Company id |
| icDebtorCode | character | |
| icCurrencyCode | character | |
| itBillDate | date | |
| icBillStatus | character | |
| iiDInvoiceCompanyId | integer | |
| iiBillYear | integer | |
query condition
each Bill where
Bill.Company_Id = iiCompanyId AND
Bill.BillDate >= itBillDate AND
Bill.BillStatus = icBillStatus AND
Bill.BillYear = iiBillYear
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 = icDebtorCode
each DInvoice (inner-join) where
DInvoice.Bill_ID = Bill.Bill_ID AND
DInvoice.Company_ID = iiDInvoiceCompanyId
query resultset tqGetConfirmedBillAfterBillDate
| field name | data type | db field | description |
|---|
| tiBill_ID | integer | Bill.Bill_ID | Record ID |
| ttBillConfirmDate | date | Bill.BillConfirmDate | Bill Confirm Date |
| ttBillDate | date | Bill.BillDate | Bill Date |
| tiBillNumber | integer | Bill.BillNumber | Bill Number |
| tcBillStatus | character | Bill.BillStatus | Status |
| tiBillYear | integer | Bill.BillYear | Bill Year |
| tiDInvoice_ID | integer | DInvoice.DInvoice_ID | Record ID |
Internal usage
QadFinancials