project QadFinancials > class BDeductionCat > business logic query DeductionCatLineByCode

Parameters

iiDomainId	integer
iiCompanyId	integer	Company id
icDeductionCode	character

query condition

each DeductionCat where

DeductionCat.DeductionCatCode = icDeductionCode

each DeductionCatLine (outer-join) where

DeductionCatLine.DeductionCat_ID = DeductionCat.DeductionCat_ID AND
DeductionCatLine.Domain_ID = iiDomainId

query resultset tqDeductionCatLineByCode

field name	data type	db field	description
tiDeductionCat_ID	integer	DeductionCat.DeductionCat_ID	Record ID
tcDeductionCatCode	character	DeductionCat.DeductionCatCode	Deduction Category Code
tcDeductionCatDescription	character	DeductionCat.DeductionCatDescription	Description
tlDeductionCatIsActive	logical	DeductionCat.DeductionCatIsActive	Active
tlDeductionCatIsAutoWriteOff	logical	DeductionCatLine.DeductionCatLineIsAutoWOff	Auto Write-off
tiDeductionCatLine_ID	integer	DeductionCatLine.DeductionCatLine_ID	Record ID
tcDeductionCatType	character	DeductionCat.DeductionCatType	Type
tdDeductionCatWriteOffLimit	decimal	DeductionCatLine.DeductionCatLineWOffLimit	Write-off Limit
tiDomain_ID	integer	DeductionCatLine.Domain_ID	Link to Doamin

Internal usage

QadFinancials

method BBankEntry.CreateDeduction
method BDInvoice.ValDeductionCatLine