PARTS
part_no
N
Number
1
desc
C
Description
2
price
Price
3
CUSTOMER
cust_id
ID
lname
Last Name
fname
First Name
addr1
Address Line 1
4
addr2
Address Line 2
5
city
City
6
state
State
7
zip
Zip
8
SALESMEN
sm_code
Code
hired
D
Hire Date
comments
V
Comments
INVOICE
Customer ID
inv_no
date
Invoice Date
Salesman
LINEITEM
Invoice Number
line_no
Line Number
Part Number