Databases Information
International Zone, Country Sort and Max Sort Database Tables
The database is made up of a series of tables that users may incorporate into their software. The tables are available for download from here.
| Table Name |
Table Purpose |
| ISORTA |
Primary sortation table used to look up the Country Code that corresponds to the country name from the mailing address |
| ISORTB |
This table is used to determine the appropriate Destination from the Country and Locality Codes for a given mailing service |
| ISORTC |
Secondary sortation table used to look up the Locality Code from a postcode for a given Country Code |
| ISORTD |
Secondary sortation table used to look up the Locality Code from a town or district name for a given Country Code |
| ISOTRF |
Printable version of the sorting criteria |
| ISTRMB |
Determines which service speeds are appropriate for a given country code. |
Data Formats
With the exception of ISORTF, the tables are available in the following formats:
ISORTF is a printable version of the sorting databases, only available in Microsoft Excel formats.
ISORTA Field Details
| Field Name |
Field Size (Bytes) |
| Database Version Number |
3 |
| Country Name |
50 |
| Country Code |
6 |
ISORTB Field Details
| Field Name |
Field Size (Bytes) |
| Database Version Number |
3 |
| International Selection Code (ISC) |
9 |
| Service Identifier |
1 |
| Destination Identifier |
50 |
| Residue Identifier |
50 |
ISORTC Field Details
| Field Name |
Field Size (Bytes) |
| Database Version Number |
3 |
| Country Code |
6 |
| Postcode |
20 |
| Locality Code |
3 |
ISORTD Field Details
| Field Name |
Field Size (Bytes) |
| Database Version Number |
3 |
| Country Code |
6 |
| Town / District |
50 |
| Locality Code |
3 |
ISTRMB Field Details
| Field Name |
Field Size (Bytes) |
| Database Version Number |
3 |
| International Selection Code (ISC) |
9 |
| Service Identifier |
1 |
| Country Name |
50 |
| Filler |
50 |
Field sizes represent the actual field width for Fixed Field Width Format and the maximum field width for Comma Delimited Field Format. Field widths for Comma Delimited Field Format may be less than the maximum.
