project QadFinancials > class BDomain > business logic query DomainSharedSetForEuMstr
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 eu_mstr (inner-join) where
eu_mstr.eu_domain = Domains.DomainCode AND
eu_mstr.eu_addr = icAddress
query resultset tqDomainSharedSetForEuMstr
| field name | data type | db field | description |
|---|
| tcDomainCode | character | Domains.DomainCode | Domain |
| tceu_addr | character | eu_mstr.eu_addr | End User |
| tiSharedSet_ID | integer | DomainSharedSet.SharedSet_ID | Shared Set |
Internal usage
QadFinancials