Data Flows

Operational LOBs (Front-Office)

Commercial Aviation Systems

Defense Systems

Space Systems

Research and Development

Support LOBs (Back-Office)

Finance and Administration

Technology Support

Contracts and Legal

Shipping and Receiving

KHA Warehouse Inventory System ERD

Item	Description
	The arrows always point towards the parent table where the originating PK came from
Bolded Text	NOT NULL – required value
Un-Bolded Text	Needed, but not always required.
PK	Primary Key – unique key identifying the table
FK	Foreign Key – A value used to link other data to the parent

The tracking table shares keys from the serialized and non-serialized items tables. Neither is required. The quantities field is for the non-serialized items only. The inventory view is used to consolidate all inventory items. The daily view is used as a data mart for inventory metrics.

KHA Warehouse Inventory System Process Flow

The supplier makes the part and ships it to the warehouse. The employees receive the items and record the items and their quantities into the system. The items quantities are added to the totals, and the location and status are changed. When the items are picked, the quantities are subtracted and the status changes. Every move is tracked. The employee’s ID is stored with every change in status along with the quantities of the items involved for accountability purposes.