Continuing in our series of wrapping the eConnect procs to allow them to be more easily called, today we have a wrapper for the taUpdateCreateCustomerRcd stored procedure.
There are two scripts, the first is the wrapper and the second is the table that we populate before calling the wrapper. Note that some of the fields are defaulted, these are required fields and if you don't populate them, you get a cryptic 'at least one field is null' error. Defaulting them fixes that.
The remaining fields can be left null (except for the required ones)