project QadFinancials > class BDInvoice > business logic query DInvoiceMovementIdForBill


Parameters


iiCompanyIdintegerCompany id
iiDebtor_IDinteger
iiCurrency_IDinteger


query condition


  each DInvoiceMovement where
DInvoiceMovement.Company_Id = iiCompanyId AND
DInvoiceMovement.Debtor_ID = iiDebtor_ID

      first DInvoice (inner-join) where
DInvoice.Company_Id = iiCompanyId AND
DInvoice.DInvoice_ID = DInvoiceMovement.DInvoice_ID AND
DInvoice.DInvoiceCurrency_ID = iiCurrency_ID


query sort order


DInvoiceMovement.DInvoiceMovement_ID (descending)


query resultset tqDInvoiceMovementIdForBill


field namedata typedb fielddescription
tiCompany_IDintegerDInvoiceMovement.Company_IDLink to Company
tiDebtor_IDintegerDInvoiceMovement.Debtor_IDLink to Debtor
tiDInvoiceCurrency_IDintegerDInvoice.DInvoiceCurrency_IDCurrency Code
tiDInvoiceMovement_IDintegerDInvoiceMovement.DInvoiceMovement_IDRecord ID


Internal usage


QadFinancials
method BBillReport.BillReportDInvoice