Advanced Search
Search Results
139 total results found
Actions (Ticket Notes) - Key Tables
Full column listings for the 3 key tables in this category. ACTARC (68 columns) # Column Type Length Nullable Default 1 Faultid int NO 2 actionnumber int NO 3 Actoutcome nvarchar 4000 YES 4 who nvarchar 4000 YES 5 Whe_ datetime YES 6 n...
Actions (Ticket Notes) - Table Index
All 7 tables in the Actions (Ticket Notes) category. Table Type Columns Key ACT BASE TABLE 5 ACTARC BASE TABLE 68 KEY ACTIONS BASE TABLE 199 KEY ACTYPE BASE TABLE 11 KEY ActionReaction BASE TABLE 5 ActionRead BASE TABLE 4 Action_View VIEW...
Tickets (Faults) - Key Tables
Full column listings for the 13 key tables in this category. FAULTAPPROVAL (30 columns) # Column Type Length Nullable Default 1 FAid int NO 2 FAseq int NO 3 FAActionNumber int YES ((0)) 4 FAEmailstatus int YES ((0)) 5 FAResult int YES ((0...
Invoicing & Billing - Key Tables
Full column listings for the 5 key tables in this category. CHARGERATE (27 columns) # Column Type Length Nullable Default 1 CRid int NO 2 CRarea int NO 3 CRchargeid int NO 4 CRstartdate datetime NO 5 CRrate float YES ((0)) 6 CRorg int...
Invoicing & Billing - Table Index
All 40 tables in the Invoicing & Billing category. Table Type Columns Key ACCOUNTSINTERFACE BASE TABLE 19 BILLINGREPORT BASE TABLE 21 BillingAudit BASE TABLE 5 BillingPlanCriteria BASE TABLE 10 CHARGECD BASE TABLE 3 CHARGERATE BASE TABLE ...
Clients & Sites - Key Tables
Full column listings for the 5 key tables in this category. AREA (332 columns) # Column Type Length Nullable Default 1 Aarea int NO 2 aareadesc nvarchar 4000 YES 3 Amemo ntext 1073741823 YES 4 Aannounce ntext 1073741823 YES 5 Aannouncedate ...
Ticket Configuration - Key Tables
Full column listings for the 7 key tables in this category. CATEGORYDETAIL (14 columns) # Column Type Length Nullable Default 1 CDid int NO 2 CDCategoryName nvarchar 4000 YES ('') 3 CDType int YES ((0)) 4 CDSLAid int YES ((-1)) 5 CDseriousne...
Custom Fields & Configuration - Key Tables
Full column listings for the 3 key tables in this category. CONTROL (808 columns) # Column Type Length Nullable Default 1 Rseq int NO 2 RDBVersion int YES ((0)) 3 RDBname nvarchar 8 YES 4 RShbitmaps bit NO ((0)) 5 RShMap bit NO ((0)) 6 R...
2026 DIA Annual Conference - Nashville
Overview Event: DIA (Dental Integrators Association) Annual Conference Dates: April 16-18, 2026 Venue: Margaritaville Hotel, Nashville, TN Room: Seagrass Room (main sessions) / Fins Up - Poolside (reception) / Porch of Indecision (meals) Timezone: Central (Ame...
Understanding portal statuses
Every invoice, quote, deposit, and ticket in the portal shows a status badge. These badges tell you where things stand at a glance — and which ones, if any, need your attention. Invoice statuses Invoices appear in the Billing section under the Invoices tab. ...
2026 DIA Mid-Year - Boston
Overview Event: DIA (Dental Integrators Association) Mid-Year Meeting Dates: October 6-8, 2026 Location: Boston, MA Venue: TBD (watch for announcement) Timezone: Eastern (America/New_York) Announced in the post-event communication following the April 2026 Annu...
Setting Up Your Portal Account
This page covers everything you need to get started with the DTC Client Portal — whether you're brand new to DTC, you've been a DTC contact for a while and are setting up portal access for the first time, or you just need to reset your password. Access the por...
HaloPSA REST API v2 — Swagger Spec
Live OpenAPI 3.0.1 spec for the HaloPSA REST API v2. 952 paths, 760 schemas. Use this as the authoritative field-level reference when the endpoint pages in this book don't carry enough detail. Spec Location Path Live URL https://dtcdev.halopsa.com/api...