address2_address_type_code

TheMSsForum.com: The Microsoft Software Forum

In CRM 1.2 I used the address2_address_type_code for a custom drop-down box
on the Account Form: Market Segment.

Since upgrading to CRM 3.0, while the data still appears on the form, I
cannot find the field in the database to use it for data selection in
reports.

Where is this field? It is not in the Account table.

Thanks,

Boolean1
Top

Re: address2_address_type_code by Dave

Dave
Thu Jan 18 20:08:00 CST 2007

address fields are stored in the CustomerAddressBase table - have a look
there.

Dave Ireland


"Boolean1" <Boolean1@comcast.net> wrote in message
news:psOdnZ-rcLLKFjLYnZ2dnUVZ_uyknZ2d@comcast.com...
> In CRM 1.2 I used the address2_address_type_code for a custom drop-down
> box on the Account Form: Market Segment.
>
> Since upgrading to CRM 3.0, while the data still appears on the form, I
> cannot find the field in the database to use it for data selection in
> reports.
>
> Where is this field? It is not in the Account table.
>
> Thanks,
>
> Boolean1


Top

Re: address2_address_type_code by Boolean1

Boolean1
Tue Jan 30 22:56:12 CST 2007

Dave,

I think you're right...was this how it was in CRM 1.2? Or did the database
structure change? Does anybody know? Just curious.

Thanks,

Boolean1

"Dave Ireland" <direland@salentica.com> wrote in message
news:e6mvx62OHHA.4940@TK2MSFTNGP03.phx.gbl...
> address fields are stored in the CustomerAddressBase table - have a look
> there.
>
> Dave Ireland
>
>
> "Boolean1" <Boolean1@comcast.net> wrote in message
> news:psOdnZ-rcLLKFjLYnZ2dnUVZ_uyknZ2d@comcast.com...
>> In CRM 1.2 I used the address2_address_type_code for a custom drop-down
>> box on the Account Form: Market Segment.
>>
>> Since upgrading to CRM 3.0, while the data still appears on the form, I
>> cannot find the field in the database to use it for data selection in
>> reports.
>>
>> Where is this field? It is not in the Account table.
>>
>> Thanks,
>>
>> Boolean1
>
>

Top