business logic query ColumnGroupDetCompForAllData

Parameters

iiFRWColDet_ID

integer

each FRWColDetComp where

FRWColDetComp.FRWColDet_ID = iiFRWColDet_ID

first FRWAnCode1 (inner-join) where

FRWAnCode1.FRWAnCode_ID = FRWColDetComp.FromRangeFRWAnCode_ID AND

first FRWAnCode2 (inner-join) where

FRWAnCode2.FRWAnCode_ID = FRWColDetComp.ToRangeFRWAnCode_ID AND

FRWColDetComp.FRWColDet_ID (ascending)
FRWColDetComp.FRWColDetCompSeq (ascending)

field name	data type	db field	description
tiFromRangeFRWAnCode_ID	integer	FRWColDetComp.FromRangeFRWAnCode_ID	Link to FromRange-FRWAnCode
tcFRWAnCodeCode	character	FRWAnCode1.FRWAnCodeCode	Code
tcFRWAnCodeCode1	character	FRWAnCode2.FRWAnCodeCode	Code
tiFRWCol_ID	integer	FRWColDetComp.FRWCol_ID	Link to FRWCol
tiFRWColDet_ID	integer	FRWColDetComp.FRWColDet_ID	Link to FRWColDet
tiFRWColDetComp_ID	integer	FRWColDetComp.FRWColDetComp_ID	Record ID
tlFRWColDetCompIsSameRowAmt	logical	FRWColDetComp.FRWColDetCompIsSameRowAmt	Use Amount From Same Row
tiFRWColDetCompSeq	integer	FRWColDetComp.FRWColDetCompSeq	Line Number
tcFRWColDetCompSource	character	FRWColDetComp.FRWColDetCompSource	Use Amount From Column
tiSourceFRWAnCode_ID	integer	FRWColDetComp.SourceFRWAnCode_ID	Link to Source-FRWAnCode
tiToRangeFRWAnCode_ID	integer	FRWColDetComp.ToRangeFRWAnCode_ID	Link to ToRange-FRWAnCode
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(FRWColDetComp),rowid(FRWAnCode1),rowid(FRWAnCode2)

QadFinancials