Centurio Sistemas & modulju dokumentacija
🔍
🏛️ Platformas arhitektūra
🇩🇪 Deutsch 🇬🇧 English 🇫🇷 Français 🇪🇸 Español 🇮🇹 Italiano 🇳🇱 Nederlands 🇵🇱 Polski 🇵🇹 Português 🇨🇿 Čeština 🇸🇰 Slovenčina 🇭🇺 Magyar 🇷🇴 Română 🇧🇬 Български 🇬🇷 Ελληνικά 🇩🇰 Dansk 🇫🇮 Suomi 🇸🇪 Svenska 🇱🇹 Lietuvių 🇱🇻 Latviešu 🇪🇪 Eesti 🇭🇷 Hrvatski 🇸🇮 Slovenščina 🇲🇹 Malti 🇮🇪 Gaeilge 🇷🇺 Русский 🇺🇦 Українська 🇹🇷 Türkçe 🇳🇴 Norsk bokmål 🇷🇸 Српски 🇮🇸 Íslenska 🇨🇭 Schwiiz/Suisse
🔑 Login
🏠 Visi moduli / inventory_logistics / Logistika un kravas sūtījumi
📘

Logistika un kravas sūtījumi

logistics inventory_logistics 🛡️ RLS Protected

Logistika & Karte <unk> process un API dokumenta, kas iegūta no kodeksa.

Fachliche Bestimmung: Logistika & Kargo nosūtīšana <unk> processu un API dokumentācija, kas iegūta no kodu.
⚡ Darbības plūsmas un dzīves cikļi (7) 🗄️ Datu modeļi & laukumi (13) 🔌 Izstādes punkti (UI un API) (85) 🛡️ Regulators & atbilstība

⚡ Darbības plūsmas un dzīves cikļi

Klienta pasūtījums → preču izceles cascade:business.customer_order.fulfill

Kaskade (review_gated).

1. issue
Izstrādājumu uzskaites
inventāri
Aktionen: stock.issue.create
2. tour
Izdodšanas brauciena plānošana
logistika
Aktionen: create_tour
3. project
projekts / izmaksām
Projekti
Aktionen: link_project
4. task
Ja ir nepieciešams, aprēķina:
uzdevumi
Aktionen: create_task

pavadzīme pilnīga apstrāde cascade:business.delivery_note.intake

Kaskade (review_gated).

1. stock
Pārtikas ievedumi uz noliktava
inventāri
Aktionen: post_goods_receipt
2. tour
Tur / tālāk pārvadājumu plānošana
logistika
Aktionen: create_tour
3. task
Pārbaudēt / salīdzināt preču ievešanu
uzdevumi
Aktionen: create_task
4. qc
Kvalitātes pārbaude, ja var būt negadījumi
inventāri
Aktionen: kvalitāte.check.create
5. ticket
Reklama biļete defektā
biļetes
Aktionen: create_ticket

Atbalsta apstrāde cascade:business.return_note.handling

Kaskade (review_gated).

1. ticket
Apdrošināšanas biļetes
biļetes
Aktionen: create_ticket
2. tour
Izņemšanas tur plani
logistika
Aktionen: create_tour
3. task
Atbalsta turpmāka apstrāde
uzdevumi
Aktionen: create_task

Tur / atcelšanas plāns cascade_target:business.logistics.tour

Kaskade (review_gated).

1. cascade
Tur / atcelšanas plāns

Uzraudzības iestāde: plan:command_logistics_tour_agent

Pārbaudēts durabls plan (durabls_plan), sākums: manuals_command.

1. logistics_tour_agent
logistics_tour_agent
{"key": "execute_command", "label": "Befehl prüfen, ausführen oder zur Freigabe vorlegen", "adapter": "agent.execute", "agent": "logistics_tour_agent", "condition_fact": null}
Aktionen: logistics_tour_agent

Sending status:logistics_shipment

Apskatāma stāvokļa mašīna (apskatāma tikai).

1. draft
projektu
Statuss <unk>izraksts <unk>izraksts <unk>izraksts
2. planned
plānots
Statuss <unk>planned <unk> statusa mašīna nosūtīšana.
3. picked_up
picked_up
Status <unk>picked_up<unk> no stāda mašīna nosūtīšana.
4. in_transit
in_transit
Statuss <unk>in_transit<unk> statusa mašīnas nosūtīšanas.
5. delivered
piegādāts
Status <unk>delivered<unk> to status mašīna nosūtīšana.
6. failed
neizpildīts
Statuss <unk>failed<unk> state machine nosūtīšana.
7. cancelled
atcelts
Statuss <unk> atcelts <unk> stāda mašīna nosūtīšana.

Turnejs status:logistics_tour

