Account group

The account group of tables provides access to database tables relating to individual debtors. Although there are many tables in this group, the most important tables include the account table itself - which lists all debtors - the account_balance table which lists the balance of each debtor, and the tx table which lists all transactions for all debtors.

Informational tables are identified with the information symbol:

Table name	Description
`account`	General account information.
`account_address`	Billing and/or street address details for an account holder in Smile.
`account_audit_log`	Audit log data for an account.
`account_balance`	Current balance (sum of all past invoices, payments, credit/debit notes, bonds, commissions, etc.) for a Smile account.
`account_contact`	Contact details for an account in Smile.
`account_cost_centre`	List of the cost centres configured against 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_purchase_order`	Purchase order codes belonging to a Smile account.
`account_terms`	Descriptions of available account terms that can be configured for accounts in Smile.
`account_type`	Configuration of account types.
`company`	Companies in a multi-tenanted Smile setup.
`crm_contact`	An audit or history of all of the changes and events related to a ticket.
`currency`	Configuration of currencies.
`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.
`operator`	Information about someone who has access to Smile.
`payment`	List of all payments, including payments which did not clear.
`payment_plan`	List of all payment plans.
`payment_plan_frequency_type`	List of possible payment plan frequencies.
`payment_plan_status`	List of possible payment plan statuses.
`payment_type`	A type of payment that can be selected when entering payment details.
`payment_type_processing_mode`	The mode of processing supported by a payment.
`recurring_charge`	A manual recurring charge against a subscription.
`subscription`	Header record for subscriptions.
`tax_schedule`	A header record for a schedule of tax schedule items.
`tax_schedule_item`	Defines the tax rules for a particular schedule at a particular time.
`timezone`	An enumeration of the time zones available to Smile.
`ticket`	All tickets and workflow instances.
`tx_item`	A line item existing on an itemised transaction, for example, an invoice line item or a deferred charge.