How to fetch Default Shipping Address of BP in Query

[Former Member]

Dear All,

          My Business Partner have More than one Ship To Addresses and I need to fetch the Default Ship To Address in SQL Query.From Which Table i can get This

[Former Member · Accepted solution]

Hi,

Try:

SELECT T0.CardCode, T0.CardName, T0.[ShipToDef] , T1.[Street], T1.[Block], T1.[ZipCode], T1.[City], T1.[Country], T1.[State]

FROM OCRD T0

JOIN CRD1 T1 ON T0.CardCode = T1.CardCode AND T0.[ShipToDef] = T1.Address

WHERE T0.[CardName] LIKE '[%0]%'

Thanks,

Gordon

[Former Member]

Thanks All

[kothandaraman_nagarajan]

Hi,

Try this query:

SELECT T0.[ShipToDef] , T1.[Street], T1.[Block], T1.[ZipCode], T1.[City], T1.[Country], T1.[State] FROM OCRD T0  left JOIN CRD1 T1 ON T0.CardCode = T1.CardCode WHERE T0.[CardCode] = [%0]  group by T0.[ShipToDef] , T1.[Street], T1.[Block], T1.[ZipCode], T1.[City], T1.[Country], T1.[State]

Thanks & Regards,

Nagarajan

[Former Member]

Hi,

It is "OCRD.ShipToDef" and union with CRD1 which contains detail info.

Hope this helps,

TVSon