Please enable JavaScript to view this site.

ROBAWS Data Model

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

PlanningItems: False

Contents Previous Home Next More

Name: PlanningItems

search

Catalog: Robaws

Schema: PlanningItems

Label: Planning Items

Partition-specific: false

Select: true

Insert: true

Update: true

Delete: true

Select Service URL (OData-specific): /api/v1/planning-items

Insert Service URL (OData-specific): /api/v1/planning-items

Update Service URL (OData-specific): /api/v1/planning-items

Delete Service URL (OData-specific): /api/v1/planning-items

Field Selection Method (OData-specific): NotRequired

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

Select Operation (Swagger-specific): get /api/v1/planning-items

Insert Operation (Swagger-specific): post /api/v1/planning-items

Update Operation (Swagger-specific): put /api/v1/planning-items/{id}

Delete Operation (Swagger-specific): delete /api/v1/planning-items/{id}

Parameters

Name

Data Type

Required

Default Value

Documentation

employeeId

int64

 

employeeId

fromDate

datetime

 

fromDate

materialId

int64

 

materialId

offset

int64

 

 

paged

boolean

 

 

pageNumber

int32

 

 

projectId

int64

 

projectId

searchText

string

 

searchText

size

int32

 

Number of records per page.

sort.sorted

boolean

 

 

sort.unsorted

boolean

 

 

status

string

 

status

toDate

datetime

 

toDate

unpaged

boolean

 

 

updatedFrom

datetime

 

updatedFrom

 

Table Columns

Name

Data Type

Label

Required

Documentation

address_city

string

City

 

address_country

string

Country

 

address_latLng_lat

double

 

 

address_latLng_lng

double

 

 

address_street

string

Street

 

address_streetExtra

string

 

 

address_zipcode

string

ZIP Code

 

body

string

Body

 

client_accountNr

string

 

 

client_address_city

string

 

 

client_address_country

string

 

 

client_address_latLng_lat

double

 

 

client_address_latLng_lng

double

 

 

client_address_street

string

 

 

client_address_streetExtra

string

 

 

client_address_zipcode

string

 

 

client_addressString

string

 

 

client_assignee_email

string

 

 

client_assignee_employeeId

int64

 

 

client_assignee_fullname

string

 

 

client_assignee_id

int64

 

 

client_assignee_schema

string

 

 

client_assignee_signature

string

 

 

client_assignee_useEmailAccount

boolean

 

 

client_assignee_username

string

 

 

client_assignee_userRole_id

int64

 

 

client_assignee_userRole_name

string

 

 

client_assignee_userRole_version

int64

 

 

client_assignee_userRoleString

string

 

 

client_assignee_version

int64

 

 

client_assigneeName

string

 

 

client_bank

string

 

 

client_contactMedium

string

 

 

client_creditDate

datetime

 

 

client_creditInfo

string

 

 

client_creditLimit

double

 

 

client_creditStatus

string

 

 

client_currencySymbol

string

 

 

client_email

string

 

 

client_emailPermissionDate

datetime

 

 

client_emailPermissionFrom

string

 

 

client_expireDate_expireDatePeriodType

string

 

 

client_expireDate_id

int64

 

 

client_expireDate_name

string

 

 

client_expireDate_plusDays

int32

 

 

client_expireDate_version

int64

 

 

client_externalId

string

 

 

client_fax

string

 

 

client_finalAddress_city

string

 

 

client_finalAddress_country

string

 

 

client_finalAddress_latLng_lat

double

 

 

client_finalAddress_latLng_lng

double

 

 

client_finalAddress_street

string

 

 

client_finalAddress_streetExtra

string

 

 

client_finalAddress_zipcode

string

 

 

client_followUpDate

datetime

 

 

client_gsm

string

 

 

client_id

int64

 

 

client_invoiceAddress_city

string

 

 

client_invoiceAddress_country

string

 

 

client_invoiceAddress_latLng_lat

double

 

 

client_invoiceAddress_latLng_lng

double

 

 

client_invoiceAddress_street

string

 

 

client_invoiceAddress_streetExtra

string

 

 

client_invoiceAddress_zipcode

string

 

 

client_invoiceEmail

string

 

 

client_invoiceRemarks

string

 

 

client_language

string

 

 

client_legalForm_hasVat

boolean

 

 

client_legalForm_id

int64

 

 

client_legalForm_name

string

 

 

client_legalForm_pdfName

string

 

 

client_legalForm_version

int64

 

 

client_legalName

string

 

 

client_logicId

string

 

 

client_name

string

 

 

client_seperateInvoicePage

boolean

 

 

client_status

string

 

 

client_tel

string

 

 

client_title

string

 

 

client_useInvoiceAddress

boolean

 

 

client_usePeppol

boolean

 

 

client_vat_ublSchemeId

string

 

 

client_vat_vatCode

string

 

 

client_vat_vatCountry

string

 

 

client_vat_vatValid

boolean

 

 

client_vatNr

string

 

 

client_vatTarif

string

 

 

client_version

int64

 

 

client_website

string

 

 

client_withRespectTo

string

 

 

customText

string

Custom Text

 

employeeName

string

Employee Name

 

endDate

datetime

End Date

 

id

int64

ID

 

insz

string

 

 

materialNames

string

 

 

project_addressString

string

 

 

project_checkInAtWork

string

 

 

project_client_accountNr

string

 

 

project_client_address_city

string

 

 

project_client_address_country

string

 

 

project_client_address_latLng_lat

double

 

 

project_client_address_latLng_lng

double

 

 

project_client_address_street

string

 

 

project_client_address_streetExtra

string

 

 

