# HAV Seafood — Logistics Outbound Fulfilment & Dispatch Framework

## Purpose

This workbook defines the static **outbound fulfilment and dispatch architecture** for HAV Seafood. It describes how a confirmed executable Sales order is structurally translated into eligible finished-goods stock, allocation/rotation, picking, handling-unit construction, dispatch staging, order consolidation and dispatch readiness.

It belongs to **Phase 1 — Business Architecture** and contains **rules, profiles and relationships rather than operational history**.

The core model is:

`Confirmed Sales Order -> Eligible Released Stock -> Allocation / Rotation -> Picking -> Handling Unit -> Dispatch Staging -> Consolidation -> Dispatch Readiness -> Future Shipment / Dispatch`

The preceding `hav_seafood_logistics_distribution_network_carrier_framework_v1.xlsx` remains authoritative for ship-to locations, outbound lanes, carriers and transport service classes.

## Architecture scope at a glance

- **24 active Production SKUs** referenced in the fulfilment layer;
- **73 Customer + SKU fulfilment relationships**, derived from existing Sales order rules and Logistics network assignments;
- **5 fulfilment profiles**, including one non-default controlled exception profile;
- **12 finished-goods storage-to-dispatch-staging mappings**;
- **11 inventory eligibility rules**;
- **5 rotation/allocation rules**;
- **6 synthetic internal remaining-shelf-life rules**;
- **5 picking-rule profiles**;
- **4 handling-unit types**;
- **6 pallet/loading rules**;
- **9 order-consolidation rules**;
- **15 dispatch-readiness requirements**.

## Key architecture decisions

### ERP warehouse execution

The existing System & Data Ownership Model explicitly assigns the following operational objects to **`ESYS-001 Core ERP`**:

- Inventory Movement;
- Inventory Balance / Stock Position;
- Warehouse Pick / Dispatch;
- Shipment / Dispatch Record.

No separate WMS is introduced. This workbook defines the static policy layer around those future ERP transactions.

### Existing Production storage is reused

Logistics does not create a second warehouse-location master. The workbook references existing Production-owned finished-goods, QA-hold and dispatch-staging locations, including the three regime-specific staging locations:

- `SL-DSP-CH` — Dispatch Staging - Chilled;
- `SL-DSP-FR` — Dispatch Staging - Frozen;
- `SL-DSP-AM` — Dispatch Staging - Ambient.

### Commercial versus physical fulfilment

Sales remains authoritative for the confirmed order and commercial permissions such as partial fulfilment, split shipment and allocation priority. Logistics owns the physical stock-selection, picking, staging and dispatch design.

### Quality boundary

Quality remains authoritative for technical release/hold decisions and release-blocking criteria. Logistics cannot make held or unreleased stock dispatch-eligible.

### Shelf-life thresholds

The workbook includes simple synthetic internal minimum remaining-shelf-life thresholds to make later fulfilment datasets coherent. These are **HAV Seafood architecture assumptions**, not customer contractual requirements, legal standards or market benchmarks.

## Workbook sheets

### `Architecture_Overview`
High-level purpose, counts, system boundary and architecture scope.

### `Fulfilment_Profiles`
Defines reusable chilled, short-life chilled, frozen, ambient and controlled-exception fulfilment profiles.

### `SKU_Fulfilment_Reference`
Derived SKU-centric reference joining Production SKU characteristics, case/pallet references, finished-goods storage, QA hold, dispatch staging, fulfilment profile, rotation rule, picking rule and shelf-life rule. Production remains authoritative for the underlying SKU, packaging, storage and quality data.

### `Storage_Dispatch_Map`
Defines the Logistics relationship from existing released finished-goods storage locations to the correct existing dispatch-staging stream.

### `Inventory_Eligibility_Rules`
Defines the conditions under which physical stock may enter outbound fulfilment.

### `Rotation_Allocation_Rules`
Defines FEFO/selection and allocation-protection logic.

### `Shelf_Life_Rules`
Defines internal minimum remaining-shelf-life thresholds at planned dispatch.

