project QadFinancials > class BFRWChart > business logic query FRWShSetCombByChart

Description

Select FRWShSetComb by chart


Parameters


iiChartIdinteger
icChartCodecharacter


query condition


  each FRWChart where
FRWChart.FRWChart_ID = iiChartId AND
FRWChart.FRWChartCode = icChartCode

      each FRWShSetComb (inner-join) where
FRWShSetComb.FRWChart_ID = FRWChart.FRWChart_ID AND


query resultset tqFRWShSetCombByChart


field namedata typedb fielddescription
tiCCCOACOACrossRef_IDintegerFRWShSetComb.CCCOACOACrossRef_IDLink To CC COACrossRef
tiCombCOACOACrossRef_IDintegerFRWShSetComb.CombCOACOACrossRef_IDLink To Combined COACrossRef
tiCostCentreSharedSet_IDintegerFRWShSetComb.CostCentreSharedSet_IDLink To CostCentreSharedSet
tiCostCentreSharedSet_ID1integerFRWChart.CostCentreSharedSet_IDLink To CostCentreSharedSet
tiDivCOACOACrossRef_IDintegerFRWShSetComb.DivCOACOACrossRef_IDLink To Div COACrossRef
tiDivisionSharedSet_IDintegerFRWShSetComb.DivisionSharedSet_IDLink To DivisionSharedSet
tiDivisionSharedSet_ID1integerFRWChart.DivisionSharedSet_IDLink To DivisionSharedSet
tiDomain_IDintegerFRWShSetComb.Domain_IDLink To Domain
tiFRWChart_IDintegerFRWChart.FRWChart_IDRecord ID
tcFRWChartCodecharacterFRWChart.FRWChartCodeChart
tiFRWShSetComb_IDintegerFRWShSetComb.FRWShSetComb_IDRecord ID
tcFRWShSetCombAllSetscharacterFRWShSetComb.FRWShSetCombAllSetsSets
tcFRWShSetCombCCCOACRCodecharacterFRWShSetComb.FRWShSetCombCCCOACRCodeCost Center Cross Ref
tcFRWShSetCombCCSSCodecharacterFRWShSetComb.FRWShSetCombCCSSCodeCost Center Shared Set
tcFRWShSetCombCombCOACRCodecharacterFRWShSetComb.FRWShSetCombCombCOACRCodeCombined Cross Ref
tcFRWShSetCombDivCOACRCodecharacterFRWShSetComb.FRWShSetCombDivCOACRCodeSub-Account Cross Ref
tcFRWShSetCombDivSSCodecharacterFRWShSetComb.FRWShSetCombDivSSCodeSub-Account Shared Set
tcFRWShSetCombFRWChartCodecharacterFRWShSetComb.FRWShSetCombFRWChartCodeChart
tcFRWShSetCombGLCOACRCodecharacterFRWShSetComb.FRWShSetCombGLCOACRCodeGL Cross Ref
tcFRWShSetCombGLSSCodecharacterFRWShSetComb.FRWShSetCombGLSSCodeGL Shared Set
tcFRWShSetCombPrjCOACRCodecharacterFRWShSetComb.FRWShSetCombPrjCOACRCodeProject Cross Ref
tcFRWShSetCombPrjSSCodecharacterFRWShSetComb.FRWShSetCombPrjSSCodeProject Shared Set
tiGLCOACrossRef_IDintegerFRWShSetComb.GLCOACrossRef_IDLink To GL COACrossRef
tiGLSharedSet_IDintegerFRWShSetComb.GLSharedSet_IDLink To GLSharedSet
tiGLSharedSet_ID1integerFRWChart.GLSharedSet_IDLink To GLSharedSet
tiPrjCOACOACrossRef_IDintegerFRWShSetComb.PrjCOACOACrossRef_IDLink To Prj COACrossRef
tiProjectSharedSet_IDintegerFRWShSetComb.ProjectSharedSet_IDLink To ProjectSharedSet
tiProjectSharedSet_ID1integerFRWChart.ProjectSharedSet_IDLink To ProjectSharedSet


Internal usage


QadFinancials
method BFRWChart.InitializeFRWXref