If you look at the schema browser for Sage 500 you will find the information on the Sales Order records to include the Header, detail, and distribution records. 

Also, you cannot go directly from stgSOLine to tsoSOLine.  It doesn't contain all the information tsoSOLine needs (SurrogateKey for example) and you are skipping any validations on the data.  stgSOLine is part of the Data Import Manager's Import Sales Order process. 

If you are trying to import sales orders into Sage 500, I recommend you try using this first.  If you are not licensed for it, you can still create a process using stored procedure spsoAPISalesOrderIns.  Review this stored procedure and you will see how stgSOLine and the other staging tables are used to create sales orders in Sage 500.  

I would also recommend working with your reseller to assist in the  proper design and the test plan for this process to avoid any possibility of data corruption in the system.

If you look at the schema browser for Sage 500 you will find the information on the Sales Order records to include the Header, detail, and distribution records. 

Also, you cannot go directly from stgSOLine to tsoSOLine.  It doesn't contain all the information tsoSOLine needs (SurrogateKey for example) and you are skipping any validations on the data.  stgSOLine is part of the Data Import Manager's Import Sales Order process. 

If you are trying to import sales orders into Sage 500, I recommend you try using this first.  If you are not licensed for it, you can still create a process using stored procedure spsoAPISalesOrderIns.  Review this stored procedure and you will see how stgSOLine and the other staging tables are used to create sales orders in Sage 500.  

I would also recommend working with your reseller to assist in the  proper design and the test plan for this process to avoid any possibility of data corruption in the system.