UFN_CREDIT_GETSALESORDERDISCOUNTITEMS
Returns the order-level discounts for the given sales order ID
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SALESORDERID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_CREDIT_GETSALESORDERDISCOUNTITEMS
(
@SALESORDERID uniqueidentifier
) returns @SALESORDERDISCOUNTITEMS table
(
SALESORDERID uniqueidentifier,
AMOUNT money
)
begin
insert into @SALESORDERDISCOUNTITEMS
select
ID,
PRICE
from SALESORDERITEM
where TYPECODE = 5 and SALESORDERID = @SALESORDERID
return;
end