project QadFinancials > class BFRWAnalysisCode > business logic query FRWAnCodeByCodeChartForGLChart


Parameters


iiFRWAnCode_IDinteger
icFRWChart_IDcharacter


query condition


  each FRWAnCode where
FRWAnCode.FRWAnCode_ID = iiFRWAnCode_ID AND
FRWAnCode.FRWChart_ID = icFRWChart_ID

      each FRWAnCodeElem (conditional-join) where
FRWAnCodeElem.FRWAnCode_ID = FRWAnCode.FRWAnCode_ID AND

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


query resultset tqFRWAnCodeByCodeChartForGLChart


field namedata typedb fielddescription
tcFRWAnCodeAnalyseTypecharacterFRWAnCode.FRWAnCodeAnalyseTypeAnalyse Type
tiFRWAnCodeElem_IDintegerFRWAnCodeElem.FRWAnCodeElem_IDRecord ID
tcFRWAnCodeElemCOATypecharacterFRWAnCodeElem.FRWAnCodeElemCOATypeCOA Type
tcFRWAnCodeElemMaskcharacterFRWAnCodeElem.FRWAnCodeElemMaskElement Mask
tcFRWAnCodeElemMaskRange1characterFRWAnCodeElem.FRWAnCodeElemMaskRange1Mask Range 1
tcFRWAnCodeElemMaskRange2characterFRWAnCodeElem.FRWAnCodeElemMaskRange2Mask Range 2
tiGLSharedSet_IDintegerFRWChart.GLSharedSet_IDLink To GLSharedSet


Internal usage


QadFinancials
method BReportTree.LoadGLChartCompletenessCheck