Load FCL Rates

The FCL Rate spreadsheet template uses the format shown below:

The fields are described as follows:

• Carrier - This is the name of the ocean carrier or steamship line.
• SCAC *- The SCAC (Standard Carrier Abbreviation Code) code for the carrier. It is a 4-digit code used to uniquely identify carriers and their equipment.
• Contract Number - This is the contract number for the rates contract with the carrier.
• Commodity Code - Code from the rates contract that identifies the commodity applicable for the rate.
• Commodity Brief - Short description of the commodity applicable for the rate.
• Commodity Description * - Full description of the commodity applicable for the rate.
• Commodity Exclusions - List of any commodities that are excluded from the rate.
• PLOR * - Place of Receipt. This is the location where the carrier will take possession of the cargo. It could be a rail ramp or seaport. UNLOC code must be used.
• POL * - Port of Load. UNLOC code must be used.
• POD * - Port of Discharge. UNLOC code must be used.
• PLOD * - Place of Delivery. This is the location where the carrier will deliver the cargo. It could be a rail ramp or seaport. UNLOC code must be used.
• Transit Time - Enter the transit time as an integer for the number of days the shipment will take.
• Service Type
  • CY/CY - Container yard to container yard
• Incoterms - If the Tariff applies to a specific incoterm, then enter the incoterm here.
• Routed - Enter Yes or No. You can have different rates apply to routed and non-routed shipments.
• Effective Date * - Enter the date the rate will go into effect. Date format should be MM/DD/YYYY.
• Expiration Date * - Enter the date the rate will expire and become inactive. Date format should be MM/DD/YYYY.
• Charge Code * - Enter the charge code for the rate. This must be a valid charge code setup in the charge code maintenance screen.
• Charge Type *
  • 20 STD
  • 40 STD
  • 40 HC
  • 45 STD
• Rate * - Enter the rate. This must be numeric.

"*" indicates the field is required.

Navigation

• Click on the Application selector > Control Panel > Rates > Upload Rate File

The Rate Files Uploads screen will be displayed:

Steps

• Select the FCL toggle at the top of the screen.

Click in the Upload Rate File field

The Windows File Selector page will open:

• Use the Window File Selector to navigate through the folders and select the spreadsheet you want to upload. Press the Open button to complete your selection.

The selected file (spreadsheet) will appear in the Upload Rate File field.

• Click on the Upload icon to begin uploading the file.

The system will display a message if the file is uploaded successfully and ready to begin processing:

If the file could not be uploaded to begin processing, then an error message will be displayed.

Next, the system will create a record in the history section below. The record will show the status of "In Process".

• You can refresh the status by clicking on the Refresh button:

If the rates successfully loaded, then a "Uploaded successfully" message will appear on the screen:

and the file will show a "RATES LOADED" status in the record history section.

Dealing with Errors

If there was an error in the spreadsheet, then the file will show a "LOADING FAILED" status in the record history section.

Click on the "Click to see details" link to view the errors:

The errors in the spreadsheet will be displayed. The Field column will display the field/column in the spreadsheet that has an error. The Unexpected Value column will show the value for the field that has an error. The Affected Rows column will show each row that is affected with this error.

Please note there can be multiple pages of errors. You can scroll through pages using page navigation at the bottom of the page.