What is this?
This tool saves you time on shipments that have the same Origin, Destination, Commodity, Shipper, Consignee etc. All information in the body of the Shipping Instructions pattern will be repeated in each bill of lading. The only information that can be different is what you enter into the Speed Bill block. For example, Equipment Initial & Number, Weight, Shipment ID.
To speed up entry of information, try Upload or Copy/Paste.
When is it used?
The Speed Bill block should be used when you want to submit multiple equipment IDs in one Shipping Instruction but create individual waybills for each equipment.
To add the Speed Bill block to your pattern, select the "Speed Bill" checkbox within the Pattern Manager.
Information available
The following information can be provided in this block:
| Equipment IDs (droplist) |
Required |
Indicates the maximum number of Equipment IDs that can be entered in the Speed Bill shipment (controls the number of input rows that are displayed on the page).
Note: If using Upload or Copy/Paste, when the number of Equipment IDs contained in the upload file or pasted from your clipboard exceeds the number in this droplist, the limit will automatically be increased so that none of the data in the upload file or pasted data is lost.
|
| Equipment List |
Optional |
Clicking the Equipment List button will display all Equipment available at your facility on specific tracks and allow you to select which pieces of equipment you want to send shipping instructions for. If you require access to Equipment List, please contact eBusiness Support. |
| Copy/Paste |
Optional |
Allows you to paste multiple Equipment IDs from your system's clipboard. |
| Upload |
Optional |
Allows you to upload a file from your system, containing the details for your entire Speed Bill shipment. |
| Equipment Initial |
Required |
The initials stenciled on the side of the equipment.
You do not need to repeat the Equipment Initials for the next car if they are the same as the previous one. The information will automatically be carried down.
|
| Equipment Number |
Required |
The numbers stenciled on the side of the equipment |
| Price Reference |
Optional |
A unique reference that identifies the price of a shipment (e.g. 'CN T0000012345000123'). It can be found using the download feature of the Price Documents tool.
The price reference is made up of 4 components:
| 1-4 |
4 |
Standard Carrier Abbreviation Code (SCAC).
Note: If less than 4 characters, pad with trailing spaces.
|
'CN ' |
|
5
|
1 |
Price Authority Type.
T: Public tariff
D: Limited distribution tariff
F: Limited freight tariff
C: Regular contract
M: Macro contract
Q: Express contract
E: Exempt quote
|
'T' |
| 6-15 |
10 |
Price Authority Number.
Note: If less than 10 numbers, pad with leading zeroes.
|
'0000012345' |
|
| Weight |
Required |
The weight of the product in each railcar.
You do not need to repeat the Weight for the next car if it is the same as the previous one. It will automatically be carried down.
|
| Unique Shipment ID |
Required |
An internal identification number that you can use to track each shipment. |
| Seals |
Optional |
The security seals used on the equipment doors and hatches. Up to 12 seals can be provided per Equipment ID.
When seals have been entered, an image of a Seal will appear next to the input field. Holding your cursor over the image will show all the seals entered for the Equipment ID. You can update the seals by clicking in the input field.
|
| Order Reference # |
Optional (Canadian Grain Shipments Only) |
The Order Reference Number (ORN), associated with each railcar used to ship Canadian Grain. |
| CGC Grain Code |
Optional (Canadian Grain Shipments Only) |
The Canadian Grain Code, used to indicate the type of grain commodity being shipped.
Important: If using Upload, codes provided in the upload file must first exist in your saved Canadian Grain Codes personal list. To update your list of saved codes, press the “Update CGC Grain Code” button in the Speed Bill section.
|
Upload
Summary
Upload allows you to upload a file from your system, containing up to 250 Equipment Ids and their details, such as Equipment Initials and Numbers, Weight, Seals, etc. The information provided is loaded directly into the Speed Bill fields.
Accepted File Formats
- .xls or .xlsx (Miscrosoft Excel, all versions)
- .csv or .txt (comma-delimited)
Upload File Specifications
Important: The upload file may or may not contain column headings. If your file includes a header row, be sure to indicate this by selecting the "Header included" checkbox.
The order of the data fields must match exactly the order of the fields as they are displayed in the Speed Bill section in Shipping Instructions, as listed in the table below.
For optional fields, where you do not wish to upload any data, you must still include the column in the Excel file, or identify the field using delimiters within the .csv or .txt file (ie: 1,,3,,5).
Note: Input fields can vary depending on the shipment type. For example, a Canadian Grain shipment will include fields for the Order Reference # and CGC, while other shipments will not.
| Equipment Initial |
The initials stenciled on the side of the railcar, container, or trailer. |
Alpha, 2-4 characters. |
Required.
If the Equipment Initial is the same for all Equipment Ids, it only needs to be entered once – in Row #1. The information will be automatically applied to all Ids upon Submit.
|
| Equipment Number |
The number stenciled on the side of the railcar, container, or trailer. |
Numeric, 1-6 digits (1-7 accepted for containers / trailers). |
Required. |
| Price Reference |
A unique reference that identifies the price of a shipment (e.g. 'CN T0000012345000123'). It can be found using the download feature of the Price Documents tool.
The price reference is made up of 4 components: Standard Carrier Abbreviation Code (SCAC), Price Authority Type, Price Authority Number, and Price Number.
|
Alpha-numeric, 21 characters. |
Optional.
If the Price Reference is the same for all Equipment Ids, it only needs to be entered once – in Row #1. The information will be automatically applied to all Ids upon Submit.
|
| Weight |
The net weight of the goods being shipped. The Unit of Measure must be specified in the Product Description and Weight section of the main pattern area. |
Numeric, 1- 7 digits, decimals permitted. |
Required.
If the Weight is the same for all Equipment Ids, it only needs to be entered once – in Row #1. The information will be automatically applied to all Ids upon Submit.
|
| Unique Shipment ID |
A unique number that your company uses to identify each shipment. |
Alphanumeric, 1 to 17 characters. Special characters permitted: '?:;+-=()&!./ (includes space).
|
Mandatory.
|
| Seal |
If applicable, the number of the protective seal, affixed to the equipment to identify any tampering of the equipment in transit. |
Alphanumeric, 2 to 15 characters. Special characters permitted: '?:;+-=()&!./ (includes space). |
Optional.
|
| Order Reference # |
The Order Reference Number, associated with each railcar used to ship Canadian Grain. |
Numeric, 6 digits. |
Optional for Canadian Grain shipments.
NOT allowed for all other shipment types.
|
| CGC Grain Code |
The Canadian Grain Code, used to indicate the type of grain commodity being shipped. |
Numeric, 6 digits. Codes provided in the upload file must exist in user's saved Canadian Grain Codes personal list (to update your list of saved codes, press the “Update CGC Grain Code” button in the Speed Bill section). |
Optional for Canadian Grain shipments.
NOT allowed for all other shipment types.
|
Step-by-Step Upload Instructions
Step 1 – Prepare Your Upload File
Important: The file must match the file specifications listed above.
Example of a Canadian Grain shipment .xls upload file that matches the specifications:
Example of the same data provided as a comma-delimited file:
Car Initials,Car Number,Price Reference,Weight,Shipment ID,Seals,ORN,CGC,Loading Week
IC,10167,CNT0000012345000123,83261,1234567890,seal1*seal2*seal3,178806,070010,201240
CN,111612,CNT0000012345000125,82600,1234567891,seal1,178807,070010,201240
CN,388113,,90089,1234567892,seal1,178808,070010,201240
Step 2 – Launch the Upload Tool
From the Speed Bill section, press Upload.
Step 3 – Browse for Your File
Within the Upload tool, press Browse to locate the file on your computer or network.
After locating the file, press Open to select it for upload.
Step 4 – Upload File
Press Upload to import the selected file into the Speed Bill section.
Step 5 – Review the Information
All data contained within the upload file will be copied into the corresponding fields in the Speed Bill section. Review all information carefully and, if necessary, make any adjustments.
Uploaded data will be appended to rows that are already populated. If you would like to replace all information, or if you’ve made a mistake and want to start over, press Clear to clear all fields in the section before using Upload.
Press Done to return to the main pattern area, where you can finalize and Submit your shipping instructions.
Copy/Paste
Summary
Copy/Paste allows you to paste up to 250 Equipment Ids from your Operating System’s clipboard directly into the Speed Bill section.
Step-by-Step Copy/Paste Instructions
Step 1 – Launch the Copy/Paste Tool
From the Speed Bill section, press Copy/Paste.
Step 2 – Paste Equipment IDs
Within the Copy/Paste area, enter up to 250 Equipment Ids and their details. Refer to the Upload File Specifications table for a list of fields and their specifications.
Specify the type of delimiter; comma (,) or semi-colon (;). A carriage return may be used between equipment records.
Example of 3 railcars pasted for a Canadian Grain shipment, comma-delimited:
IC,10167,CNT0000012345000123,83261,1234567890,seal1*seal2*seal3,178806,070010,201240
CN,111612,CNT0000012345000125,82600,1234567891,seal1,178807,070010,201240
CN,388113,,90089,1234567892,seal1,178808,070010,201240
Step 3 – Load Pasted Data
Press Done to import the pasted data into the Speed Bill section.
Step 4– Review the Information
The pasted data will be copied into the corresponding fields in the Speed Bill section. Review all information carefully and, if necessary, make any adjustments.
Pasted data will be appended after rows that are already populated. If you would like to replace all information, or if you’ve made a mistake and want to start over, press Clear to clear all fields before using Copy/Paste.
Press Done to return to the main pattern area, where you can finalize and Submit your shipping instructions.