HEM6 - biuan.com SDK Developer - SAP® Business ONE (SBO)

SQL

Human Resources /

Employees / Employee Roles

DTW Human Resources / Employee Master Data / Employee Roles

API Employees Info / Employee Roles Info

HEM6 - Employee Roles Table

SBO SQL database table details

Field	Description	Type	Size	Related	Default	Primary_Key	Unique
empID ^KEY ^UNIQUE	Employee No.	Int	11	OHEM Employees		PRIMARY	Yes
line	Employee Role Row	Int	6
roleID	Role ID	Int	11	OHTY Employee Types
LogInstanc	Log Instance	Int	11		0

Table relationship map

SELECT statement

SELECT
   HEM6.empID AS 'Employee No.', 
   HEM6.line AS 'Employee Role Row', 
   HEM6.roleID AS 'Role ID', 
   HEM6.LogInstanc AS 'Log Instance'
FROM HEM6 AS HEM6

Related information

EmployeeRolesInfo Object· Table: HEM6

A child object of the EmployeesInfo object that represents the employee roles, for example, technician, sales employee and purchasing. Source table: HEM6.

Parent: Employees Info EmployeesInfo Object· Table: OHEM
OHEM SQL Table

OHTY SQL Table

biuan SAP® BUSINESS ONE

Object
EmployeesInfo

Object
EmployeeRolesInfo

Method

Add

SetCurrentLine

Property

Count

EmployeeID

DTW DB

LineNum

DTW DB

RoleID

DTW DB

UserFields

SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates