|
|
Indiana
In order to import data into your account on HuskerOil.com,
your comma separated file (.csv) must contain these 19 items.
Arrange your spreadsheet in the following format. Do not include column headers (descriptions) in your file.
| A | Document # (up to 10 characters) |
| B | Carrier name (ex. Big I Trucking) |
| C | Carrier number (9 digits, ex. 470000000) |
| D | Mode of transportation (1 letter, ex. J (truck), R (railroad)) |
| E | Originating state (2 letters, ex. IN) |
| F | Destination state (2 letters, ex. IL) |
| G | Name of Buyer(disbursements) or Seller(receipts) (ex. Hoosier Oil Inc.) |
| H | Buyer/Seller FEIN or SSN (9 digits, ex. 470101010) |
| I | Date (format M/D/YYYY, ex. 8/31/2008) |
| J | Net Gallons (numeric, ex. 1500) |
| K | Gross Gallons (numeric, ex. 1500) |
| L | Billed Gallons (numeric, ex. 1500) |
| M | Terminal number (9 characters, ex. T99IN1234, or leave blank) |
| N | Terminal location (ex. Indianapolis, if no terminal, leave blank) |
| O | Product code (include leading 0s, ex. 065) |
| P | Schedule code (Up to 3 characters, ex. 11E) |
| Q | Diversion Number (leave blank if not applicable) |
| R | Consignor name (ex. IN Oil Inc.) (diverted loads only, else leave blank) |
| S | Consignor FEIN or SSN (9 digits) (diverted loads only, else leave blank) |
Example file:
| 200,BIGRIG,123123123,J,TX,IN,JOES,345345345,8/31/2008,2001,2010,2001,T99IN1234,GARY,160,1,,, |
| 201,LITTLES,231231231,J,SD,IN,LUMPYS,453453451,8/28/2008,1800,1800,1800,,GARY,160,11,34567,TEXAS-OIL,567567567 |
|
Cost: $100 annually.
|
