📘

Þjónustu og flutning

logistics inventory_logistics 🛡️ RLS Protected

Logistika & flutning á vörum <unk> verkferlis- og API-gögn sem eru leitt úr kóða.

Fachliche Bestimmung: Logistics & Freight Shipping <unk> Process- og API-skjalagerð sem er leidd af kóða. Fær alla skráða ferli, getu, stöðuvélar, API og töflur fyrir lífræna og endurskoðun.

⚡ Starfsflæði og lífsstíl (7) 🗄️ Upplýsingarmyndir og sviði (13) 🔌 Upphafstaðir (UI og API) (90) 🛡️ Reglugerð og eftirfylgni

⚡ Starfsflæði og lífsstíl

Kundenauftrag → Abwicklung `cascade:business.customer_order.fulfill`

Hringur (sjá)

1. order

Verkaufsauftrag anlegen / bestätigen

sales

Aktionen: sales.create

2. issue

Bóka útgangur í útgáfu

tilskipun

Aktionen: stofn. issue.create

3. tour

Skipulag afhendingarferð

efnisfræðilega

Aktionen: create_tour

4. project

verkefni / tilskipta kostnaðarstöðvum

framkvæmdir

Aktionen: link_project

5. task

Útgjörir / úttekt

verkefni

Aktionen: create_task

Þraut á `cascade:business.delivery_note.intake`

Hringur (sjá)

1. stock

Í innkomum í innkomur í innkomur í innkomur í innkomur í innkomur í innkomur í innkomur í innkomur í innkomur í innkomur í innkomur í innkomur í innkomur í innkomur í innkomur í innkomur í innkomur í innkomur í innkomur í innkomur í innkomur í innkomur í innkomur í innkomur í innkomur í innkomur í innkomur í innkomur í innkomur í innkomur í innkom

tilskipun

Aktionen: post_goods_receipt

2. tour

Skipulag ferð / flutning

efnisfræðilega

Aktionen: create_tour

3. task

Skilyrði og samræmingur

verkefni

Aktionen: create_task

4. qc

Gæðakönnun í efnisburðarástandi

tilskipun

Aktionen: gæði.sjá.skapa

5. ticket

Skilningarstefnan fyrir galla

Miða

Aktionen: create_ticket

Tilflutningur `cascade:business.return_note.handling`

Hringur (sjá)

1. ticket

Tilboð til að taka inn

Miða

Aktionen: create_ticket

2. tour

Skipulag afhendingarferð

efnisfræðilega

Aktionen: create_tour

3. task

Framhald á endurgreiðslu

verkefni

Aktionen: create_task

Skipulag ferð / innheimtu `cascade_target:business.logistics.tour`

Hringur (sjá)

1. cascade

Skipulag ferð / innheimtu

Notendabeiðni: ferðaþjónusta `plan:command_logistics_tour_agent`

Geprüfter Durable-Plan (durable_plan), Start: 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

Útflutningur `status:logistics_shipment`

Áhersla er ekki þvingað <unk> sjá staðfestingu þjónustu.

1. draft

framkvæmd

Staða <unk>framleiðsla

2. planned

fyrirhugað

Staða <unk>planned<unk> af staðsetning vél sendingu.

3. picked_up

picked_up

Staða <unk>picked_up<unk> af staða vél sendingu.

4. in_transit

in_transit

Staða <unk>in_transit<unk> sendingar á staða vél.

5. delivered

afhending

Staða <unk>delivered<unk> á staða vél sendingu.

6. failed

ekki

Staða <unk> mislögð <unk> sendingar staða vél.

7. cancelled

aflýst

Staða sendingar á stöðugum vélum.

Ferða `status:logistics_tour`

Áhersla er ekki þvingað <unk> sjá staðfestingu þjónustu.

1. draft

framkvæmd

Staða áætlun á áætlun um áætlun.

2. planned

fyrirhugað

Staða áætlað

3. in_progress

in_progress

Staða á staða vélinni.

4. completed

fullgjört

Staða fullnægt

5. cancelled

aflýst

Staða aflýst.

🗄️ Upplýsingarmyndir og sviði

GeoImportBatches geo_import_batches

8 Fylgi / rammur

Tabelle geo_import_batches

