FLOW Analytics | Datatim Base Query 2 | Creditor Masterfile Table

FLOW Analytics | Datatim Base Query 2 | Creditor Masterfile Table

The only thing that is important, but does not stand out, is the Dedicated tick box on the Creditor Masterfile.

In the backend, it's called CrInterestFlag, therefore, we need to format it like so:

SELECT  *,
        CASE WHEN CrInterestFlag = 'Y' THEN "Dedicated"
        ELSE "Adhoc" END AS TransporterType
FROM vwa_crmaster

    • Related Articles

    • FLOW Analytics | Datatim Base Query 5 | Transporter GIT Expiry Table

      A bit of calculations and joining the creditor masterfile to be able to filter on the active transporters (using CrDormantFlag field). SELECT TrCrNumber AS CrNumber, TrCrName AS CrName, TrInsCompany AS InsuranceCompany, TrInsPolicy AS PolicyNumber, ...

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

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

    • 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.*, ...