business logic query AltCOAStructDetForAll

query condition

each AltCOAStructDet where

first AltCOAGroup (conditional-join) where

AltCOAGroup.AltCOAGroup_ID = AltCOAStructDet.AltCOAGroup_ID AND

first AltCOAStruct (inner-join) where

AltCOAStruct.AltCOAStruct_ID = AltCOAStructDet.AltCOAStruct_ID AND

first AltCOAStructDet2 (conditional-join) where

AltCOAStructDet2.AltCOAStructDet_ID = AltCOAStructDet.ParentAltCOAStructDet_ID AND

field name	data type	db field	description
tiAltCOAGroup_ID	integer	AltCOAStructDet.AltCOAGroup_ID	Alternate COA Group
tcAltCOAGroupCode	character	AltCOAGroup.AltCOAGroupCode	Alternate COA Group Code
tiAltCOAStruct_ID	integer	AltCOAStructDet.AltCOAStruct_ID	Alternate COA Structure
tcAltCOAStructCode	character	AltCOAStruct.AltCOAStructCode	Code
tiAltCOAStructDet_ID	integer	AltCOAStructDet.AltCOAStructDet_ID	Alternate COA
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
tiParentAltCOAStructDet_ID	integer	AltCOAStructDet.ParentAltCOAStructDet_ID	Parent Alternate COA Structure Detail
tcParentAltCOAStructDetCode	character	AltCOAStructDet2.AltCOAStructDetCode	Alternate COA
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(AltCOAStructDet),rowid(AltCOAGroup),rowid(AltCOAStruct),rowid(AltCOAStructDet2)

QadFinancials