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