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 IC10.1 IC10.2 IC11.1 IC12.1
IC191 IC192 IC290 IC330 IC35.1 IC36.1
UPDATED BY
IC180
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
IDI-FLD-NBR Numeric 4 IC180
Dictionary Field This field contains a unique number
Number assigned to the field.
IDI-FLD-NAME Alpha 15 IC180
Dictionary Field This field contains the database field
Name name.
IDI-DB-FILE Alpha 3 IC180
Data Base File This field identifies the file related
Prefix to the field name.
ITE = Item Master File (ITEMMAST)
ITL = Item Location File (ITEMLOC)
IDI-PROMPT Alpha 20 IC180
Prompt Name for a This field contains the name for the
Field field that displays on forms or prints
on reports identifying the field.
IDI-DATA-TYPE Alpha 1 IC180
Data Type This field indicates whether the field
is alphanumeric or numeric.
A = Alpha
N = Numeric
IDI-SIZE Numeric 2 IC180
Size This field contains the size of the
database field.
IDI-DECIMALS Numeric 1 IC180
Number of Decimals This field contains the number of
decimals in the database field.
IDI-REQUIRED-FL Alpha 1 IC180
Required 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
IC10.1 IC10.2
IC11.1 IC12.1
IC180 IC191
IC192 IC290
IC330 IC35.1
IC36.1
IDISET2 FLD-NBR Subset
Where (FLD-NBR > Zeroes
And FLD-NBR <= 196 )
Or (FLD-NBR >= 515
And FLD-NBR <= 603 )
|
