ROBAWS Data Model

id

int64

☑

id

addressString

string

Address

☐

checkInAtWork

string

☐

client_accountNr

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_followUpDate

datetime

☐

client_gsm

string

☐

client_id

int64

☐

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

boolean

☐

werfleider_avatar_documentDate

datetime

☐

werfleider_avatar_expirationDate

datetime

☐

werfleider_avatar_filename

string

☐

werfleider_avatar_fileSize

int64

☐

werfleider_avatar_id

int64

☐

werfleider_avatar_mimeType

string

☐

werfleider_avatar_objectRef_objectId

int64

☐

werfleider_avatar_objectRef_objectType

string

☐

werfleider_avatar_parentId

int64

☐

werfleider_avatar_path

string

☐

werfleider_avatar_uuid

string

☐

werfleider_avatar_version

int64

☐

werfleider_avatar_wappy

boolean

☐

werfleider_email

string

☐

werfleider_emailAccount_emailAccountType

string

☐

werfleider_emailAccount_emailBcc

string

☐

werfleider_emailAccount_emailFrom

string

☐

werfleider_emailAccount_emailFromName

string

☐

werfleider_emailAccount_emailHost

string

☐

werfleider_emailAccount_emailPass

string

☐

werfleider_emailAccount_emailPort

string

☐

werfleider_emailAccount_emailUser

string

☐

werfleider_emailAccount_starttls

boolean

☐

werfleider_emailAccount_uuid

string

☐

werfleider_employee_address_city

string

☐

werfleider_employee_address_country

string

☐

werfleider_employee_address_latLng_lat

double

☐

werfleider_employee_address_latLng_lng

double

☐

werfleider_employee_address_street

string

☐

werfleider_employee_address_streetExtra

string

☐

werfleider_employee_address_zipcode

string

☐

werfleider_employee_bankaccountNr

string

☐

werfleider_employee_birthDate

datetime

☐

werfleider_employee_civilStatus

string

☐

werfleider_employee_competenceLevel

string

☐

werfleider_employee_costPerHour

double

☐

werfleider_employee_defaultMobility_id

int64

☐

werfleider_employee_defaultMobility_name

string

☐

werfleider_employee_defaultMobility_version

int64

☐

werfleider_employee_defaultOperation_accountancyCode_code

string

☐

werfleider_employee_defaultOperation_accountancyCode_externalId

string

☐

werfleider_employee_defaultOperation_accountancyCode_id

int64

☐

werfleider_employee_defaultOperation_accountancyCode_name

string

☐

werfleider_employee_defaultOperation_accountancyCode_version

int64

☐

werfleider_employee_defaultOperation_accountancyCodePurchase_code

string

☐

werfleider_employee_defaultOperation_accountancyCodePurchase_externalId

string

☐

werfleider_employee_defaultOperation_accountancyCodePurchase_id

int64

☐

werfleider_employee_defaultOperation_accountancyCodePurchase_name

string

☐

werfleider_employee_defaultOperation_accountancyCodePurchase_version

int64

☐

werfleider_employee_defaultOperation_activity

string

☐

werfleider_employee_defaultOperation_agreementType

string

☐

werfleider_employee_defaultOperation_articleGroup_contextPath

string

☐

werfleider_employee_defaultOperation_articleGroup_id

int64

☐

werfleider_employee_defaultOperation_articleGroup_name

string

☐

werfleider_employee_defaultOperation_articleGroup_photo_directory

boolean

☐

werfleider_employee_defaultOperation_articleGroup_photo_documentDate

datetime

☐

werfleider_employee_defaultOperation_articleGroup_photo_expirationDate

datetime

☐

werfleider_employee_defaultOperation_articleGroup_photo_filename

string

☐

werfleider_employee_defaultOperation_articleGroup_photo_fileSize

int64

☐

werfleider_employee_defaultOperation_articleGroup_photo_id

int64

☐

werfleider_employee_defaultOperation_articleGroup_photo_mimeType

string

☐

werfleider_employee_defaultOperation_articleGroup_photo_parentId

int64

☐

werfleider_employee_defaultOperation_articleGroup_photo_path

string

☐

werfleider_employee_defaultOperation_articleGroup_photo_uuid

string

☐

werfleider_employee_defaultOperation_articleGroup_photo_version

int64

☐

werfleider_employee_defaultOperation_articleGroup_photo_wappy

