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