biuan SAP® BUSINESS ONE SDK
DTW Object: HR Employee Transfer
API Employee Transfers Service / Employee Transfer
OHET - Object: HR Employee Transfer Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
TransferID KEY UNIQUEUnique ID for TransferInt
11
PRIMARYYes
TransStartTransfer Start DateDate
8
TransEndTimestamp if Status is "Sent"Date
8
StatusProcessing StatusVarChar
N) New
P) Processing
S) Sent
R) Received
A) Accepted
E) Error
1
N
CommentAny commentsText
16
StartTimeTransfer Start TimeInt
6
EndTimeTime When Status Is "Sent"Int
6

SELECT statement

SELECT OHET.TransferID AS 'Unique ID for Transfer', OHET.TransStart AS 'Transfer Start Date', OHET.TransEnd AS 'Timestamp if Status is "Sent"', OHET.Status AS 'Processing Status', OHET.Comment AS 'Any comments', OHET.StartTime AS 'Transfer Start Time', OHET.EndTime AS 'Time When Status Is "Sent"' FROM OHET AS OHET

Related information


Employee Transfer EmployeeTransfer Object· Table: OHET
Represents the employee transfer record to the payroll provider. Source table: OHET.
   Parent: Employee Transfers Service EmployeeTransfersService Service· Table: OHET

Employee Transfer Params EmployeeTransferParams Object· Table: OHET
Holds the key of an employee transfer.  This object is used to pass keys to and retrieve keys from EmployeeTransfersService methods. Source table: OHET.
   Parent: Employee Transfers Params EmployeeTransfersParams Collection

Employee Transfers Service EmployeeTransfersService Service· Table: OHET
EmployeeTransfersService is a business object that manages employee master data transfers from SAP Business One to the DATEV HR client application.  Source table: OHET.

OHET 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