Seperating Shipping address from Invoice Table
Ship Address gets stored in one field address in OINV or ORDR Table
any way to link that to master Address table to get address separated by address1,address2,city,state and zip
or any other thoughts
Suda Sampath replied
The example below will give you the link between the Sales Order Shipping Address and and BP Master Address table
SELECT DISTINCT T1.Address AS 'Address Name', T1.Street AS 'Street', T1.Block AS 'Block', T1.City AS 'City', T1.State AS 'State', T1.ZipCode AS 'Zip Code', T1.CardCode AS 'BP Code' FROM [dbo].[ORDR] T0 INNER JOIN [dbo].[CRD1] T1 ON T0.CardCode = T1.CardCode WHERE T0.ShipToCode = T1.Address AND T1.AdresType = 'S'