Skip to Content
0
Former Member
May 19, 2010 at 01:57 PM

Link between OCRD table and CRD1 table

1289 Views

Hi everyone,

I'm trying to create a mailing list from our customer data in SAP Business One. The list will include a lot of the information stored in the OCRD table but I also need to pull the primary billing and shipping addresses for each customer. Those values seemed to be stored in the CRD1 table but I can't find a way to determine which addresses are primary. I can link the OCRD and CRD1 tables based on CardCode but that just pulls every address which doens't really help.

Does anyone know how SAP BO determines the primary billing and shipping addresses in the SQL Database?

Thanks in advance,

Tyler Condon