Understand MES stored procedure naming conventions

For standard database operations on a single table (i.e., Add, Delete, GetAll, GetSpecific, Update), MES stored procedure names have the following format:

sp_operationtype_tablename

where operationtype is one of the following:

• I for an Add

• D for a Delete

• SA for a GetAll

• S for a GetSpecific

• U for an Update

  For example:

  	Add an item:	sp_I_Item
  	Delete a site:	sp_D_Site
  	Get all customers:	sp_SA_Cust
  	Get a specific cause:	sp_S_Cause
  	Update an attribute:	sp_U_Attr

For other database operations, the stored procedure name includes the object being acted on and the action. For example:

• To transfer items, sp_U_Item_Transfer

• To add item consumption after a job has been run, sp_I_IC_AddConsPostExecByName