project QadFinancials > class BDeductionCat > business logic query DedCatLineExpenseAccByCode
Description
Get expense account and expense journal code of the standard deduction.
Parameters
icDeductionCatCode | character | |
iiDomain_ID | integer | |
query condition
each DeductionCat where
DeductionCat.DeductionCatCode = icDeductionCatCode AND
DeductionCat.DeductionCatIsActive = yes
each DeductionCatLine (inner-join) where
DeductionCatLine.DeductionCat_ID = DeductionCat.DeductionCat_ID AND
DeductionCatLine.Domain_ID = iiDomain_ID
first CostCentre (outer-join) where
CostCentre.CostCentre_ID = DeductionCatLine.CostCentre_ID AND
CostCentre.SharedSet_ID <> 0
each DeductionCatLineSaf (outer-join) where
DeductionCatLineSaf.DeductionCatLine_ID = DeductionCatLine.DeductionCatLine_ID AND
first Saf (outer-join) where
Saf.Saf_ID = DeductionCatLineSaf.Saf_ID AND
first SafConcept (outer-join) where
SafConcept.SafConcept_ID = Saf.SafConcept_ID AND
first Division (outer-join) where
Division.Division_ID = DeductionCatLine.Division_ID AND
Division.SharedSet_ID <> 0
first GL (inner-join) where
GL.GL_ID = DeductionCatLine.GL_ID AND
GL.SharedSet_ID <> 0
first Journal (inner-join) where
Journal.Journal_ID = DeductionCatLine.ExpenseJournal_ID AND
Journal.SharedSet_ID <> 0
query resultset tqDedCatLineExpenseAccByCode
field name | data type | db field | description |
tcCostCentreCode | character | CostCentre.CostCentreCode | Cost Center: A code that identifies the cost center. |
tcDeductionCatCode | character | DeductionCat.DeductionCatCode | Deduction Category Code |
tcDivisionCode | character | Division.DivisionCode | Sub-Account |
tcGLCode | character | GL.GLCode | A code identifying the GL account. |
tcJournalCode | character | Journal.JournalCode | A daybook code (maximum eight characters). |
tcSafCode | character | Saf.SafCode | SAF Code |
tcSafConceptCode | character | SafConcept.SafConceptCode | SAF Concept Code |
Internal usage
QadFinancials