project QadFinancials > class BFRWAnalysisCode > business logic query FRWColDetByFRWAnCodeId

Description

Query to find all FRW Col Det using the FRW Analysis code table


Parameters


icAnalysisCodeIDcharacterAnalysis Code ID


query condition


  each FRWAnCode where
FRWAnCode.FRWAnCode_ID = icAnalysisCodeID

      each FRWColDet (inner-join) where
FRWColDet.FRWAnCode_ID = FRWAnCode.FRWAnCode_ID AND

          first FRWCol (inner-join) where
FRWCol.FRWCol_ID = FRWColDet.FRWCol_ID AND


query resultset tqFRWColDetByFRWAnCodeId


field namedata typedb fielddescription
tiFRWAnCode_IDintegerFRWAnCode.FRWAnCode_IDRecord ID
tcFRWAnCodeCodecharacterFRWAnCode.FRWAnCodeCodeCode
tiFRWCol_IDintegerFRWColDet.FRWCol_IDLink to FRWCol
tcFRWColCodecharacterFRWCol.FRWColCodeColumn Group Code
tiFRWColDet_IDintegerFRWColDet.FRWColDet_IDRecord ID
tiFRWColDetSeqintegerFRWColDet.FRWColDetSeqColumn Sequence Number


Internal usage


QadFinancials
method BFRWAnalysisCode.ValidateComponentPreDelete