project QadFinancials > class BDivision > business logic query DivisionForSharedSetMergeVal


Parameters


iiCompanyIdintegerCompany id
iiSharedSetIdinteger


query condition


  each Division where
Division.SharedSet_ID = iiSharedSetId

      first BudgetGroup (outer-join) where
BudgetGroup.BudgetGroup_ID = Division.BudgetGroup_ID AND


query sort order


Division.DivisionCode (ascending)


query resultset tqDivisionForSharedSetMergeVal


field namedata typedb fielddescription
tcBudgetGroupCodecharacterBudgetGroup.BudgetGroupCodeBudget Group
tcCustomCombo0characterDivision.CustomCombo0Custom Combo Field
tcCustomCombo1characterDivision.CustomCombo1Custom Combo Field
tcCustomCombo2characterDivision.CustomCombo2Custom Combo Field
tcCustomCombo3characterDivision.CustomCombo3Custom Combo Field
tcCustomCombo4characterDivision.CustomCombo4Custom Combo Field
tcCustomCombo5characterDivision.CustomCombo5Custom Combo Field
tcCustomCombo6characterDivision.CustomCombo6Custom Combo Field
tcCustomCombo7characterDivision.CustomCombo7Custom Combo Field
tcCustomCombo8characterDivision.CustomCombo8Custom Combo Field
tcCustomCombo9characterDivision.CustomCombo9Custom Combo Field
ttCustomDate0dateDivision.CustomDate0Custom Date Field
ttCustomDate1dateDivision.CustomDate1Custom Date Field
ttCustomDate2dateDivision.CustomDate2Custom Date Field
ttCustomDate3dateDivision.CustomDate3Custom Date Field
ttCustomDate4dateDivision.CustomDate4Custom Date Field
tdCustomDecimal0decimalDivision.CustomDecimal0Custom Decimal Field
tdCustomDecimal1decimalDivision.CustomDecimal1Custom Decimal Field
tdCustomDecimal2decimalDivision.CustomDecimal2Custom Decimal Field
tdCustomDecimal3decimalDivision.CustomDecimal3Custom Decimal Field
tdCustomDecimal4decimalDivision.CustomDecimal4Custom Decimal Field
tiCustomInteger0integerDivision.CustomInteger0Custom Integer Field
tiCustomInteger1integerDivision.CustomInteger1Custom Integer Field
tiCustomInteger2integerDivision.CustomInteger2Custom Integer Field
tiCustomInteger3integerDivision.CustomInteger3Custom Integer Field
tiCustomInteger4integerDivision.CustomInteger4Custom Integer Field
tcCustomLong0characterDivision.CustomLong0Custom Long Field
tcCustomLong1characterDivision.CustomLong1Custom Long Field
tcCustomNotecharacterDivision.CustomNoteCustom Note Field
tcCustomShort0characterDivision.CustomShort0Custom Short Field
tcCustomShort1characterDivision.CustomShort1Custom Short Field
tcCustomShort2characterDivision.CustomShort2Custom Short Field
tcCustomShort3characterDivision.CustomShort3Custom Short Field
tcCustomShort4characterDivision.CustomShort4Custom Short Field
tcCustomShort5characterDivision.CustomShort5Custom Short Field
tcCustomShort6characterDivision.CustomShort6Custom Short Field
tcCustomShort7characterDivision.CustomShort7Custom Short Field
tcCustomShort8characterDivision.CustomShort8Custom Short Field
tcCustomShort9characterDivision.CustomShort9Custom Short Field
tiDivision_IDintegerDivision.Division_IDRecord ID
tcDivisionCodecharacterDivision.DivisionCodeSub-Account
tlDivisionIsActivelogicalDivision.DivisionIsActiveActive
tiSharedSet_IDintegerDivision.SharedSet_IDLink to SharedSet


Internal usage


QadFinancials
method BSharedSetMerge.MergeValidateLoadSharedSetData