# VatTypes: Exact Online Domain VatTypes Lookup-table that translates code values of the domain 'VatTypes' into descriptions. - Catalog: `ExactOnlineREST` - Schema: `CodeValues` - Label: Domain VatTypes Example: The code value 'V' means 'Sales basis'. - Retrieve: True ## View Columns The columns of the view `VatTypes` 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 | |:---:|---| | `1` | Provision sales basis | | `2` | Provision sales VAT to pay | | `3` | Provision credit note sales basis | | `4` | Provision credit note sales VAT to claim | | `5` | Provision purchase basis | | `6` | Provision purchase VAT to claim | | `7` | Provision credit note purchase basis | | `8` | Provision credit note purchase VAT to pay | | `9` | Sales based on Cash system | | `A` | Sales VAT to pay | | `B` | Return sales invoice basis | | `C` | Return Sales invoice VAT to claim | | `D` | Credit note extra duty to claim / Return purchase invoice received VAT to claim | | `E` | Excluding / Provision for VAT margin: Sales basis | | `F` | Provision for VAT margin: Sales VAT to pay | | `G` | Provision for VAT margin: Sales basis for credit note | | `H` | Provision for VAT margin: Sales VAT to claim for credit note | | `I` | Purchase basis | | `J` | Provision for VAT margin: Purchase basis | | `K` | Provision for VAT margin: Purchase basis for credit note | | `L` | Purchase based on Cash system | | `M` | Credit note purchase non-deductible | | `N` | Purchase non-deductible | | `O` | Purchase VAT to claim | | `P` | Purchase VAT to pay | | `Q` | Credit note purchase VAT to claim | | `R` | Extra duty to pay | | `T` | Return purchase invoice received basis | | `U` | Return purchase invoice received VAT to pay | | `V` | Sales basis | | `W` | Credit note purchase basis | | `X` | Credit note sales basis | | `Y` | Credit note purchase VAT to pay | | `Z` | Credit note sales VAT to claim |