Inventory ERD

Inventory Table - Record current inventory on hand group by all factors used to uniquely identify the physical product. ( Lot, Serial, Manufacturer, Serial, etc )

Inventory Transaction Table - logs all movement of inventory.

Types of transactions:

• PURCHASE_RECEIVING - increase of inventory from PO receiving action.
• TRANSFER_OUT - decrease of inventory from Inventory Transfer Request
• TRANSFER_IN - Increase of inventory from Inventory Transfer Request
• SOLD - decrease in Inventory from an inventory item being placed on a bill directly, not through CDM or Prescription. ( This record is created by the VetView API after the bill has been closed. )
• USED - decrease in Inventory from CDM or Prescription transaction. This record is recorded immediately on the CDM transaction or the Issuing of a Prescription.
• RECONCILIATION - increase or decease of inventory recorded from audit on the inventory reconciliation screen.
• PRODUCT_SETUP -  increase or decease of inventory recorded from manual changes of inventory from the product setup screen.