biuan SAP® BUSINESS ONE SDK
SQL Human Resources / Employees / Termination Reason
DTW Human Resources / Employee Master Data / Termination Reason
API Employees Info / Tremination Reason
OHTR - Termination Reason Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
reasonID KEY UNIQUEReason IDInt
11
PRIMARYYes
name KEY UNIQUENamenVarChar
20
NAME_KEYYes
descriptioDescriptionText
16

SELECT statement

SELECT OHTR.reasonID AS 'Reason ID', OHTR.name AS 'Name', OHTR.descriptio AS 'Description' FROM OHTR AS OHTR

Related information


Tremination Reason TreminationReason Property· Table: OHTR
Sets or returns the termination reason. Field name: termReason. This is a foreign key to the Termination Reason table (OHTR - not exposed through the DI API).
· Table: OHEM    Parent: Employees Info EmployeesInfo Object· Table: OHEM
OHTR 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