Apskatāma stāvokļa mašīna (apskatāma tikai).

1. draft
projektu
Statuss <unk>izraksts <unk> statuss mašīnas tur.
2. planned
plānots
Statuss <unk>planned <unk> statuss mašīna turneja.
3. in_progress
in_progress
Statuss <unk>in_progress<unk> statusa mašīnas brauciens.
4. completed
pabeigta
Statuss <unk>lvots <unk> statuss mašīnas turnejs.
5. cancelled
atcelts
Statuss <unk> atcelts <unk> Statusa mašīna turnejs.

🗄️ Datu modeļi & laukumi

GeoImportBatches geo_import_batches
8 Šķiet, ka tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai ir atkarīgs no tā, vai ir atkarīgs no tā, vai ir atkarīgs no tā, vai ir atkarīgs no tā vai ir no tā.

Tabelle geo_import_batches

Feldname Datums Atbalsts Schlüssel Īpaša nozīme
source_url VARCHAR(500) Ja * - Feld source_url
source_sha256 VARCHAR(64) Ja * - Feld source_sha256
continents VARCHAR(32) Ja * - Feld continents
place_count INTEGER Ja * - Feld place_count
imported_by UUID Nein - Feld imported_by
imported_at DATETIME Ja * - Feld imported_at
is_active BOOLEAN Ja * - Feld is_active
id UUID Nein PK Feld id
GeoPlaces geo_places
14 Šķiet, ka tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai ir atkarīgs no tā, vai ir atkarīgs no tā, vai ir atkarīgs no tā, vai ir atkarīgs no tā vai ir no tā.

Tabelle geo_places

Feldname Datums Atbalsts Schlüssel Īpaša nozīme
batch_id UUID Ja * FK ➔ geo_import_batches.id Feld batch_id
geoname_id BIGINT Ja * - Feld geoname_id
name VARCHAR(200) Ja * - Feld name
ascii_name VARCHAR(200) Ja * - Feld ascii_name
alt_names TEXT Ja * - Feld alt_names
search_name VARCHAR(200) Ja * - Feld search_name
country_code VARCHAR(2) Ja * - Feld country_code
admin1_code VARCHAR(20) Nein - Feld admin1_code
admin1_name VARCHAR(200) Nein - Feld admin1_name
latitude NUMERIC(9, 6) Ja * - Feld latitude
longitude NUMERIC(9, 6) Ja * - Feld longitude
population INTEGER Ja * - Feld population
timezone VARCHAR(64) Nein - Feld timezone
id UUID Nein PK Feld id
LogisticsCn23Declarations logistics_cn23_declarations RLS Aktiv
23 Šķiet, ka tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai ir atkarīgs no tā, vai ir atkarīgs no tā, vai ir atkarīgs no tā, vai ir atkarīgs no tā vai ir no tā.

Tabelle logistics_cn23_declarations

Feldname Datums Atbalsts Schlüssel Īpaša nozīme
package_id UUID Ja * FK ➔ logistics_shipment_packages.id Feld package_id
shipment_id UUID Ja * FK ➔ logistics_shipments.id Feld shipment_id
status VARCHAR(48) Ja * - Feld status
category VARCHAR(32) Ja * - Feld category
currency VARCHAR(3) Ja * - Feld currency
total_weight_kg NUMERIC(14, 4) Nein - Feld total_weight_kg
total_value NUMERIC(14, 2) Nein - Feld total_value
contents JSONB Ja * - Feld contents
missing_fields JSONB Ja * - Feld missing_fields
sender_name VARCHAR(255) Nein - Feld sender_name
sender_country_code VARCHAR(2) Nein - Feld sender_country_code
recipient_name VARCHAR(255) Nein - Feld recipient_name
recipient_country_code VARCHAR(2) Nein - Feld recipient_country_code
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
LogisticsExportConsolidationPackages logistics_export_consolidation_packages RLS Aktiv
9 Šķiet, ka tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai ir atkarīgs no tā, vai ir atkarīgs no tā, vai ir atkarīgs no tā, vai ir atkarīgs no tā vai ir no tā.

Tabelle logistics_export_consolidation_packages

Feldname Datums Atbalsts Schlüssel Īpaša nozīme
consolidation_id UUID Ja * FK ➔ logistics_export_consolidations.id Feld consolidation_id
package_id UUID Ja * FK ➔ logistics_shipment_packages.id Feld package_id
position INTEGER Ja * - Feld position
loaded_at DATETIME Nein - Feld loaded_at
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
metadata JSONB Ja * - Feld metadata
LogisticsExportConsolidations logistics_export_consolidations RLS Aktiv
21 Šķiet, ka tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai ir atkarīgs no tā, vai ir atkarīgs no tā, vai ir atkarīgs no tā, vai ir atkarīgs no tā vai ir no tā.

