📘

Vehicle stock / trade in vehicles

vehicles inventory_logistics 🛡️ RLS Protected

Vehicle stock/car trade <unk> process and API documentation derived from code.

Fachliche Bestimmung: Vehicle stock/car trade <unk> process and API documentation derived from code. Includes all registered processes, capabilities, state machines, APIs and tables for simulations and reviews.

⚡ Workflows and life cycles (0) 🗄️ Data models and fields (2) 🔌 The Commission shall adopt delegated acts in accordance with Article 21 of this Regulation. (10) 🛡️ Regulatory and compliance

⚡ Workflows and life cycles

Dieses Modul folgt dem standardisierten transaktionalen CRUD- und Event-Lifecycle.

🗄️ Data models and fields

VehicleTradeInAgreements vehicle_trade_in_agreements RLS Aktiv

24 Fields and columns

Tabelle vehicle_trade_in_agreements

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`agreement_number`	`VARCHAR(32)`	Ja *	-	Feld agreement_number
`customer_id`	`UUID`	Ja *	FK ➔ customers.id	Feld customer_id
`vehicle_id`	`UUID`	Ja *	FK ➔ vehicles.id	Feld vehicle_id
`agreed_price`	`NUMERIC(14, 2)`	Ja *	-	Feld agreed_price
`existing_financing_bank`	`VARCHAR(128)`	Nein	-	Feld existing_financing_bank
`existing_financing_amount`	`NUMERIC(14, 2)`	Ja *	-	Feld existing_financing_amount
`net_credit_amount`	`NUMERIC(14, 2)`	Ja *	-	Feld net_credit_amount
`offset_sales_invoice_id`	`UUID`	Nein	FK ➔ invoices.id	Feld offset_sales_invoice_id
`declaration_accident_free`	`BOOLEAN`	Ja *	-	Feld declaration_accident_free
`declaration_commercial_use`	`BOOLEAN`	Ja *	-	Feld declaration_commercial_use
`number_of_keys`	`INTEGER`	Ja *	-	Feld number_of_keys
`registration_doc_part1_present`	`BOOLEAN`	Ja *	-	Feld registration_doc_part1_present
`registration_doc_part2_present`	`BOOLEAN`	Ja *	-	Feld registration_doc_part2_present
`status`	`VARCHAR(32)`	Ja *	-	Feld status
`notes`	`TEXT`	Nein	-	Feld notes
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

Vehicles vehicles RLS Aktiv

58 Fields and columns

