Legacy platform

Populating U.S. zip codes and region schemas after installation

Sample SQL scripts are provided to populate US zip codes and region schema tables. You can use these scripts for delivery maps and location-specific tasks.

To populate zip codes and region schema tables for other countries, you must manually create the SQL script for your country and region. For more information, see the sample SQL scripts.

Note: You must run the SQL scripts after installing the product.

Sample SQL scripts

To populate the YFS_ZIP_CODE_LOCATION table, run the following script:


<INSTALL_DIR>/database/FactorySetup/Optional/<dbtype>/ZipCodeLocation/
US_ZipcodeLocation.sql

To populate the YFS_REGION and YFS_REGION_DETAIL tables, run the following script:


<INSTALL_DIR>/database/FactorySetup/Optional/<dbtype>/RegionSchema-US/
RegionSchema-US.sql