project QadFinancials > class BFRWColumnGroup > business logic query ColumnGroupForAllData
Description
get a column group
Parameters
iiCol_ID | integer | column 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 name | data type | db field | description |
tiFRWChart_ID | integer | FRWCol.FRWChart_ID | Link To FRWChart |
tcFRWChartCode | character | FRWChart.FRWChartCode | Chart |
tiFRWCol_ID | integer | FRWCol.FRWCol_ID | Record ID |
tcFRWColCode | character | FRWCol.FRWColCode | Column Group Code |
tcFRWColDescription | character | FRWCol.FRWColDescription | Column Group Description |
tlFRWColIsInvertSign | logical | FRWCol.FRWColIsInvertSign | Invert Sign |
ti_sequence | integer | calculated | primary index |
tc_rowid | character | calculated | = rowid(FRWCol),rowid(FRWChart) |
Internal usage
QadFinancials