Tabelle logistics_export_consolidations

Feldname Datums Atbalsts Schlüssel Īpaša nozīme
consolidation_number VARCHAR(32) Ja * - Feld consolidation_number
mode VARCHAR(48) Ja * - Feld mode
status VARCHAR(48) Ja * - Feld status
container_ref VARCHAR(64) Nein - Feld container_ref
vessel_voyage VARCHAR(128) Nein - Feld vessel_voyage
destination_country_code VARCHAR(2) Nein - Feld destination_country_code
etd DATE Nein - Feld etd
eta DATE Nein - Feld eta
partner_customer_id UUID Nein FK ➔ customers.id Feld partner_customer_id
notes TEXT Nein - Feld notes
closed_at DATETIME Nein - Feld closed_at
shipped_at DATETIME Nein - Feld shipped_at
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
LogisticsShipmentPackages logistics_shipment_packages RLS Aktiv
20 Šķiet, ka tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai ir atkarīgs no tā, vai ir atkarīgs no tā, vai ir atkarīgs no tā, vai ir atkarīgs no tā vai ir no tā.

Tabelle logistics_shipment_packages

Feldname Datums Atbalsts Schlüssel Īpaša nozīme
shipment_id UUID Ja * FK ➔ logistics_shipments.id Feld shipment_id
position INTEGER Ja * - Feld position
barcode VARCHAR(64) Nein - Feld barcode
label VARCHAR(255) Nein - Feld label
status VARCHAR(48) Ja * - Feld status
gross_weight_kg NUMERIC(14, 4) Nein - Feld gross_weight_kg
length_cm NUMERIC(14, 4) Nein - Feld length_cm
width_cm NUMERIC(14, 4) Nein - Feld width_cm
height_cm NUMERIC(14, 4) Nein - Feld height_cm
is_dangerous_goods BOOLEAN Ja * - Feld is_dangerous_goods
adr_un_number VARCHAR(16) Nein - Feld adr_un_number
adr_class VARCHAR(16) Nein - Feld adr_class
is_bulky BOOLEAN Ja * - Feld is_bulky
notes TEXT Nein - Feld notes
scanned_at DATETIME Nein - Feld scanned_at
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
metadata JSONB Ja * - Feld metadata
LogisticsShipments logistics_shipments RLS Aktiv
65 Šķiet, ka tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai ir atkarīgs no tā, vai ir atkarīgs no tā, vai ir atkarīgs no tā, vai ir atkarīgs no tā vai ir no tā.

Tabelle logistics_shipments

