Query Reporting schemas
The Reporting Namespace in Norce Commerce Query has the entities and methods for lookup up some simpler reports and summaries.
OrderSummaryByDay
| Client | string Client. MaxLength: 100. Key property. |
| Application | string Application. MaxLength: 50. Key property. |
| Year | integer <int32> Year. Key property. |
| Month | integer <int32> Month. Key property. |
| Day | integer <int32> Day. Key property. |
| OrderQty | integer <int32> OrderQty. |
| FreightCostExVat | number <decimal> FreightCostExVat. |
| FreightCostIncVat | number <decimal> FreightCostIncVat. |
| OrderFeeExVat | number <decimal> OrderFeeExVat. |
| OrderFeeIncVat | number <decimal> OrderFeeIncVat. |
| ItemQty | number <decimal> ItemQty. |
| ItemAmountExVat | number <decimal> ItemAmountExVat. |
| ItemAmountIncVat | number <decimal> ItemAmountIncVat. |
| OrderSumExVat | number <decimal> OrderSumExVat. |
| OrderSumIncVat | number <decimal> OrderSumIncVat. |
OrderSummaryByMonth
| Client | string Client. MaxLength: 100. Key property. |
| Application | string Application. MaxLength: 50. Key property. |
| Year | integer <int32> Year. Key property. |
| Month | integer <int32> Month. Key property. |
| OrderQty | integer <int32> OrderQty. |
| FreightCostExVat | number <decimal> FreightCostExVat. |
| FreightCostIncVat | number <decimal> FreightCostIncVat. |
| OrderFeeExVat | number <decimal> OrderFeeExVat. |
| OrderFeeIncVat | number <decimal> OrderFeeIncVat. |
| ItemQty | number <decimal> ItemQty. |
| ItemAmountExVat | number <decimal> ItemAmountExVat. |
| ItemAmountIncVat | number <decimal> ItemAmountIncVat. |
| OrderSumExVat | number <decimal> OrderSumExVat. |
| OrderSumIncVat | number <decimal> OrderSumIncVat. |
OrderSummaryByPaymentAndMonth
| Client | string Client. MaxLength: 100. Key property. |
| Application | string Application. MaxLength: 50. Key property. |
| PaymentService | string PaymentService. MaxLength: 50. Key property. |
| PaymentMethodType | string PaymentMethodType. MaxLength: 50. Key property. |
| PaymentMethod | string PaymentMethod. MaxLength: 50. Key property. |
| Year | integer <int32> Year. Key property. |
| Month | integer <int32> Month. Key property. |
| OrderQty | integer <int32> OrderQty. |
| FreightCostExVat | number <decimal> FreightCostExVat. |
| FreightCostIncVat | number <decimal> FreightCostIncVat. |
| OrderFeeExVat | number <decimal> OrderFeeExVat. |
| OrderFeeIncVat | number <decimal> OrderFeeIncVat. |
| ItemQty | number <decimal> ItemQty. |
| ItemAmountExVat | number <decimal> ItemAmountExVat. |
| ItemAmountIncVat | number <decimal> ItemAmountIncVat. |
| OrderSumExVat | number <decimal> OrderSumExVat. |
| OrderSumIncVat | number <decimal> OrderSumIncVat. |
OrderSummaryByWeek
| Client | string Client. MaxLength: 100. Key property. |
| Application | string Application. MaxLength: 50. Key property. |
| Year | integer <int32> Year. Key property. |
| Week | integer <int32> Week. Key property. |
| OrderQty | integer <int32> OrderQty. |
| FreightCostExVat | number <decimal> FreightCostExVat. |
| FreightCostIncVat | number <decimal> FreightCostIncVat. |
| OrderFeeExVat | number <decimal> OrderFeeExVat. |
| OrderFeeIncVat | number <decimal> OrderFeeIncVat. |
| ItemQty | number <decimal> ItemQty. |
| ItemAmountExVat | number <decimal> ItemAmountExVat. |
| ItemAmountIncVat | number <decimal> ItemAmountIncVat. |
| OrderSumExVat | number <decimal> OrderSumExVat. |
| OrderSumIncVat | number <decimal> OrderSumIncVat. |
OrderSummaryRolling
| Client | string Client. MaxLength: 100. Key property. |
| Application | string Application. MaxLength: 50. Key property. |
| OrderQty | integer <int32> OrderQty. |
| ItemQty | number <decimal> ItemQty. |
| OrderSumExVat | number <decimal> OrderSumExVat. |
| OrderSumIncVat | number <decimal> OrderSumIncVat. |
SC3Task
| Id | integer <int32> Id. Key property. |
| Key | string <guid> Key. |
| ClientKey | string <guid> ClientKey. |
| SupplierKey | string <guid> SupplierKey. |
| Name | string Name. MaxLength: 255. Nullable. |
| Description | string Description. Nullable. |
| IsActive | boolean IsActive. |
| SecretKey | string <guid> SecretKey. Nullable. |
| Updated | string <date-time> Updated. |
| UpdatedBy | integer <int32> UpdatedBy. |
| RowId | string RowId. MaxLength: 8. Nullable. |
Array of objects <Enferno.Storm.Query.Api.DataContexts.StormCore.SC3TaskHistory> (Enferno.Storm.Query.Api.DataContexts.StormCore.SC3TaskHistory) History. |
SC3TaskHistory
| TaskId | integer <int32> TaskId. Key property. |
| Id | string Id. |
| BatchId | string <guid> BatchId. Nullable. |
| ResultCode | string ResultCode. MaxLength: 50. Nullable. |
| ResultMessage | string ResultMessage. MaxLength: 500. Nullable. |
| ProcessStarted | string <date-time> ProcessStarted. Nullable. |
| ScRows | integer <int32> ScRows. Nullable. |
| DataRows | integer <int32> DataRows. Nullable. |
| StatusMessage | string StatusMessage. MaxLength: 500. Nullable. |
| Duration | integer <int32> Duration. Nullable. |
| ProcessEnded | string <date-time> ProcessEnded. Nullable. |
| Timestamp | string <date-time> Timestamp. |
Subscription
| Id | integer <int32> Id. Key property. |
| ClientId | integer <int32> ClientId. |
| SourceId | integer <int32> SourceId. |
| DestinationId | integer <int32> DestinationId. |
| WarningMinuteCount | integer <int32> WarningMinuteCount. Nullable. |
| IsActive | boolean IsActive. |
| IsTest | boolean IsTest. |
| Created | string <date-time> Created. |
| CreatedBy | integer <int32> CreatedBy. |
| Updated | string <date-time> Updated. Nullable. |
| UpdatedBy | integer <int32> UpdatedBy. Nullable. |
Array of objects <Enferno.Storm.Query.Api.DataContexts.ReportingModel.SubscriptionPublication> (Enferno.Storm.Query.Api.DataContexts.ReportingModel.SubscriptionPublication) Publications. |
SubscriptionDestination
| Id | integer <int32> Id. Key property. |
| DefaultName | string DefaultName. MaxLength: 50. Nullable. |
| DefaultDescription | string DefaultDescription. MaxLength: 500. Nullable. |
| IsActive | boolean IsActive. |
| Created | string <date-time> Created. |
| CreatedBy | integer <int32> CreatedBy. |
| Updated | string <date-time> Updated. Nullable. |
| UpdatedBy | integer <int32> UpdatedBy. Nullable. |
Array of objects <Enferno.Storm.Query.Api.DataContexts.ReportingModel.Subscription> (Enferno.Storm.Query.Api.DataContexts.ReportingModel.Subscription) Subscriptions. | |
object <Enferno.Storm.Query.Api.DataContexts.ReportingModel.SubscriptionDestinationCulture> (Enferno.Storm.Query.Api.DataContexts.ReportingModel.SubscriptionDestinationCulture) |
SubscriptionDestinationCulture
| DestinationId | integer <int32> DestinationId. Key property. |
| CultureCode | string CultureCode. MaxLength: 16. Nullable. |
| Name | string Name. MaxLength: 50. Nullable. |
| Description | string Description. MaxLength: 500. Nullable. |
| Updated | string <date-time> Updated. Nullable. |
| UpdatedBy | integer <int32> UpdatedBy. Nullable. |
SubscriptionPublication
| SubscriptionId | integer <int32> SubscriptionId. Key property. |
| PublicationId | integer <int32> PublicationId. Key property. |
| PublicationDescription | string PublicationDescription. MaxLength: 255. Nullable. |
| Expected | string <date-time> Expected. |
| LastExport | string <date-time> LastExport. Nullable. |
| IsActive | boolean IsActive. |
| SeverityMessageId | integer <int32> SeverityMessageId. Nullable. |
| SeverityMessageUpdated | string <date-time> SeverityMessageUpdated. Nullable. |
| Created | string <date-time> Created. |
| CreatedBy | integer <int32> CreatedBy. |
| Updated | string <date-time> Updated. Nullable. |
| UpdatedBy | integer <int32> UpdatedBy. Nullable. |
SubscriptionSource
| Id | integer <int32> Id. Key property. |
| DefaultName | string DefaultName. MaxLength: 50. Nullable. |
| DefaultDescription | string DefaultDescription. MaxLength: 500. Nullable. |
| GroupId | integer <int32> GroupId. |
| TypeId | integer <int32> TypeId. |
| IsActive | boolean IsActive. |
| Created | string <date-time> Created. |
| CreatedBy | integer <int32> CreatedBy. |
| Updated | string <date-time> Updated. Nullable. |
| UpdatedBy | integer <int32> UpdatedBy. Nullable. |
Array of objects <Enferno.Storm.Query.Api.DataContexts.ReportingModel.SubscriptionSourceCulture> (Enferno.Storm.Query.Api.DataContexts.ReportingModel.SubscriptionSourceCulture) Cultures. | |
Array of objects <Enferno.Storm.Query.Api.DataContexts.ReportingModel.Subscription> (Enferno.Storm.Query.Api.DataContexts.ReportingModel.Subscription) Subscriptions. |
SubscriptionSourceCulture
| SourceId | integer <int32> SourceId. Key property. |
| CultureCode | string CultureCode. MaxLength: 16. Nullable. |
| Name | string Name. MaxLength: 50. Nullable. |
| Description | string Description. MaxLength: 500. Nullable. |
| Updated | string <date-time> Updated. Nullable. |
| UpdatedBy | integer <int32> UpdatedBy. Nullable. |
SubscriptionSourceGroup
| Id | integer <int32> Id. Key property. |
| DefaultName | string DefaultName. MaxLength: 50. Nullable. |
| DefaultDescription | string DefaultDescription. MaxLength: 500. Nullable. |
| IsActive | boolean IsActive. |
| Created | string <date-time> Created. |
| CreatedBy | integer <int32> CreatedBy. |
| Updated | string <date-time> Updated. Nullable. |
| UpdatedBy | integer <int32> UpdatedBy. Nullable. |
object <Enferno.Storm.Query.Api.DataContexts.ReportingModel.SubscriptionSourceGroupCulture> (Enferno.Storm.Query.Api.DataContexts.ReportingModel.SubscriptionSourceGroupCulture) | |
Array of objects <Enferno.Storm.Query.Api.DataContexts.ReportingModel.SubscriptionSource> (Enferno.Storm.Query.Api.DataContexts.ReportingModel.SubscriptionSource) Sources. |
SubscriptionSourceGroupCulture
| GroupId | integer <int32> GroupId. Key property. |
| CultureCode | string CultureCode. MaxLength: 16. Nullable. |
| Name | string Name. MaxLength: 50. Nullable. |
| Description | string Description. MaxLength: 500. Nullable. |
| Updated | string <date-time> Updated. Nullable. |
| UpdatedBy | integer <int32> UpdatedBy. Nullable. |
SubscriptionSourceType
| Id | integer <int32> Id. Key property. |
| DefaultName | string DefaultName. MaxLength: 50. Nullable. |
| DefaultDescription | string DefaultDescription. MaxLength: 500. Nullable. |
| IsActive | boolean IsActive. |
| Created | string <date-time> Created. |
| CreatedBy | integer <int32> CreatedBy. |
| Updated | string <date-time> Updated. Nullable. |
| UpdatedBy | integer <int32> UpdatedBy. Nullable. |
object <Enferno.Storm.Query.Api.DataContexts.ReportingModel.SubscriptionSourceTypeCulture> (Enferno.Storm.Query.Api.DataContexts.ReportingModel.SubscriptionSourceTypeCulture) | |
Array of objects <Enferno.Storm.Query.Api.DataContexts.ReportingModel.SubscriptionSource> (Enferno.Storm.Query.Api.DataContexts.ReportingModel.SubscriptionSource) Sources. |
SubscriptionSourceTypeCulture
| TypeId | integer <int32> TypeId. Key property. |
| CultureCode | string CultureCode. MaxLength: 16. Nullable. |
| Name | string Name. MaxLength: 50. Nullable. |
| Description | string Description. MaxLength: 500. Nullable. |
| Updated | string <date-time> Updated. Nullable. |
| UpdatedBy | integer <int32> UpdatedBy. Nullable. |