project QadFinancials > class BMirroringGL > business logic query MirroringGLBySourceGLAnalysis

Description

This query returns the mirroring gl accounts per domain for source1 and source 2 GL ID.

Parameters


iiCompanyIdintegerCompany id
iiDomainIdinteger
iiSource1GLIdinteger
iiSource2GLIdinteger

query condition


  each MirroringGL where
MirroringGL.Company_Id = iiCompanyId AND
MirroringGL.Domain_ID = iiDomainId AND
MirroringGL.Source1GL_ID = iiSource1GLId AND
MirroringGL.Source2GL_ID = iiSource2GLId

query resultset tqMirroringGLBySourceGLAnalysis


field namedata typedb fielddescription
tiCompany_IDintegerMirroringGL.Company_IDEntity
tiDomain_IDintegerMirroringGL.Domain_IDDomain
tiMirroringGL_IDintegerMirroringGL.MirroringGL_IDRecord ID
tiSource1CostCentre_IDintegerMirroringGL.Source1CostCentre_IDSource 1 Cost Center
tiSource1Division_IDintegerMirroringGL.Source1Division_IDSource 1 Sub-Account
tiSource1GL_IDintegerMirroringGL.Source1GL_IDSource 1 Account Type
tiSource1Project_IDintegerMirroringGL.Source1Project_IDSource 1 Project
tiSource2CostCentre_IDintegerMirroringGL.Source2CostCentre_IDSource 2 Cost Center
tiSource2Division_IDintegerMirroringGL.Source2Division_IDSource 2 Sub-Account
tiSource2GL_IDintegerMirroringGL.Source2GL_IDSource 2 Account Type
tiSource2Project_IDintegerMirroringGL.Source2Project_IDSource 2 Project

Internal usage


QadFinancials
method BMirroringGL.ValidateComponentPost
method BMirroringGL.ValidateComponentPostAnalysis
method BMirroringGL.ValidateComponentPostAnalysis1