project QadFinancials > class BPaymentSelection > business logic query PaySelByIDAllInfo


Parameters


iiCompanyIdintegerCompany id
iiPaySel_IDinteger


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 namedata typedb fielddescription
tiBankNumber_IDintegerPaySelLine.BankNumber_IDLink to BankNumber
ttLastModifiedDatedatePaySelLine.LastModifiedDateLast Modified Date
tiLastModifiedTimeintegerPaySelLine.LastModifiedTimeLast Modified Time
tcLastModifiedUsercharacterPaySelLine.LastModifiedUserLast Modified User
tcPayFormatTypeCodecharacterPaySelLine.PayFormatTypeCodePayment format of the payment selection
tiPaySel_IDintegerPaySel.PaySel_IDRecord ID
tiPaySelLine_IDintegerPaySelLine.PaySelLine_IDRecord ID
tdPaySelLineAmountTCdecimalPaySelLine.PaySelLineAmountTCAmount
tdPaySelLineDiscountTCdecimalPaySelLine.PaySelLineDiscountTCDiscount
tdPaySelLineIntAmtTCdecimalPaySelLine.PaySelLineIntAmtTCTC Interest Amount
tlPaySelLineIsRefInFilelogicalPaySelLine.PaySelLineIsRefInFileRef in File
tcPaySelLineObjectTypecharacterPaySelLine.PaySelLineObjectTypeType
tiPaySelLineParentObject_IDintegerPaySelLine.PaySelLineParentObject_IDParent Object
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(PaySel),rowid(PaySelLine)


Internal usage


QadFinancials
method BPaymentSelection.FillProDataSetPayment