UFN_DISCOUNT_GETAVAILABILITY

This function returns a discount's availability records given its ID.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@DISCOUNTID	uniqueidentifier	IN

Definition

Copy



        create function dbo.UFN_DISCOUNT_GETAVAILABILITY
    (
      @DISCOUNTID uniqueidentifier
    )
        returns table
        as return
            select
                ID,
                ALLOWMONDAY,
                ALLOWTUESDAY,
                ALLOWWEDNESDAY,
                ALLOWTHURSDAY,
                ALLOWFRIDAY,
                ALLOWSATURDAY,
                ALLOWSUNDAY,                
                ALLOWDISCOUNTDATEFROM,
                ALLOWDISCOUNTDATETO,
                ALLOWDISCOUNTTIMEFROM,
                ALLOWDISCOUNTTIMETO,
                dbo.UFN_DISCOUNTAVAILABILITY_CONSTITUENCYCODESLIST(ID) DISCOUNTAVAILABILITYCONSTITUENCYCODES,
                dbo.UFN_DISCOUNTAVAILABILITY_MEMBERSLEVELSLIST(ID) DISCOUNTAVAILABILITYMEMBERS,                
                dbo.UFN_DISCOUNTAVAILABILITY_SALESMETHODSLIST(ID) DISCOUNTAVAILABILITYSALESMETHODS,
                SEQUENCE
            from
                dbo.DISCOUNTAVAILABILITY
            where
                DISCOUNTID=@DISCOUNTID;