Hi @paulbrettibm ,
We are currently trying to map X12 835 transaction to our DB (SQL Server 2016).
However, we are having issues with creating the DB Design for a 835 transaction.
We have tried resorting to tools such as XMLSpy to convert XML to DB but to no avail (apparently the xsd created from design studio doesnt work).
We are trying to manually create tables for the 835 transaction for this scenario.
Could you let us know if there is a way to automatically generate a relational DB Design from the 835 .mtt file or .xsd file?
Looking forward to hearing from you.