Save a spreadsheet on your Windows desktop. Save it as SUNF.xls.
Put customer numbers in the left-most column.
Use a header row. Put CUST in the first cell.
| HEADERS
| SPREADSHEET VALUES
|
| CUST |
|
| PARTS-CUST |
P or DEL |
| PARTS-CUST-TYPE |
W or DEL |
| SHIP-VIA |
|
| SALE-TYPE |
|
| PRICE-CD |
|
| TAXABLE |
Y or N |
| TAX-EXEMPT-NO |
|
| FORD-COMP |
A,B,G,I,J,R,W,X,Y |
| CHRY-COMP |
Any 5 numbers = Fleet (for example, 5555)
Any 2 letters followed by 3 numbers = fleet (for example, AA555)
Any single number = comp customer (normal) |
|