Company group

The company group of tables provide access to database tables relating to company configuration.

Informational tables are identified with the information symbol:

Table name Description
access_server Each row describes a Network Access Server (NAS) that Smile knows about.
account General account information.
account_audit_log Audit log data for an account.
account_disposition Configuration list of possible account (and transaction) dispositions or credit control treatment levels.
account_payment_configuration Stores the stored (automatic) payment details for accounts.
account_payment_option Configuration of possible automatic payment configurations.
account_terms Descriptions of available account terms that can be configured for accounts in Smile.
account_type Configuration of account types.
contract Available contracts that accounts can enter into when ordering or renewing a subscription.
crm_contact An audit or history of all of the changes and events related to a ticket.
crm_contact_type An enumeration table listing the different kinds of crm_contact entry defined by Smile.
currency Configuration of currencies.
destination Represents the, usually geographical, classification of an endpoint of an XDR for charging purposes.
discount List of possible discounts that may be applied to accounts and subscriptions.
line_item Configuration of line items that can be added to invoices.
office Represents a location at which an operator could have done something.
payment List of all payments, including payments which did not clear.
payment_plan List of all payment plans.
payment_type A type of payment that can be selected when entering payment details.
plan Represents a plan, which is a header record for rating rules, recurring charges and more.
plan_option Options that may be chosen for subscriptions on a particular plan.
plan_option_group A group of "One of many" plan options.
policy_group A grouping of policies (features) which are mutually exclusive.
policy_type A type of policy (feature) that could be applied to a subscription.
prepaid_priority A header record for grouping prepaid block types.
prepaid_type A block of prepaid that can be added to a subscription.
prepaid_voucher Represents a single prepaid voucher.
prepaid_voucher_batch A header record for a batch of prepaid vouchers.
prepaid_voucher_type A type of prepaid voucher that can be instantiated into actual vouchers.
rating_period Header records for rating periods, which represent periods which usage is bound to and rated against.
recurring_charge A manual recurring charge against a subscription.
reporting_account List of reporting accounts, otherwise known as sales report categories, used for grouping transactions and line items for financial reporting.
service Contains the basic configuration for the different kinds of services. Subscriptions can be considered instances of services.
subscription Header record for subscriptions.
subscription_audit_log A record of changes made to a subscription.
subscription_contract Records details of a contract that the subscription is, was or will be bound to.
subscription_plan Maps a subscription to its current plan.
subscription_prepaid Prepaid block added to subscriptions.
subscription_rating_status Shows the status of each RTR subscription with respect to rerates.
tariff Description of how matching CDRs will be rated.
tariff_type A categorisation of CDRs.
tax_schedule A header record for a schedule of tax schedule items.
ticket All tickets and workflow instances.
timesheet A record of time spent by an operator on a particular ticket.
tx Represents a financial transaction on an account.
tx_aged A description of the age of a (debit) transaction with respect to being fully balanced by a credit transaction.
tx_detail A header record for itemised transactions such as invoices.
tx_disposition List of possible dispositions or treatment levels of a transaction.
tx_item A line item existing on an itemised transaction, for example, an invoice line item or a deferred charge.