project QadFinancials > class BDeductionCat > business logic query DedCatLineExpenseAccByCode

Description

Get expense account and expense journal code of the standard deduction.


Parameters


icDeductionCatCodecharacter
iiDomain_IDinteger


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 namedata typedb fielddescription
tcCostCentreCodecharacterCostCentre.CostCentreCodeCost Center: A code that identifies the cost center.
tcDeductionCatCodecharacterDeductionCat.DeductionCatCodeDeduction Category Code
tcDivisionCodecharacterDivision.DivisionCodeSub-Account
tcGLCodecharacterGL.GLCodeA code identifying the GL account.
tcJournalCodecharacterJournal.JournalCodeA daybook code (maximum eight characters).
tcSafCodecharacterSaf.SafCodeSAF Code
tcSafConceptCodecharacterSafConcept.SafConceptCodeSAF Concept Code


Internal usage


QadFinancials
method BDInvoice.UpdateDeductionDetailPosting