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 fi
le. Unused fields can be left blank. |
| A | Carrier name (ex. Big Sky Trucking) |
| B | Carrier number (9 digits, ex. 123456789) |
| C | Mode of transportation (1 letter, ex. J (truck), R (railroad)) |
| D | Originating city (up to 18 letters, ex. BILLINGS) |
| E | Originating state (2 letters, ex. MT) |
| F | Originating terminal (9 characters, ex. T81MT4000, or leave blank) |
| G | Destination city (up to 18 letters, ex. HELENA) |
| H | Destination state (2 letters, ex. MT) |
| I | Destination terminal (9 characters, ex. T81MT4008, or leave blank) |
| J | Buyer or Seller name (ex. Montana Oil Inc.) |
| K | Buyer or Seller number (9 digits, ex. 123456789) |
| L | Date (format M/D/YYYY, ex. 7/31/2012) |
| M | Document/Manifest number (up to 10 characters) |
| N | Product code (include leading 0's, ex. 065) |
| O | Net gallons (numeric, ex. 1500) |
| P | Gross gallons (numeric, ex. 1500, or 0) |
| Q | Billed gallons (numeric, ex. 1500, or 0) |
| R | Schedule code (up to 3 characters, ex. 5A) |
| S | Process this load with a different month (normally 0) |
Example manifest entry:
Big Sky Trucking,111111111,J,BILLINGS,MT,T81MT4000,HELENA,MT,,Montana Oil Inc.,987
654321,07/24/2012,C22X410,065,1500,0,1500,2A,0 |
