Share via

EDI cross reference table

Jonathan Brotto 420 Reputation points
2024-04-19T19:37:38.3733333+00:00

Any suggestions on building and maintaining a table in SQL server that will be used to cross refence for EDI?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,977 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,652 questions
Accepted answer
  1. Karen Lopez 81 Reputation points MVP
    2024-05-12T21:33:10.6866667+00:00

    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.

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ruel G. Cabusas 210 Reputation points
    2024-05-09T14:31:08.3233333+00:00

    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?
    User's image

    3 people found this answer helpful.
    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.