project QadFinancials > class BFRWAnalysisCode > business logic query FRWColDetByFRWAnCodeId
Description
Query to find all FRW Col Det using the FRW Analysis code table
Parameters
| icAnalysisCodeID | character | Analysis 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 name | data type | db field | description |
|---|
| tiFRWAnCode_ID | integer | FRWAnCode.FRWAnCode_ID | Record ID |
| tcFRWAnCodeCode | character | FRWAnCode.FRWAnCodeCode | Code |
| tiFRWCol_ID | integer | FRWColDet.FRWCol_ID | Link to FRWCol |
| tcFRWColCode | character | FRWCol.FRWColCode | Column Group Code |
| tiFRWColDet_ID | integer | FRWColDet.FRWColDet_ID | Record ID |
| tiFRWColDetSeq | integer | FRWColDet.FRWColDetSeq | Column Sequence Number |
Internal usage
QadFinancials