This page (revision-3) was last changed on 26-Nov-2021 10:22 by jescott

This page was created on 26-Nov-2021 10:22 by jmyers

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
3 26-Nov-2021 10:22 673 bytes jescott to previous
2 26-Nov-2021 10:22 702 bytes jmyers to previous | to last
1 26-Nov-2021 10:22 2 KB jmyers to last

Page References

Incoming links Outgoing links
IDCI
IDCI

Version management

Difference between version and

At line 7 changed one line
Work Rule data is stored in the [P2K_CM_STATE_PROVINCES], [P2K_CM_COUNTRIES], [P2K_CM_ZIP_RANGES], and [P2K_CM_TAX_JURISDICTIONS] tables.
Cities data is stored in the [P2K_CM_STATE_PROVINCES] and [P2K_CM_CITIES] tables.
At line 9 changed 10 lines
!!Country Zip Ranges tab
;[Country Name|COUNTRY_NAME]:The name of the country associated with the zip code range is identified in this field.
;[Country Code|COUNTRY_CODE]:The country code associated with the zip code range is identified in this field.
;[Alt Country Code|COUNTRY_CODE]:An alternate country code associated with the zip code range is identified in this field.
;[State Name|STATE_PROVINCE_CODE]:The state associated with the zip code range is identified in this field.
;[Zip Code|ZIP_POSTAL]:The zip code associated with the zip range is identified in this field.
;[City|CITY_NAME]:The name of the city associated with the zip code range is identified in this field.
;[City Code|CITY_CODE]:The city code associated with the zip code range is identified in this field.
;[Description|DESCRIPTION]:A short description of the zip range is provided in this field.
\\
;[Country Name|COUNTRY_NAME]:The name of the country associated with the city is identified in this field.
;[Country Code|COUNTRY_CODE]:The country code associated with the city is identified in this field.
;[City Code|CITY_CODE]:The city code is identified in this field.
;[City|CITY_NAME]:The name of the city is identified in this field.
At line 20 removed 9 lines
!!Jurisdiction Zip Ranges tab
;[GNIS Code|GEO_CODE]:The GNIS associated with the zip range is identified in this field.
;[Jurisdiction|JURISDICTION_NAME]:The jurisdiction associated with the zip range is identified in this field.
;[GEO Type|GEO_TYPE]:The GEO type associated with the zip range is identified in this field.
;[Zip Code Start|ZIP_POSTAL_START]/[Zip Code End|ZIP_POSTAL_END]:These fields identify the start and end of the zip codes.
;[City|CITY_NAME]:The name of the city associated with the zip code range is identified in this field.
;[City Code|CITY_CODE]:The city code associated with the zip code range is identified in this field.
;[Description|DESCRIPTION]:A short description of the zip range is provided in this field.
----
This page (revision-3) was last changed on 26-Nov-2021 10:22 by jescottTop