biuan SAP® BUSINESS ONE SDK
API AHE1
AHE1 - Absence Information Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
empID KEY UNIQUEEmployee IDInt
11OHEM
Employees
PRIMARYYes
lineAbsence Information RowInt
6
fromDateAbsence fromDate
8
toDateAbsence toDate
8
reasonReasonnVarChar
20
approvedByApproved BynVarChar
20
cnfrmrNumConfirmer NumberInt
11OHEM
Employees
LogInstancLog InstanceInt
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


Employees OHEM SQL Table



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