Output Fields Available for Mapping |
Scroll |
Output fields available for mapping in the connect output file are described in the table below:
Field |
Description |
Maximum Length |
Record Type |
Type of the record. This is a mandatory field. The possible values are: •S (Shipment) •P (Piece) •I (Item) •V (Void) •Q (Query) |
1 |
Error Code |
Error code. |
4 |
Shipment Code |
Code is defined by the customer and used in shipment identification. This is a mandatory field. |
20 |
Customer Code |
Code used to identify the customer in the customer database. |
10 |
Attention |
Additional information about the customer, if any. |
40 |
Customer Name |
Name of the consignee. |
40 |
Street Address |
Street name and number of the delivery address. |
45 |
Address Line 2 |
Additional address information. |
40 |
Address Line 3 |
Additional address information. |
40 |
City |
Customer's city name. |
40 |
Province |
Customer's province code (2-4 characters) and must comply with the PCL standards. |
3 |
Postal Code |
Customer's ZIP/postal code. |
10 |
Country Code |
Customer's country name. |
2 |
Telephone |
Telephone number of the contact person. |
20 |
Extension |
Extension number of the contact person. |
10 |
Fax Number |
Fax number of the contact person. |
20 |
Email Address |
Email address of the contact person. |
128 |
Tax Number |
Customer's tax number. |
16 |
Reference 1 |
Additional information to be printed on the label. |
35 |
Reference 2 |
Additional information to be printed on the label. |
35 |
Reference 3 |
Additional information to be printed on the label. |
35 |
Reference 4 |
Additional information to be printed on the label. |
35 |
Reference 5 |
Additional information to be printed on the label. |
35 |
Reference Per Piece |
Piece level reference. |
35 |
Ship Date |
Date of shipment that is to be done in future. |
8 |
Ship Via |
Any pre-configured Rate Shop Key. For specifying Fastest mode/Cheapest mode feature. The specified mode is automatically chosen — the fastest/cheapest carrier-service combination and ship/rate based on that. |
20 |
Delivery Date |
Date of delivery. |
8 |
Cost Centre |
For internal use only. |
6 |
Insured Value |
For internal use only. |
8 |
Note |
This is printed on the label if the ExpressCheque option is set to 'N'. |
50 |
Payment |
Mode of payment. The possible values are: •P (Prepaid) •C (Collect) •T (Third Party) |
1 |
Service |
Service information. The possible values are: •1030 (Express 10:30AM) •9AM (Express 9AM) •AIR (Express) •GND (Ground) •INTL (Express International) •UAIR (Express US) •UGND (Ground US) |
4 |
Saturday Service |
Saturday delivery is provided as a special service. The possible values are Y (Yes) and N (No). |
1 |
Dangerous Goods (Y/1-5) |
Shipment of dangerous goods delivery is provided as a special service. The possible values are: •Y - Valid only when, the default Dangerous Goods type is set (other than blank) in Shipper Defaults •1 - Fully Regulated •2 - UN3373 •3 - UN1845 •4 - Less than 500 KG Exemption •5 - Limited Quantity |
1 |
Hold For Pickup |
This is provided as a special service. The possible values are Y (Yes) and N (No). |
1 |
ExpressCheque |
This is provided as a special service. The possible values are Y (Yes) and N (No). |
1 |
Return Shipment |
Number of return labels for each: •S (Shipment) •P (Package) |
1 |
Pieces |
Number of pieces. This field is used to specify one piece with a weight or multiple pieces without weight. The possible values are from 1 to 100. |
3 |
PIN |
Parcel Identification Number. |
25 |
Total Weight |
Total weight of shipment including cubing. |
8 |
Weight |
Gross cubed weight of the parcel. |
8 |
Real Weight |
Actual Piece Weight. |
8 |
Length |
Length of a package. |
8 |
Width |
Width of a package. |
8 |
Height |
Height of a package. |
8 |
Weight Units |
Unit of weight. |
3 |
Dimension Units |
Units of dimension. |
2 |
Diversion Code |
Declare the highest in priority order: •0 – None •1 – Dangerous Goods •2 – Chain of Signature (COS) •3 – Heavy Weight (Applicable when piece weight is greater than 70 lbs) •4 – Future Use •5 – Special Handling Required (SHS) •6 – Saturday |
1 |
ExpCheq PIN |
Parcel Identification Number of the return cheque. |
14 |
ExpCheq Amount |
Amount of ExpressCheque. |
9 |
ExpCheq Payment Method |
Method of payment. The possible values are: •1 (Cheque) •2 (Post dated Cheque) •3 (Certified Cheque, Money order or bank draft) |
1 |
ExpCheq Attention |
Additional information about the consignee. |
40 |
ExpCheq Customer Name |
Name of the consignee. |
40 |
ExpCheq Street Address |
Street name and number of the delivery address. |
60 |
ExpCheq Address Line2 |
Additional address information. |
40 |
ExpCheq Address Line3 |
Additional address information. |
40 |
ExpCheq City |
City name. |
40 |
ExpCheq Province |
Province code (2 or 4 characters) and must comply with the PCL standards. |
3 |
ExpCheq Postal Code |
Canadian postal code or USA zip code. |
10 |
ExpCheq Country Code |
Country code. |
2 |
3rd Party Customer Code |
Code used to identify the customer in the Address book. |
10 |
3rd Party Attention |
Additional information about the 3rd party customer, if any. |
40 |
3rd Party Customer Name |
Third party's customer name. |
40 |
3rd Party Street Address |
Street name and number of the delivery address. |
45 |
3rd Party Address Line2 |
Additional address information. |
40 |
3rd Party Address Line3 |
Additional address information. |
40 |
3rd Party City |
Third party's city name. |
40 |
3rd Party Province |
Third party's province code (2 or 4 characters). It must comply with the PCL standards. |
3 |
3rd Party Postal Code |
Third party's Canadian postal code or USA zip code. |
10 |
3rd Party Country |
Third party's country name. |
2 |
3rd Party Account Number |
Third party's account number. |
10 |
3rd Party Telephone |
Third party's telephone number (in any format). |
20 |
3rd Party Extension |
Third party's extension number. |
10 |
3rd Party Fax Number |
Third party's fax number. |
20 |
3rd Party Email Address |
Third party's email address. |
100 |
Total Cost Including Tax |
Total cost of shipment including tax. |
8 |
Total Cost before Tax |
Total cost of shipment before tax. |
8 |
GST-HST |
Federal taxes applied to shipment. |
10 |
QST |
Quebec taxes applied to shipment. |
10 |
Ship Date |
Service date. |
8 |
Unicode |
Domestic routing code. |
6 |
Transit Days |
Number of business days from pickup to delivery. |
8 |
Base Cost |
Cost before surcharge and taxes. |
9 |
Beyond Charge |
Surcharge assessed against shipment to beyond points. |
9 |
Low Density (Residential) charge |
Surcharge assessed against shipment to rural points. |
9 |
Fuel Surcharge |
Surcharge assessed against shipment to fuel charged. |
9 |
ExpressCheque Surcharge |
ExpressCheque Surcharge. |
9 |
Saturday Service Charge (Delivery) |
Surcharge for special services provided on Saturdays. |
9 |
Chain of Signature Surcharge |
Chain of Signature Surcharge. |
9 |
Dangerous Goods Surcharge |
Surcharge assessed against shipment. |
9 |
Insurance Charge |
Values declared for insurance. |
9 |
Real Weight |
Physical weight of the parcel. |
8 |
Customer Margin |
Calculated customer margin for the shipment. Note: The customer margin can be a specified fixed cost or a percentage of the shipment cost. This can be set for a particular account in system settings. |
10 |
Special Handling Required (Y/N) |
This is provided as a special service. The possible values are: •Y (Yes): Pieces require special handling. •N (No): Pieces do not require special handling. This is the default value. |
1 |
Special Handling |
Special Handling Surcharge combined in a shipment. |
1 |
Special Handling Declared (N/5-10) |
This is provided as a special service. The possible values are: •N (No): Pieces do not require special handling. This is the default value. •5: Flat Package •6: Additional Handling •7: Large Package •9: Oversized •10: Residential Area Heavyweight |
1 |
Pkg Special Handling Surcharge |
Surcharge for special handling of the piece. This is applicable only if the Special Handling Required (Y/N) field in the input file is set to one of the valid values from Y/N. |
9 |
Document Only |
To produce custom documents (USA and International only). The possible values are Y (Yes) or N (No). |
1 |
Description of Goods |
Brief description of goods. |
40 |
Country of Manufacture |
Country where goods are manufactured. |
2 |
Value for Customs |
Minimum value: 2 Maximum Value: 99,999.99 |
10 |
Currency for Customs |
The possible values are CAD or USD. |
3 |
Import/Export Type |
The possible values are: •1 (Permanent) •2 (Temporary) •3 (Return/Repair) |
1 |
Duties and Taxes Paid By |
The possible values are: •1 (Receiver) •2 (Shipper) •3 (Importer) |
1 |
Sold to Attention |
Name of the person importing the shipment. It can be defined per shipment. |
40 |
Sold to Customer Name |
Customer's name. |
40 |
Sold to Street Address |
Street name and number of the delivery address. |
50 |
Sold to Address Line2 |
Additional address information. |
40 |
Sold to Address Line3 |
Additional address information. |
40 |
Sold to City |
Customer's city name. |
40 |
Sold to State |
Customer's state name. |
3 |
Sold to Country |
Customer's country name. |
2 |
Sold to Postal Code |
Customer's postal code or zip code. |
10 |
Sold to Telephone |
Customer's telephone number. |
30 |
Sold to tax number |
Customer's tax number. |
10 |
Broker Name/Telephone |
Name/telephone number of the broker. It can be defined per shipment. |
40 |
Commercial Invoice |
Commercial invoice to be printed or not. The possible values are Y (Yes) and N (No). Note: If this field is set to Y, the Document Only field is set to N. |
1 |
CI Qty |
Item quantity in the commercial invoice. CI values apply to each line item. |
8 |
CI Description |
Item description in the commercial invoice. |
40 |
CI HS Code |
HS Code in the commercial invoice. |
30 |
CI USMCA |
USMCA in the commercial invoice. |
1 |
CI Country of manufacture |
Country name of the item manufactured. |
2 |
CI Unit Value |
Unit value of the item in commercial invoice. |
13 |
CI Total Value |
Total value. |
13 |
Belt Code |
Code of Belt. |
6 |
Hub Code |
Code of Hub. |
7 |
Airport Code |
Code of airport. |
3 |
Mode of Transport |
The possible values are A (Air) and G (Ground). |
1 |
IATA Code- Origin |
Code identifies the origin point. |
3 |
IATA Code- Destination |
Code identifies the destination point. |
3 |
IATA Product Code |
Product code in the IATA bar code. |
3 |
Package Type |
The possible values are: •l (Purolator Express Envelope) •p (Purolator Express Pack) •u (Customer Packaging) |
1 |