Lawson Insight Technical Documentation |
|
IADRILL
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 WOME.1 WOOR.1 WOPR.1 WOSC.1
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
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 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
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 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
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 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
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 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
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 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
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 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
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 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 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
|