📘

Λογιστική και αποστολή εμπορευμάτων

logistics inventory_logistics 🛡️ RLS Protected

Λογιστική & αποστολή εμπορευμάτων <unk> Δοκumentaση διαδικασίας και API που προέρχεται από κώδικα.

Fachliche Bestimmung: Λογιστική & αποστολή εμπορευμάτων <unk> Δοκumentaση διαδικασίας και API που προέρχεται από κώδικα.

⚡ Διοργανωτικές ροές & κύκλοι ζωής (7) 🗄️ Πλαίσιο (13) 🔌 Πηγαίνοντας από την αρχή (90) 🛡️ Ρυθμιστική & συμμόρφωση

⚡ Διοργανωτικές ροές & κύκλοι ζωής

Τάχνη καταναλωτή → εξόδου `cascade:business.customer_order.fulfill`

Κασκατέ (review_gated).

1. issue

Κείμενο εγγραφής

Ινστιτούτο

Aktionen: stock.issue.create

2. tour

Προγραμματισμός της αποστολής

Υπηρεσίες

Aktionen: create_tour

3. project

Διοίκηση των δαπανών

Προγράμματα

Aktionen: link_project

4. task

Εξαγωγή / υπολογισμός

Επαγγελματικές

Aktionen: create_task

Πλήρης επεξεργασία `cascade:business.delivery_note.intake`

Κασκατέ (review_gated).

1. stock

Εισοδήματα προς τα καταστήματα αποθήκη

Ινστιτούτο

Aktionen: post_goods_receipt

2. tour

Σχεδιασμός τουρισμού / μεταφοράς

Υπηρεσίες

Aktionen: create_tour

3. task

Ελέγχση / συγκρίσιμο εισόδου

Επαγγελματικές

Aktionen: create_task

4. qc

Ελέγχος ποιότητας σε περίπτωση υποψίας ελαττώσεων

Ινστιτούτο

Aktionen: ποιότητα.check.create

5. ticket

Επαγγελματική επιταγή

Τickets

Aktionen: create_ticket

Επιστροφοποίηση `cascade:business.return_note.handling`

Κασκατέ (review_gated).

1. ticket

Πλήρωση εισιτηρίων για τις καταγγελίες

Τickets

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`

Επιστημονική μηχανή (απόκριτα).

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`

Επιστημονική μηχανή (απόκριτα).

1. draft

Κείμενο

Κράτος <unk>σχεδίου <unk> του Κράτους μηχανή tour.

2. planned

Προγραμματισμένη

Κράτος <unk>ετοιμαζόταν <unk> του Κράτους μηχανή tour.

3. in_progress

in_progress

Κράτος <unk>in_progress<unk> του περιήγησης μηχανής κατάστασης.

4. completed

Τελειώθηκε

Κράτος <unk> ολοκληρωμένη <unk> του Κράτους μηχανή tour.

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

69 Επισκόπηση

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
`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 Επισκόπηση

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: 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`	Μετα 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`	κατανομή Semantic binding: operator_surface; mutation=True	`logistics`
⚡ REST API	POST	`/api/v1/crossdock/{op_id}/cancel`	Κατανόηση Semantic binding: operator_surface; mutation=True	`logistics`
⚡ REST API	POST	`/api/v1/crossdock/{op_id}/dispatch`	διαβίβαση 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`	Σχέδιο Semantic binding: operator_surface; mutation=True	`logistics`
⚡ REST API	POST	`/api/v1/crossdock/{op_id}/putaway`	Πανδρείο Semantic binding: operator_surface; mutation=True	`logistics`
⚡ REST API	POST	`/api/v1/crossdock/{op_id}/receive`	Πληροφορίες 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`

🛡️ Ρυθμιστική & συμμόρφωση

Dieses Modul unterliegt folgenden gesetzlichen, regulatorischen und Revisionsstandards:

Διάλυση
Απομόνωση πελατών (PostgreSQL RLS)

Λογιστική και αποστολή εμπορευμάτων

⚡ Διοργανωτικές ροές & κύκλοι ζωής

Τάχνη καταναλωτή → εξόδου cascade:business.customer_order.fulfill

Πλήρης επεξεργασία 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`

Πλήρης επεξεργασία `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`