Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

IAFILEDEF


                             IAFILEDEF FILE

UPDATED BY

ACBA.1    ACBC.1    ACBP.1    ACBR.1    ACBS.1    ACBU.1
ACBY.1    ACDL.1    AMAS.1    AMBK.1    AMCV.1    AMDL.1
AMLF.1    AMMD.1    AMME.1    AMPD.1    AMYR.1    HCAG.1
HCCP.1    HCDL.1    HCEM.1    HCHM.1    HCHP.1    HCJC.1
HCMS.1    HCPO.1    HCRV.1    HCSC.1    HCSU.1    HCYR.1
IA120     IA150     IAAP.1    IAMB.1    IANM.1    IATM.1
IAVO.1    IAYR.1    GLBA.1    GLBD.1    GLBP.1    GLBT.1
GLBY.1    GLOP.1    IFBA.1    IFBC.1    IFBO.1    IFBS.1
POA3.1    POAB.1    POAM.1    POAO.1    POAP.1    SACU.1
SALD.1    SALO.1    SAMM.1    SAOR.1    SASC.1    SATE.1
WODL.1    WOME.1    WOOR.1    WOPR.1    WOSC.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

IFI-DATA-MART-NAME     Alpha 20  (Lower Case)                    ACBA.1  ACBC.1
Element: Data Mart NameThis field contains the name of the data  ACBP.1  ACBR.1
                       mart.                                     ACBS.1  ACBU.1
                                                                 ACBY.1  ACDL.1
                                                                 AMAS.1  AMBK.1
                                                                 AMCV.1  AMDL.1
                                                                 AMLF.1  AMMD.1
                                                                 AMME.1  AMPD.1
                                                                 AMYR.1  GLBA.1
                                                                 GLBD.1  GLBP.1
                                                                 GLBT.1  GLBY.1
                                                                 GLOP.1  HCAG.1
                                                                 HCCP.1  HCDL.1
                                                                 HCEM.1  HCHM.1
                                                                 HCHP.1  HCJC.1
                                                                 HCMS.1  HCPO.1
                                                                 HCRV.1  HCSC.1
                                                                 HCSU.1  HCYR.1
                                                                 IA120   IA150
                                                                 IAAP.1  IAMB.1
                                                                 IANM.1  IATM.1
                                                                 IAVO.1  IAYR.1
                                                                 IFBA.1  IFBC.1
                                                                 IFBO.1  IFBS.1
                                                                 POA3.1  POAB.1
                                                                 POAM.1  POAO.1
                                                                 POAP.1  SACU.1
                                                                 SALD.1  SALO.1
                                                                 SAMM.1  SAOR.1
                                                                 SASC.1  SATE.1
                                                                 ...

IFI-USER-DIM-NAME      Alpha 50  (Lower Case)                    ACBA.1  ACBC.1
Element: User Dim Name The User Dimension Name is the name       ACBP.1  ACBR.1
                       associated with the dimension in the      ACBS.1  ACBU.1
                       data mart outline. This user-defined      ACBY.1  ACDL.1
                       name can contain up to 50 alphanumeric    AMAS.1  AMBK.1
                       characters. For example, you might name   AMCV.1  AMDL.1
                       a dimension Fiscal Year or Organization.  AMLF.1  AMMD.1
                                                                 AMME.1  AMPD.1
                                                                 AMYR.1  GLBA.1
                                                                 GLBD.1  GLBP.1
                                                                 GLBT.1  GLBY.1
                                                                 GLOP.1  HCAG.1
                                                                 HCCP.1  HCDL.1
                                                                 HCEM.1  HCHM.1
                                                                 HCHP.1  HCJC.1
                                                                 HCMS.1  HCPO.1
                                                                 HCRV.1  HCSC.1
                                                                 HCSU.1  HCYR.1
                                                                 IA120   IA150
                                                                 IAAP.1  IAMB.1
                                                                 IANM.1  IATM.1
                                                                 IAVO.1  IAYR.1
                                                                 IFBA.1  IFBC.1
                                                                 IFBO.1  IFBS.1
                                                                 POA3.1  POAB.1
                                                                 POAM.1  POAO.1
                                                                 POAP.1  SACU.1
                                                                 SALD.1  SALO.1
                                                                 SAMM.1  SAOR.1
                                                                 SASC.1  SATE.1
                                                                 ...

