Ship Via Import using Edit w/Excel (SUV_EDIT)

The Ship Vias (ibis_suv) view allows you to define ship via codes which are assigned to customers or prospects in Customers (ibis_sucu.su13) view. You can also assign ship via codes to leads in the Lead Master (ibis_crmlead) views.

The code assigned to the customer/prospect becomes the default ship via code for quotes, sales orders and invoices for that customer/prospect. New shipping documents can be printed for selected ship via codes and sales can be reported by ship via code.

  • Note: If you are using TMS with Packing Station, you must set up and maintain the Ship Via TMS Carrier Mappings (ibis_su03) program. This program populates the TMS information displayed for the ship via code.

  • The TMS fields in the SU03 program are:

    • TMS Gateway
    • TMS Service Code
    • COD Required

Note: The ability to create and update information in the Ship Vias (ibis_suv) view is controlled by the permissions (create, read, update and delete) assigned to the resource within the role. This help topic assumes that you have the appropriate permissions to create and update records in Ship Via. For more information, see Role Master-Permissions.

The following list defines every field available in the ship vias (suv) table in alphabetical order:

  • Address 1 - enter the street and number associated with the ship via to a maximum of 30 characters.

  • Address 2 - enter additional address information such as unit number or rural route associated with the ship via to a maximum of 30 characters.

  • City - enter the city associated with the ship via to a maximum of 30 characters.

  • COD Required - this field is maintained in Ship Via TMS Carrier Mappings (ibis_su03) program. This field is used when TMS with Packing Station is set up in Pointforce. Valid values are: Yes and No. You cannot modify this field.

  • Company - the company field is available when you create a new ship via record. The company defaults to the company assigned to your user id in the Session Parameters view. You can change the default company during the ship via creation process only. Once the ship via record is created, the company to which the record is associated displays in the General section (at the top of the view).

  • Country - enter the country code associated with the ship via. This field is validated against the Countries (ibis_cccou) table.

  • Created By - displays the name of the user who created the record you are viewing or maintaining. May not be overridden.

  • Created On - displays the date on which the record that you are creating or maintaining was created. May not be overridden. May also represent the creation date of the records you are attempting to retrieve.

  • Description - enter a description of the ship via code. The description can be a maximum of 15 alpha numeric characters in length.

    • The ship via description prints on sales orders and invoices.

  • French Description - enter a French language description of the ship via code. The description can be a maximum of 15 alpha numeric characters in length.

  • Modification Counter - this field is not maintainable. The date and time the record was last modified.

  • Modified By - this field is not maintainable. The user or system process that last modified the record.

  • Modified On - this field is not maintainable. The date on which the record was last modified.

  • Name - enter the full name of the ship via code. The name can be a maximum of 30 alpha numeric characters in length.

  • Postal/Zip Code - enter the postal code or zip code for the ship via. For Canadian addresses, the postal code field automatically converts to upper Case. The postal code displays exactly as keyed, therefore be sure to enter the postal code with a space between the first group of 3 alpha numeric characters and the second group of 3 alpha numeric characters, for example H0H 0H0.

  • Province/State - enter or select from the look up the province or state. This field is validated against the States and Provinces (ibis_cccoustapro) table. Note: Once the province or state is entered, the country field automatically displays the associated country.

  • Service Level - from the drop list, select the transportation service level associated with the ship via. Valid options include:

    • 09 - Premium Surface
    • 3D - Three Day Service
    • AC - Air Cargo
    • AE - Air Economy
    • AM - A.M.
    • CE - Courier Express
    • CG - Ground
    • FC - First Class
    • G2 - Standard Service
    • ND - Next Day Air
    • NM - Next Morning
    • ON - Overnight
    • PB - Priority Mail
    • PM - PM
    • SA - Same Day
    • SC - Second Day Air
    • SE - Second Day
    • SG - Standard Ground
    • ST - Standard Class

  • Ship Via Code - enter a ship via code. The code can be a maximum of 3 alpha numeric characters in length. Once the record is created, you cannot modify this field.

  • Standard Carrier Alpha Code - enter the standard carrier alpha code (SCAC) for the transportation company associated with the ship via.

  • TMS Gateway - this field is maintained in Ship Via TMS Carrier Mappings (ibis_su03). When TMS with Packing Station is set up in PointForce, this field is set to TECSYS TMS. If TMS with Packing Station is not set up, this field is set to None. You cannot modify this field.

  • TMS Service Code - this field is maintained in Ship Via TMS Carrier Mappings (ibis_su03). This field displays the service code associated with the service used by TMS. This field is only populated when TMS with Packing Station is set up in PointForce. You cannot modify this field.

  • Transportation Method - from the drop list, select the transportation method associated with the ship via. Valid options include:

    • A - Air
    • C - Consolidation
    • D - Parcel Post
    • H - Customer Pickup
    • M - Motor
    • P - Private Carrier
    • R - Rail
    • S - Ocean
    • T - Best Way (Shippers Option)
    • U - Private Parcel

For the functionality of each action (i.e. button) available on this view, refer to the About the Actions topic.