Which table/column is Power in in the data mining tool?
ChrisRobinson
Registered User ✭
I need to write a query grabbing all the units which should have power, but for the life of me I can't figure out where this is stored.
Tagged:
0
Answers
-
Hi Chris,
Faster to check in the report -> Rentroll - column "bPower", but if you need it for SQL then table "Units" - column "bPower".
Cheers0 -
we charge extra for power, I need to see a list of people who are paying. If I'm not mistaken Units.bPower just lists units with power hookups0
-
Go into company>Utilities>Inspect charges (upper left) use the drop down menu by "Charge Description" to locate the correct charge "power", "electricity" and it will give you all tenants that had the charge applied this month. Or if anniversary billing, change the start date to 30 or 31 days prior.2
-
Hi @ChrisRobinson - You can use the Recurring Charges report filtered to the type of charge you want to see. Check out the screenshot below. If you have more questions, please don't hesitate to reach out to our support team at 919-865-0789, Option 2.
0
Categories
- All Categories
- 2 What's New
- SiteLink Community Discussions
- 1.9K SiteLink General Discussions
- 80 SiteLink myHub
- 48 Lead to Lease
- 15 Price Optimization
- 36 SiteLink Certified Professional
- 187 How-To's
- 97 Training Videos
- 7 Other Resources
- 81 SiteLink, SpareFoot & storEDGE merge
- Self-Storage Operations
- 65 Starting Out in Self-Storage
- 3 3rd Party Management
- 224 Regional Discussions
- 189 Miscellaneous Discussions
- 39 Industry Webinars
- SiteLink Marketplace
- 62 Self-Storage Website Design & Listing Services
- 32 Credit Cards & Payment Processing
- 31 Self-Storage Call Centers & Kiosks
- 46 Notifications, SMS & Phone Integrations
- 94 Self-Storage Insurance, Legal & Auctions
- 11 Self-Storage Revenue Management & Analytics
- 24 Gates & Access for Self-Storage Facilities
- 12 Ancillary Services for Self-Storage Facilites
- Self-Storage Times
- 62 News
- 30 Opinion
- 147 Lifestyle