project QadFinancials > class BPaymentSelection > business logic query PaySelLineByPaySelIDCInvoice


Parameters


iiPaySelIDinteger
iiCompanyIdintegerCompany id
iiBankPayFormatIDinteger


query condition


  each PaySelLine where
PaySelLine.PaySel_ID = iiPaySelID

      first CInvoice (inner-join) where
CInvoice.Company_Id = iiCompanyId AND
CInvoice.CInvoice_ID = PaySelLine.PaySelLineParentObject_ID AND

          first Creditor (inner-join) where
Creditor.SharedSet_Id = vi_CREDITOR_sharedset(iiCompanyId) AND
Creditor.Creditor_ID = CInvoice.Creditor_ID AND

              each BankNumber (inner-join) where
BankNumber.ParentObject_ID = Creditor.Creditor_ID AND
BankNumber.BankPayFormat_ID = iiBankPayFormatID


query resultset tqPaySelLineByPaySelIDCInvoice


field namedata typedb fielddescription
tcBankNumbercharacterBankNumber.BankNumberBank Number
tiBankNumber_IDintegerBankNumber.BankNumber_IDRecord ID
tcBankNumberExtensioncharacterBankNumber.BankNumberExtensionBank Extension
tlBankNumberIsActivelogicalBankNumber.BankNumberIsActiveActive
tcBankNumberValidationcharacterBankNumber.BankNumberValidationValidation
tiBankPayFormat_IDintegerBankNumber.BankPayFormat_IDLink to BankPayFormat
tiCreditor_IDintegerCreditor.Creditor_IDRecord ID
tiPaySel_IDintegerPaySelLine.PaySel_IDLink to PaySel
tiPaySelLine_IDintegerPaySelLine.PaySelLine_IDRecord ID
tcPaySelLineObjectTypecharacterPaySelLine.PaySelLineObjectTypeType
tiPaySelLineParentObject_IDintegerPaySelLine.PaySelLineParentObject_IDParent Object


Internal usage


QadFinancials
method BPaymentSelection.ValidateComponentPreBankPayFormat