business logic query GetDeductionByCodeDomain

Parameters

icDomainCode	character
icDeductionCatCode	character

each DeductionCat where

DeductionCat.DeductionCatCode = icDeductionCatCode AND
DeductionCat.DeductionCatIsActive = true

each DeductionCatLine (inner-join) where

DeductionCatLine.DeductionCat_ID = DeductionCat.DeductionCat_ID AND

first Domains (inner-join) where

Domains.Domain_ID = DeductionCatLine.Domain_ID AND
Domains.DomainCode = icDomainCode

field name	data type	db field	description
tiDeductionCat_ID	integer	DeductionCat.DeductionCat_ID	Record ID
tcDeductionCatCode	character	DeductionCat.DeductionCatCode	Deduction Category Code
tiDeductionCatLine_ID	integer	DeductionCatLine.DeductionCatLine_ID	Record ID
tlDeductionCatLineIsAutoWriteOff	logical	DeductionCatLine.DeductionCatLineIsAutoWOff	Auto Write-off
tcDeductionCatType	character	DeductionCat.DeductionCatType	Type
tdDeductionCatWriteOffLimit	decimal	DeductionCatLine.DeductionCatLineWOffLimit	Write-off Limit

QadFinancials