📘

Logistika ir krovinių siuntimas

logistics inventory_logistics 🛡️ RLS Protected

Logistika & krovinių siuntimas <unk> proceso ir API dokumentacija, gaunama iš kodų.

Fachliche Bestimmung: Logistika ir krovinių siuntimas <unk> iš kodų išvestas proceso ir API dokumentais.

⚡ Darbo srautai ir gyvenimo ciklai (7) 🗄️ Datybių modeliai ir laukiniai (13) 🔌 Įprastus punktai (UI ir API) (90) 🛡️ Reguliariška ir atitiktis

⚡ Darbo srautai ir gyvenimo ciklai

Kliento užsakymas → Prekės išleidimas `cascade:business.customer_order.fulfill`

Kaskade (review_gated).

1. issue

Išvežimas kaip projektas

Inventorius

Aktionen: - "Stock.issue.create"

2. tour

Išdavimo kelionę planuoti

logistika

Aktionen: create_tour

3. project

projektas / išlaidų skyrimas

Projektai

Aktionen: link_project

4. task

Įgyvendinti / apskaičiuoti

užduotis

Aktionen: create_task

siuntimo dokumentas - visą perdirbimą `cascade:business.delivery_note.intake`

Kaskade (review_gated).

1. stock

Įskaičiuoti į _GT20_0__

Inventorius

Aktionen: post_goods_receipt

2. tour

Turis / pervežimas

logistika

Aktionen: create_tour

3. task

Įvežimo įvežimo patikrinimas / lyginimas

užduotis

Aktionen: create_task

4. qc

Kvaliteto patikrinimas susimąstant defektų

Inventorius

Aktionen: kokybės.check.create

5. ticket

Skundų bilietas

bilietai

Aktionen: create_ticket

Atgavimo tvarkymas `cascade:business.return_note.handling`

Kaskade (review_gated).

1. ticket

Reklamacijų bilietas

bilietai

Aktionen: create_ticket

2. tour

Planuoti surinkimo kelionę

logistika

Aktionen: create_tour

3. task

Atnaujinti

užduotis

Aktionen: create_task

Planuoti ekskursiją `cascade_target:business.logistics.tour`

Kaskade (review_gated).

1. cascade

Planuoti ekskursiją

Naudotojo nurodymas: logistikos turistas `plan:command_logistics_tour_agent`

Įvertintas tvarkingojo plano (durable_plan), pradžia: manual_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

Siuntymas `status:logistics_shipment`

Įmonė, kurioje yra stebima būklė (tik stebima).

1. draft

Draftas

Statusas <unk>pranešimas <unk>statuso mašinos siuntimo.

2. planned

Planuojama

Statusas <unk>planned<unk> <unk> condition machine

3. picked_up

picked_up

Statusas <unk>picked_up<unk> <unk> statusą turinčios mašinos siuntimo.

4. in_transit

in_transit

Statusas <unk>in_transit<unk> statuso mašinos siuntimo.

5. delivered

Išvežimas

Status <unk>delivered<unk> statusą mašinos siuntimo.

6. failed

Neveikė

Statusas <unk>neveikta <unk> statuso mašinos siuntimo.

7. cancelled

Atšauktas

Statusas <unk> atšauktas <unk> statuso mašinos siuntimą.

Renginys `status:logistics_tour`

Įmonė, kurioje yra stebima būklė (tik stebima).

1. draft

Draftas

Statusas <unk>pranešimas <unk> statuso mašinos keliones.

2. planned

Planuojama

Statusas <unk>planavimas <unk> statuso mašinos keliones.

3. in_progress

in_progress

Statusas <unk>in_progress<unk> statuso mašinos kelionės.

4. completed

Užpildytas

Statusas <unk> užbaigtas <unk> statuso mašinos keliones.

5. cancelled

Atšauktas

Statusas <unk>reikšluotas <unk>turas.

🗄️ Datybių modeliai ir laukiniai

GeoImportBatches geo_import_batches

8 Lauko ir eilutės

