Wednesday, January 30, 2013

Dynamics GP - Customer Internet Information Table

Customer Internet Information Table - SY01200


To join to the Customer Master - RM00101




SELECT    * from RM00101 LEFT OUTER JOIN
                      dbo.SY01200 ON dbo.RM00101.CUSTNMBR = dbo.SY01200.Master_ID AND dbo.RM00101.ADRSCODE = dbo.SY01200.ADRSCODE


You can do a straight sql insert or table import into this table.

No comments:

Post a Comment