|
|
Kansas
In order to import data into your account on HuskerOil.com,
your comma separated file (.csv) must contain these 17 items.
Arrange your spreadsheet in the following format. Do not include column headers (descriptions) in your file.
| A | Carrier Name ( ex. BIG OIL TRADERS INC ) |
| B | Carrier FEIN ( 9 digit FEIN ) |
| C | Mode ( J for Truck, R for Rail, .etc ) |
| D | Origin City ( ex. Kansas City ) |
| E | Origin State ( ex. KS) |
| F | Destination City ( ex. Salina ) |
| G | Destination State ( ex. KS ) |
| H | Terminal location ( ex. Coffeyville, if no terminal, leave blank) |
| I | Terminal number ( 9 characters, ex. T48KS3660, or leave blank) |
| J | Seller/Buyer Name( ex. Big Oil Inc. ) |
| K | Seller/Buyer FEIN ( 9 digit FEIN) |
| L | Date ( M/D/YYYY format ) |
| M | Maninfest Number ( Bill of Lading, document number ) |
| N | Product code ( 3 characters ex. 065 or 160 ) |
| O | Net Gallons ( whole number, no commas ) |
| P | Gross Gallons ( whole number, no commas ) |
| Q | Schedule code ( Up to 3 characters, ex. 7 ) |
Example file:
| KARLS,111111111,J,TOPEKA,KS,WICHITA,KS,SALINA,T48KS1234,SHRIMPYS,222222222,3/15/2007,3333,065,2000,2002,7 |
| JETSONS,765432987,J,MADISON,KS,WICHITA,KS,,,BUDDYS,234535240,3/20/2007,3334,130,1000,1001,7 |
|
|
