project QadFinancials > class BDInvoice > business logic query GetBankNumberByDInvoiceId
Parameters
| iiCompanyId | integer | Company id |
| iiDInvoiceId | integer | |
query condition
each DInvoice where
DInvoice.Company_Id = iiCompanyId AND
DInvoice.DInvoice_ID = iiDInvoiceId
each DInvoiceBank (inner-join) where
DInvoiceBank.DInvoice_ID = DInvoice.DInvoice_ID AND
first BankNumber (inner-join) where
BankNumber.BankNumber_ID = DInvoiceBank.BankNumber_ID AND
query resultset tqGetBankNumberByDInvoiceId
| field name | data type | db field | description |
|---|
| tcBankNumber | character | BankNumber.BankNumber | Bank Number |
| tiBankNumber_ID | integer | BankNumber.BankNumber_ID | Record ID |
| tiDInvoice_ID | integer | DInvoice.DInvoice_ID | Record ID |
Internal usage
QadFinancials