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 Module
4. Vtrn - Expense module (diesel, toll, tyres, etc.)
5. OiCtrn - Open Item Creditors (current period)
6. OiDtrn - Open Item Debtors (current period)
7. ItemizedInv - Itemized Invoice lines
8. CrMaster - Creditor Masterfile
9. DrMaster - Debtors Masterfile
10. DriverMaster - Driver Masterfile
11. VehicleMaster - Vehicle Masterfile
These are the standard Datatim tables & fields as at March 2025.
Please note that these may differ due to:
1. Systems being older than the latest system; or
2. Customized fields built for Datatim clients.
Related Articles
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 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 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 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 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, ...