 |
Lawson Insight Technical Documentation |
|
IAFILEDEF FILE
UPDATED BY
ACBA.1 ACBC.1 ACBP.1 ACBR.1 ACBS.1 ACBU.1
ACBY.1 ACDL.1 AMAS.1 AMBK.1 AMCV.1 AMDL.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 HCOP.1 HCOP.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 GLOP.1 IFBA.1 IFBC.1
IFBO.1 IFBS.1 POA3.1 POAB.1 POAM.1 POAO.1
POAP.1 POAV.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
IFI-DATA-MART-NAME Alpha 20 (Lower Case) ACBA.1 ACBC.1
Data Mart Name ACBP.1 ACBR.1
ACBS.1 ACBU.1
ACBY.1 ACDL.1
AMAS.1 AMBK.1
AMCV.1 AMDL.1
AMLF.1 AMMD.1
AMME.1 AMPD.1
AMYR.1 GLBA.1
GLBD.1 GLBP.1
GLBT.1 GLBY.1
GLOP.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 HCOP.1
HCOP.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
POA3.1 POAB.1
POAM.1 POAO.1
...
IFI-USER-DIM-NAME Alpha 50 (Lower Case) ACBA.1 ACBC.1
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 ACDL.1
name can contain up to 50 alphanumeric AMAS.1 AMBK.1
characters. For example, you might name AMCV.1 AMDL.1
a dimension Fiscal Year or Organization. AMLF.1 AMMD.1
AMME.1 AMPD.1
AMYR.1 GLBA.1
GLBD.1 GLBP.1
GLBT.1 GLBY.1
GLOP.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 HCOP.1
HCOP.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
POA3.1 POAB.1
POAM.1 POAO.1
...
IFI-LEVEL-NBR Numeric 3 ACBA.1 ACBC.1
Level Nbr ACBP.1 ACBR.1
ACBS.1 ACBU.1
ACBY.1 ACDL.1
AMAS.1 AMBK.1
AMCV.1 AMDL.1
AMLF.1 AMMD.1
AMME.1 AMPD.1
AMYR.1 GLBA.1
GLBD.1 GLBP.1
GLBT.1 GLBY.1
GLOP.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 HCOP.1
HCOP.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
POA3.1 POAB.1
POAM.1 POAO.1
...
IFI-COLUMN-CAT Alpha 1 ACBA.1 ACBC.1
Column Cat L = Level Column ACBP.1 ACBR.1
P = Property Column ACBS.1 ACBU.1
I = ID Column ACBY.1 ACDL.1
S = Sort Order Column AMAS.1 AMBK.1
M = Measure Column AMCV.1 AMDL.1
U = Unary Operator Column AMLF.1 AMMD.1
AMME.1 AMPD.1
AMYR.1 GLBA.1
GLBD.1 GLBP.1
GLBT.1 GLBY.1
GLOP.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 HCOP.1
HCOP.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
POA3.1 POAB.1
POAM.1 POAO.1
...
IFI-COLUMN-DESC Alpha 50 (Lower Case) ACBA.1 ACBC.1
Column Desc ACBP.1 ACBR.1
ACBS.1 ACBU.1
ACBY.1 ACDL.1
AMAS.1 AMBK.1
AMCV.1 AMDL.1
AMLF.1 AMMD.1
AMME.1 AMPD.1
AMYR.1 GLBA.1
GLBD.1 GLBP.1
GLBT.1 GLBY.1
GLOP.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 HCOP.1
HCOP.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
POA3.1 POAB.1
POAM.1 POAO.1
...
IFI-COLUMN-SIZE Numeric 3 ACBA.1 ACBC.1
Column Size ACBP.1 ACBR.1
ACBS.1 ACBU.1
ACBY.1 ACDL.1
AMAS.1 AMBK.1
AMCV.1 AMDL.1
AMLF.1 AMMD.1
AMME.1 AMPD.1
AMYR.1 GLBA.1
GLBD.1 GLBP.1
GLBT.1 GLBY.1
GLOP.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 HCOP.1
HCOP.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
POA3.1 POAB.1
POAM.1 POAO.1
...
IFI-COLUMN-ATTR Alpha 1 ACBA.1 ACBC.1
Column Attr I = Int ACBP.1 ACBR.1
V = Varchar ACBS.1 ACBU.1
N = Numeric ACBY.1 ACDL.1
AMAS.1 AMBK.1
AMCV.1 AMDL.1
AMLF.1 AMMD.1
AMME.1 AMPD.1
AMYR.1 GLBA.1
GLBD.1 GLBP.1
GLBT.1 GLBY.1
GLOP.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 HCOP.1
HCOP.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
POA3.1 POAB.1
POAM.1 POAO.1
...
IFI-COLUMN-DECIMAL Numeric 2 ACBA.1 ACBC.1
Column Decimal ACBP.1 ACBR.1
ACBS.1 ACBU.1
ACBY.1 ACDL.1
AMAS.1 AMBK.1
AMCV.1 AMDL.1
AMLF.1 AMMD.1
AMME.1 AMPD.1
AMYR.1 GLBA.1
GLBD.1 GLBP.1
GLBT.1 GLBY.1
GLOP.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 HCOP.1
HCOP.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
POA3.1 POAB.1
POAM.1 POAO.1
...
IFI-LAW-COL-NAME Alpha 50 (Lower Case) ACBA.1 ACBC.1
Law Col Name ACBP.1 ACBR.1
ACBS.1 ACBU.1
ACBY.1 ACDL.1
AMAS.1 AMBK.1
AMCV.1 AMDL.1
AMLF.1 AMMD.1
AMME.1 AMPD.1
AMYR.1 GLBA.1
GLBD.1 GLBP.1
GLBT.1 GLBY.1
GLOP.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 HCOP.1
HCOP.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
POA3.1 POAB.1
POAM.1 POAO.1
...
IFI-CREATED-GEN Alpha 1 ACBA.1 ACBC.1
Created Gen Y ACBP.1 ACBR.1
N ACBS.1 ACBU.1
ACBY.1 ACDL.1
AMAS.1 AMBK.1
AMCV.1 AMDL.1
AMLF.1 AMMD.1
AMME.1 AMPD.1
AMYR.1 GLBA.1
GLBD.1 GLBP.1
GLBT.1 GLBY.1
GLOP.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 HCOP.1
HCOP.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
POA3.1 POAB.1
POAM.1 POAO.1
...
IFI-KEY-INDICATOR Alpha 1
Key Indicator N = No
Y = Yes
IAFILEDEF FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
IFISET1 USER-DIM-NAME KeyChange ACBA.1 ACBC.1
DATA-MART-NAME ACBP.1 ACBR.1
LEVEL-NBR ACBS.1 ACBU.1
COLUMN-CAT ACBY.1 AMAS.1
COLUMN-DESC 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
...
IFISET2 USER-DIM-NAME KeyChange ACBA.1 ACBC.1
DATA-MART-NAME ACBP.1 ACBR.1
COLUMN-DESC ACBS.1 ACBU.1
ACBY.1 ACDL.1
AMAS.1 AMBK.1
AMCV.1 AMDL.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
...
IFISET3 USER-DIM-NAME KeyChange, Subset
LEVEL-NBR Where USER-DIM-NAME != Spaces
COLUMN-CAT
COLUMN-DESC
IFISET4 DATA-MART-NAMEKeyChange, Subset ACDL.1 AMDL.1
LEVEL-NBR Where DATA-MART-NAME != Spaces HCOP.1 HCOP.2
COLUMN-CAT GLOP.1 POA3.1
COLUMN-DESC
IFISET5 USER-DIM-NAME KeyChange
DATA-MART-NAME
LEVEL-NBR
COLUMN-CAT
LAW-COL-NAME
IFISET6 DATA-MART-NAMEKeyChange IAAP.1
USER-DIM-NAME
COLUMN-CAT
LAW-COL-NAME
IFISET7 DATA-MART-NAMEKeyChange IAAP.1
USER-DIM-NAME
COLUMN-CAT
LEVEL-NBR
COLUMN-DESC
|