business logic query PaySelLineByRefCreditorYear

Parameters

iiCompanyId	integer	Company id
icCreditorCode	character	Creditor
icReference	character	Reference of the prepayment
icSkipRowId	character	Skip Row ID
iiYear	integer	year to check where prepayment is created
icObjectType	character	Object type

query condition

each PaySelLine where

PaySelLine.PaySelLineObjectType = icObjectType AND
rowid(PaySelLine) <> to-rowid(icSkipRowId)

first PaySel (inner-join) where

PaySel.Company_Id = iiCompanyId AND
PaySel.PaySel_ID = PaySelLine.PaySel_ID AND
year(PaySel.PaySelDate) = iiYear

first PaySelPrepay (inner-join) where

PaySelPrepay.PaySelPrepay_ID = PaySelLine.PaySelLineParentObject_ID AND
PaySelPrepay.PaySelPrepayReferenceText = icReference

first Creditor (inner-join) where

Creditor.SharedSet_Id = vi_CREDITOR_sharedset(iiCompanyId) AND
Creditor.Creditor_ID = PaySelPrepay.Creditor_ID AND
Creditor.CreditorCode = icCreditorCode

query resultset tqPaySelLineByRefCreditorYear

field name	data type	db field	description
tiBankNumber_ID	integer	PaySelLine.BankNumber_ID	Link to BankNumber
tcCreditorCode	character	Creditor.CreditorCode	Supplier Code
ttLastModifiedDate	date	PaySelLine.LastModifiedDate	Last Modified Date
tiLastModifiedTime	integer	PaySelLine.LastModifiedTime	Last Modified Time
tcLastModifiedUser	character	PaySelLine.LastModifiedUser	Last Modified User
tcPayFormatTypeCode	character	PaySelLine.PayFormatTypeCode	Payment format of the payment selection
tiPaySel_ID	integer	PaySelLine.PaySel_ID	Link to PaySel
tiPaySelLine_ID	integer	PaySelLine.PaySelLine_ID	Record ID
tdPaySelLineAmountTC	decimal	PaySelLine.PaySelLineAmountTC	Amount
tdPaySelLineDiscountTC	decimal	PaySelLine.PaySelLineDiscountTC	Discount
tlPaySelLineIsRefInFile	logical	PaySelLine.PaySelLineIsRefInFile	Ref in File
tcPaySelLineObjectType	character	PaySelLine.PaySelLineObjectType	Type
tiPaySelLineParentObject_ID	integer	PaySelLine.PaySelLineParentObject_ID	Parent Object
tcPaySelPrepayReferenceText	character	PaySelPrepay.PaySelPrepayReferenceText	Reference

Internal usage

QadFinancials

method BPaymentSelection.ValidateComponentPostReference