Both the Clippership Interface and the Connectship / WorldEase Interface use the same table in the NDS schema to contain the data for the shipping program. The information is copied to the table when the [Clippership] button is pressed in program OESC, Shipping Confirmation.
The following information is written to the table to be picked up by either the Clippership program or the Connectship / WorldEase program. Not all of these fields will be used by both interface programs.
Sales order number.
Sales order suffix.
Container number.
Order ship ID, which consists of the sales order number, sales order suffix, and container number combined and separated by periods.
Ship to address and attention line.
In order to be parsed out correctly, the ship to address zip component must NOT contain any embedded spaces. For example "Big City VA 99999-1000 USA" will parse correctly, but "Vancouver BC 9CH 4BG Canada" will produce an incorrect zip code for clipper. "Vancouver BC 9CH4BG Canada" would work correctly.
Ship to country.
The ship to country code length is determined by the setting of the Country Code Len pop-list in program SPSF, Ship Via Code Maintenance, for the ship via code assigned to the sales order. The Clippership Interface will look at the country code assigned to the sales order, and before sending the code to the clipper table, it will check the setting for the ship via code for the desired length. If the length is 2 characters, the 2 character code will be sent for the sales order's country code. If the length is 3 characters, the 3 character code will be sent for the sales order's country code.
Return name, address, zip code. See the Return Address to Clippership section for more information.
Terms code.
Ship Via code.
Invoice Ship Via code.
Total order amount.
Total number of containers.
Drop ship address, city, state, zip code, country.
Drop ship contact, phone number, and email address.
Oracle user ID.
Customer number.
Customer purchase order number.
Sold to recipient telephone number.
Sold to attention line.
Comment text for comments entered with type CLIP.
First sales representative.
3rd Party Billing flag.
3rd party account number.
3rd party account name.
3rd party account address, zip code, telephone phone number, and attention line. (Sold to recipient telephone number is the telephone number used. Sold to attention line is the 3rd party account attention line.)
Sales location.
Manifest location code (actual shipping plant code).
Residential flag.
Harmonized Code and Description. The copied harmonized code is that of the first line item to which a harmonized code is assigned. If the sales order is being shipped to Canada, it is the harmonized code assigned to the line item with the highest extended price.
COD Charge Includes Freight value. When set to 'Y', it indicates that the customer COD amount determined should include the freight in addition to the COD surcharge and order value. If set to 'N' then the customer COD amount should only be the COD surcharge plus the order value. Default value is 'Y' unless a negative value is returned by a custom procuser call.
Ship to contact email.
WorldEase flag.
WorldEase ID.
Importer of Record.
Importer of Record Account.
Hazmat flag.
The Clippership program and the Connectship/WorldEase program use the order ship ID to retrieve the information.
The following information is updated in program OESC, Shipping Confirmation, or program ARIE, One Step Invoice Entry.
Transaction date
Order Tracking information
Freight charges, not including COD charges
Weight of the container
COD charges: calculated as the net invoice amount - (COD miscellaneous code + freight charges)
If there is no drop ship address, the ship from location information will be used.
If the ship via code is not valid for the Clippership program or Connectship/WorldEase program, the order cannot be processed through the Clippership program or Connectship/WorldEase program.
For the Clippership program, the ship via code must be one that the Clippership program recognizes and that has the ClipperShip flag set to on in program SPSF, Ship Via Code Maintenance.
For the Connectship/WorldEase program, the ship via code must be one that the Connectship/WorldEase program recognizes and that has the WorldEase flag set to on in program SPSF, Ship Via Code Maintenance.
If the container is deleted from the Clippership program or the Connectship/WorldEase program, the tracking information, freight charges, weight field, and COD charges will all be deleted as well.
If COD charges are returned from the Clippership program or the Connectship/WorldEase program, the terms code for the sales order will be changed to COD.
If a third party account is used, no freight charges will be charged to the customer on Summary screen, but they will be recorded for each container on the Maintain Containers screen. For more information see the Third Party Shipping Accounts for Shipping Interfaces section.
When an invoice ship via code is assigned to the sales order's ship via code in program SPSF, Ship Via Code Maintenance, the invoice ship via code is also passed in. The rate charged to the company shipping the order is returned as the freight amount, and the amount to be charged to the customer is returned as the alternate freight amount. For more information, see program SPSF, Ship Via Code Maintenance.
Freight charges can be restricted from being charged to the customer for backorders from the Clippership interface or Connectship/WorldEase interface. The Bill B/O Freight flag in program ARLM, Location Maintenance, determines whether freight will be charged to the customers for backorders.
When the Bill B/O Freight flag is set to on, and a backorder is shipped using the Clippership interface or Connectship/WorldEase interface to determine freight charges, the freight charges will be copied to the container record and all container charges will be added up into the Freight Charges field of the Summary page. The freight cost for the sales order will also be updated.
When the Bill B/O Freight flag is set to off, and a backorder is shipped using the Clippership interface or Connectship/WorldEase interface to determine freight charges, the freight charges will be copied to the container record from the Clippership interface or Connectship/WorldEase interface. However, they will not be written to the Freight Charges field of the Summary page, so that the customer will not be charged for them. Freight charges can be entered manually. The freight cost for the sales order will also be updated.
Backorders are defined as sales orders with a suffix other than 0.
If the sales order is sent to the Clippership interface or Connectship/WorldEase interface after program OESJ, Sales Order End of Day and Journals, is run, the following actions will be taken.
No changes will be written to the sales order by the Clippership interface or Connectship/WorldEase interface at this point.
Any changes returned by the Clippership interface or Connectship/WorldEase interface will be written to the sales order tracking records for the order.
A POSTCLIP workflow record will be generated and sent to the person assigned to the workflow template in program WFWM, Workflow Template Maintenance.
Sales order information can be transferred to the Clippership Interface under the following conditions:
The Clippership Interface has been installed in your system.
The sales order has been shipped and is status J - Confirmed Incomplete, or status S - Confirmed Complete. The following programs ship sales orders:
OESC, Shipping Confirmation
ARIE, One-Step Invoice Entry
OESB, Sales Order Batch Shipping
OESX, Shipping Director
The ship via code for the sales order has the ClipperShip flag set to on in program SPSF, Ship Via Code Maintenance.
The containers created when shipping the sales order have a manifest location equal to the logged in plant. When shipping sales orders, only containers with a Manifest Location equal to the logged in plant will be sent to Clippership. This allows multi-plant sales orders to be shipped from the two separate physical locations.
For more information about the Clippership Interface, contact your NDS sales representative.
Sales order information can be transferred to the Connectship / WorldEase Interface under the following conditions:
The Connectship / WorldEase Interface has been installed in your system.
The sales order has been shipped and is status J - Confirmed Incomplete, or status S - Confirmed Complete. The following programs ship sales orders:
OESC, Shipping Confirmation
ARIE, One-Step Invoice Entry
OESB, Sales Order Batch Shipping
OESX, Shipping Director
The ship via code for the sales order has the WorldEase flag set to on in program SPSF, Ship Via Code Maintenance.
Set up the Hazardous Matl flag for items in program ICMM, Inventory Master Maintenance.
Assign the Importer ID and Importer of Record information to customers in program CMMM, Customer Master Maintenance. This information is defined originally in program IMPM, Importer Master Maintenance.
The containers created when shipping the sales order have a manifest location equal to the logged in plant. When shipping sales orders, only containers with a Manifest Location equal to the logged in plant will be sent to the Connectship / WorldEase Interface. This allows multi-plant sales orders to be shipped from the two separate physical locations.
For more information about the Connectship / WorldEase Interface, contact your NDS sales representative.
The return address written to the clipper table for the Clippership Interface or the Connectship/WorldEase Interface is determined by the setting of the Address Source pop-list in program SPMM, System Parameters/Default Maintenance.
Choices are:
Org Unit - Financial enterprise name and address from program GMEM, Enterprise Maintenance.
AR Location - Accounts receivable location name and address for the sales order location in program ARLM, Location Maintenance.
OEHEAD Customer - the sold to customer name and address from the sales order header.
OEHEAD Invoice To - the invoice to customer name and address from the sales order header.
OEHEAD Bill To - the bill to customer name and address from the sales order header.