FLOW Analytics | Datatim Base Query 7 | Vehicle Expense (VTRN) Table

FLOW Analytics | Datatim Base Query 7 | Vehicle Expense (VTRN) Table

This is showing you ALL expense data. 

SELECT  *
FROM vwa_vtrn

If you want Diesel Consumption, build a separate Data Model and have a look at the next article titled:
FLOW Analytics | Datatim Base Query 8 | Diesel Consumption (VTRN) Table

    • Related Articles

    • Datatim Back-End Tables

      The attached file shows each table and fields in the most used and standard Datatim tables, currently in use on FLOW Analytics. These include: 1. tblloadschedule - Load Schedule 2. loadconfirmation - Collection and Delivery addresses 3. KPI - KPI ...

    • FLOW Analytics | Datatim Base Query 8 | Diesel Consumption (VTRN) Table

      This strictly looks at Diesel Consumption only. Please note the Previous Speedo calculations are based on the Vehicle's Previous Odometer reading and NOT per date. You can adjust if needed, but I find this the best and most popular way. SELECT ...

    • FLOW Analytics | Datatim Base Query 6 | Vehicle Masterfile Table

      You may need to adjust the KM parameters based on how the client defines their parameters. SELECT VehicleNumber, Registration, TranspNo, TranspDescrip, VehDormantFlag, CASE WHEN VehicleCategory = 'H' THEN "Horse" WHEN VehicleCategory = 'L' THEN ...

    • FLOW Analytics | Datatim Base Query 1 | Load Schedule Table

      This should cover the base Datatim systems and run successfully. The only challenge will be intricately customized systems. This is additional scoping. Go to Data Model > Add New and paste this Base Query, and then click Run. Base Query: SELECT l.*, ...

    • FLOW Analytics | Datatim Base Query 3 | Driver Masterfile Table

      The Driver Masterfile has a lot of unneccessary fields, but the Expiries dashboards are very popular, hence the detailed query below. SELECT DriverNumber, DriverName, TranspNo, TranspDescrip, DriverDormantFlag, PDPDate , LicenseDate , ...