project QadFinancials > class BDivision > business logic query DivisionForExcel

Parameters


iiCompanyIdintegerCompany id
iiCOAMaskDivSharedSetIdintegerId of the Shared set for COA Mask

query condition


  each Division where
Division.SharedSet_Id = vi_DIVISION_sharedset(iiCompanyId) AND

      each ProfileLink (outer-join) where
ProfileLink.Profile_ID = Division.COAMaskDivProfile_ID AND
ProfileLink.SharedSet_ID = iiCOAMaskDivSharedSetId

          first COAMaskDiv (outer-join) where
COAMaskDiv.SharedSet_Id = vi_SUBACCOUNTCOAMASK_sharedset(iiCompanyId) AND
COAMaskDiv.COAMaskDiv_ID = ProfileLink.ProfileLinkObject_ID AND

query resultset tqDivisionForExcel


field namedata typedb fielddescription
tiBudgetGroup_IDintegerDivision.BudgetGroup_IDLink to BudgetGroup
tcCOAMaskDivCodecharacterCOAMaskDiv.COAMaskDivCodeSub-Account COA Mask Code
tiCOAMaskDivProfile_IDintegerDivision.COAMaskDivProfile_IDCOA Mask Profile
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
tcDivisionDescriptioncharacterDivision.DivisionDescriptionDescription
tlDivisionIsActivelogicalDivision.DivisionIsActiveActive
ttLastModifiedDatedateDivision.LastModifiedDateLast Modified Date
tiLastModifiedTimeintegerDivision.LastModifiedTimeLast Modified Time
tcLastModifiedUsercharacterDivision.LastModifiedUserLast Modified User
tiProfileLinkSharedSet_IDintegerProfileLink.SharedSet_IDLink to SharedSet
tiSharedSet_IDintegerDivision.SharedSet_IDLink to SharedSet
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(Division),rowid(ProfileLink),rowid(COAMaskDiv)

Internal usage


QadFinancials
method BDivision.ApiLoadDivision