project QadFinancials > class BDInvoice > business logic query DInvoiceBankForDDocument
Parameters
| iiDInvoiceId | integer | Debtor Invoice ID |
| iiCompanyId | integer | Company id |
query condition
each DInvoiceBank where
DInvoiceBank.DInvoice_ID = iiDInvoiceId
first BankNumber1 (inner-join) where
BankNumber1.BankNumber_ID = DInvoiceBank.BankNumber_ID AND
first BankPayFormat (inner-join) where
BankPayFormat.BankPayFormat_ID = BankNumber1.BankPayFormat_ID AND
first BankNumber2 (inner-join) where
BankNumber2.BankNumber_ID = BankPayFormat.BankNumber_ID AND
first DInvoice (inner-join) where
DInvoice.Company_Id = iiCompanyId AND
DInvoice.DInvoice_ID = DInvoiceBank.DInvoice_ID AND
query resultset tqDInvoiceBankForDDocument
| field name | data type | db field | description |
|---|
| tcBankNumber | character | BankNumber1.BankNumber | Bank Number |
| tiBankNumber_ID | integer | DInvoiceBank.BankNumber_ID | Formatted Bank Account No |
| tiBankPayFormat_ID | integer | BankNumber1.BankPayFormat_ID | Link to BankPayFormat |
| tiDebtor_ID | integer | DInvoice.Debtor_ID | Link to Debtor |
| tiDInvoice_ID | integer | DInvoiceBank.DInvoice_ID | Link to DInvoice |
| tiDInvoiceBank_ID | integer | DInvoiceBank.DInvoiceBank_ID | Record ID |
| tdDInvoiceBankToPayTC | decimal | DInvoiceBank.DInvoiceBankToPayTC | TC Payment Amount. This field displays the payment amount in the transaction currency. |
| tcOwnBankNumber | character | BankNumber2.BankNumber | Bank Number |
| tcPayFormatTypeCode | character | BankPayFormat.PayFormatTypeCode | Payment Format |
Internal usage
QadFinancials