Hello,
I have been trying to figure out the address mapping in CRM 2013 On Premise. When an address is entered into a lead it exists only in the SQL table LeadAddressBase. OK makes sense.
When the lead is qualified the address is copied to the CustomerAddressBase table and can be searched via the CRM Client as the Address entity.
So far so good.
Next I test the address po box field. In the lead entity this is known as the address1_postofficebox and the address2_postofficebox fields.
Where things seem to get off track is the "mapping" of the po box field. It does NOT make it into the CustomerAddressBase table. The column PostOfficeBox is defined as nvarchar4000 so there should be no data type issues.
The rest of the address makes it in like city, state etc. Just not the PO Box value??
Am I missing something about how this is supposed to work?