project QadFinancials > class BPaymentSelectionReport > business logic query CInvoiceBankAttributes


Parameters


iiCInvoiceIDinteger
iiBankNumberIDinteger


query condition


  each CInvoiceBank where
CInvoiceBank.BankNumber_ID = iiBankNumberID AND
CInvoiceBank.CInvoice_ID = iiCInvoiceID

      each CInvoiceBankPayCode (inner-join) where
CInvoiceBankPayCode.CInvoiceBank_ID = CInvoiceBank.CInvoiceBank_ID AND

          first PayFormatCode (conditional-join) where
PayFormatCode.PayFormatCode_ID = CInvoiceBankPayCode.PayFormatCode_ID AND

          first PayFormatGroup (inner-join) where
PayFormatGroup.PayFormatGroup_ID = CInvoiceBankPayCode.PayFormatGroup_ID AND


query resultset tqCInvoiceBankAttributes


field namedata typedb fielddescription
tiBankNumber_IDintegerCInvoiceBank.BankNumber_IDBank Number
tiCInvoiceBank_IDintegerCInvoiceBank.CInvoiceBank_IDRecord ID
tcCInvoiceBankPayCodeValuecharacterCInvoiceBankPayCode.CInvoiceBankPayCodeValueAttribute Value. A new attribute of the payment Format.
This field is added by the user for bank payment.
api annotation:This field defaults from the value user set in the payment maintance.
tcPayFormatCodecharacterPayFormatCode.PayFormatCodeAttribute Value
tiPayFormatCode_IDintegerCInvoiceBankPayCode.PayFormatCode_IDLink to PayFormatCode
tiPayFormatGroup_IDintegerCInvoiceBankPayCode.PayFormatGroup_IDLink to PayFormatGroup
tcPayFormatGroupCodecharacterPayFormatGroup.PayFormatGroupCodeAttribute Name


Internal usage


QadFinancials
method BPaymentSelectionReport.Paylist