project QadFinancials > class BCInvoice > business logic query CInvoiceBankForCDocument
Parameters
| iiCInvoiceID | integer | |
| iiCompanyId | integer | Company id |
query condition
each CInvoiceBank where
CInvoiceBank.CInvoice_ID = iiCInvoiceID
first BankNumber1 (inner-join) where
BankNumber1.BankNumber_ID = CInvoiceBank.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 CInvoice (inner-join) where
CInvoice.Company_Id = iiCompanyId AND
CInvoice.CInvoice_ID = CInvoiceBank.CInvoice_ID AND
query resultset tqCInvoiceBankForCDocument
| field name | data type | db field | description |
|---|
| tcBankNumber | character | BankNumber1.BankNumber | Bank Number |
| tiBankNumber_ID | integer | CInvoiceBank.BankNumber_ID | Bank Number |
| tcBankNumberParentType | character | BankNumber2.BankNumberParentType | Type |
| tiBankPayFormat_ID | integer | BankNumber1.BankPayFormat_ID | Link to BankPayFormat |
| tiCInvoice_ID | integer | CInvoiceBank.CInvoice_ID | Link to CInvoice |
| tiCInvoiceBank_ID | integer | CInvoiceBank.CInvoiceBank_ID | Record ID |
| tdCInvoiceBankToPayTC | decimal | CInvoiceBank.CInvoiceBankToPayTC | TC Payment Amount. This field displays the payment amount in the transaction currency. |
| tiCreditor_ID | integer | CInvoice.Creditor_ID | Link to Creditor |
| tcOwnBankNumber | character | BankNumber2.BankNumber | Bank Number |
| tiParentObject_ID | integer | BankNumber2.ParentObject_ID | Parent Object |
| tcPayFormatTypeCode | character | BankPayFormat.PayFormatTypeCode | Payment Format |
Internal usage
QadFinancials