project_client_address_zipcode

string

 

 

project_client_addressString

string

 

 

project_client_assignee_email

string

 

 

project_client_assignee_employeeId

int64

 

 

project_client_assignee_fullname

string

 

 

project_client_assignee_id

int64

 

 

project_client_assignee_schema

string

 

 

project_client_assignee_signature

string

 

 

project_client_assignee_useEmailAccount

boolean

 

 

project_client_assignee_username

string

 

 

project_client_assignee_userRole_id

int64

 

 

project_client_assignee_userRole_name

string

 

 

project_client_assignee_userRole_version

int64

 

 

project_client_assignee_userRoleString

string

 

 

project_client_assignee_version

int64

 

 

project_client_assigneeName

string

 

 

project_client_bank

string

 

 

project_client_contactMedium

string

 

 

project_client_creditDate

datetime

 

 

project_client_creditInfo

string

 

 

project_client_creditLimit

double

 

 

project_client_creditStatus

string

 

 

project_client_currencySymbol

string

 

 

project_client_email

string

 

 

project_client_emailPermissionDate

datetime

 

 

project_client_emailPermissionFrom

string

 

 

project_client_expireDate_expireDatePeriodType

string

 

 

project_client_expireDate_id

int64

 

 

project_client_expireDate_name

string

 

 

project_client_expireDate_plusDays

int32

 

 

project_client_expireDate_version

int64

 

 

project_client_externalId

string

 

 

project_client_fax

string

 

 

project_client_finalAddress_city

string

 

 

project_client_finalAddress_country

string

 

 

project_client_finalAddress_latLng_lat

double

 

 

project_client_finalAddress_latLng_lng

double

 

 

project_client_finalAddress_street

string

 

 

project_client_finalAddress_streetExtra

string

 

 

project_client_finalAddress_zipcode

string

 

 

project_client_followUpDate

datetime

 

 

project_client_gsm

string

 

 

project_client_id

int64

 

 

project_client_invoiceAddress_city

string

 

 

project_client_invoiceAddress_country

string

 

 

project_client_invoiceAddress_latLng_lat

double

 

 

project_client_invoiceAddress_latLng_lng

double

 

 

project_client_invoiceAddress_street

string

 

 

project_client_invoiceAddress_streetExtra

string

 

 

project_client_invoiceAddress_zipcode

string

 

 

project_client_invoiceEmail

string

 

 

project_client_invoiceRemarks

string

 

 

project_client_language

string

 

 

project_client_legalForm_hasVat

boolean

 

 

project_client_legalForm_id

int64

 

 

project_client_legalForm_name

string

 

 

project_client_legalForm_pdfName

string

 

 

project_client_legalForm_version

int64

 

 

project_client_legalName

string

 

 

project_client_logicId

string

 

 

project_client_name

string

 

 

project_client_seperateInvoicePage

boolean

 

 

project_client_status

string

 

 

project_client_tel

string

 

 

project_client_title

string

 

 

project_client_useInvoiceAddress

boolean

 

 

project_client_usePeppol

boolean

 

 

project_client_vat_ublSchemeId

string

 

 

project_client_vat_vatCode

string

 

 

project_client_vat_vatCountry

string

 

 

project_client_vat_vatValid

boolean

 

 

project_client_vatNr

string

 

 

project_client_vatTarif

string

 

 

project_client_version

int64

 

 

project_client_website

string

 

 

project_client_withRespectTo

string

 

 

project_clientName

string

 

 

project_clientReference

string

 

 

project_contactPerson_email

string

 

 

project_contactPerson_fullName

string

 

 

project_contactPerson_function

string

 

 

project_contactPerson_gsm

string

 

 

project_contactPerson_gsmOrTel

string

 

 

project_contactPerson_id

int64

 

 

project_contactPerson_name

string

 

 

project_contactPerson_surname

string

 

 

project_contactPerson_tel

string

 

 

project_contactPerson_title

string

 

 

project_contactPerson_version

int64

 

 

project_contactPersonMail

string

 

 

project_contactPersonName

string

 

 

project_contactPersonTel

string

 

 

project_date

datetime

 

 

project_endClientName

string

 

 

project_id

int64

 

 

project_kilometers

int32

 

 

project_km

double

 

 

project_logicId

string

 

 

project_planningGroup

string

 

 

project_planningName

string

 

 

project_site_city

string

 

 

project_site_country

string

 

 

project_site_latLng_lat

double

 

 

project_site_latLng_lng

double

 

 

project_site_street

string

 

 

project_site_streetExtra

string

 

 

project_site_zipcode

string

 

 

project_siteNotification

string

 

 

project_siteRsz

string

 

 

project_status

string

 

 

project_version

int64

 

 

project_werfleider_email

string

 

 

project_werfleider_employeeId

int64

 

 

project_werfleider_fullname

string

 

 

project_werfleider_id

int64

 

 

project_werfleider_schema

string

 

 

project_werfleider_signature

string

 

 

project_werfleider_useEmailAccount

boolean

 

 

project_werfleider_username

string

 

 

project_werfleider_userRole_id

int64

 

 

project_werfleider_userRole_name

string

 

 

project_werfleider_userRole_version

int64

 

 

project_werfleider_userRoleString

string

 

 

project_werfleider_version

int64

 

 

project_workOrderInfo

string

 

 

project_yearNumber

int32

 

 

regie

boolean

 

 

startDate

datetime

Start Date

 

status

string

Status

 

supplierName

string

Supplier Name

 

supplierVat

string

Supplier VAT

 

timeTickets

int32

Time Tickets

 

version

int64

Version

 

 

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