project QadFinancials > class BCOAMaskCC > business logic query COAMaskCCForDelGL
Parameters
iiCompanyId | integer | Company id |
iiCOAMaskCCId | integer | |
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 name | data type | db field | description |
tiCOAMaskCC_ID | integer | COAMaskCC.COAMaskCC_ID | COA Mask Cost Center |
tcCOAMaskCCCode | character | COAMaskCC.COAMaskCCCode | Cost Center COA Mask Code |
tcSharedSetCode | character | SharedSet.SharedSetCode | Shared Set Code |
Internal usage
QadFinancials