Feldname Datums Atbalsts Schlüssel Īpaša nozīme
shipment_number VARCHAR(32) Ja * - Feld shipment_number
status VARCHAR(48) Ja * - Feld status
carrier_mode VARCHAR(48) Ja * - Feld carrier_mode
subcontractor_supplier_id UUID Nein FK ➔ suppliers.id Feld subcontractor_supplier_id
contract_id UUID Nein FK ➔ contracts.id Feld contract_id
carrier_contract_id UUID Nein FK ➔ contracts.id Feld carrier_contract_id
customer_id UUID Nein FK ➔ customers.id Feld customer_id
work_order_id UUID Nein FK ➔ work_orders.id Feld work_order_id
project_id UUID Nein FK ➔ projects.id Feld project_id
stock_issue_id UUID Nein FK ➔ stock_issues.id Feld stock_issue_id
sender_name VARCHAR(255) Ja * - Feld sender_name
sender_address_line1 VARCHAR(255) Nein - Feld sender_address_line1
sender_postal_code VARCHAR(32) Nein - Feld sender_postal_code
sender_city VARCHAR(128) Nein - Feld sender_city
sender_country_code VARCHAR(2) Nein - Feld sender_country_code
consignee_name VARCHAR(255) Ja * - Feld consignee_name
consignee_address_line1 VARCHAR(255) Nein - Feld consignee_address_line1
consignee_postal_code VARCHAR(32) Nein - Feld consignee_postal_code
consignee_city VARCHAR(128) Nein - Feld consignee_city
consignee_country_code VARCHAR(2) Nein - Feld consignee_country_code
place_of_taking_over VARCHAR(255) Nein - Feld place_of_taking_over
date_of_taking_over DATE Nein - Feld date_of_taking_over
place_of_delivery VARCHAR(255) Nein - Feld place_of_delivery
goods_description TEXT Nein - Feld goods_description
packages_count INTEGER Nein - Feld packages_count
gross_weight_kg NUMERIC(14, 4) Nein - Feld gross_weight_kg
volume_m3 NUMERIC(14, 4) Nein - Feld volume_m3
is_dangerous_goods BOOLEAN Ja * - Feld is_dangerous_goods
adr_un_number VARCHAR(16) Nein - Feld adr_un_number
adr_class VARCHAR(16) Nein - Feld adr_class
adr_packing_group VARCHAR(8) Nein - Feld adr_packing_group
adr_tunnel_code VARCHAR(8) Nein - Feld adr_tunnel_code
adr_net_mass_kg NUMERIC(14, 4) Nein - Feld adr_net_mass_kg
is_bulky BOOLEAN Ja * - Feld is_bulky
length_cm NUMERIC(14, 4) Nein - Feld length_cm
width_cm NUMERIC(14, 4) Nein - Feld width_cm
height_cm NUMERIC(14, 4) Nein - Feld height_cm
loading_meters NUMERIC(14, 4) Nein - Feld loading_meters
pallet_type VARCHAR(16) Nein - Feld pallet_type
pallet_count INTEGER Nein - Feld pallet_count
stack_factor INTEGER Ja * - Feld stack_factor
requires_tail_lift BOOLEAN Ja * - Feld requires_tail_lift
requires_crane BOOLEAN Ja * - Feld requires_crane
carriage_charge_terms VARCHAR(48) Ja * - Feld carriage_charge_terms
special_agreements TEXT Nein - Feld special_agreements
tour_id UUID Nein FK ➔ logistics_tours.id Feld tour_id
picked_up_at DATETIME Nein - Feld picked_up_at
pickup_signature_document_id UUID Nein FK ➔ documents.id Feld pickup_signature_document_id
pickup_signed_by_name VARCHAR(255) Nein - Feld pickup_signed_by_name
delivered_at DATETIME Nein - Feld delivered_at
delivery_signature_document_id UUID Nein FK ➔ documents.id Feld delivery_signature_document_id
delivery_signed_by_name VARCHAR(255) Nein - Feld delivery_signed_by_name
carrier_code VARCHAR(32) Nein - Feld carrier_code
tracking_number VARCHAR(64) Nein - Feld tracking_number
notes TEXT Nein - Feld notes
idempotency_key VARCHAR(128) Nein - Feld idempotency_key
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
LogisticsTourPositionSamples logistics_tour_position_samples RLS Aktiv
12 Šķiet, ka tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai ir atkarīgs no tā, vai ir atkarīgs no tā, vai ir atkarīgs no tā, vai ir atkarīgs no tā vai ir no tā.

Tabelle logistics_tour_position_samples

Feldname Datums Atbalsts Schlüssel Īpaša nozīme
tour_id UUID Ja * FK ➔ logistics_tours.id Feld tour_id
recorded_at DATETIME Ja * - Feld recorded_at
lat NUMERIC(9, 6) Ja * - Feld lat
lng NUMERIC(9, 6) Ja * - Feld lng
accuracy_m NUMERIC(10, 2) Nein - Feld accuracy_m
speed_kmh NUMERIC(8, 2) Nein - Feld speed_kmh
heading_deg NUMERIC(6, 2) Nein - Feld heading_deg
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
metadata JSONB Ja * - Feld metadata
LogisticsTourStopPhotos logistics_tour_stop_photos RLS Aktiv
9 Šķiet, ka tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai ir atkarīgs no tā, vai ir atkarīgs no tā, vai ir atkarīgs no tā, vai ir atkarīgs no tā vai ir no tā.

Tabelle logistics_tour_stop_photos

Feldname Datums Atbalsts Schlüssel Īpaša nozīme
tour_stop_id UUID Ja * FK ➔ logistics_tour_stops.id Feld tour_stop_id
document_id UUID Ja * FK ➔ documents.id Feld document_id
caption VARCHAR(255) Nein - Feld caption
position INTEGER Ja * - Feld position
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
metadata JSONB Ja * - Feld metadata
LogisticsTourStops logistics_tour_stops RLS Aktiv
32 Šķiet, ka tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai ir atkarīgs no tā, vai ir atkarīgs no tā, vai ir atkarīgs no tā, vai ir atkarīgs no tā vai ir no tā.

Tabelle logistics_tour_stops

