business logic query FRWTreeViewByApiFields

Parameters

iiUsrId	integer
iiFRWAnCodeId	integer
iiFRWCubeId	integer
icFRWTreeViewAmountIn	character
iiFRWTreeViewReportPeriodFrom	integer
iiFRWTreeViewReportPeriodTo	integer
iiFRWTreeViewReportYearFrom	integer
iiFRWTreeViewReportYearTo	integer
iiFRWTreeNodeId	integer

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 name	data type	db field	description
tiFRWAnCode_ID	integer	FRWTreeView.FRWAnCode_ID
tiFRWCube_ID	integer	FRWTreeView.FRWCube_ID
tiFRWTreeNode_ID	integer	FRWTreeView.FRWTreeNode_ID
tiFRWTreeView_ID	integer	FRWTreeView.FRWTreeView_ID	Record ID
tcFRWTreeViewAmountsIn	character	FRWTreeView.FRWTreeViewAmountsIn	Amounts In
tlFRWTreeViewIsShared	logical	FRWTreeView.FRWTreeViewIsShared	Is Shared
tiFRWTreeViewReportPeriodFrom	integer	FRWTreeView.FRWTreeViewReportPeriodFrom	Report Period From
tiFRWTreeViewReportPeriodTo	integer	FRWTreeView.FRWTreeViewReportPeriodTo	Report Period To
tiFRWTreeViewReportYearFrom	integer	FRWTreeView.FRWTreeViewReportYearFrom	Report Year From
tiFRWTreeViewReportYearTo	integer	FRWTreeView.FRWTreeViewReportYearTo	Report Year To
tiUsr_ID	integer	FRWTreeView.Usr_ID
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(FRWTreeView)

Internal usage

QadFinancials

method BFRWTreeView.AdditionalUpdates
method BFRWTreeView.ValidationComponentFRWTreeViewCode