|
Michigan
In order to import data into your account on HuskerOil.com,
your comma separated file (.csv) must contain the first 18 items.
If delivering to a terminal, use columns 19 and 20 (columns S and T)
If the item is for amendment purposes, put 1 in column 21 (U).
Arrange your spreadsheet in the following format. Do not include column headers (descriptions) in your file.
A | Carrier name ( ex. Nebraska Trucking ) |
B | Carrier number ( 9 digits, ex. 470000000 ) |
C | Mode of transportation ( 1 letter, ex. J (truck), R (railroad)) |
D | Terminal number ( 9 characters, ex. T38MI1111, or leave blank) |
E | Destination state ( 2 letters, ex. NE ) |
F | Buyer or Seller name ( ex. Texas Oil Inc. ) |
G | Buyer or Seller FEIN or SSN ( 9 digits, ex. 470101010) |
H | Date ( format M/D/YYYY, ex. 8/31/2006 ) |
I | Document # ( up to 10 characters ) |
J | Net Gallons ( numeric, ex. 1500 ) |
K | Gross Gallons ( numeric, ex. 1500 ) |
L | Billed Gallons( numeric, ex. 1500 ) |
M | Terminal location ( ex. Sidney, if no terminal, leave blank) |
N | Originating state ( 2 letters, ex. NE ) |
O | Product code (include leading 0s, ex. 065, or E00 ) |
P | Schedule code ( Up to 3 characters, ex. 7A ) |
Q | Origin City (Supposedly optional, up to 25 characters) |
R | Destination City (Also supposedly optional, up to 25 characters) |
S | Destination Terminal number (no dashes, ex. T38MI2222, or leave blank) |
T | Destination Terminal Location (ex. Lansing, else leave blank) |
U | 1 if amended item, 0 or blank if original |
Example file:
TRUCKPROS,666666014,J,T38MI9999,SD,GASMANS,211111111,11/28/2007,5017,29100,29100,29100,DETROIT,MI,E00,7A,DETROIT,SIOUXLAND |
TRAINPROS,555555514,R,T38MI9999,TX,BUDDYS,222222222,11/29/2007,5018,29101,29101,29101,DETROIT,MI,E00,7A,, |
SHIPPROS,444444014,S,T38MI9999,AL,FRANKS,233333333,11/30/2007,5019,29100,29100,29100,DETROIT,MI,E00,7A,LANSING,PIXTOWN |
CARRIER,444444015,J,,AL,BOBS,233333334,11/30/2007,2222,29100,29100,29100,,MI,E00,7A,LANSING,PIXTOWN,T38MI2222,LANSING |
|
|