📘

Логистичка и пратована пошаљења

logistics inventory_logistics 🛡️ RLS Protected

Логистичка и пратована испорука <unk> Процесна и API документација која је одведени из кода.

Fachliche Bestimmung: Логистика и пратована превоз <unk> Процесна и API документација која је одведени од кода.

⚡ Процес у области правног и животног циклуса (7) 🗄️ Модели података & поље (13) 🔌 Постапе почетка (УИ и АПИ) (85) 🛡️ Регулаторна политика и у складу

⚡ Процес у области правног и животног циклуса

Налог купца → Излазак производа `cascade:business.customer_order.fulfill`

Каскаде (review_gated).

1. issue

Уписање излаза као пројекта

Инвентар

Aktionen: Сток.испу.креати

2. tour

Планирање туре испоруке

Логистика

Aktionen: create_tour

3. project

projekat / додељивање трошкових места

Проекти

Aktionen: link_project

4. task

Укупни средства

задатке

Aktionen: create_task

otpremnica потпуна обрадања `cascade:business.delivery_note.intake`

Каскаде (review_gated).

1. stock

Улаз у _GT20_0__

Инвентар

Aktionen: post_goods_receipt

2. tour

Планирање тура / превоз

Логистика

Aktionen: create_tour

3. task

Проверка / упоређивање улаза производа

задатке

Aktionen: create_task

4. qc

Проверење квалитета у случају сумње на недостатак

Инвентар

Aktionen: квалитет.проверите.креати

5. ticket

Твилет за жалбе у случају недостатака

Билети

Aktionen: create_ticket

Обрадања повратака `cascade:business.return_note.handling`

Каскаде (review_gated).

1. ticket

Постављање пријаве

Билети

Aktionen: create_ticket

2. tour

Планирање турнеје за прикупљање

Логистика

Aktionen: create_tour

3. task

Продолжење обраде повратака

задатке

Aktionen: create_task

Планирање тура / подношења `cascade_target:business.logistics.tour`

Каскаде (review_gated).

1. cascade

Планирање тура / подношења

Упутство за употребу: логистички тур агент `plan:command_logistics_tour_agent`

Проверени трајни план (durable_plan), почетак: 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

Излазак `status:logistics_shipment`

Beobachtbare Zustandsmaschine (observable_only). Übergänge hier nicht erzwungen — siehe Service-Validierung.

1. draft

Проекти

Статус <unk>проекта <unk> статевичке машине.

2. planned

планирано

Статус <unk>планирана <unk> стан машина емисија.

3. picked_up

picked_up

Статус <unk>picked_up<unk> стан машине емисије.

4. in_transit

in_transit

Статус <unk>in_transit<unk> стан машине емисије.

5. delivered

Достављена

Статус <unk>достављен <unk> стан машине испоруке.

6. failed

неуспех

Статус <unk>непостигнута <unk> стан машине емисије.

7. cancelled

Смргнута

Статус <unk>отклана <unk> стан машине емисије.

Тур `status:logistics_tour`

Beobachtbare Zustandsmaschine (observable_only). Übergänge hier nicht erzwungen — siehe Service-Validierung.

1. draft

Проекти

Статус <unk>проект <unk> турнеје статемашине.

2. planned

планирано

Статус <unk>планована <unk> турнеја статусмашина.

3. in_progress

in_progress

Статус <unk>in_progress <unk> турнеје статемашине.

4. completed

Свршена

Статус <unk>површена <unk> турнеја статемашине.

5. cancelled

Смргнута

Статус <unk>отсечен <unk> турнеја статус машина.

🗄️ Модели података & поље

GeoImportBatches geo_import_batches

8 Половина

Tabelle geo_import_batches

Feldname	Тип података	Уговор	Schlüssel	Професионални значај
`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 Половина

Tabelle geo_places

Feldname	Тип података	Уговор	Schlüssel	Професионални значај
`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 Половина

Tabelle logistics_cn23_declarations

Feldname	Тип података	Уговор	Schlüssel	Професионални значај
`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 Половина

Tabelle logistics_export_consolidation_packages

Feldname	Тип података	Уговор	Schlüssel	Професионални значај
`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 Половина

Tabelle logistics_export_consolidations

Feldname	Тип података	Уговор	Schlüssel	Професионални значај
`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 Половина

Tabelle logistics_shipment_packages

Feldname	Тип података	Уговор	Schlüssel	Професионални значај
`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 Половина

Tabelle logistics_shipments

Feldname	Тип података	Уговор	Schlüssel	Професионални значај
`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 Половина

Tabelle logistics_tour_position_samples

Feldname	Тип података	Уговор	Schlüssel	Професионални значај
`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 Половина

Tabelle logistics_tour_stop_photos

Feldname	Тип података	Уговор	Schlüssel	Професионални значај
`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 Половина

Tabelle logistics_tour_stops

Feldname	Тип података	Уговор	Schlüssel	Професионални значај
`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 Половина

Tabelle logistics_tours

Feldname	Тип података	Уговор	Schlüssel	Професионални значај
`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 Половина

Tabelle logistics_vehicle_bay_loads

Feldname	Тип података	Уговор	Schlüssel	Професионални значај
`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 Половина

Tabelle logistics_vehicle_load_bays

Feldname	Тип података	Уговор	Schlüssel	Професионални значај
`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

🔌 Постапе почетка (УИ и АПИ)

Art	Метод	Крајна точка / пут	Titel & Zweck	Управовање
⚡ 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`	мета 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`	додељују Semantic binding: not_evaluated; mutation=True	`logistics`
⚡ REST API	POST	`/api/v1/crossdock/{op_id}/cancel`	одменити Semantic binding: not_evaluated; mutation=True	`logistics`
⚡ REST API	POST	`/api/v1/crossdock/{op_id}/dispatch`	диспетчери 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`	план Semantic binding: not_evaluated; mutation=True	`logistics`
⚡ REST API	POST	`/api/v1/crossdock/{op_id}/putaway`	поноса Semantic binding: not_evaluated; mutation=True	`logistics`
⚡ REST API	POST	`/api/v1/crossdock/{op_id}/receive`	Пријем 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`

🛡️ Регулаторна политика и у складу

Dieses Modul unterliegt folgenden gesetzlichen, regulatorischen und Revisionsstandards:

Укупност укупности
Изолација клијента (PostgreSQL RLS)

Логистичка и пратована пошаљења

⚡ Процес у области правног и животног циклуса

Налог купца → Излазак производа cascade:business.customer_order.fulfill

otpremnica потпуна обрадања cascade:business.delivery_note.intake

Обрадања повратака cascade:business.return_note.handling

Планирање тура / подношења cascade_target:business.logistics.tour

Упутство за употребу: логистички тур агент plan:command_logistics_tour_agent

Излазак status:logistics_shipment

Тур status:logistics_tour

🗄️ Модели података & поље

🔌 Постапе почетка (УИ и АПИ)

🛡️ Регулаторна политика и у складу

Налог купца → Излазак производа `cascade:business.customer_order.fulfill`

otpremnica потпуна обрадања `cascade:business.delivery_note.intake`

Обрадања повратака `cascade:business.return_note.handling`

Планирање тура / подношења `cascade_target:business.logistics.tour`

Упутство за употребу: логистички тур агент `plan:command_logistics_tour_agent`

Излазак `status:logistics_shipment`

Тур `status:logistics_tour`