project QadFinancials > class BFRWReportMaster > business logic query FRWReportMasterForExcelInteg


query condition


  each FRWRepMstr where

      first FRWChart (inner-join) where
FRWChart.FRWChart_ID = FRWRepMstr.FRWChart_ID AND

      first FRWCol (inner-join) where
FRWCol.FRWCol_ID = FRWRepMstr.FRWCol_ID AND

      first FRWTreeNode (inner-join) where
FRWTreeNode.FRWTreeNode_ID = FRWRepMstr.FRWTreeNode_ID AND

      each FRWRepMstrRole (outer-join) where
FRWRepMstrRole.FRWRepMstr_ID = FRWRepMstr.FRWRepMstr_ID AND

          first Role (outer-join) where
Role.Role_ID = FRWRepMstrRole.Role_ID AND


query resultset tqFRWReportMasterForExcelInteg


field namedata typedb fielddescription
tcFRWChartCodecharacterFRWChart.FRWChartCodeChart
tcFRWColCodecharacterFRWCol.FRWColCodeColumn Group Code
tiFRWRepMstr_IDintegerFRWRepMstr.FRWRepMstr_IDRecord ID
tcFRWRepMstrCodecharacterFRWRepMstr.FRWRepMstrCodeReport Master Code
tcFRWRepMstrCodeDescOptioncharacterFRWRepMstr.FRWRepMstrCodeDescOptionCode, Description or Both
tcFRWRepMstrDescriptioncharacterFRWRepMstr.FRWRepMstrDescriptionReport MasterDescription
tiFRWRepMstrIndentPixelsintegerFRWRepMstr.FRWRepMstrIndentPixelsNumber of Pixels for Indent
tlFRWRepMstrIsZeroSuppreslogicalFRWRepMstr.FRWRepMstrIsZeroSuppresSuppress zero amounts on report
tcFRWRepMstrLabelForCodecharacterFRWRepMstr.FRWRepMstrLabelForCodeLabel for Code and Description
tiFRWRepMstrLevelsToPrintintegerFRWRepMstr.FRWRepMstrLevelsToPrintLevels To Print
tiFRWRepMstrMaxPostinglineintegerFRWRepMstr.FRWRepMstrMaxPostinglineMax Posting Lines
tiFRWRepMstrNumberOfDecimalsintegerFRWRepMstr.FRWRepMstrNumberOfDecimalsNumber of Decimals
tcFRWRepMstrPrintTransactionscharacterFRWRepMstr.FRWRepMstrPrintTransactionsPrint GL Transactions
tcFRWRepMstrSubTitlecharacterFRWRepMstr.FRWRepMstrSubTitleSubtitle
tcFRWRepMstrThousandMillioncharacterFRWRepMstr.FRWRepMstrThousandMillionReport Amount Scale
tcFRWRepMstrTitlecharacterFRWRepMstr.FRWRepMstrTitleReportTitle
tcFRWRepMstrZeroSuppressTypecharacterFRWRepMstr.FRWRepMstrZeroSuppressTypeZero Suppress Type
tcFRWTreeNodeCodecharacterFRWTreeNode.FRWTreeNodeCodeName
tcRoleNamecharacterRole.RoleNameRole Name
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(FRWRepMstr),rowid(FRWChart),rowid(FRWCol),rowid(FRWTreeNode),rowid(FRWRepMstrRole),rowid(Role)


Internal usage


QadFinancials
method BFRWReportMaster.ApiLoadFRWReportMaster