project QadFinancials > class BCOAMaskCC > business logic query COAMaskCCForDivAll

Parameters

iiCompanyId	integer	Company id
iiDivisionSharedSetId	integer	ID of the Cost centre shared set

query condition

each COAMaskCC where

COAMaskCC.SharedSet_Id = vi_COSTCENTERCOAMASK_sharedset(iiCompanyId) AND

each COAMaskCCDiv (inner-join) where

COAMaskCCDiv.COAMaskCC_ID = COAMaskCC.COAMaskCC_ID AND
COAMaskCCDiv.DivSharedSet_ID = iiDivisionSharedSetId

query resultset tqCOAMaskCCForDivAll

field name	data type	db field	description
tiCOAMaskCC_ID	integer	COAMaskCCDiv.COAMaskCC_ID	COA Mask CC
tiCOAMaskCCDiv_ID	integer	COAMaskCCDiv.COAMaskCCDiv_ID	COA Mask CC Range GL
tcCOAMaskCCDivDescr	character	COAMaskCCDiv.COAMaskCCDivDescr	Description
tcCOAMaskCCDivFrom	character	COAMaskCCDiv.COAMaskCCDivFrom	From
tlCOAMaskCCDivIsNeg	logical	COAMaskCCDiv.COAMaskCCDivIsNeg	Disallowed Range
tcCOAMaskCCDivTo	character	COAMaskCCDiv.COAMaskCCDivTo	To
tiDivSharedSet_ID	integer	COAMaskCCDiv.DivSharedSet_ID	Shared Set
ttLastModifiedDate	date	COAMaskCCDiv.LastModifiedDate	Last Modified Date
tiLastModifiedTime	integer	COAMaskCCDiv.LastModifiedTime	Last Modified Time
tcLastModifiedUser	character	COAMaskCCDiv.LastModifiedUser	Last Modified User
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(COAMaskCC),rowid(COAMaskCCDiv)

Internal usage

QadFinancials

method BCOAMaskCC.ApiLoadCOAMaskCC