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