COMMERCE QUERY

Orders

OrderService.QuotationItemInfo

Norce Query API Documentation (2.0)

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

Download OpenAPI description

openapi.json

openapi.yaml

Servers

https://customer-slug.api-se.norce.tech/commerce/query/2.0/

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