Daily use
| Field Name | Data Type | Field Length | Description | Key | Sample |
| CustomerName | String | 15 | Name of Customer/Supplier | Thompson, Bob | |
| CustomerPhone | String | 15 | Phone of Customer/Supplier | (509) 555-1298 | |
| CustomerAddress | String | 45 | Address of Customer/Supplier | 1698 Mellowbrook Road | |
| CustomerState | String | 15 | State of Customer/Supplier | WA | |
| CustomerZip | Int | 9 | Zip of Customer/Supplier | 980045890 | |
| CustomerInventory | Int | 15 | Customer Inventory in Queue | 16 | |
| CustomerID | Int | 10 | Customer Primary Key | PK | 948920 |
| ProductName | String | 15 | Product Name | Hammer | |
| ProductCategory | String | 15 | Category of Product | Tools | |
| ProductID | Int | 30 | Primary Key for Product | FK | 5432 |
| ProductInventory | Int | 6 | Product Inventory in Warehouse | 32 | |
| CustomerAcct | Int | 15 | Customer Account Number | FK | 84392795 |
| PurchaseDate | Datetime | 8 | Date of Customer Purchase | FK | 12121986 |
| ShipDate | Datetime | 8 | Date of Customer Product Ship | FK | 12121986 |