project QadFinancials > class BCOAMaskCC > business logic query COAMaskCCForDelGL


Parameters


iiCompanyIdintegerCompany id
iiCOAMaskCCIdinteger


query condition


  each COAMaskCC where
COAMaskCC.SharedSet_Id = vi_COSTCENTERCOAMASK_sharedset(iiCompanyId) AND
COAMaskCC.COAMaskCC_ID = iiCOAMaskCCId

      each COAMaskCCGL (inner-join) where
COAMaskCCGL.COAMaskCC_ID = COAMaskCC.COAMaskCC_ID AND

          first SharedSet (inner-join) where
SharedSet.SharedSet_ID = COAMaskCCGL.GLSharedSet_ID AND


query resultset tqCOAMaskCCForDelGL


field namedata typedb fielddescription
tiCOAMaskCC_IDintegerCOAMaskCC.COAMaskCC_IDCOA Mask Cost Center
tcCOAMaskCCCodecharacterCOAMaskCC.COAMaskCCCodeCost Center COA Mask Code
tcSharedSetCodecharacterSharedSet.SharedSetCodeShared Set Code


Internal usage


QadFinancials
method BCOAMaskCC.CheckCOAMaskCCBeforeDelete