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