IFI-LEVEL-NBR          Numeric 3                                 ACBA.1  ACBC.1
Element: Level Nbr                                               ACBP.1  ACBR.1
                                                                 ACBS.1  ACBU.1
                                                                 ACBY.1  ACDL.1
                                                                 AMAS.1  AMBK.1
                                                                 AMCV.1  AMDL.1
                                                                 AMLF.1  AMMD.1
                                                                 AMME.1  AMPD.1
                                                                 AMYR.1  GLBA.1
                                                                 GLBD.1  GLBP.1
                                                                 GLBT.1  GLBY.1
                                                                 GLOP.1  HCAG.1
                                                                 HCCP.1  HCDL.1
                                                                 HCEM.1  HCHM.1
                                                                 HCHP.1  HCJC.1
                                                                 HCMS.1  HCPO.1
                                                                 HCRV.1  HCSC.1
                                                                 HCSU.1  HCYR.1
                                                                 IA120   IA150
                                                                 IAAP.1  IAMB.1
                                                                 IANM.1  IATM.1
                                                                 IAVO.1  IAYR.1
                                                                 IFBA.1  IFBC.1
                                                                 IFBO.1  IFBS.1
                                                                 POA3.1  POAB.1
                                                                 POAM.1  POAO.1
                                                                 POAP.1  SACU.1
                                                                 SALD.1  SALO.1
                                                                 SAMM.1  SAOR.1
                                                                 SASC.1  SATE.1
                                                                 ...

IFI-COLUMN-CAT         Alpha 1                                   ACBA.1  ACBC.1
Element: Column Cat    L = Level Column                          ACBP.1  ACBR.1
                       P = Property Column                       ACBS.1  ACBU.1
                       I = ID Column                             ACBY.1  ACDL.1
                       S = Sort Order Column                     AMAS.1  AMBK.1
                       M = Measure Column                        AMCV.1  AMDL.1
                       U = Unary Operator Column                 AMLF.1  AMMD.1
                                                                 AMME.1  AMPD.1
                                                                 AMYR.1  GLBA.1
                                                                 GLBD.1  GLBP.1
                                                                 GLBT.1  GLBY.1
                                                                 GLOP.1  HCAG.1
                                                                 HCCP.1  HCDL.1
                                                                 HCEM.1  HCHM.1
                                                                 HCHP.1  HCJC.1
                                                                 HCMS.1  HCPO.1
                                                                 HCRV.1  HCSC.1
                                                                 HCSU.1  HCYR.1
                                                                 IA120   IA150
                                                                 IAAP.1  IAMB.1
                                                                 IANM.1  IATM.1
                                                                 IAVO.1  IAYR.1
                                                                 IFBA.1  IFBC.1
                                                                 IFBO.1  IFBS.1
                                                                 POA3.1  POAB.1
                                                                 POAM.1  POAO.1
                                                                 POAP.1  SACU.1
                                                                 SALD.1  SALO.1
                                                                 SAMM.1  SAOR.1
                                                                 SASC.1  SATE.1
                                                                 ...

IFI-COLUMN-DESC        Alpha 50  (Lower Case)                    ACBA.1  ACBC.1
Element: Column Desc                                             ACBP.1  ACBR.1
                                                                 ACBS.1  ACBU.1
                                                                 ACBY.1  ACDL.1
                                                                 AMAS.1  AMBK.1
                                                                 AMCV.1  AMDL.1
                                                                 AMLF.1  AMMD.1
                                                                 AMME.1  AMPD.1
                                                                 AMYR.1  GLBA.1
                                                                 GLBD.1  GLBP.1
                                                                 GLBT.1  GLBY.1
                                                                 GLOP.1  HCAG.1
                                                                 HCCP.1  HCDL.1
                                                                 HCEM.1  HCHM.1
                                                                 HCHP.1  HCJC.1
                                                                 HCMS.1  HCPO.1
                                                                 HCRV.1  HCSC.1
                                                                 HCSU.1  HCYR.1
                                                                 IA120   IA150
                                                                 IAAP.1  IAMB.1
                                                                 IANM.1  IATM.1
                                                                 IAVO.1  IAYR.1
                                                                 IFBA.1  IFBC.1
                                                                 IFBO.1  IFBS.1
                                                                 POA3.1  POAB.1
                                                                 POAM.1  POAO.1
                                                                 POAP.1  SACU.1
                                                                 SALD.1  SALO.1
                                                                 SAMM.1  SAOR.1
                                                                 SASC.1  SATE.1
                                                                 ...

IFI-COLUMN-SIZE        Numeric 3                                 ACBA.1  ACBC.1
Element: Column Size                                             ACBP.1  ACBR.1
                                                                 ACBS.1  ACBU.1
                                                                 ACBY.1  ACDL.1
                                                                 AMAS.1  AMBK.1
                                                                 AMCV.1  AMDL.1
                                                                 AMLF.1  AMMD.1
                                                                 AMME.1  AMPD.1
                                                                 AMYR.1  GLBA.1
                                                                 GLBD.1  GLBP.1
                                                                 GLBT.1  GLBY.1
                                                                 GLOP.1  HCAG.1
                                                                 HCCP.1  HCDL.1
                                                                 HCEM.1  HCHM.1
                                                                 HCHP.1  HCJC.1
                                                                 HCMS.1  HCPO.1
                                                                 HCRV.1  HCSC.1
                                                                 HCSU.1  HCYR.1
                                                                 IA120   IA150
                                                                 IAAP.1  IAMB.1
                                                                 IANM.1  IATM.1
                                                                 IAVO.1  IAYR.1
                                                                 IFBA.1  IFBC.1
                                                                 IFBO.1  IFBS.1
                                                                 POA3.1  POAB.1
                                                                 POAM.1  POAO.1
                                                                 POAP.1  SACU.1
                                                                 SALD.1  SALO.1
                                                                 SAMM.1  SAOR.1
                                                                 SASC.1  SATE.1
                                                                 ...

