Save a spreadsheet on your computer. Name it with the first 4 characters SUNF, and file type CSV(Comma delimited)(*.csv).
Put customer numbers in the left-most column.
Use a header row. Put CUST in the first cell.
Upload the file here.
| 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) |
| RO-PRICE-CD |
|
| NAME1 |
|
| ADDRESS |
|
| CITY |
|
| STATE |
the 2-character code |
| ZIP |
5 or 9 numeric |
| PHONE |
10 numeric |
| EMAIL |
valid email address |
|