project QadFinancials > class BDInvoice > business logic query DInvoiceBankPayCodeByDIBankID


Parameters


icPayFormatGroupLevelcharacter
iiDInvoiceIdinteger
iiBankNumberIdinteger


query condition


  each DInvoiceBank where
DInvoiceBank.DInvoice_ID = iiDInvoiceId AND
DInvoiceBank.BankNumber_ID = iiBankNumberId

      each DInvoiceBankPayCode (conditional-join) where
DInvoiceBankPayCode.DInvoiceBank_ID = DInvoiceBank.DInvoiceBank_ID AND

          first PayFormatGroup (conditional-join) where
PayFormatGroup.PayFormatGroup_ID = DInvoiceBankPayCode.PayFormatGroup_ID AND
PayFormatGroup.PayFormatGroupLevel = icPayFormatGroupLevel


query resultset tqDInvoiceBankPayCodeByDIBankID


field namedata typedb fielddescription
tiBankNumber_IDintegerDInvoiceBank.BankNumber_IDFormatted Bank Account No
tiDInvoice_IDintegerDInvoiceBank.DInvoice_IDLink to DInvoice
tiDInvoiceBank_IDintegerDInvoiceBank.DInvoiceBank_IDRecord ID
tiDInvoiceBankPayCode_IDintegerDInvoiceBankPayCode.DInvoiceBankPayCode_IDRecord ID
tcDInvoiceBankPayCodeValuecharacterDInvoiceBankPayCode.DInvoiceBankPayCodeValueAttribute Value.The value of 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.
tiPayFormatCode_IDintegerDInvoiceBankPayCode.PayFormatCode_IDLink to PayFormatCode
tiPayFormatGroup_IDintegerDInvoiceBankPayCode.PayFormatGroup_IDLink to PayFormatGroup
tcPayFormatGroupCodecharacterPayFormatGroup.PayFormatGroupCodeAttribute Name
tcPayFormatGroupLevelcharacterPayFormatGroup.PayFormatGroupLevelLevel
tcPayFormatTypeCodecharacterPayFormatGroup.PayFormatTypeCodePayment Format Type


Internal usage


QadFinancials
method BCDocument.ValidateComponentPost
method BDCollection.FillProDataSet
method BDCollectionReport.DCollectionReport
method BDPaymentSelection.AdditionalUpdatesDDocument