Input Fields Available for Mapping |
Scroll |
Input fields available for mapping in the connect input file are described in the table below:
Field |
Description |
Maximum Length |
Type of the record. The possible values are: •S (Shipment): This type of record contains information about the shipment. •P (Piece): In multi-piece shipments, it is required to define the weight of each piece/item in the input file. Thus the first record in the input file must have S (Shipment) in the first field. While subsequent records in the same shipment have P (Piece) for information about the pieces in the same shipment. •I (Item): Similarly, for multiple item each subsequent record has I (Item) for information about the items included in the shipment. Note: Pieces represent the number of packages in the shipment. Item represents the shipment content and are represented in the commercial invoice as separate line items. |
1 |
|
Mode of processing records in the connect input file. The possible values are: |
1 |
|
Printer ID |
ID of the printer used to print the label. |
100 |
Shipment Code |
Code defined by the customer and is used in shipment identification. This is a mandatory field. |
20 |
Customer Code |
Code used to identify a customer in the address book and retrieve the address information. Note: If the customer code is not supplied in the input file, the address information can not be retrieved from the address book. It uses the address information supplied in the input file. |
10 |
Attention |
Additional information about the customer can be provided. |
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 |
Phone number of the contact person. |
20 |
Extension |
Extension 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 |
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. Current date is the default value for this field. |
8 |
Ship Via |
Any pre-configured Rate Shop Key can be specified as its value. 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 Center |
For internal use only. |
6 |
Insured Value |
For internal use only. |
8 |
Note |
Additional information. |
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 entered are applied to the: •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 |
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 |
Weight |
Gross cubed weight of a parcel. |
8 |
Length |
Length of a package. |
8 |
Width |
Width of a package. |
8 |
Height |
Height of a package. |
8 |
ExpCheq Amount |
Amount of the 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 customer, if any. |
40 |
ExpCheq Customer Name |
Name of the customer. |
40 |
ExpCheq Street Address |
Street name and number of the delivery address. |
60 |
ExpCheq Address Line2 |
Additional address information, if any. |
40 |
ExpCheq Address Line3 |
Additional address information, if any. |
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 |
The possible values are: •Y (Yes): Do not print the label and allow customers to print their own labels. •N (No): Print the label. This is the default value. Note: If the value for this field is not supplied, it is considered as N (No). |
1 |
|
3rd Party Customer Code |
Code used to identify the third party customer in the Address book. |
10 |
3rd Party Attention |
Additional information about the third party customer can be provided. |
40 |
3rd Party Customer Name |
Name of the third party customer. |
40 |
3rd Party Street Address |
Street name and number of the delivery address. |
45 |
3rd Party Address Line2 |
Additional address information, if any. |
40 |
3rd Party Address Line3 |
Additional address information, if any. |
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 |
Canadian postal code or USA zip code. Note: Integration Adapter translates the postal code to city and province. The translated city and province is used even if the city and province is supplied in the input record. |
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. |
10 |
3rd Party Fax Number |
Third party's fax number. |
20 |
3rd Party Email Address |
Third party's email address. |
100 |
Document Only |
The possible values are: •Y (Yes): Indicates a document only shipment and is used to produce custom documents using the default trade data defined in carrier module (USA and International only). •N (No): Indicates a non-document shipment. This is the default value. |
1 |
Description of Goods |
Brief description of goods. |
40 |
Country of Manufacture |
Country where the goods are manufactured. |
2 |
Value for Customs |
Minimum value: 2 Maximum Value: 99,999.99 |
10 |
Return Special Handling (Y/N/5-10) |
This is provided as a return special service. The possible values are: •Y (Yes): Piece requires special handling. •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 |
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, if any. |
40 |
Sold to Address Line3 |
Additional address information, if any. |
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 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 is requested through the connect input file. The possible values are Y (Yes) and N (No). Note: If this field is set to Y, the Document Only field is automatically set to N. |
1 |
|
CI Qty |
Quantity in the commercial invoice. Note: The CI values apply to each line item. |
8 |
CI Description |
Description of the commercial invoice. |
40 |
CI HS Code |
HS code of the commercial invoice. |
30 |
CI USMCA |
The possible values are Y (Yes) and N (No). |
1 |
CI Country of Manufacture |
Country name of the item manufactured. |
2 |
CI Unit Value |
Unit value of the item in the commercial invoice. |
13 |
Package Type |
The possible values are: •l (Purolator Express Envelope) •p (Purolator Express Pack) •u (Customer Packaging) |
1 |