project QadFinancials > class BDivision > business logic query DivisionForSharedSetMergeVal
Parameters
| iiCompanyId | integer | Company id |
| iiSharedSetId | integer | |
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 name | data type | db field | description |
|---|
| tcBudgetGroupCode | character | BudgetGroup.BudgetGroupCode | Budget Group |
| tcCustomCombo0 | character | Division.CustomCombo0 | Custom Combo Field |
| tcCustomCombo1 | character | Division.CustomCombo1 | Custom Combo Field |
| tcCustomCombo2 | character | Division.CustomCombo2 | Custom Combo Field |
| tcCustomCombo3 | character | Division.CustomCombo3 | Custom Combo Field |
| tcCustomCombo4 | character | Division.CustomCombo4 | Custom Combo Field |
| tcCustomCombo5 | character | Division.CustomCombo5 | Custom Combo Field |
| tcCustomCombo6 | character | Division.CustomCombo6 | Custom Combo Field |
| tcCustomCombo7 | character | Division.CustomCombo7 | Custom Combo Field |
| tcCustomCombo8 | character | Division.CustomCombo8 | Custom Combo Field |
| tcCustomCombo9 | character | Division.CustomCombo9 | Custom Combo Field |
| ttCustomDate0 | date | Division.CustomDate0 | Custom Date Field |
| ttCustomDate1 | date | Division.CustomDate1 | Custom Date Field |
| ttCustomDate2 | date | Division.CustomDate2 | Custom Date Field |
| ttCustomDate3 | date | Division.CustomDate3 | Custom Date Field |
| ttCustomDate4 | date | Division.CustomDate4 | Custom Date Field |
| tdCustomDecimal0 | decimal | Division.CustomDecimal0 | Custom Decimal Field |
| tdCustomDecimal1 | decimal | Division.CustomDecimal1 | Custom Decimal Field |
| tdCustomDecimal2 | decimal | Division.CustomDecimal2 | Custom Decimal Field |
| tdCustomDecimal3 | decimal | Division.CustomDecimal3 | Custom Decimal Field |
| tdCustomDecimal4 | decimal | Division.CustomDecimal4 | Custom Decimal Field |
| tiCustomInteger0 | integer | Division.CustomInteger0 | Custom Integer Field |
| tiCustomInteger1 | integer | Division.CustomInteger1 | Custom Integer Field |
| tiCustomInteger2 | integer | Division.CustomInteger2 | Custom Integer Field |
| tiCustomInteger3 | integer | Division.CustomInteger3 | Custom Integer Field |
| tiCustomInteger4 | integer | Division.CustomInteger4 | Custom Integer Field |
| tcCustomLong0 | character | Division.CustomLong0 | Custom Long Field |
| tcCustomLong1 | character | Division.CustomLong1 | Custom Long Field |
| tcCustomNote | character | Division.CustomNote | Custom Note Field |
| tcCustomShort0 | character | Division.CustomShort0 | Custom Short Field |
| tcCustomShort1 | character | Division.CustomShort1 | Custom Short Field |
| tcCustomShort2 | character | Division.CustomShort2 | Custom Short Field |
| tcCustomShort3 | character | Division.CustomShort3 | Custom Short Field |
| tcCustomShort4 | character | Division.CustomShort4 | Custom Short Field |
| tcCustomShort5 | character | Division.CustomShort5 | Custom Short Field |
| tcCustomShort6 | character | Division.CustomShort6 | Custom Short Field |
| tcCustomShort7 | character | Division.CustomShort7 | Custom Short Field |
| tcCustomShort8 | character | Division.CustomShort8 | Custom Short Field |
| tcCustomShort9 | character | Division.CustomShort9 | Custom Short Field |
| tiDivision_ID | integer | Division.Division_ID | Record ID |
| tcDivisionCode | character | Division.DivisionCode | Sub-Account |
| tlDivisionIsActive | logical | Division.DivisionIsActive | Active |
| tiSharedSet_ID | integer | Division.SharedSet_ID | Link to SharedSet |
Internal usage
QadFinancials