COMMERCE QUERY

Orders

Enferno.Storm.Query.Api.DataContexts.OrderModel.WarehouseTransactionItem

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

Enferno.Storm.Query.Api.DataContexts.OrderModel.OrderCustomerInfo

Idstring

Id. Key property.

FirstNamestring

FirstName. MaxLength: 50. Nullable.

LastNamestring

LastName. MaxLength: 50. Nullable.

EmailAddressstring

EmailAddress. MaxLength: 255. Nullable.

PhoneNumberstring

PhoneNumber. MaxLength: 50. Nullable.

CellPhoneNumberstring

CellPhoneNumber. MaxLength: 50. Nullable.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Rowidstring

Rowid. MaxLength: 8. Nullable.

CompanyNamestring

CompanyName. MaxLength: 100. Nullable.

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: 100. Nullable.

CountryIdinteger(int32)

CountryId. Nullable.

ClientIdinteger(int32)

ClientId. Nullable.

ShippingPhoneNumberstring

ShippingPhoneNumber. MaxLength: 50. Nullable.

Glnstring

Gln. MaxLength: 50. Nullable.

{
  "Id": "string",
  "FirstName": "string",
  "LastName": "string",
  "EmailAddress": "string",
  "PhoneNumber": "string",
  "CellPhoneNumber": "string",
  "Created": "2019-08-24T14:15:22Z",
  "CreatedBy": 0,
  "Rowid": "string",
  "CompanyName": "string",
  "CareOf": "string",
  "AddressLine1": "string",
  "AddressLine2": "string",
  "ZipCode": "string",
  "City": "string",
  "Region": "string",
  "CountryId": 0,
  "ClientId": 0,
  "ShippingPhoneNumber": "string",
  "Gln": "string"
}

Enferno.Storm.Query.Api.DataContexts.OrderModel.WarehouseTransactionItem

WarehouseTransactionIdstring

WarehouseTransactionId.

Idstring

Id. Key property.

LineNumbernumber(decimal)

LineNumber.

PartNostring

PartNo. MaxLength: 50. Nullable.

Qtynumber(decimal)

Qty.

Amountnumber(decimal)

Amount.

RemainingQtynumber(decimal)

RemainingQty. Nullable.

RemainingAmountnumber(decimal)

RemainingAmount. Nullable.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

{
  "WarehouseTransactionId": "string",
  "Id": "string",
  "LineNumber": 0,
  "PartNo": "string",
  "Qty": 0,
  "Amount": 0,
  "RemainingQty": 0,
  "RemainingAmount": 0,
  "Created": "2019-08-24T14:15:22Z",
  "CreatedBy": 0
}

Enferno.Storm.Query.Api.DataContexts.OrderModel.OrderItem

Idstring

Id. Key property.

OrderIdstring

OrderId.

LineNumbernumber(decimal)

LineNumber.

ParentLineNumbernumber(decimal)

ParentLineNumber. Nullable.

StatusIdinteger(int32)

StatusId.

PartNostring

PartNo. MaxLength: 50. Nullable.

ExternalPartNostring

ExternalPartNo. MaxLength: 50. Nullable.

ProductNamestring

ProductName. MaxLength: 255. Nullable.

StockUnitOfMeasurementCountnumber(decimal)

StockUnitOfMeasurementCount.

PriceUnitOfMeasurementCountnumber(decimal)

PriceUnitOfMeasurementCount.

WarehouseIdinteger(int32)

WarehouseId. Nullable.

LocationIdinteger(int32)

LocationId. Nullable.

QtyOrderednumber(decimal)

QtyOrdered.

CurrencyIdinteger(int32)

CurrencyId.

VatRatenumber(decimal)

VatRate.

CostUnitnumber(decimal)

CostUnit.

PriceSalenumber(decimal)

PriceSale.

DiscountPercentagenumber(decimal)

DiscountPercentage.

DiscountAmountnumber(decimal)

DiscountAmount.

LineAmountnumber(decimal)

LineAmount.

DeliveryModestring

DeliveryMode. MaxLength: 50. Nullable.

IsPartDeliveryboolean

IsPartDelivery.

ExpectedDeliveryDatestring(date-time)

ExpectedDeliveryDate. Nullable.

ConfirmedDeliveryDatestring(date-time)

ConfirmedDeliveryDate. Nullable.

SalesRepContactIdinteger(int32)

SalesRepContactId. Nullable.

LedgerAccountstring

LedgerAccount. MaxLength: 50. Nullable.

Departmentstring

Department. MaxLength: 10. Nullable.

Centrestring

Centre. MaxLength: 10. Nullable.

TransIdstring

TransId.

ExternalStatusTextstring

ExternalStatusText. MaxLength: 255. Nullable.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

LineNumberStringstring

LineNumberString. MaxLength: 50. Nullable.

PriceRecommendednumber(decimal)

PriceRecommended. Nullable.

PriceCatalognumber(decimal)

PriceCatalog. Nullable.

PriceStandardnumber(decimal)

PriceStandard. Nullable.

ClientIdinteger(int32)

ClientId. Nullable.

InvoiceItemArray of objects(OrderService.InvoiceItem)(OrderService.InvoiceItem)

InvoiceItem.

InfosArray of objects(Enferno.Storm.Query.Api.DataContexts.OrderModel.OrderItemInfo)(Enferno.Storm.Query.Api.DataContexts.OrderModel.OrderItemInfo)

Infos.

{
  "Id": "string",
  "OrderId": "string",
  "LineNumber": 0,
  "ParentLineNumber": 0,
  "StatusId": 0,
  "PartNo": "string",
  "ExternalPartNo": "string",
  "ProductName": "string",
  "StockUnitOfMeasurementCount": 0,
  "PriceUnitOfMeasurementCount": 0,
  "WarehouseId": 0,
  "LocationId": 0,
  "QtyOrdered": 0,
  "CurrencyId": 0,
  "VatRate": 0,
  "CostUnit": 0,
  "PriceSale": 0,
  "DiscountPercentage": 0,
  "DiscountAmount": 0,
  "LineAmount": 0,
  "DeliveryMode": "string",
  "IsPartDelivery": true,
  "ExpectedDeliveryDate": "2019-08-24T14:15:22Z",
  "ConfirmedDeliveryDate": "2019-08-24T14:15:22Z",
  "SalesRepContactId": 0,
  "LedgerAccount": "string",
  "Department": "string",
  "Centre": "string",
  "TransId": "string",
  "ExternalStatusText": "string",
  "Created": "2019-08-24T14:15:22Z",
  "CreatedBy": 0,
  "Updated": "2019-08-24T14:15:22Z",
  "UpdatedBy": 0,
  "LineNumberString": "string",
  "PriceRecommended": 0,
  "PriceCatalog": 0,
  "PriceStandard": 0,
  "ClientId": 0,
  "InvoiceItem": [
    { … }
  ],
  "Infos": [
    { … }
  ]
}

Orders

Operations