boolean

☐

werfleider_employee_defaultOperation_articleGroup_version

int64

☐

werfleider_employee_defaultOperation_articleNumber

string

☐

werfleider_employee_defaultOperation_articleType

string

☐

werfleider_employee_defaultOperation_barcode

string

☐

werfleider_employee_defaultOperation_brand

string

☐

werfleider_employee_defaultOperation_calc

boolean

☐

werfleider_employee_defaultOperation_calcDescription

string

☐

werfleider_employee_defaultOperation_calculationType

string

☐

werfleider_employee_defaultOperation_chapter

string

☐

werfleider_employee_defaultOperation_compositeArticle

boolean

☐

werfleider_employee_defaultOperation_costPrice

double

☐

werfleider_employee_defaultOperation_currencySymbol

string

☐

werfleider_employee_defaultOperation_description

string

☐

werfleider_employee_defaultOperation_deviantSalesName

string

☐

werfleider_employee_defaultOperation_headerLevel

string

☐

werfleider_employee_defaultOperation_id

int64

☐

werfleider_employee_defaultOperation_indirectCostFactor

double

☐

werfleider_employee_defaultOperation_internalPhoto

boolean

☐

werfleider_employee_defaultOperation_lineType

string

☐

werfleider_employee_defaultOperation_margin

double

☐

werfleider_employee_defaultOperation_materialInstallation

boolean

☐

werfleider_employee_defaultOperation_minimumSaleAmount

double

☐

werfleider_employee_defaultOperation_minimumStockAmount

double

☐

werfleider_employee_defaultOperation_name

string

☐

werfleider_employee_defaultOperation_newPage

boolean

☐

werfleider_employee_defaultOperation_photo_directory

boolean

☐

werfleider_employee_defaultOperation_photo_documentDate

datetime

☐

werfleider_employee_defaultOperation_photo_expirationDate

datetime

☐

werfleider_employee_defaultOperation_photo_filename

string

☐

werfleider_employee_defaultOperation_photo_fileSize

int64

☐

werfleider_employee_defaultOperation_photo_id

int64

☐

werfleider_employee_defaultOperation_photo_mimeType

string

☐

werfleider_employee_defaultOperation_photo_objectRef_objectId

int64

☐

werfleider_employee_defaultOperation_photo_objectRef_objectType

string

☐

werfleider_employee_defaultOperation_photo_parentId

int64

☐

werfleider_employee_defaultOperation_photo_path

string

☐

werfleider_employee_defaultOperation_photo_uuid

string

☐

werfleider_employee_defaultOperation_photo_version

int64

☐

werfleider_employee_defaultOperation_photo_wappy

boolean

☐

werfleider_employee_defaultOperation_saleName

string

☐

werfleider_employee_defaultOperation_salePrice

double

☐

werfleider_employee_defaultOperation_stockAmount

double

☐

werfleider_employee_defaultOperation_stockChanges

string

☐

werfleider_employee_defaultOperation_stockLocation

string

☐

werfleider_employee_defaultOperation_supplierNames

string

☐

werfleider_employee_defaultOperation_timeOperation

boolean

☐

werfleider_employee_defaultOperation_unitType

string

☐

werfleider_employee_defaultOperation_useMargin

boolean

☐

werfleider_employee_defaultOperation_vatTarif

string

☐

werfleider_employee_defaultOperation_version

int64

☐

werfleider_employee_dependentChildren

int32

☐

werfleider_employee_detachment

boolean

☐

werfleider_employee_dimona

string

☐

werfleider_employee_dimonaExpireDate

datetime

☐

werfleider_employee_distance

double

☐

werfleider_employee_documentRsz

int64

☐

werfleider_employee_documentRszPayment

int64

☐

werfleider_employee_documentRszValidTill

datetime

☐

werfleider_employee_driverLicense

string

☐

werfleider_employee_email

string

☐

werfleider_employee_emergencyTel

string

☐

werfleider_employee_employeeGone

datetime

☐

werfleider_employee_employeeRole_id

int64

☐

werfleider_employee_employeeRole_name

string

☐

werfleider_employee_employeeRole_version

int64

☐

werfleider_employee_employeeSince

datetime

☐

werfleider_employee_employeeStatute

string

☐

werfleider_employee_expireDateRszPayment

datetime

☐

werfleider_employee_fullname

string

☐

werfleider_employee_function

string

☐

