When you add your document type to e Connect, you need to create a SQL stored procedure that performs each of these steps.
To complete a create, update, or delete operation, the Dynamics GP Service framework sends an XML document to e Connect.
The name of each input parameter specifies a data field from the IG001 table.
In addition, each input parameter name starts with "@I_v".
Notice the naming convention used with the input parameters.
The use of this naming convention makes it easier to see how the input parameters are used in the stored procedure.
While not required, you should adopt a similar convention that makes it easier to update and maintain your stored procedure.
In the File menu, point to New, and then click Project.
In the New Project window, expand Other Project Types, and then select Database from the list of Project types. Review the Location and Solution Name, and then click OK.