Skip to content
COMMERCE QUERY
/
Orders
/
/
OrderService.QuotationIte...

Storm Query API Documentation (2.0)

Storm Query API is an API based on OData V4. It is an API to fill the need for data from Storm in integration services that do not have direct access to Storm’s data and data models.

Download OpenAPI description
openapi.json
openapi.yaml
Languages
Servers
https://customer-slug.api-se.norce.tech/commerce/query/2.0/

Schemas

Schemas

OrderService.QuotationItem

Idinteger(int32)

Id. Key property.

QuotationIdinteger(int32)

QuotationId.

LineNumberinteger(int32)

LineNumber.

CustomerLineCodestring

CustomerLineCode. MaxLength: 50. Nullable.

StatusIdinteger(int32)

StatusId.

PartNostring

PartNo. MaxLength: 50. Nullable.

ProductNameWhenCreatedstring

ProductNameWhenCreated. MaxLength: 255. Nullable.

BundlePartnostring

BundlePartno. MaxLength: 50. Nullable.

BundleTypeIdinteger(int32)

BundleTypeId. Nullable.

Qtyinteger(int32)

Qty.

OnHandWhenCreatedinteger(int32)

OnHandWhenCreated. Nullable.

PriceSalenumber(decimal)

PriceSale. Nullable.

PriceSaleWhenCreatednumber(decimal)

PriceSaleWhenCreated. Nullable.

PriceListIdinteger(int32)

PriceListId.

PatternIdinteger(int32)

PatternId. Nullable.

VatCodeinteger(int32)

VatCode. Nullable.

VatValuenumber(decimal)

VatValue. Nullable.

PromotionIdSeedstring

PromotionIdSeed. MaxLength: 50. Nullable.

CampaignIdinteger(int32)

CampaignId. Nullable.

SearchStringstring

SearchString. MaxLength: 50. Nullable.

CategoryItemIdinteger(int32)

CategoryItemId. Nullable.

ParentPartnoIdstring

ParentPartnoId. MaxLength: 50. Nullable.

ParentLineNumberinteger(int32)

ParentLineNumber. Nullable.

Commentstring

Comment. MaxLength: 255. Nullable.

ExternalDatastring

ExternalData. Nullable.

RefererIdinteger(int32)

RefererId. Nullable.

RefererUrlstring

RefererUrl. MaxLength: 255. Nullable.

PriceResellernumber(decimal)

PriceReseller. Nullable.

IsLockedboolean

IsLocked. Nullable.

TotalPriceSaleExVatnumber(decimal)

TotalPriceSaleExVat. Nullable.

TotalPriceSaleIncVatnumber(decimal)

TotalPriceSaleIncVat. Nullable.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy. Nullable.

Updatedstring(date-time)

Updated. Nullable.

ExpectedDeliveryDatestring(date-time)

ExpectedDeliveryDate. Nullable.

RequirementPromotionIdSeedstring

RequirementPromotionIdSeed. MaxLength: 255. Nullable.

IsPriceManualboolean

IsPriceManual. Nullable.

Qty2number(decimal)

Qty2. Nullable.

ClientIdinteger(int32)

ClientId. Nullable.

InfosArray of objects(OrderService.QuotationItemInfo)(OrderService.QuotationItemInfo)

Infos.

{
  "Id": 0,
  "QuotationId": 0,
  "LineNumber": 0,
  "CustomerLineCode": "string",
  "StatusId": 0,
  "PartNo": "string",
  "ProductNameWhenCreated": "string",
  "BundlePartno": "string",
  "BundleTypeId": 0,
  "Qty": 0,
  "OnHandWhenCreated": 0,
  "PriceSale": 0,
  "PriceSaleWhenCreated": 0,
  "PriceListId": 0,
  "PatternId": 0,
  "VatCode": 0,
  "VatValue": 0,
  "PromotionIdSeed": "string",
  "CampaignId": 0,
  "SearchString": "string",
  "CategoryItemId": 0,
  "ParentPartnoId": "string",
  "ParentLineNumber": 0,
  "Comment": "string",
  "ExternalData": "string",
  "RefererId": 0,
  "RefererUrl": "string",
  "PriceReseller": 0,
  "IsLocked": true,
  "TotalPriceSaleExVat": 0,
  "TotalPriceSaleIncVat": 0,
  "Created": "2019-08-24T14:15:22Z",
  "CreatedBy": 0,
  "Updated": "2019-08-24T14:15:22Z",
  "ExpectedDeliveryDate": "2019-08-24T14:15:22Z",
  "RequirementPromotionIdSeed": "string",
  "IsPriceManual": true,
  "Qty2": 0,
  "ClientId": 0,
  "Infos": [
    { … }
  ]
}

OrderService.QuotationItemInfo

Idstring

Id. Key property.

QuotationItemIdinteger(int32)

QuotationItemId.

TypeIdinteger(int32)

TypeId.

Valuestring

Value. Nullable.

Updatedstring(date-time)

Updated.

UpdatedByinteger(int32)

UpdatedBy.

ClientIdinteger(int32)

ClientId. Nullable.

{
  "Id": "string",
  "QuotationItemId": 0,
  "TypeId": 0,
  "Value": "string",
  "Updated": "2019-08-24T14:15:22Z",
  "UpdatedBy": 0,
  "ClientId": 0
}

OrderService.QuotationCustomerAddress

Idinteger(int32)

Id. Key property.

QuotationIdinteger(int32)

QuotationId.

ClientCustomerAddressIdinteger(int32)

ClientCustomerAddressId. Nullable.

ClientCompanyAddressIdinteger(int32)

ClientCompanyAddressId. Nullable.

CustomerIdinteger(int32)

CustomerId. Nullable.

CompanyIdinteger(int32)

CompanyId. Nullable.

TypeIdinteger(int32)

TypeId.

CareOfstring

CareOf. MaxLength: 100. Nullable.

AddressLine1string

AddressLine1. MaxLength: 255. Nullable.

AddressLine2string

AddressLine2. MaxLength: 255. Nullable.

ZipCodestring

ZipCode. MaxLength: 50. Nullable.

Citystring

City. MaxLength: 50. Nullable.

Regionstring

Region. MaxLength: 50. Nullable.

CountryIdinteger(int32)

CountryId. Nullable.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

CompanyNamestring

CompanyName. MaxLength: 100. Nullable.

FirstNamestring

FirstName. MaxLength: 50. Nullable.

LastNamestring

LastName. MaxLength: 50. Nullable.

CellPhoneNumberstring

CellPhoneNumber. MaxLength: 50. Nullable.

Emailstring

Email. MaxLength: 255. Nullable.

ClientIdinteger(int32)

ClientId. Nullable.

ShippingPhoneNumberstring

ShippingPhoneNumber. MaxLength: 50. Nullable.

Glnstring

Gln. MaxLength: 50. Nullable.

{
  "Id": 0,
  "QuotationId": 0,
  "ClientCustomerAddressId": 0,
  "ClientCompanyAddressId": 0,
  "CustomerId": 0,
  "CompanyId": 0,
  "TypeId": 0,
  "CareOf": "string",
  "AddressLine1": "string",
  "AddressLine2": "string",
  "ZipCode": "string",
  "City": "string",
  "Region": "string",
  "CountryId": 0,
  "Created": "2019-08-24T14:15:22Z",
  "CreatedBy": 0,
  "CompanyName": "string",
  "FirstName": "string",
  "LastName": "string",
  "CellPhoneNumber": "string",
  "Email": "string",
  "ClientId": 0,
  "ShippingPhoneNumber": "string",
  "Gln": "string"
}

Orders

Operations