Search Site
   

 
Friday, July 25, 2008 
  • Home
      SS Classic
      SS Professional
      Feature List
      Document List
  • Free Demo Version
  • Order
  • Services
  • Support
  • News
  • Int'l Trade Links
  • Newsletter
  • About Us
  • Contact Us
  • Privacy Policy
  • Sitemap

Shipping Solutions
A Division of
InterMart, Inc.

PO Box 22267
Eagan, MN 55122
PH: 651-905-1727
FX: 651-905-1827
E-Mail:
info@shipsolutions.com

 
 
 


The following two charts detail the Shipping Solutions Professional fields including names, types and sizes. As part of the integration process, you must map the data fields from your accounting system into one or more of the fields in Shipping Solutions Professional.

Header File | Line Item Detail File

Header File

Shipping Solutions Field Name Database Field Name Field Type Field Size Acceptable entry
HEADER LINKING FIELD linking_field N/A N/A Any field that ties to the line item file.  This must be the first column in the file and have the same field title as the line item linking field.
Exporter ID Number exp_id_num Text 50  
Exporter ID Type exp_id_type Text 1 E, S, or T
Exporter Name exp_name Text 50  
Exporter Address Line 1 exp_add_1 Text 50  
Exporter Address Line 2 exp_add_2 Text 50  
Exporter City exp_city Text 50  
Exporter State exp_state Text 2 Two digit state code
Exporter Country exp_country Text 2 Two digit country code
Exporter Postal Code exp_postal_code Text 50  
Exporter Phone exp_phone_num Text 14  
Exporter Fax exp_fax_num Text 14  
Exporter Email exp_email Text 50  
Exporter Officer First Name exp_officer_first_name Text 25  
Exporter Officer Last Name exp_officer_last_name Text 25  
Exporter Officer Title exp_officer_title Text 50  
Ultimate Consignee ID Number uc_id_num Text 50  
Ultimate Consignee Name uc_name Text 50  
Ultimate Consignee Address Line 1 uc_add_1 Text 50  
Ultimate Consignee Address Line 2 uc_add_2 Text 50  
Ultimate Consignee City uc_city Text 50  
Ultimate Consignee State uc_state Text 2 Two digit state code
Ultimate Consignee Country uc_country Text 2 Two digit country code
Ultimate Consignee Postal Code uc_postal_code Text 50  
Ultimate Consignee Contact Name uc_contact_name Text 50  
Ultimate Consignee Contact Title uc_contact_title Text 50  
Ultimate Consignee Phone uc_phone_num Text 14  
Intermediate Consignee ID Number ic_id_num Text 50  
Intermediate Consignee Name ic_name Text 50  
Intermediate Consignee Add Line 1 ic_add_1 Text 50  
Intermediate Consignee Add Line 2 ic_add_2 Text 50  
Intermediate Consignee City ic_city Text 30  
Intermediate Consignee State ic_state Text 2 Two digit state code
Intermediate Consignee Country ic_country Text 2 Two digit country code
Intermediate Consignee Postal Code ic_postal_code Text 30  
Intermediate Consignee Contact Name ic_contact_name Text 50  
Intermediate Consignee Contact Title ic_contact_title Text 50  
Intermediate Consignee Phone ic_phone_num Text 14  
Freight Forwarder ID Number ff_id_num Text 50  
Freight Forwarder Name ff_name Text 50  
Freight Forwarder Address Line 1 ff_add_1 Text 50  
Freight Forwarder Address Line 2 ff_add_2 Text 50  
Freight Forwarder City ff_city Text 30  
Freight Forwarder State ff_state Text 2 Two digit state code
Freight Forwarder Country ff_country Text 2 Two digit country code
Freight Forwarder Postal Code ff_postal_code Text 30  
Freight Forwarder Contact Name ff_contact_name Text 50  
Freight Forwarder Contact Title ff_contact_title Text 50  
Freight Forwarder Phone ff_phone_num Text 14  
Bill To Name bill_name Text 50  
Bill To  Address Line 1 bill_add_1 Text 50  
Bill To  Address Line 2 bill_add_2 Text 50  
Bill To City bill_city Text 30  
Bill To State bill_state Text 2 Two digit state code
Bill To Country bill_country Text 2 Two digit country code
Bill To Postal Code bill_postal_code Text 30  
Notify Name notify_name Text 50  
Notify Address Line 1 notify_add_1 Text 50  
Notify Address Line 2 notify_add_2 Text 50  
Notify Address City notify_city Text 50  
Notify Address State notify_state Text 2 Two digit state code
Notify Address Postal Code notify_postal_code Text 50 Two digit country code
Notify AddressCountry notify_country Text 2 Two digit country code
Commercial Invoice Date comm_inv_date Date/Time 8 mm/dd/yy
Commercial Invoice Number comm_inv_num Text 50  
Customer Account Number cust_acct_num Text 50  
PO Number po_num Text 100  
Proforma Invoice Number proforma_inv_num Text 50  
Proforma Invoice Date proforma_inv_date Date/Time 8 mm/dd/yy
Loading Pier / Terminal load_pier_terminal Text 50  
Order Number order_num Text 50  
Terms terms Text 50  
Commercial Invoice Phrase comm_inv_phrase Memo 500  
Proforma Invoice Phrase proforma_inv_phrase Memo 500  
Exporting Carrier exporting_carrier Text 50  
Exporting Carrier Code exporting_carrier_code Text 10  
Vessel Name vessel_name Text 50  
Inland Carrier inland_carrier Text 50  
Inland Carrier Code inland_carrier_code Text 10  
Inland Freight Fees inland_freight_fees Currency no limit  
Handling Fees handling_fees Currency no limit  
Consular Fees consular_fees Currency no limit  
Ocean / Air Fees ocean_air_fees Currency no limit  
Insurance Fees insurance_fees Currency no limit  
Other Fees other_fees Currency no limit  
Currency doc_currency Text 50  
Display Currency Flag disp_currency_flag Yes/No N/A True or False
Currency Rate doc_currency_rate Decimal/ Number no limit  
Incoterm incoterm Text 50 Three digit incoterm code
Incoterm Location inco_location Text 50  
Incoterm Year incoterm_year Text 50  
Port of Export port_of_export Text 50  
Port of Export Code port_of_export_code Text 10  
Related Parties Flag related_parties_flag Yes/No N/A True or False
ECCN (Paper Sed Only) eccn_consolidated Text 200  
Port of Unloading port_of_unloading Text 50  
Port of Unloading Code port_of_unloading_code Text 10  
Mode of Transport Code mode_of_transport_code Text 10  
Containerized Shipment Flag containerized_flag Yes/No N/A True or False
User Defined Shipment Number document_num Text 50  
Date of Export date_of_export Date/Time 8 mm/dd/yy
Bill of Lading Summary-Marks and Numbers marks_numbers Memo 500  
Combine Sched B Numbers (SED) combine_on_schb_flag Yes/No N/A True or False
Hazardous Shipment Flag hazard_shipment_flag Yes/No N/A True or False
Entry Number entry_number Text 50  
Inbond Code inbond_code Text 50  
Routed Export Flag routed_export_flag Yes/No N/A True or False
SED Exemption Statement aes_itn_num Text 50  
Shipment Reference Number shipment_ref_num Text 50  
Point of Origin point_of_origin Text 50  
UC / BL Address Selection select_uc_bl_address Text 10  
Select Int Consignee Flag select_ic_inv_address Text 10  
Bills of Lading Summary-Goods bills_of_lading_goods Memo 500  
Bills of Lading Summary-No. of packages bills_of_lading_pcs Memo 500  
Bills of Lading Summary-Weight bills_of_lading_weight Memo 500  
Bills of Lading Summary-Dims bills_of_lading_dims Memo 500  
SED/AES Shipment Ref Number cust_ship_ref_no Text 50  
Country of Ultimate Destination inv_user_defined_1 Text 50 This is pulling total in second currency.
Canada Customs Invoice Transportation cci_transportation Text 150  
Canada Customs Invoice Country of Transit cci_countryoftrans Text 50  
Canada Customs Invoice Origin cci_origin Text 30  
Canada Customs Invoice Condition of Sale cci_conditionofsale Text 150  
Canada Customs Invoice Currency of Settlement cci_currencyofsettlement Text 50  
Canada Customs Invoice Departmental Ruling cci_departmentalruling Text 50  
Canada Customs Invoice Other Reference cci_otherreferences Text 255  
Canada Customs Invoice Box 18 cci_18 Yes/No N/A True or False
Canada Customs Invoice Box 23i cci_23i Currency no limit  
Canada Customs Invoice Box 23ii cci_23ii Currency no limit  
Canada Customs Invoice Box 23iii cci_23iii Currency no limit  
Canada Customs Invoice Box 24i cci_24i Currency no limit  
Canada Customs Invoice Box 24ii cci_24ii Currency no limit  
Canada Customs Invoice Box 24iii cci_24iii Currency no limit  
Canada Customs Invoice Box 25i cci_25i Yes/No N/A True or False
Canada Customs Invoice Box 25ii cci_25ii Yes/No N/A True or False
Canada Customs Invoice Box 22 cci_22 Yes/No N/A True or False
Canada Customs Invoice Number of Pages cci_numpkgs Integer no limit  
Nafta Blanket From Date nafta_blanket_from_date Date/Time 8 mm/dd/yy
Nafta Blanket End Date nafta_blanket_to_date Date/Time 8 mm/dd/yy
Nafta HTS Display Digits nafta_hts_digits Integer no limit  
Nafta Date nafta_date Date/Time 8 mm/dd/yy
Nafta Producer ID Number prod_id_num Text 50  
Nafta Producer ID Type prod_id_type Text 1 E, S, or T
Nafta Producer Name prod_name Text 50  
Nafta Producer Address Line 1 prod_add_1 Text 50  
Nafta Producer Address Line 2 prod_add_2 Text 50  
Nafta Producer City prod_city Text 50  
Nafta Producer State prod_state Text 2 Two digit state code
Nafta Producer Country prod_country Text 2 Two digit country code
Nafta Producer Postal Code prod_postal_code Text 50  
Canada Customs Invoice Purchaser ID Number purch_id_num Text 50  
Canada Customs Invoice Purchaser ID Type purch_id_type Text 1 E, S, or T
Canada Customs Invoice Purchaser Name purch_name Text 50  
Canada Customs Invoice Purchaser Address Line 1 purch_add_1 Text 50  
Canada Customs Invoice Purchaser Address Line 2 purch_add_2 Text 50  
Canada Customs Invoice Purchaser City purch_city Text 50  
Canada Customs Invoice Purchaser State purch_state Text 2 Two digit state code
Canada Customs Invoice Purchaser Country purch_country Text 2 Two digit country code
Canada Customs Invoice Purchaser Postal Code purch_postal_code Text 50  
Canada Customs Invoice Originator ID Number orig_id_num Text 50  
Canada Customs Invoice Originator D Type orig_id_type Text 1 E, S, or T
Canada Customs Invoice Originator Name orig_name Text 50  
Canada Customs Invoice Originator Addr Line 1 orig_add_1 Text 50  
Canada Customs Invoice Originator Addr Line 2 orig_add_2 Text 50  
Canada Customs Invoice Originator City orig_city Text 50  
Canada Customs Invoice Originator State orig_state Text 2 Two digit state code
Canada Customs Invoice Originator Country orig_country Text 2 Two digit country code
Canada Customs Invoice Originator Postal Code orig_postal_code Text 50  
Canada Customs Invoice Exporter ID Number exp2_id_num Text 50  
Canada Customs Invoice Exporter ID Type exp2_id_type Text 1 E, S, or T
Canada Customs Invoice Exporter ID Name exp2_name Text 50  
Canada Customs Invoice Exporter ID Addr Line 1 exp2_add_1 Text 50  
Canada Customs Invoice Exporter ID Addr Line 2 exp2_add_2 Text 50  
Canada Customs Invoice Exporter ID City exp2_city Text 50  
Canada Customs Invoice Exporter ID State exp2_state Text 2 Two digit state code
Canada Customs Invoice Exporter ID Country exp2_country Text 2 Two digit country code
Canada Customs Invoice Exporter ID Postal Code exp2_postal_code Text 50  
Caricom Bank caricom_bank Text 35  
Caricom Terms caricom_terms Text 50  
Caricom Origin caricom_origin Text 35  
Caricom Gross Weight caricom_gross_wght Text 35  
Caricom Quantity Shipped caricom_qty_shipped Text 35  
Caricom Cubic Meters caricom_cubic_meters Text 10  
Caricom Certificate Number caricom_certificate_num Text 50  
Caricom Marks and Numbers caricom_marks_num Text 50  
Caricom Goods Description caricom_goods_desc Text 50  
Caricom Other References caricom_oth_refs Text 50  
Caricom B/L Number caricom_bl_num Text 30  
Caricom Packing caricom_packing Currency no limit  
Caricom Freight caricom_freight Currency no limit  
Caricom Insurance caricom_insurance Currency no limit  
Caricom Other Costs caricom_other_costs Currency no limit  
Certificate of Origing Stmnt cert_of_origin_stmnt Memo 500  
Nafta Certify Company certify_company Text 50  
Nafta Certify First Name certify_first_name Text 50  
Nafta Certify Last Name certify_last_name Text 50  
Nafta Certify Title certify_title Text 50  
Nafta Certify Phone certify_phone Text 50  
Nafta Certify Fax certify_fax Text 50  

 

