Re: Best Practices for Application Schema for Outbound 834

Like you said, without knowing more, it is challenging to offer a 
suggestion.I would have an extract where it pulls 'header' information and

then details where it has the informaiton that will populate the 2300
level 
loop.
Sorry I could not be of more assistance,
Eric
http://blog.biztalk-info.com

"Mark Vance" <Mark Vance@[EMAIL PROTECTED]
> wrote in message 
news:ED1456C9-732C-4B73-9E3C-7EEBC342642E@[EMAIL PROTECTED]
>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.