project QadFinancials > class BMirroringGL > business logic query MirroringGLBySourceGL
Description
This query returns the mirroring gl accounts per domain for source GL ID.
Parameters
| iiCompanyId | integer | Company id |
| icSource1GLCode | character | |
| icSource2GLCode | character | |
| icCompanyCode | character | |
| icDomainCode | character | |
query condition
each MirroringGL where
MirroringGL.Company_Id = iiCompanyId AND
first Company (conditional-join) where
Company.Company_Id = iiCompanyId AND
Company.Company_ID = MirroringGL.Company_ID AND
Company.CompanyCode = icCompanyCode
first CostCentre1 (conditional-join) where
CostCentre1.SharedSet_Id = vi_COSTCENTRE_sharedset(iiCompanyId) AND
CostCentre1.CostCentre_ID = MirroringGL.Mirror2CostCentre_ID AND
first CostCentre2 (conditional-join) where
CostCentre2.SharedSet_Id = vi_COSTCENTRE_sharedset(iiCompanyId) AND
CostCentre2.CostCentre_ID = MirroringGL.Mirror1CostCentre_ID AND
first CostCentre3 (conditional-join) where
CostCentre3.SharedSet_Id = vi_COSTCENTRE_sharedset(iiCompanyId) AND
CostCentre3.CostCentre_ID = MirroringGL.Source2CostCentre_ID AND
first CostCentre4 (conditional-join) where
CostCentre4.SharedSet_Id = vi_COSTCENTRE_sharedset(iiCompanyId) AND
CostCentre4.CostCentre_ID = MirroringGL.Source1CostCentre_ID AND
first Division1 (conditional-join) where
Division1.SharedSet_Id = vi_DIVISION_sharedset(iiCompanyId) AND
Division1.Division_ID = MirroringGL.Mirror2Division_ID AND
first Division2 (conditional-join) where
Division2.SharedSet_Id = vi_DIVISION_sharedset(iiCompanyId) AND
Division2.Division_ID = MirroringGL.Mirror1Division_ID AND
first Division3 (conditional-join) where
Division3.SharedSet_Id = vi_DIVISION_sharedset(iiCompanyId) AND
Division3.Division_ID = MirroringGL.Source2Division_ID AND
first Division4 (conditional-join) where
Division4.SharedSet_Id = vi_DIVISION_sharedset(iiCompanyId) AND
Division4.Division_ID = MirroringGL.Source1Division_ID AND
first Domains (inner-join) where
Domains.Domain_ID = MirroringGL.Domain_ID AND
Domains.DomainCode = icDomainCode
first GL1 (inner-join) where
GL1.SharedSet_Id = vi_GL_sharedset(iiCompanyId) AND
GL1.GL_ID = MirroringGL.Mirror2GL_ID AND
first GL2 (inner-join) where
GL2.SharedSet_Id = vi_GL_sharedset(iiCompanyId) AND
GL2.GL_ID = MirroringGL.Mirror1GL_ID AND
first GL3 (inner-join) where
GL3.SharedSet_Id = vi_GL_sharedset(iiCompanyId) AND
GL3.GL_ID = MirroringGL.Source2GL_ID AND
GL3.GLCode = icSource2GLCode
first GL4 (inner-join) where
GL4.SharedSet_Id = vi_GL_sharedset(iiCompanyId) AND
GL4.GL_ID = MirroringGL.Source1GL_ID AND
GL4.GLCode = icSource1GLCode
first Project1 (conditional-join) where
Project1.SharedSet_Id = vi_PROJECT_sharedset(iiCompanyId) AND
Project1.Project_ID = MirroringGL.Source2Project_ID AND
first Project2 (conditional-join) where
Project2.SharedSet_Id = vi_PROJECT_sharedset(iiCompanyId) AND
Project2.Project_ID = MirroringGL.Source1Project_ID AND
first Project3 (conditional-join) where
Project3.SharedSet_Id = vi_PROJECT_sharedset(iiCompanyId) AND
Project3.Project_ID = MirroringGL.Mirror2Project_ID AND
first Project4 (conditional-join) where
Project4.SharedSet_Id = vi_PROJECT_sharedset(iiCompanyId) AND
Project4.Project_ID = MirroringGL.Mirror1Project_ID AND
query resultset tqMirroringGLBySourceGL
| field name | data type | db field | description |
|---|
| tiCompany_ID | integer | MirroringGL.Company_ID | Entity |
| tcCompanyCode | character | Company.CompanyCode | Entity Code |
| tiDomain_ID | integer | MirroringGL.Domain_ID | Domain |
| tcDomainCode | character | Domains.DomainCode | Domain |
| ttLastModifiedDate | date | MirroringGL.LastModifiedDate | Last Modified Date |
| tiLastModifiedTime | integer | MirroringGL.LastModifiedTime | Last Modified Time |
| tcLastModifiedUser | character | MirroringGL.LastModifiedUser | Last Modified User |
| tiMirror1CostCentre_ID | integer | MirroringGL.Mirror1CostCentre_ID | Mirror 1 Cost Center |
| tcMirror1CostCentreCode | character | CostCentre2.CostCentreCode | Cost Center: A code that identifies the cost center. |
| tiMirror1Division_ID | integer | MirroringGL.Mirror1Division_ID | Mirror 1 Sub-Account |
| tcMirror1DivisionCode | character | Division2.DivisionCode | Sub-Account |
| tiMirror1GL_ID | integer | MirroringGL.Mirror1GL_ID | Mirror 1 Account |
| tcMirror1GLCode | character | GL2.GLCode | A code identifying the GL account. |
| tiMirror1Project_ID | integer | MirroringGL.Mirror1Project_ID | Mirror 1 Project |
| tcMirror1ProjectCode | character | Project4.ProjectCode | Project |
| tiMirror2CostCentre_ID | integer | MirroringGL.Mirror2CostCentre_ID | Mirror 2 Cost Center |
| tcMirror2CostCentreCode | character | CostCentre1.CostCentreCode | Cost Center: A code that identifies the cost center. |
| tiMirror2Division_ID | integer | MirroringGL.Mirror2Division_ID | Mirror 2 Sub-Account |
| tcMirror2DivisionCode | character | Division1.DivisionCode | Sub-Account |
| tiMirror2GL_ID | integer | MirroringGL.Mirror2GL_ID | Mirror 2 Account |
| tcMirror2GLcode | character | GL1.GLCode | A code identifying the GL account. |
| tiMirror2Project_ID | integer | MirroringGL.Mirror2Project_ID | Mirror 2 Project |
| tcMirror2ProjectCode | character | Project3.ProjectCode | Project |
| tiMirroringGL_ID | integer | MirroringGL.MirroringGL_ID | Record ID |
| tcMirroringGLSplitGLType | character | MirroringGL.MirroringGLSplitGLType | Account Split Type |
| tcMirroringGLTrans1Journal | character | MirroringGL.MirroringGLTrans1Journal | Transaction 1 Daybook |
| tcMirroringGLTrans2Journal | character | MirroringGL.MirroringGLTrans2Journal | Transaction 2 Daybook |
| tiSource1CostCentre_ID | integer | MirroringGL.Source1CostCentre_ID | Source 1 Cost Center |
| tcSource1CostCentreCode | character | CostCentre4.CostCentreCode | Cost Center: A code that identifies the cost center. |
| tiSource1Division_ID | integer | MirroringGL.Source1Division_ID | Source 1 Sub-Account |
| tcSource1DivisionCode | character | Division4.DivisionCode | Sub-Account |
| tiSource1GL_ID | integer | MirroringGL.Source1GL_ID | Source 1 Account Type |
| tcSource1GLCode | character | GL4.GLCode | A code identifying the GL account. |
| tcSource1GLSystemType | character | GL4.GLSystemTypeCode | System Type: A code identifying the type of system account. |
| tcSource1GLTypeCode | character | GL4.GLTypeCode | A code identifying the type of account. |
| tiSource1Project_ID | integer | MirroringGL.Source1Project_ID | Source 1 Project |
| tcSource1ProjectCode | character | Project2.ProjectCode | Project |
| tiSource2CostCentre_ID | integer | MirroringGL.Source2CostCentre_ID | Source 2 Cost Center |
| tcSource2CostCentreCode | character | CostCentre3.CostCentreCode | Cost Center: A code that identifies the cost center. |
| tiSource2Division_ID | integer | MirroringGL.Source2Division_ID | Source 2 Sub-Account |
| tcSource2DivisionCode | character | Division3.DivisionCode | Sub-Account |
| tiSource2GL_ID | integer | MirroringGL.Source2GL_ID | Source 2 Account Type |
| tcSource2GLCode | character | GL3.GLCode | A code identifying the GL account. |
| tcSource2GLSystemType | character | GL3.GLSystemTypeCode | System Type: A code identifying the type of system account. |
| tcSource2GLTypeCode | character | GL3.GLTypeCode | A code identifying the type of account. |
| tiSource2Project_ID | integer | MirroringGL.Source2Project_ID | Source 2 Project |
| tcSource2ProjectCode | character | Project1.ProjectCode | Project |
| ti_sequence | integer | calculated | primary index |
| tc_rowid | character | calculated | = rowid(MirroringGL),rowid(Company),rowid(CostCentre1),rowid(CostCentre2),rowid(CostCentre3),rowid(CostCentre4),rowid(Division1),rowid(Division2),rowid(Division3),rowid(Division4),rowid(Domains),rowid(GL1),rowid(GL2),rowid(GL3),rowid(GL4),rowid(Project1),rowid(Project2),rowid(Project3),rowid(Project4) |
Internal usage
QadFinancials