Please enable JavaScript to view this site.

ROBAWS Data Model

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

Clients: False

 Contents Previous Home Next More

Name: Clients

search

Catalog: Robaws

Schema: Clients

Label: Customers

Partition-specific: false

Select: true

Insert: true

Update: true

Delete: true

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

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

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

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

Field Selection Method (OData-specific): NotRequired

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

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

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

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

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

Parameters

Name

Data Type

Required

Default Value

Documentation

btwNr

string

☐

 

btwNr

fromDate

datetime

☐

 

fromDate

logicId

string

☐

 

logicId

name

string

☐

 

name

notId

int64

☐

 

notId

offset

int64

☐

 

 

paged

boolean

☐

 

 

pageNumber

int32

☐

 

 

sort.sorted

boolean

☐

 

 

sort.unsorted

boolean

☐

 

 

text

string

☐

 

text

toDate

datetime

☐

 

toDate

unpaged

boolean

☐

 

 

updatedFrom

datetime

☐

 

updatedFrom

 

Table Columns

Name

Data Type

Label

Required

Documentation

accountNr

string

Account Number

☐

 

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

☐

 

bank

string

Bank

☐

 

contactMedium

string

 

☐

 

creditDate

datetime

Credit Date

☐

 

creditInfo

string

Credit Information

☐

 

creditLimit

double

Credit Limit

☐

 

creditStatus

string

Credit Status

☐

 

currencySymbol

string

Currency Symbol

☐

 

email

string

Email

☐

 

emailPermissionDate

datetime

 

☐

 

emailPermissionFrom

string

 

☐

 

expireDate_expireDatePeriodType

string

 

☐

 

expireDate_id

int64

 

☐

 

expireDate_name

string

 

☐

 

expireDate_plusDays

int32

 

☐

 

expireDate_version

int64

 

☐

 

externalId

string

External ID

☐

 

fax

string

Fax

☐

 

finalAddress_city

string

 

☐

 

finalAddress_country

string

 

☐

 

finalAddress_latLng_lat

double

 

☐

 

finalAddress_latLng_lng

double

 

☐

 

finalAddress_street

string

 

☐

 

finalAddress_streetExtra

string

 

☐

 

finalAddress_zipcode

string

 

☐

 

followUpDate

datetime

 

☐

 

gsm

string

Mobile

☐

 

id

int64

ID

☐

 

invoiceAddress_city

string

 

☐

 

invoiceAddress_country

string

 

☐

 

invoiceAddress_latLng_lat

double

 

☐

 

invoiceAddress_latLng_lng

double

 

☐

 

invoiceAddress_street

string

 

☐

 

invoiceAddress_streetExtra

string

 

☐

 

invoiceAddress_zipcode

string

 

☐

 

invoiceEmail

string

Invoice Email

☐

 

invoiceRemarks

string

Invoice Remarks

☐

 

language

string

Language

☐

 

legalForm_hasVat

boolean

 

☐

 

legalForm_id

int64

Legal Form ID

☐

 

legalForm_name

string

Legal Form Name

☐

 

legalForm_pdfName

string

 

☐

 

legalForm_version

int64

Version

☐

 

legalName

string

Legal Name

☐

 

logicId

string

 

☐

 

name

string

Name

☐

 

seperateInvoicePage

boolean

Separate Invoice Page

☐

 

status

string

Status

☐

 

tel

string

Phone

☐

 

title

string

Title

☐

 

useInvoiceAddress

boolean

Use Invoice Address

☐

 

usePeppol

boolean

Use PEPPOL

☐

 

vat_ublSchemeId

string

 

☐

 

vat_vatCode

string

 

☐

 

vat_vatCountry

string

 

☐

 

vat_vatValid

boolean

VAT Number Valid

☐

 

vatNr

string

VAT Number

☐

 

vatTarif

string

VAT Code

☐

 

version

int64

Version

☐

 

website

string

Website

☐

 

withRespectTo

string

 

☐

 

 

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