project QadFinancials > class BCOAMaskCC > business logic query COAMaskCCForGLAll


Parameters


iiCompanyIdintegerCompany id
iiGLSharedSetIdintegerID 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 namedata typedb fielddescription
tiCOAMaskCC_IDintegerCOAMaskCCGL.COAMaskCC_IDCOA Mask CC
tiCOAMaskCCGL_IDintegerCOAMaskCCGL.COAMaskCCGL_IDCOA Mask CC Range GL
tcCOAMaskCCGLDescrcharacterCOAMaskCCGL.COAMaskCCGLDescrDescription
tcCOAMaskCCGLFromcharacterCOAMaskCCGL.COAMaskCCGLFromFrom
tlCOAMaskCCGLIsNeglogicalCOAMaskCCGL.COAMaskCCGLIsNegDisallowed Range
tcCOAMaskCCGLTocharacterCOAMaskCCGL.COAMaskCCGLToTo
tiGLSharedSet_IDintegerCOAMaskCCGL.GLSharedSet_IDShared Set
ttLastModifiedDatedateCOAMaskCCGL.LastModifiedDateLast Modified Date
tiLastModifiedTimeintegerCOAMaskCCGL.LastModifiedTimeLast Modified Time
tcLastModifiedUsercharacterCOAMaskCCGL.LastModifiedUserLast Modified User
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(COAMaskCC),rowid(COAMaskCCGL)


Internal usage


QadFinancials
method BCOAMaskCC.ApiLoadCOAMaskCC