business logic query BankPayFormatByID

Parameters

iiBankPayFormatId	integer
iiCompanyId	integer	Company id

each BankPayFormat where

BankPayFormat.BankPayFormat_ID = iiBankPayFormatId

first BankNumber (inner-join) where

BankNumber.BankNumber_ID = BankPayFormat.BankNumber_ID AND

first CompanySharedSet (inner-join) where

CompanySharedSet.Company_Id = iiCompanyId AND
CompanySharedSet.CompanySharedSet_ID = BankNumber.CompanySharedSet_ID AND

first Company (inner-join) where

Company.Company_Id = iiCompanyId AND
Company.Company_ID = CompanySharedSet.Company_ID AND

first GL (outer-join) where

GL.SharedSet_Id = vi_GL_sharedset(iiCompanyId) AND
GL.GL_ID = BankNumber.ParentObject_ID AND

first PayFormatType (inner-join) where

PayFormatType.PayFormatTypeCode = BankPayFormat.PayFormatTypeCode AND

field name	data type	db field	description
tiBankAccFormat_ID	integer	BankNumber.BankAccFormat_ID	Bank Account Format
tcBankNumber	character	BankNumber.BankNumber	Bank Number
tiBankNumber_ID	integer	BankPayFormat.BankNumber_ID	Bank Number
tiBankNumber_ID1	integer	BankNumber.BankNumber_ID	Record ID
tiBankNumberBankChargeGL_ID	integer	BankNumber.BankNumberBankChargeGL_ID	Link to GL for Bank Charges
tcBankNumberFormatted	character	BankNumber.BankNumberFormatted	Formatted Bank Account No
tlBankNumberIsBankCharge	logical	BankNumber.BankNumberIsBankCharge	Bank Charge
tiBankPayFormat_ID	integer	BankPayFormat.BankPayFormat_ID	Record ID
tlBankPayFormatIsBankCharge	logical	BankPayFormat.BankPayFormatIsBankCharge	Bank Charge Applies
tiCompany_ID	integer	Company.Company_ID	Record ID
tcCompanyCode	character	Company.CompanyCode	Entity Code
tiGL_ID	integer	GL.GL_ID	Record ID
tcGLCode	character	GL.GLCode	A code identifying the GL account.
tcPayFormatTypeCode	character	BankPayFormat.PayFormatTypeCode	Payment Format
tcPayFormatTypePayInstrument	character	PayFormatType.PayFormatTypePayInstrument	Payment Instrument
tcPayFormatTypePayType	character	PayFormatType.PayFormatTypePayType	Payment Type
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(BankPayFormat),rowid(BankNumber),rowid(CompanySharedSet),rowid(Company),rowid(GL),rowid(PayFormatType)

QadFinancials