|
|
Kentucky
In order to import data into your account on HuskerOil.com,
your comma separated file (.csv) must contain these 22 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 or Consignor name (ex. Wildcat Trucking) |
| B | Carrier or Consignor number (9 digits, ex. 123456789) |
| C | Mode of transportation (1 letter, ex. J (truck), R (railroad)) |
| D | Origin city (ex. Lexington) |
| E | Origin state (2 letters, ex. KY) |
| F | Origin terminal# (9 characters, ex. T72KY2345 or 0) |
| G | Destination city (ex. Fairmont) |
| H | Destination state (2 letters, ex. TN) |
| I | Destination terminal# (9 characters, ex. T72KY2345 or 0) |
| J | Buyer name (ex. Kentucky Oil Inc.) |
| K | Buyer number (9 digits, ex. 123456789) |
| L | Seller or Position Holder name (ex. Kentucky Oil Inc.) |
| M | Seller or Position Holder number (9 digits, ex. 123456789) |
| N | Date (format M/D/YYYY, ex. 8/31/2010) |
| O | Document/Manifest number (up to 15 characters) |
| P | Product code (3 digits, include leading 0's, ex. 065) |
| Q | Net gallons (numeric, ex. 1500) |
| R | Gross gallons (numeric, ex. 1500, or 0) |
| S | Schedule code (up to 3 characters, ex. 5D) |
| T | Process this load with a different month (normally 0) |
| U | Beginning inventory (optional, schedule 15C only) |
| V | Ending inventory (optional, schedule 15C only) |
Example distributor manifest entry:
Wildcat Trucking,111111111,J,Lexington,KY,,,,T72KY2345,Kentucky Oil Inc.,987654321,,,03/24/2013,C22X410,065,1500,0,5D,0,, |
Example carrier manifest entry:
Acme Consignors,223344556,J,Lexington,KY,,Nashville,TN,,My Gas Co,444444444,,,03/24/2013,C22X411,065,1500,0,14,0,, |
Example terminal operator manifest entry:
Wildcat Trucking,111111111,J,,,,,,,My Gas Co,444444444,,,03/24/2013,C22X412,065,1500,0,15A,0,,
,,,,,,,,,,,,,03/24/2013,C22X413,065,,,15C,0,12000,9500 |
|
