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)

Sort by

Suggested answer

Chaitanya Golla 17,225 on at

Like (1)

Report
Copy link

Link copied!

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
Suggested answer

Ajit 8,788 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
AXDeveloperJunior 100 on at

Like (0)

Report
Copy link

Link copied!

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