biuan SAP® BUSINESS ONE SDK
API Employee Transfer Details / Employee Transfer Detail
HET1 - Employee Transfer Details Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
TransferID KEY UNIQUEForeign Key to OHETInt
11OHET
Object: HR Employee Transfer
PRIMARYYes
empIDForeign Key to OHEMInt
11OHEM
Employees
TransferedTimestamp: Status "Sent"Date
8
StatusProcessing StatusVarChar
N) New
S) Sent
A) Accepted
E) Error
1
N
CommentAny commentsText
16
TransTimeTime When Status Is "Sent"Int
6

Table relationship map

SELECT statement

SELECT HET1.TransferID AS 'Foreign Key to OHET', HET1.empID AS 'Foreign Key to OHEM', HET1.Transfered AS 'Timestamp: Status "Sent"', HET1.Status AS 'Processing Status', HET1.Comment AS 'Any comments', HET1.TransTime AS 'Time When Status Is "Sent"' FROM HET1 AS HET1

Related information


Employee Transfer Detail EmployeeTransferDetail Object· Table: HET1
EmployeeTransferDetail is a child object of the EmployeeTransfer object. Represents the sub-record of an employee transfer to the payroll provider. Source table: HET1.
   Parent: Employee Transfer Details EmployeeTransferDetails Collection
Employees OHEM SQL Table

Object: HR Employee Transfer 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