business logic query PaySelByCode

Description

PaySelByCode

iiCompanyId	integer	Company id
icPaySelCode	character	Payment Selection Code

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

field name	data type	db field	description
tiBankPayFormat_ID	integer	PaySel.BankPayFormat_ID	Link to BankPayFormat
tcCurrencyCode	character	Currency.CurrencyCode	Currency Code
tiCurrencyNumberOfDecimals	integer	Currency.CurrencyNumberOfDecimals	Number of Decimals
tiGL_ID	integer	PaySel.GL_ID	Account
tcGLCode	character	GL.GLCode	A code identifying the GL account.
tlGLIsLocalCurrency	logical	GL.GLIsLocalCurrency	Set 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_ID	integer	PaySel.PaySel_ID	Record ID
tcPaySelCode	character	PaySel.PaySelCode	Code
ttPaySelDate	date	PaySel.PaySelDate	Execution Date
tcPaySelStatus	character	PaySel.PaySelStatus	Status
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(PaySel),rowid(GL),rowid(Currency)

QadFinancials