business logic query BankNumberByID

Description

BankNumberByID

iiBankNumber_ID	integer
iiCompanyId	integer	Company id

each BankNumber where

BankNumber.BankNumber_ID = iiBankNumber_ID

first CompanySharedSet (conditional-join) where

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

first Company (conditional-join) where

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

field name	data type	db field	description
tcBankNumber	character	BankNumber.BankNumber	Bank Number
tiBankNumber_ID	integer	BankNumber.BankNumber_ID	Record ID
tcBankNumberExtension	character	BankNumber.BankNumberExtension	Bank Extension
tcBankNumberFormatted	character	BankNumber.BankNumberFormatted	Formatted Bank Account No
tcBankNumberValidation	character	BankNumber.BankNumberValidation	Validation
tiCompany_ID	integer	Company.Company_ID	Record ID
tcCompanyCode	character	Company.CompanyCode	Entity Code
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(BankNumber),rowid(CompanySharedSet),rowid(Company)

QadFinancials