IFI-COLUMN-ATTR        Alpha 1                                   ACBA.1  ACBC.1
Element: Column Attr   I = Int                                   ACBP.1  ACBR.1
                       V = Varchar                               ACBS.1  ACBU.1
                       N = Numeric                               ACBY.1  ACDL.1
                                                                 AMAS.1  AMBK.1
                                                                 AMCV.1  AMDL.1
                                                                 AMLF.1  AMMD.1
                                                                 AMME.1  AMPD.1
                                                                 AMYR.1  GLBA.1
                                                                 GLBD.1  GLBP.1
                                                                 GLBT.1  GLBY.1
                                                                 GLOP.1  HCAG.1
                                                                 HCCP.1  HCDL.1
                                                                 HCEM.1  HCHM.1
                                                                 HCHP.1  HCJC.1
                                                                 HCMS.1  HCPO.1
                                                                 HCRV.1  HCSC.1
                                                                 HCSU.1  HCYR.1
                                                                 IA120   IA150
                                                                 IAAP.1  IAMB.1
                                                                 IANM.1  IATM.1
                                                                 IAVO.1  IAYR.1
                                                                 IFBA.1  IFBC.1
                                                                 IFBO.1  IFBS.1
                                                                 POA3.1  POAB.1
                                                                 POAM.1  POAO.1
                                                                 POAP.1  SACU.1
                                                                 SALD.1  SALO.1
                                                                 SAMM.1  SAOR.1
                                                                 SASC.1  SATE.1
                                                                 ...

IFI-COLUMN-DECIMAL     Numeric 2                                 ACBA.1  ACBC.1
Element: Column Decimal                                          ACBP.1  ACBR.1
                                                                 ACBS.1  ACBU.1
                                                                 ACBY.1  ACDL.1
                                                                 AMAS.1  AMBK.1
                                                                 AMCV.1  AMDL.1
                                                                 AMLF.1  AMMD.1
                                                                 AMME.1  AMPD.1
                                                                 AMYR.1  GLBA.1
                                                                 GLBD.1  GLBP.1
                                                                 GLBT.1  GLBY.1
                                                                 GLOP.1  HCAG.1
                                                                 HCCP.1  HCDL.1
                                                                 HCEM.1  HCHM.1
                                                                 HCHP.1  HCJC.1
                                                                 HCMS.1  HCPO.1
                                                                 HCRV.1  HCSC.1
                                                                 HCSU.1  HCYR.1
                                                                 IA120   IA150
                                                                 IAAP.1  IAMB.1
                                                                 IANM.1  IATM.1
                                                                 IAVO.1  IAYR.1
                                                                 IFBA.1  IFBC.1
                                                                 IFBO.1  IFBS.1
                                                                 POA3.1  POAB.1
                                                                 POAM.1  POAO.1
                                                                 POAP.1  SACU.1
                                                                 SALD.1  SALO.1
                                                                 SAMM.1  SAOR.1
                                                                 SASC.1  SATE.1
                                                                 ...

IFI-LAW-COL-NAME       Alpha 50  (Lower Case)                    ACBA.1  ACBC.1
Element: Law Col Name                                            ACBP.1  ACBR.1
                                                                 ACBS.1  ACBU.1
                                                                 ACBY.1  ACDL.1
                                                                 AMAS.1  AMBK.1
                                                                 AMCV.1  AMDL.1
                                                                 AMLF.1  AMMD.1
                                                                 AMME.1  AMPD.1
                                                                 AMYR.1  GLBA.1
                                                                 GLBD.1  GLBP.1
                                                                 GLBT.1  GLBY.1
                                                                 GLOP.1  HCAG.1
                                                                 HCCP.1  HCDL.1
                                                                 HCEM.1  HCHM.1
                                                                 HCHP.1  HCJC.1
                                                                 HCMS.1  HCPO.1
                                                                 HCRV.1  HCSC.1
                                                                 HCSU.1  HCYR.1
                                                                 IA120   IA150
                                                                 IAAP.1  IAMB.1
                                                                 IANM.1  IATM.1
                                                                 IAVO.1  IAYR.1
                                                                 IFBA.1  IFBC.1
                                                                 IFBO.1  IFBS.1
                                                                 POA3.1  POAB.1
                                                                 POAM.1  POAO.1
                                                                 POAP.1  SACU.1
                                                                 SALD.1  SALO.1
                                                                 SAMM.1  SAOR.1
                                                                 SASC.1  SATE.1
                                                                 ...

