Please enable JavaScript to view this site.

BluJay Solutions Parcel 21.1.0 - User Guide

Navigation: » No topics above this level «

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

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