Skip to main content

Sales Orders

The data model includes measures such as Sales Order ExtAmt, FreightAmt, Amt Inv cd, Trade Disc Amt, OpenAmt, QtyOpenToShip, Qty On BO, Qty Ord, Qty Ship, Qty Rtrn Credit, and SalesAmt. Views available are Top 10 Item by Order Amount and Sales Orders, offering insights into sales order details, quantities, and related financial aspects without explicitly counting entries. Additionally, HSalesAmt provides a historical aggregated sales amount reference.

Benefits of This Data Model​

  • Enhanced Sales Analysis: The data model allows for in-depth analysis of sales orders, quantities, and related financial aspects without explicitly counting entries.
  • Improved Item Performance Monitoring: Users can easily track the top 10 items based on total order amount for better performance monitoring and decision-making.
  • Comprehensive Customer Insights: Through dimensions like Customer Code, Customer Name, and Customer Class, businesses can gain detailed insights into customer behavior and preferences.
  • Efficient Vendor Management: With dimensions like Vendor Code and Vendor Name, organizations can efficiently manage vendor relationships and track vendor performance.
  • Historical Sales Reference: The HSalesAmt measure provides a historical aggregated sales amount reference for trend analysis and forecasting purposes.

Key Performance Indicators (KPIs)​

  • Sales Order ExtAmt: Total amount of the sales order, including all line items and any additional charges.
  • Sales Order FreightAmt: Amount charged for freight or shipping associated with the sales order.
  • Sales Order Amt Inv cd: Amount of the sales order that has been invoiced and credited.
  • Sales Order Trade Disc Amt: Amount of trade discounts applied to the sales order.
  • Sales Order OpenAmt: Remaining open amount to be invoiced or paid for the sales order.
  • Sales Order QtyOpenToShip: Quantity of items in the sales order that are yet to be shipped.
  • Sales Order Qty On BO: Quantity of items in the sales order that are on backorder.
  • Sales Order Qty Ord: Total quantity of items ordered in the sales order.
  • Sales Order Qty Ship: Total quantity of items shipped from the sales order.
  • Sales Order Qty Rtrn Credit: Quantity of items returned for credit from the sales order.
  • Sales Order SalesAmt: Total amount of sales generated from the order.
  • HSalesAmt: Historic total sales amount aggregated across all sales orders.

Available Visualizations​

View NameDescription
Top 10 Item by Order AmountDisplays the top 10 items based on total order amount for analysis.
Sales OrdersContains data on all sales orders including customer, products, quantities, and dates.