### `Picking_Rules`
Defines case/full-pallet picking, mixed-pallet principles, lot handling, verification and temperature-handling rules.

### `Handling_Unit_Types`
Defines shipping case, full homogeneous pallet, partial homogeneous pallet and mixed-SKU pallet types. These are types only, not actual handling-unit records.

### `Pallet_Loading_Rules`
Defines standard pallet build, partial pallet, mixed-SKU, temperature-compatibility, traceability and load-stability rules.

### `Order_Consolidation_Rules`
Defines when multiple future order lines may be physically grouped into the same shipment.

### `Customer_SKU_Fulfilment`
Derived 73-row bridge from existing Sales Customer + SKU relationships to ship-to, lane, service, fulfilment profile, storage, staging, rotation, picking and shelf-life architecture. This sheet is non-authoritative.

### `Dispatch_Readiness_Requirements`
Defines the blocking conditions that must be satisfied before physical dispatch. Actual checks, timestamps, approvers and exceptions belong to Phase 3.

### `Dispatch_Document_Requirements`
Reuses relevant requirements from the Distribution Network & Carrier Framework and clarifies the warehouse/dispatch action.

### `Position_Responsibility`
Maps Logistics, Sales, Quality, Production and warehouse responsibilities to existing HR positions.

### `System_Data_Mapping`
Maps fulfilment data/transactions to existing enterprise systems and preserves the existing system-of-record model.

### `Source_Precedence`
States which architecture wins for shared concepts.

### `Architecture_Notes`
Records boundaries and key design decisions.

### `Data_Dictionary`
Field-level reference across the workbook.

## Core ownership boundaries

- **Sales** — confirmed Sales orders, orderability, partial fulfilment, split shipment, allocation-priority classes and customer/commercial rules.
- **Production** — SKU identity, pack/case/pallet technical masters, finished-goods storage locations and technical storage characteristics.
- **Quality** — technical release/hold, product-integrity requirements and release-blocking criteria.
- **Logistics** — fulfilment profiles, physical eligibility rules, stock rotation/allocation execution, picking, staging, handling-unit rules, consolidation and dispatch readiness.
- **HR** — positions, position seats, incumbency and employee identity.
- **Shared Enterprise / System Ownership** — enterprise system identities and system/data authority.

## Operational data intentionally excluded

This workbook contains no actual:

- inventory balances or stock snapshots;
- reservations or allocations;
- pick lists or pick events;
- picked quantities;
- lot allocations;
- handling-unit IDs;
- pallet records or pallet-build events;
- staging events or timestamps;
- loading events;
- dispatch-readiness checklist completions;
- shipment IDs or shipment lines;
- dispatch dates/times;
- carrier bookings;
- loaded quantities;
- shortages, backorders or mis-picks;
- damaged pallets;
- dispatch delays;
- warehouse temperature readings.

These belong to Phase 3 after the business stories have been selected.

## Story neutrality

The architecture does not deliberately seed shortages, shelf-life failures, mis-picks, allocation conflicts, dispatch delays, Quality bypasses, damaged handling units, incorrect staging, missing documents or other operational outcomes.

## Recommended AI use

For fast context:

1. read this Markdown file;
2. inspect `Customer_SKU_Fulfilment` for a customer/product question;
3. inspect `SKU_Fulfilment_Reference` for a product/warehouse question;
4. inspect the relevant authoritative rule sheet;
5. consult the upstream Sales, Production, Quality or Network workbook when the underlying fact belongs outside Logistics.

## Source files used

- `hav_seafood_logistics_distribution_network_carrier_framework_v1.xlsx`
- `hav_seafood_sales_order_customer_service_framework_v1.xlsx`
- `seafood_products_skus_v1.xlsx`
- `seafood_storage_locations_v1.xlsx`
- `seafood_packaging_materials_v1.xlsx`
- `seafood_quality_food_safety_requirements_v1.xlsx`
- `hav_seafood_system_data_ownership_model_v1.xlsx`
- `hav_seafood_hr_reference_tables_v1.xlsx`
