metafresh logo and link to homepage

IT FRESH-344

IT FRESH-344

Move KPI SQL to repository and new DB Schema

A list with some of the KPIs we have and what they do

Inventory Turnover

  1. What is used for
  2. Calling the function

Purchase Order Aging Report

  1. What is used for
  2. Calling the function

Sales Order Aging Report

  1. What is used for
  2. Calling the function

Purchase price range

  1. What is used for
  2. Calling the function

Sales Price Range

  1. What is used for
  2. Calling the function

Top Customers

  1. What is used for
  2. Calling the function

Top Vendors

  1. What is used for
  2. Calling the function

Top Performers purchase

  1. What is used for
  2. Calling the function

Top Performers sales

  1. What is used for
  2. Calling the function

Top Products Purchase

  1. What is used for
  2. Calling the function

Top Products Sales

  1. What is used for
  2. Calling the function

Vendor delivery promise date performance

  1. What is used for
  2. Calling the function

Vendor delivery quality performance

  1. What is used for
  2. Calling the function

Workflow duration purchase inout

  1. What is used for
  2. Calling the function

Workflow duration purchase invoice

  1. What is used for
  2. Calling the function

Workflow duration purchase order

  1. What is used for
  2. Calling the function

Workflow duration sales inout

  1. What is used for
  2. Calling the function

Workflow duration sales invoice

  1. What is used for
  2. Calling the function

Workflow duration sales order

  1. What is used for
  2. Calling the function

Accounts Payable Turnover

  1. What is used for
  2. Calling the function

Accounts Receivable Turnover

  1. What is used for
  2. Calling the function

Performance Asynch today vs average 30 Days

  1. What is used for
  2. Calling the function

Machine time as percentage of order lead time

  1. What is used for
  2. Calling the function

Open Session today

  1. What is used for
  2. Calling the function

Qty open sessions today vs. average 30 days

  1. What is used for
  2. Calling the function

Production Run setup Time

  1. What is used for
  2. Calling the function

projected vs. actual time production line

  1. What is used for
  2. Calling the function

Operating Cash Flow

  1. What is used for
  2. Calling the function

Projected cash flow

  1. What is used for
  2. Calling the function

Purchase Order Status

  1. What is used for
  2. Calling the function

Purchase Order Status Overview

  1. What is used for
  2. Calling the function

Sales Invoice Status

  1. What is used for
  2. Calling the function

Sales Order Status

  1. What is used for
  2. Calling the function

Sales Order Status Overview

  1. What is used for
  2. Calling the function

Top 10 Best Scrap Numbers

  1. What is used for
  2. Calling the function

Top 10 Worst Scrap Numbers

  1. What is used for
  2. Calling the function

Shipment Status

  1. What is used for
  2. Calling the function

Top 10 Worst Machine Times As Percentage or Order Lead Time

  1. What is used for
  2. Calling the function

Top 10 Products Inventory Value

  1. What is used for
  2. Calling the function

Worst Performing Products last year - Purchase

  1. What is used for
  2. Calling the function

Worst Performing Products last year - Sales

  1. What is used for
  2. Calling the function

Zur Quelldatei auf github.com