project QadFinancials > class BBankNumber > business logic query BankNumberPayCodeByBankNbrID


Parameters


iiBankNumberIdinteger


query condition


  each BankNumberPayCode where
BankNumberPayCode.BankNumber_ID = iiBankNumberId

      first BankNumber (inner-join) where
BankNumber.BankNumber_ID = BankNumberPayCode.BankNumber_ID AND

          first BankPayFormat (inner-join) where
BankPayFormat.BankPayFormat_ID = BankNumber.BankPayFormat_ID AND

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

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


query resultset tqBankNumberPayCodeByBankNbrID


field namedata typedb fielddescription
tiBankNumber_IDintegerBankNumberPayCode.BankNumber_IDLink to BankNumber
tiBankNumberPayCode_IDintegerBankNumberPayCode.BankNumberPayCode_IDRecord ID
tiBankNumberPayCodeSequenceintegerBankNumberPayCode.BankNumberPayCodeSequenceSequence
tcBankNumberPayCodeValuecharacterBankNumberPayCode.BankNumberPayCodeValueAttribute Value
tcPayFormatCodecharacterPayFormatCode.PayFormatCodeAttribute Value
tiPayFormatCode_IDintegerBankNumberPayCode.PayFormatCode_IDDescription
tcPayFormatCodeDescriptioncharacterPayFormatCode.PayFormatCodeDescriptionDescription
tiPayFormatGroup_IDintegerPayFormatGroup.PayFormatGroup_IDRecord ID
tcPayFormatGroupCodecharacterPayFormatGroup.PayFormatGroupCodeAttribute Name
tcPayFormatGroupDataTypecharacterPayFormatGroup.PayFormatGroupDataTypeData Type
tcPayFormatGroupDescriptioncharacterPayFormatGroup.PayFormatGroupDescriptionDescription
tcPayFormatGroupInputOptioncharacterPayFormatGroup.PayFormatGroupInputOptionInput Option
tlPayFormatGroupIsMandatorylogicalPayFormatGroup.PayFormatGroupIsMandatoryMandatory
tiPayFormatGroupSequenceintegerPayFormatGroup.PayFormatGroupSequenceGroup Code
tcPayFormatTypeCodecharacterBankPayFormat.PayFormatTypeCodePayment Format


Internal usage


QadFinancials
method BCreditor.Calculate
method BDebtor.Calculate
method BDInvoice.UpdateDInvoiceBankNumber
method BPaymentSelection.GetExportGroupCodes