project QadFinancials > class BFRWColumnGroup > business logic query ColumnGroupByCodeChart
Parameters
| iiFRWChartId | integer | |
| iiFRWColId | integer | |
| icFRWColCode | character | |
| icFRWChartCode | character | |
query condition
each FRWCol where
FRWCol.FRWCol_ID = iiFRWColId AND
FRWCol.FRWColCode = icFRWColCode AND
FRWCol.FRWChart_ID = iiFRWChartId
first FRWChart (inner-join) where
FRWChart.FRWChart_ID = FRWCol.FRWChart_ID AND
FRWChart.FRWChartCode = icFRWChartCode
query resultset tqColumnGroupByCodeChart
| 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 |
Internal usage
QadFinancials