# transactionview

## Type: view

## Columns

| Column                   | Type     | Attributes | Description |
| ------------------------ | -------- | ---------- | ----------- |
| accountrowid             | int      |            |             |
| classrowid               | int      |            |             |
| companyrowid             | int      |            |             |
| contactrowid             | int      |            |             |
| creditamount             | decimal  |            |             |
| debitamount              | decimal  |            |             |
| description              | varchar  |            |             |
| discountdate             | datetime |            |             |
| duedate                  | datetime |            |             |
| emailmessagerowid        | int      |            |             |
| invoicedeliverymethodid  | varchar  |            |             |
| invoicedeliverymethoduid | varchar  |            |             |
| isactive                 | tinyint  |            |             |
| iscleared                | int      |            |             |
| isinvoicepaid            | tinyint  |            |             |
| isposting                | tinyint  |            |             |
| isprint                  | tinyint  |            |             |
| printscriptrowid         | int      |            |             |
| referencenbr             | varchar  |            |             |
| relationshipid           | varchar  |            |             |
| relationshiprowid        | int      |            |             |
| rowid                    | int      |            |             |
| salestaxgrouprowid       | int      |            |             |
| termrowid                | int      |            |             |
| totalamount              | decimal  |            |             |
| transactiondate          | date     |            |             |
| transactionid            | varchar  |            |             |
| transactionlinkrowid     | int      |            |             |
| transactiontypeid        | varchar  |            |             |
| transactiontyperowid     | int      |            |             |
| userrowid                | int      |            |             |

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