Feldname Datums Atbalsts Schlüssel Īpaša nozīme
tour_id UUID Ja * FK ➔ logistics_tours.id Feld tour_id
shipment_id UUID Nein FK ➔ logistics_shipments.id Feld shipment_id
position INTEGER Ja * - Feld position
stop_type VARCHAR(48) Ja * - Feld stop_type
status VARCHAR(48) Ja * - Feld status
contact_name VARCHAR(255) Nein - Feld contact_name
address_line1 VARCHAR(255) Nein - Feld address_line1
address_line2 VARCHAR(255) Nein - Feld address_line2
postal_code VARCHAR(32) Nein - Feld postal_code
city VARCHAR(128) Nein - Feld city
country_code VARCHAR(2) Nein - Feld country_code
phone VARCHAR(64) Nein - Feld phone
latitude NUMERIC(9, 6) Nein - Feld latitude
longitude NUMERIC(9, 6) Nein - Feld longitude
planned_window_start DATETIME Nein - Feld planned_window_start
planned_window_end DATETIME Nein - Feld planned_window_end
arrived_at DATETIME Nein - Feld arrived_at
completed_at DATETIME Nein - Feld completed_at
signature_document_id UUID Nein FK ➔ documents.id Feld signature_document_id
signed_by_name VARCHAR(255) Nein - Feld signed_by_name
failure_reason TEXT Nein - Feld failure_reason
notes TEXT Nein - Feld notes
damage_reported BOOLEAN Ja * - Feld damage_reported
damage_notes TEXT Nein - Feld damage_notes
pod_lat NUMERIC(9, 6) Nein - Feld pod_lat
pod_lng NUMERIC(9, 6) Nein - Feld pod_lng
delivery_note_document_id UUID Nein FK ➔ documents.id Feld delivery_note_document_id
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
metadata JSONB Ja * - Feld metadata
LogisticsTours logistics_tours RLS Aktiv
26 Šķiet, ka tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai ir atkarīgs no tā, vai ir atkarīgs no tā, vai ir atkarīgs no tā, vai ir atkarīgs no tā vai ir no tā.

Tabelle logistics_tours

Feldname Datums Atbalsts Schlüssel Īpaša nozīme
tour_number VARCHAR(32) Ja * - Feld tour_number
status VARCHAR(48) Ja * - Feld status
planned_date DATE Nein - Feld planned_date
vehicle_asset_id UUID Nein FK ➔ assets.id Feld vehicle_asset_id
driver_user_id UUID Nein FK ➔ users.id Feld driver_user_id
depot_location_id UUID Nein FK ➔ locations.id Feld depot_location_id
started_at DATETIME Nein - Feld started_at
completed_at DATETIME Nein - Feld completed_at
cancelled_at DATETIME Nein - Feld cancelled_at
notes TEXT Nein - Feld notes
idempotency_key VARCHAR(128) Nein - Feld idempotency_key
current_lat NUMERIC(9, 6) Nein - Feld current_lat
current_lng NUMERIC(9, 6) Nein - Feld current_lng
current_accuracy_m NUMERIC(8, 2) Nein - Feld current_accuracy_m
current_speed_kmh NUMERIC(6, 2) Nein - Feld current_speed_kmh
current_heading_deg NUMERIC(5, 1) Nein - Feld current_heading_deg
position_updated_at DATETIME Nein - Feld position_updated_at
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
LogisticsVehicleBayLoads logistics_vehicle_bay_loads RLS Aktiv
10 Šķiet, ka tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai ir atkarīgs no tā, vai ir atkarīgs no tā, vai ir atkarīgs no tā, vai ir atkarīgs no tā vai ir no tā.

Tabelle logistics_vehicle_bay_loads

Feldname Datums Atbalsts Schlüssel Īpaša nozīme
bay_id UUID Ja * FK ➔ logistics_vehicle_load_bays.id Feld bay_id
tour_id UUID Ja * FK ➔ logistics_tours.id Feld tour_id
shipment_id UUID Ja * FK ➔ logistics_shipments.id Feld shipment_id
package_id UUID Nein FK ➔ logistics_shipment_packages.id Feld package_id
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
metadata JSONB Ja * - Feld metadata
LogisticsVehicleLoadBays logistics_vehicle_load_bays RLS Aktiv
21 Šķiet, ka tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai tas ir atkarīgs no tā, vai ir atkarīgs no tā, vai ir atkarīgs no tā, vai ir atkarīgs no tā, vai ir atkarīgs no tā vai ir no tā.

Tabelle logistics_vehicle_load_bays

Feldname Datums Atbalsts Schlüssel Īpaša nozīme
asset_id UUID Ja * FK ➔ assets.id Feld asset_id
code VARCHAR(32) Ja * - Feld code
name VARCHAR(128) Ja * - Feld name
position INTEGER Ja * - Feld position
max_weight_kg NUMERIC(14, 4) Nein - Feld max_weight_kg
max_loading_meters NUMERIC(14, 4) Nein - Feld max_loading_meters
length_cm NUMERIC(14, 4) Nein - Feld length_cm
width_cm NUMERIC(14, 4) Nein - Feld width_cm
height_cm NUMERIC(14, 4) Nein - Feld height_cm
allows_dangerous_goods BOOLEAN Ja * - Feld allows_dangerous_goods
is_active BOOLEAN Ja * - Feld is_active
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

