project QadFinancials > class BDInvoice > business logic query DInvoiceMovementIdForBill
Parameters
| iiCompanyId | integer | Company id |
| iiDebtor_ID | integer | |
| iiCurrency_ID | integer | |
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 name | data type | db field | description |
|---|
| tiCompany_ID | integer | DInvoiceMovement.Company_ID | Link to Company |
| tiDebtor_ID | integer | DInvoiceMovement.Debtor_ID | Link to Debtor |
| tiDInvoiceCurrency_ID | integer | DInvoice.DInvoiceCurrency_ID | Currency Code |
| tiDInvoiceMovement_ID | integer | DInvoiceMovement.DInvoiceMovement_ID | Record ID |
Internal usage
QadFinancials