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