🔌 Izstādes punkti (UI un API)

Art Metodes Galvenā vieta / ceļš Titel & Zweck Attaisnošana
⚡ REST API DELETE /api/v1/crossdock/{op_id}/lines/{kind}/{line_id}
remove_line
Semantic binding: not_evaluated; mutation=True
 logistics
⚡ REST API DELETE /api/v1/logistics/vehicle-bay-loads/{load_id}
remove_vehicle_bay_load
Semantic binding: not_evaluated; mutation=True
 logistics
⚡ REST API GET /api/v1/crossdock
list_operations
Semantic binding: not_evaluated; mutation=False
 logistics
⚡ REST API GET /api/v1/crossdock/meta
meta
Semantic binding: not_evaluated; mutation=False
 logistics
⚡ REST API GET /api/v1/crossdock/rules
list_rules
Semantic binding: not_evaluated; mutation=False
 logistics
⚡ REST API GET /api/v1/crossdock/{op_id}
get_operation
Semantic binding: not_evaluated; mutation=False
 logistics
⚡ REST API GET /api/v1/logistics/docks
list_docks
Semantic binding: not_evaluated; mutation=False
 logistics
⚡ REST API GET /api/v1/logistics/docks/{dock_id}/slots
list_dock_slots
Semantic binding: not_evaluated; mutation=False
 logistics
⚡ REST API GET /api/v1/logistics/export-consolidations/{consolidation_id}
get_export_consolidation
Semantic binding: not_evaluated; mutation=False
 logistics
⚡ REST API GET /api/v1/logistics/packages/{package_id}/cn23
get_package_cn23
Semantic binding: not_evaluated; mutation=False
 logistics
⚡ REST API GET /api/v1/logistics/shipments
list_shipments
Semantic binding: not_evaluated; mutation=False
 logistics
⚡ REST API GET /api/v1/logistics/shipments/{shipment_id}
get_shipment
Semantic binding: not_evaluated; mutation=False
 logistics
⚡ REST API GET /api/v1/logistics/shipments/{shipment_id}/cmr
shipment_cmr_pdf
Semantic binding: not_evaluated; mutation=False
 logistics
⚡ REST API GET /api/v1/logistics/shipments/{shipment_id}/cmr.json
shipment_cmr_json
Semantic binding: not_evaluated; mutation=False
 logistics
⚡ REST API GET /api/v1/logistics/shipments/{shipment_id}/contract-check
shipment_contract_check
Semantic binding: not_evaluated; mutation=False
 logistics
⚡ REST API GET /api/v1/logistics/shipments/{shipment_id}/delivery-note
shipment_delivery_note_pdf
Semantic binding: not_evaluated; mutation=False
 logistics
⚡ REST API GET /api/v1/logistics/shipments/{shipment_id}/label
shipment_label_pdf
Semantic binding: not_evaluated; mutation=False
 logistics
⚡ REST API GET /api/v1/logistics/shipments/{shipment_id}/packages
list_packages
Semantic binding: not_evaluated; mutation=False
 logistics
⚡ REST API GET /api/v1/logistics/tours
list_tours
Semantic binding: not_evaluated; mutation=False
 logistics
⚡ REST API GET /api/v1/logistics/tours/my
list_my_tours
Semantic binding: not_evaluated; mutation=False
 logistics
⚡ REST API GET /api/v1/logistics/tours/{tour_id}
get_tour
Semantic binding: not_evaluated; mutation=False
 logistics
⚡ REST API GET /api/v1/logistics/tours/{tour_id}/load-plan
tour_load_plan
Semantic binding: not_evaluated; mutation=False
 logistics
⚡ REST API GET /api/v1/logistics/tours/{tour_id}/positions
list_tour_positions
Semantic binding: not_evaluated; mutation=False
 logistics
⚡ REST API GET /api/v1/logistics/vehicle-bay-loads
list_vehicle_bay_loads
Semantic binding: not_evaluated; mutation=False
 logistics
⚡ REST API GET /api/v1/logistics/vehicle-bays
list_vehicle_bays
Semantic binding: not_evaluated; mutation=False
 logistics
⚡ REST API GET /api/v1/logistics/vehicles/{asset_id}/capacity
get_vehicle_capacity
Semantic binding: not_evaluated; mutation=False
 logistics
⚡ REST API GET /crossdock
crossdock_page
Semantic binding: not_evaluated; mutation=False
 logistics
⚡ REST API GET /logistics
logistics_page
Semantic binding: not_evaluated; mutation=False
 logistics
