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
iiCompanyId | integer | Company id |
iiDomainId | integer | |
iiMirroringGLID | integer | |
icSource1GLCode | character | |
icSource2GLCode | character | |
icSource1ProjectCode | character | |
icSource2ProjectCode | character | |
icSource2DivisionCode | character | |
icSource1DivisionCode | character | |
icSource1CostCentreCode | character | |
icSource2CostCentreCode | character | |
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 name | data type | db field | description |
tiCompany_ID | integer | MirroringGL.Company_ID | Entity |
tiDomain_ID | integer | MirroringGL.Domain_ID | Domain |
tiMirroringGL_ID | integer | MirroringGL.MirroringGL_ID | Record ID |
tcSource1CostCentreCode | character | CostCentre1.CostCentreCode | Cost Center: A code that identifies the cost center. |
tcSource1DivisionCode | character | Division1.DivisionCode | Sub-Account |
tcSource1GLCode | character | GL1.GLCode | A code identifying the GL account. |
tcSource1ProjectCode | character | Project1.ProjectCode | Project |
tcSource2CostCentreCode | character | CostCentre2.CostCentreCode | Cost Center: A code that identifies the cost center. |
tcSource2DivisionCode | character | Division2.DivisionCode | Sub-Account |
tcSource2GLCode | character | GL2.GLCode | A code identifying the GL account. |
tcSource2ProjectCode | character | Project2.ProjectCode | Project |
Internal usage
QadFinancials