Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

IADRILL


                              IADRILL FILE

REFERENCED BY

IASD.1

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

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

IDR-DIM-OBJ-ID         Numeric 12                                ACBA.1  ACBC.1
Element: 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
                                                                 HCAG.1  HCCP.1
                                                                 HCEM.1  HCHM.1
                                                                 HCJC.1  HCMS.1
                                                                 HCPO.1  HCRV.1
                                                                 HCSC.1  HCSU.1
                                                                 HCYR.1  IA120
                                                                 IA150   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

IDR-DATA-TARGET        Alpha 1                                   ACBA.1  ACBC.1
Element: 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
                                                                 HCAG.1  HCCP.1
                                                                 HCEM.1  HCHM.1
                                                                 HCJC.1  HCMS.1
                                                                 HCPO.1  HCRV.1
                                                                 HCSC.1  HCSU.1
                                                                 HCYR.1  IA120
                                                                 IA150   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

IDR-MBR-OBJ-ID         Numeric 12                                ACBA.1  ACBC.1
Element: 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
                                                                 HCAG.1  HCCP.1
                                                                 HCEM.1  HCHM.1
                                                                 HCJC.1  HCMS.1
                                                                 HCPO.1  HCRV.1
                                                                 HCSC.1  HCSU.1
                                                                 HCYR.1  IA120
                                                                 IA150   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

IDR-META-ID            Numeric 9                                 ACBA.1  ACBC.1
Element: 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
                                                                 HCAG.1  HCCP.1
                                                                 HCEM.1  HCHM.1
                                                                 HCJC.1  HCMS.1
                                                                 HCPO.1  HCRV.1
                                                                 HCSC.1  HCSU.1
                                                                 HCYR.1  IA120
                                                                 IA150   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

IDR-DRILL-FILE         Alpha 10                                  ACBA.1  ACBC.1
Element: 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
                                                                 HCAG.1  HCCP.1
                                                                 HCEM.1  HCHM.1
                                                                 HCJC.1  HCMS.1
                                                                 HCPO.1  HCRV.1
                                                                 HCSC.1  HCSU.1
                                                                 HCYR.1  IA120
                                                                 IA150   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

IDR-DRILL-INDEX        Alpha 10                                  ACBA.1  ACBC.1
Element: 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
                                                                 HCAG.1  HCCP.1
                                                                 HCEM.1  HCHM.1
                                                                 HCJC.1  HCMS.1
                                                                 HCPO.1  HCRV.1
                                                                 HCSC.1  HCSU.1
                                                                 HCYR.1  IA120
                                                                 IA150   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

IDR-DRILL-KEYS         Alpha 120  (Lower Case)                   ACBA.1  ACBC.1
Element: 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
                                                                 HCAG.1  HCCP.1
                                                                 HCEM.1  HCHM.1
                                                                 HCJC.1  HCMS.1
                                                                 HCPO.1  HCRV.1
                                                                 HCSC.1  HCSU.1
                                                                 HCYR.1  IA120
                                                                 IA150   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

                         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  HCAG.1
                                                                 HCCP.1  HCEM.1
                                                                 HCHM.1  HCJC.1
                                                                 HCMS.1  HCPO.1
                                                                 HCRV.1  HCSC.1
                                                                 HCSU.1  HCYR.1
                                                                 IA120   IA150
                                                                 IAMB.1  IASD.1
                                                                 ...

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