werfleider_employee_gender

string

☐

werfleider_employee_grossSalary

double

☐

werfleider_employee_gsm

string

☐

werfleider_employee_gsmOrTel

string

☐

werfleider_employee_id

int64

☐

werfleider_employee_independentCertificate

boolean

☐

werfleider_employee_independentConnection

boolean

☐

werfleider_employee_insz

string

☐

werfleider_employee_limosaExpireDate

datetime

☐

werfleider_employee_limosaNr

string

☐

werfleider_employee_name

string

☐

werfleider_employee_nameAndState

string

☐

werfleider_employee_nationality

string

☐

werfleider_employee_passportExpireDate

datetime

☐

werfleider_employee_passportNr

string

☐

werfleider_employee_paymentRsz

boolean

☐

werfleider_employee_planningGroup

string

☐

werfleider_employee_startDate

datetime

☐

werfleider_employee_status

string

☐

werfleider_employee_subType

string

☐

werfleider_employee_supplier_accountancyCodePurchase_code

string

☐

werfleider_employee_supplier_accountancyCodePurchase_externalId

string

☐

werfleider_employee_supplier_accountancyCodePurchase_id

int64

☐

werfleider_employee_supplier_accountancyCodePurchase_name

string

☐

werfleider_employee_supplier_accountancyCodePurchase_version

int64

☐

werfleider_employee_supplier_accountNr

string

☐

werfleider_employee_supplier_addressString

string

☐

werfleider_employee_supplier_bank

string

☐

werfleider_employee_supplier_btwNumber

string

☐

werfleider_employee_supplier_currencySymbol

string

☐

werfleider_employee_supplier_email

string

☐

werfleider_employee_supplier_externalId

string

☐

werfleider_employee_supplier_fax

string

☐

werfleider_employee_supplier_gsm

string

☐

werfleider_employee_supplier_id

int64

☐

werfleider_employee_supplier_invoiceAddress_city

string

☐

werfleider_employee_supplier_invoiceAddress_country

string

☐

werfleider_employee_supplier_invoiceAddress_latLng_lat

double

☐

werfleider_employee_supplier_invoiceAddress_latLng_lng

double

☐

werfleider_employee_supplier_invoiceAddress_street

string

☐

werfleider_employee_supplier_invoiceAddress_streetExtra

string

☐

werfleider_employee_supplier_invoiceAddress_zipcode

string

☐

werfleider_employee_supplier_invoiceRemarks

string

☐

werfleider_employee_supplier_language

string

☐

werfleider_employee_supplier_legalForm_hasVat

boolean

☐

werfleider_employee_supplier_legalForm_id

int64

☐

werfleider_employee_supplier_legalForm_name

string

☐

werfleider_employee_supplier_legalForm_pdfName

string

☐

werfleider_employee_supplier_legalForm_version

int64

☐

werfleider_employee_supplier_legalName

string

☐

werfleider_employee_supplier_logicId

string

☐

werfleider_employee_supplier_name

string

☐

werfleider_employee_supplier_status

string

☐

werfleider_employee_supplier_supplyOrderRemarks

string

☐

werfleider_employee_supplier_tel

string

☐

werfleider_employee_supplier_vat_ublSchemeId

string

☐

werfleider_employee_supplier_vat_vatCode

string

☐

werfleider_employee_supplier_vat_vatCountry

string

☐

werfleider_employee_supplier_vat_vatValid

boolean

☐

werfleider_employee_supplier_vatNr

string

☐

werfleider_employee_supplier_vatTarif

string

☐

werfleider_employee_supplier_version

int64

☐

werfleider_employee_supplier_website

string

☐

werfleider_employee_supplierName

string

☐

werfleider_employee_surname

string

☐

werfleider_employee_tel

string

☐

werfleider_employee_type

string

☐

werfleider_employee_version

int64

☐

werfleider_employeeId

int64

☐

werfleider_fullname

string

☐

werfleider_id

int64

☐

werfleider_schema

string

☐

werfleider_signature

string

☐

werfleider_useEmailAccount

boolean

☐

werfleider_username

string

☐

werfleider_userRole_id

int64

☐

werfleider_userRole_name

string

☐

werfleider_userRole_version

int64

☐

werfleider_userRoleString

string

☐

werfleider_version

int64

☐

workOrderInfo

string

Work Order Information

☐

yearNumber

int32

Year

☐