UFN_CONFIGURATIONDATA_ACKNOWLEDGEMENTPROCESSEXPORTFORMAT

Returns all data from the businessprocessexportformat table for acknowledgement processes.

Return

Return Type
table

Definition

Copy



create function dbo.UFN_CONFIGURATIONDATA_ACKNOWLEDGEMENTPROCESSEXPORTFORMAT()
returns table
as
return (
    select ACKNOWLEDGEMENTPROCESSEXPORTFORMAT.PARAMETERSETID ID,
           BUSINESSPROCESSEXPORTFORMAT.CURRENCYSYMBOL,
           BUSINESSPROCESSEXPORTFORMAT.CURRENCYGROUPSEPARATOR,
           BUSINESSPROCESSEXPORTFORMAT.CURRENCYDECIMALSEPARATOR,
           BUSINESSPROCESSEXPORTFORMAT.CURRENCYDECIMALDIGITS,
           BUSINESSPROCESSEXPORTFORMAT.DATEFORMAT,
           BUSINESSPROCESSEXPORTFORMAT.FUZZYDATEFORMAT,
           BUSINESSPROCESSEXPORTFORMAT.MONTHDAYFORMAT,
           BUSINESSPROCESSEXPORTFORMAT.HOURMINUTEFORMAT
    from dbo.BUSINESSPROCESSEXPORTFORMAT
    inner join dbo.ACKNOWLEDGEMENTPROCESSEXPORTFORMAT on ACKNOWLEDGEMENTPROCESSEXPORTFORMAT.ID = BUSINESSPROCESSEXPORTFORMAT.ID
)