project BLF > class BUser > business logic query UserPrim

Description

Query that can be used to convert the ID into the Code and vice-versa (Code is also a related-key-business-field in this query).


Parameters


iiUsrIdintegerUser ID
icUsrLogincharacterUser name


query condition


  each Usr where
Usr.Usr_ID = iiUsrId AND
Usr.UsrLogin = icUsrLogin


query resultset tqUserPrim


field namedata typedb fielddescription
tcUsrLogincharacterUsr.UsrLoginLogin
tiUsr_IDintegerUsr.Usr_IDRecord ID


Internal usage


BLF
method business.ApiActivitiesAreAllowed
method business.apiActivityIsAllowed
method BControlProperty.ApiGetCustomizedForms
method BControlProperty.DataLoadByInput
method BControlProperty.DeleteControlProperty
method BReportVariant.ApiGetVariantInformation
method BSetting.CreateSystemSettingsUpdate
method BSODPolicyException.PostTransaction
method BStoredSearch.GetStoredSearchView
method BUser.ApiGetRoleScopeValues
method BUser.ApiGetUserDomainEntityAccess
method BUser.ApiSynchronise
method BUser.LinkCompanyToDaemonUsers
method BUserRole.ApiSynchronise
method BUserRole.DataLoadByInput
method BWorkObject.CreateDraftWorkObject
method BWorkObject.UpdateWorkobjectStatus
method TApplication.ActivateSOD
method TApplication.DeactivateSOD
method TApplication.Synchronize
validate related business field(s) on tCorrLog.Usr_ID
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
read related business field(s) on tWorkObject.CreatorUsr_ID
read related business field(s) on tWorkObject.Usr_ID
read related business field(s) on tUsrRole.Usr_ID
read related business field(s) on tSyst.Usr_ID
read related business field(s) on tSODException.Usr_ID
method TSODImport.ImportSODData
read related business field(s) on tCorrLog.Usr_ID
read related business field(s) on tRptRequest.Usr_ID
read related business field(s) on tRptRequestVariant.Usr_ID
validate related business field(s) on tWorkObject.CreatorUsr_ID
validate related business field(s) on tSyst.Usr_ID
validate related business field(s) on tSODException.Usr_ID
validate related business field(s) on tRptRequestVariant.Usr_ID
validate related business field(s) on tRptRequest.Usr_ID
validate related business field(s) on tUsrRole.Usr_ID
validate related business field(s) on tWorkObject.Usr_ID

QadFinancials
read related business field(s) on tBudget.Usr_ID
method BProject.ApiLoadProjectCalcUsrLogin
method BProject.Calculate
method BResource.ApiMfgproFunctionIsAllowed
method BSystem.ApiSetSystemPropertiesExtInvCert
method TJournalRole.CheckJournalRole
read related business field(s) on tCashReport.Usr_ID
read related business field(s) on tCostCentre.Usr_ID
read related business field(s) on tFRWTreeView.Usr_ID
read related business field(s) on tEmployee.Usr_ID
read related business field(s) on tDDocument.CreationUsr_ID
read related business field(s) on tDCollectionExport.Usr_ID
method BGL.Calculate
method BGL.ApiLoadGLCalcUsrLogin
method BGL.ApiLoadGL
method BEmployee.ApiLoadEmployeeCalcUsrLogin
method BEmployee.ApiLoadEmployee
method BEmployee.APIGetDefaultEmployee
method BCostCentre.Calculate
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
method BCostCentre.ApiLoadCostCentreCalcUsrLogin
method BProject.ApiLoadProject
read related business field(s) on tProject.ControllerUsr_ID
read related business field(s) on tProject.ProjectManagerUsr_ID
read related business field(s) on tProject.AdminRespUsr_ID
read related business field(s) on tProject.SalesRespUsr_ID
read related business field(s) on tPosting.CreatorUsr_ID
read related business field(s) on tPaySelHistory.Usr_ID
validate related business field(s) on tBudget.Usr_ID
validate related business field(s) on tCashReport.Usr_ID
validate related business field(s) on tCostCentre.Usr_ID
validate related business field(s) on tDCollectionExport.Usr_ID
validate related business field(s) on tDDocument.CreationUsr_ID
validate related business field(s) on tEmployee.Usr_ID
validate related business field(s) on tFRWTreeView.Usr_ID
validate related business field(s) on tPaySelHistory.Usr_ID
validate related business field(s) on tPosting.CreatorUsr_ID
validate related business field(s) on tProject.SalesRespUsr_ID
validate related business field(s) on tProject.AdminRespUsr_ID
validate related business field(s) on tProject.ProjectManagerUsr_ID
validate related business field(s) on tProject.ControllerUsr_ID