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