|
|
ICDICT FILE
Item/Item Location Dictionary
The Item/Item Location Dictionary file is a file of all Item Master and Item
Location fields that can be selected for user-defined item maintenance and
inquiry formats. Initially, IC180 (Dictionary Setup) must be run once to load
this file.
REFERENCED BY
IC00.1 IC01.1 IC11.1 IC12.1 IC330
UPDATED BY
IC180
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
IDI-FLD-NBR Numeric 4 IC180
Element: Fld Nbr This field contains a unique number
assigned to the field.
IDI-FLD-NAME Alpha 15 IC180
Element: Fld Name This field contains the database field
name.
IDI-DB-FILE Alpha 3 IC180
Element: Db File This field identifies the file related
to the field name.
ITE = Item Master File (ITEMMAST)
ITL = Item Location File (ITEMLOC)
IDI-PROMPT Alpha 20 IC180
Element: Prompt This field contains the name for the
field that displays on forms or prints
on reports identifying the field.
IDI-DATA-TYPE Alpha 1 IC180
Element: Data Type This field indicates whether the field
is alphanumeric or numeric.
A = Alpha
N = Numeric
IDI-SIZE Numeric 2 IC180
Element: Size This field contains the size of the
database field.
IDI-DECIMALS Numeric 1 IC180
Element: Decimals This field contains the number of
decimals in the database field.
IDI-REQUIRED-FL Alpha 1 IC180
Element: All Flag This field indicates whether the
database field is required.
N = No
Y = Yes
ICDICT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
IDISET1 FLD-NBR IC00.1 IC01.1
IC11.1 IC12.1
IC180 IC330
IDISET2 FLD-NBR Subset
Where (FLD-NBR > Zeroes
And FLD-NBR <= 196 )
Or (FLD-NBR >= 515
And FLD-NBR <= 603 )
|
