|
|
Importing Option (Nebraska version)
In order to import data into your account on HuskerOil.com,
at a minimum, your comma separated file (.csv) must contain these items.
* Schedule code ( 1 or 2 digits, ex. 2 )
* Carrier name ( ex. Nebraska Trucking )
* Carrier number ( 9 digits, ex. 470000000 )
* Mode of transportation ( 1 letter, ex. J (truck), R (railroad))
* Originating state ( 2 letters, ex. NE )
* Destination state ( 2 letters, ex. NE )
* Terminal location ( ex. Sidney, if no terminal, leave blank)
* Terminal number ( 9 characters, ex. T47NE3604, or leave blank)
* Buyer or Seller name ( ex. Texas Oil Inc. )
* Buyer or Seller FEIN or SSN ( 9 digits, ex. 470101010)
* Date ( format YYYY/MM/DD preferred, ex. 2004/09/30 )
* Document # ( up to 10 characters )
* Gallons of product ( numeric, ex. 1500 )
* Product code (include leading 0s, ex. 065 )
Example file:
2,Petrol Movers,470000000,J,NE,NE,Sidney,T47NE3604,OilInc.,470101010,2004/09/30,00451,1500,065
5,My Trucking,470123450,J,NE,NE,,,Kwik Stop,471234567,2004/09/25,001,900,065
2,Petrol Movers,470000000,J,NE,NE,Sidney,T47NE3604,OilInc.,470101010,2004/09/21,00452,1500,124
Cost: $100 annually.
Send a test file with field definitions if you would like to
activate this feature.
Importing Option (Michigan version)
For Michigan, your comma separated file (.csv) must contain these 18 items in this specific order:
1 Carrier name ( ex. Nebraska Trucking )
2 Carrier number ( 9 digits, ex. 470000000 )
3 Mode of transportation ( 1 letter, ex. J (truck), R (railroad))
4 Terminal number ( 9 characters, ex. T38MI1111, or leave blank)
5 Destination state ( 2 letters, ex. NE )
6 Buyer or Seller name ( ex. Texas Oil Inc. )
7 Buyer or Seller FEIN or SSN ( 9 digits, ex. 470101010)
8 Date ( format M/D/YYYY, ex. 8/31/2006 )
9 Document # ( up to 10 characters )
10 Net Gallons ( numeric, ex. 1500 )
11 Gross Gallons ( numeric, ex. 1500 )
12 Billed Gallons( numeric, ex. 1500 )
13 Terminal location ( ex. Sidney, if no terminal, leave blank)
14 Originating state ( 2 letters, ex. NE )
15 Product code (include leading 0s, ex. 065, or E00 )
16 Schedule code ( Up to 3 characters, ex. 7A )
17 Origin City (Supposedly optional, up to 25 characters)
18 Destination City (Also supposedly optional, up to 25 characters)
19 Destination Terminal number (no dashes, ex. T38MI2222, or leave blank)
20 Destination Terminal Location (ex. Lansing, else leave blank)
Example file:
TRUCKPROS,666666014,J,T38MI9999,SD,GASMANS,211111111,11/28/2007,5017,29100,29100,29100,DETROIT,MI,E00,7A,DETROIT,SIOUX FALLS
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
MY CARRIER,444444015,J,,AL,BOB FOOD,233333334,11/30/2007,2222,29100,29100,29100,,MI,E00,7A,LANSING,PIXTOWN,T38MI2222,LANSING PIPE
Cost: $100 annually.
A test file will be needed.
Importing Option (Missouri version)
For Missouri, your comma separated file (.csv) must contain items 1-16 (use 17 and 18 only if delivering to terminal) items in this specific order:
1 Carrier name ( ex. Showme Trucking )
2 Carrier number ( 9 digits, ex. 470000000 )
3 Mode of transportation ( 1 letter, ex. J (truck), R (railroad))
4 Terminal number ( 9 characters, ex. T38MO1111, or leave blank)
5 Destination state ( 2 letters, ex. NE )
6 Buyer or Seller name ( ex. MIZZOU Oil Inc. )
7 Buyer or Seller FEIN or SSN ( 9 digits, ex. 470101010)
8 Date ( format M/D/YYYY, ex. 8/31/2006 )
9 Document # ( up to 10 characters )
10 Net Gallons ( numeric, ex. 1500 )
11 Gross Gallons ( numeric, ex. 1500 )
12 Billed Gallons( numeric, ex. 1500 )
13 Terminal location ( ex. ST. LOUIS, if no terminal, leave blank)
14 Originating state ( 2 letters, ex. NE )
15 Product code (include leading 0s, ex. 065)
16 Schedule code ( Up to 3 characters, ex. 2A )
17 Destination Terminal number (delivery TO terminal only)
18 Destination Terminal Location (delivery TO terminal only)
Example file:
SOME CARRIER,234567890,J,T45MO1234,MO,BUYER,345678901,06/22/2008,666,1000,1001,1002,CARSON,TX,065,2A
SOME CARRIER2,234567891,J,T45MO1234,MO,BUYER2,345678902,06/23/2008,777,2000,2001,2002,CARSON,TX,065,10J,T50MO1212,CARSON
Cost: $100 annually.
A test file will be needed.
Importing Option (Tennessee version)
For Tennessee, your comma separated file (.csv) must contain these 19 items in this specific order:
1 Carrier name ( ex. Elvis Trucking )
2 Carrier number ( 9 digits, ex. 470000000 )
3 Mode of transportation ( 1 letter, ex. J (truck), R (railroad))
4 Terminal number ( 9 characters, ex. T62TN1234, or leave blank)
5 Destination state ( 2 letters, ex. TN )
6 Buyer(or Consignor) name ( ex. Tennessee Oil Inc. ) (required for all disbursements and schedules 7A1,7B4,7E2, and all transporter schedules)
7 Buyer(or Consignor) FEIN or SSN ( 9 digits, ex. 470101010) (required for all disbursements and schedules 7A1,7B4,7E2, and all transporter schedules)
8 Date ( format M/D/YYYY, ex. 8/31/2006 )
9 Document # ( up to 10 characters )
10 Net Gallons ( numeric, ex. 1500 )
11 Gross Gallons ( numeric, ex. 1500 )
12 Billed Gallons( numeric, ex. 1500 )
13 Terminal location ( ex. Chattanooga, if no terminal, leave blank)
14 Originating state ( 2 letters, ex. TN )
15 Product code (include leading 0s, ex. 065)
16 Schedule code ( Up to 3 characters, ex. 11E )
17 Diversion Number (leave blank if not applicable)
18 Seller name ( ex. Tennessee Oil Inc. ) (required for all receipts and schedules 7A1,7B4,7E2, and all transporter schedules)
19 Seller FEIN or SSN ( 9 digits, ex. 470101010) (required for all receipts and schedules 7A1,7B4,7E2, and all transporter schedules)
Example file:
TRUCKPROS,666666014,J,T62TN9999,SD,GASMANS,211111111,3/1/2007,5017,29100,29100,29100,MEMPHIS,TN,065,11E,1234,,
TRAINPROS,555555514,R,T62TN9999,TX,BUDDYS,222222222,3/29/2007,5018,29101,29101,29101,MEMPHIS,TN,160,7A1,,BOBS,123456789
SHIPPROS,444444014,S,T62TN9999,AL,FRANKS,233333333,3/30/2007,5019,29100,29100,29100,MEMPHIS,TN,065,7B4,,LEFTYS,234567890
MAC FUEL,444444444,S,T62TN1111,AL,,,3/30/2007,5019,3000,3001,3000,MEMPHIS,TN,065,1,,BIG OIL,345678123
Cost: $100 annually.
A test file will be needed.
Importing Options South Carolina
South Carolina has two possible formats, depending on whether you are classified as a Supplier or a Transporter
I. Transporter version (Form 2176))
Your comma separated file (.csv) must contain these 20 items in this specific order:
1 Consignor Name ( ex. Carlina Consignors )
2 Consignor FEIN ( 9 digits, ex. 470000000)
3 Consignor City ( ex. Raleigh, if unkown leave blank)
4 Consignor ST( 2 characters, ex. SC)
5 Seller Name( ex. Big Oil Inc. )
6 Seller FEIN ( 9 digits, ex. 470000001)
7 Seller City ( ex. Raleigh, if unkown leave blank)
8 Seller ST( 2 characters, ex. SC)
9 Mode ( J for Truck, R for Rail, .etc )
10 Origin ( either 2 letter state or Terminal Number, ex. T57SC2001 )
11 Purchaser Name( ex. Big Oil Inc. )
12 Purchaser FEIN ( 9 digits, ex. 470000001)
13 Purchaser City ( ex. Raleigh, mandatory for Purchaser)
14 Purchaser ST( 2 characters, ex. SC, mandatory for Purchaser)
15 Date ( M/D/YYYY format )
16 Maninfest Number ( Bill of Lading, document number )
17 Gross Gallons ( whole number )
18 Net Gallons ( whole number )
19 Schedule code ( Up to 3 characters, ex. 14B )
20 Product code ( 3 characters ex. 065 )
Example file:
Bubbly Oil & Gas,561111111,Huskerboro,NC,BN Oil Company,341111111,Big City,NC,J,T56NC2020,R & R,579999999,Northtown,SC,12/1/2007,12345,2199,2181,14B,065
Bubbly Oil & Gas,561111111,Huskerboro,NC,BN Oil Company,341111111,Big City,NC,J,NC,R & R,579999999,Northtown,SC,12/2/2007,23456,3000,2999,14B,065
II. Supplier version (Form 2119))
Your comma separated file (.csv) must contain these 20 items in this specific order:
1 Carrier Name ( ex. Carlina Consignors )
2 Carrier FEIN ( 9 digits, ex. 470000000)
3 Unused (leave blank)
4 Unused (leave blank)
5 Seller/Buyer Name( ex. Big Oil Inc. )
6 Seller/Buyer FEIN ( 9 digits, ex. 470000001)
7 Seller/Buyer City ( ex. Raleigh, if unkown leave blank)
8 Seller/Buyer ST( 2 characters, ex. SC)
9 Mode ( J for Truck, R for Rail, .etc )
10 Origin ( either 2 letter state or Terminal Number, ex. T57SC2001 )
11 Destination State ( 2 letter state abreviation ex. SC )
12 Billed Gallons (if required, else 0)
13 Unused (leave blank)
14 Unused (leave blank)
15 Date ( M/D/YYYY format )
16 Maninfest Number ( Bill of Lading, document number )
17 Gross Gallons ( whole number )
18 Net Gallons ( whole number )
19 Schedule code ( Up to 3 characters, ex. 7A )
20 Product code ( 3 characters ex. 065 )
Example file:
SAMPLE CARRIER,561111111,,,SAMPLE BUYER,341111111,Big City,SC,J,SC,SC,2199,,,12/1/2007,12344,2200,2199,7A,065
SAMPLE CARRIER,561111111,,,SAMPLE SELLER,342222222,Little City,SC,J,T57SC2020,SC,2300,,,12/8/2007,12345,2305,2300,1,065
Cost: $100 (each state) annually for either the SC Transporter or Supplier Option.
A test file will be needed.
Importing Option (North Carolina Transporter version)
For North Carolina, your comma separated file (.csv) must contain these 20 items in this specific order:
1 Consignor Name ( ex. BIG OIL TRADERS INC )
2 Consignor FEIN ( IMPORTANT: 11 digit NC License or 9 digit FEIN if not NC licensed company)
3 Consignor City ( ex. Raleigh, if unkown leave blank)
4 Consignor ST( 2 characters, ex. SC)
5 Seller Name( ex. Big Oil Inc. )
6 Seller FEIN ( IMPORTANT: 11 digit NC License or 9 digit FEIN if not NC licensed company)
7 Seller City ( ex. Raleigh, if unkown leave blank)
8 Seller ST( 2 characters, ex. SC)
9 Mode ( J for Truck, R for Rail, .etc )
10 Origin ( either 2 letter state or Terminal Number, ex. T57SC2001 )
11 Purchaser Name( ex. Big Oil Inc. )
12 Purchaser FEIN ( IMPORTANT: 11 digit NC License or 9 digit FEIN if not NC licensed company)
13 Purchaser City ( ex. Raleigh, mandatory for Purchaser)
14 Purchaser ST( 2 characters, ex. SC, mandatory for Purchaser)
15 Date ( M/D/YYYY format )
16 Maninfest Number ( Bill of Lading, document number )
17 Gross Gallons ( whole number )
18 Net Gallons ( whole number )
19 Schedule code ( Up to 3 characters, ex. 14B )
20 Product code ( 3 characters ex. 065 )
Example file:
Bubbly Oil & Gas,561111111,Huskerboro,NC,BN Oil Company,341111111,Big City,NC,J,T56NC2020,R & R,579999999,Northtown,SC,12/1/2007,12345,2199,2181,14B,065
Bubbly Oil & Gas,561111111,Huskerboro,NC,BN Oil Company,341111111,Big City,NC,J,NC,R & R,579999999,Northtown,SC,12/2/2007,23456,3000,2999,14B,065
Cost: $100 (each state) annually.
A test file will be needed.
Importing Option (Arkansas Gasoline and Distillates (First Receivers and Importers))
For Arkansas, your comma separated file (.csv) must contain these 16 items in this specific order:
1 Carrier Name ( ex. BIG OIL TRADERS INC )
2 Carrier FEIN ( 9 digit FEIN )
3 Mode ( J for Truck, R for Rail, .etc )
4 Origin City ( ex. Little Rock )
5 Origin State ( ex. AR)
6 Destination City ( ex. Memphis )
7 Destination State ( ex. TN )
8 Terminal location ( ex. Little Rock, if no terminal, leave blank)
9 Terminal number ( 9 characters, ex. T62AR1234, or leave blank)
10 Seller/Buyer Name( ex. Big Oil Inc. )
11 Seller/Buyer FEIN ( 9 digit FEIN)
12 Date ( M/D/YYYY format )
13 Maninfest Number ( Bill of Lading, document number )
14 Product code ( 3 characters ex. 65 or 160 (no leading 0) )
15 Net Gallons ( whole number )
16 Schedule code ( Up to 3 characters, ex. 7 )
Example file:
Bobs Trucking,111111111,J,LITTLE ROCK,AR,MEMPHIS,TN,LITTLE ROCK PIPELINE,T22AR1234,SHRIMPYS,222222222,3/15/2007,3333,65,2000,7
JetWay Trucking,765432987,J,LITTLE ROCK,AR,NASHVILLE,TN,,,BUDDYS AIR,234535240,3/20/2007,3334,130,1000,10B
Cost: $100 (each state) annually.
A test file will be needed.
Importing Option (Kansas Monthly Return MF52))
For Kansas, your comma separated file (.csv) must contain these 17 items in this specific order:
1 Carrier Name ( ex. BIG OIL TRADERS INC )
2 Carrier FEIN ( 9 digit FEIN )
3 Mode ( J for Truck, R for Rail, .etc )
4 Origin City ( ex. Kansas City )
5 Origin State ( ex. KS)
6 Destination City ( ex. Salina )
7 Destination State ( ex. KS )
8 Terminal location ( ex. Coffeywville, if no terminal, leave blank)
9 Terminal number ( 9 characters, ex. T48KS3660, or leave blank)
10 Seller/Buyer Name( ex. Big Oil Inc. )
11 Seller/Buyer FEIN ( 9 digit FEIN)
12 Date ( M/D/YYYY format )
13 Maninfest Number ( Bill of Lading, document number )
14 Product code ( 3 characters ex. 065 or 160 )
15 Net Gallons ( whole number, no commas )
16 Gross Gallons ( whole number, no commas )
17 Schedule code ( Up to 3 characters, ex. 7 )
Example file:
KARLS CARRIER,111111111,J,KANSAS CITY,KS,WICHITA,KS,SALINA,T48KS1234,SHRIMPYS,222222222,3/15/2007,3333,065,2000,2002,7
JETSONS TRUCKING,765432987,J,MADISON,KS,WICHITA,KS,,,BUDDYS AIR,234535240,3/20/2007,3334,130,1000,1001,7
Cost: $100 (each state) annually.
A test file will be needed.
Importing Option (Indiana MF-360 and SF-900 ))
For Indiana, your comma separated file (.csv) must contain these 19 items in this specific order:
1 Document # (up to 10 characters)
2 Carrier name (ex. Big I Trucking)
3 Carrier number (9 digits, ex. 470000000)
4 Mode of transportation (1 letter, ex. J (truck), R (railroad))
5 Originating state (2 letters, ex. IN)
6 Destination state (2 letters, ex. IL)
7 Name of Buyer(disbursements) or Seller(receipts) (ex. Hoosier Oil Inc.)
8 Buyer/Seller FEIN or SSN (9 digits, ex. 470101010)
9 Date (format M/D/YYYY, ex. 8/31/2008)
10 Net Gallons (numeric, ex. 1500)
11 Gross Gallons (numeric, ex. 1500)
12 Billed Gallons (numeric, ex. 1500)
13 Terminal number (9 characters, ex. T99IN1234, or leave blank)
14 Terminal location (ex. Indianapolis, if no terminal, leave blank)
15 Product code (include leading 0s, ex. 065)
16 Schedule code (Up to 3 characters, ex. 11E)
17 Diversion Number (leave blank if not applicable)
18 Consignor name (ex. IN Oil Inc.) (diverted loads only, else leave blank)
19 Consignor FEIN or SSN (9 digits) (diverted loads only, else leave blank)
Example file:
200,BIG RIG TRUCKING,123123123,J,TX,IN,LITTLE JOES,345345345,8/31/2008,2001,2010,2001,T99IN1234,GARY,160,1,,,
201,LITTLE GUY TRUCKING,231231231,J,SD,IN,JOE OIL,453453451,8/28/2008,1800,1800,1800,,GARY,160,11,34567,TEXAS OIL,567567567
Cost: $100 (each state) annually.
A test file will be needed.
|
