business logic query ActivityCodeByCodeTypeAct

Parameters

icActiveCode	character
icActiveCodeType	character
ilActiveCodeIsActive	logical

query condition

each ActivityCode where

ActivityCode.ActivityCode matches icActiveCode AND
ActivityCode.ActivityCodeType matches icActiveCodeType AND
ActivityCode.ActivityCodeIsActive = ilActiveCodeIsActive

query resultset tqActivityCodeByCodeTypeAct

field name	data type	db field	description
tcActivityCode	character	ActivityCode.ActivityCode	Activity Code
tiActivityCode_ID	integer	ActivityCode.ActivityCode_ID	Record ID
tcActivityCodeDescription	character	ActivityCode.ActivityCodeDescription	Description
tlActivityCodeIsActive	logical	ActivityCode.ActivityCodeIsActive	Active
tcActivityCodeType	character	ActivityCode.ActivityCodeType	Activity Type

Internal usage

QadFinancials

method BEmployee.ValActiveActivity