Region Interface - Shipping

                    

Interface Tables:

WSH_REGIONS_INTERFACE

WSH_REGIONS_TL_INTERFACE

Base Tables:

WSH_REGIONS

WSH_REGIONS_TL

Create Country:

Insert the following data into Interface tables  

Generate Sequence_ID and use the same for both the INTERFACE tables.

Region_Type=0

Country and Country_Code should be NOT NULL.

Other values like state, city, parent_region_id should be NULL

Run ‘Region Interface’ import program to create COUNTRY records.

Create State:

Insert the following data into Interface tables

Generate Sequence_ID and use the same for both the INTERFACE tables.

Region_Type=1

Country, Country_Code, State, State_Code should be NOT NULL.

Parent_Region_ID should be the region_id of the corresponding COUNTRY record.

Other values like city, Postal_Code_From, Postal_Code_To should be NULL

Run ‘Region Interface’ import program to create STATE records.

Create City:

Insert the following data into Interface tables

Generate Sequence_ID and use the same for both the INTERFACE tables.

Region_Type=2

Country, Country_Code, State, State_Code, City_City_Code should be NOT NULL.

Parent_Region_ID should be the region_id of the corresponding STATE record.

Other values like area, Postal_Code_From, Postal_Code_To should be NULL

Run ‘Region Interface’ import program to create CITY records

Create Area/ Pincode:

Insert the following data into Interface tables

Generate Sequence_ID and use the same for both the INTERFACE tables.

Region_Type=3

Country , Country_Code, State, State_Code, City_City_Code, Area, Postal_Code_From, Postal_Code_To should be NOT NULL.

Run ‘Region Interface’ import program to create Area/ Pincode records.