project QadFinancials > class BCubeQuery > business logic query CubeDimByChartCode
Description
Find FRW Chart related cube's CubeDim
Parameters
| icChartCode | character | |
| iiCompanyId | integer | Company id |
query condition
each FRWChart where
FRWChart.FRWChartCode = icChartCode
each FRWCube (inner-join) where
FRWCube.FRWChart_ID = FRWChart.FRWChart_ID AND
each FRWCubeDim (inner-join) where
FRWCubeDim.Company_Id = iiCompanyId AND
FRWCubeDim.FRWCube_ID = FRWCube.FRWCube_ID AND
query resultset tqCubeDimByChartCode
| field name | data type | db field | description |
|---|
| tiFRWChart_ID | integer | FRWChart.FRWChart_ID | Record ID |
| tcFRWChartCode | character | FRWChart.FRWChartCode | Chart |
| tcFRWCubeCode | character | FRWCube.FRWCubeCode | Name |
Internal usage
QadFinancials