Inventory ERD

Owned by Jeff Duke
Last updated: Jan 04, 2023
1 min read

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.