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