|
North Carolina
In order to import data into your account on HuskerOil.com,
your comma separated file (.csv) must contain these 20 items. (Column U is optional)
Arrange your spreadsheet in the following format. Do not include column headers (descriptions) in your file.
TRANSPORTERS (GAS-1301)
A | Consignor Name ( ex. BIG OIL TRADERS INC ) |
B | Consignor FEIN ( IMPORTANT: 11 digit NC License or 9 digit FEIN if not NC licensed company) |
C | Consignor City ( ex. Raleigh, if unkown leave blank) |
D | Consignor ST( 2 characters, ex. SC) |
E | Seller Name( ex. Big Oil Inc. ) |
F | Seller FEIN ( IMPORTANT: 11 digit NC License or 9 digit FEIN if not NC licensed company) |
G | Seller City ( ex. Raleigh, if unkown leave blank) |
H | Seller ST( 2 characters, ex. SC) |
I | Mode ( J for Truck, R for Rail, .etc ) |
J | Origin ( either 2 letter state or Terminal Number, ex. T57SC2001 ) |
K | Purchaser Name( ex. Big Oil Inc. ) |
L | Purchaser FEIN ( IMPORTANT: 11 digit NC License or 9 digit FEIN if not NC licensed company) |
M | Purchaser City ( ex. Raleigh, mandatory for Purchaser) |
N | Purchaser ST( 2 characters, ex. SC, mandatory for Purchaser) |
O | Date ( M/D/YYYY format ) |
P | Maninfest Number ( Bill of Lading, document number ) |
Q | Gross Gallons ( whole number ) |
R | Net Gallons ( whole number ) |
S | Schedule code ( Up to 3 characters, ex. 14B ) |
T | Product code ( 3 characters ex. 065 ) |
U | Is this an amending item?(1 if yes, 0 if no) |
Example file:
HUSKYS,561111111,Huskerboro,NC,B&N,341111111,Bigtown,NC,J,T56NC2020,R&R,579999999,Northtown,SC,12/1/2007,12345,2199,2181,14B,065 |
HUSKYS,561111111,Huskerboro,NC,B&N,341111111,Bigtown,NC,J,NC,R&R,579999999,Northtown,SC,12/2/2007,23456,3000,2999,14B,065 |
|
SUPPLIERS (GAS-1202)
A | Carrier Name ( ex. BIG OIL TRADERS INC ) |
B | Carrier FEIN ( IMPORTANT: 11 digit NC License or 9 digit FEIN if not NC licensed company) |
C | Schedule code (up to 3 characters ex. 1, 5A) |
D | Product code (3 characters ex. 065, 160) |
E | Seller Name( ex. Big Oil Inc., receipts only ) |
F | Seller FEIN ( IMPORTANT: 11 digit NC License or 9 digit FEIN, receipts only ) |
G | Origin City ( ex. Raleigh, mandatory if no origin terminal) |
H | Origin State ST( 2 characters, ex. SC) |
I | Mode ( J for Truck, R for Rail, .etc ) |
J | Origin Terminal(if applicable, terminal number, ex. T57NC2001 ) |
K | Purchaser Name( ex. Big Oil Inc. disbursements only ) |
L | Purchaser FEIN ( IMPORTANT: 11 digit NC License or 9 digit FEIN, disbursements only) |
M | Destination City ( ex. Raleigh, mandatory if no destination terminal) |
N | Destination State( 2 characters, ex. NC, mandatory for Purchaser) |
O | Date ( M/D/YYYY format ) |
P | Manifest Number ( Bill of Lading, document number ) |
Q | Gross Gallons ( whole number ) |
R | Net Gallons ( whole number ) |
S | Billed Gallons (whole number) |
T | Destination Terminal (if applicable) |
U | Is this an amending item?(1 if yes, 0 if no) |
Example file:
HUSKYS CARRIERS,561111111,1,065,BIG OIL,12323445601,CHARLOTTE,NC,J,T99NC1234,,,RALEIGH,NC,08/12/2012,90111,2700,2701,2700,,0 |
HUSKYS CARRIERS,561111111,5A,065,,,RALEIGH,NC,J,,BOBS GETNGO,345345512301,CHARLOTTE,NC,08/14/2012,90112,800,800,800,,0 |
|
|