Minor correction to the parameter list, partial of the parameter list

CustomerCode = CUST-000040 (new customer code)
DefaultShipToCode = NULL (FK_Customer_CustomerShipTo)
CustomerGUID = NULL

Gary,

Nice tip.   Thank you very much.

Here is what I am going to do.

1. Create a contact in the CRMContact table
2. Create a new customer record in the Customer table with
    DefaultContact = contact in step 1
    DefaultAPContact = contact in step 1
    DefaultShipToCode = null
3. Create a CustomerShipTo record in the CustomerShipTo table with
    CustomerCode = customer from step 2
    ContactCode = contact from step 1
   
4. Update the new customer record from step 2
    DefaultShipToCode = ShipToCode from step 3

What do you think?

I have not tested this procedure yet.

Thanks.

Francis