# rdw_vehicles: RDW Vehicles - Catalog: `RDW` - Schema: `RDW` - Primary Keys: `id` - Label: Vehicles This is a read-only table. 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. ## Table Columns The columns of the table `rdw_vehicles` 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 | ☐ | | ## Foreign Keys The values of these columns refer to a row of another table. | Columns | Referenced Table | Referenced Columns | Guarantee | |---|---|---|---| | `code_explanation_counter_reading_judgement` | [[RDW-rdw_counter_reading_judgement_explanations\|RDW.rdw_counter_reading_judgement_explanations]] | `code` | Candidate: Follows from the name of the column and held in the 7 of the 9 codes used in 300 sampled vehicles on 2026-10-31; RDW does not state this relation. | ## Referenced By The columns of these tables refer to a row of this table. | Table | Columns | Guarantee | |---|---|---| | [[RDW-rdw_added_objects\|RDW.rdw_added_objects]] | `license_plate` | Candidate: Follows from the licence plate (kenteken), which RDW describes as making a vehicle unique and identifiable; held in every sampled row of the datasets on 2026-10-31, but RDW does not state this relation for this dataset. | | [[RDW-rdw_callback_action_statuses\|RDW.rdw_callback_action_statuses]] | `license_plate` | Candidate: Follows from the licence plate (kenteken), which RDW describes as making a vehicle unique and identifiable; held in every sampled row of the datasets on 2026-10-31, but RDW does not state this relation for this dataset. | | [[RDW-rdw_inspection_body_reports\|RDW.rdw_inspection_body_reports]] | `license_plate` | Candidate: Follows from the licence plate (kenteken), which RDW describes as making a vehicle unique and identifiable; held in every sampled row of the datasets on 2026-10-31, but RDW does not state this relation for this dataset. | | [[RDW-rdw_inspections\|RDW.rdw_inspections]] | `license_plate` | Candidate: Follows from the licence plate (kenteken), which RDW describes as making a vehicle unique and identifiable; held in every sampled row of the datasets on 2026-10-31, but RDW does not state this relation for this dataset. | | [[RDW-rdw_licensed_fuel_vehicles\|RDW.rdw_licensed_fuel_vehicles]] | `license_plate` | Declared by the connector, not enforced by the platform | | [[RDW-rdw_licensed_vehicle_axles\|RDW.rdw_licensed_vehicle_axles]] | `license_plate` | Declared by the connector, not enforced by the platform | | [[RDW-rdw_licensed_vehicle_chassis\|RDW.rdw_licensed_vehicle_chassis]] | `license_plate` | Declared by the connector, not enforced by the platform | | [[RDW-rdw_observed_defects\|RDW.rdw_observed_defects]] | `license_plate` | Candidate: Follows from the licence plate (kenteken), which RDW describes as making a vehicle unique and identifiable; held in every sampled row of the datasets on 2026-10-31, but RDW does not state this relation for this dataset. | | [[RDW-rdw_vehicle_particulars\|RDW.rdw_vehicle_particulars]] | `license_plate` | Candidate: Follows from the licence plate (kenteken), which RDW describes as making a vehicle unique and identifiable; held in every sampled row of the datasets on 2026-10-31, but RDW does not state this relation for this dataset. | | [[RDW-rdw_vehicle_subcategories\|RDW.rdw_vehicle_subcategories]] | `license_plate` | Candidate: Follows from the licence plate (kenteken), which RDW describes as making a vehicle unique and identifiable; held in every sampled row of the datasets on 2026-10-31, but RDW does not state this relation for this dataset. |