|
|
New Mexico
In order to import data into your account on HuskerOil.com,
your comma separated file (.csv) must contain these 16 items.
Arrange your spreadsheet in the following format. Do not include column headers (descriptions) in your file.
| A | Carrier Name ( ex. BIG OIL TRADERS INC ) |
| B | Carrier FEIN ( 9 digit FEIN ) |
| C | Mode ( J for Truck, R for Rail, .etc ) |
| D | Origin City ST ( ex. ALBUQUERQUE NM) |
| E | Destination City ST ( ex. SANTA FE NM ) |
| F | Terminal location ( ex. ALBUQUERQUE, if no terminal, leave blank) |
| G | Terminal # ( 9 characters, ex. T85NM1234, or leave blank) |
| H | Seller/Buyer Name( ex. Big Oil Inc. ) |
| I | Seller/Buyer FEIN ( 9 digit FEIN) |
| J | Date ( M/D/YYYY format ) |
| K | Maninfest Number ( Bill of Lading, document number ) |
| L | Product code ( 3 characters ex. 065 or 160) |
| M | Net Gallons ( whole number ) |
| N | Gross Gallons (whole number) |
| 0 | Schedule code ( Up to 3 characters, ex. 7 ) |
| P | Schedule 5A County Code( 5 digits, or leave blank) |
Example file:
| HAULIN-FUEL,650634856,J,AZTEC NM,DALLAS TX,,,ABC-FUEL,593232755,09/01/2010,1111,065,2525,2526,7,, |
| US,123456789,J,CABO NM,AZTEC NM,FUNCO,T85NM2014,N.M.C. ,593332703,09/02/2010,1112,065,7504,7504,5A,16218 |
|
|
