Please enable JavaScript to view this site.

ROBAWS Data Model

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

TimeTicketDistances:

Contents Previous Home Next More

Name: TimeTicketDistances

search

Catalog: Robaws

Schema: TimeTickets

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[*].distances[*]

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

costPrice

double

Cost Price

 

driver

boolean

Driver

 

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_defaultMobility_id

int64

 

 

employee_defaultMobility_name

string

 

 

employee_defaultMobility_version

int64

 

 

employee_defaultOperation_accountancyCode_code

string

 

 

employee_defaultOperation_accountancyCode_externalId

string

 

 

employee_defaultOperation_accountancyCode_id

int64

 

 

employee_defaultOperation_accountancyCode_name

string

 

 

employee_defaultOperation_accountancyCode_version

int64

 

 

employee_defaultOperation_accountancyCodePurchase_code

string

 

 

employee_defaultOperation_accountancyCodePurchase_externalId

string

 

 

employee_defaultOperation_accountancyCodePurchase_id

int64

 

 

employee_defaultOperation_accountancyCodePurchase_name

string

 

 

employee_defaultOperation_accountancyCodePurchase_version

int64

 

 

employee_defaultOperation_activity

string

 

 

employee_defaultOperation_agreementType

string

 

 

employee_defaultOperation_articleGroup_contextPath

string

 

 

employee_defaultOperation_articleGroup_id

int64

 

 

employee_defaultOperation_articleGroup_name

string

 

 

employee_defaultOperation_articleGroup_photo_directory

boolean

 

 

employee_defaultOperation_articleGroup_photo_documentDate

datetime

 

 

employee_defaultOperation_articleGroup_photo_expirationDate

datetime

 

 

employee_defaultOperation_articleGroup_photo_filename

string

 

 

employee_defaultOperation_articleGroup_photo_fileSize

int64

 

 

employee_defaultOperation_articleGroup_photo_id

int64

 

 

employee_defaultOperation_articleGroup_photo_mimeType

string

 

 

employee_defaultOperation_articleGroup_photo_parentId

int64

 

 

employee_defaultOperation_articleGroup_photo_path

string

 

 

employee_defaultOperation_articleGroup_photo_uuid

string

 

 

employee_defaultOperation_articleGroup_photo_version

int64

 

 

employee_defaultOperation_articleGroup_photo_wappy

boolean

 

 

employee_defaultOperation_articleGroup_version

int64

 

 

employee_defaultOperation_articleNumber

string

 

 

employee_defaultOperation_articleType

string

 

 

employee_defaultOperation_barcode

string

 

 

employee_defaultOperation_brand

string

 

 

employee_defaultOperation_calc

boolean

 

 

employee_defaultOperation_calcDescription

string

 

 

employee_defaultOperation_calculationType

string

 

 

employee_defaultOperation_chapter

string

 

 

employee_defaultOperation_compositeArticle

boolean

 

 

employee_defaultOperation_costPrice

double

 

 

employee_defaultOperation_currencySymbol

string

 

 

employee_defaultOperation_description

string

 

 

employee_defaultOperation_deviantSalesName

string

 

 

employee_defaultOperation_headerLevel

string

 

 

employee_defaultOperation_id

int64

 

 

employee_defaultOperation_indirectCostFactor

double

 

 

employee_defaultOperation_internalPhoto

boolean

 

 

employee_defaultOperation_lineType

string

 

 

employee_defaultOperation_margin

double

 

 

employee_defaultOperation_materialInstallation

boolean

 

 

employee_defaultOperation_minimumSaleAmount

double

 

 

employee_defaultOperation_minimumStockAmount

double

 

 

employee_defaultOperation_name

string

 

 

employee_defaultOperation_newPage

boolean

 

 

employee_defaultOperation_photo_directory

boolean

 

 

employee_defaultOperation_photo_documentDate

datetime

 

 

employee_defaultOperation_photo_expirationDate

datetime

 

 

employee_defaultOperation_photo_filename

string

 

 

employee_defaultOperation_photo_fileSize

int64

 

 

