Wyoming
In order to import data into your account on HuskerOil.com,
your comma separated file (.csv) must contain these 20 (21-23 optional) items.
Arrange your spreadsheet in the following format. Do not include column headers (descriptions) in your file.
| A | Carrier Name |
| B | Carrier FEIN |
| C | Mode (J-Truck, R-Rail, P-Pipeline) |
| D | Origin City or County Code* (only for Wyoming Cities, and if no origin terminal, otherwise blank) IMPORTANT:Must use exact city spelling for cities, or 3 digit county code for counties. |
| E | Origin State |
| F | Destination City or County Code* (only for Wyoming Cities, otherwise blank) IMPORTANT:Must use exact city spelling for cities, or 3 digit county code for counties. You may also use the 4 digit code(ex. 01-01 for Casper) for destinations in WY. |
| G | Destination State |
| H | Terminal Name/Location (if applicable, ex. Sheridan ConocoPhillips) |
| I | Terminal Number (if above Terminal Name/Location (H) is indicated, ex. T83WY4050) The state will also allow the 4 digit code (ex. 03-04 for Sheridan) for origins in WY. |
| J | Seller Name (if receipt, else blank) |
| K | Seller Fein (if receipt and Seller name (J) , else blank) |
| L | Buyer Name (if disbursement, else blank) |
| M | Buyer FEIN (if disbursement and Buyer Name(L), else blank) |
| N | Date of transaction (M/D/YYYY format, ex. 12/01/2011) |
| O | Manifest Number (up to 10 characters) |
| P | Product code (choices 065,072,122,124,125,130,142,160,170,171,175,185,228,284, or 290) |
| Q | Net Gallons of Product (whole gallons) |
| R | Gross Gallons of Product (whole gallons) |
| S | Billed Gallons of Product(whole gallons) |
| T | Schedule Code (1A,2,2B,2C,2E ,5,5X,6,6B,7,or 7B) |
| U | Reporting Month (if transaction date of load is out-of-period, with which month would you like it to be processed, or leave blank) |
| V | Reporting Year (if transaction date of load is out-of-period, with which year would you like it to be processed, or leave blank) |
Example file:
|