Coded variables use a value that has been set in your Herb software. Some coded variables indicate a status as true or false, for example:
|
Variable |
Description |
|---|---|
SALES_LEDGER.ACCOUNT_ON_HOLD |
This variable returns 1 if the account is on hold (true) or 0 if it is not (false). |
SALES_LEDGER.TERMS_AGREED |
This variable returns 1 if terms have been agreed on the account (true) and 0 if they haven't (false). |
Note: You can choose whether to display the coded (readable) variable or the value in your report. To do this, select the variable, then from the Properties pane, click the Display Named Values drop-down list and select Readable Value or Raw Value.
Some coded variables indicate a range of different statuses. For example, the SALES_LEDGER.STATUS_NUMBER variable indicates the customer record status:
| Number | Status |
|---|---|
| 0 | Open |
| 1 | See Notes |
| 2 | Closed (On Hold) |
| 3 | Liquidation (On Hold) |
| 4 | Expired Credit Limit (On Hold) |
| 5 | Exceeded Credit Limit (On Hold) |
| 6 | Bad Debt (On Hold) |
| 7 | Solicitors (On Hold) |
| 8 | New |
| 9 | Cash Only |
| 10 | Prospect |
| 11-99 | Blank status, set as required |