Lawson Insight Technical Documentation |
|
IAFILEDEF
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 HCAG.1
HCCP.1 HCDL.1 HCEM.1 HCHM.1 HCHP.1 HCJC.1
HCMS.1 HCPO.1 HCRV.1 HCSC.1 HCSU.1 HCYR.1
IA120 IA150 IAAP.1 IAMB.1 IANM.1 IATM.1
IAVO.1 IAYR.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 SACU.1
SALD.1 SALO.1 SAMM.1 SAOR.1 SASC.1 SATE.1
WODL.1 WOME.1 WOOR.1 WOPR.1 WOSC.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
IFI-DATA-MART-NAME Alpha 20 (Lower Case) ACBA.1 ACBC.1
Element: Data Mart NameThis field contains the name of the data ACBP.1 ACBR.1
mart. 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 HCAG.1
HCCP.1 HCDL.1
HCEM.1 HCHM.1
HCHP.1 HCJC.1
HCMS.1 HCPO.1
HCRV.1 HCSC.1
HCSU.1 HCYR.1
IA120 IA150
IAAP.1 IAMB.1
IANM.1 IATM.1
IAVO.1 IAYR.1
IFBA.1 IFBC.1
IFBO.1 IFBS.1
POA3.1 POAB.1
POAM.1 POAO.1
POAP.1 SACU.1
SALD.1 SALO.1
SAMM.1 SAOR.1
SASC.1 SATE.1
...
IFI-USER-DIM-NAME Alpha 50 (Lower Case) ACBA.1 ACBC.1
Element: 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 HCAG.1
HCCP.1 HCDL.1
HCEM.1 HCHM.1
HCHP.1 HCJC.1
HCMS.1 HCPO.1
HCRV.1 HCSC.1
HCSU.1 HCYR.1
IA120 IA150
IAAP.1 IAMB.1
IANM.1 IATM.1
IAVO.1 IAYR.1
IFBA.1 IFBC.1
IFBO.1 IFBS.1
POA3.1 POAB.1
POAM.1 POAO.1
POAP.1 SACU.1
SALD.1 SALO.1
SAMM.1 SAOR.1
SASC.1 SATE.1
...
IFI-LEVEL-NBR Numeric 3 ACBA.1 ACBC.1
Element: 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 HCAG.1
HCCP.1 HCDL.1
HCEM.1 HCHM.1
HCHP.1 HCJC.1
HCMS.1 HCPO.1
HCRV.1 HCSC.1
HCSU.1 HCYR.1
IA120 IA150
IAAP.1 IAMB.1
IANM.1 IATM.1
IAVO.1 IAYR.1
IFBA.1 IFBC.1
IFBO.1 IFBS.1
POA3.1 POAB.1
POAM.1 POAO.1
POAP.1 SACU.1
SALD.1 SALO.1
SAMM.1 SAOR.1
SASC.1 SATE.1
...
IFI-COLUMN-CAT Alpha 1 ACBA.1 ACBC.1
Element: 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 HCAG.1
HCCP.1 HCDL.1
HCEM.1 HCHM.1
HCHP.1 HCJC.1
HCMS.1 HCPO.1
HCRV.1 HCSC.1
HCSU.1 HCYR.1
IA120 IA150
IAAP.1 IAMB.1
IANM.1 IATM.1
IAVO.1 IAYR.1
IFBA.1 IFBC.1
IFBO.1 IFBS.1
POA3.1 POAB.1
POAM.1 POAO.1
POAP.1 SACU.1
SALD.1 SALO.1
SAMM.1 SAOR.1
SASC.1 SATE.1
...
IFI-COLUMN-DESC Alpha 50 (Lower Case) ACBA.1 ACBC.1
Element: 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 HCAG.1
HCCP.1 HCDL.1
HCEM.1 HCHM.1
HCHP.1 HCJC.1
HCMS.1 HCPO.1
HCRV.1 HCSC.1
HCSU.1 HCYR.1
IA120 IA150
IAAP.1 IAMB.1
IANM.1 IATM.1
IAVO.1 IAYR.1
IFBA.1 IFBC.1
IFBO.1 IFBS.1
POA3.1 POAB.1
POAM.1 POAO.1
POAP.1 SACU.1
SALD.1 SALO.1
SAMM.1 SAOR.1
SASC.1 SATE.1
...
IFI-COLUMN-SIZE Numeric 3 ACBA.1 ACBC.1
Element: 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 HCAG.1
HCCP.1 HCDL.1
HCEM.1 HCHM.1
HCHP.1 HCJC.1
HCMS.1 HCPO.1
HCRV.1 HCSC.1
HCSU.1 HCYR.1
IA120 IA150
IAAP.1 IAMB.1
IANM.1 IATM.1
IAVO.1 IAYR.1
IFBA.1 IFBC.1
IFBO.1 IFBS.1
POA3.1 POAB.1
POAM.1 POAO.1
POAP.1 SACU.1
SALD.1 SALO.1
SAMM.1 SAOR.1
SASC.1 SATE.1
...
IFI-COLUMN-ATTR Alpha 1 ACBA.1 ACBC.1
Element: 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 HCAG.1
HCCP.1 HCDL.1
HCEM.1 HCHM.1
HCHP.1 HCJC.1
HCMS.1 HCPO.1
HCRV.1 HCSC.1
HCSU.1 HCYR.1
IA120 IA150
IAAP.1 IAMB.1
IANM.1 IATM.1
IAVO.1 IAYR.1
IFBA.1 IFBC.1
IFBO.1 IFBS.1
POA3.1 POAB.1
POAM.1 POAO.1
POAP.1 SACU.1
SALD.1 SALO.1
SAMM.1 SAOR.1
SASC.1 SATE.1
...
IFI-COLUMN-DECIMAL Numeric 2 ACBA.1 ACBC.1
Element: 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 HCAG.1
HCCP.1 HCDL.1
HCEM.1 HCHM.1
HCHP.1 HCJC.1
HCMS.1 HCPO.1
HCRV.1 HCSC.1
HCSU.1 HCYR.1
IA120 IA150
IAAP.1 IAMB.1
IANM.1 IATM.1
IAVO.1 IAYR.1
IFBA.1 IFBC.1
IFBO.1 IFBS.1
POA3.1 POAB.1
POAM.1 POAO.1
POAP.1 SACU.1
SALD.1 SALO.1
SAMM.1 SAOR.1
SASC.1 SATE.1
...
IFI-LAW-COL-NAME Alpha 50 (Lower Case) ACBA.1 ACBC.1
Element: 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 HCAG.1
HCCP.1 HCDL.1
HCEM.1 HCHM.1
HCHP.1 HCJC.1
HCMS.1 HCPO.1
HCRV.1 HCSC.1
HCSU.1 HCYR.1
IA120 IA150
IAAP.1 IAMB.1
IANM.1 IATM.1
IAVO.1 IAYR.1
IFBA.1 IFBC.1
IFBO.1 IFBS.1
POA3.1 POAB.1
POAM.1 POAO.1
POAP.1 SACU.1
SALD.1 SALO.1
SAMM.1 SAOR.1
SASC.1 SATE.1
...
IFI-CREATED-GEN Alpha 1 ACBA.1 ACBC.1
Element: 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 HCAG.1
HCCP.1 HCDL.1
HCEM.1 HCHM.1
HCHP.1 HCJC.1
HCMS.1 HCPO.1
HCRV.1 HCSC.1
HCSU.1 HCYR.1
IA120 IA150
IAAP.1 IAMB.1
IANM.1 IATM.1
IAVO.1 IAYR.1
IFBA.1 IFBC.1
IFBO.1 IFBS.1
POA3.1 POAB.1
POAM.1 POAO.1
POAP.1 SACU.1
SALD.1 SALO.1
SAMM.1 SAOR.1
SASC.1 SATE.1
...
IFI-KEY-INDICATOR Alpha 1
Element: 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 HCAG.1
HCCP.1 HCEM.1
HCHM.1 HCJC.1
HCMS.1 HCPO.1
HCRV.1 HCSC.1
HCSU.1 HCYR.1
IA120 IA150
IAAP.1 IAMB.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 HCAG.1
HCCP.1 HCDL.1
HCEM.1 HCHM.1
HCHP.1 HCJC.1
HCMS.1 HCPO.1
HCRV.1 HCSC.1
HCSU.1 HCYR.1
...
IFISET3 USER-DIM-NAME KeyChange, Subset IANM.1
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 HCDL.1 HCHP.1
COLUMN-CAT IA150 IANM.1
COLUMN-DESC GLOP.1 POA3.1
SALD.1 WODL.1
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
|