Please enable JavaScript to view this site.

ROBAWS Data Model

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

Projects: False

Contents Previous Home Next More

Name: Projects

search

Catalog: Robaws

Schema: Projects

Label: Projects

Partition-specific: false

Select: true

Insert: true

Update: true

Delete: true

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

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

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

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

Field Selection Method (OData-specific): NotRequired

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

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

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

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

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

Parameters

Name

Data Type

Required

Default Value

Documentation

clientId

int64

 

clientId

clientReference

string

 

clientReference

endPhaseDate

datetime

 

endPhaseDate

fromDate

datetime

 

fromDate

offset

int64

 

 

paged

boolean

 

 

pageNumber

int32

 

 

projectNr

string

 

projectNr

searchText

string

 

searchText

size

int32

 

Number of records per page.

sort.sorted

boolean

 

 

sort.unsorted

boolean

 

 

startPhaseDate

datetime

 

startPhaseDate

status

string

 

status

text

string

 

text

toDate

datetime

 

toDate

unpaged

boolean

 

 

updatedFrom

datetime

 

updatedFrom

werfleider

string

 

werfleider

 

Table Columns

Name

Data Type

Label

Required

Documentation

addressString

string

Address

 

checkInAtWork

string

 

 

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_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

 

 

clientName

string

Customer Name

 

clientReference

string

Customer Reference

 

contactPerson_email

string

 

 

contactPerson_fullName

string

 

 

contactPerson_function

string

 

 

contactPerson_gsm

string

 

 

contactPerson_gsmOrTel

string

 

 

contactPerson_id

int64

 

 

contactPerson_name

string

 

 

contactPerson_surname

string

 

 

contactPerson_tel

string

 

 

contactPerson_title

string

 

 

contactPerson_version

int64

 

 

contactPersonMail

string

Contact Person Email

 

contactPersonName

string

Contact Person Name

 

contactPersonTel

string

Contact Person Phone

 

date

datetime

Date

 

endClientName

string

 

 

id

int64

ID

 

kilometers

int32

Kilometers

 

km

double

Kilometers

 

logicId

string

 

 

planningGroup

string

Planning Group

 

planningName

string

Planning Name

 

site_city

string

 

 

site_country

string

 

 

site_latLng_lat

double

 

 

site_latLng_lng

double

 

 

site_street

string

 

 

site_streetExtra

string

 

 

site_zipcode

string

 

 

siteNotification

string

Site Notification

 

siteRsz

string

 

 

status

string

Status

 

version

int64

Version

 

werfleider_email

string

 

 

werfleider_employeeId

int64

 

 

werfleider_fullname

string

 

 

werfleider_id

int64

 

 

werfleider_schema

string

 

 

werfleider_signature

string

 

 

werfleider_useEmailAccount

boolean

 

 

werfleider_username

string

 

 

werfleider_userRoleString

string

 

 

werfleider_version

int64

 

 

workOrderInfo

string

Work Order Information

 

yearNumber

int32

Year

 

 

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