When creating reports in the Report Definition Wizard you need to choose what table to take the info from. Below is a list of the common tables and examples of what reports can be taken from them.
AUTOMOBILE_ISSUE_MASTER
Here we find information about Vehicle Issuing. Use this table to create reports showing information about Issuing Vehicles to employees. Vehicle Issuing is part of the Fleet Module.
BREAKDOWN_MASTER
Here we find information from Vehicle Breakdown Reports. Use this table to create reports showing information about vehicle breakdowns. Vehicle Breakdown Reports are part of the Fleet Module.
CHECKLIST_RESULTS_MASTER
Here we find the results entered on checklists. Use this table for things such as showing deficiency trends.
CREW_MASTER
Here we find the information entered about crews such as employees, available hours and schedules. This information is all entered on the Crew Entry screen.
DOCUMENT_MASTER
Here is the information entered about documents. Use this to export a list of existing documents and information about them such as locations and filenames.
EMPLOYEE_MASTER
Here we find information entered on the Employee Entry screen such as Name, Trade, Wages, Vacation time and much more.
EMPLOYEE_TRANS_MASTER
Here we find hour transactions for employees. This includes hours entered on Work orders as well as time cards. Use this table any time you are looking for total hours or labour costs.
EQUIPMENT_MASTER
Here we find all the information entered in the equipment entry screen. Use this table to report on information such as BOM, Equipment Departments or equipment within a building.
FUELING_MASTER
Here we find all information about Vehicle Fueling. Use this table to create reports showing information about fueling Vehicles. Vehicle Fueling is part of the Fleet Module.
INVENTORY_ADJUSTMENT_MASTER
Here we find information about adjustments made to inventory OHQ either through the Inventory Adjustment screen or through Physical Counts. Note: Adjustment Records are created when the OHQ is changed on the Inventory Detail Entry screen as well.
INVENTORY_DETAIL_MASTER
Here we find the information entered on the Inventory Detail screen, as well as the Inventory header information. Use this table to run reports on warehouse specific information such as On Hand Quantities, Locations, and Suppliers.
INVENTORY_HEADER_MASTER
Here we find all the information entered on the Inventor Header screen. This is the non warehouse specific information about your parts. Use this table to report on things such as costs or unit of measure.
INVENTORY_ISSUE_MASTER
Here we find information about inventory issues. Use the table to create reports on material usage and material costs.
INVENTORY_PICKLIST_MASTER
Here we find information entered on picklists when they are created from Directline Mobile. Use this to create reports about pick list contents, and status.
PM_DETAIL_MASTER
Here we find all the information entered on the PM Detail screen (Accessed by hitting Line Scheduling Details on the PM Procedure Entry screen). Use this table to report on Planned labor and materials, Documents, and Checklists.
PM_HEADER_MASTER
Here we find all the information entered on the PM Procedure Entry screen. Use this table to create reports on pm info such as Last Done dates, Frequencies, Equipment, and Priority.
PURCHASE_DIRECT_MASTER
Here we find all the information entered in the Direct Purchase screen. Use this table to report on info such as cost, items purchased and date purchased. This info is for direct purchases only, not purchase orders.
PURCHASE_ORDER_MASTER
Here we find information about Purchase Orders. Purchases only appear here once the Requisition has been approved and the PO has been generated. Use this table to create reports on Purchase cost, status of a purchase, Received to date or items ordered from a supplier. Note: This table is only used when using the Full Package Purchasing.
PUR_AGENT_MASTER
Here we find the information about purchase agents. Use this table to create a list of Purchasing Agents and their limits. Note: this table is only populated if Purchasing Agents are enabled in Directline System Defaults.
READING_MASTER
Here we find Reading measurements and values entered in the Reading module. i.e. Utility Readings.
RECEIPT_MASTER
Here we find Information about inventory Receipts. Use this table to create reports on Date items were received, what items were received and who received them.
REQUISITION_MASTER
Here we find all information entered on a requisition. Use this table to create reports on Reqs on a desk, approval status, items ordered, and Suppliers. Note: Once a PO is generated the Requisition is no longer updated so be sure to report on POs once they have been generated.
SAFETY_PROCEDURES_MASTER
Here we find all the information entered On the Safety Procedures screen. Use this table to generate a list of Safety procedures and their associated documents.
SPACE_BUILDINGS
Here we find the information entered on the building Entry screen. Use this table to report on information such as superintendent, contacts, assignable area, and building age.
STANDARD_PROCEDURES_MASTER
Here we find all the information entered On the Standard Procedures screen. Use this table to generate a list of Standard Procedures and their associated documents.
SUPPLIER_MASTER
Here we find all the information entered in the supplier Entry screen. Use this table to create a list of suppliers as well as contact information and prequalification categories.
WORK_ORDER_MASTER
This table contains all information about work orders including both planning and completion information. Use this table to create any report with work order info on it such as Equipment History, PM Work orders, Work orders created within a date range, and many more.