UFN_SALESDEPOSITPROCESS_GETALLTRANSACTIONS

Return

Return Type
table

Definition

Copy


CREATE function dbo.UFN_SALESDEPOSITPROCESS_GETALLTRANSACTIONS()
RETURNS TABLE AS
RETURN (
    select 
        T.ID
        ,T.TRANSACTIONDATE
        ,T.PAYMENTMETHODCODE
        ,T.PAYMENTMETHOD
        ,T.SALESMETHODCODE
        ,T.SALESMETHOD
        ,T.CREDITTYPECODEID
        ,T.OTHERPAYMENTMETHODCODEID
        ,T.AMOUNT
        ,T.ISREFUND
    from dbo.UFN_SALESDEPOSITPROCESS_GETACCOUNTSYSTEMTRANSACTIONS(null) T
)