business logic query COACrossRefDetByDomainID

Parameters

iiDomainID	integer	Source Domain ID
iiAltCOAStructID	integer
iiCOACrossRefID	integer	COA Cross Reference ID
icAltCOAStructDetCode	character	Alternate COA Structure Detail Code
icAltCOAStructDetSeq	character
icCOACrossRefCode	character

query condition

each COACrossRef where

COACrossRef.SourceDomain_ID = iiDomainID AND
COACrossRef.AltCOAStruct_ID = iiAltCOAStructID AND
COACrossRef.COACrossRefIsActive = true AND
COACrossRef.COACrossRef_ID = iiCOACrossRefID AND
COACrossRef.COACrossRefCode = icCOACrossRefCode

each COACrossRefDet (inner-join) where

COACrossRefDet.COACrossRef_ID = COACrossRef.COACrossRef_ID AND

first AltCOAStructDet (inner-join) where

AltCOAStructDet.AltCOAStructDet_ID = COACrossRefDet.TargetAltCOAStructDet_ID AND
AltCOAStructDet.AltCOAStructDetCode = icAltCOAStructDetCode AND
AltCOAStructDet.AltCOAStructDetSeq begins icAltCOAStructDetSeq

query resultset tqCOACrossRefDetByDomainID

field name	data type	db field	description
tcAltCOAStructDetCode	character	AltCOAStructDet.AltCOAStructDetCode	Alternate COA
tcAltCOAStructDetColLabel	character	AltCOAStructDet.AltCOAStructDetColLabel	Column Label
tcAltCOAStructDetDescription	character	AltCOAStructDet.AltCOAStructDetDescription	Description
tlAltCOAStructDetIsLeaf	logical	AltCOAStructDet.AltCOAStructDetIsLeaf	Leaf
tiAltCOAStructDetLevel	integer	AltCOAStructDet.AltCOAStructDetLevel	Level
tcAltCOAStructDetSeq	character	AltCOAStructDet.AltCOAStructDetSeq	Sequence
tiAlternateCOAStruct_ID	integer	COACrossRef.AltCOAStruct_ID	Alternate COA Structure
tiCOACrossRef_ID	integer	COACrossRef.COACrossRef_ID	COA Cross Reference
tcCOACrossRefCode	character	COACrossRef.COACrossRefCode	Code
tcCOACrossRefDetSrcCCFrom	character	COACrossRefDet.COACrossRefDetSrcCCFrom	Source Cost Center From
tcCOACrossRefDetSrcCCTo	character	COACrossRefDet.COACrossRefDetSrcCCTo	Source Cost Center To
tcCOACrossRefDetSrcDivFrom	character	COACrossRefDet.COACrossRefDetSrcDivFrom	Source Sub-Account From
tcCOACrossRefDetSrcDivTo	character	COACrossRefDet.COACrossRefDetSrcDivTo	Source Sub-Account To
tcCOACrossRefDetSrcGLFrom	character	COACrossRefDet.COACrossRefDetSrcGLFrom	Source GL Account From
tcCOACrossRefDetSrcGLTo	character	COACrossRefDet.COACrossRefDetSrcGLTo	Source GL Account To
tcCOACrossRefDetSrcProjFrom	character	COACrossRefDet.COACrossRefDetSrcProjFrom	Source Project From
tcCOACrossRefDetSrcProjTo	character	COACrossRefDet.COACrossRefDetSrcProjTo	Source Project To
tlCOACrossRefIsActive	logical	COACrossRef.COACrossRefIsActive	Active
tiSourceDomain_ID	integer	COACrossRef.SourceDomain_ID	Source Domain
tiTargetAlternateCOA_ID	integer	COACrossRefDet.TargetAltCOAStructDet_ID	Target Alternate COA

Internal usage

QadFinancials

method BAltCOAStruct.ValidateComponent
method BGLReport.AltAccBalanceTOT
method BGLReport.AltVATPayableLedger
method BGLReport.CBGLReport
method BGLReport.ColumnarLedgersForCOA
method BGLReport.GLReport
method BGLReport.SubLedgeReport
method BGLReport.ValidateFiltersForChineseBSIS