business logic (internal API) query DeductionCatExpenseInfoByCode

query filter (table tFilter)

tcBusinessFieldName	tcDataType	tcOperator
iiCompanyId	i
icDeductionCatCode	c	=
iiDomain_ID	i	=
tDeductionCat.DeductionCatCode	c	=,>=,>,<>,<=,<,begins,can-do,matches
tJournal.JournalCode	c	=,>=,>,<>,<=,<,begins,can-do,matches

each DeductionCat where

DeductionCat.DeductionCatCode = icDeductionCatCode

each DeductionCatLine (inner-join) where

DeductionCatLine.DeductionCat_ID = DeductionCat.DeductionCat_ID AND
DeductionCatLine.Domain_ID = iiDomain_ID

first Journal (inner-join) where

Journal.Journal_ID = DeductionCatLine.ExpenseJournal_ID AND
Journal.SharedSet_ID <> 0

field name	data type	db field	description
tiDeductionCat_ID	integer	DeductionCat.DeductionCat_ID	Record ID
tcDeductionCatCode	character	DeductionCat.DeductionCatCode	Deduction Category Code
tiExpenseJournal_ID	integer	DeductionCatLine.ExpenseJournal_ID	Link to ExpenseJournal
tcExpenseJournalCode	character	Journal.JournalCode	A daybook code (maximum eight characters).
DeductionCatCustom	character	calculated	custom fields
DeductionCatLineCustom	character	calculated	custom fields
JournalCustom	character	calculated	custom fields
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(DeductionCat),rowid(DeductionCatLine),rowid(Journal)

QadFinancials