project QadFinancials > class BCOAMaskCC > business logic query COAMaskCCForDivAll


Parameters


iiCompanyIdintegerCompany id
iiDivisionSharedSetIdintegerID 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 namedata typedb fielddescription
tiCOAMaskCC_IDintegerCOAMaskCCDiv.COAMaskCC_IDCOA Mask CC
tiCOAMaskCCDiv_IDintegerCOAMaskCCDiv.COAMaskCCDiv_IDCOA Mask CC Range GL
tcCOAMaskCCDivDescrcharacterCOAMaskCCDiv.COAMaskCCDivDescrDescription
tcCOAMaskCCDivFromcharacterCOAMaskCCDiv.COAMaskCCDivFromFrom
tlCOAMaskCCDivIsNeglogicalCOAMaskCCDiv.COAMaskCCDivIsNegDisallowed Range
tcCOAMaskCCDivTocharacterCOAMaskCCDiv.COAMaskCCDivToTo
tiDivSharedSet_IDintegerCOAMaskCCDiv.DivSharedSet_IDShared Set
ttLastModifiedDatedateCOAMaskCCDiv.LastModifiedDateLast Modified Date
tiLastModifiedTimeintegerCOAMaskCCDiv.LastModifiedTimeLast Modified Time
tcLastModifiedUsercharacterCOAMaskCCDiv.LastModifiedUserLast Modified User
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(COAMaskCC),rowid(COAMaskCCDiv)


Internal usage


QadFinancials
method BCOAMaskCC.ApiLoadCOAMaskCC