project QadFinancials > class BFRWColumnGroup > business logic query ColumnGroupForAllData

Description

get a column group


Parameters


iiCol_IDintegercolumn group id


query condition


  each FRWCol where
FRWCol.FRWCol_ID = iiCol_ID

      first FRWChart (inner-join) where
FRWChart.FRWChart_ID = FRWCol.FRWChart_ID AND


query resultset tqColumnGroupForAllData


field namedata typedb fielddescription
tiFRWChart_IDintegerFRWCol.FRWChart_IDLink To FRWChart
tcFRWChartCodecharacterFRWChart.FRWChartCodeChart
tiFRWCol_IDintegerFRWCol.FRWCol_IDRecord ID
tcFRWColCodecharacterFRWCol.FRWColCodeColumn Group Code
tcFRWColDescriptioncharacterFRWCol.FRWColDescriptionColumn Group Description
tlFRWColIsInvertSignlogicalFRWCol.FRWColIsInvertSignInvert Sign
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(FRWCol),rowid(FRWChart)


Internal usage


QadFinancials
method BFRWColumnGroup.ApiLoadFRWColumnGroup