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  |