project QadFinancials > class BDivision > business logic query DivisionByCodeIsActive


Parameters


iiCompanyIdintegerCompany id
icDivisionCodecharacter
ilIsActivelogical


query condition


  each Division where
Division.SharedSet_Id = vi_DIVISION_sharedset(iiCompanyId) AND
Division.DivisionCode = icDivisionCode AND
Division.DivisionIsActive = ilIsActive


query resultset tqDivisionByCodeIsActive


field namedata typedb fielddescription
tiDivision_IDintegerDivision.Division_IDRecord ID
tcDivisionCodecharacterDivision.DivisionCodeSub-Account
tlDivisionIsActivelogicalDivision.DivisionIsActiveActive


Internal usage


QadFinancials
method BCOAValidation.ValidateCOA
method BDeductionCat.ValidateComponent