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