# Procurement & Supply Chain Reference Tables

## Purpose

This workbook is the derived, AI-friendly navigation and joining layer for the static **Procurement & Supply Chain Architecture** of **HAV Seafood**.

It belongs to **Phase 1 — Business Architecture** and contains no operational or transactional history.

The workbook consolidates selected identifiers, labels, classifications and relationships from the authoritative Procurement & Supply Chain architecture so an AI system or human user can quickly understand how suppliers, items, sourcing, planning, inventory control, inbound logistics, receiving, governance, commercial structures and procurement controls connect.

**This workbook is derived and does not own master data. If any value conflicts with an authoritative source workbook, the authoritative source wins.**

## Current scope

The reference layer currently covers:

- **13 procurement suppliers**;
- **132 purchasable items**;
- **188 supplier-item sourcing relationships**;
- **8 supply-planning profiles**;
- **8 inventory-control profiles**;
- **18 static supplier inbound lanes**;
- **8 receiving profiles**;
- **19 procurement processes**.

These counts describe the current static architecture, not historical activity.

## Workbook sheets

### `Supplier_Reference`

One compact row per procurement supplier. Combines supplier classification, Shared Enterprise identity labels, governance profile, commercial profile, normal agreement structure, procurement ownership and the number of approved item-source relationships.

Use this sheet to answer questions such as **who the suppliers are, how important they are, and under what governance/commercial structure HAV Seafood normally works with them**.

### `Item_Sourcing_Reference`

One row per purchasable item. Combines procurement category, preferred supplier, source count, sourcing model, lead-time range, planning profile, inventory profile, primary storage location and normal receiving profile.

This is normally the best item-level starting point for AI analysis.

### `Supplier_Item_Sources`

One row per authoritative supplier-item sourcing relationship. Preserves the sourcing relationship ID and adds supplier/item labels plus the assigned inbound lane, transport profile, receiving profile and storage destination.

This is the main detailed join between **Procurement sourcing** and **Supply Chain inbound architecture**.

### `Planning_Inventory_Reference`

One row per purchasable item combining supply-planning and inventory-control classifications. Includes demand type, replenishment method, preferred source, lead time, planning responsibility, stock-control requirements, storage references and intended system.

### `Inbound_Receiving_Reference`

One row per supplier-item sourcing relationship showing the normal inbound lane and receiving structure: origin, destination, transport regime, delivery pattern, logistics partner where applicable, receiving controls, initial stock status and storage references.

No shipment or receipt events are represented.

### `Governance_Commercial_Reference`

One row per supplier summarizing governance assignment, technical-review requirements, commercial profile, agreement type, currency, provisional payment-term assumption, delivery/service terms, freight responsibility and commercial master system.

Finance- and Quality-owned structures remain subject to the ownership boundaries documented in the authoritative source workbook.

### `Process_Control_Reference`

One row per Procurement process. Summarizes process ownership, systems, approval architecture, segregation-of-duties requirements, authority levels, and counts of workflow steps, related controls and exception structures.

Detailed workflow steps and control rules remain in the authoritative Process & Control workbook.

### `Architecture_Relationships`

Explicit relationship catalog showing how the main Procurement & Supply Chain entities connect, including source and target keys, cardinality and the authoritative source workbook.

This sheet is intended specifically to help AI systems identify reliable joins rather than infer relationships from names alone.

### `Source_Register`

Lists the architecture workbooks used to create this derived reference layer, their role, whether they are authoritative, and when this workbook should be refreshed.

### `Data_Dictionary`

Provides field-level definitions, datatypes, key/reference roles, lineage and authoritative-source context for every sheet in this workbook.

## Authoritative sources

The Procurement & Supply Chain reference layer is derived primarily from:

1. `hav_seafood_procurement_supplier_sourcing_architecture_v1.xlsx`
2. `hav_seafood_procurement_supplier_governance_commercial_framework_v1.xlsx`
3. `hav_seafood_supply_planning_inventory_framework_v1.xlsx`
4. `hav_seafood_supply_chain_inbound_logistics_receiving_v1.xlsx`
5. `hav_seafood_procurement_process_control_framework_v1.xlsx`

It also uses `hav_seafood_shared_enterprise_reference_v1.xlsx` for compact shared labels and navigation. The Shared Enterprise reference workbook is itself derived; detailed authoritative Shared Enterprise workbooks prevail where precision is required.

## Main relationship paths

A useful supplier/item path is:

`External Organization -> Procurement Supplier -> Supplier-Item Source -> Enterprise Item`

`Supplier-Item Source -> Inbound Lane -> Receiving Profile -> Storage / Stock Status`

A useful item-control path is:

`Enterprise Item -> Procurement Category -> Planning Profile -> Inventory Control Profile -> Storage Location`

A useful governance path is:

`Supplier -> Governance Profile -> Qualification Requirements`

`Supplier -> Commercial Profile -> Agreement Type`

A useful process path is:

`Procurement Process -> Process Steps -> Approval Authority -> Control Rules / Exception Rules`

## Ownership boundaries

This workbook preserves the established domain boundaries:

- **Shared Enterprise** owns shared organization, item, system, department, location and identifier structures.
- **Procurement** owns supplier-specific procurement attributes, procurement categories, supplier-item sourcing, supplier governance/commercial structures and procurement process/control architecture.
- **Supply Chain** owns supply-planning policy, inventory-control policy, inbound lane architecture and receiving/putaway logic.
- **Production** remains authoritative for detailed technical material masters and detailed production storage structures.
- **Quality** remains authoritative for detailed supplier-quality evidence, technical acceptance criteria and quality-system records where assigned.
- **HR / Shared Enterprise authority structures** remain authoritative for roles, positions and approval-authority structures referenced by Procurement.
- **Finance** is expected to own enterprise financial approval thresholds, payment-term masters, inventory valuation and accounting structures when the Finance architecture is completed.

## Architecture boundary

This workbook intentionally contains **no operational history**, including no:

- purchase requisitions or purchase orders;
- RFQs, quotations or negotiations;
- actual supplier approvals or review events;
- signed agreements or price histories;
- forecasts, MRP runs or planned orders;
- inventory balances or movements;
- shipment bookings or transit events;
- goods receipts or receiving measurements;
- supplier performance results or scorecards;
- actual control exceptions or approval decisions.

Those belong to Phase 3 after the Phase 2 stories have been selected.

## Recommended AI usage

For fast Procurement & Supply Chain context:

1. Read the overall Procurement & Supply Chain README when available.
2. Inspect this reference workbook.
3. Use the relevant reference sheet to identify IDs and relationship paths.
4. Open the matching authoritative Procurement/Supply Chain workbook for precise rules or definitions.
5. Follow the Shared Enterprise, Production, Quality, HR or future Finance source where ownership crosses domain boundaries.

The reference workbook should be refreshed whenever any authoritative Procurement & Supply Chain architecture workbook changes.
