Military customers
ChasityD
Registered User ✭✭
Comments
-
@ChasityD - We do not currently have a report showing all military customers. However, you can try this query in the "Custom Reporting" screen and it may help you to find active tenants flagged as military:
Select T.*
From Tenants T
join MktgType M on T.MktgTypeID = M.MktgTypeID and T.siteID = M.siteID
Where
(
Select Count(L.LedgerID)
From Ledgers L
Inner Join Access A On L.LedgerID = A.LedgerID
Where A.TenantID = T.TenantID
And L.dMovedOut Is Null
And L.dDeleted Is Null
) >= 1
and m.sdefmktgtypedesc = 'Military' (edited)
0 -
If you offer a military discount you pull up the discount reports2
Categories
- All Categories
- 34 What's New
- 30 SiteLink: What's new
- 4 Storable Payments: What's new
- SiteLink Community Discussions
- 1.9K SiteLink General Discussions
- 94 SiteLink myHub
- 55 Lead to Lease
- 27 Price Optimization
- 38 SiteLink Certified Professional
- 262 How-To's
- 11 Gate setup and Access Control
- 6 Email setup and troubleshooting
- 2 Software Setup
- 2 Unit Setup
- 11 Basic Operations FAQs
- 14 Advanced Operations FAQs
- 18 Billing and Accounting
- 5 Troubleshooting
- 6 Reports
- 21 Storable Payments
- 98 Training Videos
- 6 Other Resources
- 61 SiteLink, SpareFoot & storEDGE merge
- Self-Storage Operations
- 72 Starting Out in Self-Storage
- 3 3rd Party Management
- 219 Regional Discussions
- 182 Miscellaneous Discussions
- 38 Industry Webinars
- SiteLink Marketplace
- 62 Self-Storage Website Design & Listing Services
- 31 Credit Cards & Payment Processing
- 32 Self-Storage Call Centers & Kiosks
- 48 Notifications, SMS & Phone Integrations
- 92 Self-Storage Insurance, Legal & Auctions
- 11 Self-Storage Revenue Management & Analytics
- 21 Gates & Access for Self-Storage Facilities
- 7 Ancillary Services for Self-Storage Facilites
- Self-Storage Times
- 64 News
- 31 Opinion
- 149 Lifestyle