employee_defaultOperation_photo_id

int64

 

 

employee_defaultOperation_photo_mimeType

string

 

 

employee_defaultOperation_photo_objectRef_objectId

int64

 

 

employee_defaultOperation_photo_objectRef_objectType

string

 

 

employee_defaultOperation_photo_parentId

int64

 

 

employee_defaultOperation_photo_path

string

 

 

employee_defaultOperation_photo_uuid

string

 

 

employee_defaultOperation_photo_version

int64

 

 

employee_defaultOperation_photo_wappy

boolean

 

 

employee_defaultOperation_saleName

string

 

 

employee_defaultOperation_salePrice

double

 

 

employee_defaultOperation_stockAmount

double

 

 

employee_defaultOperation_stockChanges

string

 

 

employee_defaultOperation_stockLocation

string

 

 

employee_defaultOperation_supplierNames

string

 

 

employee_defaultOperation_timeOperation

boolean

 

 

employee_defaultOperation_unitType

string

 

 

employee_defaultOperation_useMargin

boolean

 

 

employee_defaultOperation_vatTarif

string

 

 

employee_defaultOperation_version

int64

 

 

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_employeeRole_id

int64

 

 

employee_employeeRole_name

string

 

 

employee_employeeRole_version

int64

 

 

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_supplier_accountancyCodePurchase_code

string

 

 

employee_supplier_accountancyCodePurchase_externalId

string

 

 

employee_supplier_accountancyCodePurchase_id

int64

 

 

employee_supplier_accountancyCodePurchase_name

string

 

 

employee_supplier_accountancyCodePurchase_version

int64

 

 

employee_supplier_accountNr

string

 

 

employee_supplier_addressString

string

 

 

employee_supplier_bank

string

 

 

employee_supplier_btwNumber

string

 

 

employee_supplier_currencySymbol

string

 

 

employee_supplier_email

string

 

 

employee_supplier_externalId

string

 

 

employee_supplier_fax

string

 

 

employee_supplier_gsm

string

 

 

employee_supplier_id

int64

 

 

employee_supplier_invoiceAddress_city

string

 

 

employee_supplier_invoiceAddress_country

string

 

 

employee_supplier_invoiceAddress_latLng_lat

double

 

 

employee_supplier_invoiceAddress_latLng_lng

double

 

 

employee_supplier_invoiceAddress_street

string

 

 

employee_supplier_invoiceAddress_streetExtra

string

 

 

employee_supplier_invoiceAddress_zipcode

string

 

 

employee_supplier_invoiceRemarks

string

 

 

employee_supplier_language

string

 

 

employee_supplier_legalForm_hasVat

boolean

 

 

employee_supplier_legalForm_id

int64

 

 

employee_supplier_legalForm_name

string

 

 

employee_supplier_legalForm_pdfName

string

 

 

employee_supplier_legalForm_version

int64

 

 

employee_supplier_legalName

string

 

 

employee_supplier_logicId

string

 

 

employee_supplier_name

string

 

 

employee_supplier_status

string

 

 

employee_supplier_supplyOrderRemarks

string

 

 

employee_supplier_tel

string

 

 

employee_supplier_vat_ublSchemeId

string

 

 

employee_supplier_vat_vatCode

string

 

 

employee_supplier_vat_vatCountry

string

 

 

employee_supplier_vat_vatValid

boolean

 

 

employee_supplier_vatNr

string

 

 

employee_supplier_vatTarif

string

 

 

employee_supplier_version

int64

 

 

employee_supplier_website

string

 

 

employee_supplierName

string

 

 

employee_surname

string

 

 

employee_tel

string

 

 

employee_type

string

 

 

employee_version

int64

 

 

employeeName

string

Employee Name

 

employeeSupplierName

string

 

 

id

int64

ID

 

kilometers

double

Kilometers

 

mobilityType_id

int64

 

 

mobilityType_name

string

 

 

mobilityType_version

int64

 

 

returnKilometers

double

 

 

totalKilometers

int32

Total Kilometers

 

version

int64

Version

 

 

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