project QadFinancials > class BPaymentSelection > business logic query PaySelByIDAllInfo

Parameters

iiCompanyId	integer	Company id
iiPaySel_ID	integer

query condition

each PaySel where

PaySel.Company_Id = iiCompanyId AND
PaySel.PaySel_ID = iiPaySel_ID

each PaySelLine (inner-join) where

PaySelLine.PaySel_ID = PaySel.PaySel_ID AND

query resultset tqPaySelByIDAllInfo

field name	data type	db field	description
tiBankNumber_ID	integer	PaySelLine.BankNumber_ID	Link to BankNumber
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	PaySel.PaySel_ID	Record ID
tiPaySelLine_ID	integer	PaySelLine.PaySelLine_ID	Record ID
tdPaySelLineAmountTC	decimal	PaySelLine.PaySelLineAmountTC	Amount
tdPaySelLineDiscountTC	decimal	PaySelLine.PaySelLineDiscountTC	Discount
tdPaySelLineIntAmtTC	decimal	PaySelLine.PaySelLineIntAmtTC	TC Interest Amount
tlPaySelLineIsRefInFile	logical	PaySelLine.PaySelLineIsRefInFile	Ref in File
tcPaySelLineObjectType	character	PaySelLine.PaySelLineObjectType	Type
tiPaySelLineParentObject_ID	integer	PaySelLine.PaySelLineParentObject_ID	Parent Object
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(PaySel),rowid(PaySelLine)

Internal usage

QadFinancials

method BPaymentSelection.FillProDataSetPayment