Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

FDDETAIL


                             FDDETAIL FILE

                             Budget Detail

REFERENCED BY

IFBA.1    IFBO.1

UPDATED BY

IFAS.1    IFOS.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

FDD-USER-DIM-NAME      Alpha 50  (Lower Case)                    IFAS.1  IFOS.1
Element: User Dim Name The User Dimension Name is the name
                       associated with the dimension in the
                       data mart outline. This user-defined
                       name can contain up to 50 alphanumeric
                       characters. For example, you might name
                       a dimension Fiscal Year or Organization.


FDD-MBR-TYPE           Alpha 2                                   IFAS.1  IFOS.1
Element: Mbr Type      The Member Type field specifies the
                       member type.

                       Valid values are:
                       BD = Budget
                       BV = Budget Variance
                       CH = Alternate Chart
                       FY = Fiscal Year
                       PD = Period
                       PY = Period Year-to-Date
                       QR = Quarter
                       QY = Quarter Year-to-Date
                       SA = Subaccount
                       VW = View
                       YV = Year Variance

FDD-MBR-NAME           Alpha 30  (Lower Case)                    IFAS.1  IFOS.1
Element: Mbr Name      The Member Name field contains the
                       user-defined member name for the income
                       statement member. This name can contain
                       up to 30 characters of any kind.

FDD-ATTRIBUTE-NAME     Alpha 50  (Lower Case)
Element: Attribute Name

FDD-GEN-LEVEL-NBR      Numeric 2
Element: Gen Level Nbr

                         FDDETAIL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

FDDSET1   USER-DIM-NAME                                          IFAS.1  IFBA.1
          MBR-TYPE                                               IFBO.1  IFOS.1
          MBR-NAME