Skip to main content

Recently Updated Pages

Clients & Sites - Key Tables

HaloPSA Database Schema Clients & Sites

Full column listings for the 5 key tables in this category. AREA (332 columns) # Column Type L...

Updated 1 month ago by Nate Smith

Invoicing & Billing - Table Index

HaloPSA Database Schema Invoicing & Billing

All 40 tables in the Invoicing & Billing category. Table Type Columns Key ACCOUNTSINTERFAC...

Updated 1 month ago by Nate Smith

Invoicing & Billing - Key Tables

HaloPSA Database Schema Invoicing & Billing

Full column listings for the 5 key tables in this category. CHARGERATE (27 columns) # Column T...

Updated 1 month ago by Nate Smith

Tickets (Faults) - Key Tables

HaloPSA Database Schema Tickets (Faults)

Full column listings for the 13 key tables in this category. FAULTAPPROVAL (30 columns) # Colu...

Updated 1 month ago by Nate Smith

Actions (Ticket Notes) - Table Index

HaloPSA Database Schema Actions (Ticket Notes)

All 7 tables in the Actions (Ticket Notes) category. Table Type Columns Key ACT BASE TABLE...

Updated 1 month ago by Nate Smith

Actions (Ticket Notes) - Key Tables

HaloPSA Database Schema Actions (Ticket Notes)

Full column listings for the 3 key tables in this category. ACTARC (68 columns) # Column Type ...

Updated 1 month ago by Nate Smith

Agents & Technicians - Key Tables

HaloPSA Database Schema Agents & Technicians

Full column listings for the 4 key tables in this category. SECTIONDETAIL (50 columns) # Colum...

Updated 1 month ago by Nate Smith

Reports & Analytics - Table Index

HaloPSA Database Schema Reports & Analytics

All 63 tables in the Reports & Analytics category. Table Type Columns Key ANALYZERFILTER B...

Updated 1 month ago by Nate Smith

Reports & Analytics - Key Tables

HaloPSA Database Schema Reports & Analytics

Full column listings for the 2 key tables in this category. ANALYZERPROFILE (99 columns) # Col...

Updated 1 month ago by Nate Smith

Email & Communication - Table Index

HaloPSA Database Schema Email & Communication

All 50 tables in the Email & Communication category. Table Type Columns Key BulkEmail BASE...

Updated 1 month ago by Nate Smith

Email & Communication - Key Tables

HaloPSA Database Schema Email & Communication

Full column listings for the 3 key tables in this category. EMAILRULE (61 columns) # Column Ty...

Updated 1 month ago by Nate Smith

Assets & Configuration Items - Table Index

HaloPSA Database Schema Assets & Configuration Items

All 27 tables in the Assets & Configuration Items category. Table Type Columns Key ASSETFI...

Updated 1 month ago by Nate Smith

Assets & Configuration Items - Key Tables

HaloPSA Database Schema Assets & Configuration Items

Full column listings for the 4 key tables in this category. CONN (25 columns) # Column Type Le...

Updated 1 month ago by Nate Smith

Automation & Workflows - Table Index

HaloPSA Database Schema Automation & Workflows

All 28 tables in the Automation & Workflows category. Table Type Columns Key APPROVALPROCE...

Updated 1 month ago by Nate Smith

Automation & Workflows - Key Tables

HaloPSA Database Schema Automation & Workflows

Full column listings for the 5 key tables in this category. AUTOASSIGN (52 columns) # Column T...

Updated 1 month ago by Nate Smith

Items & Products - Table Index

HaloPSA Database Schema Items & Products

All 33 tables in the Items & Products category. Table Type Columns Key ITEM BASE TABLE 125...

Updated 1 month ago by Nate Smith

Items & Products - Key Tables

HaloPSA Database Schema Items & Products

Full column listings for the 2 key tables in this category. ITEM (125 columns) # Column Type L...

Updated 1 month ago by Nate Smith

Knowledge Base - Key Tables

HaloPSA Database Schema Knowledge Base

Full column listings for the 1 key table in this category. KBENTRY (318 columns) # Column Type...

Updated 1 month ago by Nate Smith

Supplier Orders & Purchasing - Table Index

HaloPSA Database Schema Supplier Orders & Purchasing

All 16 tables in the Supplier Orders & Purchasing category. Table Type Columns Key CONSIGN...

Updated 1 month ago by Nate Smith

Supplier Orders & Purchasing - Key Tables

HaloPSA Database Schema Supplier Orders & Purchasing

Full column listings for the 4 key tables in this category. ORDERHEAD (59 columns) # Column Ty...

Updated 1 month ago by Nate Smith