UFN_BILLINGGENERATETRANSACTIONSPROCESS_GETBILLINGITEMS

Returns the billing items for a generate transactions process.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@BILLINGGENERATETRANSACTIONSPROCESSID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.UFN_BILLINGGENERATETRANSACTIONSPROCESS_GETBILLINGITEMS
(
    @BILLINGGENERATETRANSACTIONSPROCESSID uniqueidentifier
)
returns table
as return
(
    select
        PROCESSBILLINGITEMS.ID,
        PROCESSBILLINGITEMS.BILLINGITEMID,
        BILLINGITEM.NAME
    from
        dbo.BILLINGGENERATETRANSACTIONSCHARGEPROCESSBILLINGITEMS PROCESSBILLINGITEMS
        inner join dbo.BILLINGITEM
            on PROCESSBILLINGITEMS.BILLINGITEMID = BILLINGITEM.ID
    where
        PROCESSBILLINGITEMS.BILLINGGENERATETRANSACTIONSPROCESSID = @BILLINGGENERATETRANSACTIONSPROCESSID
)