⚡ REST API GET /logistics/meine-touren
logistics_meine_page
Semantic binding: not_evaluated; mutation=False
 logistics
⚡ REST API GET /portal/{slug}/sendungen
shipments_page
Semantic binding: not_evaluated; mutation=False
 logistics
⚡ REST API PATCH /api/v1/logistics/tours/{tour_id}
patch_tour
Semantic binding: not_evaluated; mutation=True
 logistics
⚡ REST API POST /api/v1/crossdock
create_operation
Semantic binding: not_evaluated; mutation=True
 logistics
⚡ REST API POST /api/v1/crossdock/dock-scan
dock_scan
Semantic binding: not_evaluated; mutation=True
 logistics
⚡ REST API POST /api/v1/crossdock/from-purchase/{purchase_id}
from_purchase
Semantic binding: not_evaluated; mutation=True
 logistics
⚡ REST API POST /api/v1/crossdock/rules
create_rule
Semantic binding: not_evaluated; mutation=True
 logistics
⚡ REST API POST /api/v1/crossdock/{op_id}/allocate
sadaļa
Semantic binding: not_evaluated; mutation=True
 logistics
⚡ REST API POST /api/v1/crossdock/{op_id}/cancel
atcelt
Semantic binding: not_evaluated; mutation=True
 logistics
⚡ REST API POST /api/v1/crossdock/{op_id}/dispatch
nosūtīšana
Semantic binding: not_evaluated; mutation=True
 logistics
⚡ REST API POST /api/v1/crossdock/{op_id}/inbound
add_inbound
Semantic binding: not_evaluated; mutation=True
 logistics
⚡ REST API POST /api/v1/crossdock/{op_id}/inbound/from-purchase/{purchase_id}
inbound_from_purchase
Semantic binding: not_evaluated; mutation=True
 logistics
⚡ REST API POST /api/v1/crossdock/{op_id}/outbound
add_outbound
Semantic binding: not_evaluated; mutation=True
 logistics
⚡ REST API POST /api/v1/crossdock/{op_id}/outbound/from-quote/{quote_id}
outbound_from_quote
Semantic binding: not_evaluated; mutation=True
 logistics
⚡ REST API POST /api/v1/crossdock/{op_id}/plan
plan
Semantic binding: not_evaluated; mutation=True
 logistics
⚡ REST API POST /api/v1/crossdock/{op_id}/putaway
putway
Semantic binding: not_evaluated; mutation=True
 logistics
⚡ REST API POST /api/v1/crossdock/{op_id}/receive
saņem
Semantic binding: not_evaluated; mutation=True
 logistics
⚡ REST API POST /api/v1/logistics/dock-slots/{slot_id}/cancel
cancel_dock_slot
Semantic binding: not_evaluated; mutation=True
 logistics
⚡ REST API POST /api/v1/logistics/dock-slots/{slot_id}/check-in
check_in_dock_slot
Semantic binding: not_evaluated; mutation=True
 logistics
⚡ REST API POST /api/v1/logistics/dock-slots/{slot_id}/complete
complete_dock_slot
Semantic binding: not_evaluated; mutation=True
 logistics
⚡ REST API POST /api/v1/logistics/docks
create_dock
Semantic binding: not_evaluated; mutation=True
 logistics
⚡ REST API POST /api/v1/logistics/docks/{dock_id}/slots
book_dock_slot
Semantic binding: not_evaluated; mutation=True
 logistics
⚡ REST API POST /api/v1/logistics/export-consolidations
create_export_consolidation
Semantic binding: not_evaluated; mutation=True
 logistics
⚡ REST API POST /api/v1/logistics/export-consolidations/{consolidation_id}/close
close_export_consolidation
Semantic binding: not_evaluated; mutation=True
 logistics
⚡ REST API POST /api/v1/logistics/export-consolidations/{consolidation_id}/packages
add_export_consolidation_package
Semantic binding: not_evaluated; mutation=True
 logistics
⚡ REST API POST /api/v1/logistics/export-consolidations/{consolidation_id}/ship
ship_export_consolidation
Semantic binding: not_evaluated; mutation=True
 logistics
⚡ REST API POST /api/v1/logistics/packages/scan
scan_package
Semantic binding: not_evaluated; mutation=True
 logistics
⚡ REST API POST /api/v1/logistics/packages/{package_id}/cn23
ensure_package_cn23
Semantic binding: not_evaluated; mutation=True
 logistics
⚡ REST API POST /api/v1/logistics/shipments
create_shipment
Semantic binding: not_evaluated; mutation=True
 logistics
⚡ REST API POST /api/v1/logistics/shipments/import
import_shipments
Semantic binding: not_evaluated; mutation=True
 logistics
