project BLF > class BWorkObject > business logic query LookupWorkObject
Description
LookupWorkObject
Parameters
| iiCompanyId | integer | Company id |
| icBusComponentCode | character | |
| iiInternalObjectId | integer | value of the identity field of business class main table record |
query condition
each WorkObject where
WorkObject.Company_Id = iiCompanyId AND
WorkObject.WorkObjectInternal_ID = iiInternalObjectId
first BusComponent (inner-join) where
BusComponent.BusComponent_ID = WorkObject.BusComponent_ID AND
BusComponent.BusComponentCode = icBusComponentCode
query resultset tqLookupWorkObject
| field name | data type | db field | description |
|---|
| tiWorkObject_ID | integer | WorkObject.WorkObject_ID | Record ID |
| tiWorkObjectInternal_ID | integer | WorkObject.WorkObjectInternal_ID | Identification of the business object
(= identity value of the main table record) |
Internal usage
BLF
QadFinancials