project QadFinancials > class BDomain > business logic query DomainSharedSetForVdMstr
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 vd_mstr (inner-join) where
vd_mstr.vd_domain = Domains.DomainCode AND
vd_mstr.vd_addr = icAddress
query resultset tqDomainSharedSetForVdMstr
| field name | data type | db field | description |
|---|
| tcDomainCode | character | Domains.DomainCode | Domain |
| tiSharedSet_ID | integer | DomainSharedSet.SharedSet_ID | Shared Set |
| tcvd_addr | character | vd_mstr.vd_addr | Supplier |
Internal usage
QadFinancials