account_disposition

Configuration list of possible account (and transaction) dispositions or credit control treatment levels.

Column name Description Data type
account_disposition Primary key. integer
company The company configuration ID.

Reference to company.

integer
name The account disposition name. text

Smile monitors invoices to ensure that they are paid. If an invoice becomes overdue, Smile keeps track of this by setting a value against the account to indicate how overdue the invoice (or invoices) has become. This overdue status field is called the account disposition.

Smile may take specific actions when it detects that the account’s disposition has changed. For example, if the disposition changes from Settled to Overdue, Smile might send a reminder to the customer.

Account dispositions can be configured by operators.

The following example shows the name, account balance and disposition status for all accounts in Smile:

SELECT usn(account), cf(account, 'contactNameFamily') AS "family name", cf(account, 'contactNameGiven') AS "given name", name AS "status", balance FROM account JOIN account_balance USING (account) LEFT JOIN account_disposition using (account_disposition);

   usn     |  family name  |  given name   |   status   |   balance
-----------+---------------+---------------+------------+-----------
2142420872 | Bush          | George        | Settled    |    900.00
2142421037 | Bush          | George W      | Settled    |    900.00
2142420898 | Fraser        | Malcolm       | Settled    |    900.00
2142420914 | Clinton       | Bill          | Delinquent |    825.00