project QadFinancials > class BCubeQuery > business logic query CubeDimByChartCode

Description

Find FRW Chart related cube's CubeDim


Parameters


icChartCodecharacter
iiCompanyIdintegerCompany 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 namedata typedb fielddescription
tiFRWChart_IDintegerFRWChart.FRWChart_IDRecord ID
tcFRWChartCodecharacterFRWChart.FRWChartCodeChart
tcFRWCubeCodecharacterFRWCube.FRWCubeCodeName


Internal usage


QadFinancials
method BFRWChart.CheckChartHasData