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    HCAC.1    HCAG.1    HCCL.1
HCCP.1    HCEC.1    HCEM.1    HCEO.1    HCEX.1    HCGL.1
HCGN.1    HCJC.1    HCLO.1    HCMS.1    HCMS.2    HCPL.1
HCPO.1    HCRV.1    HCSC.1    HCSH.1    HCST.1    HCSU.1
HCTM.1    HCUF.1    HCUL.1    HCUN.1    HCYR.1    IAAP.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    POAV.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 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
                                                                 HCAC.1  HCAG.1
                                                                 HCCL.1  HCCP.1
                                                                 HCEC.1  HCEM.1
                                                                 HCEO.1  HCEX.1
                                                                 HCGL.1  HCGN.1
                                                                 HCJC.1  HCLO.1
                                                                 HCMS.1  HCMS.2
                                                                 HCPL.1  HCPO.1
                                                                 HCRV.1  HCSC.1
                                                                 HCSH.1  HCST.1
                                                                 HCSU.1  HCTM.1
                                                                 HCUF.1  HCUL.1
                                                                 HCUN.1  HCYR.1
                                                                 IAAP.1  IFBA.1
                                                                 IFBC.1  IFBO.1
                                                                 IFBS.1  POAB.1
                                                                 POAM.1  POAO.1
                                                                 POAP.1  POAV.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
                                                                 HCAC.1  HCAG.1
                                                                 HCCL.1  HCCP.1
                                                                 HCEC.1  HCEM.1
                                                                 HCEO.1  HCEX.1
                                                                 HCGL.1  HCGN.1
                                                                 HCJC.1  HCLO.1
                                                                 HCMS.1  HCMS.2
                                                                 HCPL.1  HCPO.1
                                                                 HCRV.1  HCSC.1
                                                                 HCSH.1  HCST.1
                                                                 HCSU.1  HCTM.1
                                                                 HCUF.1  HCUL.1
                                                                 HCUN.1  HCYR.1
                                                                 IAAP.1  IFBA.1
                                                                 IFBC.1  IFBO.1
                                                                 IFBS.1  POAB.1
                                                                 POAM.1  POAO.1
                                                                 POAP.1  POAV.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
                                                                 HCAC.1  HCAG.1
                                                                 HCCL.1  HCCP.1
                                                                 HCEC.1  HCEM.1
                                                                 HCEO.1  HCEX.1
                                                                 HCGL.1  HCGN.1
                                                                 HCJC.1  HCLO.1
                                                                 HCMS.1  HCMS.2
                                                                 HCPL.1  HCPO.1
                                                                 HCRV.1  HCSC.1
                                                                 HCSH.1  HCST.1
                                                                 HCSU.1  HCTM.1
                                                                 HCUF.1  HCUL.1
                                                                 HCUN.1  HCYR.1
                                                                 IAAP.1  IFBA.1
                                                                 IFBC.1  IFBO.1
                                                                 IFBS.1  POAB.1
                                                                 POAM.1  POAO.1
                                                                 POAP.1  POAV.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
                                                                 HCAC.1  HCAG.1
                                                                 HCCL.1  HCCP.1
                                                                 HCEC.1  HCEM.1
                                                                 HCEO.1  HCEX.1
                                                                 HCGL.1  HCGN.1
                                                                 HCJC.1  HCLO.1
                                                                 HCMS.1  HCMS.2
                                                                 HCPL.1  HCPO.1
                                                                 HCRV.1  HCSC.1
                                                                 HCSH.1  HCST.1
                                                                 HCSU.1  HCTM.1
                                                                 HCUF.1  HCUL.1
                                                                 HCUN.1  HCYR.1
                                                                 IAAP.1  IFBA.1
                                                                 IFBC.1  IFBO.1
                                                                 IFBS.1  POAB.1
                                                                 POAM.1  POAO.1
                                                                 POAP.1  POAV.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  HCAC.1
                                                                 HCAG.1  HCCL.1
                                                                 HCCP.1  HCEC.1
                                                                 HCEM.1  HCEO.1
                                                                 HCEX.1  HCGL.1
                                                                 HCGN.1  HCJC.1
                                                                 HCLO.1  HCMS.1
                                                                 HCMS.2  HCPL.1
                                                                 ...

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