project QadFinancials > class BGLMask > business logic query GLMaskPrim

Description

GLMaskPrim; query that can be used find G/L Masks based on the prim-key or base don the logical, unique key


Parameters


iiDomainIdintegerDomain ID
iiGLIDintegerGLId
iiDivisionIDintegerDivisionID
iiProjectIDintegerProject ID
iiCostCentreIDintegerCostCentreId
iiGLMaskIDintegerGLMaskID


query condition


  each GLMask where
GLMask.GL_ID = iiGLID AND
GLMask.Division_ID = iiDivisionID AND
GLMask.Project_ID = iiProjectID AND
GLMask.CostCentre_ID = iiCostCentreID AND
GLMask.GLMask_ID = iiGLMaskID AND
GLMask.Domain_ID = iiDomainId


query resultset tqGLMaskPrim


field namedata typedb fielddescription
tiDomain_IDintegerGLMask.Domain_IDDomain
tiGLMask_IDintegerGLMask.GLMask_IDRecord ID
tiGL_IDintegerGLMask.GL_IDGL Account
tiDivision_IDintegerGLMask.Division_IDSub-Account Code
tiProject_IDintegerGLMask.Project_IDProject Code
tiCostCentre_IDintegerGLMask.CostCentre_IDCost Center Code
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(GLMask)


Internal usage


QadFinancials
method BGLMask.ApiStdMaintainTT