Please enable JavaScript to view this site.

ROBAWS Data Model

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

Offers: False

Contents Previous Home Next More

Name: Offers

search

Catalog: Robaws

Schema: Offers

Label: Offers

Partition-specific: false

Select: true

Insert: true

Update: true

Delete: true

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

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

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

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

Field Selection Method (OData-specific): NotRequired

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

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

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

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

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

Parameters

Name

Data Type

Required

Default Value

Documentation

assigneeId

int64

 

assigneeId

clientId

int64

 

clientId

clientReference

string

 

clientReference

fromDate

datetime

 

fromDate

offset

int64

 

 

paged

boolean

 

 

pageNumber

int32

 

 

searchText

string

 

searchText

size

int32

 

Number of records per page.

sort.sorted

boolean

 

 

sort.unsorted

boolean

 

 

status

string

 

status

toDate

datetime

 

toDate

unpaged

boolean

 

 

updatedFrom

datetime

 

updatedFrom

 

Table Columns

Name

Data Type

Label

Required

Documentation

activeOnProject

boolean

 

 

addressString

string

Address

 

assigneeName

string

Assignee Name

 

body

string

Body

 

btw

double

VAT

 

calculation

boolean

Calculation

 

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

 

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

 

 

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