SCHEMA REFERENCES
/
Commerce Query
/
Query Reporting
Last updated

Query Reporting schemas

The Reporting Namespace in Norce Commerce Query has the entities and methods for lookup up some simpler reports and summaries.

OrderSummaryByDay

Clientstring

Client. MaxLength: 100. Key property.

Applicationstring

Application. MaxLength: 50. Key property.

Yearinteger(int32)

Year. Key property.

Monthinteger(int32)

Month. Key property.

Dayinteger(int32)

Day. 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.

OrderSummaryByMonth

Clientstring

Client. MaxLength: 100. Key property.

Applicationstring

Application. MaxLength: 50. Key property.

Yearinteger(int32)

Year. Key property.

Monthinteger(int32)

Month. 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.

OrderSummaryByPaymentAndMonth

Clientstring

Client. MaxLength: 100. Key property.

Applicationstring

Application. MaxLength: 50. Key property.

PaymentServicestring

PaymentService. MaxLength: 50. Key property.

PaymentMethodTypestring

PaymentMethodType. MaxLength: 50. Key property.

PaymentMethodstring

PaymentMethod. MaxLength: 50. Key property.

Yearinteger(int32)

Year. Key property.

Monthinteger(int32)

Month. 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.

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.

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.

SC3Task

Idinteger(int32)

Id. Key property.

Keystring(guid)

Key.

ClientKeystring(guid)

ClientKey.

SupplierKeystring(guid)

SupplierKey.

Namestring

Name. MaxLength: 255. Nullable.

Descriptionstring

Description. Nullable.

IsActiveboolean

IsActive.

SecretKeystring(guid)

SecretKey. Nullable.

Updatedstring(date-time)

Updated.

UpdatedByinteger(int32)

UpdatedBy.

RowIdstring

RowId. MaxLength: 8. Nullable.

HistoryArray of objects(Enferno.Storm.Query.Api.DataContexts.StormCore.SC3TaskHistory)(Enferno.Storm.Query.Api.DataContexts.StormCore.SC3TaskHistory)

History.

SC3TaskHistory

TaskIdinteger(int32)

TaskId. Key property.

Idstring

Id.

BatchIdstring(guid)

BatchId. Nullable.

ResultCodestring

ResultCode. MaxLength: 50. Nullable.

ResultMessagestring

ResultMessage. MaxLength: 500. Nullable.

ProcessStartedstring(date-time)

ProcessStarted. Nullable.

ScRowsinteger(int32)

ScRows. Nullable.

DataRowsinteger(int32)

DataRows. Nullable.

StatusMessagestring

StatusMessage. MaxLength: 500. Nullable.

Durationinteger(int32)

Duration. Nullable.

ProcessEndedstring(date-time)

ProcessEnded. Nullable.

Timestampstring(date-time)

Timestamp.

Subscription

Idinteger(int32)

Id. Key property.

ClientIdinteger(int32)

ClientId.

SourceIdinteger(int32)

SourceId.

DestinationIdinteger(int32)

DestinationId.

WarningMinuteCountinteger(int32)

WarningMinuteCount. Nullable.

IsActiveboolean

IsActive.

IsTestboolean

IsTest.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

PublicationsArray of objects(Enferno.Storm.Query.Api.DataContexts.ReportingModel.SubscriptionPublication)(Enferno.Storm.Query.Api.DataContexts.ReportingModel.SubscriptionPublication)

Publications.

SubscriptionDestination

Idinteger(int32)

Id. Key property.

DefaultNamestring

DefaultName. MaxLength: 50. Nullable.

DefaultDescriptionstring

DefaultDescription. MaxLength: 500. Nullable.

IsActiveboolean

IsActive.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

SubscriptionsArray of objects(Enferno.Storm.Query.Api.DataContexts.ReportingModel.Subscription)(Enferno.Storm.Query.Api.DataContexts.ReportingModel.Subscription)

Subscriptions.

Culturesobject(Enferno.Storm.Query.Api.DataContexts.ReportingModel.SubscriptionDestinationCulture)(Enferno.Storm.Query.Api.DataContexts.ReportingModel.SubscriptionDestinationCulture)

SubscriptionDestinationCulture

DestinationIdinteger(int32)

DestinationId. Key property.

CultureCodestring

CultureCode. MaxLength: 16. Nullable.

Namestring

Name. MaxLength: 50. Nullable.

Descriptionstring

Description. MaxLength: 500. Nullable.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

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.

SubscriptionSource

Idinteger(int32)

Id. Key property.

DefaultNamestring

DefaultName. MaxLength: 50. Nullable.

DefaultDescriptionstring

DefaultDescription. MaxLength: 500. Nullable.

GroupIdinteger(int32)

GroupId.

TypeIdinteger(int32)

TypeId.

IsActiveboolean

IsActive.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

CulturesArray of objects(Enferno.Storm.Query.Api.DataContexts.ReportingModel.SubscriptionSourceCulture)(Enferno.Storm.Query.Api.DataContexts.ReportingModel.SubscriptionSourceCulture)

Cultures.

SubscriptionsArray of objects(Enferno.Storm.Query.Api.DataContexts.ReportingModel.Subscription)(Enferno.Storm.Query.Api.DataContexts.ReportingModel.Subscription)

Subscriptions.

SubscriptionSourceCulture

SourceIdinteger(int32)

SourceId. Key property.

CultureCodestring

CultureCode. MaxLength: 16. Nullable.

Namestring

Name. MaxLength: 50. Nullable.

Descriptionstring

Description. MaxLength: 500. Nullable.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

SubscriptionSourceGroup

Idinteger(int32)

Id. Key property.

DefaultNamestring

DefaultName. MaxLength: 50. Nullable.

DefaultDescriptionstring

DefaultDescription. MaxLength: 500. Nullable.

IsActiveboolean

IsActive.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

Culturesobject(Enferno.Storm.Query.Api.DataContexts.ReportingModel.SubscriptionSourceGroupCulture)(Enferno.Storm.Query.Api.DataContexts.ReportingModel.SubscriptionSourceGroupCulture)
SourcesArray of objects(Enferno.Storm.Query.Api.DataContexts.ReportingModel.SubscriptionSource)(Enferno.Storm.Query.Api.DataContexts.ReportingModel.SubscriptionSource)

Sources.

SubscriptionSourceGroupCulture

GroupIdinteger(int32)

GroupId. Key property.

CultureCodestring

CultureCode. MaxLength: 16. Nullable.

Namestring

Name. MaxLength: 50. Nullable.

Descriptionstring

Description. MaxLength: 500. Nullable.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

SubscriptionSourceType

Idinteger(int32)

Id. Key property.

DefaultNamestring

DefaultName. MaxLength: 50. Nullable.

DefaultDescriptionstring

DefaultDescription. MaxLength: 500. Nullable.

IsActiveboolean

IsActive.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

Culturesobject(Enferno.Storm.Query.Api.DataContexts.ReportingModel.SubscriptionSourceTypeCulture)(Enferno.Storm.Query.Api.DataContexts.ReportingModel.SubscriptionSourceTypeCulture)
SourcesArray of objects(Enferno.Storm.Query.Api.DataContexts.ReportingModel.SubscriptionSource)(Enferno.Storm.Query.Api.DataContexts.ReportingModel.SubscriptionSource)

Sources.

SubscriptionSourceTypeCulture

TypeIdinteger(int32)

TypeId. Key property.

CultureCodestring

CultureCode. MaxLength: 16. Nullable.

Namestring

Name. MaxLength: 50. Nullable.

Descriptionstring

Description. MaxLength: 500. Nullable.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

Previous page
Next page