project QadFinancials > class BBankNumber > business logic query BankNumberPayCodeForCIDefSupp

Parameters


iiBankNumberIdinteger

query condition


  each BankNumberPayCode where
BankNumberPayCode.BankNumber_ID = iiBankNumberId

      first PayFormatCode (outer-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 tqBankNumberPayCodeForCIDefSupp


field namedata typedb fielddescription
tiBankNumber_IDintegerBankNumberPayCode.BankNumber_IDLink to BankNumber
tcBankNumberPayCodeValuecharacterBankNumberPayCode.BankNumberPayCodeValueAttribute Value
tcPayFormatCodecharacterPayFormatCode.PayFormatCodeAttribute Value
tiPayFormatCode_IDintegerPayFormatCode.PayFormatCode_IDRecord ID
tiPayFormatCode_ID1integerBankNumberPayCode.PayFormatCode_IDDescription
tcPayFormatCodeDescriptioncharacterPayFormatCode.PayFormatCodeDescriptionDescription
tiPayFormatGroup_IDintegerPayFormatGroup.PayFormatGroup_IDRecord ID
tiPayFormatGroup_ID1integerPayFormatCode.PayFormatGroup_IDPayment Format Type
tcPayFormatGroupCodecharacterPayFormatGroup.PayFormatGroupCodeAttribute Name
tcPayFormatGroupDataTypecharacterPayFormatGroup.PayFormatGroupDataTypeData Type
tcPayFormatGroupDescriptioncharacterPayFormatGroup.PayFormatGroupDescriptionDescription
tcPayFormatGroupInputOptioncharacterPayFormatGroup.PayFormatGroupInputOptionInput Option
tlPayFormatGroupIsMandatorylogicalPayFormatGroup.PayFormatGroupIsMandatoryMandatory

Internal usage


QadFinancials
method BCInvoice.CreateCInvoices
method BCInvoice.DefaultValuesBankCreateCIBankPayCode
method BCInvoiceJournalEntry.ApiStdMaintainTTValidationsAndDef