ROBAWS Data Model

id

int64

☑

id

activeOnProject

boolean

☐

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

☐

addressString

string

Address

☐

assignee_email

string

Assignee Email

☐

assignee_employeeId

int64

☐

assignee_fullname

string

Assignee Full Name

☐

assignee_id

int64

☐

assignee_schema

string

☐

assignee_signature

string

☐

assignee_useEmailAccount

boolean

☐

assignee_username

string

☐

assignee_userRole_id

int64

☐

assignee_userRole_name

string

☐

assignee_userRole_version

int64

☐

assignee_userRoleString

string

☐

assignee_version

int64

☐

assigneeName

string

Assignee Name

☐

body

string

Body

☐

btw

double

VAT

☐

calculation

boolean

Calculation

☐

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

☐

clientLegalName

string

Customer Legal Name

☐

clientName

string

Customer Name

☐

clientReference

string

Customer Reference

☐

clientSupplyOrder

string

☐

contactPersonEmail

string

☐

contactPersonGsm

string

☐

contactPersonName

string

Contact Person Name

☐

conversion

double

☐

currencySymbol

string

Currency Symbol

☐

date

datetime

Date

☐

deadlineDate

datetime

Deadline Date

☐

description

string

Description

☐

embeddedBody_text

string

☐

embeddedFooter_text

string

☐

endClientName

string

☐

estimatedTotal

double

Estimated Total

☐

expireDate

datetime

Expiry Date

☐

followUp

boolean

Follow-up

☐

followUpDate

datetime

☐

footer

string

Footer

☐

id

int64

ID

☐

inFirstClaimState

boolean

In First Claim State

☐

kilometers

int32

Kilometers

☐

logicId

string

☐

marginArticle

double

☐

marginArticleCost

double

☐

marginMaterial

double

☐

marginMaterialCost

double

☐

marginSubcontractor

double

☐

marginSubcontractorCost

double

☐

marginWork

double

☐

marginWorkCost

double

☐

orderNr

int64

Order Number

☐

priceEstimate

boolean

Price Estimate

☐

priceInWords

boolean

Price in Words

☐

receivedDate

datetime

Received Date

☐

rf

boolean

☐

sentDate

datetime

Sent Date

☐

settlement

boolean

Settlement

☐

siteVisit

boolean

Site Visit

☐

status

string

Status

☐

tender

boolean

Tender

☐

tenderDate

datetime

Tender Date

☐

totalCostPrice

double

☐

totalExcBTW

double

Total excl. VAT

☐

totalIncBTW

double

Total incl. VAT

☐

totalIndirectCosts

double

Total Indirect Costs

☐

totalMargin

double

Total Margin

☐

version

int64

Version

☐

yearNumber

int32

Year

☐