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 |
| LOT NO | Required | Enter Lot No. Accepts up to 15 alphanumeric characters. No spaces. Use only standard ASCII characters (no *,/, etc.) | B123456789 |
| MANUFACTURER’S LOT NO | Required | Manufacturer’s Lot No. Up to 30 alphanumeric characters. No spaces. Use only standard ASCII characters (no *,/, etc.) | VS123456789-23 |
| PRODUCT CODE | Required | Enter existing Product Code | JA-2010-345 |
| VENDOR CODE | Enter existing Vendor Code | VE103-2334 | |
| WAREHOUSE | Required | Enter existing Warehouse Code | 200 |
| QTY ON HAND | Required | Enter existing QOH | 15 |
| MFG DATE | Required | Enter Manufactured date in US date format MM/DD/YY | 8/1/18 |
| EXPIRY DATE | Required | Enter Expiry date in US date format MM/DD/YY | 8/1/20 |
| CERTIFICATE NO | Enter Lot certficate number | C123D456 | |
| NOTES | Notes related to the Lot or Certificate | Notes on Lot | |
| COMMENTS | Enter Lot Comments | A01-R01-S01-B02 | |
| ACTIVE? | Required | Enter Y or N. Default is Y | Y |