USP_DATALIST_WORKSTATIONCASHDRAWERPAYMENTMETHOD

List all payment methods that open cash drawer for a workstation

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



CREATE procedure dbo.USP_DATALIST_WORKSTATIONCASHDRAWERPAYMENTMETHOD
(
    @ID uniqueidentifier
)
as
    set nocount on;

    select
        ID,
        case when PAYMENTTYPECODE = 10 then
            dbo.UFN_OTHERPAYMENTMETHODCODE_GETDESCRIPTION(OTHERPAYMENTMETHODCODEID)
        else
            PAYMENTTYPE
        end as [PAYMENTTYPE]        
    from
        dbo.WORKSTATIONCASHDRAWERPAYMENTMETHOD
    where
        WORKSTATIONCASHDRAWERPAYMENTMETHOD.WORKSTATIONID = @ID

    return 0;