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

SQL

Human Resources /

Absence Information

API AHE1

AHE1 - Absence Information Table

SBO SQL database table details

Field	Description	Type	Size	Related	Default	Primary_Key	Unique
empID ^KEY ^UNIQUE	Employee ID	Int	11	OHEM Employees		PRIMARY	Yes
line	Absence Information Row	Int	6
fromDate	Absence from	Date	8
toDate	Absence to	Date	8
reason	Reason	nVarChar	20
approvedBy	Approved By	nVarChar	20
cnfrmrNum	Confirmer Number	Int	11	OHEM Employees
LogInstanc	Log Instance	Int	11		0

SELECT statement

SELECT
   AHE1.empID AS 'Employee ID', 
   AHE1.line AS 'Absence Information Row', 
   AHE1.fromDate AS 'Absence from', 
   AHE1.toDate AS 'Absence to', 
   AHE1.reason AS 'Reason', 
   AHE1.approvedBy AS 'Approved By', 
   AHE1.cnfrmrNum AS 'Confirmer Number', 
   AHE1.LogInstanc AS 'Log Instance'
FROM AHE1 AS AHE1

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