TAG LINE
SMALL TITLE

Creating a Database View

Last Updated: Oct 02, 2020

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

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