This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(294.40000000000003, 82%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJB%3C/text%3E%3C/svg%3E)
Any suggestions on building and maintaining a table in SQL server that will be used to cross refence for EDI?
Can you share more details about this question?
Karen Lopez we have an external database that can map the necessary fields and was looking for best practice as each trading partner requires different fields not in the ERP.
Still more then unclear, you have to provide more detailed informations.
Hi Jonathan Brotto,
Kindly provide more details of the requirements. We have EDI in place in our company but I'm not sure if it is what you meant.
@Ruel G. Cabusas We have a table that matches a UPC based on our Product code as to sent the correct UPC and Description for the customer.
There is an open data standard for Retail and Distributor data models/database designs hosted by the Open Group. It addresses UPC/GTIN to internal product codes mapping. You might want to look that up.
Hi Jonathan Brotto,
In my previous projects, we usually call it product mapping and if I understand it correctly this is how I will do it.
If you want it to be exported as .csv you can do it pragmatically in T-SQL but I usually have it done using SSIS.
Do you need a code or the illustration is enough?