UFN_CREDIT_GETORDERPAYMENTS
Returns order payment items for a given sales order id
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SALESORDERID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_CREDIT_GETORDERPAYMENTS
(
@SALESORDERID uniqueidentifier
) returns @PAYMENTS table
(
[INCLUDE] bit,
[DESCRIPTION] nvarchar(100),
[DISPLAYDESCRIPTION] nvarchar(100),
[DISPLAYSOURCE] nvarchar(100),
[SOURCENUMBER] integer,
[SOURCETYPE] tinyint,
[REFUNDAMOUNT] money,
[AMOUNTPAID] money,
[PAYMENTTYPECODE] tinyint,
[REVENUEID] uniqueidentifier,
[REVENUESPLITID] uniqueidentifier,
[TRANSACTIONID] uniqueidentifier,
[OTHERPAYMENTMETHODCODEID] uniqueidentifier
)
begin
insert into @PAYMENTS
select
[INCLUDE],
[DESCRIPTION],
[DISPLAYDESCRIPTION],
[DISPLAYSOURCE],
[SOURCENUMBER],
[SOURCETYPE],
[REFUNDAMOUNT],
[AMOUNTPAID],
[PAYMENTTYPECODE],
[REVENUEID],
[REVENUESPLITID],
[TRANSACTIONID],
[OTHERPAYMENTMETHODCODEID]
from dbo.UFN_CREDIT_GETORDERPAYMENTS_2(@SALESORDERID)
return;
end