Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

IAFILEDLT


                             IAFILEDLT FILE

UPDATED BY

ACBA.1    ACBC.1    ACBP.1    ACBR.1    ACBS.1    ACBU.1
ACBY.1    AMAS.1    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
IATM.1    IAVO.1    IAYR.1    GLBA.1    GLBD.1    GLBP.1
GLBT.1    GLBY.1    IFBA.1    IFBC.1    IFBO.1    IFBS.1
POAB.1    POAM.1    POAO.1    POAP.1    SACU.1    SALO.1
SAMM.1    SAOR.1    SASC.1    SATE.1    WOME.1    WOOR.1
WOPR.1    WOSC.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

DLT-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  AMAS.1
                                                                 AMBK.1  AMCV.1
                                                                 AMLF.1  AMMD.1
                                                                 AMME.1  AMPD.1
                                                                 AMYR.1  GLBA.1
                                                                 GLBD.1  GLBP.1
                                                                 GLBT.1  GLBY.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  IATM.1
                                                                 IAVO.1  IAYR.1
                                                                 IFBA.1  IFBC.1
                                                                 IFBO.1  IFBS.1
                                                                 POAB.1  POAM.1
                                                                 POAO.1  POAP.1
                                                                 SACU.1  SALO.1
                                                                 SAMM.1  SAOR.1
                                                                 SASC.1  SATE.1
                                                                 WOME.1  WOOR.1
                                                                 WOPR.1  WOSC.1

DLT-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  AMAS.1
                       name can contain up to 50 alphanumeric    AMBK.1  AMCV.1
                       characters. For example, you might name   AMLF.1  AMMD.1
                       a dimension Fiscal Year or Organization.  AMME.1  AMPD.1
                                                                 AMYR.1  GLBA.1
                                                                 GLBD.1  GLBP.1
                                                                 GLBT.1  GLBY.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  IATM.1
                                                                 IAVO.1  IAYR.1
                                                                 IFBA.1  IFBC.1
                                                                 IFBO.1  IFBS.1
                                                                 POAB.1  POAM.1
                                                                 POAO.1  POAP.1
                                                                 SACU.1  SALO.1
                                                                 SAMM.1  SAOR.1
                                                                 SASC.1  SATE.1
                                                                 WOME.1  WOOR.1
                                                                 WOPR.1  WOSC.1

DLT-COLUMN-DESC        Alpha 50  (Lower Case)                    ACBA.1  ACBC.1
Element: Column Desc                                             ACBP.1  ACBR.1
                                                                 ACBS.1  ACBU.1
                                                                 ACBY.1  AMAS.1
                                                                 AMBK.1  AMCV.1
                                                                 AMLF.1  AMMD.1
                                                                 AMME.1  AMPD.1
                                                                 AMYR.1  GLBA.1
                                                                 GLBD.1  GLBP.1
                                                                 GLBT.1  GLBY.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  IATM.1
                                                                 IAVO.1  IAYR.1
                                                                 IFBA.1  IFBC.1
                                                                 IFBO.1  IFBS.1
                                                                 POAB.1  POAM.1
                                                                 POAO.1  POAP.1
                                                                 SACU.1  SALO.1
                                                                 SAMM.1  SAOR.1
                                                                 SASC.1  SATE.1
                                                                 WOME.1  WOOR.1
                                                                 WOPR.1  WOSC.1

DLT-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  AMAS.1
                                                                 AMBK.1  AMCV.1
                                                                 AMLF.1  AMMD.1
                                                                 AMME.1  AMPD.1
                                                                 AMYR.1  GLBA.1
                                                                 GLBD.1  GLBP.1
                                                                 GLBT.1  GLBY.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  IATM.1
                                                                 IAVO.1  IAYR.1
                                                                 IFBA.1  IFBC.1
                                                                 IFBO.1  IFBS.1
                                                                 POAB.1  POAM.1
                                                                 POAO.1  POAP.1
                                                                 SACU.1  SALO.1
                                                                 SAMM.1  SAOR.1
                                                                 SASC.1  SATE.1
                                                                 WOME.1  WOOR.1
                                                                 WOPR.1  WOSC.1

                         IAFILEDLT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

DLTSET1   DATA-MART-NAMEKeyChange                                ACBA.1  ACBC.1
          USER-DIM-NAME                                          ACBP.1  ACBR.1
          COLUMN-DESC                                            ACBS.1  ACBU.1
                                                                 ACBY.1  AMAS.1
                                                                 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
                                                                 ...

DLTSET2   DATA-MART-NAME
          USER-DIM-NAME
          LAW-COL-NAME