IFI-CREATED-GEN        Alpha 1                                   ACBA.1  ACBC.1
Element: Created Gen   Y                                         ACBP.1  ACBR.1
                       N                                         ACBS.1  ACBU.1
                                                                 ACBY.1  ACDL.1
                                                                 AMAS.1  AMBK.1
                                                                 AMCV.1  AMDL.1
                                                                 AMLF.1  AMMD.1
                                                                 AMME.1  AMPD.1
                                                                 AMYR.1  GLBA.1
                                                                 GLBD.1  GLBP.1
                                                                 GLBT.1  GLBY.1
                                                                 GLOP.1  HCAG.1
                                                                 HCCP.1  HCDL.1
                                                                 HCEM.1  HCHM.1
                                                                 HCHP.1  HCJC.1
                                                                 HCMS.1  HCPO.1
                                                                 HCRV.1  HCSC.1
                                                                 HCSU.1  HCYR.1
                                                                 IA120   IA150
                                                                 IAAP.1  IAMB.1
                                                                 IANM.1  IATM.1
                                                                 IAVO.1  IAYR.1
                                                                 IFBA.1  IFBC.1
                                                                 IFBO.1  IFBS.1
                                                                 POA3.1  POAB.1
                                                                 POAM.1  POAO.1
                                                                 POAP.1  SACU.1
                                                                 SALD.1  SALO.1
                                                                 SAMM.1  SAOR.1
                                                                 SASC.1  SATE.1
                                                                 ...

IFI-KEY-INDICATOR      Alpha 1
Element: Key Indicator N = No
                       Y = Yes

                         IAFILEDEF FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

IFISET1   USER-DIM-NAME KeyChange                                ACBA.1  ACBC.1
          DATA-MART-NAME                                         ACBP.1  ACBR.1
          LEVEL-NBR                                              ACBS.1  ACBU.1
          COLUMN-CAT                                             ACBY.1  AMAS.1
          COLUMN-DESC                                            AMBK.1  AMCV.1
                                                                 AMLF.1  AMMD.1
                                                                 AMME.1  AMPD.1
                                                                 AMYR.1  HCAG.1
                                                                 HCCP.1  HCEM.1
                                                                 HCHM.1  HCJC.1
                                                                 HCMS.1  HCPO.1
                                                                 HCRV.1  HCSC.1
                                                                 HCSU.1  HCYR.1
                                                                 IA120   IA150
                                                                 IAAP.1  IAMB.1
                                                                 ...

IFISET2   USER-DIM-NAME KeyChange                                ACBA.1  ACBC.1
          DATA-MART-NAME                                         ACBP.1  ACBR.1
          COLUMN-DESC                                            ACBS.1  ACBU.1
                                                                 ACBY.1  ACDL.1
                                                                 AMAS.1  AMBK.1
                                                                 AMCV.1  AMDL.1
                                                                 AMLF.1  AMMD.1
                                                                 AMME.1  AMPD.1
                                                                 AMYR.1  HCAG.1
                                                                 HCCP.1  HCDL.1
                                                                 HCEM.1  HCHM.1
                                                                 HCHP.1  HCJC.1
                                                                 HCMS.1  HCPO.1
                                                                 HCRV.1  HCSC.1
                                                                 HCSU.1  HCYR.1
                                                                 ...

IFISET3   USER-DIM-NAME KeyChange, Subset                        IANM.1
          LEVEL-NBR     Where USER-DIM-NAME != Spaces
          COLUMN-CAT
          COLUMN-DESC

IFISET4   DATA-MART-NAMEKeyChange, Subset                        ACDL.1  AMDL.1
          LEVEL-NBR     Where DATA-MART-NAME != Spaces           HCDL.1  HCHP.1
          COLUMN-CAT                                             IA150   IANM.1
          COLUMN-DESC                                            GLOP.1  POA3.1
                                                                 SALD.1  WODL.1

IFISET5   USER-DIM-NAME KeyChange
          DATA-MART-NAME
          LEVEL-NBR
          COLUMN-CAT
          LAW-COL-NAME

IFISET6   DATA-MART-NAMEKeyChange                                IAAP.1
          USER-DIM-NAME
          COLUMN-CAT
          LAW-COL-NAME

IFISET7   DATA-MART-NAMEKeyChange                                IAAP.1
          USER-DIM-NAME
          COLUMN-CAT
          LEVEL-NBR
          COLUMN-DESC