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.