I need to generate an outbound 834 from our internal application and I need
some assistance as to what is the best way to structure my source schema
(our
application data) to ease and simplify the mapping of our data to the 834
schema. The data exists in an SQL 2005 database. I realize the reader of
this post does not know about how our internal application and how it is
structured but I would think there is probably a preferred application
schema
approach to use to ease the data mapping to the 834 schema.