USP_DATALIST_CMSUSERSALESORDER
Returns the active sales order ID associated with the specified CMS user.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CMSUSERID | int | IN | Input parameter indicating the context ID for the data list. |
Definition
Copy
create procedure dbo.USP_DATALIST_CMSUSERSALESORDER(@CMSUSERID int)
as
set nocount on;
select SALESORDERID
from dbo.CMSUSERSALESORDER
where CLIENTUSERID = @CMSUSERID