project BLF > class BUser > business logic query UsrCompanyPrim
Description
Query used to convert the physical prim-key into the logical-prim-key and vice-versa
Parameters
| iiCompanyId | integer | Company id |
| iiUsrCompanyID | integer | UsrCompanyID |
| icUsrLogin | character | |
| icCompanyCode | character | Entity Code |
query condition
each UsrCompany where
UsrCompany.Company_Id = iiCompanyId AND
UsrCompany.UsrCompany_ID = iiUsrCompanyID
first Company (inner-join) where
Company.Company_Id = iiCompanyId AND
Company.Company_ID = UsrCompany.Company_ID AND
Company.CompanyCode = icCompanyCode
first Usr (inner-join) where
Usr.Usr_ID = UsrCompany.Usr_ID AND
Usr.UsrLogin = icUsrLogin
query resultset tqUsrCompanyPrim
| field name | data type | db field | description |
|---|
| tcUsrLogin | character | Usr.UsrLogin | Login |
| tiUsrCompany_ID | integer | UsrCompany.UsrCompany_ID | Record ID |
| tcCompanyCode | character | Company.CompanyCode | Entity Code |
Internal usage
BLF