project QadFinancials > class BFRWAnalysisCode > business logic query FRWAnCodeByCodeChart


Parameters


iiFRWChartIdinteger
icFRWChartCodecharacter
iiFRWAnCodeIdinteger
icFRWAnCodeCodecharacter


query condition


  each FRWAnCode where
FRWAnCode.FRWAnCode_ID = iiFRWAnCodeId AND
FRWAnCode.FRWAnCodeCode = icFRWAnCodeCode AND
FRWAnCode.FRWChart_ID = iiFRWChartId

      first FRWChart (inner-join) where
FRWChart.FRWChart_ID = FRWAnCode.FRWChart_ID AND
FRWChart.FRWChartCode = icFRWChartCode


query resultset tqFRWAnCodeByCodeChart


field namedata typedb fielddescription
tiFRWAnCode_IDintegerFRWAnCode.FRWAnCode_IDRecord ID
tcFRWAnCodeCodecharacterFRWAnCode.FRWAnCodeCodeCode
tiFRWChart_IDintegerFRWAnCode.FRWChart_IDLink to FRWChart
tcFRWChartCodecharacterFRWChart.FRWChartCodeChart


Internal usage


QadFinancials
method BFRWAnalysisCode.ValidateAnCodeForUpdate
method BFRWColumnGroup.ValidateComponentPreAnCode