project QadFinancials > class BDInvoice > business logic query DInvoiceDeductionById
Parameters
| icDInvoiceDeductionID | character | |
query condition
each DInvoiceDeduction where
DInvoiceDeduction.DInvoiceDeduction_ID = icDInvoiceDeductionID
first DeductionCatLine (inner-join) where
DeductionCatLine.DeductionCatLine_ID = DInvoiceDeduction.DeductionCatLine_ID AND
first DeductionCat (inner-join) where
DeductionCat.DeductionCat_ID = DeductionCatLine.DeductionCat_ID AND
query resultset tqDInvoiceDeductionById
| field name | data type | db field | description |
|---|
| tcDeductionCatType | character | DeductionCat.DeductionCatType | Type |
| tiDInvoiceDeduction_ID | integer | DInvoiceDeduction.DInvoiceDeduction_ID | Record ID |
| tcDInvoiceDeductionStatus | character | DInvoiceDeduction.DInvoiceDeductionStatus | Deduction Status |
Internal usage
QadFinancials