project QadFinancials > class BCInvoice > business logic query CInvoiceBankForCDocument


Parameters


iiCInvoiceIDinteger
iiCompanyIdintegerCompany 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 namedata typedb fielddescription
tcBankNumbercharacterBankNumber1.BankNumberBank Number
tiBankNumber_IDintegerCInvoiceBank.BankNumber_IDBank Number
tcBankNumberParentTypecharacterBankNumber2.BankNumberParentTypeType
tiBankPayFormat_IDintegerBankNumber1.BankPayFormat_IDLink to BankPayFormat
tiCInvoice_IDintegerCInvoiceBank.CInvoice_IDLink to CInvoice
tiCInvoiceBank_IDintegerCInvoiceBank.CInvoiceBank_IDRecord ID
tdCInvoiceBankToPayTCdecimalCInvoiceBank.CInvoiceBankToPayTCTC Payment Amount. This field displays the payment amount in the transaction currency.
tiCreditor_IDintegerCInvoice.Creditor_IDLink to Creditor
tcOwnBankNumbercharacterBankNumber2.BankNumberBank Number
tiParentObject_IDintegerBankNumber2.ParentObject_IDParent Object
tcPayFormatTypeCodecharacterBankPayFormat.PayFormatTypeCodePayment Format


Internal usage


QadFinancials
method BCDocument.ValidateComponentPreCInvoice
method BCDocumentReport.CDocumentReportAllCreate