business logic query COACrossRefByAll

Description

Query For COA Cross Reference with all conditions

Parameters

iiCOACrossRefID	integer
iiSourceDomainID	integer
iiTargetDomainID	integer
iiAltCOAStructID	integer
icCOACrossRefCode	character
icCOACrossRefType	character
ilCOACrossRefIsActive	logical
icSourceDomainCode	character
icTargetDomainCode	character
icAltCOAStructCode	character

query condition

each COACrossRef where

COACrossRef.COACrossRef_ID = iiCOACrossRefID AND
COACrossRef.COACrossRefCode = icCOACrossRefCode AND
COACrossRef.SourceDomain_ID = iiSourceDomainID AND
COACrossRef.TargetDomain_ID = iiTargetDomainID AND
COACrossRef.COACrossRefType = icCOACrossRefType AND
COACrossRef.COACrossRefIsActive = ilCOACrossRefIsActive AND
COACrossRef.AltCOAStruct_ID = iiAltCOAStructID

first AltCOAStruct (conditional-join) where

AltCOAStruct.AltCOAStruct_ID = COACrossRef.AltCOAStruct_ID AND
AltCOAStruct.AltCOAStructCode = icAltCOAStructCode

first Domains1 (inner-join) where

Domains1.Domain_ID = COACrossRef.SourceDomain_ID AND
Domains1.DomainCode = icSourceDomainCode

first Domains2 (inner-join) where

Domains2.Domain_ID = COACrossRef.TargetDomain_ID AND
Domains2.DomainCode = icTargetDomainCode

query sort order

COACrossRef.SourceDomain_ID (ascending)
COACrossRef.COACrossRefCode (ascending)

query resultset tqCOACrossRefByAll

field name	data type	db field	description
tiCOACrossRef_ID	integer	COACrossRef.COACrossRef_ID	COA Cross Reference
tiSourceDomain_ID	integer	COACrossRef.SourceDomain_ID	Source Domain
tiTargetDomain_ID	integer	COACrossRef.TargetDomain_ID	Target Domain
tiAltCOAStruct_ID	integer	COACrossRef.AltCOAStruct_ID	Alternate COA Structure
tcCOACrossRefCode	character	COACrossRef.COACrossRefCode	Code
tcCOACrossRefDescription	character	COACrossRef.COACrossRefDescription	Description
tlCOACrossRefIsActive	logical	COACrossRef.COACrossRefIsActive	Active
tcCOACrossRefType	character	COACrossRef.COACrossRefType	Type
tcSourceDomainCode	character	Domains1.DomainCode	Domain
tcTargetDomainCode	character	Domains2.DomainCode	Domain
tcAltCOAStructCode	character	AltCOAStruct.AltCOAStructCode	Code
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(COACrossRef),rowid(AltCOAStruct),rowid(Domains1),rowid(Domains2)

Internal usage

QadFinancials

method BAccountingInterface.FillProDsAccntBook
method BAccountingInterface.FillProDsChartOfAccnt
method BCOACrossRef.ApiLoadCOACrossRef
method BCOACrossRef.GetCOACrossRef
method BConsolidCycle.ValidateComponentAll
method BConsolidCycle.ValidateComponentAllCrossReference
method BFRWChart.GetCOACrossRefByCode
method BFRWChart.ValidateComponentAllCOACrossRef