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 CBBB.1
CBBC.1 CBBD.1 CBBO.1 CBBR.1 CBBT.1 CBOP.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
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 CBBB.1
CBBC.1 CBBD.1
CBBO.1 CBBR.1
CBBT.1 CBOP.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
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 CBBB.1
CBBC.1 CBBD.1
CBBO.1 CBBR.1
CBBT.1 CBOP.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
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 CBBB.1
CBBC.1 CBBD.1
CBBO.1 CBBR.1
CBBT.1 CBOP.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
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 CBBB.1
CBBC.1 CBBD.1
CBBO.1 CBBR.1
CBBT.1 CBOP.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
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 CBBB.1
CBBC.1 CBBD.1
CBBO.1 CBBR.1
CBBT.1 CBOP.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
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 CBBB.1
CBBC.1 CBBD.1
CBBO.1 CBBR.1
CBBT.1 CBOP.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
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 CBBB.1
CBBC.1 CBBD.1
CBBO.1 CBBR.1
CBBT.1 CBOP.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
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 CBBB.1
CBBC.1 CBBD.1
CBBO.1 CBBR.1
CBBT.1 CBOP.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
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 CBBB.1
CBBC.1 CBBD.1
CBBO.1 CBBR.1
CBBT.1 CBOP.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
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 CBBB.1
CBBC.1 CBBD.1
CBBO.1 CBBR.1
CBBT.1 CBOP.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
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 CBBB.1
CBBC.1 CBBD.1
CBBO.1 CBBR.1
CBBT.1 HCAG.1
HCCP.1 HCEM.1
HCHM.1 HCJC.1
HCMS.1 HCPO.1
HCRV.1 HCSC.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 CBBB.1
CBBC.1 CBBD.1
CBBO.1 CBBR.1
CBBT.1 CBOP.1
HCAG.1 HCCP.1
HCDL.1 HCEM.1
HCHM.1 HCHP.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 CBOP.1 HCDL.1
COLUMN-CAT HCHP.1 IA150
COLUMN-DESC IANM.1 GLOP.1
POA3.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
|