# transactiondetailviewoffset

## Type: view

## Columns

| Column                          | Type     | Attributes | Description |
| ------------------------------- | -------- | ---------- | ----------- |
| acconttypenormalbalance         | varchar  |            |             |
| acconttypereconciled            | smallint |            |             |
| acconttypesortorder             | smallint |            |             |
| acconttypestatement             | varchar  |            |             |
| acconttypetrialbalancesection   | varchar  |            |             |
| accountcategoryrowid            | int      |            |             |
| accountformatted                | varchar  |            |             |
| accountid                       | varchar  |            |             |
| accountname                     | varchar  |            |             |
| accountrowid                    | int      |            |             |
| accounttypedescription          | varchar  |            |             |
| accounttypeid                   | varchar  |            |             |
| accounttyperowid                | int      |            |             |
| amount                          | decimal  |            |             |
| amountdue                       | decimal  |            |             |
| amountduecurrency               | decimal  |            |             |
| amountreceived                  | decimal  |            |             |
| amountreceivedcurrency          | decimal  |            |             |
| box1099id                       | varchar  |            |             |
| box1099rowid                    | int      |            |             |
| classid                         | varchar  |            |             |
| classrowid                      | int      |            |             |
| companyrowid                    | int      |            |             |
| creditamount                    | decimal  |            |             |
| creditamountcurrency            | decimal  |            |             |
| debitamount                     | decimal  |            |             |
| debitamountcurrency             | decimal  |            |             |
| discountamount                  | decimal  |            |             |
| discountamountcurrency          | decimal  |            |             |
| displayorder                    | smallint |            |             |
| iscleared                       | tinyint  |            |             |
| isdiscount                      | tinyint  |            |             |
| ismemoline                      | tinyint  |            |             |
| issalestax                      | tinyint  |            |             |
| istaxable                       | tinyint  |            |             |
| istransactionoffset             | tinyint  |            |             |
| itemid                          | varchar  |            |             |
| itemrowid                       | int      |            |             |
| itemtypeid                      | varchar  |            |             |
| itemtypeuid                     | varchar  |            |             |
| jobid                           | varchar  |            |             |
| jobrowid                        | int      |            |             |
| lotserialnbr                    | varchar  |            |             |
| memo                            | varchar  |            |             |
| paymentmethodlistitemrowid      | int      |            |             |
| quantity                        | decimal  |            |             |
| quantityinvoiced                | decimal  |            |             |
| quantityreceived                | decimal  |            |             |
| quantityreturned                | decimal  |            |             |
| quantityshipped                 | decimal  |            |             |
| referencedate                   | datetime |            |             |
| referencenbr                    | varchar  |            |             |
| relationshipid                  | varchar  |            |             |
| relationshiprowid               | int      |            |             |
| retrievetimestamp               | date     |            |             |
| rowid                           | int      |            |             |
| transactioncategory             | varchar  |            |             |
| transactiondate                 | date     |            |             |
| transactiondescription          | varchar  |            |             |
| transactiondetaillinkrowid      | int      |            |             |
| transactiondiscountdate         | datetime |            |             |
| transactionduedate              | datetime |            |             |
| transactionid                   | varchar  |            |             |
| transactionisactive             | tinyint  |            |             |
| transactionisbillreceived       | tinyint  |            |             |
| transactioniscredithold         | tinyint  |            |             |
| transactioniscreditholdoverride | tinyint  |            |             |
| transactionisholdpayment        | tinyint  |            |             |
| transactionisinvoicepaid        | tinyint  |            |             |
| transactionisopeningbalance     | tinyint  |            |             |
| transactionisreverse            | tinyint  |            |             |
| transactionlinkrowid            | int      |            |             |
| transactionreferencenbr         | varchar  |            |             |
| transactionrelationshiprowid    | int      |            |             |
| transactionrowid                | int      |            |             |
| transactiontermrowid            | int      |            |             |
| transactiontotalamount          | decimal  |            |             |
| transactiontypeid               | varchar  |            |             |
| transactiontypeisposting        | tinyint  |            |             |
| unitcost                        | decimal  |            |             |
| unitid                          | varchar  |            |             |
| unitrate                        | decimal  |            |             |
| unitrowid                       | int      |            |             |

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