biuan SAP® BUSINESS ONE SDK
SQL Human Resources / Employees / Employee Status
DTW Human Resources / Employee Master Data / Employee Status
API Employees Info / Status Code
OHST - Employee Status Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
statusID KEY UNIQUEStatus IDInt
11
PRIMARYYes
name KEY UNIQUENamenVarChar
20
NAME_KEYYes
descriptioDescriptionText
16

SELECT statement

SELECT OHST.statusID AS 'Status ID', OHST.name AS 'Name', OHST.descriptio AS 'Description' FROM OHST AS OHST

Related information


Status Code StatusCode Property· Table: OHST
Sets or returns the employee status code. Field name: status.
· Table: OHEM    Parent: Employees Info EmployeesInfo Object· Table: OHEM
OHST 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