Dynamics GP 10.0: Where is stored procedure documentation?

(0) Share

Report

Posted on by Community Member

Regarding Dynamics GP 10.0: Where is stored procedure (aka, "Business Object")documentation? I'd like to call some of these stored procedures from my application, but I can't find anything to tell me what the names of the procedures are, what the parameters are, or what they do...at least the eConnect programmer's guide doesn't mention this.

thanks

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Andrew John Dean 1,337 on at

Like (0)

Report

Each GP table has a series of associated stored procedures that allow records to be selected, inserted and deleted. These stored procedures have prefix 'zDP' followed by the table name. There are some stored procedures that contain business logic however for the most part, the GP business logic is performed in the dexterity code.

The architecture of eConnect differs in that all the business logic is contained inside of the stored procedures however these procedures are encrypted. If you looking for these eConnect stored procedures have the prefix 'ta'. Although I have directly called the eConnect stored procedures for a past project where I needed to wrap GP function calls into a larger database transaction, I would not recommend it. Better option is a use the .NET library or web service.

Regards

Andrew Dean

Was this reply helpful? Yes No