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 reship data. ParcelShield works with customers to establish a secure file transfer process.
As part of the layout, the below data fields allow ParcelShield to process reship data files.
Column | Description | Data Type | Sample | Required |
Original Location Indicator | Unique location identifier - Original | String(255) | PHARM_1 | X |
Original Order Number | Unique package identifier – Original | String(255) | 505321458 | X |
Original Tracking Number | Carrier Tracking Number - Original | String(255) | 1Z123456789123 | X |
Original Need by Date | Date the package is to arrive - Original | Date Time | 1/1/2020 8:00 |
|
Location Indicator | Unique location identifier | String(255) | PHARM_1 | X |
Order Number | Unique package identifier | String(255) | 505321458 | X |
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 |
|
Ship Date | Date the package is tendered to the shipper | Date Time | 1/1/2020 8:00 | X |
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 | RECCOMENDED |
Reship Cost | Cost of reship | Decimal | 1234.55 | RECCOMENDED |
Reship Category | Reship category | String(255) | Vendor Misdelivered | RECOMMENDED |
Reship Subcategory | Reship subcategory | String(255) | Damaged Delivered to incorrect address or location | RECOMMENDED |
Is Refrigerated | Refrigeration Status of the Shipment | Y/N | Y | RECCOMENDED |
Reship Notes | Any notes associated with the notes | String(1024) | Package delivered to incurred address | RECCOMENDED |
Signature Required Indicator |
| Y/N | N | RECCOMENDED |