Please contact your Account Executive to talk further details on data specification documents. Your Account Executive will provide the full data specification document.
ParcelShield uses a defined data specification document/file layout to import and process manifested packages. ParcelShield works with customers to establish a secure file transfer process.
As part of the layout, the below data fields allow ParcelShield to provide services on behalf of customers.
Column | Description | Data Type | Sample | Required |
Location Indicator | Unique location identifier | String(255) | PHARM_1 | X |
Order Number | Unique package identifier | String(255) | 505321458 |
|
Tracking Number | Carrier Tracking Number | String(255) | 1Z123456789123 | X |
Carrier Indicator | Carrier Indicator | UPS|FEDEX|GSO|USPS | UPS | Required for regional carriers (e.g. GSO) |
Description | Service Type | String(255) | UPS Ground |
|
Address | Ship From Address | String(255) | 101 Main St. |
|
City | Ship From City | String(255) | Sanford |
|
State | Ship From State | String (2) | FL |
|
Zip Code | Ship From Zip Code | String (10) | 32773 |
|
Consignee First Name | First Name of the Consignee | String(255) | John | X |
Consignee Last Name | Last Name of the Consignee
| String(255) | Doe | X |
Consignee Address Line 1 | Address of the Consignee | String(512) | 123 Mill Cr. Rd | X |
Consignee Address Line 2 | Apartment Number or Suite | String(512) | Suite 1 |
|
Consignee City | City | String(255) | Redmond | X |
Consignee State | State | String(2) | OR | X |
Consignee Zip | Zip | String(10) | 97756 | X |
Consignee Country | Country | String( | US | X |
Consignee Phone Number | Phone Number of the Consignee | 10 Digit Phone Number | 8888888888 | X |
Consignee Secondary Phone Number | Secondary Contact Phone Number | 10 Digit Phone Number | 8888888888 | RECCOMMENDED |
Consignee Email Address | Email address that can be used for package communications | String(255) | RECCOMMENDED | |
Ship Date | Date the package is tendered to the shipper | Date Time | 1/1/2020 8:00 | X |
Need by Date | Date the package is to arrive | Date Time | 1/1/2020 8:00 |
|
Customer Reference Number | Reference Number | String(255) | CR-1234 |
|
Delivery Instructions | Special instructions accompanying the shipment | String(1024) | Leave at back door |
|
Package Value | Value of the shipment contents | decimal | 1234.55 | RECCOMMENDED |
Is Refrigerated | Refrigeration Status of the Shipment | Y/N | Y | RECCOMMENDED |
Medical Doctors Office Indicator | Indicator that the address is a Medical doctor's Office | Y/N | Y |
|
Signature Required Indicator |
| Y/N | N | RECCOMMENDED |
Consignee Language | Preferred language | String (30) | Chinese English Spanish | RECOMMENDED |