Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                              IADRILL 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    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

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

IDR-DIM-OBJ-ID       Numeric 12                                  ACBA.1  ACBC.1
Dim Obj Id           The Dimension Object Identifier field       ACBP.1  ACBR.1
                     contains a unique numeric identifier        ACBS.1  ACBU.1
                     assigned to the dimension, which            ACBY.1  AMAS.1
                     associates this record to the member        AMBK.1  AMCV.1
                     records.                                    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
                                                                 IFBA.1  IFBC.1
                                                                 IFBO.1  IFBS.1
                                                                 POAB.1  POAM.1
                                                                 POAO.1  POAP.1
                                                                 POAV.1

IDR-DATA-TARGET      Alpha 1                                     ACBA.1  ACBC.1
Data Target                                                      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
                                                                 IFBA.1  IFBC.1
                                                                 IFBO.1  IFBS.1
                                                                 POAB.1  POAM.1
                                                                 POAO.1  POAP.1
                                                                 POAV.1

IDR-MBR-OBJ-ID       Numeric 12                                  ACBA.1  ACBC.1
Mbr Obj Id           The Member Object Identifier field          ACBP.1  ACBR.1
                     contains a unique numeric identifier        ACBS.1  ACBU.1
                     assigned to a member, which associates      ACBY.1  AMAS.1
                     this record to the appropriate MEMBER       AMBK.1  AMCV.1
                     file record.                                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
                                                                 IFBA.1  IFBC.1
                                                                 IFBO.1  IFBS.1
                                                                 POAB.1  POAM.1
                                                                 POAO.1  POAP.1
                                                                 POAV.1

IDR-META-ID          Numeric 9                                   ACBA.1  ACBC.1
Meta Id                                                          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
                                                                 IFBA.1  IFBC.1
                                                                 IFBO.1  IFBS.1
                                                                 POAB.1  POAM.1
                                                                 POAO.1  POAP.1
                                                                 POAV.1

IDR-DRILL-FILE       Alpha 10                                    ACBA.1  ACBC.1
Drill File                                                       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
                                                                 IFBA.1  IFBC.1
                                                                 IFBO.1  IFBS.1
                                                                 POAB.1  POAM.1
                                                                 POAO.1  POAP.1
                                                                 POAV.1

IDR-DRILL-INDEX      Alpha 10                                    ACBA.1  ACBC.1
Drill Index                                                      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
                                                                 IFBA.1  IFBC.1
                                                                 IFBO.1  IFBS.1
                                                                 POAB.1  POAM.1
                                                                 POAO.1  POAP.1
                                                                 POAV.1

IDR-DRILL-KEYS       Alpha 120  (Lower Case)                     ACBA.1  ACBC.1
Drill Keys                                                       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
                                                                 IFBA.1  IFBC.1
                                                                 IFBO.1  IFBS.1
                                                                 POAB.1  POAM.1
                                                                 POAO.1  POAP.1
                                                                 POAV.1

                         IADRILL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

IDRSET1   DIM-OBJ-ID    KeyChange                                ACBA.1  ACBC.1
          DATA-TARGET                                            ACBP.1  ACBR.1
          MBR-OBJ-ID                                             ACBS.1  ACBU.1
          META-ID                                                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
                                                                 ...

IDRSET2   MBR-OBJ-ID    KeyChange, Subset
          DIM-OBJ-ID    Where DATA-TARGET =  "1"
                        And   MBR-OBJ-ID  != Zeroes