project QadFinancials > class BCOACrossRef > business logic query COACrossRefByAll

Description

Query For COA Cross Reference with all conditions


Parameters


iiCOACrossRefIDinteger
iiSourceDomainIDinteger
iiTargetDomainIDinteger
iiAltCOAStructIDinteger
icCOACrossRefCodecharacter
icCOACrossRefTypecharacter
ilCOACrossRefIsActivelogical
icSourceDomainCodecharacter
icTargetDomainCodecharacter
icAltCOAStructCodecharacter


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 namedata typedb fielddescription
tiCOACrossRef_IDintegerCOACrossRef.COACrossRef_IDCOA Cross Reference
tiSourceDomain_IDintegerCOACrossRef.SourceDomain_IDSource Domain
tiTargetDomain_IDintegerCOACrossRef.TargetDomain_IDTarget Domain
tiAltCOAStruct_IDintegerCOACrossRef.AltCOAStruct_IDAlternate COA Structure
tcCOACrossRefCodecharacterCOACrossRef.COACrossRefCodeCode
tcCOACrossRefDescriptioncharacterCOACrossRef.COACrossRefDescriptionDescription
tlCOACrossRefIsActivelogicalCOACrossRef.COACrossRefIsActiveActive
tcCOACrossRefTypecharacterCOACrossRef.COACrossRefTypeType
tcSourceDomainCodecharacterDomains1.DomainCodeDomain
tcTargetDomainCodecharacterDomains2.DomainCodeDomain
tcAltCOAStructCodecharacterAltCOAStruct.AltCOAStructCodeCode
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = 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