project QadFinancials > class BBankNumber > business logic query BankNumberPayCodeForCIDef


Parameters


iiBankNumberIdinteger


query condition


  each BankNumberPayCode where
BankNumberPayCode.BankNumber_ID = iiBankNumberId

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

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


query resultset tqBankNumberPayCodeForCIDef


field namedata typedb fielddescription
tiBankNumber_IDintegerBankNumberPayCode.BankNumber_IDLink to BankNumber
tcBankNumberPayCodeValuecharacterBankNumberPayCode.BankNumberPayCodeValueAttribute Value
tcPayFormatCodecharacterPayFormatCode.PayFormatCodeAttribute Value
tiPayFormatCode_IDintegerBankNumberPayCode.PayFormatCode_IDDescription
tiPayFormatCode_ID1integerPayFormatCode.PayFormatCode_IDRecord ID
tcPayFormatCodeDescriptioncharacterPayFormatCode.PayFormatCodeDescriptionDescription
tiPayFormatGroup_ID1integerPayFormatCode.PayFormatGroup_IDPayment Format Type
tcPayFormatGroupCodecharacterPayFormatGroup.PayFormatGroupCodeAttribute Name
tcPayFormatGroupDataTypecharacterPayFormatGroup.PayFormatGroupDataTypeData Type
tcPayFormatGroupDescriptioncharacterPayFormatGroup.PayFormatGroupDescriptionDescription
tcPayFormatGroupInputOptioncharacterPayFormatGroup.PayFormatGroupInputOptionInput Option
tlPayFormatGroupIsMandatorylogicalPayFormatGroup.PayFormatGroupIsMandatoryMandatory
tcPayFormatGroupLevelcharacterPayFormatGroup.PayFormatGroupLevelLevel
tcPayFormatTypeCodecharacterPayFormatGroup.PayFormatTypeCodePayment Format Type


Internal usage


QadFinancials
method BCInvoice.DefaultValuesBankCreateCIBankPayCode1
method BDInvoice.CreateDIBankPayCode
method BDInvoiceJournalEntry.CreateDIBankPayCodeDIJE
method BPaymentSelection.GetInvWithCommonPayAttributes