# transactionviewcompact

## Type: view

## Columns

| Column                 | Type     | Attributes | Description |
| ---------------------- | -------- | ---------- | ----------- |
| companyrowid           | int      |            |             |
| contactrowid           | int      |            |             |
| description            | varchar  |            |             |
| duedate                | datetime |            |             |
| isactive               | tinyint  |            |             |
| isinvoicepaid          | tinyint  |            |             |
| isposting              | tinyint  |            |             |
| isprint                | tinyint  |            |             |
| referencenbr           | varchar  |            |             |
| relationshipid         | varchar  |            |             |
| relationshiprowid      | int      |            |             |
| rowid                  | int      |            |             |
| salestagelistitemrowid | int      |            |             |
| totalamount            | decimal  |            |             |
| transactiondate        | date     |            |             |
| transactionid          | varchar  |            |             |
| transactionlinkrowid   | int      |            |             |
| transactiontypeid      | varchar  |            |             |
| transactiontyperowid   | int      |            |             |
| userrowid              | int      |            |             |

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