Shipment Server import detail

Here you will find descriptions on how data from each table in the process is handled when importing from a Shipment Server instance. This is the same for both on premise and cloud installs.

Only the following tables from both versions of the product (versions 8.x and 7.x) are processed during import. Unsupported version 7.x tables are outlined below. For version 8.x only tables, see the Database Definition provided on the Developer landing page.

Table	Notes
Account Codes	Existing table contents replaced with imported data.
Accounts	Existing table contents replaced with imported data for supported Transtream carriers.
Address Aliases	Existing table contents replaced with imported data.
Address Codes	Existing table contents replaced with imported data.
Addresses	Existing table contents replaced with imported data.
Bulk Lists	Existing table contents replaced with imported data.
Bulk List Contacts	Existing table contents replaced with imported data.
Carrier Functions	Existing table contents for custom carriers (Carrier IDs 999 or higher) is replaced with imported custom carriers data.
Carrier Package Types	Existing table contents for custom carriers (Carrier IDs 999 or higher) is replaced with imported custom carriers data.
Carrier Rating	Existing table contents for custom carriers (Carrier IDs 999 or higher) is replaced with imported custom carriers data.
Carrier Rating Options
Carrier Services	Existing table contents for custom carriers (Carrier IDs 999 or higher) is replaced with imported custom carriers data.
Carrier Service Mappings	Existing table contents for custom carriers (Carrier IDs 999 or higher) is replaced with imported custom carriers data.
Carriers	Existing table contents for custom carriers (Carrier IDs 999 or higher) is replaced with imported custom carriers.
Carton Package Mapping	Existing table contents replaced with imported data.
Carton Configuration	Existing table contents replaced with imported data.
Cartonization Group Config Mapping	Existing table contents replaced with imported data.
Cartonization Groups	Existing table contents replaced with imported data.
Cartonized Shipments	Existing table contents replaced with imported data.
Charges	Existing table contents replaced with imported data for Shipments, Packages, Rates and Quotes.
Company Codes	Existing table contents replaced with imported data.
Consolidated Shipment Progress	Existing table contents replaced with imported data for supported Transtream carriers.
Consolidated Shipments	Existing table contents replaced with imported data.
Consolidated Shipping Defaults	Existing table contents replaced with imported data for supported Transtream carriers.
Contacts	Existing table contents replaced with imported data.
Container Types	Existing table contents replaced with imported data.
Content Material Exemptions	Existing table contents replaced with imported data.
Content Materials	Existing table contents replaced with imported data.
Contents	Existing table contents replaced with imported data.
Cost Centers	Existing table contents replaced with imported data.
Custom Code Translations	Existing table contents replaced with imported data.
Custom Labels	Existing table contents replaced with imported data.
Custom Print Engines	Existing table contents replaced with imported data.
Custom Storage	Existing table contents replaced with imported data.
Customers	Existing table contents replaced with imported data.
EEI Filings	Existing table contents replaced with imported data.
EEI Responses	Existing table contents replaced with imported data.
Email Templates	Existing table contents updated with imported data, not replaced.
End Of Day	Existing table contents replaced with imported data.
End Of Day Progress	Existing table contents replaced with imported data.
Hazardous Helpline Contacts	Existing table contents replaced with imported data.
Hazardous Packaging Types	Existing table contents replaced with imported data.
Hazardous Shipment Templates	Existing table contents replaced with imported data.
Imported Of Record Facilities	Existing table contents replaced with imported data.
Insurance	Existing table contents replaced with imported data.
Insurance Progress	Existing table contents replaced with imported data.
International Defaults	Existing table contents replaced with imported data.
Invoice Carrier Services	Existing table contents replaced with imported data.
Invoice Carrier Special Services	Existing table contents replaced with imported data.
Invoice Carriers	Existing table contents replaced with imported data.
Invoice Charges	Existing table contents replaced with imported data.
Invoice Package Types	Existing table contents replaced with imported data.
Invoice Providers	Existing table contents replaced with imported data.
Invoice Transactions	Existing table contents replaced with imported data.
Invoices	Existing table contents replaced with imported data.
IOPCPPA Account Permissions	Existing table contents replaced with imported data.
Load Balance Server Pool Account Mapping	Existing table contents replaced with imported data.
Load Balance Server Pools	Existing table contents replaced with imported data.
Load Balance Transaction Details	Existing table contents replaced with imported data.
Load Balanced Transaction State	Existing table contents replaced with imported data.
Localizations	Existing table contents replaced with imported data.
Locations	Existing table contents replaced with imported data.
Low Funds Alert Types	Existing table contents replaced with imported data.
Measurement Unit Aliases	Existing table contents replaced with imported data.
Order Addresses	Existing table contents replaced with imported data.
Order Pack Items	Existing table contents replaced with imported data.
Order Pick Lists	Existing table contents replaced with imported data.
Order Shipments	Existing table contents replaced with imported data for supported Transtream carriers.
Orders	Existing table contents replaced with imported data.
Organizations	Existing table contents replaced with imported data.
Output	Existing table contents replaced with imported data for supported Transtream carriers.
Output Extension Mappings	Existing table contents replaced with imported data.
Output Extensions	Existing table contents replaced with imported data.
Outputs Items	Existing table contents replaced with imported data for supported Transtream carriers.
Pack Items	Existing table contents replaced with imported data.
Package History	Existing table contents replaced with imported data for supported Transtream carriers.
Package Numbers	Existing table contents replaced with imported data.
Package Requisitions	Existing table contents replaced with imported data for supported Transtream carriers.
Packages	Existing table contents replaced with imported data for supported Transtream carriers.
Packages Cache	Existing table contents replaced with imported data.
Payers	Existing table contents replaced with imported data.
Pending	Existing table contents replaced with imported data.
Pending Errors	Existing table contents replaced with imported data.
Pick List Pack Items	Existing table contents replaced with imported data.
Pick List Shipments	Existing table contents replaced with imported data.
Pick Lists	Existing table contents replaced with imported data.
Pickups	Existing table contents replaced with imported data.
Postal Meter Fund History	Existing table contents replaced with imported data.
Postal Meters	Existing table contents replaced with imported data.
Pouches	Existing table contents replaced with imported data.
Printers	Existing table contents replaced with imported data.
Product Templates	Existing table contents replaced with imported data.
Products	Existing table contents replaced with imported data.
Profiles	Existing table contents replaced with imported data.
Quote Requests	Existing table contents replaced with imported data.
Quotes	Existing table contents replaced with imported data.
Rate Engine Types	Existing table contents replaced with imported data.
Rate Engines	Existing table contents replaced with imported data.
Rate Group Members	Existing table contents replaced with imported data.
Rate Groups	Existing table contents replaced with imported data.
Rate Types	Existing table contents for custom rate types (Rate Type IDs 9 or higher) is replaced with imported custom rate types.
Rated Packages	Existing table contents replaced with imported data for supported Transtream carriers.
Rated Shipments	Existing table contents replaced with imported data for supported Transtream carriers.
Rates	Existing table contents replaced with imported data for supported Transtream carriers.
Record Identifiers	Existing table contents replaced with imported data.
Reports Location Activity	Existing table contents replaced with imported data.
Reports Shipper Activity	Existing table contents replaced with imported data.
Reports Transactions Data	Existing table contents replaced with imported data.
Resources	Existing table contents replaced with imported data.
Routes	Existing table contents replaced with imported data.
Routing Rule Days Of Week	Existing table contents replaced with imported data.
Routing Rules	Existing table contents replaced with imported data.
Scales	Existing table contents replaced with imported data.
Security Credentials	Existing table contents replaced with imported data for supported Transtream carriers.
Server	Existing table contents replaced with imported data.
Settings	The imported Shipment Server settings are copied to the new instance.
Shipment Groups	Existing table contents replaced with imported data.
Shipment Requisitions	Existing table contents replaced with imported data for supported Transtream carriers.
Shipment Returns	Existing table contents replaced with imported data for supported Transtream carriers.
Shipments	Existing table contents replaced with imported data for supported Transtream carriers.
Shipments Cache	Existing table contents replaced with imported data for supported Transtream carriers.
Shipping Keys	Existing table contents replaced with imported data for supported Transtream carriers.
Shipping Order Header	Existing table contents replaced with imported data.
Shipping Order Line Items	Existing table contents replaced with imported data.
Smart Post Hubs	Existing table contents replaced with imported data.
Special Services	Existing table contents replaced with imported data.
Third Parties	Existing table contents replaced with imported data.
Transactional Addresses	Existing table contents replaced with imported data.
User Defaults	Existing table contents replaced with imported data.
User Messaging	Existing table contents replaced with imported data for supported Transtream carriers.
Users	Existing table contents replaced with imported data.

Top

Version 7 specific tables