# TransactionTypes: Exact Online Domain TransactionTypes
Lookup-table that translates code values of the domain 'TransactionTypes' into descriptions.
- Catalog: `ExactOnlineREST`
- Schema: `CodeValues`
- Label: Domain TransactionTypes
Example: The code value '10' means 'Opening balance'.
- Retrieve: True
## View Columns
The columns of the view `TransactionTypes` are shown below. Each column has an SQL data type.
| Name | Data Type | Label | Required | Documentation |
|---|:---:|---|:---:|---|
| `code` | `varchar2`(240) | Code | ☑ | Unique code within the domain. |
| `description` | `varchar2`(4000) | Description | ☐ | Meaning of the unique code within the domain. |
| `domain` | `varchar2`(240) | Domain | ☑ | Each domain defines a map of codes to values. |
| `resource_code` | `varchar2`(240) | Resource Code | ☐ | Resource code for internationalization. |
## Values
| Code | Description |
|:---:|---|
| `10` | Opening balance |
| `120` | Fulfillment |
| `121` | Return fulfillment |
| `130` | Receipt |
| `131` | Purchase return |
| `140` | Shop order stock receipt |
| `141` | Shop order stock reversal |
| `142` | Issue to parent |
| `145` | Shop order time entry |
| `146` | Shop order time entry reversal |
| `147` | Shop order by-product receipt |
| `148` | Shop order by-product reversal |
| `150` | Requirement issue |
| `151` | Requirement reversal |
| `152` | Returned from parent |
| `155` | Subcontract Issue |
| `156` | Subcontract reversal |
| `158` | Shop order completed |
| `159` | Shop order uncompleted |
| `162` | Finished assembly |
| `170` | Payroll |
| `180` | Stock revaluation |
| `181` | Financial revaluation |
| `195` | Stock count |
| `20` | Sales entry |
| `21` | Sales credit note |
| `22` | Return invoice |
| `290` | Correction entry |
| `30` | Purchase entry |
| `3000` | Budget |
| `31` | Purchase credit note |
| `310` | Period closing |
| `32` | Return invoice |
| `320` | Year end reflection |
| `321` | Year end costing |
| `322` | Year end profits to gross profit |
| `323` | Year end costs to gross profit |
| `324` | Year end tax |
| `325` | Year end gross profit to net p/l |
| `326` | Year end net p/l to balance sheet |
| `327` | Year end closing balance |
| `328` | Year start opening balance |
| `40` | Cash flow |
| `50` | VAT return |
| `70` | Asset depreciation |
| `71` | Asset investment |
| `72` | Asset revaluation |
| `73` | Asset transfer |
| `74` | Asset split |
| `75` | Asset discontinue |
| `76` | Asset sales |
| `80` | Revaluation |
| `82` | Exchange rate difference |
| `83` | Payment difference |
| `84` | Deferred revenue |
| `85` | Tracking number |
| `86` | Deferred cost |
| `87` | VAT on prepayment |
| `90` | Other |
| `91` | Audit file |