business logic query GLMaskByIDsCodes

Description

GetExistingGLMasks

Parameters

iiCompanyId	integer	Company id
icCostCentreCode	character	CostCentreCode; The parameter value that you pass will be matched with the CostCentre-code field using the matches-operator
icProjectCode	character	ProjectCode; The parameter value that you pass will be matched with the Project-code field using the matches-operator
icGLCode	character	GLCode; The parameter value that you pass will be matched with the G/L-code field using the matches-operator
icDvisionCode	character	DvisionCode; The parameter value that you pass will be matched with the Division-code field using the matches-operator
iiCostCentreID	integer	CostCentreID; possible values; -999999 : When passing this fixed value, only the G/L-Mask records with value 0 for this field will be returned. 0 : No condition on this value is executed <existing-value> : Only the records that fit this value are returned
iiProjectID	integer	ProjectID; possible values; -999999 : When passing this fixed value, only the G/L-Mask records with value 0 for this field will be returned. 0 : No condition on this value is executed <existing-value> : Only the records that fit this value are returned
iiGLID	integer	GLID; possible values; -999999 : When passing this fixed value, only the G/L-Mask records with value 0 for this field will be returned. 0 : No condition on this value is executed <existing-value> : Only the records that fit this value are returned
iiDivisionID	integer	DivisionID; possible values; -999999 : When passing this fixed value, only the G/L-Mask records with value 0 for this field will be returned. 0 : No condition on this value is executed <existing-value> : Only the records that fit this value are returned
iiGLMaskID	integer	GLMaskID
iiDomainID	integer

query condition

each GLMask where

GLMask.CostCentre_ID = ( if iiCostCentreID = -999999 then 0 else iiCostCentreID) AND
GLMask.Project_ID = ( if iiProjectID = -999999 then 0 else iiProjectID) AND
GLMask.GL_ID = ( if iiGLID = -999999 then 0 else iiGLID) AND
GLMask.Division_ID = ( if iiDivisionID = -999999 then 0 else iiDivisionID) AND
GLMask.GLMask_ID = iiGLMaskID AND
GLMask.Domain_ID = iiDomainID

first CostCentre (conditional-join) where

CostCentre.SharedSet_Id = vi_COSTCENTRE_sharedset(iiCompanyId) AND
CostCentre.CostCentre_ID = GLMask.CostCentre_ID AND
CostCentre.CostCentreCode matches icCostCentreCode

first Division (conditional-join) where

Division.SharedSet_Id = vi_DIVISION_sharedset(iiCompanyId) AND
Division.Division_ID = GLMask.Division_ID AND
Division.DivisionCode matches icDvisionCode

first GL (conditional-join) where

GL.SharedSet_Id = vi_GL_sharedset(iiCompanyId) AND
GL.GL_ID = GLMask.GL_ID AND
GL.GLCode matches icGLCode

first Project (conditional-join) where

Project.SharedSet_Id = vi_PROJECT_sharedset(iiCompanyId) AND
Project.Project_ID = GLMask.Project_ID AND
Project.ProjectCode matches icProjectCode

query resultset tqGLMaskByIDsCodes

field name	data type	db field	description
tiDomain_ID	integer	GLMask.Domain_ID	Domain
tlGLIsCostCentreAccount	logical	GL.GLIsCostCentreAccount	This field will be calculated by the system based on the value of tcAnalysisType. If the analysis type of the account is Project the value will be true.
	api annotation:		This field can be left blank as it will be calculated by the system.
tlGLIsDivisionAccount	logical	GL.GLIsDivisionAccount	Set to true if the account has a sub-account. Its value is calculated by the system and is determined by the value of tcDivisionProfileCode.
	api annotation:		This field can be left blank as it will be calculated by the system.
tlGLIsProjectAccount	logical	GL.GLIsProjectAccount	Project Analysis: This field will be calculated by the system based on the value of tcAnalysisType. If the analysis type of the account is Project the value will be true.
	api annotation:		This field can be left blank as it will be calculated by the system.
tiGLMask_ID	integer	GLMask.GLMask_ID	Record ID
tiGL_ID	integer	GLMask.GL_ID	GL Account
tiDivision_ID	integer	GLMask.Division_ID	Sub-Account Code
tiProject_ID	integer	GLMask.Project_ID	Project Code
tiCostCentre_ID	integer	GLMask.CostCentre_ID	Cost Center Code
tcGLCode	character	GL.GLCode	A code identifying the GL account.
tcDivisionCode	character	Division.DivisionCode	Sub-Account
tcProjectCode	character	Project.ProjectCode	Project
tcCostCentreCode	character	CostCentre.CostCentreCode	Cost Center: A code that identifies the cost center.

Internal usage

QadFinancials

method BGLMask.ApiGetGLMasks