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

SQL

Human Resources /

Employee Roles

API AHE6

AHE6 - 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
   AHE6.empID AS 'Employee No.', 
   AHE6.line AS 'Employee Role Row', 
   AHE6.roleID AS 'Role ID', 
   AHE6.LogInstanc AS 'Log Instance'
FROM AHE6 AS AHE6

Related information

OHEM SQL Table

OHTY SQL Table

biuan SAP® BUSINESS ONE

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