# rdw_vehicles_by_tag: RDW Vehicles by Tag - Catalog: `RDW` - Schema: `RDW` - Primary Keys: `id` - Label: Vehicles by Tag This is a read-only table function. The RDW API may not support changing the data or the Invantive UniversalSQL driver for RDW does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the RDW API. ## Parameters of Table Function The following parameters can be used to control the behaviour of the table function `rdw_vehicles_by_tag`. A value must be provided at all times for required parameters, but optional parameters in general do not need to have a value and the execution will default to a pre-defined behaviour. Values can be specified by position and by name. In both cases, all parameters not specified will be evaluated using their default values. Value specification by position is done by listing all values from the first to the last needed value. For example: a `select * from table(value1, value2, value3)` on a table with four parameters will use the default value for the fourth parameter and the specified values for the first three. Value specification by name is done by listing all values that require a value. For example with `select * from table(name1 => value1, name3 => value3)` on the same table will use the default values for the second and fourth parameters and the specified values for the first and third. | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `Kenteken` | `` | ☑ | | | ## Columns of Table Function The columns of the table function `rdw_vehicles_by_tag` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `additional_mass_alternative_drive` | `decimal` | | ☐ | | | `aerodynamic_feature` | `varchar2` | Aerodynamic Feature | ☐ | | | `api_licensed_vehicle_axles` | `varchar2` | API Licensed Vehicle Axles | ☐ | | | `api_licensed_vehicle_chassis_specific` | `varchar2` | API Licensed Vehicle Chassis Specific | ☐ | | | `api_licensed_vehicle_chassis` | `varchar2` | API Licensed Vehicle Chassis | ☐ | | | `api_licensed_vehicle_class` | `varchar2` | API Licensed Vehicle Class | ☐ | | | `api_licensed_vehicle_fuel` | `varchar2` | API Licensed Vehicle Fuel | ☐ | | | `average_load_value` | `varchar2` | Average Load Value | ☐ | | | `brake_system_type_code` | `varchar2` | | ☐ | | | `brand` | `varchar2` | Brand | ☐ | | | `can_register_ownership` | `varchar2` | Can Register Ownership | ☐ | | | `catalogue_price` | `decimal` | Catalogue Price | ☐ | | | `cilinder_volume_wrong` | `varchar2` | Cylinder Volume Wrong | ☐ | | | `cilinder_volume` | `decimal` | Cylinder Volume | ☐ | | | `code_explanation_counter_reading_judgement` | `varchar2` | Code Explanation Counter Reading Judgement | ☐ | | | `counter_reading_judgement` | `varchar2` | Counter Reading Judgement | ☐ | | | `date_admittance` | `datetime` | Date Admittance | ☐ | | | `date_ascription` | `datetime` | Date Ascription | ☐ | | | `date_expiry_apk_txt` | `varchar2` | Date Expiry APK Text | ☐ | | | `date_expiry_apk` | `datetime` | Date Expiry APK | ☐ | | | `date_expiry_tachograph_txt` | `varchar2` | Date Expiry Tachograph Text | ☐ | | | `date_expiry_tachograph` | `datetime` | Date Expiry Tachograph | ☐ | | | `date_first_admission` | `datetime` | First Admission | ☐ | | | `date_first_admittance` | `datetime` | Date First Admittance | ☐ | | | `date_first_registration_txt` | `varchar2` | Date First Registration Text | ☐ | | | `date_first_registration` | `datetime` | Date First Registration | ☐ | | | `date_registration_approval_depreciation_moment_bpm_txt` | `varchar2` | Date Registration Approval Depreciation Moment Bpm Text | ☐ | | | `date_registration_approval_depreciation_moment_bpm` | `datetime` | Date Registration Approval Depreciation Moment Bpm | ☐ | | | `designation_number` | `varchar2` | | ☐ | | | `deviating_maximum_speed` | `decimal` | | ☐ | | | `distance_front_to_stick_shift` | `decimal` | Distance Front to Stick Shift | ☐ | | | `distance_stick_shift_to_back` | `decimal` | Distance Stick Shift to Back | ☐ | | | `economy_classification` | `varchar2` | Economy Classification | ☐ | | | `edition` | `varchar2` | Edition | ☐ | | | `empty_vehicle_weight` | `decimal` | Empty Vehicle Weight | ☐ | | | `eu_approval_number_change` | `varchar2` | EU Approval Number Change | ☐ | | | `european_release_category` | `varchar2` | European Release Category | ☐ | | | `european_vehicle_category_add` | `varchar2` | European Vehicle Category Add | ☐ | | | `european_vehicle_category` | `varchar2` | European Vehicle Category | ☐ | | | `export_indicator` | `varchar2` | Export Indicator | ☐ | | | `extended_cabin_indicator` | `varchar2` | | ☐ | | | `first_color` | `varchar2` | First Colour | ☐ | | | `gas_installation_type` | `varchar2` | Gas Installation Type | ☐ | | | `height_maximum` | `decimal` | | ☐ | | | `height_minimum` | `decimal` | | ☐ | | | `height` | `decimal` | Height | ☐ | | | `id` | `varchar2` | ID | ☐ | | | `interior` | `varchar2` | Interior | ☐ | | | `kerb_weight` | `decimal` | Kerb Weight | ☐ | | | `length_maximum` | `decimal` | | ☐ | | | `length_minimum` | `decimal` | | ☐ | | | `length` | `decimal` | Length | ☐ | | | `license_plate` | `varchar2` | License Plate | ☐ | | | `load_capacity` | `decimal` | Load Capacity | ☐ | | | `location_chassis_number` | `varchar2` | Location Chassis Number | ☐ | | | `max_weight_vehicle` | `decimal` | Maximum Weight Vehicle | ☐ | | | `maximum_construction_speed` | `decimal` | Maximum Construction Speed | ☐ | | | `maximum_load_under_front_axles_combined_coupling` | `decimal` | Maximum Load Under Front Axles Combined Coupling | ☐ | | | `maximum_mass_composed` | `decimal` | Maximum Mass Composed | ☐ | | | `maximum_mass_pull_breaked` | `decimal` | Maximum Mass Pull Braked | ☐ | | | `maximum_mass_pull_unbreaked` | `decimal` | Maximum Mass Pull Unbraked | ☐ | | | `maximum_mass_technical_maximum` | `decimal` | | ☐ | | | `maximum_mass_technical_minimum` | `decimal` | | ☐ | | | `maximum_supported_speed` | `decimal` | Maximum Supported Speed | ☐ | | | `number_of_cilinders_wrong` | `varchar2` | Number of Cylinders Wrong | ☐ | | | `number_of_cilinders` | `decimal` | Number of Cilinders | ☐ | | | `number_of_doors` | `decimal` | Number of Doors | ☐ | | | `number_of_wheels` | `decimal` | Number of Wheels | ☐ | | | `open_recall_indication` | `varchar2` | Open Recall Indication | ☐ | | | `operational_mass_maximum` | `decimal` | | ☐ | | | `operational_mass_minimum` | `decimal` | | ☐ | | | `passenger_seats_count_legal` | `decimal` | | ☐ | | | `permitted_maximum_vehicle_mass` | `decimal` | Permitted Maximum Vehicle Mass | ☐ | | | `power_per_kilo_curb` | `varchar2` | Power per Kilo/Curb | ☐ | | | `seats_count` | `decimal` | Seats Count | ☐ | | | `second_color` | `varchar2` | Second Colour | ☐ | | | `standing_places_count` | `decimal` | | ☐ | | | `subcategory_netherlands` | `varchar2` | | ☐ | | | `tax` | `decimal` | Tax | ☐ | | | `taxi_indicator` | `varchar2` | | ☐ | | | `technically_permitted_mass_coupling_point` | `decimal` | | ☐ | | | `track_undercarriage_configuration_code` | `varchar2` | | ☐ | | | `trade_name` | `varchar2` | Trade Name | ☐ | | | `trailer_autonomous_braked` | `varchar2` | Trailer Autonomous Braked | ☐ | | | `trailer_braked` | `varchar2` | Trailer Braked | ☐ | | | `trailer_centre_axle_braked` | `decimal` | Trailer Centre Axle Braked | ☐ | | | `type_approval_number` | `varchar2` | Type Approval Number | ☐ | | | `type` | `varchar2` | Type | ☐ | | | `variant` | `varchar2` | License Variant | ☐ | | | `vehicle_type` | `varchar2` | Vehicle Type | ☐ | | | `vertical_load_coupling_point_towed_vehicle` | `decimal` | Vertical Load Coupling Point to Wed Vehicle | ☐ | | | `waiting_for_approval` | `varchar2` | Waiting for Approval | ☐ | | | `wam_insured` | `varchar2` | WAM Insured | ☐ | | | `wheelbase_maximum` | `decimal` | | ☐ | | | `wheelbase_minimum` | `decimal` | | ☐ | | | `wheelbase` | `decimal` | Wheelbase | ☐ | | | `wheelchair_places_count` | `decimal` | Wheel Chair Places Count | ☐ | | | `width_maximum` | `decimal` | | ☐ | | | `width_minimum` | `decimal` | | ☐ | | | `width` | `decimal` | Width | ☐ | | | `year_last_registration_counter_reading` | `varchar2` | Year Last Registration Counter Reading | ☐ | |