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
| iiDomainId | integer | Domain ID |
| iiGLID | integer | GLId |
| iiDivisionID | integer | DivisionID |
| iiProjectID | integer | Project ID |
| iiCostCentreID | integer | CostCentreId |
| iiGLMaskID | integer | GLMaskID |
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 name | data type | db field | description |
|---|
| tiDomain_ID | integer | GLMask.Domain_ID | Domain |
| 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 |
| ti_sequence | integer | calculated | primary index |
| tc_rowid | character | calculated | = rowid(GLMask) |
Internal usage
QadFinancials