County code

(1) Share

Report

Posted on by AXDeveloperJunior

100

How can I find the correspondence between a County/Province and its code? For instance, I know that 90008 Zip Code is for "Los Angeles" with code 90 and I get it of two first numbers of ZipCode. Is there any form where I can see it straightly?

Thanks in advance.

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (0)

AXDeveloperJunior 100 on at

Like (0)

Report

RE: County code

This code could be useful, although I wanted it conversely: Get the code from a known County, what I find out with a substring of Zipcode.

Was this reply helpful? Yes No
Suggested answer

Ajit 8,755 on at

Like (1)

Report

RE: County code

County names are not unique, like one county name can be there in multiple states.

Was this reply helpful? Yes No
Suggested answer

Chaitanya Golla 17,225 on at

Like (1)

Report

RE: County code

Hi,

For a given zip code you can get the county list through Address setup form located at the

Path: Organization administration/Setup/Addresses/Address setup.

You can get the county from a given zipcode through below job.

static void Address(Args _args)
{
LogisticsPostalAddress postalAddress;
LogisticsAddressCounty addressCounty;
LogisticsAddressZipCode addressZipCode;

while select addressZipCode
where addressZipCode.ZipCode == "XYZ"
join addressCounty
where addressZipCode.CountryRegionId == addressCounty.CountryRegionId
&& addressZipCode.State == addressCounty.StateId
&& addressZipCode.County == addressCounty.CountyId
{
info(strFmt("ZipCode: %3, County: %1, Name: %2", addressZipCode.ZipCode, addressCounty.CountyId, addressZipCode.ZipCode));
}
}

Was this reply helpful? Yes No