project QadFinancials > class BPaymentSelection > business logic query PaySelLineByPaySelIDDInvoice


Parameters


iiCompanyIdintegerCompany id
iiBankPayFormatIDinteger
iiPaySelIDinteger


query condition


  each PaySelLine where
PaySelLine.PaySel_ID = iiPaySelID

      first DInvoice (inner-join) where
DInvoice.Company_Id = iiCompanyId AND
DInvoice.DInvoice_ID = PaySelLine.PaySelLineParentObject_ID AND

          first Debtor (inner-join) where
Debtor.SharedSet_Id = vi_DEBTOR_sharedset(iiCompanyId) AND
Debtor.Debtor_ID = DInvoice.SoldToDebtor_ID AND

              each BankNumber (inner-join) where
BankNumber.ParentObject_ID = Debtor.Debtor_ID AND
BankNumber.BankPayFormat_ID = iiBankPayFormatID


query resultset tqPaySelLineByPaySelIDDInvoice


field namedata typedb fielddescription
tcBankNumbercharacterBankNumber.BankNumberBank Number
tiBankNumber_IDintegerBankNumber.BankNumber_IDRecord ID
tiBankPayFormat_IDintegerBankNumber.BankPayFormat_IDLink to BankPayFormat
tiDebtor_IDintegerDebtor.Debtor_IDRecord ID
tcDebtorCodecharacterDebtor.DebtorCodeA code (maximum eight characters) that identifies a customer. If the code you specify matches an existing supplier code, a warning message displays. You can choose to ignore the warning, and create the record. However, when a supplier and customer share the same code, they must reference the same business relation.
api annotation:If you leave the Customer Code field blank, the system automatically generates a number for the record based on the sequence defined in Customer Autonumber Create.
tiPaySel_IDintegerPaySelLine.PaySel_IDLink to PaySel
tiPaySelLine_IDintegerPaySelLine.PaySelLine_IDRecord ID
tcPaySelLineObjectTypecharacterPaySelLine.PaySelLineObjectTypeType
tiPaySelLineParentObject_IDintegerPaySelLine.PaySelLineParentObject_IDParent Object


Internal usage


QadFinancials
method BPaymentSelection.ValidateComponentPreBankPayFormat