Lawson Insight Technical Documentation |
|
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
|