project QadFinancials > class BPaymentSelection > business logic query PaySelByCode

Description

PaySelByCode


Parameters


iiCompanyIdintegerCompany id
icPaySelCodecharacterPayment Selection Code


query condition


  each PaySel where
PaySel.Company_Id = iiCompanyId AND
PaySel.PaySelCode = icPaySelCode

      first GL (inner-join) where
GL.SharedSet_Id = vi_GL_sharedset(iiCompanyId) AND
GL.GL_ID = PaySel.GL_ID AND

          first Currency (outer-join) where
Currency.Currency_ID = GL.Currency_ID AND


query resultset tqPaySelByCode


field namedata typedb fielddescription
tiBankPayFormat_IDintegerPaySel.BankPayFormat_IDLink to BankPayFormat
tcCurrencyCodecharacterCurrency.CurrencyCodeCurrency Code
tiCurrencyNumberOfDecimalsintegerCurrency.CurrencyNumberOfDecimalsNumber of Decimals
tiGL_IDintegerPaySel.GL_IDAccount
tcGLCodecharacterGL.GLCodeA code identifying the GL account.
tlGLIsLocalCurrencylogicalGL.GLIsLocalCurrencySet to true If postings are performed in the base currency only.
api annotation:When this field's value is true, the tcCurrencyCode field should be blank.
tiPaySel_IDintegerPaySel.PaySel_IDRecord ID
tcPaySelCodecharacterPaySel.PaySelCodeCode
ttPaySelDatedatePaySel.PaySelDateExecution Date
tcPaySelStatuscharacterPaySel.PaySelStatusStatus
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(PaySel),rowid(GL),rowid(Currency)


Internal usage


QadFinancials
method BPaymentSelection.ApiGetPaySelInfo
method BPaymentSelection.ApiGetPaySelInfoForConfirm