business logic query PaySelLineByPaySelIDDInvoice

Parameters

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

field name	data type	db field	description
tcBankNumber	character	BankNumber.BankNumber	Bank Number
tiBankNumber_ID	integer	BankNumber.BankNumber_ID	Record ID
tiBankPayFormat_ID	integer	BankNumber.BankPayFormat_ID	Link to BankPayFormat
tiDebtor_ID	integer	Debtor.Debtor_ID	Record ID
tcDebtorCode	character	Debtor.DebtorCode	A 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_ID	integer	PaySelLine.PaySel_ID	Link to PaySel
tiPaySelLine_ID	integer	PaySelLine.PaySelLine_ID	Record ID
tcPaySelLineObjectType	character	PaySelLine.PaySelLineObjectType	Type
tiPaySelLineParentObject_ID	integer	PaySelLine.PaySelLineParentObject_ID	Parent Object

QadFinancials