|
|
New Mexico
In order to import data into your account on HuskerOil.com,
your comma separated file (.csv) must contain the first 16 items.
Rack operators schedules use columns Q and R.
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) |
| Q | leave blank or 0 |
| R | (optional) Rack operator schedule? (1 yes, 0 no) |
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 |
|
|
