Importing Sales Orders with order lines via VI 1

[GoGoGadgetMAS90]

Hello everyone, I have a quick question. I'm using Visual Integrator to import Sales Orders right now from a CSV file. Right now I have the Sales Orders coming in and posting, but I have one issue. I have numerous order lines for each order I'm importing, and I'm having troubles figuring out how to bring in the lines as well. I know from connecting to the MAS90 tables with an ODBC connection that there is a table separate from the main SO.ORDERS(SO1_SOEntryHeader) table for storing the detail lines, called SO2_SOEntryDetailLine, but for some reason this table isn't available for selection in the 'MAS90 File Select' dialog in the Import Job Maintenance area.
I'm sure that I will need to make my CSV file with both the order and order line information, with a record type column or similar concept to dictate where to put the records once they come in. I'm just curious as to where I would put the order line information once I get it separated out. Anyone have any suggestions or ideas?

 

[Blorf]

Hi, you put your sales order header, and your sales order lines in the same csv record, and in your vi job select details included with header.

Make sure you specify record types uder the records tab also.

ChaZ

 

[GoGoGadgetMAS90]

Thanks for the help, this did the trick.