project QadFinancials > class BPostingSafHist > business logic query PostingSafCombinedForGLSaf

Parameters


iiPostingSafCombinedIDinteger

query condition


  each PostingSafCombined where
PostingSafCombined.PostingSafCombined_ID = iiPostingSafCombinedID

      first Saf1 (conditional-join) where
Saf1.Saf_ID = PostingSafCombined.GL1Saf_ID AND

          first SafConcept1 (conditional-join) where
SafConcept1.SafConcept_ID = Saf1.SafConcept_ID AND

      first Saf2 (conditional-join) where
Saf2.Saf_ID = PostingSafCombined.GL2Saf_ID AND

          first SafConcept2 (conditional-join) where
SafConcept2.SafConcept_ID = Saf2.SafConcept_ID AND

      first Saf3 (conditional-join) where
Saf3.Saf_ID = PostingSafCombined.GL3Saf_ID AND

          first SafConcept3 (conditional-join) where
SafConcept3.SafConcept_ID = Saf3.SafConcept_ID AND

      first Saf4 (conditional-join) where
Saf4.Saf_ID = PostingSafCombined.GL4Saf_ID AND

          first SafConcept4 (conditional-join) where
SafConcept4.SafConcept_ID = Saf4.SafConcept_ID AND

      first Saf5 (conditional-join) where
Saf5.Saf_ID = PostingSafCombined.GL5Saf_ID AND

          first SafConcept5 (conditional-join) where
SafConcept5.SafConcept_ID = Saf5.SafConcept_ID AND

      first SafStructure (conditional-join) where
SafStructure.SafStructure_ID = PostingSafCombined.GLSafStructure_ID AND

query resultset tqPostingSafCombinedForGLSaf


field namedata typedb fielddescription
tiCostCentre1Saf_IDintegerPostingSafCombined.CostCentre1Saf_IDLink to CostCentre-SAF1
tiCostCentre2Saf_IDintegerPostingSafCombined.CostCentre2Saf_IDLink to CostCentre-SAF2
tiCostCentre3Saf_IDintegerPostingSafCombined.CostCentre3Saf_IDLink to CostCentre-SAF3
tiCostCentre4Saf_IDintegerPostingSafCombined.CostCentre4Saf_IDLink to CostCentre-SAF4
tiCostCentre5Saf_IDintegerPostingSafCombined.CostCentre5Saf_IDLink to CostCentre-SAF5
tcGLSAFCode1characterSaf1.SafCodeSAF Code
tcGLSAFCode2characterSaf2.SafCodeSAF Code
tcGLSAFCode3characterSaf3.SafCodeSAF Code
tcGLSAFCode4characterSaf4.SafCodeSAF Code
tcGLSAFCode5characterSaf5.SafCodeSAF Code
tcGLSafConceptCode1characterSafConcept1.SafConceptCodeSAF Concept Code
tcGLSafConceptCode2characterSafConcept2.SafConceptCodeSAF Concept Code
tcGLSafConceptCode3characterSafConcept3.SafConceptCodeSAF Concept Code
tcGLSafConceptCode4characterSafConcept4.SafConceptCodeSAF Concept Code
tcGLSafConceptCode5characterSafConcept5.SafConceptCodeSAF Concept Code
tcGLSafStructureCodecharacterSafStructure.SafStructureCodeStructure Code
tiPostingSafCombined_IDintegerPostingSafCombined.PostingSafCombined_IDRecord ID

Internal usage


QadFinancials
method BConsolid.AdditionalUpdatesConsolidationBlockDef
method BGL.TrialBalanceCreate