project QadFinancials > class BDeductionCat > business logic query DeductionCatLineByCode


Parameters


iiDomainIdinteger
iiCompanyIdintegerCompany id
icDeductionCodecharacter


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 namedata typedb fielddescription
tiDeductionCat_IDintegerDeductionCat.DeductionCat_IDRecord ID
tcDeductionCatCodecharacterDeductionCat.DeductionCatCodeDeduction Category Code
tcDeductionCatDescriptioncharacterDeductionCat.DeductionCatDescriptionDescription
tlDeductionCatIsActivelogicalDeductionCat.DeductionCatIsActiveActive
tlDeductionCatIsAutoWriteOfflogicalDeductionCatLine.DeductionCatLineIsAutoWOffAuto Write-off
tiDeductionCatLine_IDintegerDeductionCatLine.DeductionCatLine_IDRecord ID
tcDeductionCatTypecharacterDeductionCat.DeductionCatTypeType
tdDeductionCatWriteOffLimitdecimalDeductionCatLine.DeductionCatLineWOffLimitWrite-off Limit
tiDomain_IDintegerDeductionCatLine.Domain_IDLink to Doamin


Internal usage


QadFinancials
method BBankEntry.CreateDeduction
method BDInvoice.ValDeductionCatLine