project QadFinancials > class BDomain > business logic query DomainSharedSetForCmMstr
Parameters
| iiSharedSetId | integer | |
| icDomainCode | character | |
| icAddress | character | |
query condition
each DomainSharedSet where
DomainSharedSet.SharedSet_ID = iiSharedSetId
first Domains (inner-join) where
Domains.Domain_ID = DomainSharedSet.Domain_ID AND
Domains.DomainCode = icDomainCode
each cm_mstr (inner-join) where
cm_mstr.cm_domain = Domains.DomainCode AND
cm_mstr.cm_addr = icAddress
query resultset tqDomainSharedSetForCmMstr
| field name | data type | db field | description |
|---|
| tccm_addr | character | cm_mstr.cm_addr | Customer |
| tcDomainCode | character | Domains.DomainCode | Domain |
| tiSharedSet_ID | integer | DomainSharedSet.SharedSet_ID | Shared Set |
Internal usage
QadFinancials