Duplicate record in addresszipcode table.

(0) Share

Report

Posted on by Saurabh P Singh

890

Hi,

I am having duplicate record in my table addresszipcode, which shouldnot happen. So, is there any method by which i could restrict it at the table level.

Regards,

*This post is locked for comments

All responses (4)

Answers (1)

Saurabh P Singh 890 on at

Like (0)

Report

Re: Duplicate record in addresszipcode table.

Hi Brandon Wiese,

Thanks alot for the help.

Regards,
Verified answer

Brandon Wiese 17,788 on at

Like (0)

Report

Re: Duplicate record in addresszipcode table.

Unfortunately ZipCode is not a unique key in the AddressZipCode table as you might think. First, different countries could use the same ZipCode, and that's valid, so at the very least you might find the same ZipCode used with different CountryRegionId's.

But, the design of the AddressZipCode table goes further and provides fields like StreetName and FromNum, ToNum, and EvenOdd which are used to describe street-level ZipCode usage. While it is flexible enough to allow for the full ZIP+4 data set in the United States, for example, it is simply not smart enough to use the data usefully. That, and the data set is massive (>30 million records).

If you want to use ZipCode unique, simply create an Index on CountryRegionId and ZipCode, make it unique (set AllowDuplicates to No), and that will enforce the restriction at the table level.
Saurabh P Singh 890 on at

Like (0)

Report

Re: Duplicate record in addresszipcode table.

It's Ax 2009, Actually each value in the addresszipcode table is being repeated.
Brandon Wiese 17,788 on at

Like (0)

Report

Re: Duplicate record in addresszipcode table.

What version of AX?

What type of duplicate? Same zipcode on multiple records? RecId conflict?