Top of Page

Line Item Detail File

Shipping Solutions Field Name Database Field Name Field Type Field Size Acceptable entry
DETAIL LINKING FIELD linking_field N/A N/A Any field that ties to the header file.  This must be the first column in the file and have the same field title as the header linking field.
Product Id prod_id Text 50  
Product Description prod_desc Memo 500  
Schedule B Description schbdesc Memo 500  
Quantity quantity Decimal/ Numeric no limit  
SED Quantity 1 future_8 Long Integer no limit  
Sales Unit of Measure sales_unit_of_measure Text 25  
SED Unit of Measure 1 unit_of_measure_1 Text 3 Valid three digit SED code
SED Quantity 2 quantity_2 Long Integer no limit  
SED Unit of Measure 2 unit_of_measure_2 Text 3 Valid three digit SED code
Gross Weight sed_gross_weight Decimal/ Numeric no limit  
Unit Price unit_price Currency no limit  
Extended Price ext_price Currency no limit  
HTS Code/Schedule B Number hts_code Text 12 Number excluding periods
SED FAS Value sedFASVal Currency no limit  
License Type license_type Text 3 Valid three digit SED code
License Number license_num Text 25  
Domestic / Foreign Flag domestic_foreign_flag Text 1 D, F, or M
Nafta Producer nafta_producer Text 5 Yes, No1, No2 or No3
Preference Criteria preference_criteria Text 3 A,B,C,D1,D2,E,FA,or FB
Net Cost ( Nafta ) net_cost Text 15  
Nafta Country of Origin nafta_c_of_o Text 3 US, MX, CA, JNT
Include on SED Flag include_on_sed Yes/No 1 True or False
Net Weight NetWeight Decimal Numeric no limit  
ECCN ECCN Text 50  
AES Export Code aes_export_code Text 10 Valid two digit SED code
Country of Origin country_of_origin Text 2 Two digit country code
Country of Origin Long Name country_of_origin_fullname Text 50  
Vehicle Flag vehicle_flag Yes/No N/A True or False
Vehicle ID Number vehicle_id Text 50  
Vehicle Title vehicle_title Text 50  
Vehicle Title State vehicle_title_state Text 50 Two digit state code.
Include on Nafta Flag include_on_nafta Yes/No N/A True or False
Include on Cert of Origin Flag include_on_coforigin Yes/No N/A True or False
Bill of Lading Num of Packages bl_num_of_pkgs Long Integer no limit  
Inland B/L Hazardous Flag inlandbl_hazardous_flag Yes/No N/A True or False
Inland B/L Rate inlandbl_rate Text 50  

 

Top of Page | Go Back a Page
 
© 2008 Shipping Solutions - America's #1 Export Documentation Software - All rights reserved.

PO Box 22267 • Eagan, MN 55122 • PH: 651-905-1727 • FX: 651-905-1827 • E-Mail: info@shipsolutions.com