Customers |
Warehouse Customers |
This table contains the list of customers who interact with the warehouse. |
View |
InventoryByLocation |
Inventory by Location |
This table tracks inventory quantities distributed across different warehouse locations |
View |
InventoryTransactions |
Inventory Transactions |
This table records all inventory movements, including additions and subtractions. |
View |
Locations |
Warehouse Locations |
This table details the various physical locations within the warehouse. |
View |
Products |
Product Details |
This table stores information about the products available in the warehouse. |
View |
PurchaseOrderDetails |
Purchase Order Details |
This table provides details for each purchase order, including items and quantities. |
View |
PurchaseOrders |
Purchase Orders |
This table lists all purchase orders made to suppliers. |
View |
Returns |
Returns |
This table tracks returned items from customers and their associated details. |
View |
SalesOrderDetails |
Sales Order Details |
This table contains details of each sales order, including product quantities and prices. |
View |
SalesOrders |
Sales Orders |
This table records all sales orders placed by customers. |
View |
Shipments |
Shipments |
This table logs details of shipments sent from the warehouse to customers or other locations. |
View |
Suppliers |
Suppliers |
This table lists the suppliers from whom products are purchased. |
View |