project QadFinancials > class BFRWColumnGroup > business logic query ColumnGroupDetForAllData


Parameters


iiFRWCol_IDinteger


query condition


  each FRWColDet where
FRWColDet.FRWCol_ID = iiFRWCol_ID


query sort order


FRWColDet.FRWCol_ID (ascending)
FRWColDet.FRWColDetSeq (ascending)


query resultset tqColumnGroupDetForAllData


field namedata typedb fielddescription
tiFRWAnCode_IDintegerFRWColDet.FRWAnCode_IDLink to FRWAnCode
tiFRWCol_IDintegerFRWColDet.FRWCol_IDLink to FRWCol
tiFRWColDet_IDintegerFRWColDet.FRWColDet_IDRecord ID
tcFRWColDetCalcFormulacharacterFRWColDet.FRWColDetCalcFormulaFormula for Calcualted Column
tcFRWColDetColumnTypecharacterFRWColDet.FRWColDetColumnTypeColumn Type
tiFRWColDetCompareOffsetintegerFRWColDet.FRWColDetCompareOffsetNumber Periods Offset
tcFRWColDetCompareTypecharacterFRWColDet.FRWColDetCompareTypePeriod Compare Type
tiFRWColDetFixedPeriodFromintegerFRWColDet.FRWColDetFixedPeriodFromFixed Period From
tiFRWColDetFixedPeriodTointegerFRWColDet.FRWColDetFixedPeriodToFixed Period To
tlFRWColDetIsBracketNegativelogicalFRWColDet.FRWColDetIsBracketNegativePrint negative amounts between brackets
tlFRWColDetIsFullAmountlogicalFRWColDet.FRWColDetIsFullAmountPrint Full Amount
tlFRWColDetIsHiddenColumnlogicalFRWColDet.FRWColDetIsHiddenColumnHide On Report
tlFRWColDetIsHideFuturePeriodlogicalFRWColDet.FRWColDetIsHideFuturePeriodHide Future Periods
tlFRWColDetIsRedNegativelogicalFRWColDet.FRWColDetIsRedNegativePrint negative Amounts in Red
tlFRWColDetIsWithCurrSignlogicalFRWColDet.FRWColDetIsWithCurrSignPrint Currency Sign
tlFRWColDetIsZeroSuppresslogicalFRWColDet.FRWColDetIsZeroSuppressZero Suppress
tcFRWColDetLabelcharacterFRWColDet.FRWColDetLabelColumn Label
tcFRWColDetLabelStylecharacterFRWColDet.FRWColDetLabelStyleLabel Style
tcFRWColDetLeadTrailUnitLabelcharacterFRWColDet.FRWColDetLeadTrailUnitLabelPercentage Sign or Currency Sign Position
tcFRWColDetMeasureStylecharacterFRWColDet.FRWColDetMeasureStyleMeasure Style Tag
tcFRWColDetMeasureTypecharacterFRWColDet.FRWColDetMeasureTypeMeasure Type
tcFRWColDetPeriodTypecharacterFRWColDet.FRWColDetPeriodTypePeriod Type
tiFRWColDetSeqintegerFRWColDet.FRWColDetSeqColumn Sequence Number
tcFRWColDetUnitLabelcharacterFRWColDet.FRWColDetUnitLabelPercentage or Currency Sign
tcFRWColDetUnitTypecharacterFRWColDet.FRWColDetUnitTypeUnit Type
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(FRWColDet)


Internal usage


QadFinancials
method BFRWColumnGroup.ApiLoadFRWColumnGroup