|
|
Virginia
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.
| 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. BILOXI ) |
| E | Origin State ( ex. MS) |
| F | Origin Zip ( ex. 91250, will be filled with 00000 if left blank) |
| G | Destination City ( ex. JACKSON ) |
| H | Destination State ( ex. TN ) |
| I | Destination Zip ( ex. 91250, will be filled with 00000 if left blank) |
| J | Origin Terminal ( 9 characters, ex. T99VA1234, or leave blank) |
| K | Destination Terminal ( 9 characters, ex. T99VA1234, or leave blank) |
| L | Buyer/DeliveredTo Name( ex. Big Oil Inc. ) |
| M | Buyer/DeliveredTo FEIN ( 9 digit FEIN) |
| N | Consignor Name( ex. Consginors Inc. ) |
| O | Consignor FEIN ( 9 digit FEIN) |
| P | Date ( M/D/YYYY format ) |
| Q | Maninfest Number ( Bill of Lading, document number ) |
| R | Product code ( up to 3 characters ex. 65 or 160 (no leading 0) ) |
| S | Net Gallons ( whole number ) |
| T | Gross Gallons ( whole number ) |
| U | Schedule code ( Up to 3 characters, ex. 14A or 14C ) |
| V | Amending Item? ( 1 for yes, 0 for no ) |
Example file:
| Billy's Trucking,333555666,J,Beloit,WI,,Richmond,VA,91280,T99WI1234,,DICKS OIL,999000999,Big Oil Bros.,222555666,05/22/2014,9922,65,999,1000,14B,0 |
| Billy's Trucking,333555666,J,Richmond,VA,91280,Toledo,OH,,,,DICKS OIL,999000999,Big Oil Bros.,222555666,05/23/2014,9923,65,300,301,14A,1 |
|
|
