Import to SO.ORDHISH table in MAS v4.05 via Visual Integrator

[MAS200Newbie]

Hi all.

I want to import a value for Ship_To_Address3 in the SO_03SOHistoryHeader table in MAS via a visual integrator job.

I have the sales order number and the value I want to add in Address line 3.

I took away all the information from the Validation tab because it kept failing for the SALESPRSN_NO field eveb though I used the file assign.

The VI job completes successfully yet when I look it up in the tables, it does NOT import the ship to address 3 value I want.

How do I import into the sales order history header file?

Thank you in advance.

 

[MAS200Newbie]

By the way, this works when I use the source as table via an ODBC connection. I simply have 2 fields: sales order number and address 3.

Will this corrupt my data in any way instead of using a CSV file?