If you have support access to the SalesLogix website, there is a
database schema that you can download.
Trying to do what you want to do requires very good knowledge of the
database structure and which fields and records are mandatory, as well
as the SalesLogix external interfaces. For example, creating a new
account involves both company name and company name uppercase to be
entered, and there must also be a matching record in the account summary
table.
Although not impossible, it is definitely not recommended that you add
records to the SalesLogix database without going through the proper
interfaces.
I see immense difficulties in what you are trying to do,not least in
matching the name on the order with the SalesLogix name, unless you have
parallel IDs in both systems.
Have you considered using the SalesLogix web interface?
Tony
Baobab Consultancy Ltd