Creating a Database View

LogiSense Billing has number of out-of-the-box views which can be leveraged for creating data sources. Our philosophy is to provide you with a lot of columns at the view level which can then be pared down at the data source and ultimately sorted and filtered by the report according to your business needs. LogiSense will work with you to create custom views.

Please find a list of commonly used views below:

View	Description

View	Description
Statement of Account	Transactional and invoice summary
Usage	Individual rated usage event details
Invoice Summary	Details grouped by invoice
Sales	A list of all transactional line items
Product Catalog	Details of all offerings
Account	List all accounts with subscriptions and contacts
Data Allowance	Usage allowance by account and bucket/share plan
Account Contract	Contract details grouped by account
Tax	Lists all taxed amounts with account and tax category details
Accounting Export	Transaction level detail to be imported by financial system
Payments and Credits	Lists payment and disbursement details grouped by account
Aged Balance	Lists balance due by account and days late