VatCategoryLineVatRatesById2: Visma.net Financials VAT Category Line VAT Rates by ID
read only REST
- Catalog:
VismaNet - Schema:
VatCategory - Label: VAT Category Line VAT Rates by ID
Get a specific VatCategory
Can only retrieve data.
API Source
- Endpoint:
/v1/vatCategory/{taxCategoryId} - Operation:
get /v1/vatCategory/{taxCategoryId}
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 155 |
| Full scan rows per minute | 29,100 |
| Point query rows per minute | 387 |
The result can be cached on the client.
Parameters
| Name | Data Type | Required | Default | Documentation |
|---|---|---|---|---|
tax |
`` | Identifies the VatCategory | ||
vendor |
`` | Optional vendor number (tax agency) parameter |
Table Columns
The columns of the table VatCategoryLineVatRatesById2 are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
COMPANY_ |
varchar2 |
Company Code | writable | Partition code, segmenting the data. | |
COMPANY_ |
varchar2 |
Company Name | writable | Name of the partition. | |
active |
char |
Active | filters on the platform, writable, ::ancestor. |
The top part > Active > A check box that means (if selected) that this VAT category is active. | |
calculate |
varchar2 |
itgen_vnet_calculateon | writable, ::ancestor. |
Calculate on > The way the VAT amount is calculated, which can be one of the following options: Extract from item amount, Document amount, Document and VAT amount. | |
cash |
varchar2 |
Cash Discount | writable, ::ancestor. |
Cash discount > The method of calculating the taxable amount if a discount is applied (based on the credit terms). It can be one of the following options: Reduce VAT amount, Does not affect VAT amount. | |
description |
varchar2 |
Description | writable, ::ancestor. |
Description > The detailed description of the VAT item. | |
description_ |
varchar2 |
Description 2 | filters on the platform, writable, ::ancestor. |
The top part > Description > A detailed description of the category. | |
exclude |
char |
itgen_vnet_excludelistedtaxes | filters on the platform, writable, ::ancestor. |
The top part > Exclude listed taxes > A check box that indicates (if selected) this VAT category should exclude the listed taxes from VAT zones. | |
group |
varchar2 |
Group Type | writable, group |
The type of the reporting group. | |
last |
datetime |
Last Modified | filters on the platform, writable, ::ancestor. |
Systemgenerated information. | |
revision |
varchar2 |
itgen_vnet_revisionid | writable, revision |
The revision ID of the VAT rate. | |
start |
datetime |
Start Date | writable, start |
The date and time from which the VAT rate is effective. | |
type |
varchar2 |
Type | writable, ::ancestor. |
VAT type > The type of VAT, which defines how it is processed. | |
vat |
varchar2 |
VAT Category ID | filters on the platform, writable, ::ancestor. |
Mandatory field: The top part > VAT category ID* > The unique ID of the VAT category. An alphanumeric string of up to six characters can be used. | |
vatId |
varchar2 |
VAT ID | writable, ::ancestor. |
Mandatory field: VAT ID* > The ID of the VAT included in the category. | |
vat |
double |
VAT Rate | writable, vat |
The VAT rate of the line. | |
vendor |
varchar2 |
itgen_vnet_vendorcd | writable, ::ancestor. |
Vendor code > The vendor number associated with the VAT category line. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: