MatriculaSecundariastring nullable
Secondary license plate (national)
code_matriculastring nullable
Primary license plate country code
code_matricula_secundariastring nullable
Secondary license plate country code
Marcainteger nullable
Brand ID (FK to MarcasViatura)
Modelointeger nullable
Model ID (FK to ModelosViatura)
Cilindradastring nullable
Combustinteger nullable
Fuel type ID (FK to CombustivelViatura)
Caixainteger nullable
Gearbox ID (FK to CaixaVelocidadesViatura)
Corinteger nullable
Color ID (FK to CoresViatura)
Lugaresinteger nullable
Number of seats (FK to LugaresViatura)
Portasinteger nullable
Number of doors (FK to PortasViatura)
Segmentointeger nullable
Segment/Type ID (FK to TipoViatura)
Subsegmentointeger nullable
Subsegment ID (FK to Subsegmentos)
Estadointeger nullable
State ID (1=new, 2=sold, 3=reserved, 4=to close)
RegimeIvainteger nullable
VAT regime ID (FK to RegimeIva)
Dataentrstring date-time nullable
Datamatstring date-time nullable
Data_Impstring date-time nullable
data_mat_nacionalstring date-time nullable
National registration date
ValInspstring date-time nullable
Forneceinteger nullable
Supplier ID (FK to Cliente)
Ponto_de_vendainteger nullable
Point of sale ID (FK to PontosDeVenda)
IDempresainteger nullable
Company ID - auto-set from authenticated user
current_park_location_idinteger nullable
Current physical park location (FK to Z_ParkLocations). Required when the vehicle is created with localizacao=0 (em parque). Validated at route layer to belong to the same company.
custo_compranumber nullable
Purchase cost (€, > 0) — required
compra_metodo_pagamentointeger nullable
Payment method of the purchase (MetodosPagamento.ID); ignored for a consigned car
compra_fatura_idinteger nullable
Purchase invoice (Faturas.ID) to link
Consignadoboolean nullable
Emprestadoboolean nullable
Importadoboolean nullable
stockpartilhadoboolean nullable
datafechostring date-time nullable
bucketurlstring nullable
S3 bucket URL for main photo
Observacoesstring nullable
IDeasydatainteger nullable
Estadoeasydatainteger nullable
referenceinteger nullable
version_idinteger nullable
gearbox_type_idinteger nullable
Integrazu gearbox type ID
gearbox_shift_idinteger nullable
Integrazu gearbox shift ID
section_idinteger nullable
second_key_status'sim' | 'não' | 'requisitado' nullable