project QadFinancials > class BDeductionCat > business logic query GetDedCatLineIdByDedCatCode (distinct)
Parameters
| icDeductionCatCode | character | |
query condition
each DeductionCat where
DeductionCat.DeductionCatCode = icDeductionCatCode
each DeductionCatLine (inner-join) where
DeductionCatLine.DeductionCat_ID = DeductionCat.DeductionCat_ID AND
query resultset tqGetDedCatLineIdByDedCatCode
| field name | data type | db field | description |
|---|
| tcDeductionCatCode | character | DeductionCat.DeductionCatCode | Deduction Category Code |
| tiDeductionCatLine_ID | integer | DeductionCatLine.DeductionCatLine_ID | Record ID |
Internal usage
QadFinancials