Feldname	Upplýsingar	Þörf	Schlüssel	Sérfræðilegt þýði
`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 Fylgi / rammur

Tabelle geo_places

Feldname	Upplýsingar	Þörf	Schlüssel	Sérfræðilegt þýði
`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 Fylgi / rammur

Tabelle logistics_cn23_declarations

Feldname	Upplýsingar	Þörf	Schlüssel	Sérfræðilegt þýði
`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 Fylgi / rammur

Tabelle logistics_export_consolidation_packages

Feldname	Upplýsingar	Þörf	Schlüssel	Sérfræðilegt þýði
`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 Fylgi / rammur

Tabelle logistics_export_consolidations

Feldname	Upplýsingar	Þörf	Schlüssel	Sérfræðilegt þýði
`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 Fylgi / rammur

Tabelle logistics_shipment_packages

Feldname	Upplýsingar	Þörf	Schlüssel	Sérfræðilegt þýði
`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 Fylgi / rammur

Tabelle logistics_shipments

Feldname	Upplýsingar	Þörf	Schlüssel	Sérfræðilegt þýði
`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 Fylgi / rammur

Tabelle logistics_tour_position_samples

Feldname	Upplýsingar	Þörf	Schlüssel	Sérfræðilegt þýði
`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 Fylgi / rammur

Tabelle logistics_tour_stop_photos

Feldname	Upplýsingar	Þörf	Schlüssel	Sérfræðilegt þýði
`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 Fylgi / rammur

Tabelle logistics_tour_stops

Feldname	Upplýsingar	Þörf	Schlüssel	Sérfræðilegt þýði
`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 Fylgi / rammur

Tabelle logistics_tours

Feldname	Upplýsingar	Þörf	Schlüssel	Sérfræðilegt þýði
`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 Fylgi / rammur

Tabelle logistics_vehicle_bay_loads

Feldname	Upplýsingar	Þörf	Schlüssel	Sérfræðilegt þýði
`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 Fylgi / rammur

Tabelle logistics_vehicle_load_bays

Feldname	Upplýsingar	Þörf	Schlüssel	Sérfræðilegt þýði
`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

🔌 Upphafstaðir (UI og API)

Art	Aðferð	Endaskil / leið	Titel & Zweck	Tilréttaröðun
⚡ 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`	umfjöllun 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`	tilskipta Semantic binding: operator_surface; mutation=True	`logistics`
⚡ REST API	POST	`/api/v1/crossdock/{op_id}/cancel`	afnema Semantic binding: operator_surface; mutation=True	`logistics`
⚡ REST API	POST	`/api/v1/crossdock/{op_id}/dispatch`	afskipti 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`	áætlun Semantic binding: operator_surface; mutation=True	`logistics`
⚡ REST API	POST	`/api/v1/crossdock/{op_id}/putaway`	Fötu Semantic binding: operator_surface; mutation=True	`logistics`
⚡ REST API	POST	`/api/v1/crossdock/{op_id}/receive`	að taka 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`

🛡️ Reglugerð og eftirfylgni

Dieses Modul unterliegt folgenden gesetzlichen, regulatorischen und Revisionsstandards:

Gæðslu og efnismun
Þingþjónustuþjónusta (PostgreSQL RLS)

Þjónustu og flutning

⚡ Starfsflæði og lífsstíl

Kundenauftrag → Abwicklung cascade:business.customer_order.fulfill

Þraut á cascade:business.delivery_note.intake

Tilflutningur cascade:business.return_note.handling

Skipulag ferð / innheimtu cascade_target:business.logistics.tour

Notendabeiðni: ferðaþjónusta plan:command_logistics_tour_agent

Útflutningur status:logistics_shipment

Ferða status:logistics_tour

🗄️ Upplýsingarmyndir og sviði

🔌 Upphafstaðir (UI og API)

🛡️ Reglugerð og eftirfylgni

Kundenauftrag → Abwicklung `cascade:business.customer_order.fulfill`

Þraut á `cascade:business.delivery_note.intake`

Tilflutningur `cascade:business.return_note.handling`

Skipulag ferð / innheimtu `cascade_target:business.logistics.tour`

Notendabeiðni: ferðaþjónusta `plan:command_logistics_tour_agent`

Útflutningur `status:logistics_shipment`

Ferða `status:logistics_tour`