USP_DATALIST_SALESORDERCONSTITUENT
Returns the sales orders for a constituent, or verifies validity/state for a given ID.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SALESMETHODTYPECODE | tinyint | IN | Input parameter indicating the context ID for the data list. |
| @STATUSCODE | tinyint | IN | Status Code |
| @CONSTITUENTID | uniqueidentifier | IN | Constituent ID |
| @SALESORDERID | uniqueidentifier | IN | ID |
Definition
Copy
CREATE procedure dbo.USP_DATALIST_SALESORDERCONSTITUENT(
@SALESMETHODTYPECODE tinyint,
@STATUSCODE tinyint = 0, -- = pending
@CONSTITUENTID uniqueidentifier = null,
@SALESORDERID uniqueidentifier = null
)
as
set nocount on;
select
ID as SALESORDERID, CONSTITUENTID
from dbo.SALESORDER
where (SALESMETHODTYPECODE = @SALESMETHODTYPECODE)
and (STATUSCODE = @STATUSCODE)
and ((@CONSTITUENTID IS NULL) OR (CONSTITUENTID = @CONSTITUENTID))
and ((@SALESORDERID IS NULL) OR (@SALESORDERID = ID))
order by DATECHANGED DESC