project QadFinancials > class BFRWAnalysisCode > business logic query GetFRWAnCodeAllByCodeChart

Description

Get Report Analysis Code information for Report Tree Export.

Parameters


icChartCodecharacter
icFRWAnCodeListcharacter

query condition


  each FRWAnCode where
FRWAnCode.FRWAnCodeCode can-do icFRWAnCodeList

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

          each FRWAnCodeElemDet (outer-join) where
FRWAnCodeElemDet.FRWAnCodeElem_ID = FRWAnCodeElem.FRWAnCodeElem_ID AND

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

query resultset tqGetFRWAnCodeAllByCodeChart


field namedata typedb fielddescription
tcCodeElemIDListcharactercalculatedStore the FRWAnCodeElemID list.
tiFRWAnCode_IDintegerFRWAnCode.FRWAnCode_IDRecord ID
tcFRWAnCodeAnalyseTextcharacterFRWAnCode.FRWAnCodeAnalyseTextAnalyse Text
tcFRWAnCodeAnalyseTypecharacterFRWAnCode.FRWAnCodeAnalyseTypeAnalyse Type
tcFRWAnCodeCalcElementcharacterFRWAnCode.FRWAnCodeCalcElementCalculation Element
tcFRWAnCodeCalcTypecharacterFRWAnCode.FRWAnCodeCalcTypeCalculation Type
tcFRWAnCodeCodecharacterFRWAnCode.FRWAnCodeCodeCode
tcFRWAnCodeDescriptioncharacterFRWAnCode.FRWAnCodeDescriptionDescription
tiFRWAnCodeElem_IDintegerFRWAnCodeElem.FRWAnCodeElem_IDRecord ID
tcFRWAnCodeElemCOATypecharacterFRWAnCodeElem.FRWAnCodeElemCOATypeCOA Type
tcFRWAnCodeElemDetCodecharacterFRWAnCodeElemDet.FRWAnCodeElemDetCodeCOA Element Code
tiFRWAnCodeElemDetValueintegerFRWAnCodeElemDet.FRWAnCodeElemDetValueCOA Type
tlFRWAnCodeElemIsDetRowExpllogicalFRWAnCodeElem.FRWAnCodeElemIsDetRowExplExplode Detail-rows
tcFRWAnCodeElemMaskcharacterFRWAnCodeElem.FRWAnCodeElemMaskElement Mask
tcFRWAnCodeElemMaskRange1characterFRWAnCodeElem.FRWAnCodeElemMaskRange1Mask Range 1
tcFRWAnCodeElemMaskRange2characterFRWAnCodeElem.FRWAnCodeElemMaskRange2Mask Range 2
tcFRWAnCodeELRcharacterFRWAnCode.FRWAnCodeELRELR
tcFRWAnCodeFRWChartCodecharacterFRWAnCode.FRWAnCodeFRWChartCodeChart
tcFRWAnCodeInfocharacterFRWAnCode.FRWAnCodeInfoSummary Info
tcFRWAnCodeTaxoNamecharacterFRWAnCode.FRWAnCodeTaxoNameTaxonomy Name
tcFRWAnCodeVersioncharacterFRWAnCode.FRWAnCodeVersionVersion
tcFRWAnCodeXBRElementcharacterFRWAnCode.FRWAnCodeXBRElementXBR Element
tcFRWChartCodecharacterFRWChart.FRWChartCodeChart
tcQADC01characterFRWAnCodeElem.QADC01unused QAD reserved field

Internal usage


QadFinancials
method BFRWAnalysisCode.GetFRWAnCodeAllInfo