UFN_CHARGE_GETBILLINGITEMID
Returns the billing item ID for a given charge.
Return
| Return Type |
|---|
| uniqueidentifier |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_CHARGE_GETBILLINGITEMID
(
@ID uniqueidentifier
)
returns uniqueidentifier
as begin
declare @retval uniqueidentifier;
select
@retval=BILLINGITEMID
from
dbo.CHARGE
where
dbo.CHARGE.ID=@ID
return @retval;
end