project QadFinancials > class BDomain > business logic query DomainBySharedSetDomain

Description

Get list of domains using certain shared set

Parameters

iiSharedSetId	integer	Shared Set ID
iiDomainID	integer	Domain ID
icDomainCode	character	Domain Code

query condition

each DomainSharedSet where

DomainSharedSet.SharedSet_ID = iiSharedSetId AND
DomainSharedSet.Domain_ID = iiDomainID

first Domains (inner-join) where

Domains.Domain_ID = DomainSharedSet.Domain_ID AND
Domains.DomainCode = icDomainCode

each DomainProperty (inner-join) where

DomainProperty.Domain_ID = Domains.Domain_ID AND

query resultset tqDomainBySharedSetDomain

field name	data type	db field	description
tiDomain_ID	integer	DomainSharedSet.Domain_ID	Domain
tcDomainCode	character	Domains.DomainCode	Domain
tlDomainIsActive	logical	Domains.DomainIsActive	Active
tlDomainPropertyIsSetupCompl	logical	DomainProperty.DomainPropertyIsSetupCompl	Setup Complete
tiDomainSharedSet_ID	integer	DomainSharedSet.DomainSharedSet_ID	Record ID
tiLng_ID	integer	Domains.Lng_ID	Language
tiPrimaryCompany_ID	integer	Domains.PrimaryCompany_ID	Primary Entity
tiSharedSet_ID	integer	DomainSharedSet.SharedSet_ID	Shared Set

Internal usage

QadFinancials

method BCreditor.DefaultValuesBusinessRelation
method BCreditor.PostValidateComponent
method BDebtor.DefaultValuesBusinessRelation
method BDebtor.PostValidateComponent
method BDebtor.ValidateComponent
method BGL.ValidateComponentPost
method BJournal.ValidateComponent
method BMfgAccount.ApiReplicateFromFinancials
method BMfgAddress.ApiReplicateFromFinancialsCreditor
method BMfgAddress.ApiReplicateFromFinancialsDebtor
method BMfgAddress.ApiReplicateFromFinancialsEndUSer
method BMfgAddress.ApiReplicateFromFinancialsShipTo
method BMfgAddress.ReplicateFromFinancialsShipToDebtorLink
method BMfgAddressListDetail.ApiReplicateFromFinancialsCreditor
method BMfgAddressListDetail.ApiReplicateFromFinancialsDebtor
method BMfgAddressListDetail.ApiReplicateFromFinancialsEndUser
method BMfgAddressListDetail.ApiReplicateFromFinancialsShipTo
method BMfgCostCenter.ApiReplicateFromFinancials
method BMfgCustomer.ApiReplicateFromFinancials
method BMfgDaybook.ApiReplicateFromFinancials
method BMfgEndUser.ApiReplicateFromFinancials
method BMfgEndUser.MaintainDataBusinessRelation
method BMfgExchangeRate.ApiReplicateFromFinancials
method BMfgNRM.ApiReplicateFromFinancials
method BMfgProject.ApiReplicateFromFinancials
method BMfgSubAccount.ApiReplicateFromFinancials
method BMfgSupplier.ApiReplicateFromFinancials
method BSharedSetMerge.MergeInit