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

SQL Human Resources / Employee Reviews

API AHE3

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 Review Row	Int	6
date	Employee Review Date	Date	8
reviewDesc	Review Description	nVarChar	100
manager	Manager	Int	11	OHEM Employees
grade	Grade	nVarChar	50
remarks	Reviews	Text	16
LogInstanc	Log Instance	Int	11		0

SELECT statement

SELECT
   AHE3.empID AS 'Employee No.', 
   AHE3.line AS 'Employee Review Row', 
   AHE3.date AS 'Employee Review Date', 
   AHE3.reviewDesc AS 'Review Description', 
   AHE3.manager AS 'Manager', 
   AHE3.grade AS 'Grade', 
   AHE3.remarks AS 'Reviews', 
   AHE3.LogInstanc AS 'Log Instance'
FROM AHE3 AS AHE3

Related information

OHEM 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. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates