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