User Tools

Site Tools


dynamiczip:tables:dz_plus4_geocode_table

This is an old revision of the document!


DZ Plus4 Geocode table

Permission to access this table is granted to the Tax Setup Task.

Display Name DZ Plus4 Geocode
Technical Name KD_Plus4Geocode
Physical Name DZ00800
Database COMPANY1)

This table2) contains a record for each contiguous group of Plus4's having a common Tax Location for each ZIP code included in the import.

The table is populated by the rate & boundary import but only if the optional Zip+4 Option is enabled and the proper ZipPlus4.txt file exists in the Import Folder.

The table is used by the Zip+4 Option to identify the Tax Location based on the ZIP+4 in the address.

Data Model Changes

Build 74

Fields Added

  • RateSet Index

Fields Removed

  • Default For Zip

Build 72

Fields Added

  • KD Update Number (Used to identify which records were included in a particular update.)

DynamicZip Tables

1)
Prior to build 74 this table was in the DYNAMICS database
2)
Added with Build 70.
dynamiczip/tables/dz_plus4_geocode_table.1432739466.txt.gz · Last modified: 2015/05/27 15:11 by chuck

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki