Centurio Dokumenty systemowe i modułowe
🏛️ Architektura platformy 🔑 Login
🏠 Wszystkie moduły / inventory_logistics / Stopa pojazdów / handel samochodami
📘

Stopa pojazdów / handel samochodami

vehicles inventory_logistics 🛡️ RLS Protected

Dokumenty procesne i API pochodzące z kodu.

Fachliche Bestimmung: Dokumenty procesowe i API pochodzące z kodu. obejmują wszystkie zarejestrowane procesy, zdolności, maszyny stanu, API i tabele symulacji i przeglądów.

⚡ Przepływy pracy i cykle życia

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

🗄️ Modele danych

VehicleTradeInAgreements vehicle_trade_in_agreements RLS Aktiv
24 Wyroby

Tabelle vehicle_trade_in_agreements

Feldname Typ danych Wymóg Schlüssel Znaczenie specjalne
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 Wyroby

Tabelle vehicles

Feldname Typ danych Wymóg Schlüssel Znaczenie specjalne
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

🔌 Punkty wyjścia (UI & API)

Art Wykorzystanie Punkt końcowy / droga Titel & Zweck Właściwości
⚡ REST API GET /vehicles
vehicles_page
Semantic binding: inventory_only; mutation=False
vehicles
⚡ REST API GET /vehicles/export/autoscout24
export_autoscout24_route
Semantic binding: inventory_only; mutation=False
vehicles
⚡ REST API GET /vehicles/export/csv
export_vehicles_csv_route
Semantic binding: inventory_only; mutation=False
vehicles
⚡ REST API GET /vehicles/export/mobile-de
export_mobile_de_route
Semantic binding: inventory_only; mutation=False
vehicles
⚡ REST API GET /vehicles/new
vehicle_create_page
Semantic binding: inventory_only; mutation=False
vehicles
⚡ REST API GET /vehicles/{vehicle_id}
vehicle_detail_page
Semantic binding: inventory_only; mutation=False
vehicles
⚡ REST API POST /vehicles
create_vehicle_form
Semantic binding: operator_surface; mutation=True
vehicles
⚡ REST API POST /vehicles/trade-in
create_trade_in_route
Semantic binding: operator_surface; mutation=True
vehicles
⚡ REST API POST /vehicles/{vehicle_id}/create-invoice
create_vehicle_invoice_route
Semantic binding: operator_surface; mutation=True
vehicles
⚡ REST API POST /vehicles/{vehicle_id}/reconditioning
add_vehicle_reconditioning_cost
Semantic binding: operator_surface; mutation=True
vehicles

🛡️ Regulatoryzacja i zgodność

Dieses Modul unterliegt folgenden gesetzlichen, regulatorischen und Revisionsstandards:

  • Wykrywalność
  • W przypadku gdy systemy i systemy są w stanie być wyłączone, systemy i systemy identyfikacyjne mogą być wykorzystywane w celu zapewnienia zgodności z wymogami określonymi w art. 2 ust. 1 lit. a) i b) niniejszego rozporządzenia.