| In order to import data into your account on HuskerOil.com, your comma separated file (.csv) must contain these 23 items. Arrange your spreadsheet in the following format. Do not include column headers (descriptions) in your file. Unused fields can be left blank. |
|
| A | Carrier name (ex. Tide Trucking) |
| B | Carrier number (9 digits, ex. 123456789) |
| C | Mode of transportation (1 letter, ex. J (truck), R (railroad)) |
| D | Originating state (2 letters, ex. AL) |
| E | Terminal# (9 characters, ex. T72AL2345, required for 15A, 15B, 15C) |
| F | Destination state (2 letters, ex. AL) |
| G | Buyer or Seller name (ex. Alabama Oil Inc.) |
| H | Buyer or Seller number (9 digits, ex. 123456789) |
| I | Date (format M/D/YYYY, ex. 8/31/2010) |
| J | Document/Manifest number (up to 10 characters) |
| K | Product code (include leading 0's, ex. 065) |
| L | Net gallons (numeric, ex. 1500) |
| M | Gross gallons (numeric, ex. 1500, or 0) |
| N | Schedule code (up to 3 characters, ex. 5A) |
| O | Consignor or Position Holder name (ex. Southern Oil) |
| P | Consignor or Position Holder number (9 digits, ex. 123456789) |
| Q | Process this load with a different month (normally 0) |
| R | DeliveredTo name (transporter report only) |
| S | DeliveredTo number (9 digits, transporter report only) |
| T | DeliveredTo address (no commas, transporter report only) |
| U | Supplier/Distributor Report Type (1st letter of report type - 'S','I','E') |
| V | Beginning Inventory (numeric, ex. 150000, schedule 15C only) |
| W | Gain/Loss (numeric, ex. 40000, schedule 15C only) |
| Example Supplier manifest entry: Tide Trucking,111111111,J,AL,T72AL2345,AL,Alabama Oil Inc.,987654321,09/24/2012,C22X410,065,1500,0,5A,,,0,,,,S,, |
|
| Example Importer manifest entry: Tide Trucking,111111111,J,AL,,TN,Tennessee Oil Inc.,987654321,09/24/2012,C99B,065,2500,0,1C,,,0,,,,I,, |
|
| Example Exporter manifest entry: Tide Trucking,111111111,J,FL,T54FL1234,AL,Alabama Oil Inc.,987654321,09/24/2012,C99B,160,2900,0,7B,,,0,,,,E,, |
|
| Example Transporter manifest entry: ,,J,AL,,AL,Alabama Oil Inc.,987654321,09/24/2012,99AA25,125,1700,0,14B,Southern Air,321456987,0,Levens Oil Co,445566778,123 Ripley Road Montgomey AL 36106,,, |
|
| Example Terminal Operator manifest entry: Tide Trucking,111111111,J,AL,T72AL2345,AL,,,09/24/2012,99AA25,125,1700,0,15A,Southern Air,321456987,0,,,,,, |
|