Accolent ERP data Import Template Instructions provide field-by-field information on the data needed to fill out the CSV templates. Always review these instructions before populating a CSV import template.
| Field Name | Required Field? | Field Data Instructions | Sample Data |
| PO NO | Required | 20 character maximum – no spaces. Use only standard ASCII characters (no *, /, etc.) | PO-2000 |
| PO DATE | Required | Enter Purchase Order date | 3/18/19 |
| VENDOR CODE | Required | Enter the exisiting Vendor Code for PO | VC-031 |
| CONTACT CODE | Enter existing contact code | 123 | |
| TERMS | Required | Enter existing Terms Code | 123 |
| SHIP VIA | Required | Enter existing Ship Via Code | 1 |
| ORDERED BY | Enter the Ordered By name | User Name | |
| WAREHOUSE CODE | Required | Enter the existing Warehouse Code | 100 |
| DEPARTMENT CODE | Required | Enter the existing Department Code | 1 |
| DROP SHIP CUSTOMER | Enter the Drop Ship Customer Code | ADS001 | |
| SHIP-TO CUSTOMER NAME | Required | Enter existing Warehouse Name | ADS Solutions |
| SHIP-TO ADDRESS LINE 1 | Shipping address line 1 | 10 Commercial Blvd | |
| SHIP-TO ADDRESS LINE 2 | Shipping address line 2 | Suite 208 | |
| SHIP-TO CITY | City | NOVATO | |
| SHIP-TO STATE | Enter existing State code | CA | |
| SHIP-TO ZIP CODE | Either use zip or zip+4 | 94945 | |
| SHIP-TO COUNTRY | Required | Enter existing Country code | USA |
| FOB CODE | Enter the FOB Code set up in the FOB table | DC0 | |
| ACKNOWLEDGE? | Is acknowledgement required? Enter Y or N | N | |
| CONFIRMING | Confirming? Enter Y or N | Y | |
| SPECIAL INSTRUCTIONS | Enter special instructions,if any | Special Instructions | |
| PO COMMENTS | Enter PO Comments, if any | Purchase Order comments |