project QadFinancials > class BDeductionCat > business logic query DeductionCatLineExpenseAccount
Parameters
| iiCompanyId | integer | Company id |
| iiDeductionCatLine_ID | integer | Deduction Cat Line ID. |
query condition
each DeductionCatLine where
DeductionCatLine.DeductionCatLine_ID = iiDeductionCatLine_ID
first CostCentre (conditional-join) where
CostCentre.SharedSet_Id = vi_COSTCENTRE_sharedset(iiCompanyId) AND
CostCentre.CostCentre_ID = DeductionCatLine.CostCentre_ID AND
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 (conditional-join) where
Division.SharedSet_Id = vi_DIVISION_sharedset(iiCompanyId) AND
Division.Division_ID = DeductionCatLine.Division_ID AND
first GL (inner-join) where
GL.SharedSet_Id = vi_GL_sharedset(iiCompanyId) AND
GL.GL_ID = DeductionCatLine.GL_ID AND
first Journal (inner-join) where
Journal.SharedSet_Id = vi_JOURNAL_sharedset(iiCompanyId) AND
Journal.Journal_ID = DeductionCatLine.ExpenseJournal_ID AND
query resultset tqDeductionCatLineExpenseAccount
| field name | data type | db field | description |
|---|
| tiCostCentre_ID | integer | DeductionCatLine.CostCentre_ID | Link to CostCentre |
| tcCostCentreCode | character | CostCentre.CostCentreCode | Cost Center: A code that identifies the cost center. |
| tlCostCentreIsActive | logical | CostCentre.CostCentreIsActive | Active: Indicate if this is an active cost center. |
| api annotation: | | PartialUpdate = yes - defaults to true |
| tiDivision_ID | integer | DeductionCatLine.Division_ID | Link to Division |
| tcDivisionCode | character | Division.DivisionCode | Sub-Account |
| tlDivisionIsActive | logical | Division.DivisionIsActive | Active |
| tiExpenseJournal_ID | integer | DeductionCatLine.ExpenseJournal_ID | Link to ExpenseJournal |
| tiGL_ID | integer | DeductionCatLine.GL_ID | Link to GL |
| tcGLCode | character | GL.GLCode | A code identifying the GL account. |
| tlGLIsActive | logical | GL.GLIsActive | Active: Indicate if this is an active account. |
| tcJournalCode | character | Journal.JournalCode | A daybook code (maximum eight characters). |
| tiRechargeJournal_ID | integer | DeductionCatLine.RechargeJournal_ID | Link to RechargeJournal |
| tiSaf_ID | integer | DeductionCatLineSaf.Saf_ID | Link to Saf |
| tcSafCode | character | Saf.SafCode | SAF Code |
| tiSafConcept_ID | integer | Saf.SafConcept_ID | SAF Concept Code |
| tcSafConceptCode | character | SafConcept.SafConceptCode | SAF Concept Code |
| tlSafConceptIsActive | logical | SafConcept.SafConceptIsActive | Active |
| tlSafIsActive | logical | Saf.SafIsActive | Active |
| tiSafStructure_ID | integer | DeductionCatLine.SafStructure_ID | Link to SafStructure |
Internal usage
QadFinancials