I am in the process of dealing with this issue now - for a new store which is on 220.127.116.11 - and may be able to answer some of your questions. I’m not sure if I am using the correct database jargon for these tables and fields but hopefully it makes sense. At the end I asked a question that I have regarding this process.
In the table: sales_flat_shipment_grid you will find:
order_increment_id : the Magento Order number
increment_id : the Magento Shipment number
shipping_name : The full name of the recipient
order_id : this is a key value which appears in other tables
In the table sales_flat_order_address you will find:
parent_id : this matches the order_id value in sales_flat_shipment_grid. However, there are two instances of this value in sales_flat_order_address. One for billing address and one for shipping address.
entity_id : this is a key value in this table. Each parent_id has two entity_ids one for billing address one for shipping. The second entity_id for each parent_id refers to the shipping address needed by WorldShip. The main address fields can be found in this table. Their field names match their contents for the most part. There is a column for email but it doesn’t contain any values in this table in my database. The customer (billing) email address can be found in:
In the table sales_flat_order
entity_id : this is a key value which matches order_id in sales_flat_shipment_grid and parent_id in sales_flat_order_address .
customer_email : customer (billing) email address.
shipping_description : UPS shipping method
For the write back from WorldShip to Magento:
In the table sales_flat_shipment_track
order_id : this is a key value which matches order_id in sales_flat_shipment_grid and parent_id in sales_flat_order_address and entity_id in sales_flat_order
number : UPS tracking number
The problem I am having is finding a way to associate increment_id in sales_flat_shipment_grid (the Magento Shipment number) with the entity_id for the shipping address from sales_flat_order_address. So that my shipper can enter the Magento Shipment number into WorldShip and pull the shipping address. Currently, if I set up relationship between tables based on the shared order/entity/parent id value, WorldShip see both the billing and shipping address and automatically chooses the first which is the billing address.