Tabelle vehicles

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`vin`	`VARCHAR(17)`	Ja *	-	Feld vin
`license_plate`	`VARCHAR(32)`	Nein	-	Feld license_plate
`make`	`VARCHAR(64)`	Ja *	-	Feld make
`model`	`VARCHAR(64)`	Ja *	-	Feld model
`variant`	`VARCHAR(128)`	Nein	-	Feld variant
`body_type`	`VARCHAR(32)`	Nein	-	Feld body_type
`first_registration_date`	`DATE`	Nein	-	Feld first_registration_date
`mileage`	`INTEGER`	Ja *	-	Feld mileage
`fuel_type`	`VARCHAR(32)`	Ja *	-	Feld fuel_type
`transmission`	`VARCHAR(32)`	Ja *	-	Feld transmission
`power_kw`	`INTEGER`	Nein	-	Feld power_kw
`power_hp`	`INTEGER`	Nein	-	Feld power_hp
`engine_displacement_ccm`	`INTEGER`	Nein	-	Feld engine_displacement_ccm
`exterior_color`	`VARCHAR(64)`	Nein	-	Feld exterior_color
`interior_color`	`VARCHAR(64)`	Nein	-	Feld interior_color
`hsn`	`VARCHAR(4)`	Nein	-	Feld hsn
`tsn`	`VARCHAR(4)`	Nein	-	Feld tsn
`emission_class`	`VARCHAR(32)`	Nein	-	Feld emission_class
`tuv_until`	`DATE`	Nein	-	Feld tuv_until
`previous_owners`	`INTEGER`	Ja *	-	Feld previous_owners
`accident_free`	`BOOLEAN`	Ja *	-	Feld accident_free
`damage_notes`	`TEXT`	Nein	-	Feld damage_notes
`features`	`JSONB`	Ja *	-	Feld features
`status`	`VARCHAR(32)`	Ja *	-	Feld status
`tax_regime`	`VARCHAR(32)`	Ja *	-	Feld tax_regime
`purchase_date`	`DATE`	Nein	-	Feld purchase_date
`purchase_price`	`NUMERIC(14, 2)`	Ja *	-	Feld purchase_price
`purchase_type`	`VARCHAR(32)`	Ja *	-	Feld purchase_type
`seller_customer_id`	`UUID`	Nein	FK ➔ customers.id	Feld seller_customer_id
`supplier_id`	`UUID`	Nein	FK ➔ suppliers.id	Feld supplier_id
`reconditioning_cost`	`NUMERIC(14, 2)`	Ja *	-	Feld reconditioning_cost
`total_cost`	`NUMERIC(14, 2)`	Ja *	-	Feld total_cost
`asking_price`	`NUMERIC(14, 2)`	Ja *	-	Feld asking_price
`min_price`	`NUMERIC(14, 2)`	Nein	-	Feld min_price
`sold_price`	`NUMERIC(14, 2)`	Nein	-	Feld sold_price
`sold_date`	`DATE`	Nein	-	Feld sold_date
`buyer_customer_id`	`UUID`	Nein	FK ➔ customers.id	Feld buyer_customer_id
`invoice_id`	`UUID`	Nein	FK ➔ invoices.id	Feld invoice_id
`purchase_id`	`UUID`	Nein	FK ➔ purchases.id	Feld purchase_id
`trade_in_for_vehicle_id`	`UUID`	Nein	FK ➔ vehicles.id	Feld trade_in_for_vehicle_id
`location`	`VARCHAR(128)`	Nein	-	Feld location
`ad_title`	`VARCHAR(255)`	Nein	-	Feld ad_title
`ad_description`	`TEXT`	Nein	-	Feld ad_description
`is_listed_mobile_de`	`BOOLEAN`	Ja *	-	Feld is_listed_mobile_de
`mobile_de_ad_id`	`VARCHAR(64)`	Nein	-	Feld mobile_de_ad_id
`is_listed_autoscout24`	`BOOLEAN`	Ja *	-	Feld is_listed_autoscout24
`autoscout24_ad_id`	`VARCHAR(64)`	Nein	-	Feld autoscout24_ad_id
`listing_status`	`VARCHAR(32)`	Ja *	-	Feld listing_status
`images`	`JSONB`	Ja *	-	Feld images
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

🔌 The Commission shall adopt delegated acts in accordance with Article 21 of this Regulation.

Art	The method	Endpoint / path	Titel & Zweck	The Commission shall adopt the following:
⚡ REST API	GET	`/vehicles`	vehicles_page Semantic binding: not_evaluated; mutation=False	`vehicles`
⚡ REST API	GET	`/vehicles/export/autoscout24`	export_autoscout24_route Semantic binding: not_evaluated; mutation=False	`vehicles`
⚡ REST API	GET	`/vehicles/export/csv`	export_vehicles_csv_route Semantic binding: not_evaluated; mutation=False	`vehicles`
⚡ REST API	GET	`/vehicles/export/mobile-de`	export_mobile_de_route Semantic binding: not_evaluated; mutation=False	`vehicles`
⚡ REST API	GET	`/vehicles/new`	vehicle_create_page Semantic binding: not_evaluated; mutation=False	`vehicles`
⚡ REST API	GET	`/vehicles/{vehicle_id}`	vehicle_detail_page Semantic binding: not_evaluated; mutation=False	`vehicles`
⚡ REST API	POST	`/vehicles`	create_vehicle_form Semantic binding: not_evaluated; mutation=True	`vehicles`
⚡ REST API	POST	`/vehicles/trade-in`	create_trade_in_route Semantic binding: not_evaluated; mutation=True	`vehicles`
⚡ REST API	POST	`/vehicles/{vehicle_id}/create-invoice`	create_vehicle_invoice_route Semantic binding: not_evaluated; mutation=True	`vehicles`
⚡ REST API	POST	`/vehicles/{vehicle_id}/reconditioning`	add_vehicle_reconditioning_cost Semantic binding: not_evaluated; mutation=True	`vehicles`

🛡️ Regulatory and compliance

Dieses Modul unterliegt folgenden gesetzlichen, regulatorischen und Revisionsstandards:

The Commission shall adopt the following implementing acts:
The following information shall be provided: