# openbillview

## Type: view

## Columns

| Column                       | Type     | Attributes | Description |
| ---------------------------- | -------- | ---------- | ----------- |
| amountpaid                   | decimal  |            |             |
| classid                      | varchar  |            |             |
| discountamount               | decimal  |            |             |
| iscleared                    | tinyint  |            |             |
| referencenbr                 | varchar  |            |             |
| relationshipid               | varchar  |            |             |
| relationshiprowid            | int      |            |             |
| rowid                        | int      |            |             |
| transactiondate              | date     |            |             |
| transactiondescription       | varchar  |            |             |
| transactiondiscountdate      | datetime |            |             |
| transactionduedate           | datetime |            |             |
| transactionid                | varchar  |            |             |
| transactionlinkrowid         | int      |            |             |
| transactionrelationshipid    | varchar  |            |             |
| transactionrelationshiprowid | int      |            |             |
| transactionrowid             | int      |            |             |
| transactiontermrowid         | int      |            |             |
| transactiontotalamount       | decimal  |            |             |
| transactiontypeid            | varchar  |            |             |

v.ismain -- Wed, Feb 28, 2018 2:58 PM