COMMERCE QUERY
/
Reporting
/
Schemas
/
Enferno.Storm.Query.Api.DataContexts.ReportingModel.OrderSummaryRolling

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
Languages
Servers

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

Schemas

Enferno.Storm.Query.Api.DataContexts.ReportingModel.OrderSummaryByWeek

Clientstring

Client. MaxLength: 100. Key property.

Applicationstring

Application. MaxLength: 50. Key property.

Yearinteger(int32)

Year. Key property.

Weekinteger(int32)

Week. Key property.

OrderQtyinteger(int32)

OrderQty.

FreightCostExVatnumber(decimal)

FreightCostExVat.

FreightCostIncVatnumber(decimal)

FreightCostIncVat.

OrderFeeExVatnumber(decimal)

OrderFeeExVat.

OrderFeeIncVatnumber(decimal)

OrderFeeIncVat.

ItemQtynumber(decimal)

ItemQty.

ItemAmountExVatnumber(decimal)

ItemAmountExVat.

ItemAmountIncVatnumber(decimal)

ItemAmountIncVat.

OrderSumExVatnumber(decimal)

OrderSumExVat.

OrderSumIncVatnumber(decimal)

OrderSumIncVat.

{
  "Client": "string",
  "Application": "string",
  "Year": 0,
  "Week": 0,
  "OrderQty": 0,
  "FreightCostExVat": 0,
  "FreightCostIncVat": 0,
  "OrderFeeExVat": 0,
  "OrderFeeIncVat": 0,
  "ItemQty": 0,
  "ItemAmountExVat": 0,
  "ItemAmountIncVat": 0,
  "OrderSumExVat": 0,
  "OrderSumIncVat": 0
}

Enferno.Storm.Query.Api.DataContexts.ReportingModel.OrderSummaryRolling

Clientstring

Client. MaxLength: 100. Key property.

Applicationstring

Application. MaxLength: 50. Key property.

OrderQtyinteger(int32)

OrderQty.

ItemQtynumber(decimal)

ItemQty.

OrderSumExVatnumber(decimal)

OrderSumExVat.

OrderSumIncVatnumber(decimal)

OrderSumIncVat.

{
  "Client": "string",
  "Application": "string",
  "OrderQty": 0,
  "ItemQty": 0,
  "OrderSumExVat": 0,
  "OrderSumIncVat": 0
}

Enferno.Storm.Query.Api.DataContexts.ReportingModel.SubscriptionPublication

SubscriptionIdinteger(int32)

SubscriptionId. Key property.

PublicationIdinteger(int32)

PublicationId. Key property.

PublicationDescriptionstring

PublicationDescription. MaxLength: 255. Nullable.

Expectedstring(date-time)

Expected.

LastExportstring(date-time)

LastExport. Nullable.

IsActiveboolean

IsActive.

SeverityMessageIdinteger(int32)

SeverityMessageId. Nullable.

SeverityMessageUpdatedstring(date-time)

SeverityMessageUpdated. Nullable.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

{
  "SubscriptionId": 0,
  "PublicationId": 0,
  "PublicationDescription": "string",
  "Expected": "2019-08-24T14:15:22Z",
  "LastExport": "2019-08-24T14:15:22Z",
  "IsActive": true,
  "SeverityMessageId": 0,
  "SeverityMessageUpdated": "2019-08-24T14:15:22Z",
  "Created": "2019-08-24T14:15:22Z",
  "CreatedBy": 0,
  "Updated": "2019-08-24T14:15:22Z",
  "UpdatedBy": 0
}

Reporting

Operations