Please enable JavaScript to view this site.

BluJay Solutions Parcel 21.1.0 - User Guide

Navigation: » No topics above this level «

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

Record Type

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

Transaction Type

Mode of processing records in the connect input file. The possible values are:

I (Input)

A (Automatic)

Q (Query)

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

Suppress Label

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

3rd Party Postal Code

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

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

CONFIDENTIAL © 2004-2021 BluJay Solutions Ltd. All Rights Reserved.