project QadFinancials > class BRevaluationSaf > business logic query RevalGLSafCombinedByIds

Description

This query returns all the fields of RevalGLSafCombined for all the input id fiellds of this table.


Parameters


iiCostCentre1SafIDinteger
iiCostCentre2SafIDinteger
iiCostCentre3SafIDinteger
iiCostCentre4SafIDinteger
iiCostCentre5SafIDinteger
iiCostCentreSafStructureIDinteger
iiGL1SafIDinteger
iiGL2SafIDinteger
iiGL3SafIDinteger
iiGL4SafIDinteger
iiGL5SafIDinteger
iiGLSafStructureIDinteger
iiProject1SafIDinteger
iiProject2SafIDinteger
iiProject3SafIDinteger
iiProject4SafIDinteger
iiProject5SafIDinteger
iiProjectSafStructureIDinteger
iiRevalGLSafCombined_Idinteger


query condition


  each RevalGLSafCombined where
RevalGLSafCombined.CostCentre1Saf_ID = iiCostCentre1SafID AND
RevalGLSafCombined.CostCentre2Saf_ID = iiCostCentre2SafID AND
RevalGLSafCombined.CostCentre3Saf_ID = iiCostCentre3SafID AND
RevalGLSafCombined.CostCentre4Saf_ID = iiCostCentre4SafID AND
RevalGLSafCombined.CostCentre5Saf_ID = iiCostCentre5SafID AND
RevalGLSafCombined.CostCentreSafStructure_ID = iiCostCentreSafStructureID AND
RevalGLSafCombined.GL1Saf_ID = iiGL1SafID AND
RevalGLSafCombined.GL2Saf_ID = iiGL2SafID AND
RevalGLSafCombined.GL3Saf_ID = iiGL3SafID AND
RevalGLSafCombined.GL4Saf_ID = iiGL4SafID AND
RevalGLSafCombined.GL5Saf_ID = iiGL5SafID AND
RevalGLSafCombined.GLSafStructure_ID = iiGLSafStructureID AND
RevalGLSafCombined.Project1Saf_ID = iiProject1SafID AND
RevalGLSafCombined.Project2Saf_ID = iiProject2SafID AND
RevalGLSafCombined.Project3Saf_ID = iiProject3SafID AND
RevalGLSafCombined.Project4Saf_ID = iiProject4SafID AND
RevalGLSafCombined.Project5Saf_ID = iiProject5SafID AND
RevalGLSafCombined.ProjectSafStructure_ID = iiProjectSafStructureID AND
RevalGLSafCombined.RevalGLSafCombined_ID = iiRevalGLSafCombined_Id

      first SafStructure1 (outer-join) where
SafStructure1.SafStructure_ID = RevalGLSafCombined.CostCentreSafStructure_ID AND

      first SafStructure2 (outer-join) where
SafStructure2.SafStructure_ID = RevalGLSafCombined.GLSafStructure_ID AND

      first SafStructure3 (outer-join) where
SafStructure3.SafStructure_ID = RevalGLSafCombined.ProjectSafStructure_ID AND


query resultset tqRevalGLSafCombinedByIds


field namedata typedb fielddescription
tiCostCentre1Saf_IDintegerRevalGLSafCombined.CostCentre1Saf_IDLink to Saf
tiCostCentre2Saf_IDintegerRevalGLSafCombined.CostCentre2Saf_IDLink to Saf
tiCostCentre3Saf_IDintegerRevalGLSafCombined.CostCentre3Saf_IDLink to Saf
tiCostCentre4Saf_IDintegerRevalGLSafCombined.CostCentre4Saf_IDLink to Saf
tiCostCentre5Saf_IDintegerRevalGLSafCombined.CostCentre5Saf_IDLink to Saf
tiCostCentreSafStructure_IDintegerRevalGLSafCombined.CostCentreSafStructure_IDLink to SafStructure
tiGL1Saf_IDintegerRevalGLSafCombined.GL1Saf_IDLink to Saf
tiGL2Saf_IDintegerRevalGLSafCombined.GL2Saf_IDLink to Saf
tiGL3Saf_IDintegerRevalGLSafCombined.GL3Saf_IDLink to Saf
tiGL4Saf_IDintegerRevalGLSafCombined.GL4Saf_IDLink to Saf
tiGL5Saf_IDintegerRevalGLSafCombined.GL5Saf_IDLink to Saf
tiGLSafStructure_IDintegerRevalGLSafCombined.GLSafStructure_IDLink to SafStructure
tiProject1Saf_IDintegerRevalGLSafCombined.Project1Saf_IDLink to Saf
tiProject2Saf_IDintegerRevalGLSafCombined.Project2Saf_IDLink to Saf
tiProject3Saf_IDintegerRevalGLSafCombined.Project3Saf_IDLink to Saf
tiProject4Saf_IDintegerRevalGLSafCombined.Project4Saf_IDLink to Saf
tiProject5Saf_IDintegerRevalGLSafCombined.Project5Saf_IDLink to Saf
tiProjectSafStructure_IDintegerRevalGLSafCombined.ProjectSafStructure_IDLink to SafStructure
tiRevalGLSafCombined_IDintegerRevalGLSafCombined.RevalGLSafCombined_IDRecord ID
tcSafStructureCodecharacterSafStructure1.SafStructureCodeStructure Code
tcSafStructureCode2characterSafStructure2.SafStructureCodeStructure Code
tcSafStructureCode3characterSafStructure3.SafStructureCodeStructure Code
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(RevalGLSafCombined),rowid(SafStructure1),rowid(SafStructure2),rowid(SafStructure3)


Internal usage


QadFinancials
method BRevaluation.AdditionalUpdatesPostingCreate
method BRevaluation.AdditionalUpdatesPostingCreateSafs
method BRevaluationSaf.UpdateRevalGLSafCombined