biuan SAP® BUSINESS ONE SDK
SQL Human Resources / Employee Types / Employee Types
DTW Employee Types
API Employee Roles Setup Service / Employee Role Setup
OHTY - Employee Types Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
typeID KEY UNIQUEEmployee Type IDInt
11
PRIMARYYes
name KEYNamenVarChar
20
NAME_KEYNo
descriptioDescriptionText
16
lockedLockedVarChar
Y) Yes
N) No
1
N

SELECT statement

SELECT OHTY.typeID AS 'Employee Type ID', OHTY.name AS 'Name', OHTY.descriptio AS 'Description', OHTY.locked AS 'Locked' FROM OHTY AS OHTY

Related information


Employee Role Setup EmployeeRoleSetup Object· Table: OHTY
Represents an employee role. Source table: OHTY Mandatory properties: Name and Description cannot both be blank.
   Parent: Employee Roles Setup Service EmployeeRolesSetupService Service· Table: OHTY

Employee Roles Setup Service EmployeeRolesSetupService Service· Table: OHTY
The EmployeeRolesSetupService service enables you to add, look up and remove roles in the employee roles master data table. To see the list of employee roles and create a new one, select Human Resources -- Employee Master Data, and select...

OHTY 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