project QadFinancials > class BFRWAnalysisCode > business logic query FRWAnCodeByCodeChart
Parameters
| iiFRWChartId | integer | |
| icFRWChartCode | character | |
| iiFRWAnCodeId | integer | |
| icFRWAnCodeCode | character | |
query condition
each FRWAnCode where
FRWAnCode.FRWAnCode_ID = iiFRWAnCodeId AND
FRWAnCode.FRWAnCodeCode = icFRWAnCodeCode AND
FRWAnCode.FRWChart_ID = iiFRWChartId
first FRWChart (inner-join) where
FRWChart.FRWChart_ID = FRWAnCode.FRWChart_ID AND
FRWChart.FRWChartCode = icFRWChartCode
query resultset tqFRWAnCodeByCodeChart
| field name | data type | db field | description |
|---|
| tiFRWAnCode_ID | integer | FRWAnCode.FRWAnCode_ID | Record ID |
| tcFRWAnCodeCode | character | FRWAnCode.FRWAnCodeCode | Code |
| tiFRWChart_ID | integer | FRWAnCode.FRWChart_ID | Link to FRWChart |
| tcFRWChartCode | character | FRWChart.FRWChartCode | Chart |
Internal usage
QadFinancials