Please enable JavaScript to view this site.

ROBAWS Data Model

Navigation: Catalog: Robaws > Schemas > Schema: TimeTickets > Tables

TimeTicketHours: False

Contents Previous Home Next More

Name: TimeTicketHours

search

Catalog: Robaws

Schema: TimeTickets

Label: Time Ticket Hours

Partition-specific: false

Select: true

Insert: false

Update: false

Delete: false

Select Service URL (OData-specific): /api/v1/time-tickets

Insert Service URL (OData-specific): /api/v1/time-tickets

Update Service URL (OData-specific): /api/v1/time-tickets

Delete Service URL (OData-specific): /api/v1/time-tickets

Field Selection Method (OData-specific): NotRequired

Base Path (OData-specific): content[*].hours[*]

Select Operation (Swagger-specific): get /api/v1/time-tickets

Parameters

Name

Data Type

Required

Default Value

Documentation

clientId

int64

 

clientId

fromDate

datetime

 

fromDate

offset

int64

 

 

paged

boolean

 

 

pageNumber

int32

 

 

searchText

string

 

searchText

size

int32

 

Number of records per page.

sort.sorted

boolean

 

 

sort.unsorted

boolean

 

 

toDate

datetime

 

toDate

unpaged

boolean

 

 

updatedFrom

datetime

 

updatedFrom

 

Table Columns

Name

Data Type

Label

Required

Documentation

activity

string

Activity

 

articleName

string

Article Name

 

costPrice

double

Cost Price

 

employee_address_city

string

 

 

employee_address_country

string

 

 

employee_address_latLng_lat

double

 

 

employee_address_latLng_lng

double

 

 

employee_address_street

string

 

 

employee_address_streetExtra

string

 

 

employee_address_zipcode

string

 

 

employee_bankaccountNr

string

 

 

employee_birthDate

datetime

 

 

employee_civilStatus

string

 

 

employee_competenceLevel

string

 

 

employee_costPerHour

double

 

 

employee_dependentChildren

int32

 

 

employee_detachment

boolean

 

 

employee_dimona

string

 

 

employee_dimonaExpireDate

datetime

 

 

employee_distance

double

 

 

employee_documentRsz

int64

 

 

employee_documentRszPayment

int64

 

 

employee_documentRszValidTill

datetime

 

 

employee_driverLicense

string

 

 

employee_email

string

 

 

employee_emergencyTel

string

 

 

employee_employeeGone

datetime

 

 

employee_employeeSince

datetime

 

 

employee_employeeStatute

string

 

 

employee_expireDateRszPayment

datetime

 

 

employee_fullname

string

 

 

employee_function

string

 

 

employee_gender

string

 

 

employee_grossSalary

double

 

 

employee_gsm

string

 

 

employee_gsmOrTel

string

 

 

employee_id

int64

 

 

employee_independentCertificate

boolean

 

 

employee_independentConnection

boolean

 

 

employee_insz

string

 

 

employee_limosaExpireDate

datetime

 

 

employee_limosaNr

string

 

 

employee_name

string

 

 

employee_nameAndState

string

 

 

employee_nationality

string

 

 

employee_passportExpireDate

datetime

 

 

employee_passportNr

string

 

 

employee_paymentRsz

boolean

 

 

employee_planningGroup

string

 

 

employee_startDate

datetime

 

 

employee_status

string

 

 

employee_subType

string

 

 

employee_supplierName

string

 

 

employee_surname

string

 

 

employee_tel

string

 

 

employee_type

string

 

 

employee_version

int64

 

 

employeeName

string

Employee Name

 

employeeSupplierName

string

 

 

endHour

datetime

 

 

endRegistered

datetime

 

 

hours

double

Hours

 

id

int64

ID

 

pause

double

Pause

 

remark

string

Remark

 

salePrice

double

Sales Price

 

startHour

datetime

Start Hour

 

startRegistered

datetime

Start Registered

 

totalCost

double

Total Cost

 

unitType

string

Unit Type

 

version

int64

Version

 

 

25-05-2020 14:5220.1.44-BETA+2813