---
title: "OrderVatTotalsByType (Minox)"
description: "Order VAT Totals by Type"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/minox/Minox.Ordering.OrderVatTotalsByType
original: https://documentation.invantive.eu/en/datamodels/minox/Minox.Ordering.OrderVatTotalsByType
updated: 2026-11-01T16:19:41Z
license: https://documentation.invantive.eu/en/
---

# OrderVatTotalsByType: Minox Order VAT Totals by Type

`read only` `per partition` `REST`

- Catalog: `Minox`
- Schema: `Ordering`
- Label: Order VAT Totals by Type

Get a list of order documents by type.

The data in this table is partitioned per value of the `administration_code` column.

Can only retrieve data.

## API Source

- Endpoint: `/tenant/{tenant_id}/administration/{administration_id}/ordering/by_type/{type}`
- Operation: `get /tenant/{tenant_id}/administration/{administration_id}/ordering/by_type/{type}`

## Parameters

| Name | Data Type | Required | Default | Documentation |
|---|---|:---:|---|---|
| `administration_code` | `` | [ ] |  | Partition to retrieve data from. |
| `type` | `` | [x] |  | Values: concept, invoice, invoice_draft, quotation, orderresponse, packinglist, billoflading, subscription. |

## Table Columns

The columns of the table `OrderVatTotalsByType` 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 |
|---|---|---|:---:|---|---|
| `carrier_description` | `varchar2` | Carrier Description | [ ] | filters on the platform, writable, `::ancestor.carrier.description` |  |
| `carrier_id` | `int64` | Carrier ID | [ ] | filters on the platform, writable, `::ancestor.carrier.id` |  |
| `credit_restriction_percent` | `decimal` | Credit Restriction Percent | [ ] | filters on the platform, writable, `::ancestor.credit_restriction_percent` | The credit restriction percentage added over the total |
| `currency_description` | `varchar2` | Currency Description | [ ] | filters on the platform, writable, `::ancestor.currency.description` |  |
| `currency_id` | `varchar2` | Currency ID | [ ] | filters on the platform, writable, `::ancestor.currency.id` |  |
| `customer_city` | `varchar2` | Customer City | [ ] | filters on the platform, writable, `::ancestor.customer.city` |  |
| `customer_contact_name` | `varchar2` | Customer Contact Name | [ ] | filters on the platform, writable, `::ancestor.customer.contact_name` |  |
| `customer_country_code` | `varchar2` | Customer Country Code | [ ] | filters on the platform, writable, `::ancestor.customer.country_code` | An ISO-3166-1-alpha2 country code. See: https://en.wikipedia.org/wiki/ISO_3166-1_alpha-2#Officially_assigned_code_elements |
| `customer_id` | `decimal` | Customer ID | [ ] | filters on the platform, writable, `::ancestor.customer.id` |  |
| `customer_name` | `varchar2` | Customer Name | [ ] | filters on the platform, writable, `::ancestor.customer.name` |  |
| `customer_postal_code` | `varchar2` | Customer Postal Code | [ ] | filters on the platform, writable, `::ancestor.customer.postal_code` |  |
| `customer_salutation` | `varchar2` | Customer Salutation | [ ] | filters on the platform, writable, `::ancestor.customer.salutation` |  |
| `customer_streetname_and_number` | `varchar2` | Customer Street Name And Number | [ ] | filters on the platform, writable, `::ancestor.customer.streetname_and_number` |  |
| `customer_type_description` | `varchar2` | Customer Type Description | [ ] | filters on the platform, writable, `::ancestor.customer_type.description` |  |
| `customer_type_id` | `int64` | Customer Type ID | [ ] | filters on the platform, writable, `::ancestor.customer_type.id` |  |
| `delivery_address_city` | `varchar2` | Delivery Address City | [ ] | filters on the platform, writable, `::ancestor.delivery_address.city` |  |
| `delivery_address_contact_name` | `varchar2` | Delivery Address Contact Name | [ ] | filters on the platform, writable, `::ancestor.delivery_address.contact_name` |  |
| `delivery_address_country_code` | `varchar2` | Delivery Address Country Code | [ ] | filters on the platform, writable, `::ancestor.delivery_address.country_code` | An ISO-3166-1-alpha2 country code. See: https://en.wikipedia.org/wiki/ISO_3166-1_alpha-2#Officially_assigned_code_elements |
| `delivery_address_extended_name` | `varchar2` | Delivery Address Extended Name | [ ] | filters on the platform, writable, `::ancestor.delivery_address.extended_name` |  |
| `delivery_address_name` | `varchar2` | Delivery Address Name | [ ] | filters on the platform, writable, `::ancestor.delivery_address.name` |  |
| `delivery_address_postal_code` | `varchar2` | Delivery Address Postal Code | [ ] | filters on the platform, writable, `::ancestor.delivery_address.postal_code` |  |
| `delivery_address_streetname_and_number` | `varchar2` | Delivery Address Streetname and Number | [ ] | filters on the platform, writable, `::ancestor.delivery_address.streetname_and_number` |  |
| `delivery_date` | `varchar2` | Delivery Date | [ ] | filters on the platform, writable, `::ancestor.delivery_date` | The ISO date of the delivery (is set automatically when the document transitioned from the type billoflading) |
| `delivery_term_description` | `varchar2` | Delivery Term Description | [ ] | filters on the platform, writable, `::ancestor.delivery_term.description` |  |
| `delivery_term_id` | `int64` | Delivery Term ID | [ ] | filters on the platform, writable, `::ancestor.delivery_term.id` |  |
| `discount` | `decimal` | Discount | [ ] | writable, `discount` | The discount for the VAT percentage |
| `discount_percentage` | `decimal` | Discount Percentage | [ ] | filters on the platform, writable, `::ancestor.discount_percentage` | The discount percentage calculated over the entire order document |
| `document_number` | `decimal` | Document Number | [ ] | filters on the platform, writable, `::ancestor.document_number` | The number given when an order document of type orderresponse, packinglist or billoflading is transitioned |
| `frequence` | `varchar2` | Frequence | [ ] | filters on the platform, writable, `::ancestor.frequence` |  |
| `id` | `varchar2` | ID | [ ] | filters on the platform, writable, `::ancestor.id` |  |
| `inclusive_amount` | `decimal` | Inclusive Amount | [ ] | writable, `inclusive_amount` | The amount with the vat amount (filled if vat_inclusive is true) |
| `invoice_date` | `varchar2` | Invoice Date | [ ] | filters on the platform, writable, `::ancestor.invoice_date` | The ISO date for when the document transitioned to the type invoice |
| `invoice_number` | `decimal` | Invoice Number | [ ] | filters on the platform, writable, `::ancestor.invoice_number` | The number given when an order document is transitioned to the invoice type |
| `is_g_account` | `char` | Is G-Account | [ ] | filters on the platform, writable, `::ancestor.is_g_account` |  |
| `is_merge` | `char` | Is Merge | [ ] | filters on the platform, writable, `::ancestor.is_merge` | If the order document has been created by merging multiple order documents |
| `mandate_code` | `varchar2` | Mandate Code | [ ] | filters on the platform, writable, `::ancestor.mandate.code` |  |
| `mandate_date` | `varchar2` | Mandate Date | [ ] | filters on the platform, writable, `::ancestor.mandate_date` | The ISO date calculated based on the invoice date and the mandate_date |
| `mandate_serial_number` | `decimal` | Mandate Serial Number | [ ] | filters on the platform, writable, `::ancestor.mandate.serial_number` |  |
| `memo` | `varchar2` | Memo | [ ] | filters on the platform, writable, `::ancestor.memo` |  |
| `next_invoice_date` | `varchar2` | Next Invoice Date | [ ] | filters on the platform, writable, `::ancestor.next_invoice_date` | The ISO date for when the document last transitioned from type subscription to the type invoice |
| `orderresponse_date` | `varchar2` | Orderresponse Date | [ ] | filters on the platform, writable, `::ancestor.orderresponse_date` | The ISO date for when the document transitioned from the type orderresponse |
| `packinglist_date` | `varchar2` | Packinglist Date | [ ] | filters on the platform, writable, `::ancestor.packinglist_date` | The ISO date for when the document transitioned from the type packinglist |
| `payment_discount_percent` | `decimal` | Payment Discount Percent | [ ] | filters on the platform, writable, `::ancestor.payment_discount_percent` | The payment discount percentage subtracted over the total |
| `payment_term_days` | `decimal` | Payment Term Days | [ ] | filters on the platform, writable, `::ancestor.payment_term.days` |  |
| `payment_term_description` | `varchar2` | Payment Term Description | [ ] | filters on the platform, writable, `::ancestor.payment_term.description` |  |
| `payment_term_id` | `int64` | Payment Term ID | [ ] | filters on the platform, writable, `::ancestor.payment_term.id` |  |
| `payment_term_mandate` | `varchar2` | Payment Term Mandate | [ ] | filters on the platform, writable, `::ancestor.payment_term.mandate` |  |
| `payment_term_start` | `varchar2` | Payment Term Start | [ ] | filters on the platform, writable, `::ancestor.payment_term.start` |  |
| `percentage` | `decimal` | Percentage | [ ] | writable, `percentage` | The VAT percentage |
| `period_number` | `decimal` | Period Number | [ ] | filters on the platform, writable, `::ancestor.period_number` | The period in which the invoice belongs |
| `previous_type` | `varchar2` | Previous Type | [ ] | filters on the platform, writable, `::ancestor.previous_type` |  |
| `quotation_date` | `varchar2` | Quotation Date | [ ] | filters on the platform, writable, `::ancestor.quotation_date` | The ISO date for when the document transitioned from the type quotation |
| `quotation_number` | `decimal` | Quotation Number | [ ] | filters on the platform, writable, `::ancestor.quotation_number` | The number given when an order document of type quotation is transitioned |
| `reference` | `varchar2` | Reference | [ ] | filters on the platform, writable, `::ancestor.reference` |  |
| `region_description` | `varchar2` | Region Description | [ ] | filters on the platform, writable, `::ancestor.region.description` |  |
| `region_id` | `int64` | Region ID | [ ] | filters on the platform, writable, `::ancestor.region.id` |  |
| `representative_id` | `int64` | Representative ID | [ ] | filters on the platform, writable, `::ancestor.representative.id` |  |
| `representative_name` | `varchar2` | Representative Name | [ ] | filters on the platform, writable, `::ancestor.representative.name` |  |
| `state_date` | `varchar2` | State Date | [ ] | filters on the platform, writable, `::ancestor.state_date` | The ISO date for when the last transition happened |
| `subscription_date` | `varchar2` | Subscription Date | [ ] | filters on the platform, writable, `::ancestor.subscription_date` | The ISO date for when the document transitioned from the type subscription |
| `subscription_end_date` | `varchar2` | Subscription End Date | [ ] | filters on the platform, writable, `::ancestor.subscription_end_date` | The ISO date for when the subscription ends |
| `subscription_number` | `decimal` | Subscription Number | [ ] | filters on the platform, writable, `::ancestor.subscription_number` | The number given when an order document of type subscription is transitioned |
| `tax_amount` | `decimal` | Tax Amount | [ ] | writable, `tax_amount` | The VAT amount |
| `taxable_amount` | `decimal` | Taxable Amount | [ ] | writable, `taxable_amount` | The amount without VAT |
| `totals_amount` | `decimal` | Totals Amount | [ ] | filters on the platform, writable, `::ancestor.totals.amount` | The total amount (before discounts and VAT) |
| `totals_credit_restriction` | `decimal` | Totals Credit Restriction | [ ] | filters on the platform, writable, `::ancestor.totals.credit_restriction` | The credit restriction |
| `totals_delivery_quantity` | `decimal` | Totals Delivery Quantity | [ ] | filters on the platform, writable, `::ancestor.totals.delivery_quantity` | The total amount of items delivered |
| `totals_discount` | `decimal` | Totals Discount | [ ] | filters on the platform, writable, `::ancestor.totals.discount` | The total discount |
| `totals_payment_discount` | `decimal` | Totals Payment Discount | [ ] | filters on the platform, writable, `::ancestor.totals.payment_discount` | The payment discount |
| `totals_quantity` | `decimal` | Totals Quantity | [ ] | filters on the platform, writable, `::ancestor.totals.quantity` | The total amount of items |
| `totals_total` | `decimal` | Totals Total | [ ] | filters on the platform, writable, `::ancestor.totals.total` | The total amount with discounts and VAT |
| `type` | `varchar2` | Type | [ ] | filters on the platform, writable, `::ancestor.type` |  |
| `vat_id` | `int64` | VAT ID | [ ] | writable, `vat_id` | The internal VAT identifier |
| `vat_inclusive` | `char` | VAT Inclusive | [ ] | filters on the platform, writable, `::ancestor.vat_inclusive` | Whether the VAT amounts are included in the amounts |
| `vat_reverse_charged` | `char` | VAT Reverse Charged | [ ] | filters on the platform, writable, `::ancestor.vat_reverse_charged` | Whether the VAT amounts are reverse charged |



## Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver:

- [Minox](/en/release-notes/drivers?driver=minox)

### Changes of This Table, 26.0 to 27.0

<a id="MNX-27.0-D221"></a><a id="MNX-27.0-D222"></a>

- `-` `administration_code`
- `-` `administration_name`

[All changes of the driver, 26.0 to 27.0](/en/release-notes/drivers?driver=minox&step=26.0-to-27.0#minox-26.0-to-27.0)