Tabelle geo_import_batches

Feldname	Datymo tipas	Privalumas	Schlüssel	Įvairosios srities
`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 Lauko ir eilutės

Tabelle geo_places

Feldname	Datymo tipas	Privalumas	Schlüssel	Įvairosios srities
`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 Lauko ir eilutės

Tabelle logistics_cn23_declarations

Feldname	Datymo tipas	Privalumas	Schlüssel	Įvairosios srities
`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 Lauko ir eilutės

Tabelle logistics_export_consolidation_packages

Feldname	Datymo tipas	Privalumas	Schlüssel	Įvairosios srities
`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 Lauko ir eilutės

Tabelle logistics_export_consolidations

Feldname	Datymo tipas	Privalumas	Schlüssel	Įvairosios srities
`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 Lauko ir eilutės

Tabelle logistics_shipment_packages

Feldname	Datymo tipas	Privalumas	Schlüssel	Įvairosios srities
`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

69 Lauko ir eilutės

Tabelle logistics_shipments

Feldname	Datymo tipas	Privalumas	Schlüssel	Įvairosios srities
`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
`carrier_provider`	`VARCHAR(32)`	Nein	-	Feld carrier_provider
`carrier_booking_ref`	`VARCHAR(64)`	Nein	-	Feld carrier_booking_ref
`shipping_option_code`	`VARCHAR(64)`	Nein	-	Feld shipping_option_code
`label_document_id`	`UUID`	Nein	FK ➔ documents.id	Feld label_document_id
`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 Lauko ir eilutės

Tabelle logistics_tour_position_samples

Feldname	Datymo tipas	Privalumas	Schlüssel	Įvairosios srities
`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 Lauko ir eilutės

Tabelle logistics_tour_stop_photos

Feldname	Datymo tipas	Privalumas	Schlüssel	Įvairosios srities
`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 Lauko ir eilutės

Tabelle logistics_tour_stops

Feldname	Datymo tipas	Privalumas	Schlüssel	Įvairosios srities
`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 Lauko ir eilutės

Tabelle logistics_tours

Feldname	Datymo tipas	Privalumas	Schlüssel	Įvairosios srities
`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 Lauko ir eilutės

Tabelle logistics_vehicle_bay_loads

Feldname	Datymo tipas	Privalumas	Schlüssel	Įvairosios srities
`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 Lauko ir eilutės

Tabelle logistics_vehicle_load_bays

Feldname	Datymo tipas	Privalumas	Schlüssel	Įvairosios srities
`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

🔌 Įprastus punktai (UI ir API)

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

🛡️ Reguliariška ir atitiktis

Dieses Modul unterliegt folgenden gesetzlichen, regulatorischen und Revisionsstandards:

Įtraukiamumas
Kliento izolacija (PostgreSQL RLS)

Logistika ir krovinių siuntimas

⚡ Darbo srautai ir gyvenimo ciklai

Kliento užsakymas → Prekės išleidimas cascade:business.customer_order.fulfill

siuntimo dokumentas - visą perdirbimą cascade:business.delivery_note.intake

Atgavimo tvarkymas cascade:business.return_note.handling

Planuoti ekskursiją cascade_target:business.logistics.tour

Naudotojo nurodymas: logistikos turistas plan:command_logistics_tour_agent

Siuntymas status:logistics_shipment

Renginys status:logistics_tour

🗄️ Datybių modeliai ir laukiniai

🔌 Įprastus punktai (UI ir API)

🛡️ Reguliariška ir atitiktis

Kliento užsakymas → Prekės išleidimas `cascade:business.customer_order.fulfill`

siuntimo dokumentas - visą perdirbimą `cascade:business.delivery_note.intake`

Atgavimo tvarkymas `cascade:business.return_note.handling`

Planuoti ekskursiją `cascade_target:business.logistics.tour`

Naudotojo nurodymas: logistikos turistas `plan:command_logistics_tour_agent`

Siuntymas `status:logistics_shipment`

Renginys `status:logistics_tour`