ROBAWS Data Model

assigneeId

int64

☐

assigneeId

clientId

int64

☐

clientId

clientReference

string

☐

clientReference

fromDate

datetime

☐

fromDate

offset

int64

☐

paged

boolean

☐

pageNumber

int32

☐

searchText

string

☐

searchText

sentToAccountant

boolean

☐

sentToAccountant

size

int32

☐

Number of records per page.

sort.sorted

boolean

☐

sort.unsorted

boolean

☐

status

string

☐

status

toDate

datetime

☐

toDate

unpaged

boolean

☐

updatedFrom

datetime

☐

updatedFrom

activity

string

Activity

☐

agreementType

string

Agreement Type

☐

amount

double

Amount

☐

amountCalculation

string

☐

amountReceived

double

Amount Received

☐

barcode

string

Bar Code

☐

calculatedTotalCost

double

Calculated Total Cost

☐

calculationType

string

Calculation Type

☐

calculationTypeString

string

Calculation Type

☐

chapter

string

Chapter

☐

compositeLineItem

boolean

Composite Line Item

☐

costPrice

double

Cost Price

☐

customPrice

boolean

Custom Price

☐

description

string

Description

☐

descriptionCalculation

string

☐

descriptionExtended

string

☐

descriptionExtendedWithReplacedFormulas

string

☐

discount

double

Discount

☐

headerLevel

string

Header Level

☐

id

int64

ID

☐

indirectCostFactor

double

Indirect Cost Factor

☐

lineNumber

string

Line Number

☐

lineType

string

Line Type

☐

location

string

Location

☐

margin

double

☐

newPage

boolean

New Page

☐

percentageDone

int32

Done (%)

☐

percentagePrevious

int32

Previous (%)

☐

price

double

Price

☐

priceAdjustment

double

Price Adjustment

☐

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_emailAccount_emailAccountType

string

☐

project_client_assignee_emailAccount_emailBcc

string

☐

project_client_assignee_emailAccount_emailFrom

string

☐

project_client_assignee_emailAccount_emailFromName

string

☐

project_client_assignee_emailAccount_emailHost

string

☐

project_client_assignee_emailAccount_emailPass

string

☐

project_client_assignee_emailAccount_emailPort

string

☐

project_client_assignee_emailAccount_emailUser

string

☐

project_client_assignee_emailAccount_starttls

boolean

☐

project_client_assignee_emailAccount_uuid

string

☐

project_client_assignee_employee_bankaccountNr

string

☐

project_client_assignee_employee_birthDate

datetime

☐

project_client_assignee_employee_civilStatus

string

☐

project_client_assignee_employee_competenceLevel

string

☐

project_client_assignee_employee_costPerHour

double

☐

project_client_assignee_employee_dependentChildren

int32

☐

project_client_assignee_employee_detachment

boolean

☐

project_client_assignee_employee_dimona

string

☐

project_client_assignee_employee_dimonaExpireDate

datetime

☐

project_client_assignee_employee_distance

double

☐

project_client_assignee_employee_documentRsz

int64

☐

project_client_assignee_employee_documentRszPayment

int64

☐

project_client_assignee_employee_documentRszValidTill

datetime

☐

project_client_assignee_employee_driverLicense

string

☐

project_client_assignee_employee_email

string

☐

project_client_assignee_employee_emergencyTel

string

☐

project_client_assignee_employee_employeeGone

datetime

☐

project_client_assignee_employee_employeeSince

datetime

☐

project_client_assignee_employee_employeeStatute

string

☐

project_client_assignee_employee_expireDateRszPayment

datetime

☐

project_client_assignee_employee_fullname

string

☐

project_client_assignee_employee_function

string

☐

project_client_assignee_employee_gender

string

☐

project_client_assignee_employee_grossSalary

double

☐

project_client_assignee_employee_gsm

string

☐

project_client_assignee_employee_gsmOrTel

string

☐

project_client_assignee_employee_id

int64

☐

project_client_assignee_employee_independentCertificate

boolean

☐

project_client_assignee_employee_independentConnection

boolean

☐

project_client_assignee_employee_insz

string

☐

project_client_assignee_employee_limosaExpireDate

datetime

☐

project_client_assignee_employee_limosaNr

string

☐

project_client_assignee_employee_name

string

☐

project_client_assignee_employee_nameAndState

string

☐

project_client_assignee_employee_nationality

string

☐

project_client_assignee_employee_passportExpireDate

datetime

☐

project_client_assignee_employee_passportNr

string

☐

project_client_assignee_employee_paymentRsz

boolean

☐

project_client_assignee_employee_planningGroup

string

☐

project_client_assignee_employee_startDate

datetime

☐

project_client_assignee_employee_status

string

☐

project_client_assignee_employee_subType

string

☐

project_client_assignee_employee_supplierName

string

☐

project_client_assignee_employee_surname

string

☐

project_client_assignee_employee_tel

string

☐

project_client_assignee_employee_type

string

☐

project_client_assignee_employee_version

int64

☐

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_userRoleString

string

☐

project_werfleider_version

int64

☐

project_workOrderInfo

string

☐

project_yearNumber

int32

☐

purchasePrice

double

Purchase Price

☐

receivedTotalExclBtw

double

Received Total excl. VAT

☐

scanned

datetime

☐

taxPercent

double

☐

totalBtw

double

Total VAT

☐

totalExclBtw

double

Total excl. VAT

☐

totalIncBtw

double

Total incl. VAT

☐

totality

boolean

☐

unitType

string

Unit Type

☐

vatTarif

string

VAT Code

☐

version

int64

Version

☐