project QadFinancials > class BPostingSafHist > business logic query PostingSafCombinedForCCSaf

Parameters


iiPostingSafCombinedIDinteger

query condition


  each PostingSafCombined where
PostingSafCombined.PostingSafCombined_ID = iiPostingSafCombinedID

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

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

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

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

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

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

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

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

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

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

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

query resultset tqPostingSafCombinedForCCSaf


field namedata typedb fielddescription
tcCCSafConceptCode1characterSafConcept5.SafConceptCodeSAF Concept Code
tcCCSafConceptCode2characterSafConcept4.SafConceptCodeSAF Concept Code
tcCCSafConceptCode3characterSafConcept1.SafConceptCodeSAF Concept Code
tcCCSafConceptCode4characterSafConcept2.SafConceptCodeSAF Concept Code
tcCCSafConceptCode5characterSafConcept3.SafConceptCodeSAF Concept Code
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
tcCostCentreSAFCode1characterSaf5.SafCodeSAF Code
tcCostCentreSAFCode2characterSaf4.SafCodeSAF Code
tcCostCentreSAFCode3characterSaf1.SafCodeSAF Code
tcCostCentreSAFCode4characterSaf2.SafCodeSAF Code
tcCostCentreSAFCode5characterSaf3.SafCodeSAF Code
tcCostCentreSafStructureCodecharacterSafStructure.SafStructureCodeStructure Code
tiPostingSafCombined_IDintegerPostingSafCombined.PostingSafCombined_IDRecord ID

Internal usage


QadFinancials
method BConsolid.AdditionalUpdatesConsolidationBlockDef
method BGL.TrialBalanceCreate