Crm.Sales.SalesAnalytics View
Namespace: Crm.Sales
Grouped sales data. Entity: Crm_Sales_Analytics (Introduced in version 26.2.0.62)
Default Visualization
Default Display Text Format:
{SalesAnalyticId}: {DocumentDate}
Default Search Members:
__
Category: Views
Show in UI: ShownByDefault
API access: ReadOnly
Aggregate
An aggregate is a cluster of domain objects that can be treated as a single unit.
Aggregate Tree
Attributes
| Name | Type | Description |
|---|---|---|
| DocumentDate | date | Date to group for. Required Filter(ge;le) ORD |
| LineAmount | decimal (38, 2) | Line Amount for date. Required |
| LineDiscountAmount | decimal (38, 2) | Discount over Line Amount for Date. Required |
| QuantityBase | decimal (38, 3) | Base Quantity for Date. Required |
| SalesAnalyticId | guid | Row Id. Required Filter(multi eq) |
| StandardQuantityBase | decimal (38, 3) | Standard Base Quantity for Date. Required |
References
| Name | Type | Description |
|---|---|---|
| BonusProgram | BonusPrograms | Bonus Program used in sales. Required Default(New Guid) Filter(multi eq) Inherited from Crm_Bonus_Programs_Table.Bonus_Program_Id |
| Customer | Customers | Unique customer Id. Required Default(New Guid) Filter(multi eq) Inherited from Crm_Customers_Table.Customer_Id |
| Dealer | Dealers | External Dealer for this sales. Required Default(New Guid) Filter(multi eq) Inherited from Crm_Dealers_Table.Dealer_Id |
| DistributionChannel | DistributionChannels | Distribution Channel for this sales. Required Default(New Guid) Filter(multi eq) Inherited from Crm_Distribution_<br />Channels_Table.Distribution_Channel_Id |
| DocumentCurrency | Currencies | Currency for this sales. Required Default(New Guid) Filter(multi eq) Inherited from Gen_Currencies_Table.Currency_Id |
| EndCustomerParty | Parties | Unique party id. Required Default(New Guid) Filter(multi eq) Inherited from Gen_Parties_Table.Id |
| EnterpriseCompany | EnterpriseCompanies | The Enterprise Company to which this SalesAnalyticsEntry applies. Required Default(New Guid) Filter(multi eq) Inherited from Gen_Enterprise_<br />Companies_Table.Enterprise_Company_Id |
| EnterpriseCompanyLocation | CompanyLocations | The Enterprise Company Location to which this SalesAnalyticsEntry applies. Required Default(New Guid) Filter(multi eq) Inherited from Cm_Company_Locations_Table.Company_Location_Id |
| Level1Discount | LineDiscounts | Level 1 Discount for this sales. Required Default(New Guid) Filter(multi eq) Inherited from Crm_Line_Discounts_Table.Line_Discount_Id |
| Level2Discount | LineDiscounts | Level 2 Discount for this sales. Required Default(New Guid) Filter(multi eq) Inherited from Crm_Line_Discounts_Table.Line_Discount_Id |
| Level3Discount | LineDiscounts | Level 3 Discount for this sales. Required Default(New Guid) Filter(multi eq) Inherited from Crm_Line_Discounts_Table.Line_Discount_Id |
| Product | Products | Unique id of the item. Required Default(New Guid) Filter(multi eq) ORD Inherited from Gen_Products_Table.Id |
| ProductPrice | ProductPrices | Product Price for this sales. Required Default(New Guid) Filter(multi eq) Inherited from Crm_Product_Prices_Table.Product_Price_Id |
| ProductVariant | ProductVariants | Product Variant for this sales. Required Default(New Guid) Filter(multi eq) Inherited from Gen_Product_Variants_Table.Product_Variant_Id |
| PromotionalPackage | PromotionalPackages | Promotional Package for this sales. Required Default(New Guid) Filter(multi eq) Inherited from Crm_Promotional_<br />Packages_Table.Promotional_Package_Id |
| SalesPerson | SalesPersons | Unique sales person for this sales. Required Default(New Guid) Filter(multi eq) Inherited from Crm_Sales_Persons_Table.Sales_Person_Id |
| Store | Stores | Unique store Id. Required Default(New Guid) Filter(multi eq) Inherited from Inv_Stores_Table.Id |
Attribute Details
DocumentDate
Date to group for. Required Filter(ge;le) ORD
Type: date
Category: System
Supported Filters: GreaterThanOrLessThan
Supports Order By: True
Show in UI: ShownByDefault
LineAmount
Line Amount for date. Required
Type: decimal (38, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
LineDiscountAmount
Discount over Line Amount for Date. Required
Type: decimal (38, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
QuantityBase
Base Quantity for Date. Required
Type: decimal (38, 3)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
SalesAnalyticId
Row Id. Required Filter(multi eq)
Type: guid
Category: System
Supported Filters: Equals, EqualsIn
Show in UI: ShownByDefault
StandardQuantityBase
Standard Base Quantity for Date. Required
Type: decimal (38, 3)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
Reference Details
BonusProgram
Bonus Program used in sales. Required Default(New Guid) Filter(multi eq) Inherited from Crm_Bonus_Programs_Table.Bonus_Program_Id
Type: BonusPrograms
Category: System
Inherited From: Crm_Bonus_Programs_Table.Bonus_Program_Id
Supported Filters: Equals, EqualsIn
Default Value: NewGuid
Show in UI: ShownByDefault
Customer
Unique customer Id. Required Default(New Guid) Filter(multi eq) Inherited from Crm_Customers_Table.Customer_Id
Type: Customers
Category: System
Inherited From: Crm_Customers_Table.Customer_Id
Supported Filters: Equals, EqualsIn
Default Value: NewGuid
Show in UI: ShownByDefault
Dealer
External Dealer for this sales. Required Default(New Guid) Filter(multi eq) Inherited from Crm_Dealers_Table.Dealer_Id
Type: Dealers
Category: System
Inherited From: Crm_Dealers_Table.Dealer_Id
Supported Filters: Equals, EqualsIn
Default Value: NewGuid
Show in UI: ShownByDefault
DistributionChannel
Distribution Channel for this sales. Required Default(New Guid) Filter(multi eq) Inherited from Crm_Distribution_Channels_Table.Distribution_Channel_Id
Type: DistributionChannels
Category: System
Inherited From: Crm_Distribution_Channels_Table.Distribution_Channel_Id
Supported Filters: Equals, EqualsIn
Default Value: NewGuid
Show in UI: ShownByDefault
DocumentCurrency
Currency for this sales. Required Default(New Guid) Filter(multi eq) Inherited from Gen_Currencies_Table.Currency_Id
Type: Currencies
Category: System
Inherited From: Gen_Currencies_Table.Currency_Id
Supported Filters: Equals, EqualsIn
Default Value: NewGuid
Show in UI: ShownByDefault
EndCustomerParty
Unique party id. Required Default(New Guid) Filter(multi eq) Inherited from Gen_Parties_Table.Id
Type: Parties
Category: System
Inherited From: Gen_Parties_Table.Id
Supported Filters: Equals, EqualsIn
Default Value: NewGuid
Show in UI: ShownByDefault
EnterpriseCompany
The Enterprise Company to which this SalesAnalyticsEntry applies. Required Default(New Guid) Filter(multi eq) Inherited from Gen_Enterprise_Companies_Table.Enterprise_Company_Id
Type: EnterpriseCompanies
Category: System
Inherited From: Gen_Enterprise_Companies_Table.Enterprise_Company_Id
Supported Filters: Equals, EqualsIn
Default Value: NewGuid
Show in UI: ShownByDefault
EnterpriseCompanyLocation
The Enterprise Company Location to which this SalesAnalyticsEntry applies. Required Default(New Guid) Filter(multi eq) Inherited from Cm_Company_Locations_Table.Company_Location_Id
Type: CompanyLocations
Category: System
Inherited From: Cm_Company_Locations_Table.Company_Location_Id
Supported Filters: Equals, EqualsIn
Default Value: NewGuid
Show in UI: ShownByDefault
Level1Discount
Level 1 Discount for this sales. Required Default(New Guid) Filter(multi eq) Inherited from Crm_Line_Discounts_Table.Line_Discount_Id
Type: LineDiscounts
Category: System
Inherited From: Crm_Line_Discounts_Table.Line_Discount_Id
Supported Filters: Equals, EqualsIn
Default Value: NewGuid
Show in UI: ShownByDefault
Level2Discount
Level 2 Discount for this sales. Required Default(New Guid) Filter(multi eq) Inherited from Crm_Line_Discounts_Table.Line_Discount_Id
Type: LineDiscounts
Category: System
Inherited From: Crm_Line_Discounts_Table.Line_Discount_Id
Supported Filters: Equals, EqualsIn
Default Value: NewGuid
Show in UI: ShownByDefault
Level3Discount
Level 3 Discount for this sales. Required Default(New Guid) Filter(multi eq) Inherited from Crm_Line_Discounts_Table.Line_Discount_Id
Type: LineDiscounts
Category: System
Inherited From: Crm_Line_Discounts_Table.Line_Discount_Id
Supported Filters: Equals, EqualsIn
Default Value: NewGuid
Show in UI: ShownByDefault
Product
Unique id of the item. Required Default(New Guid) Filter(multi eq) ORD Inherited from Gen_Products_Table.Id
Type: Products
Category: System
Inherited From: Gen_Products_Table.Id
Supported Filters: Equals, EqualsIn
Default Value: NewGuid
Show in UI: ShownByDefault
ProductPrice
Product Price for this sales. Required Default(New Guid) Filter(multi eq) Inherited from Crm_Product_Prices_Table.Product_Price_Id
Type: ProductPrices
Category: System
Inherited From: Crm_Product_Prices_Table.Product_Price_Id
Supported Filters: Equals, EqualsIn
Default Value: NewGuid
Show in UI: ShownByDefault
ProductVariant
Product Variant for this sales. Required Default(New Guid) Filter(multi eq) Inherited from Gen_Product_Variants_Table.Product_Variant_Id
Type: ProductVariants
Category: System
Inherited From: Gen_Product_Variants_Table.Product_Variant_Id
Supported Filters: Equals, EqualsIn
Default Value: NewGuid
Show in UI: ShownByDefault
PromotionalPackage
Promotional Package for this sales. Required Default(New Guid) Filter(multi eq) Inherited from Crm_Promotional_Packages_Table.Promotional_Package_Id
Type: PromotionalPackages
Category: System
Inherited From: Crm_Promotional_Packages_Table.Promotional_Package_Id
Supported Filters: Equals, EqualsIn
Default Value: NewGuid
Show in UI: ShownByDefault
SalesPerson
Unique sales person for this sales. Required Default(New Guid) Filter(multi eq) Inherited from Crm_Sales_Persons_Table.Sales_Person_Id
Type: SalesPersons
Category: System
Inherited From: Crm_Sales_Persons_Table.Sales_Person_Id
Supported Filters: Equals, EqualsIn
Default Value: NewGuid
Show in UI: ShownByDefault
Store
Unique store Id. Required Default(New Guid) Filter(multi eq) Inherited from Inv_Stores_Table.Id
Type: Stores
Category: System
Inherited From: Inv_Stores_Table.Id
Supported Filters: Equals, EqualsIn
Default Value: NewGuid
Show in UI: ShownByDefault
API
Domain API Entity Set: Crm_Sales_SalesAnalytics
Domain API Entity Type: Crm_Sales_SalesAnalyticsEntry
Domain API Query: https://testdb.my.erp.net/api/domain/odata/Crm_Sales_SalesAnalytics?$top=10
Domain API Query Builder: https://testdb.my.erp.net/api/domain/querybuilder#Crm_Sales_SalesAnalytics?$top=10