UFN_CONFIGURATIONDATA_EXPORTPROCESSEXPORTFORMAT

Returns all data from the businessprocessexportformat table for export processes.

Return

Return Type
table

Definition

Copy



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