business logic query ScanDaemonLocationInfo

Parameters

iiCompanyId

integer

Company id

each ScanDaemonLocation where

ScanDaemonLocation.Company_Id = iiCompanyId AND

first BusComponent (inner-join) where

BusComponent.BusComponent_ID = ScanDaemonLocation.BusComponent_ID AND

field name	data type	db field	description
tiBusComponent_ID	integer	ScanDaemonLocation.BusComponent_ID	Business Component
tcBusComponentCode	character	BusComponent.BusComponentCode	Component
tiCompany_ID	integer	ScanDaemonLocation.Company_ID	Entity
tcDummy	character	calculated	only created to create a global calculation method
tcScanDaemonLocationDir	character	ScanDaemonLocation.ScanDaemonLocationDir	Location

BLF