project QadFinancials > class BUserRole > business logic query UsrRoleCompanyForMail
Parameters
| iiCompanyId | integer | Company id |
| iiRoleId | integer | |
query condition
each UsrRoleCompany where
UsrRoleCompany.Company_Id = iiCompanyId AND
UsrRoleCompany.Role_ID = iiRoleId
first Usr (inner-join) where
Usr.Usr_ID = UsrRoleCompany.Usr_ID AND
query resultset tqUsrRoleCompanyForMail
| field name | data type | db field | description |
|---|
| tiCompany_ID | integer | UsrRoleCompany.Company_ID | Entity |
| tiRole_ID | integer | UsrRoleCompany.Role_ID | Role |
| tcUsrInitials | character | Usr.UsrInitials | UsrInitials |
| tlUsrIsActive | logical | Usr.UsrIsActive | Active |
| tcUsrLogin | character | Usr.UsrLogin | Login |
| tcUsrMailAddress | character | Usr.UsrMailAddress | E-mail Address |
Internal usage
QadFinancials