project QadFinancials > class BCOAMaskCC > business logic query COAMaskCCForGLAll

Parameters

iiCompanyId	integer	Company id
iiGLSharedSetId	integer	ID of the Shared Set used by GL accounts

query condition

each COAMaskCC where

COAMaskCC.SharedSet_Id = vi_COSTCENTERCOAMASK_sharedset(iiCompanyId) AND

each COAMaskCCGL (inner-join) where

COAMaskCCGL.COAMaskCC_ID = COAMaskCC.COAMaskCC_ID AND
COAMaskCCGL.GLSharedSet_ID = iiGLSharedSetId

query resultset tqCOAMaskCCForGLAll

field name	data type	db field	description
tiCOAMaskCC_ID	integer	COAMaskCCGL.COAMaskCC_ID	COA Mask CC
tiCOAMaskCCGL_ID	integer	COAMaskCCGL.COAMaskCCGL_ID	COA Mask CC Range GL
tcCOAMaskCCGLDescr	character	COAMaskCCGL.COAMaskCCGLDescr	Description
tcCOAMaskCCGLFrom	character	COAMaskCCGL.COAMaskCCGLFrom	From
tlCOAMaskCCGLIsNeg	logical	COAMaskCCGL.COAMaskCCGLIsNeg	Disallowed Range
tcCOAMaskCCGLTo	character	COAMaskCCGL.COAMaskCCGLTo	To
tiGLSharedSet_ID	integer	COAMaskCCGL.GLSharedSet_ID	Shared Set
ttLastModifiedDate	date	COAMaskCCGL.LastModifiedDate	Last Modified Date
tiLastModifiedTime	integer	COAMaskCCGL.LastModifiedTime	Last Modified Time
tcLastModifiedUser	character	COAMaskCCGL.LastModifiedUser	Last Modified User
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(COAMaskCC),rowid(COAMaskCCGL)

Internal usage

QadFinancials

method BCOAMaskCC.ApiLoadCOAMaskCC