|
|
Missouri
In order to import data into your account on HuskerOil.com,
your comma separated file (.csv) must contain the first 16 columns
The last two columns (Q and R) are required only if delivering to a terminal.
Arrange your spreadsheet in the following format. Do not include column headers (descriptions) in your file.
| A | Carrier name ( ex. Showme Trucking ) |
| B | Carrier number ( 9 digits, ex. 470000000 ) |
| C | Mode of transportation ( 1 letter, ex. J (truck), R (railroad)) |
| D | Terminal number ( 9 characters, ex. T38MO1111, or leave blank) |
| E | Destination state ( 2 letters, ex. NE ) |
| F | Buyer or Seller name ( ex. MIZZOU Oil Inc. ) |
| G | Buyer or Seller FEIN or SSN ( 9 digits, ex. 470101010) |
| H | Date ( format M/D/YYYY, ex. 8/31/2006 ) |
| I | Document # ( up to 10 characters ) |
| J | Net Gallons ( numeric, ex. 1500 ) |
| K | Gross Gallons ( numeric, ex. 1500 ) |
| L | Billed Gallons( numeric, ex. 1500 ) |
| M | Terminal location ( ex. ST. LOUIS, if no terminal, leave blank) |
| N | Originating state ( 2 letters, ex. NE ) |
| O | Product code (include leading 0s, ex. 065) |
| P | Schedule code ( Up to 3 characters, ex. 2A ) |
| Q | Destination Terminal number (delivery TO terminal only) |
| R | Destination Terminal Location (delivery TO terminal only) |
Example file:
| CARRIER,234567890,J,T45MO1234,MO,BUYER,345678901,06/22/2008,666,1000,1001,1002,CARSON,TX,065,2A |
| CARRIER2,234567891,J,T45MO1234,MO,BUYER2,345678902,06/23/2008,777,2000,2001,2002,CARSON,TX,065,10J,T50MO1212,CARSON |
|
|
