project QadFinancials > class BFRWTreeView > business logic query FRWTreeViewByApiFields


Parameters


iiUsrIdinteger
iiFRWAnCodeIdinteger
iiFRWCubeIdinteger
icFRWTreeViewAmountIncharacter
iiFRWTreeViewReportPeriodFrominteger
iiFRWTreeViewReportPeriodTointeger
iiFRWTreeViewReportYearFrominteger
iiFRWTreeViewReportYearTointeger
iiFRWTreeNodeIdinteger


query condition


  each FRWTreeView where
FRWTreeView.Usr_ID = iiUsrId AND
FRWTreeView.FRWAnCode_ID = iiFRWAnCodeId AND
FRWTreeView.FRWCube_ID = iiFRWCubeId AND
FRWTreeView.FRWTreeNode_ID = iiFRWTreeNodeId AND
FRWTreeView.FRWTreeViewReportPeriodFrom = iiFRWTreeViewReportPeriodFrom AND
FRWTreeView.FRWTreeViewReportPeriodTo = iiFRWTreeViewReportPeriodTo AND
FRWTreeView.FRWTreeViewReportYearFrom = iiFRWTreeViewReportYearFrom AND
FRWTreeView.FRWTreeViewReportYearTo = iiFRWTreeViewReportYearTo AND
FRWTreeView.FRWTreeViewAmountsIn = icFRWTreeViewAmountIn


query resultset tqFRWTreeViewByApiFields


field namedata typedb fielddescription
tiFRWAnCode_IDintegerFRWTreeView.FRWAnCode_ID
tiFRWCube_IDintegerFRWTreeView.FRWCube_ID
tiFRWTreeNode_IDintegerFRWTreeView.FRWTreeNode_ID
tiFRWTreeView_IDintegerFRWTreeView.FRWTreeView_IDRecord ID
tcFRWTreeViewAmountsIncharacterFRWTreeView.FRWTreeViewAmountsInAmounts In
tlFRWTreeViewIsSharedlogicalFRWTreeView.FRWTreeViewIsSharedIs Shared
tiFRWTreeViewReportPeriodFromintegerFRWTreeView.FRWTreeViewReportPeriodFromReport Period From
tiFRWTreeViewReportPeriodTointegerFRWTreeView.FRWTreeViewReportPeriodToReport Period To
tiFRWTreeViewReportYearFromintegerFRWTreeView.FRWTreeViewReportYearFromReport Year From
tiFRWTreeViewReportYearTointegerFRWTreeView.FRWTreeViewReportYearToReport Year To
tiUsr_IDintegerFRWTreeView.Usr_ID
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(FRWTreeView)


Internal usage


QadFinancials
method BFRWTreeView.AdditionalUpdates
method BFRWTreeView.ValidationComponentFRWTreeViewCode