API Data Provider - Online Help
KingOfTime Profile
Connecting to KingOfTime
Using the Profile
ADO.NET
JDBC
ODBC
PowerBI
SSIS
Excel
SQL Compliance
SELECT Statements
SQL Functions
String Functions
Date Functions
Math Functions
EXECUTE Statements
Schema Discovery
ADO.NET
JDBC
System Tables
sys_tables
sys_tablecolumns
sys_procedures
Tables
Administrators
Companies
DailySchedules
DailySchedulesCosts
DailyWorkings
DailyWorkingsCosts
DailyWorkingsTimeRecords
Divisions
Employees
MonthlySchedulesCosts
MonthlyWorkings
MonthlyWorkingsCosts
MonthlyWorkingsHolidayRemained
RequestsOvertimeLimits
RequestsOvertimes
RequestsSchedules
RequestsTimerecords
WorkingTypes
YearlyWorkingsHolidays
Divisions
Generated schema file.
Columns
Name
Type
References
Code [KEY]
String
Name
String
DayBorderTime
String