SSIS Components for Exact Online

Build 24.0.9060

LeaveAbsenceHoursByDay

Use this endpoint to read employee's leave and absence hours by day.

Columns

Name Type Description
ID [KEY] String Id for LeaveAbsenceHoursByDay
Created Datetime Creation date
Date Datetime Date of leave or absence
Division Int Division code
Employee String ID of employee linked to the leave or absence
EmployeeFullName String Employee full name
EmployeeHID Int Numeric ID of the employee
Employment String Employment ID
EmploymentHID Int Numeric ID of the employment
EndTime Datetime End time of leave or absence
ExternalIDInt Long Unique ID from external source.
Hours Double Hours of leave or absence
Modified Datetime Last modified date
StartTime Datetime Start time of leave or absence
Status Int Status, 1 = Submitted, 2 = Approved
Type Int Type, 0 = Leave, 1 = Absence

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060