Lawson - Lawson Software Technical Library - Data File Text for IAFILEDEF

IAFILEDEF
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
Element: Data Mart Name Alpha 20 (Lower Case)
This field contains the name of the data mart.

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

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
Element: User Dim Name Alpha 50 (Lower Case)
The User Dimension Name is the name associated with the dimension in the data mart outline. This user-defined name can contain up to 50 alphanumeric characters. For example, you might name a dimension Fiscal Year or Organization.

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

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
Element: Level Nbr Numeric 3

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

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
Element: Column Cat Alpha 1

L = Level Column
P = Property Column
I = ID Column
S = Sort Order Column
M = Measure Column
U = Unary Operator Column

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

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
Element: Column Desc Alpha 50 (Lower Case)

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

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
Element: Column Size Numeric 3

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

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
Element: Column Attr Alpha 1

I = Int
V = Varchar
N = Numeric

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

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
Element: Column Decimal Numeric 2

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

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
Element: Law Col Name Alpha 50 (Lower Case)

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

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
Element: Created Gen Alpha 1

Y
N

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

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
Element: Key Indicator Alpha 1

N = No
Y = Yes

IAFILEDEF FILE INDEX

NAME

KEY FIELDS

DESCRIPTION / SUBSET CONDITION

USED IN

IFISET1

USER-DIM-NAME
DATA-MART-NAME
LEVEL-NBR
COLUMN-CAT
COLUMN-DESC

KeyChange

...

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	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
DATA-MART-NAME
COLUMN-DESC

KeyChange

...

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

IFISET3

USER-DIM-NAME
LEVEL-NBR
COLUMN-CAT
COLUMN-DESC

KeyChange, Subset
Where		USER-DIM-NAME	!=	Spaces

IFISET4

DATA-MART-NAME
LEVEL-NBR
COLUMN-CAT
COLUMN-DESC

KeyChange, Subset
Where		DATA-MART-NAME	!=	Spaces

ACDL.1	AMDL.1
CBOP.1	HCDL.1
HCHP.1	IA150
IANM.1	GLOP.1
POA3.1

IFISET5

USER-DIM-NAME
DATA-MART-NAME
LEVEL-NBR
COLUMN-CAT
LAW-COL-NAME

KeyChange

IFISET6

DATA-MART-NAME
USER-DIM-NAME
COLUMN-CAT
LAW-COL-NAME

KeyChange

IFISET7

DATA-MART-NAME
USER-DIM-NAME
COLUMN-CAT
LEVEL-NBR
COLUMN-DESC

KeyChange

File created: Thu Jun 09 02:18:03 2016

Home
Contact Us

All trademarks and registered trademarks are the property of their respective owners.