Suppliers
| Supplier ID | Category | Name | Street Address | City | Postcode | Lead Time | Credit Limit | Credit Days | Amount Owed |
|---|
Customers
| ID | Registered Date | First Name | Surname | Street | Town | City | County | Postcode | Orders Placed | Total Spent | Last Order Date | Active |
|---|
Packaging
| Information | Quantity/Price per Pack | Stock | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Code | Type | Pack Size | size | Volume (mm3) | 1 | 2+ | 5+ | 10+ | Pallet | Pallet Size | Total Used | In stock |
Inventory
| Code | Supplier ID | SKU | Stock Units | Sold Units | Volume (mm) | Cost Price | Sale Price | Margin | Category | Pack | Date Added | ID |
|---|
Sales
| Date | Order ID | Customer ID | Items | Order Value | Package ID | Status |
|---|
Purchases
| Order ID | Order Date | Total | Status | Supplier ID | Due Date | Paid Date |
|---|
Invoices
| Order Date | Paid Date | Order number | Amount | Purpose | SupplierID |
|---|