BluJay Solutions Parcel 21.1.0 - User Guide
How to Configure Time in Transit - Time in Transit Files |
Scroll |
Each carrier that supports the time in transit calculation has a set of the following screens for editing and importing files related to calculating time in transit:
•Importing Time in Transit Files
Caution: Although you can import files separately, the geocodes used in the Transit Days file must exist in the geocodes table. In addition, the services included in either the Transit Days file or the Holidays file must be configured for the location and carrier in order for the import to be successful.
Notes:
•After you create the time in transit files for a particular location and carrier, use the Import Time in Transit Files screen to import these files for a carrier, and then the other screens listed above to edit time in transit information as necessary.
•If you enable time in transit calculation and the carrier has a system that provides time in transit data, for each shipment Parcel first attempts to retrieve the time in transit using the carrier's system. If for some reason this data cannot be retrieved, Parcel then calculates time in transit based on the data in the imported time in transit files. For carriers that do not provide time in transit data, Parcel calculates time in transit from the data in the imported time in transit files or from resident system data.
Geographic Code File Format and Screen
The Geographic Code screen for each supported carrier displays the Geographic Codes and associated data that Parcel uses for time in transit calculations. After you import the Geographic Code file, Parcel displays the table of these values on this screen, enabling you to add, edit, or delete rows as needed.
The Geographic Data file is a comma-delimited text file with the following format:
Geographic Data File Headings |
Variable type and length |
Field Description |
UI Field Name |
geo_code |
Alphanumeric, 32 characters |
Destination Geographic Code; for example, METROLA for Metropolitan Los Angeles. |
Geographic Code |
geo_code_desc |
Alphanumeric, 64 characters |
Geographic Code description – For example: “Metropolitan Los Angeles”. |
Geographic Code Description |
country_code |
Alphanumeric, 3 characters |
ISO country code – The two-character country code or ALL (for all countries). |
Country |
state |
Alphanumeric, 20 characters |
Destination state or province. Note: For those countries where there is a state drop-down list in Parcel, this is the two-letter state/province code. For all others, it is the state or province spelled out. |
State |
city |
Alphanumeric, 50 characters |
Destination city. |
City |
zip_low |
Alphanumeric, 10 characters |
Lowest postal code for the area included in the Geographic Code. |
Zip Low |
zip_high |
Alphanumeric, 10 characters |
Highest postal code for the area included in the Geographic Code. |
Zip High |
Import this file into the Parcel database using the Import Time in Transit Files screen.
Transit Days File Format and Screen
This screen displays the Transit days and related information that Parcel uses for time in transit calculations. After you import the Transit Days file, Parcel displays the table of these values on this screen, enabling you to add, edit, or delete rows as needed.
Caution: Before importing the Transit Days file, ensure that the following conditions are met:
•The Geo Code file must be either previously imported or imported when you import the Transit Days file.
•You must already have configured the services included in the Transit Days file.
The Transit Days file is a comma-delimited text file with the following format:
Transit Days File Headings |
Variable type and length |
Field Description |
UI Field Name |
service_id |
Alphanumeric, 32 characters |
The Parcel Carrier Service ID code. Notes: •If you want to designate that the record is for all configured services, type ALL. This is displayed as “All Services” in the Transit Days table after you import this file. •The data file uses the Service ID code. The Parcel UI displays the complete service name. |
Carrier Service |
geo_code |
Alphanumeric, 32 characters |
Geographic Code as it appears in the Geographic Code file. Caution: BluJay Solutions strongly recommends that at least one row of this file contains a value of geo_code=ALL in order for the time in transit calculation to return a value. You must also include the ALL geo_code in the Geographic Code file, as well as a serviceid value of ALL. |
Geographic Code |
transit_days |
Integer (no length limit) |
Total number of days for delivery of shipment to the destination specified by the Geographic Code. The value of this field cannot be greater than 99. Note: After calculating time in transit for a rate request, Parcel displays this value as Delivery Date. |
Transit Days |
transit_time |
Time, hh:mm:ss |
Transit time in hours, minutes, and seconds. Note: Parcel displays this value as Delivery Time. |
Transit Times |
sat_delivery |
y or n flag |
Saturday delivery flag – y indicates Saturday delivery, n indicates no Saturday delivery. Note: The value for this field is not case sensitive. |
Saturday Delivery |
include_weekend_transit |
y or n flag |
Flag determines whether to add the two weekend days Saturday and Sunday to the time in transit calculation if these days are not counted as transit days. Note: The value for this field is not case sensitive. |
Add Weekend Transit |
Import this file into the Parcel database using the Import Time in Transit Files screen.
Holidays File Format and Screen
This screen displays the Holidays that Parcel uses for time in transit calculations. After you import the Carrier Holidays file, Parcel displays the table of these values on this screen, enabling you to add, edit, or delete rows as needed.
The Holidays file is a comma-delimited text file with the following format:
Holidays File Heading |
Variable type and length |
Field Description |
UI Field Name |
service_id |
Alphanumeric, 32 characters |
The Parcel Carrier Service ID code. Notes: •If you want to designate that the record is for all configured services, type ALL. This is displayed as “All Services” in the Transit Days table after you import this file. •The data file uses the Service ID code. The Parcel UI displays the complete service name. |
Service Name |
country_code |
Alphanumeric, 20 characters |
ISO country code – The two-character country code or ALL (for all countries). |
Country |
state |
Alphanumeric, 20 characters |
Destination state or province. Note: For those countries where there is a state drop-down list in Parcel, this is the two-letter state/province code. For all others, it is the state or province spelled out. |
State |
holiday_desc |
Alphanumeric, 20 characters |
Name of holiday. |
Holiday Description |
holiday_date |
Alphanumeric, 8 characters |
Date of the holiday in the following form: YYYY-MM-DD. |
Holiday Date |
allow_delivery |
y or n flag. |
A y indicates that delivery allowed on the holiday; an n indicates delivery is not allowed. Note: The value for this field is not case sensitive. |
Allow Delivery |
include_transit |
y or n flag. |
Flag determines whether to add one day for the holiday to the time in transit calculation if the holiday is not to be counted as a transit day. Note: The value for this field is not case sensitive. |
Add Transit |
Import this file into the Parcel database using the Import Time in Transit Files screen.
Weekends File Format and Screen
This screen displays the Weekend details that Parcel uses for time in transit calculations. After you import the Carrier Weekends file, Parcel displays the table of these values on the Weekends screen, enabling you to add, edit, or delete rows as needed.
The Weekends file is a comma-delimited text file with the following format:
Weekends File Heading |
Variable type and length |
Field Description |
UI Field Name |
service_id |
Alphanumeric, 32 characters |
The Parcel Carrier Service ID code. Notes: •If you want to designate that the record is for all configured services, type ALL. This is displayed as “All Services” in the Transit Days table after you import this file. •The data file uses the Service ID code. The Parcel UI displays the complete service name. |
Service Name |
country_code |
Alphanumeric, 20 characters |
ISO country code – The two-character country code or ALL (for all countries). |
Country |
state |
Alphanumeric, 20 characters |
Destination state or province. Note: For those countries where there is a state drop-down list in Parcel, this is the two-letter state/province code. For all others, it is the state or province spelled out. |
State/Province |
Weekend_desc |
Alphabetic, 3 characters |
Three-character day-name abbreviation; for example: SAT Note: If you enter the complete name of the day, it is truncated to the first three characters. |
Weekend |
allow_delivery |
y or n flag. |
A y indicates that delivery allowed on the weekend; an n indicates delivery is not allowed. Note: The value for this field is not case sensitive. |
Allow Delivery |
include_transit |
y or n flag. |
Flag determines whether to add one day for the weekend to the time in transit calculation if the weekend is not to be counted as a transit day. Notes: •A "Y" (no quotation marks) indicates that the weekend is counted as a transit day in the TinT calculation (that is, does count as a transit day); an "N" indicates that the weekend is not counted as a transit day in the TinT calculation. For example, if a shipment is picked up on a Thursday with 3 transit days, and the value for this field is "Y," then the delivery date is the following Monday. If the value is "N," then the delivery date is Tuesday. •The value for this field is not case sensitive. |
Allow Transit |
Import this file into the Parcel database using the Import Time in Transit Files screen.
On each of the previous screens, add a row to the table by clicking the ADD 
icon in the upper left corner. Delete a row by clicking the DELETE 
icon to the left of the row. Edit a row by clicking the EDIT 
icon to the left of the row. Click [SAVE] to save your changes or [CANCEL] to exit the screen without saving changes.
