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