project QadFinancials > class BMirroringGL > business logic query MirroringGLPrim

Description

This query returns the primary field per domain for the Mirroring ID and Mirroring Code.


Parameters


iiCompanyIdintegerCompany id
iiDomainIdinteger
iiMirroringGLIDinteger
icSource1GLCodecharacter
icSource2GLCodecharacter
icSource1ProjectCodecharacter
icSource2ProjectCodecharacter
icSource2DivisionCodecharacter
icSource1DivisionCodecharacter
icSource1CostCentreCodecharacter
icSource2CostCentreCodecharacter


query condition


  each MirroringGL where
MirroringGL.Company_Id = iiCompanyId AND
MirroringGL.Domain_ID = iiDomainId AND
MirroringGL.MirroringGL_ID = iiMirroringGLID

      first CostCentre1 (conditional-join) where
CostCentre1.SharedSet_Id = vi_COSTCENTRE_sharedset(iiCompanyId) AND
CostCentre1.CostCentre_ID = MirroringGL.Source1CostCentre_ID AND
CostCentre1.CostCentreCode = icSource1CostCentreCode

      first CostCentre2 (conditional-join) where
CostCentre2.SharedSet_Id = vi_COSTCENTRE_sharedset(iiCompanyId) AND
CostCentre2.CostCentre_ID = MirroringGL.Source2CostCentre_ID AND
CostCentre2.CostCentreCode = icSource2CostCentreCode

      first Division1 (conditional-join) where
Division1.SharedSet_Id = vi_DIVISION_sharedset(iiCompanyId) AND
Division1.Division_ID = MirroringGL.Source1Division_ID AND
Division1.DivisionCode = icSource1DivisionCode

      first Division2 (conditional-join) where
Division2.SharedSet_Id = vi_DIVISION_sharedset(iiCompanyId) AND
Division2.Division_ID = MirroringGL.Source2Division_ID AND
Division2.DivisionCode = icSource2DivisionCode

      first GL1 (inner-join) where
GL1.SharedSet_Id = vi_GL_sharedset(iiCompanyId) AND
GL1.GL_ID = MirroringGL.Source1GL_ID AND
GL1.GLCode = icSource1GLCode

      first GL2 (inner-join) where
GL2.SharedSet_Id = vi_GL_sharedset(iiCompanyId) AND
GL2.GL_ID = MirroringGL.Source2GL_ID AND
GL2.GLCode = icSource2GLCode

      first Project1 (conditional-join) where
Project1.SharedSet_Id = vi_PROJECT_sharedset(iiCompanyId) AND
Project1.Project_ID = MirroringGL.Source1Project_ID AND
Project1.ProjectCode = icSource1ProjectCode

      first Project2 (conditional-join) where
Project2.SharedSet_Id = vi_PROJECT_sharedset(iiCompanyId) AND
Project2.Project_ID = MirroringGL.Source2Project_ID AND
Project2.ProjectCode = icSource2ProjectCode


query resultset tqMirroringGLPrim


field namedata typedb fielddescription
tiCompany_IDintegerMirroringGL.Company_IDEntity
tiDomain_IDintegerMirroringGL.Domain_IDDomain
tiMirroringGL_IDintegerMirroringGL.MirroringGL_IDRecord ID
tcSource1CostCentreCodecharacterCostCentre1.CostCentreCodeCost Center: A code that identifies the cost center.
tcSource1DivisionCodecharacterDivision1.DivisionCodeSub-Account
tcSource1GLCodecharacterGL1.GLCodeA code identifying the GL account.
tcSource1ProjectCodecharacterProject1.ProjectCodeProject
tcSource2CostCentreCodecharacterCostCentre2.CostCentreCodeCost Center: A code that identifies the cost center.
tcSource2DivisionCodecharacterDivision2.DivisionCodeSub-Account
tcSource2GLCodecharacterGL2.GLCodeA code identifying the GL account.
tcSource2ProjectCodecharacterProject2.ProjectCodeProject


Internal usage


QadFinancials
method BMirroringGL.DataLoadByInput