UFN_CONFIGURATIONDATA_POSTTOGLPROCESSEXPORTFORMAT

Returns all data from the businessprocessexportformat table for Post Revenue to GL processes.

Return

Return Type
table

Definition

Copy



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