⚡ REST API POST /api/v1/logistics/shipments/{shipment_id}/assign-tour
assign_tour
Semantic binding: not_evaluated; mutation=True
 logistics
⚡ REST API POST /api/v1/logistics/shipments/{shipment_id}/cancel
cancel_shipment
Semantic binding: not_evaluated; mutation=True
 logistics
⚡ REST API POST /api/v1/logistics/shipments/{shipment_id}/carrier-tracking
set_carrier_tracking
Semantic binding: not_evaluated; mutation=True
 logistics
⚡ REST API POST /api/v1/logistics/shipments/{shipment_id}/deliver
deliver_shipment
Semantic binding: not_evaluated; mutation=True
 logistics
⚡ REST API POST /api/v1/logistics/shipments/{shipment_id}/fail
fail_shipment
Semantic binding: not_evaluated; mutation=True
 logistics
⚡ REST API POST /api/v1/logistics/shipments/{shipment_id}/in-transit
in_transit_shipment
Semantic binding: not_evaluated; mutation=True
 logistics
⚡ REST API POST /api/v1/logistics/shipments/{shipment_id}/packages
add_package
Semantic binding: not_evaluated; mutation=True
 logistics
⚡ REST API POST /api/v1/logistics/shipments/{shipment_id}/pickup
pickup_shipment
Semantic binding: not_evaluated; mutation=True
 logistics
⚡ REST API POST /api/v1/logistics/shipments/{shipment_id}/verify-charges
shipment_verify_charges
Semantic binding: not_evaluated; mutation=True
 logistics
⚡ REST API POST /api/v1/logistics/tours
create_tour
Semantic binding: not_evaluated; mutation=True
 logistics
⚡ REST API POST /api/v1/logistics/tours/from-picking
tour_from_picking
Semantic binding: not_evaluated; mutation=True
 logistics
⚡ REST API POST /api/v1/logistics/tours/from-return
tour_from_return
Semantic binding: not_evaluated; mutation=True
 logistics
⚡ REST API POST /api/v1/logistics/tours/from-shipments
tour_from_shipments
Semantic binding: not_evaluated; mutation=True
 logistics
⚡ REST API POST /api/v1/logistics/tours/{tour_id}/cancel
cancel_tour
Semantic binding: not_evaluated; mutation=True
 logistics
⚡ REST API POST /api/v1/logistics/tours/{tour_id}/complete
complete_tour
Semantic binding: not_evaluated; mutation=True
 logistics
⚡ REST API POST /api/v1/logistics/tours/{tour_id}/geocode-stops
geocode_tour_stops
Semantic binding: not_evaluated; mutation=True
 logistics
⚡ REST API POST /api/v1/logistics/tours/{tour_id}/optimize-stops
optimize_tour_stops
Semantic binding: not_evaluated; mutation=True
 logistics
⚡ REST API POST /api/v1/logistics/tours/{tour_id}/position
update_position
Semantic binding: not_evaluated; mutation=True
 logistics
⚡ REST API POST /api/v1/logistics/tours/{tour_id}/start
start_tour
Semantic binding: not_evaluated; mutation=True
 logistics
⚡ REST API POST /api/v1/logistics/tours/{tour_id}/stops
add_stop
Semantic binding: not_evaluated; mutation=True
 logistics
⚡ REST API POST /api/v1/logistics/tours/{tour_id}/stops/{stop_id}/arrive
arrive_stop
Semantic binding: not_evaluated; mutation=True
 logistics
⚡ REST API POST /api/v1/logistics/tours/{tour_id}/stops/{stop_id}/complete
complete_stop
Semantic binding: not_evaluated; mutation=True
 logistics
⚡ REST API POST /api/v1/logistics/vehicle-bay-loads
assign_vehicle_bay_load
Semantic binding: not_evaluated; mutation=True
 logistics
⚡ REST API POST /api/v1/logistics/vehicle-bays
create_vehicle_bay
Semantic binding: not_evaluated; mutation=True
 logistics
⚡ REST API PUT /api/v1/crossdock/rules/{rule_id}
update_rule
Semantic binding: not_evaluated; mutation=True
 logistics
⚡ REST API PUT /api/v1/crossdock/{op_id}/allocations
set_allocation
Semantic binding: not_evaluated; mutation=True
 logistics
⚡ REST API PUT /api/v1/logistics/vehicles/{asset_id}/capacity
put_vehicle_capacity
Semantic binding: not_evaluated; mutation=True
 logistics

🛡️ Regulators & atbilstība

Dieses Modul unterliegt folgenden gesetzlichen, regulatorischen und Revisionsstandards:

  • GOPD pārraudzības
  • Klienta izolācija (PostgreSQL RLS)